r-从纳斯达克网站下载csv文件



我尝试了一段时间,只是从网上下载RStudio中的csv文件(所以我使用R(。我以前做过这样的事情,从来没有遇到过现在的问题。尝试了网上建议的几种解决方案。我只是试着从这里下载以下文件https://www.nasdaq.com/market-activity/stocks/aapl/historical.这是指向csv->https://www.nasdaq.com/api/v1/historical/AAPL/stocks/2020-09-09/2020-10-09.我尝试了httr和RCurl包方法,但都不起作用。希望有人能帮我,提前谢谢。

编辑:到目前为止我尝试了什么:-更新的ssl-我可以安装新的软件包,这样互联网就可以正常工作-更新的git-更新的R-已更新所有程序包-尝试了这里的建议:下载.文件在RStudio 中失败

第二版:不久前,我用软件包RSelenium进行了网络清理,并启动了rem_session。Rselenium是否可能更改某些基本设置?

编辑3:完全卸载的Rstudio+R+Rtool手动删除了所有内容,重新安装后仍然存在相同的问题

您是否尝试过通过read.csv()直接在R中加载它?

它对我有用…看看:

data = read.csv('https://www.nasdaq.com/api/v1/historical/AAPL/stocks/2020-09-09/2020-10-09')
data

这是输出:

Date Close.Last    Volume     Open      High      Low
1  10/07/2020    $115.08  96848990  $114.62   $115.55  $114.13
2  10/06/2020    $113.16 161498200   $115.7   $116.12  $112.25
3  10/05/2020     $116.5 106243800  $113.91   $116.65  $113.55
4  10/02/2020    $113.02 144712000  $112.89   $115.37  $112.22
5  10/01/2020    $116.79 116120400  $117.64   $117.72  $115.83
6  09/30/2020    $115.81 142675200  $113.79   $117.26  $113.62
7  09/29/2020    $114.09 100060500  $114.55   $115.31  $113.57
8  09/28/2020    $114.96 137672400  $115.01   $115.32  $112.78
9  09/25/2020    $112.28 149981400  $108.43   $112.44  $107.67
10 09/24/2020    $108.22 167743300  $105.17   $110.25     $105
11 09/23/2020    $107.12 150718700  $111.62   $112.11  $106.77
12 09/22/2020    $111.81 183055400  $112.68   $112.86  $109.16
13 09/21/2020    $110.08 195713800  $104.54   $110.19   $103.1
14 09/18/2020    $106.84 287104900   $110.4   $110.88  $106.09
15 09/17/2020    $110.34 178011000  $109.72    $112.2  $108.71
16 09/16/2020    $112.13 155026700  $115.23      $116  $112.04
17 09/15/2020    $115.54 184642000  $118.33  $118.829  $113.61
18 09/14/2020   $115.355 140150100  $114.72   $115.93   $112.8
19 09/11/2020       $112 180860300  $114.57   $115.23     $110
20 09/10/2020    $113.49 182274400  $120.36    $120.5   $112.5
21 09/09/2020    $117.32 176940500  $117.26   $119.14  $115.26

如果以后要将其保存为csv文件,只需运行write.csv():

write.csv(data, '~/Downloads/data.csv')

如果它对你有效,请告诉我。

如果您在windows操作系统中,则需要设置mode=wb参数。

download.file(
"https://www.nasdaq.com/api/v1/historical/AAPL/stocks/2020-09-09/2020-10-09",
"file.csv", mode='wb'
)

最新更新