[GNC] Revisiting Quotes

[Tom Teixeira]

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 at 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.