[GNC] Trouble with gnc-fq-dump
Daniel Torstenson
dtorstenson21 at gmail.com
Thu Dec 9 02:13:51 EST 2021
Ah, your question of which distri led me to the solution. I'm on Arch. I
installed Finance::Quote using gnc-fq-update, without fully realizing it
was about to install a billion perl modules. I think there was probably
some dependency problem. I manually uninstalled those modules (I think!
There were a lot of them!), and installed perl-finance-quote through the
Arch repository. Now it works great!
Thanks for your help!
On Wed, Dec 8, 2021 at 9:37 PM Frank H. Ellenberger <
frank.h.ellenberger at gmail.com> wrote:
> 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