cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
137 stars 17 forks source link

Error 508 #110

Open hostingnuggets opened 5 days ago

hostingnuggets commented 5 days ago

Hi, I just installed this extension in Calc (LibreOffice 7.4.7.2) on Debian 12 but unfortunately all examples below from the README:

    =GETREALTIME("IBM",21,"YAHOO")
    =GETREALTIME("IBM:NYQ",21,"FT")
    =GETREALTIME("EURUSD","LAST_PRICE","FT")
    =GETHISTORIC("IBM",90,"2020-12-01","YAHOO")
    =GETREALTIME("ETH-USD","LAST_PRICE","COINBASE")

Show me an Error 508. Any ideas what could be wrong?

cmallwitz commented 5 days ago

Odd - Error 508 - assuming this is a web server error 508 - would indicate you have overloaded the target web server somehow. Not very likely across all of Yahoo/FT/Coinbase.

Are you behind a corporate firewall that somehow could interfere with the extension?

On Tue, 25 Jun 2024 at 13:53, Hosting Nuggets @.***> wrote:

Hi, I just installed this extension in Calc (LibreOffice 7.4.7.2) on Debian 12 but unfortunately all examples below from the README:

=GETREALTIME("IBM",21,"YAHOO")
=GETREALTIME("IBM:NYQ",21,"FT")
=GETREALTIME("EURUSD","LAST_PRICE","FT")
=GETHISTORIC("IBM",90,"2020-12-01","YAHOO")
=GETREALTIME("ETH-USD","LAST_PRICE","COINBASE")

Show me an Error 508. Any ideas what could be wrong?

— Reply to this email directly, view it on GitHub https://github.com/cmallwitz/Financials-Extension/issues/110, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA226T5WQDSOZNNKQJMG4RLZJFY4ZAVCNFSM6AAAAABJ35BC4CVHI2DSMVQWIX3LMV43ASLTON2WKOZSGM3TENZWGMZDAMQ . You are receiving this because you are subscribed to this thread.Message ID: @.***>

hostingnuggets commented 5 days ago

Are you behind a corporate firewall that somehow could interfere with the extension?

No, home connection in Europe. Could be maybe some country restriction...

hostingnuggets commented 3 days ago

@cmallwitz I actually found the issue: instead of using , as a separator like in the example I needed to use a ;.

But now I have another issue, for the following

=GETREALTIME("EUR=X";"LAST_PRICE";"YAHOO")

I get the following error:

Yahoo.getRealtime(EUR=X, 21) - crumb missing

Any ideas what's wrong here?