[GNC] Get quote - online price retrieval
D.
sunfish62 at yahoo.com
Mon Aug 17 07:00:00 EDT 2020
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