[GNC] YahooJSON hack for Linux Flatpak install
The hack proposed by Bruce Schuck in the thread "Yahoo Closed the Door on Finance API" also works for Flatpak install of Gnucash v. 5.3. This Flatpak install was the only Linux distribution of Gnucash v.5.3 I have been able to find. Unfortunately it it uses F::Q v. 1.56 and I have been unable to find any means of upgrading to F::Q v. 1.57. The good news is the hack also works on F::Q v.1.56. Bruce's hack is:>For those comfortable with locating and editing the YahooJSON.pm module>manually I have a quick fix. If you have F::Q v1.57 change the lines>defining $YIND_URL_HEAD and $YIND_URL_TAIL (lines 38 and 39) to: >my $YIND_URL_HEAD >=>'https://query2.finance.yahoo.com/v11/finance/quoteSummary/?symbol=';>my >$YIND_URL_TAIL = '=price,summaryDetail,defaultKeyStatistics'; The Flatpak YahooJSON.pm module is located at:var/lib/flatpak/app/org.gnucash.GnuCash/current/active/files/lib/perl5/site_perl/S.32.0/Finance/Quote Elevated privileges are required to modify this file. ___ gnucash-user mailing list gnucash-user@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.
[GNC] Fw: Finance::Quote terminal commands not working with Flatpak v:5.3 install
Old dog learning new tricks comes hard: I forgot to cc the mailing list in my reply to the valuable information Geert shared so this is to rectify that omission. Also, it occurs to me that it would be very useful if somebody who knows how to edit the Gnucash Wiki could put a link in the Online Quotes page, Section 3 (https://wiki.gnucash.org/wiki/Online_Quotes#Command_line_interface) pointing to the Flatpak page on Using Command Line Tools (https://wiki.gnucash.org/wiki/Flatpak#Using_Command_Line_Tools) which documents the information that Geert supplied me. Cheers,doug - Reply - From: doug brown To: Geert Janssens Sent: Tuesday, July 11, 2023 at 02:45:37 PM GMT-7Subject: Re: Re: [GNC] Finance::Quote terminal commands not working with Flatpack v:5.3 install Thanks Geert- This works! The whole topic of flatpack is a complete mystery to me that I'm not sure I have the motivation to unravel. One small error in the code line you sent. The option keyword needs to be preceded with a double dash as follows: flatpak run --command=gnucash-cli org.gnucash.GnuCash --quotes dump and dump requires some arguements. Thanks again. Cheers,doug On Tuesday, July 11, 2023 at 08:30:29 AM GMT-7, Geert Janssens wrote: Hi Doug, For the flatpak edition of gnucash the command to fetch quotes is slightly more complex: flatpak run --command=gnucash-cli org.gnucash.GnuCash -quotes dump This boils down to the following components: - flatpak run org.gnucash.GnuCash => indicate you want to execute a command in the org.gnucash.GnuCash sandbox without any further options, this will run the default command in that sandbox, which is "gnucash" - --command=gnucash-cli => indicate you don't want to run the default command, but gnucash-cli instead - -quotes dump => the arguments to pass to the command to run Regards, Geert Op dinsdag 11 juli 2023 16:13:37 CEST schreef doug brown via gnucash-user: > I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the > terminal commands that I previously used to find sources for quotes on > longer work. Here is the output: doug@sager:~$ gnucash-cli --quotes dump > yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump > -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed > with:sudo apt install gnucash Any thoughts? > > > > ___ > gnucash-user mailing list > gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
[GNC] Finance::Quote terminal commands not working with Flatpack v:5.3 install
I installed via flatpack Gnucash v. 5.3 on Linux Mint v. 20 OS and the terminal commands that I previously used to find sources for quotes on longer work. Here is the output: doug@sager:~$ gnucash-cli --quotes dump yahoo_json QCBMPXgnucash-cli: command not found doug@sager:~$ gnc-fq-dump -v yahoo_json QCBMPXCommand 'gnc-fq-dump' not found, but can be installed with:sudo apt install gnucash Any thoughts? ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Unable to get TIAA-CREF price quotes
Yes. That does work. Although it takes a very long time to get a response from Yahoo. Like three minutes. That may be a function of my slow internet connection. Thank you very much, Dale. Doug On Wednesday, July 5, 2023 at 07:20:02 PM GMT-7, Dale Alspach wrote: Have you tried using Yahoo as JSON to retrieve TIAA prices? This works for all of mine. I don't know about that particular one. Dale On Wed, Jul 5, 2023, 7:06 PM doug brown via gnucash-user wrote: Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56 When I update the price Data Base it fails to retrieve TIAA-CREF quotes. The Security Editor is set up as follows: Running gnc-fq-dump gives the following result: doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote fields Gnucash uses: symbol: QCBMPX (deduced) <=== required date: ** missing ** <=== recommended currency: ** missing ** <=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! Any thoughts? ___ gnucash-user mailing list gnucash-user@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. ___ gnucash-user mailing list gnucash-user@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.
[GNC] Unable to get TIAA-CREF price quotes
Linux Mint v. 20. GNUCASH v. 4.2Finance::Quote v. 1.56 When I update the price Data Base it fails to retrieve TIAA-CREF quotes. The Security Editor is set up as follows: Running gnc-fq-dump gives the following result: doug@sager:~/src/gnucash-5.1$ gnc-fq-dump tiaacref QCBMPXFinance::Quote fields Gnucash uses: symbol: QCBMPX (deduced) <=== required date: ** missing ** <=== recommended currency: ** missing ** <=== required last: **missing** <=\ nav: **missing** <=== one of these price: **missing** <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! Any thoughts? ___ gnucash-user mailing list gnucash-user@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.