All geek questions in one place

Is YQL / datatables.org as of May 17-18, 2017?

Over the past 1-2 days, the HTTP request that I used to download historical stock prices from Yahoo Finance did not work. The link I use is the first, but I also tried the other three (as I saw other people using them):

http://real-chart.finance.yahoo.com/table.csv?s=TRQ&d=6&e=3&f=2016&g=d&a=5&b=25&c=2016&ignore=.csv
https://real-chart.finance.yahoo.com/table.csv?s=TRQ&d=6&e=3&f=2016&g=d&a=5&b=25&c=2016&ignore=.csv
http://ichart.finance.yahoo.com/table.csv?s=TRQ&d=6&e=3&f=2016&g=d&a=5&b=25&c=2016&ignore=.csv
https://ichart.finance.yahoo.com/table.csv?s=TRQ&d=6&e=3&f=2016&g=d&a=5&b=25&c=2016&ignore=.csv

Interestingly, I noticed that the link that the Yahoo site itself provides (for downloading data manually) has changed. The link was the first in the list above (in the end, where I got it from), but now it looks like this:

https://query1.finance.yahoo.com/v7/finance/download/TRQ?period1=1466805600&period2=1467496800&interval=1d&events=history&crumb=DuX0UxVwtN0

Please note that all of these links should theoretically extract the same data: stock prices for TRQ (as an example, I also tried, for example, AAPL) from 2016/06/25 to 2016/07/03.

These new links work in the browser or in my program, but they are hardly scalable since this requires a session cookie; if you simply do not specify the last request parameter, you will receive an error message when you are not authorized. This question asks how to create the specified session cookie in an automatic way; however, I want to ask about it, completely avoiding this problem, trying to get direct access to the YQL database.

I tried using the following link to directly use the YQL API (converting spaces to% 20 etc., which is not a problem):

https://query.yahooapis.com/v1/public/yql?q=
  select * from yahoo.finance.historicaldata where symbol = "TRQ" 
  and startDate = "2016-06-25" 
  and endDate = "2016-07-03"
 &format=json
 &diagnostics=true
 &env=store://datatables.org/alltableswithkeys
 &callback=

"connection failed". , , datatables.org ( ). - ?

.

+6
4

, . Quandl, , , . , ETF, VXUS VTI, .

+1

Yahoo " ", . , API Google, . , (excel VBA), . , , - 2019 - ​​ :

startdate = #3/15/2015#
StartingMonth = Format(startdate, "Mmm")
StartingDay = Format(startdate, "d")
StartingYear = Format(startdate, "yyyy")
startdate = StartingMonth & "+" & StartingDay & "%2C+" & StartingYear    
Symbol = "AAPL" 
ThisAddress = "http://www.google.com/finance/historical?q=" & _
            Symbol & "&startdate=" & startdate & "&enddate=Nov+1%2C+2019&output=csv"
Workbooks(ThisBook).FollowHyperlink Address:=ThisAddress
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:=Symbol, FileFormat:=xlCSV
+1

Yahoo , EOD . thread Nixon. Yahoo Verizon, .

, Yahoo, CSV , -. API "", cookie .

Python3, CSV, ( ) API. , GitHub yahoo_quote_download.

+1

Source: https://habr.com/ru/post/1017348/

More articles:


All Articles