search

cmallwitz / Financials-Extension

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

Suggestion: Alphavantage API #79

Open omoknen opened 1 year ago

omoknen commented 1 year ago

https://www.alphavantage.co/

I know Gnucash uses Finance::Quote (perl module) to get quotes from various sources and which I use with Alphavantage, but my husband uses your Financials-Extension for Libre Calc and he really loves it. Alphavantage API uses a free API key and it has a limit to how many times you can retrieve information. They do have extensions for Google Docs and Excel, but not Libre Calc. I don't know if it can be accessed with your extension, but perhaps it might be a way to get around Yahoo if it keeps changing. I know this would be a lot of work so I just want to make this a suggestion

Thank you

cmallwitz commented 1 year ago

A few years back I got a free Alphavantage account and tried to use it here. The problem is the free usage tier limits of 5 API requests per minute and 500 API requests per day.

Maybe Gnucash and Finance::Quote somehow control there traffic by downloading data only once a day or by bundling all stock symbols into one API call.

But the LibreCalc extensions doesn't "see" how many or what symbols might be requested from a spreadsheet. Say you want to refresh a spreadsheet with 20 positions - if the extensions would do the required throttling, it would take 4 minutes to refresh the data. So I gave up on Alphavantage :-(

I'm happy to look into API like data sources but they need to have somewhat compatible API limits.