我尝试了一段时间,只是从网上下载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'
)