[GNC] Get quote - online price retrieval

D. sunfish62 at yahoo.com
Mon Aug 17 08:56:34 EDT 2020


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 <cleanoutmyshed at gmail.com>
Sent: Mon Aug 17 08:32:10 EDT 2020
To: "D." <sunfish62 at yahoo.com>
Cc: David Reiser via gnucash-user <gnucash-user at gnucash.org>, gnucash-user at 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 <cleanoutmyshed at gmail.com>
> Sent: Mon Aug 17 01:41:22 EDT 2020
> To: gnucash-user at 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 at 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.
> 



More information about the gnucash-user mailing list