Forum Discussion
Yahoo Finance Power Query Link Not Working
Hey 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 Care
I 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?