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