[GNC] experience using Alpha Vantage

[David G. Pickett]

One theory I have that seems good is that they delay Fund pricing, perhaps because each fund firm publishes their NAVs at different times after the trading day, so the do not collect them or make them visible until much later.  I finally got my Friday fund prices today, which is not a trading day because of the holiday, but to a simple computer schedule might seem a trading day, as it is Monday.


-----Original Message-----
From: David G. Pickett <dgpickett at aol.com>
To: john.layman at laymanandlayman.com <john.layman at laymanandlayman.com>; gnucash-user at gnucash.org <gnucash-user at gnucash.org>
Sent: Sat, May 27, 2023 5:14 pm
Subject: Re: [GNC] experience using Alpha Vantage

It is frustrating that you can find dozens of free sites for human viewing with up to date quotes, especially for funds that change once after each trading day close (I guess if they have interest bearing securities they could fluctuate all the time as rates fluctuate, but not that I ever heard of).  If we learn to mine these pages, the quote fetch overhead on the providers goes way up from them creating junk we throw away, e.g.: https://finance.yahoo.com/quote/SPY/

-----Original Message-----
From: John Layman <john.layman at laymanandlayman.com>
To: 'David G. Pickett' <dgpickett at aol.com>; gnucash-user at gnucash.org
Sent: Sat, May 27, 2023 8:09 am
Subject: RE: [GNC] experience using Alpha Vantage

Mostly, no.  I'm getting few mutual fund returns.  But misses are only sporadically logged.  That makes me wonder if stale quotes are being delivered.  But it also makes me wonder if I've been tuned out and am unaware that a secret handshake is now needed.

I don't fetch prices automatically, but typically download around 6 AM.  I also run an Excel spreadsheet that fetches quotes from Refinitiv using the Stocks data type.  That has its own issues as some newer mutual fund tickers aren't recognized.

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+john.layman=ieee.org at gnucash.org> On Behalf Of David G. Pickett via gnucash-user
Sent: Friday, May 26, 2023 4:42 PM
To: gnucash-user at gnucash.org
Subject: Re: [GNC] experience using Alpha Vantage

I have seen it fumble, too, not sure if it is FQ or AA.  Funds do their nav some time after 4 eastern, so I do my quotes on cron at midnight.  This also means the 6 minute run time is not a problem.  But silently lost quotes seems like a bad behavior.  Does the code log when the price fetch fails a AA?  It certainly did with Yahoo!
_______________________________________________
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.