[GNC] Problem getting Finance::Quote working
John Ralls
jralls at ceridwen.us
Fri Jan 3 17:08:44 EST 2025
FWIW I just successfully retrieved quotes with gnucash-cli -Q get; GnuCash 5.10 on macOS 15.3. Most of my securities use yahoo_json for the source.
Regards,
John Ralls
> On Jan 3, 2025, at 10:06, Kalpesh Patel <kalpesh.patel at usa.net> wrote:
>
> From looking at the *NIX's strace output, F::Q doesn’t appear to be fetching quotes from Alphavantage so the absent of the key should not matter. Full JSON is present in the strace output, thus F::Q is working as designed.
>
> I was also having issue with fetching yahoo_json quotes with GNC 5.10 on Windows 11, and had to fall back to prior version where it works fine so far without making any changes to F::Q. There was recommendation to update it to latest version which I did but still had no luck fetching quotes with GNC5.10.
>
> -----Original Message-----
> From: David H <hellvee at gmail.com>
> Sent: Thursday, January 02, 2025 11:22 PM
> To: Tomas Volf <~@wolfsden.cz>
> Cc: gnucash-user at gnucash.org
> Subject: Re: [GNC] Problem getting Finance::Quote working
>
> Have you setup your Alpha Vantage API key the output warns you about ?
> Preferences >> Online Quotes -
> https://wiki.gnucash.org/wiki/Online_Quotes#Alphavantage
>
> 00:58:05 WARN <gnc.price-quotes> [GncFQQuoteSource::set_api_key()] No Alpha Vantage API key set, currency quotes and other AlphaVantage based quotes won't work
>
> Cheers David H.
>
>
> On Fri, 3 Jan 2025 at 12:51, Tomas Volf <~@wolfsden.cz> wrote:
>
>> Hello,
>>
>> Today I installed gnucash and am trying to get fetch quotes from the
>> internet, and I am having troubles getting it to work. I am not
>> subscribed, so please CC.
>>
>> When I try the `gnucash-cli --quotes info', it seems to work:
>>
>> --8<---------------cut here---------------start------------->8---
>> $
>> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cl
>> i
>> --quotes info
>> * 00:56:27 WARN <gnc.price-quotes> [GncFQQuoteSource::set_api_key()]
>> No Alpha Vantage API key set, currency quotes and other AlphaVantage
>> based quotes won't work.
>> Found Finance::Quote version 1.64.
>> Finance::Quote sources:
>> aex alphavantage amfiindia asegr asx
>> aufunds australia bamosz bats bet bloomberg
>> borsa_italiana bourso bse bseindia bvb
>> canada comdirect consorsbank cse deka dutch
>> dwsfunds europe fetch_live_currencies financeapi
>> finanzpartner fondsweb fool france ftfunds
>> goldmoney googleweb greece hu hufund hungary
>> hustock india indiamutual known_currencies
>> marketwatch
>> morningstarau morningstarch morningstarjp
>> morningstaruk mstaruk nasdaq nseindia nyse
>> nzx onvista oslobors poland romania seb_funds
>> sinvestor six stockdata stooq tesouro_direto
>> tiaacref tmx tradegate tradeville treasurydirect
>> troweprice troweprice_direct tsp tsx twelvedata
>> ukfunds unionfunds usa xetra yahoo_json yahoojson
>> yahooweb za
>> --8<---------------cut here---------------end--------------->8---
>>
>> However when I try to actually get some quotes, I get this "error":
>>
>> --8<---------------cut here---------------start------------->8---
>> $
>> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cl
>> i
>> --quotes dump australia CML
>> * 00:58:05 WARN <gnc.price-quotes> [GncFQQuoteSource::set_api_key()]
>> No Alpha Vantage API key set, currency quotes and other AlphaVantage
>> based quotes won't work.
>> CML Finance::Quote returned no data and set no error.
>> --8<---------------cut here---------------end--------------->8---
>>
>> Which seems weird. The helper itself appears to work:
>>
>> --8<---------------cut here---------------start------------->8---
>> $ echo '{"defaultcurrency": "USD","australia": {"CML": ""}}' |
>> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/finance-qu
>> ote-wrapper
>> -f
>> {"australia":{"CML":{"name":"CONNECTED MINERALS
>> LIMITED","success":1,"last":0.2,"method":"asx","price":0.2,"type":"","
>> net":0,"errormsg":"","bid":0.18,"symbol":"CML","p_change":"0","volume"
>> :1019,"currency":"AUD","exchange":"Australian
>> Securities Exchange","ask":0.2}}}
>> --8<---------------cut here---------------end--------------->8---
>>
>> When I strace the `gnucash-cli' binary, it seems it does get the JSON
>> back:
>>
>> --8<---------------cut here---------------start------------->8---
>> $ strace -v -s 8192 --
>> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cl
>> i
>> --quotes dump australia CML
>> [..]
>> read(15,
>> "{\"australia\":{\"CML\":{\"errormsg\":\"\",\"price\":0.2,\"net\":0,\"
>> type\":\"\",\"bid\":0.18,\"success\":1,\"volume\":1019,\"name\":\"CONN
>> ECTED
>> MINERALS
>> LIMITED\",\"method\":\"asx\",\"p_change\":\"0\",\"currency\":\"AUD\",\
>> "ask\":0.2,\"last\":0.2,\"symbol\":\"CML\"}}}\n",
>> 512) = 224
>> [..]
>> write(1, "CML Finance::Quote returned no data and set no error.\n",
>> 54CML Finance::Quote returned no data and set no error.
>> ) = 54
>> [..]
>> --8<---------------cut here---------------end--------------->8---
>>
>> I am on 5.9 version:
>>
>> --8<---------------cut here---------------start------------->8---
>> $
>> /gnu/store/fq2bix6lr0rls6vld4xwb1dchkkdjnx1-gnucash-5.9/bin/gnucash-cl
>> i
>> --version
>> GnuCash 5.9
>> Build ID: 5.9+(2024-09-28)
>> --8<---------------cut here---------------end--------------->8---
>>
>> Would anyone have some suggestion what might be wrong and how I can
>> fix this?
>>
>> Thank you and have a nice day,
>> Tomas Volf
>>
>> --
>> There are only two hard things in Computer Science:
>> cache invalidation, naming things and off-by-one errors.
>> _______________________________________________
>> 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.
>>
>
>
> _______________________________________________
> 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