雅虎财经历史数据下载器网址不起作用 [英] Yahoo Finance Historical data downloader url is not working
本文介绍了雅虎财经历史数据下载器网址不起作用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用以下网址从雅虎财经获取历史数据.从 2017 年 5 月 16 日起,该网址无效.
I have used the following url to fetch the historical data from yahoo finance. From last 16th May, 2017 the url is not working.
好像他们改变了网址,新网址是:
Seems like they have changed the url and the new url is:
在上面更改的 URL 中有一个会话 cookie,它是 crumb.知道如何以编程方式(在 JAVA 中)获取此 cookie 吗?
In the above changed URL has a session cookie which is crumb. Is there any idea how to get this cookie programmatically(in JAVA)?
推荐答案
开始工作,现在我只需要解析 csv.我想我会分享,因为我在语法上遇到了问题.
Got it to work, now I just have to parse the csv. Thought I'd share since I was having trouble with the syntax.
Dim crumb As String: crumb = "xxxx"
Dim cookie As String: cookie = "yyyy"
Dim urlStock As String: urlStock = "https://query1.finance.yahoo.com/v7/finance/download/SIRI?" & _
"period1=1274158800&" & _
"period2=1495059477&" & _
"interval=1d&events=history&crumb=" & crumb
Dim http As MSXML2.XMLHTTP: Set http = New MSXML2.ServerXMLHTTP
http.Open "GET", urlStock, False
http.setRequestHeader "Cookie", cookie
http.send
这篇关于雅虎财经历史数据下载器网址不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文