A way to bypass Finance::Quote is to create a .csv file with price
quotes and import that. It turns out that several commercial spreadsheet
packages have the ability to look up stock prices and don't seem to
charge extra or to limit query rates. I've tried this with Microsoft
Excel, Apple Numbers and Google Sheets. The .csv file needs columns for
symbol, date, namespace (as used by Gnucash's security editor) and currency.
While not as convenient as updating directly in Gnucash, with a lot of
stocks it can be faster than waiting for the throttling of Alphavantage.
Tom T.
On 5/29/23 5:31 PM, Bruce Schuck wrote:
On Thu May 25, 2023 at 14:59:14 EDT R Losey wrote:
From the discussion here, one would get the idea that the only two
options for quotes are Alphavantage and Yahoo/JSON... don't the other
options work? I seem to remember seeing a very long list of options.
Most of the other modules retrieve data for non-US based securities,
or specific funds such as TSP.pm for data from https://www.tsp.gov/.
Fool.pm is one that probably just needs someone to spend a little time
investigating why it no longer works, but it could be a viable
alternative.
People either forget or don't realize that companies like
AlphaVantage, Yahoo, Alphabet (aka Google), and others pay for the
stock market data available on their websites or through APIs. Along
with what is likely a a large cost, there are license limitations on
how they may make that data available to others. This would be the
reason AlphaVantage has limits placed on access using the free API
key, and probably why Yahoo has been blocking access to long utilized
URLs/APIs. I fully expect the new URL for Yahoo in coming F::Q release
1.56 to get blocked at some point. Maybe a few months, maybe a year,
but I would bet on it.
This means modules will need to be rewritten to parse the HTML.
Doable, but not as simple as parsing JSON.
Bruce S.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
