[GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit

Fri Mar 13 06:04:34 EDT 2020

Hi Mitch,

please always answer to all or the list. I am no Windows user, so others
might have better ideas.

BTW the full quotes of websites are hard read.

A few places with additional infos:
https://wiki.gnucash.org/wiki/Online_Quotes
https://www.gnucash.org/docs/v3/C/gnucash-help/tips.html

Am 12.03.20 um 21:48 schrieb Mitchell Hausman:
> Danke
> 
> this page: https://wiki.gnucash.org/wiki/FAQ states:
> 
>        *Windows Users:* Note that recent versions of Finance::Quote
>        require more recent versions of perl on Windows. If you
>        encounter trouble with the installation, remove whichever perl
>        you have, both with Control Panel and Windows Explorer, then run
>        Install Online Price Retrieval, which will install a recent
>        version of Strawberry Perl <http://strawberryperl.com/> for you.
> 
>            /N.B.:/ You don't necessarily want to do that if you're
>            using perl for other purposes, but in that case you probably
>            already know how to upgrade perl.
> 
> i hadn't noticed that reference before today
> 
> i don't know/remember if i had perl installed before gnucash install
> (probably not), but i did run gnucash's " install online price
> retrieval," in windows and it didn't install successfully
> 
> (i thought F-Q  had been separated from GnuCash, and you had to do the
> install online price retrieval per the instruction above - i _assumed_
> if it was a menu option, that gnucash did not come with f-q already
> installed)
> 
> i also thought that meant install f-q, not install recent perl
> 
> i went thru many iterations of installing and uninstalling perl (both 64
> and 32 bit), installing f-q with cpan, installing and uninstalling
> GnuCash, but i don't recall if i uninstalled perl, then used gnucash to
> install f-q
> 
> i think i always did the cpan f-q install after (strawberry) perl install
> 
> only the 64 bit strawberry perl successfully installed f-q
> 
> 
> i finally successfully ran Install Online Price Retrieval, after
> successful cpan install of f-q
> 
> i thought GnuCash had to "think" it had installed f-q successfully
> 
> probably a bad idea, but it worked
> 
> 
> before that, i learned enough perl to run perl scripts that got quotes
> successfully, so i knew f-q was working
> 
> 
> get quote in gnucash worked last night (hooray), but it stopped working
> after i almost replied saying i got it working a few moments ago!
> 
> so yes, i muddled everything with so many uninstalls and installs!!!!!
> 
> 
> i guess the correct steps are to uninstall perl and gnucash (they always
> leave stuff in the registry, so it's not a complete uninstall, so i may
> not be able to "unmuddle"))
> 
> install gnucash -*done*
> 
> see if GnuCash "get quotes" works (doesn't crash GnuCash and gets price
> data) - *doesn't work *- get quotes greyed out) see attached screenshot
> 
> if not, run Install Online Price Retrieval - *done, and failed (see
> attached txt file)*
> 
> *
> *
> 
> ... at end of install:
> 
> Stopping: 'install' failed for 'JSON::Parse'.
> 
> * Check environment variable ALPHAVANTAGE_API_KEY
> 
>   ***
>   *** You need an API key (from https://www.alphavantage.co)
>   ***   to run the Perl module Finance::Quote.
>   ***
>   *** Make it available to GnuCash by
>   ***    - setting the environment variable ALPHAVANTAGE_API_KEY (done)
> or         //key already entered in both places
>   ***    - starting GnuCash and adding the Alpha Vantage api key in
>   ***        Edit->Preferences->Online Quotes
>   ***
> 
> * Run gnc-fq-check
> 
> 
> You need to install the following Perl modules: //this is today's result
> of gnc-fq-check
>   Finance::Quote
> 
> Use your system's package manager to install them,
> or run 'gnc-fq-update' as root.                                    
> //this failed as well
> missing-lib
> 
> An error occurred, see above.
> 
> Press any key to continue . . .
> 
> 
> 
> _I've come full circle and have to use cpan in perl to install
> finance::quote_
> 
> _but, _cpan install failed as well:
> 
> 
> collect2.exe: error: ld returned 1 exit status
> gmake: *** [Makefile:495: blib\arch\auto\JSON\Parse\Parse.xs.dll] Error 1
>   BKB/JSON-Parse-0.56.tar.gz
>   C:\STRAWB~1\c\bin\gmake.exe -- NOT OK
> Stopping: 'install' failed for 'JSON::Parse'.
> 
> 
> I give up
> 
> Thanks, though
> 
> 
> i ran these yesterday:
> 
> C:\Program Files (x86)\gnucash\bin>perl *gnc-fq-check*
> ("1.49" "adig" "aex" "aiahk" "alphavantage" "amfiindia" "asegr" "asx"
> "aufunds" "australia" "bamosz" "bet" "bmonesbittburns" "bourso" "bse"
> "bsero" "canada" "canadamutual" "citywire" "cominvest" "cse" "deka"
> "dutch" "dwsfunds" "europe"
> "fetch_live_currencies" "fidelity" "fidelity_direct" "fidelityfixed"
> "financecanada" "finanzpartner" "finland" "fool" "france" "ftfunds"
> "ftportfolios" "ftportfolios_direct" "fundlibrary" "goldmoney" "greece"
> "hex" "hu" "hufund"
> "hungary" "hustock" "iexcloud" "indiamutual" "known_currencies"
> "lerevenu" "maninv" "morningstar" "morningstarau" "morningstarch"
> "morningstarjp" "mstaruk" "nasdaq" "nyse" "nz" "nzx" "platinum"
> "romania" "seb_funds" "sixfunds"
>  "sixshares" "stockhousecanada_fund" "tdefunds" "tdwaterhouse"
> "tiaacref" "tnetuk" "troweprice" "troweprice_direct" "trustnet" "tsp"
> "tsx" "uk_unit_trusts" "ukfunds" "unionfunds" "usa" "usfedbonds"
> "vanguard" "vwd" "yahoo_json"
> "yahoo_yql" "za" "za_unittrusts")
> 
> C:\Program Files (x86)\gnucash\bin>

That looked goood.

> C:\Program Files (x86)\gnucash\bin>perl *gnc-fq-dump* -v yahoo_json
> USDEUR=X
> Finance::Quote fields Gnucash uses:
>     symbol: USDEUR=X             <=== required
>       date: 03/11/2020           <=== recommended
>   currency: EUR                  <=== required
>       last: 0.8865               <=\
>        nav:                      <=== one of these
>      price:                      <=/
>   timezone:                      <=== optional
> 
> All fields returned by Finance::Quote for stock USDEUR=X (from alpha
> advantage web page)

That is not from alphavantage.co, but yahoo.com. OTOH it is an usable
result.

> stock           field  value
> -----           -----  -----
> USDEUR=X        close: 0.8854
> USDEUR=X     currency: EUR
> USDEUR=X         date: 03/11/2020
> USDEUR=X    div_yield: 0
> USDEUR=X          eps:
> USDEUR=X     exchange: Sourced from Yahoo Finance (as JSON)
> USDEUR=X         high: 0.888
> USDEUR=X      isodate: 2020-03-11
> USDEUR=X         last: 0.8865
> USDEUR=X          low: 0.8796
> USDEUR=X       method: yahoo_json
> USDEUR=X         name: USDEUR=X (USD/EUR)
> USDEUR=X         open: 0.8857
> USDEUR=X           pe:
> USDEUR=X      success: 1
> USDEUR=X       symbol: USDEUR=X
> USDEUR=X         type: CURRENCY
> USDEUR=X       volume: 0
> USDEUR=X   year_range: 0.869880000000001 - 0.927680000000001

For FX rates it seems, F::Q changed something. I will investigate it now...

Regards
Frank

> Mitch
> 
> 
> On 3/12/2020 7:00 AM, Frank H. Ellenberger wrote:
>> Hello Mitchell,
>>
>> Am 09.03.20 um 19:35 schrieb Mitchell Hausman via gnucash-user:
>>> C:\Program Files (x86)\GnuCash\bin>cpan gnc-fq-dump
>> while gnc-fq-dump is written in perl, it is not provided  by cpan, but
>> already installed as part of gnucash.
>>
>> So cpan is right here:
>>>> (error): Skipping gnc-fq-dump because I couldn't find a matching
>>>> namespace.
>> Did you muddle cpan (installer) with perl (processor)?
>>
>> What is the output of:
>> perl gnc-fq-check
>>
>> HTH
>> Frank
> 
> 