[GNC] Finance::Quote - AlphaVantage Trade Currencies
Bruce Schuck
bschuck at asgard-systems.com
Sun Jul 16 18:52:37 EDT 2023
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.
More information about the gnucash-user
mailing list