[GNC] Trouble with gnc-fq-dump
Frank H. Ellenberger
frank.h.ellenberger at gmail.com
Wed Dec 8 23:37:11 EST 2021
Hi Daniel,
I get:
> gnc-fq-dump -v alphavantage IBM
Finance::Quote fields Gnucash uses:
symbol: IBM <=== required
date: 12/08/2021 <=== recommended
currency: USD <=== required
last: 123.0200 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
All fields returned by Finance::Quote for stock IBM
stock field value
----- ----- -----
IBM close: 121.5800
IBM currency: USD
IBM currency_set_by_fq: 1
IBM date: 12/08/2021
IBM high: 123.3800
IBM isodate: 2021-12-08
IBM last: 123.0200
IBM low: 121.5200
IBM method: alphavantage
IBM net: 1.4400
IBM open: 122.0000
IBM p_change: 1.1844
IBM success: 1
IBM symbol: IBM
IBM volume: 5483948
> gnc-fq-dump -v yahoo_json IBM
Finance::Quote fields Gnucash uses:
symbol: IBM <=== required
date: 12/08/2021 <=== recommended
currency: USD <=== required
last: 123.02 <=\
nav: <=== one of these
price: <=/
timezone: <=== optional
All fields returned by Finance::Quote for stock IBM
stock field value
----- ----- -----
IBM close: 121.58
IBM currency: USD
IBM date: 12/08/2021
IBM div_yield: 5.3791743
IBM eps: 5.283
IBM exchange: Sourced from Yahoo Finance (as JSON)
IBM high: 123.38
IBM isodate: 2021-12-08
IBM last: 123.02
IBM low: 121.52
IBM method: yahoo_json
IBM name: IBM (International Business Machines)
IBM open: 122
IBM pe: 23.28601
IBM success: 1
IBM symbol: IBM
IBM type: EQUITY
IBM volume: 5454786
IBM year_range: 112.19885 - 146.11855
> gnc-fq-check
("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
"australia" "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia"
"canada" "canadamutual" "comdirect" "cse" "deka" "dutch" "dwsfunds"
"europe" "fetch_live_currencies" "fidelity" "fidelity_direct"
"finanzpartner" "fondsweb" "fool" "ftfunds" "fundata" "fundlibrary"
"goldmoney" "greece" "hu" "hufund" "hungary" "hustock" "iexcloud"
"india" "indiamutual" "known_currencies" "morningstarau" "morningstarjp"
"mstaruk" "nasdaq" "nseindia" "nyse" "nzx" "onvista" "oslobors"
"romania" "seb_funds" "six" "tiaacref" "tmx" "tradeville" "troweprice"
"troweprice_direct" "tsp" "ukfunds" "unionfunds" "usa" "usfedbonds"
"yahoo_json" "za")
> date
Do 9. Dez 05:16:14 CET 2021
Did you read https://www.alphavantage.co/support/#support about the
limits of the free key?
But as yahoo is also broken for you, a few steps you could try:
* Check your network and security (firewall, antivirus…) settings,
* reinstall F::Q
* reinstall perl
which distri?
Regards
Frank
Am 09.12.21 um 00:58 schrieb Daniel Torstenson:
> Hi, I'm trying to get online quotes to work with Alphavantage, but I'm
> having trouble. I'd appreciate any pointers for debugging this, as I don't
> see anyone else with this problem after searching the web a little bit.
>
> I'm running Linux.
which distri?
> I have an Alphavantage API key.
>
> A call to
>
> https://www.alphavantage.co/query?function=SYMBOL_SEARCH&keywords=IBM&apikey=MY_API_KEY
>
> gives the expected results
>
>> gnc-fq-check
>
> gives
>
> ("1.51" "aex" "alphavantage" "amfiindia" "asegr" "asx" "aufunds"
> "australia" "bamosz" "bet" "bloomberg" "bourso" "bse" "bseindia" "canada"
> "canadamutual" "comdirect" "cse" "deka" "dutch" "dwsfunds" "europe"
> "fetch_live_currencies" "fidelity" "fidelity_direct" "finanzpartner"
> "fondsweb" "fool" "ftfunds" "fundata" "fundlibrary" "goldmoney" "greece"
> "hu" "hufund" "hungary" "hustock" "iexcloud" "india" "indiamutual"
> "known_currencies" "morningstarau" "morningstarjp" "mstaruk" "nasdaq"
> "nseindia" "nyse" "nzx" "onvista" "oslobors" "romania" "seb_funds" "six"
> "tiaacref" "tmx" "tradeville" "troweprice" "troweprice_direct" "tsp"
> "ukfunds" "unionfunds" "usa" "usfedbonds" "yahoo_json" "za")
>
>> export ALPHAVANTAGE_API_KEY=MY_API_KEY
>> echo $ALPHAVANTAGE_API_KEY
>
> gives MY_API_KEY correctly.
>
>> gnc-fq-dump -v alphavantage IBM
>
> gives
>
> Finance::Quote fields Gnucash uses:
> symbol: IBM (deduced) <=== required
> date: ** missing ** <=== recommended
> currency: ** missing ** <=== required
> last: **missing** <=\
> nav: **missing** <=== one of these
> price: **missing** <=/
> timezone: <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
>
> All fields returned by Finance::Quote for stock IBM
>
> stock field value
> ----- ----- -----
> IBM errormsg: Not Implemented
> IBM last: **missing**
> IBM nav: **missing**
> IBM price: **missing**
> IBM success: 0
>
> I get the same for any ticker symbol I try.
>
> Strangely, when I try
>
>> gnc-fq-dump -v yahoo_json IBM ✔
>
> I get
>
> Finance::Quote fields Gnucash uses:
> symbol: IBM <=== required
> date: ** missing ** <=== recommended
> currency: ** missing ** <=== required
> last: **missing** <=\
> nav: **missing** <=== one of these
> price: **missing** <=/
> timezone: <=== optional
>
> ** This stock quote cannot be used by GnuCash!
>
>
> All fields returned by Finance::Quote for stock IBM
>
> stock field value
> ----- ----- -----
> IBM errormsg: Error retrieving quote for IBM. Attempt to fetch the
> URL https://query1.finance.yahoo.com/v7/finance/quote?symbols=IBM resulted
> in HTTP response 501 (Not Implemented)
> IBM last: **missing**
> IBM nav: **missing**
> IBM price: **missing**
> IBM success: 0
> IBM symbol: IBM
>
> It claims I'm getting error 501. But if I just copy and paste that URL into
> a browser, I get the correct results. What could be going on here?
>
> Thanks!
> _______________________________________________
> 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
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> 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