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 > > _______________________________________________ gnucash-user mailing list gnucash-user@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.
