[GNC] Finance:Quote again [sorry]

Thu May 11 17:47:11 EDT 2023

For Windows, looks like install-fq-mods.cmd script needs an update. 

I am willing to chip in. Anyone able to point me to docs on PR against the code base? 

From: David H <hellvee at gmail.com> 
Sent: Thursday, May 11, 2023 5:14 PM
To: David Carlson <david.carlson.417 at gmail.com>
Cc: Geert Janssens <geert.gnucash at kobaltwit.be>; Kalpesh Patel <kalpesh.patel at usa.net>; gnucash-user at gnucash.org
Subject: Re: [GNC] Finance:Quote again [sorry]

The file in question is NOT in the registry, if you are using Strawberry Perl it should be C:\Strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm on both Win 10 and Win 11.

If you do have Yahoo as a quote source the work around is to change the api version called from v7 to v6 by editing the line (about line 38)  "my $YIND_URL_HEAD = 'https://query1.finance.yahoo.com/v7/finance/quote?symbols=';" to "my $YIND_URL_HEAD = 'https://query1.finance.yahoo.com/v6/finance/quote?symbols=';".

The file is normally read only so you'll need to right click on it in Windows Explorer and uncheck the read only checkbox first, then edit it in Notepad or similar, save the changes and for consistency re-apply the read only attribute.

Cheers David H.

On Fri, 12 May 2023 at 05:07, David Carlson <david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com> > wrote:

Just to complicate things, once you are sure that you have Finance:Quote
installed correctly, then, if you have any securities set up to be updated
with Yahoo as JSON, that feature is currently broken in recent releases of
Finance:Quote.  There is another thread that has a work-arouind, but it
involves editing a certain file that is probably in the Registry if you are
on Windows.  That may be something that is too risky for users who don't
like to get 'under the hood'.  There should be an update to fix that in a
few weeks, I hope.

On Thu, May 11, 2023 at 1:00 PM Geert Janssens <geert.gnucash at kobaltwit.be <mailto:geert.gnucash at kobaltwit.be> >
wrote:

> The new command is
> c:\Program Files (x86)\gnucash\bin\gnucash-cli --quotes info
>
> More details can be found on our online quotes wiki page, section command
> line interface:
> https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface[1]
>
> Regards,
>
> Geert
>
> Op donderdag 11 mei 2023 18:58:18 CEST schreef David Reiser via
> gnucash-user:
> > except that there is no gnc-fq-check in gnucash 5
> > --
> > Dave Reiser
> > dbreiser at icloud.com <mailto:dbreiser at icloud.com> 
> >
> > > On May 11, 2023, at 12:55 PM, Kalpesh Patel <kalpesh.patel at usa.net <mailto:kalpesh.patel at usa.net> >
> wrote:
> > >
> > > That sounds like GNC is not in your path ... try running following in a
> > > console window:
> > >
> > > c:\Strawberry\perl\bin\perl.exe "c:\Program Files
> > > (x86)\gnucash\bin\gnc-fq-check"
> > >
> > > It should spit out something like this:
> > >
> > > Microsoft Windows [Version 10.0.22621.1702]
> > > (c) Microsoft Corporation. All rights reserved.
> > >
> > > C:\Users\kalpesh>c:\Strawberry\perl\bin\perl.exe "c:\Program Files
> > > (x86)\gnucash\bin\gnc-fq-check" ("1.54" "aex" "alphavantage"
> "amfiindia"
> > > "asegr" "asx" "aufunds" "australia" "bamosz" "bet" "bloomberg" "bourso"
> > > "bse" "bseindia" "canada" "canadamutual" "comdirect" "cse" "deka"
> "dutch"
> > > "dwsfunds" "europe" "fetch_live_currencies" "fidelity"
> "fidelity_direct"
> > > "finanzpartner" "fondsweb" "fool" "france" "ftfunds" "fundata"
> > > "fundlibrary" "goldmoney" "greece" "hu" "hufund" "hungary" "hustock"
> > > "iexcloud" "india" "indiamutual" "known_currencies" "morningstarau"
> > > "morningstarch" "morningstarjp" "mstaruk" "nasdaq" "nseindia" "nyse"
> > > "nzx" "onvista" "oslobors" "romania" "seb_funds" "sinvestor" "six"
> > > "tesouro_direto" "tiaacref" "tmx" "tradegate" "tradeville"
> > > "treasurydirect" "troweprice" "troweprice_direct" "tsp" "tsx" "ukfunds"
> > > "unionfunds" "usa" "xetra" "yahoo_json" "za")
> > >
> > > C:\Users\kalpesh>
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Graham <graham.balin at gmail.com <mailto:graham.balin at gmail.com> >
> > > Sent: Thursday, May 11, 2023 11:49 AM
> > > To: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
> > > Subject: Re: [GNC] Finance:Quote again [sorry]
> > >
> > > Dear team
> > >
> > > Apologies if I am being particularly thick, but I can't get up to date
> > > stock prices. The last ones on the system are from March. I've spent
> ages
> > > with the documentation, so I uninstalled strawberry perl, re-run the
> > > windows install online price retrieval tool. All went well. But...when
> I
> > > attempt to run perl gnc-fq-check, I get 'Can't open perl script
> > > "gnc-fq-check": No such file or directory'.
> > >
> > > In the About section of Gnucash , i get the attached list, with no
> finance
> > > quote shown. Trying to get updated quotes with the price database, it
> now
> > > tells me Finance:Quote is not installed properly.
> > >
> > > Win10, Gnucash 5.
> > >
> > > Any help gratefully received
> > >
> > > --
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>

-- 
David Carlson
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.