I would suspect the crash happens because of mixing 32-bit Gnucash with 64-bit perl, but I am no Windows user.
~Frank -------- Weitergeleitete Nachricht -------- Betreff: Re: [GNC] problems with Finance::Quote 1.49 and and gnucash Build ID: 3.8b+(2019-12-29) on windows 10 64 bit Datum: Fri, 13 Mar 2020 13:54:02 -0400 Von: Mitchell Hausman <mshaus...@verizon.net> An: Frank H. Ellenberger <frank.h.ellenber...@gmail.com> Hello Frank, I still think there's a windows f-q install problem when using GnuCash to invoke it Unfortunately, 1) because i'm such a muddler, it's hard to isolate variables and determine the actual correct path to a "normal" windows install of Finance::Quote for GnuCash use 2) i'm just beginning to understand how to use GnuCash, so some of the errors might be between the screen and the keyboard, (as they used to say), but i don't think so I have a 57 page LibreOffice document showing the steps to a successful install in windows (it's that many pages because i copied all the complete perl scripts into it) IMHO, it shouldn't require so many steps by the user The Windows install steps should be (again, IMHO): 1) install Gnucash 2) select install online price retrieval from windows start menu (image below) done! *those steps don't appear to work (f-q install fails, or, get quote call crashes GnuCash)!* *Bottom Line:* *Manjaro Linux 19.0 64 bit:* Using Octopi to install Gnucash, you have the option of adding dependencies, including Finance::Quote I previously thought "get quote" function wasn't working on Linux, but maybe i was setting up the security editor, or price database/price editor incorrectly rechecking today, get quote within GnuCash succeeds, with a normal install! *Win 10 64 bit:* from gnucash-guide (downloaded from https://gnucash.org/docs.phtml, for windows users), if you want online price retrieval for GnuCash, you do have to install F-Q separately as a gnucash sub menu from the windows start menu: *that did not work (Gnucash calls to F-Q caused crash)* ** what worked for me (summarized from my install documentation mentioned above), is: 3/12/2020 6:11 pm after uninstalling straberryperl and gnucash (without registry cleanup) 1. installed strawberry perl 64 bit 2. used cpanm Module::Name to install finance::quote in admin cmd window: C:\WINDOWS\system32>cpanm Finance::Quote . . . *Successfully installed Finance-Quote-1.49* 9 distributions installed 3. install GnuCash 3.8 4. because it blew up (crashed) with "get quote" call, i installed F-Q from the windows start menu (see image above) it succeeded: . . . Appending installation info to C:\STRAWB~1\perl\lib/perllocal.pod SBECK/Date-Manip-6.81.tar.gz C:\STRAWB~1\c\bin\gmake.exe install UNINST=1 -- OK *Finance::Quote is up to date (1.49).* * 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 *** - starting GnuCash and adding the Alpha Vantage api key in *** Edit->Preferences->Online Quotes *** * Run gnc-fq-check //shows available quote sources ("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") * Run gnc-fq-helper (("AMZN" (symbol . "AMZN") (gnc:time-no-zone . "2020-03-12 12:00:00") (last . #e1676.6100) (currency . "USD"))) * Installation succeeded *Summary:* F-Q calls (get quote) within gnucash work on Manjaro Linux 19.0 after a "normal" octopi install of GnuCash After two installs of F-Q (first in strawberry perl 64 bit, then from windows start menu item), get quote within GnuCash works in Win 10 64 bit F-Q should not require repeated installs in Windows, but i'm happy i got it working within GnuCash If no other Win 10 user complains, i'd consider the issue closed *one other thing..* i read (https://money.stackexchange.com/questions/87192/how-to-fix-financequote-to-pull-quotes-in-gnucash#87270): /The Yahoo Finance API is no longer available, so //*Finance::Quote*//needs to point at something else. Recent versions of //*Finance::Quote*//can use AlphaVantage as a replacement for the Yahoo Finance API, but individual users need to acquire and input an AlphaVantage API key. Pretty decent documentation for how to this is available at the GnuCash wiki. / // /Once you've followed the directions on the wiki and set the API key, you still need to tell each individual security to use AlphaVantage rather than Yahoo Finance: / // 1. /Open the Security Editor (//|Tools|//menu -> //|Security Editor|//)/ 2. /Double-click the security/ 3. /Then, under //|Quote Source Information|//... / 1. /Check //|Get Online Quotes|/ 2. /Check the //|Unknown:|//radio button/ 3. /Change //|Unknown:|//'s associated menu item to //|alphavantage|//./ // /As a warning, I've been having intermittent trouble with AlphaVantage. From the //*GnuCash*//wiki: / // /Be patient. Alphavantage does not have the resources that Yahoo! did and it is common for //*quote*//requests to time out, which //*GnuCash*//will present as "unknown error". / // /I've certainly been experiencing those errors, though not always. / // /--Brian/ /===================================== / So, as i understand it, the API used is from AlphaVantage (and i have a key), but i can still choose from a variety of "sources," not to be confused with exchanges (like usa, NYSE nasdaq, etc.) The quote source (not exchange) i personally select in Gnucash security editor is alphavantage,us but it could just as easily be one of many from the drop down list including yahoo as json or YQl, where json/Yql is a datatype (format) The alphadvantage documentation page says datatypes available are json and csv I'll worry more about that, and the Labels available from the FETCH method(based on the source used, i guess), if i get more into using Perl scripts to get quotes Perl is an interesting language ===================================== Again, thanks for hearing me out Stay Well, Mitch On 3/13/2020 6:04 AM, Frank H. Ellenberger wrote: > 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 >> -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
_______________________________________________ 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.