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...
Hi
I had exactly the same problem as you describe. I have found the solution by using the STOCKHISTORY function in Excel:
HTH
Nick
Thanks for your reply, Nick!
Unfortunately this only works with Office 365. I have a standalone version of EXCEL 2021 that doesn't support this function.