[GNC] Finance::Quote - AlphaVantage Trade Currencies

[Brad Morrison]

Hi Bruce/all,

Thank you for all your hard work with F::Q!

Does it also make sense to post this situation & question to the other 6 
GnuCash Mailman 2 mailing lists that are not in English? 
https://wiki.gnucash.org/wiki/Mailing_Lists & 
https://lists.gnucash.org/mailman/listinfo

I have never used F::Q in GnuCash (or at all), so maybe my point is 
useless or maybe you already are signed up for those other language 
lists. I was just thinking that there may be many more users of AV for 
non-US traded securities on the other language lists than English - ?

In my work for a tax & wealth management firm (on the tax side), I most 
frequently interact with non-US traded stocks when an IRS form 1099DIV 
(https://www.irs.gov/forms-pubs/about-form-1099-div) or 1099B 
(https://www.irs.gov/forms-pubs/about-form-1099-b) indicates that 
foreign taxes were paid and my role is account for those foreign taxes 
paid & to determine whether an IRS form 1116 
(https://www.irs.gov/forms-pubs/about-form-1116) is needed.

While I am mentioning the GnuCash mailing lists, does anyone know if 
there are plans to upgrade from Mailman 2 to Mailman 3? 
https://www.gnu.org/software/mailman/ & 
https://en.wikipedia.org/wiki/GNU_Mailman

2.5 securities per minute seems really slow!

Brad


On 7/16/23 15:52, Bruce Schuck wrote:
> Hello again,
>
> At some point I am going to take a break from F::Q, I thought this 
> weekend I was going to escape.
>
> ### For the question, skip to the next ###
>
> Anyway, some time ago the issue was raised about prices from 
> AlphaVantage for LSE traded stocks (see 
> https://github.com/finance-quote/finance-quote/issues/281). While 
> there is an issue, the user's perceived solution was not the answer. 
> Apparently my attempt to explain that the root cause was that the data 
> returned from the AV "GLOBAL_QUOTE" API did *NOT* contain the currency 
> used for the pricing returned.
>
> What the AV module does is assign a currency based on the suffix of 
> the lookup symbol. So stocks like GBP.L and GBPG.L get mapped to GBP. 
> The problem is that GBP.L (Global Petroleum Limited) is traded in GBX 
> (aka GBp) and GBPG.L (Goldman Sachs Access UK Gilts 1-10) is traded in 
> GBP. But the AV module as written cannot differentiate since the 
> currency used is not part of the data. Stocks from South Africa have a 
> similar issue.
>
> Needless to say, since I was not ready to dig into the root cause and 
> not wanting to remove the fix that was meant to convert GBp pricing to 
> GBP pricing based solely on the symbol's suffix, the user decided to 
> go on a rant and throw a tantrum in the comments and had to be blocked 
> from the Finance::Quote repository.
>
> ### Question here ###
>
> The currency for the trades can be gotten from AV, but an additional 
> call using the "SYMBOL_SEARCH" API is necessary. Obviously this would 
> impact the throttling limitation of AlphaVantage. For non-US stocks, 
> this means that including an additional currency lookup an average of 
> 2.5 securities can be fetched per minute. I am curious how many of you 
> all use AV for non-US traded securities? Has the pricing discrepancy 
> affect you, and would you want it corrected even though that means 
> increasing retrieval time due to the extra API usage?
>
> 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.
>