[GNC] experience using Alpha Vantage
Tom Veik
tlveik at gmail.com
Fri May 26 20:31:35 EDT 2023
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 <dgpickett at aol.com>
> To: gnucash-user at gnucash.org <gnucash-user at 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 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.
More information about the gnucash-user
mailing list