Forum Discussion
Yahoo Finance Power Query Link Not Working
Hello, I have a spreadsheet which downloads daily currency rates from Yahoo Finance using PowerQuery, for example... = Csv.Document(Web.Contents("https://query1.finance.yahoo.com/v7/finance/down...
This URL will give the same data, but the response is formatted in JSON:
Hello,
Many thanks for your responses, it's much appreciated.
I've never used JSON... I tried the url in PowerQuery, but it's not clear what to do with it. What are the steps to get this into just a data table?
Also, my end date is (was) dynamic, i.e. previously, my query would search Yahoo Finance for today's date minus 1 day and return the data. How does one incorporate that into the query?