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 G05DVD ,
May I ask for your help?
I tried to follow your way of doing that, but unfortunatelly not fully successful.
When I run it for any sticker, in this example ISAC.L there is following result
when checking the error:
How can I deal with that?
I found the problem. For me it was necessary to replace function:
Date.From(DateTimeZone.FromSecondsSinceEpoch([_]))
with
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0,0,0,_)