[GNC] Finance:Quote again [sorry]

David H hellvee at gmail.com
Thu May 11 17:13:53 EDT 2023


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>
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
> >
> 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
> > >
> > > > On May 11, 2023, at 12:55 PM, Kalpesh Patel <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>
> > > > Sent: Thursday, May 11, 2023 11:49 AM
> > > > To: 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
> > 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
> 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.
>


More information about the gnucash-user mailing list