search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
151 stars 21 forks source link

GETHISTORIC not working since 2024-09-05 #115

Open khorton opened 2 months ago

khorton commented 2 months ago

GETHISTORIC last worked on 2024-09-05 for symbols TSLA and AAPL. The function now returns "#N/A"

cmallwitz commented 2 months ago

confirmed.

my problem: I can see a "download" option for historical data on yahoo any more and I was using this functionality to extract historical prices... :-(

dlenski commented 2 months ago

Confirmed. My https://github.com/dlenski/yahoo-quote-download also used the same endpoints of https://query{1,2}.finance.yahoo.com/v7/finance/download/$TICKER, and it has stopped working.

https://github.com/dlenski/yahoo_quote_download/blob/master/yahoo_quote_download/yqd.py#L52

~For now there's doesn't seem to be any~ easy replacement: https://github.com/cmallwitz/Financials-Extension/issues/115#issuecomment-2344857238

dlenski commented 2 months ago

See https://github.com/dlenski/yahoo_quote_download/commit/1711c88 for how you can use the very similar /v7/finance/chart/$TICKER endpoint to get the exact same data, except in a JSON format rather than CSV.

Hamalx commented 2 months ago

Will there be any update soon to fix this issue?

minfuhon commented 1 month ago

confirmed.

my problem: I can see a "download" option for historical data on yahoo any more and I was using this functionality to extract historical prices... :-(

Do you think there is a work around? Or do we need to find alternatives?

dlenski commented 1 month ago

@minfuhon wrote:

Do you think there is a work around? Or do we need to find alternatives?

Did you read my immediately following comment, in which I demonstrate a clear and easy replacement to work around the removal of this endpoint? 🤨

cmallwitz commented 1 month ago

Planning to take a look on the weekend...

24 Sept 2024 19:56:36 Dan Lenski @.***>:

@minfuhon[https://github.com/minfuhon] wrote:

Do you think there is a work around? Or do we need to find alternatives?

Did you read my /immediately following comment/, in which I demonstrate a clear and easy replacement to work around the removal of this endpoint? 🤨

— Reply to this email directly, view it on GitHub[https://github.com/cmallwitz/Financials-Extension/issues/115#issuecomment-2372067436], or unsubscribe[https://github.com/notifications/unsubscribe-auth/AA226T4XOIOF7KGNBFIAIHDZYGYWFAVCNFSM6AAAAABN6Q6ULSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNZSGA3DONBTGY]. You are receiving this because you commented. [Tracking image][https://github.com/notifications/beacon/AA226T7NRH2HA4TGIIQFSNTZYGYWFA5CNFSM6AAAAABN6Q6ULSWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTUNMLQGY.gif]

cmallwitz commented 1 month ago

I uploaded new release 3.7.0 - Thanks for the link to updated code from Dan on yahoo_quote_download