Forum Discussion
Yahoo Finance Power Query Link Not Working
Same thing happening to me. Looks like they either intentionally or inadvertantly put this behind a login today.
Hi Guys, Yahoo is on the case, I have been having this issue via Power BI and Power Shell since Friday (possibly Thursday) myself, so I reached out to them since I have a model which took me 1.5 years double full time to build and I was ready to pay for the data; apparently no need to, finger crossed since the market is hot at the moment...
Hi Marco,
Thanks for reaching out to Yahoo Finance.
I apologize for the inconvenience. I understand that you're experiencing issues with the feature to download historical data.
Please know our Engineering team is continuing to work to fix this known issue for you. We know it’s frustrating when things don't work and appreciate your patience while we correct the problem.
If you have any other questions or can provide further information regarding this issue, let us know by replying to this message.Best,
Lucas
Yahoo Customer CareHey that's really GREAT!!! 😀👍
I tried contacting them myself, but found out that they make it really hard to get in touch with their support (and it appeared as if you need to be a paying customer as well, but I might be mistaken).
Anyway, thanks to you we at least know that they are aware of the issue. Please keep us posted!!!Hi Guys, I have a lesser joyful update, but with most probably a happy ending.
You can see from the Yahoo email above that they were inviting to give more details on the case if possible, I reckoned to help them on the case. So I did. I gave them both forms that ceased working, with M query and Power Shell, here:
1)Source = Web.Contents(
"https://query1.finance.yahoo.com/v7/finance/download",
[
RelativePath=Symbol,
Query=
[
period1= DateDiff2SecLT, //"1711497601"
period2= DateDiff2SecUT, //"1711584001"
interval="1d"
],
]
)
2)
# ► Create $session Object
$session = New-Object Microsoft.PowerShell.Commands.WebRequestSession
# ► Call 3rd Url ( Get Yahoo's Data )
try {
$ResponseText = Invoke-WebRequest -UseBasicParsing -Uri $URL -WebSession $session
$ResponseText = $ResponseText.ToString()
}
And then I got this meaningless reply:
Hi Marco,
Thank you for writing us back.
I apologize for the inconvenience. It appears that the program you're using is not supported by Yahoo Finance because of this we can't provide additional assistance with your concern.
If you have some suggestions and feedback on ways to improve our product we would love to hear from you. Send us your feedback on the Yahoo Finance Feedback Forum. This feedback helps us develop the future versions of our app.If you have additional questions or concerns, please feel free to contact us again.
Best,
Lucas
Yahoo Customer CareI replied back again, asking:
Hi Lucas
I wrote you some details about the issue since you had asked, now I am not sure if you are working on the issue I have reported in the first message or not; you wrote me the issue I was signaling, and that everybody else seems to have, was known and you were working on it, are you?
From last saturday this query seems to ask for a user to be indicated instead of working with anonymous connection, as it has done for at least February 2023:"https://query2.finance.yahoo.com/v7/finance/download/" + $Stock + "?period1=1725321599&period2=1725667199&interval=1d"
Hence I asked if from now on it was necessary to have a bronze, silver or gold subscription, you told me it was a known issues you guys were working on, and soon to be solved, do I understand correctly?
Or?But got an auto reply message.This is the bad news. The good one is that as IT guys we know the sky is the limit, so I am working on a workaround, the prototype works, I got the data, as soon as I manage (hopefully) to integrate it in my great scheme of things I will post the full script. So annoying wasting time on the tech side when I should be here buying stocks!!
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?
Essentially you need to change the source in your query.
In Power BI Use Transform Data, select the relevant query then use the Advanced Editor. You will see Source = xxxx
Previously the table was contructed as CSV it now needs to be JSON so in my case the source is...
Source = Json.Document(Web.Contents("https://query1.finance.yahoo.com/v8/finance/chart/" & StickerSymbol & "?period1=" & StartOfPeriod & "&period2=" & EndOfPeriod & "&interval=1d&events=history&includeAdjustedClose=true"))
Besides the chart option in the above URL, is it possible to get split, dividend, and market cap data? What should be the label?
Did you find a solution for that ?
