Ah, yes. ISTR that AlphaVantage is used for all currency conversions. That would suggest that users should be told that outright somewhere.
-------- Original Message -------- From: Geoff <cleanoutmys...@gmail.com> Sent: Mon Aug 17 08:32:10 EDT 2020 To: "D." <sunfis...@yahoo.com> Cc: David Reiser via gnucash-user <gnucash-user@gnucash.org>, gnucash-user@gnucash.org Subject: Re: [GNC] Get quote - online price retrieval One would think so David, but my experience was otherwise. When running Get Quotes on a brand new default database with no securities defined, and then after adding just one security for this mutual fund, in both cases I was prompted to enter an AlphaVantage API key - see attached screenshots. I believe this behaviour is because I set up the database with a currency code of INR, as when I do the same with USD the error message doesn't manifest. Anyway, for this particular issue, the root cause was the failed installation of the supporting perl modules. Have a good day. Regards Geoff ===== On 17/08/2020 9:00 pm, D. wrote: > Of course, if you're using amfiindia as your price source, it's not > technically necessary to add an AlphaVantage key, since you're not using > AlphaVantage as a source. > > > -------- Original Message -------- > From: Geoff <cleanoutmys...@gmail.com> > Sent: Mon Aug 17 01:41:22 EDT 2020 > To: gnucash-user@gnucash.org > Subject: Re: [GNC] Get quote - online price retrieval > > Ashok, I have tried to replicate your issue on a new Windows 10 installation. > > You said:- > "Did the cpan Date::Manip, but that freezes at the point of the below stage. > Have to "Ctrl"+C, ugly exit." > > You need to be more patient, it wasn't frozen, just having a rest! The > complete installation process of all the necessary perl modules for price > quotes (if you use "gnc-fq-update" the recommended gnucash installer) took > about 30 minutes on my machine, and there were a couple of significant > pauses along the way. > > Once you have successfully installed Finance::Quotes and all of its > dependencies, you will be able to get a quote for your fund: > > C:\Program Files (x86)\gnucash\bin>perl gnc-fq-dump -v amfiindia 106876 > Finance::Quote fields Gnucash uses: > symbol: 106876 <=== required > date: 08/14/2020 <=== recommended > currency: INR <=== required > last: <=\ > nav: 17.6037 <=== one of these > price: <=/ > timezone: <=== optional > > All fields returned by Finance::Quote for stock 106876 > > stock field value > ----- ----- ----- > 106876 currency: INR > 106876 date: 08/14/2020 > 106876 isodate: 2020-08-14 > 106876 link: https://www.amfiindia.com/spages/NAVAll.txt > 106876 method: amfitable > 106876 name: Aditya Birla Sun Life International Equity Fund - > Plan B - Growth - Regular Plan > 106876 nav: 17.6037 > 106876 source: http://www.amfiindia.com/ > 106876 success: 1 > 106876 symbol: 106876 > > > I have also attached a screenshot of getting a quote from within gnucash - > don't forget to add your AlphaVantage API key first as explained here: > https://wiki.gnucash.org/wiki/Online_Quotes > > > DETAILED INSTRUCTIONS > ===================== > Windows 10 Version 1903 > > Download gnucash 4.1 for Windows 10 from: > https://sourceforge.net/projects/gnucash/files/gnucash%20(stable)/4.1/gnucash-4.1.setup.exe > > Verify the checksum from https://www.gnucash.org/news.phtml > We are expecting: > "836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0" for > gnucash-4.1.setup.exe > > 08/17/2020 12:56 PM <DIR> .. > 08/17/2020 12:56 PM 148,789,209 gnucash-4.1.setup.exe > > C:>certutil -hashfile gnucash-4.1.setup.exe SHA256 > SHA256 hash of gnucash-4.1.setup.exe: > 836b36be639caf61321c2df24dda48691e57ddeb6b7aa13db49f8eddd5b096e0 > CertUtil: -hashfile command completed successfully. > > > Download strawberry perl from http://strawberryperl.com/ > http://strawberryperl.com/download/5.30.2.1/strawberry-perl-5.30.2.1-64bit.msi > > 08/17/2020 01:04 PM <DIR> . > 08/17/2020 01:04 PM 106,541,628 strawberry-perl-5.30.2.1-64bit.msi > > C:>perl -v > This is perl 5, version 30, subversion 2 (v5.30.2) built for > MSWin32-x64-multi-thread > > C:>cd "C:\Program Files (x86)\gnucash\bin" > > C:\Program Files (x86)\gnucash\bin>perl gnc-fq-check > > You need to install the following Perl modules: > Finance::Quote > > Use your system's package manager to install them, > or run 'gnc-fq-update' as root. > missing-lib > > C:\Program Files (x86)\gnucash\bin>perl gnc-fq-update > Fetching with LWP: > http://cpan.strawberryperl.com/authors/01mailrc.txt.gz > Fetching with LWP: > http://cpan.strawberryperl.com/modules/02packages.details.txt.gz > Fetching with LWP: > http://cpan.strawberryperl.com/modules/03modlist.data.gz > Creating database file ... Done! > Running install for module 'Date::Manip' > Fetching with LWP: > http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/Date-Manip-6.82.tar.gz > Fetching with LWP: > HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS > Fetching with LWP: > HASH(0x5250c90)authors/id/S/SB/SBECK/CHECKSUMS.gz > Fetching with LWP: > http://cpan.strawberryperl.com/authors/id/S/SB/SBECK/CHECKSUMS > Checksum for > C:\Strawberry\cpan\sources\authors\id\S\SB\SBECK\Date-Manip-6.82.tar.gz ok > Configuring S/SB/SBECK/Date-Manip-6.82.tar.gz with Makefile.PL > Checking if your kit is complete... > Looks good > > ~~~ snip ~~~ > > 2900 lines later it should complete successfully with: > > Installing C:\Strawberry\perl\site\lib\Finance\Quote\YahooYQL.pm > Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA.pm > Installing C:\Strawberry\perl\site\lib\Finance\Quote\ZA_UnitTrusts.pm > Appending installation info to C:\Strawberry\perl\lib/perllocal.pod > ECOCODE/Finance-Quote-1.49.tar.gz > C:\Strawberry\c\bin\gmake.exe install UNINST=1 -- OK > > C:\Program Files (x86)\gnucash\bin> > > Hope this helps. > > Geoff > ===== > <http://gnucash.1415818.n4.nabble.com/file/t379090/amfiindia.jpg> > > > > -- > Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html > _______________________________________________ > 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. > _______________________________________________ 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.
