[GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit
Frank H. Ellenberger
frank.h.ellenberger at gmail.com
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
>
>
More information about the gnucash-user
mailing list