Alphavantage is having issues, completely separate from GnuCash. I did
some experimenting today with queries for one mutual fund. GnuCash is
not involved at all in this test.
Here are responses to several identical queries I made. One line has
the date/time of the query, followed by the response to the query. Look
at the back and forth nature of the responses I got. Look at the "latest
trading day" line.
The query:
https://www.alphavantage.co/query?function=GLOBAL_QUOTE&datatype=json&apikey=********&symbol=VFIAX
5/26/2023 4:16:38 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 4:31:40 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 4:46:41 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 5:01:42 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 5:16:43 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 5:31:44 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "383.8600",
"03. high": "383.8600",
"04. low": "383.8600",
"05. price": "383.8600",
"06. volume": "0",
"07. latest trading day": "2023-05-25",
"08. previous close": "380.5100",
"09. change": "3.3500",
"10. change percent": "0.8804%"
}
}
5/26/2023 5:46:46 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 6:01:47 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 6:16:48 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 6:31:49 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 6:46:51 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "380.5100",
"03. high": "380.5100",
"04. low": "380.5100",
"05. price": "380.5100",
"06. volume": "0",
"07. latest trading day": "2023-05-24",
"08. previous close": "383.3100",
"09. change": "-2.8000",
"10. change percent": "-0.7305%"
}
}
5/26/2023 7:01:52 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "383.8600",
"03. high": "383.8600",
"04. low": "383.8600",
"05. price": "383.8600",
"06. volume": "0",
"07. latest trading day": "2023-05-25",
"08. previous close": "380.5100",
"09. change": "3.3500",
"10. change percent": "0.8804%"
}
}
5/26/2023 7:16:53 PM
{
"Global Quote": {
"01. symbol": "VFIAX",
"02. open": "383.8600",
"03. high": "383.8600",
"04. low": "383.8600",
"05. price": "383.8600",
"06. volume": "0",
"07. latest trading day": "2023-05-25",
"08. previous close": "380.5100",
"09. change": "3.3500",
"10. change percent": "0.8804%"
}
}
On 5/26/2023 4:06 PM, David G. Pickett via gnucash-user wrote:
I see last night it missed all my funds, so I am running it again. That
worked! Maybe I will add another run to make sure! 9:15?
-----Original Message-----
From: David G. Pickett <dgpick...@aol.com>
To: gnucash-user@gnucash.org <gnucash-user@gnucash.org>
Sent: Fri, May 26, 2023 4:42 pm
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@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.
