Forum Discussion
Power Query returns only 100 rows
Hello, I'm trying to download historical stock price data from Yahoo! Finance using the Power Query tool however, it only ever shows me the first 100 rows. Has anyone else encountered this probl...
Taking a different approach you can get what you want, until Yahoo changes something...:
1 - Use URL like: "https://query1.finance.yahoo.com/v7/finance/chart/CARR?range=1y&interval=1d&indicators=quote&includeTimestamps=true"
2 - Convert the binary as a Json
3 - Parse the Json - it's not a complex one :))
The most interesting part was to figure out that the timetamps are actually Unix sec. since Jan 1st 1970
Sample attached with function ParseYahooFinanceBin that does 2 & 3
Before any question :)) please read the comments in the 2 ex. queries and the function
EDIT: Forgot to say that the approach is avail. https://www.stock-data-solutions.com/kb/how-to-load-historical-prices-from-yahoo-finance-to-csv.htm