Re: [GNC] Security pricing sources

[Murugan Muruganandam]

hi Kalpesh

Yahoo JSON is still working in V6 (refer my earlier email)

if you want to custom build a source, it is very much possible. please follow 
the steps below


Create your own code and name it appropriately (eg yahooscrap.pm)

  1.  Place the  file yahooscrap.pm inside the  following folder

Linux depends on the way it was installed: by package manager:

 /usr/share/perl5/[vendor/]Finance/Quote by CPAN or gnc-fq-update: 
/usr/share/perl5/site/Finance/Quote self compiled: 
/usr/local/share/perl/5.xx.x/Finance

Windows:

C:\Strawberry\perl\site\lib\Finance\Quote

macOS: /Library/Perl/5.xx/Finance/Quote where xx depends on the version of perl 
in use when you installed Finance::Quote. macOS upgrades may require 
reinstallation of Finance::Quote because older version directories are not 
included in @INC.

  1.  To make your file accessible following file needs to be edited to include 
the line "yahooscrap"

Windows: C:\Strawberry\perl\site\lib\Finance\Quote.pm

add yahooscrap inside the modules block

@MODULES =



Now go to security editor and use unknown as type of quote source and 
yahooscrap will be visible to be picked up. Save and now run the get quote




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Kalpesh Patel 
Sent: Thursday, May 11, 2023 6:01 PM
To: gnucash-user@gnucash.org 
Subject: [GNC] Security pricing sources

As most of you know yahoo_json has gone broken which IMHO was really the
only free source for people like me who just needed end-of-day prices. While
I've gotten around to it with able to gather the data via custom Python
script and import it in, I like to directly integrate and interface with the
GNC to pull prices from the web scraping Yahoo. I noticed that there is not
a "custom" source I can specify for price download, in additional to many of
them greyed out (Vanguard source would have been great as quite a number of
mutual funds I track are with them).  So two question, how easy is it for
someone who is somewhat familiar with programming to directly wire-up and
interface with it and how can the greyed out sources be enabled? I am on
Windows 11 with 4.14 GNC but willing to tackle on 5.x version.



Thanks.

___
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.

Re: [GNC] Security pricing sources

[Murugan Muruganandam]

David

you can find the YahooJSON file in the following path in Windows. as David H 
had earlier clarified, make the file readable and then make the change for V7 
to V6.  i have attached a sample file

C:\Strawberry\perl\site\lib\Finance\Quote\YahooJSON.pm




Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
David Carlson 
Sent: Thursday, May 11, 2023 6:22 PM
To: Kalpesh Patel 
Cc: gnucash-user@gnucash.org 
Subject: Re: [GNC] Security pricing sources

I forgot to qualify my comment with the fact that I do not know how to find
and edit that YahooJSON.pm file in Windows 10 or 11.

On Thu, May 11, 2023 at 5:17 PM David Carlson 
wrote:

> Kalpesh,
>
> I cannot speak to your specific question, but I can report that I am
> running GnuCash 4.8 in Ubuntu 22.04, and I was able to successfully find
> and edit the YahooJSON.pm file (as root) per Bruce Schuck's instructions in
> the "...throwing unauthorized error" thread of this maillist.  Doing that
> restores functionality of the Finance:Quote module within GnuCash.
>
> On Thu, May 11, 2023 at 5:02 PM Kalpesh Patel 
> wrote:
>
>> As most of you know yahoo_json has gone broken which IMHO was really the
>> only free source for people like me who just needed end-of-day prices.
>> While
>> I've gotten around to it with able to gather the data via custom Python
>> script and import it in, I like to directly integrate and interface with
>> the
>> GNC to pull prices from the web scraping Yahoo. I noticed that there is
>> not
>> a "custom" source I can specify for price download, in additional to many
>> of
>> them greyed out (Vanguard source would have been great as quite a number
>> of
>> mutual funds I track are with them).  So two question, how easy is it for
>> someone who is somewhat familiar with programming to directly wire-up and
>> interface with it and how can the greyed out sources be enabled? I am on
>> Windows 11 with 4.14 GNC but willing to tackle on 5.x version.
>>
>>
>>
>> Thanks.
>>
>> ___
>> 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.
>>
>
>
> --
> David Carlson
>


--
David Carlson
___
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.


YahooJSON.pm
Description: YahooJSON.pm
___
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] Bank statement

[David Carlson]

James,

Please include  in your reply so others can
participate in the discussion.

If you think that the bank is not providing the correct information on the
statement, you need to take that up with them, not us.

On Thu, May 11, 2023 at 7:30 PM James Baxter  wrote:

> David Carlson
> I have all in the Account (Gnucash) is all checks out. But it shows it
> wrong. They are charged me a service charge but they don't show that. The
> on line report shows two starting and two ending. I run both of them and I
> get two different answers.
> Hope this makes cents
>
> Thanks
> James Baxter
>
> Sent from Yahoo Mail on Android
> 
>
> On Thu, May 11, 2023 at 7:56 PM, David Carlson
>  wrote:
> How, exactly, did the bank give you a starting amount?  If you already
> have each item in the statement entered into GnuCash, which ones don't
> balance, and how do you know that.  Are you running a report?
>
> On Thu, May 11, 2023 at 6:39 PM James Baxter via gnucash-user <
> gnucash-user@gnucash.org> wrote:
>
> As I ask a question to do with reconcile a bank statement.
> The bank gives me the starting amount,  but this is given to me, two ways.
> Why. I don't know. I have all the items in the Gnucash. But it won't
> balance.
> ThanksJames Baxter P.s. I may not have given you enough info
>
> Sent from Yahoo Mail on Android
>
> ___
> 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.
>
>
>
> --
> David Carlson
>
>

-- 
David Carlson
___
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] Bank statement

[David Cousens]

James,

Your bank statement should have the following identifiable information

Opening balance at the start of the period of the statement

Closing Balance at the closing date of the statement period.

List of transactions which are included in the statement which will sum to the
difference between the opening and closing balances. Some will be debits and
some credits and it is the difference between the sum of the credits and the sum
of the debits which will equal the difference between opening and closing
balances.

Your records for the same period may not be identical to the bank's. You will
record transactions at a date/time which is relevant to you. The bank may record
the same event at a different date and time, e.g. when funds are cleared to them
from another bank for example. 

The process of reconciliation consist of identifying the transactions in the
bank's statement in your own records and then ensuring that your opening
balance, closing balance and difference in the sum of debits   and credits of
the transactions in the period of the bank's statement are present in your
records but not necessarily at exactly the same date and time. Some in your
records may be outside the  period as defined in the bank's statement.

You say the bank supplies two forms of the statement? Often banks may provide
access to downloadable transaction records in OFX or CSV or other formats for
example, but this is not a statement. It is provided for convenience and as one
means to enter data into your records.  A statement however is usually a written
record and is usually delivered as a signed paper copy or an emailed PDF copy.

Hope this helps make reconciliation a bit clearer for you

David Cousens

On Thu, 2023-05-11 at 23:38 +, James Baxter via gnucash-user wrote:
> As I ask a question to do with reconcile a bank statement. 
> The bank gives me the starting amount,  but this is given to me, two ways.
> Why. I don't know. I have all the items in the Gnucash. But it won't balance. 
> ThanksJames Baxter P.s. I may not have given you enough info
> 
> Sent from Yahoo Mail on Android
> ___
> 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.

Re: [GNC] Bank statement

[David Carlson]

How, exactly, did the bank give you a starting amount?  If you already have
each item in the statement entered into GnuCash, which ones don't balance,
and how do you know that.  Are you running a report?

On Thu, May 11, 2023 at 6:39 PM James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> As I ask a question to do with reconcile a bank statement.
> The bank gives me the starting amount,  but this is given to me, two ways.
> Why. I don't know. I have all the items in the Gnucash. But it won't
> balance.
> ThanksJames Baxter P.s. I may not have given you enough info
>
> Sent from Yahoo Mail on Android
> ___
> 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.
>


-- 
David Carlson
___
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] Bank statement

[James Baxter via gnucash-user]

As I ask a question to do with reconcile a bank statement. 
The bank gives me the starting amount,  but this is given to me, two ways. Why. 
I don't know. I have all the items in the Gnucash. But it won't balance. 
ThanksJames Baxter P.s. I may not have given you enough info

Sent from Yahoo Mail on Android
___
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] Security pricing sources

[john]

Kalpesh,

The modules that show up in the securities editor are hard-coded and have 
gotten seriously out of sync with F::Q's modules. Vincent Lucarrelli has begun 
https://github.com/Gnucash/gnucash/pull/1626 to create the list more 
dynamically.

The easiest place to hack is libgnucash/quotes/finance-quote-wrapper. It's a 
perl module that shims between Finance::Quote and GnuCash. The best place is 
F::Q itself: Write a new module implementing the functions Quote.pm needs and 
add it to the modules list in Quote.pm. If you happen to name it to match one 
of the no longer supported names in libgnucash/engine/gnc-commodity.c then 
GnuCash will enable that checkbox in the security editor.

Regards,
John Ralls


> On May 11, 2023, at 3:01 PM, Kalpesh Patel  wrote:
> 
> As most of you know yahoo_json has gone broken which IMHO was really the
> only free source for people like me who just needed end-of-day prices. While
> I've gotten around to it with able to gather the data via custom Python
> script and import it in, I like to directly integrate and interface with the
> GNC to pull prices from the web scraping Yahoo. I noticed that there is not
> a "custom" source I can specify for price download, in additional to many of
> them greyed out (Vanguard source would have been great as quite a number of
> mutual funds I track are with them).  So two question, how easy is it for
> someone who is somewhat familiar with programming to directly wire-up and
> interface with it and how can the greyed out sources be enabled? I am on
> Windows 11 with 4.14 GNC but willing to tackle on 5.x version.
> 
> 
> 
> Thanks.
> 
> ___
> 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.

Re: [GNC] Security pricing sources

[David Carlson]

I forgot to qualify my comment with the fact that I do not know how to find
and edit that YahooJSON.pm file in Windows 10 or 11.

On Thu, May 11, 2023 at 5:17 PM David Carlson 
wrote:

> Kalpesh,
>
> I cannot speak to your specific question, but I can report that I am
> running GnuCash 4.8 in Ubuntu 22.04, and I was able to successfully find
> and edit the YahooJSON.pm file (as root) per Bruce Schuck's instructions in
> the "...throwing unauthorized error" thread of this maillist.  Doing that
> restores functionality of the Finance:Quote module within GnuCash.
>
> On Thu, May 11, 2023 at 5:02 PM Kalpesh Patel 
> wrote:
>
>> As most of you know yahoo_json has gone broken which IMHO was really the
>> only free source for people like me who just needed end-of-day prices.
>> While
>> I've gotten around to it with able to gather the data via custom Python
>> script and import it in, I like to directly integrate and interface with
>> the
>> GNC to pull prices from the web scraping Yahoo. I noticed that there is
>> not
>> a "custom" source I can specify for price download, in additional to many
>> of
>> them greyed out (Vanguard source would have been great as quite a number
>> of
>> mutual funds I track are with them).  So two question, how easy is it for
>> someone who is somewhat familiar with programming to directly wire-up and
>> interface with it and how can the greyed out sources be enabled? I am on
>> Windows 11 with 4.14 GNC but willing to tackle on 5.x version.
>>
>>
>>
>> Thanks.
>>
>> ___
>> 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.
>>
>
>
> --
> David Carlson
>


-- 
David Carlson
___
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] Security pricing sources

[David Carlson]

Kalpesh,

I cannot speak to your specific question, but I can report that I am
running GnuCash 4.8 in Ubuntu 22.04, and I was able to successfully find
and edit the YahooJSON.pm file (as root) per Bruce Schuck's instructions in
the "...throwing unauthorized error" thread of this maillist.  Doing that
restores functionality of the Finance:Quote module within GnuCash.

On Thu, May 11, 2023 at 5:02 PM Kalpesh Patel  wrote:

> As most of you know yahoo_json has gone broken which IMHO was really the
> only free source for people like me who just needed end-of-day prices.
> While
> I've gotten around to it with able to gather the data via custom Python
> script and import it in, I like to directly integrate and interface with
> the
> GNC to pull prices from the web scraping Yahoo. I noticed that there is not
> a "custom" source I can specify for price download, in additional to many
> of
> them greyed out (Vanguard source would have been great as quite a number of
> mutual funds I track are with them).  So two question, how easy is it for
> someone who is somewhat familiar with programming to directly wire-up and
> interface with it and how can the greyed out sources be enabled? I am on
> Windows 11 with 4.14 GNC but willing to tackle on 5.x version.
>
>
>
> Thanks.
>
> ___
> 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.
>


-- 
David Carlson
___
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] Finance:Quote again [sorry]

[Bruce Schuck]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 5/11/23 14:06 PM, David Carlson 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-around, 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.

Those familiar with using CPAN can install the latest pre-release 
BPSCHUCK/Finance-Quote-1.54_04.tar.gz.


I hope to finish up some release related housekeeping and push F::Q 
v1.55 to CPAN this weekend.


- - Bruce S.
-BEGIN PGP SIGNATURE-
Comment: GPGTools - http://gpgtools.org

iHkEARECADkWIQRzL0H5rBaeDPnpeL1IjAeprJFQBwUCZF1nDRscYnNjaHVja0Bh
c2dhcmQtc3lzdGVtcy5jb20ACgkQSIwHqayRUAca5wCfZ1i/Z2s3OEvX5YwS/eyM
n64OFcMAoJddFolSDcewW2HMy7+l9iG60vj2
=C6JS
-END PGP SIGNATURE-
___
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] Security pricing sources

[Kalpesh Patel]

As most of you know yahoo_json has gone broken which IMHO was really the
only free source for people like me who just needed end-of-day prices. While
I've gotten around to it with able to gather the data via custom Python
script and import it in, I like to directly integrate and interface with the
GNC to pull prices from the web scraping Yahoo. I noticed that there is not
a "custom" source I can specify for price download, in additional to many of
them greyed out (Vanguard source would have been great as quite a number of
mutual funds I track are with them).  So two question, how easy is it for
someone who is somewhat familiar with programming to directly wire-up and
interface with it and how can the greyed out sources be enabled? I am on
Windows 11 with 4.14 GNC but willing to tackle on 5.x version.

 

Thanks.

___
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] Finance:Quote again [sorry]

[Kalpesh Patel]

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  
Sent: Thursday, May 11, 2023 5:14 PM
To: David Carlson 
Cc: Geert Janssens ; Kalpesh Patel 
; gnucash-user@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 mailto:david.carlson@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 mailto:geert.gnuc...@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
> > dbrei...@icloud.com  
> >
> > > On May 11, 2023, at 12:55 PM, Kalpesh Patel  > >  >
> 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 mailto:graham.ba...@gmail.com> >
> > > Sent: Thursday, May 11, 2023 11:49 AM
> > > To: gnucash-user@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@gnucash.org  
> To update your 

Re: [GNC] Finance:Quote again [sorry]

[David H]

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 
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  >
> 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
> > > dbrei...@icloud.com
> > >
> > > > On May 11, 2023, at 12:55 PM, Kalpesh Patel 
> > 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 
> > > > Sent: Thursday, May 11, 2023 11:49 AM
> > > > To: gnucash-user@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@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@gnucash.org
> To update your subscription preferences or 

Re: [GNC] Finance:Quote again [sorry]

[Murugan Muruganandam]

Graham

The new command line query looks like this below, try to run it from a command 
prompt and see if it is working

Go to the following folder
C:\Program Files (x86)\gnucash\bin

execute the following query
gnucash-cli.exe --verbose -Q dump yahoo_json acn


if you are successful, then the installation is working fine

Check the securities editor screen and make sure yahoo json is enabled. Run Get 
quotes and let us know what error you are getting





Saludos Cordiales


Murugan


From: gnucash-user 
 on behalf of 
Graham 
Sent: Thursday, May 11, 2023 11:48 AM
To: gnucash-user@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

--
--
Cheerio,

Graham
___
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] Auto commit with auto save?

[David G. Pickett via gnucash-user]

An alternative proposal is to create data elements to allow auto-saving of both 
the modified and unmodified transaction of uncommitted changes, so if the file 
is reloaded, the uncommitted state is restored as it was at the time of the 
save.  Then auto save would ensure these uncommitted transactions are saved as 
uncommitted, for future discovery after a file load on a *manual* save or 
graceful interactive exit with save warnings.
___
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] from James Baxter to do with bank charge

[Jim DeLaHunt]

Hello, James Baxter:

On 2023-05-11 10:55, James Baxter via gnucash-user wrote:

As I am James Baxter, email address is kangaro...@yahoo.com.  I am looking at 
the bank statement and have a bank service charge. It is not listen in the 
statement. as I must be charded for it. So when I add it to the line. it dont 
seen to work.I am looking to use the screen that said is there a bank interset. 
 I tsaid you cant send it to the same account.  it is coming up with credit to 
credit. so that dont work for me.

HelpJames Baxter


I am confident that people on this list would like to help, but it is 
not clear to me what you mean in your message.


1. You included a screen grab, which helpful, but the most interesting 
part of the GnuCash UI in the image is obscured by a file save dialogue. 
It will help for you to redo the screen grab, but make sure there is no 
file save dialogue in the image, just GnuCash UI.


2. You say, "I am looking at the bank statement", but it appears from 
the screen grab that you are working with a credit card account. In 
GnuCash, accounts related to credit cards behave differently in some 
important ways from accounts related to bank savings and chequing 
accounts.  Is the statement you are describing a bank account statement 
or a credit card statement.


3. You say, "…have a bank service charge. It is not listen in the 
statement. as I must be charded for it." I believe that when you say 
"it" here, you mean the bank service charge.  Are you saying that there 
is a bank service charge, and that the bank service charge is not listed 
in the statement, and the reason that the charge is not listed is that 
you must be charged for the bank service charge?  I don't understand 
what you mean. Maybe try rewording your situation without using the word 
"it". That will help you be more explicit in describing your situation.


4. You say, "…I am looking to use the screen that said is there a bank 
interset." When you say "the screen", I think you mean a dialogue box in 
the GnuCash UI, but I don't know which dialogue box you are referring 
to. Dialogue boxes have a title at the top. It would perhaps be clearer 
if you would use that title in your explanation.


5. You say, "…I tsaid you cant send it to the same account.  it is 
coming up with credit to credit." You are using the word "it" three 
times there. I am not sure what you are referring to with the word "it". 
I suspect that you are referring to different things each time you 
re-use the word "it". Again, maybe try rewording your situation without 
using the word "it".


I hope this is helpful to you in making your situation understood, and 
getting assistance from someone on this list.


Best regards,
    —Jim DeLaHunt

___
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] from James Baxter to do with bank charge

[Steve Butler]

Hey James, maybe I am not understanding your question.  To me, this appears
to be a bank service charge of some sort.  That would be an expense to you
so you need a expense account for that other side.

Do you want to track different types of bank service charges?  Such as:
Monthly service charge.
Overdraft service charge.
Statement charge (yup my bank now charges if I get paper statements).
Wire transfer fee.

If so, set these all up as children to the Bank Fees parent expense account.

If not, just set up a single Bank service charge expense account and use
that for all the different service charges.

They are all an expense that you pay.

On Thu, May 11, 2023, 10:57 James Baxter via gnucash-user <
gnucash-user@gnucash.org> wrote:

> As I am James Baxter, email address is kangaro...@yahoo.com.  I am
> looking at the bank statement and have a bank service charge. It is not
> listen in the statement. as I must be charded for it. So when I add it to
> the line. it dont seen to work.I am looking to use the screen that said is
> there a bank interset.  I tsaid you cant send it to the same account.  it
> is coming up with credit to credit. so that dont work for me.
>
> HelpJames Baxter
> ___
> 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.

Re: [GNC] Finance:Quote again [sorry]

[David Carlson]

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 
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
> > dbrei...@icloud.com
> >
> > > On May 11, 2023, at 12:55 PM, Kalpesh Patel 
> 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 
> > > Sent: Thursday, May 11, 2023 11:49 AM
> > > To: gnucash-user@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@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@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] Finance:Quote again [sorry]

[Geert Janssens]

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
> dbrei...@icloud.com
> 
> > On May 11, 2023, at 12:55 PM, Kalpesh Patel  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 
> > Sent: Thursday, May 11, 2023 11:49 AM
> > To: gnucash-user@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@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] Finance:Quote again [sorry]

[David Reiser via gnucash-user]

except that there is no gnc-fq-check in gnucash 5
--
Dave Reiser
dbrei...@icloud.com





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

Re: [GNC] Finance:Quote again [sorry]

[Kalpesh Patel]

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  
Sent: Thursday, May 11, 2023 11:49 AM
To: gnucash-user@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

--
--
Cheerio,

Graham

___
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] Finance:Quote again [sorry]

[Fred Bone]

On 11 May 2023 at 16:48, Graham said:

> 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.

The first thing you need to mention when asking for support for ANY piece 
of software is the version you are using ...

(And the OS, but as you mentioned Windows in passing people can take an 
educated guess).



___
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] Auto commit with auto save?

[David T. via gnucash-user]

As for missed threads, I've taken to opening the message queue on the mail 
server directly before I reply, just to be sure I'm replying with useful 
information...
⁣
David T.​

On May 11, 2023, 07:20, at 07:20, Adrien Monteleone 
 wrote:
>David,
>
>I didn't notice when I replied, that this thread broke (at least for
>me) 
>and there were more detailed replies.
>
>Now that I see what the OP was encountering, I agree, SQL won't be a 
>solution for anything not committed.
>
>Other than this special case, I'm not sure it would be a good idea to 
>auto-save uncommitted transactions. (especially if they don't balance 
>yet) I'd hazard some folks rely on that current behavior.
>
>I do agree some sort of visual indication as to which open registers 
>have uncommitted transactions would be helpful, as would the warning 
>message being more specific to avoid a guessing game.
>
>And certainly, the OPs original goal might be better implemented within
>
>the GUI so as to avoid the issue entirely, as it seems the cron job is
>a 
>work around. (thus it seems the problem isn't not auto-saving or 
>auto-committing transactions on exit, but rather the lack of ability to
>
>schedule price updates)
>
>Regards,
>Adrien
>
>On 5/10/23 11:02 PM, David T. via gnucash-user wrote:
>> Adrien,
>> 
>> The issue as stated is specifically the loss of an uncommitted
>transaction, so an SQL back end won't help with that. If, however, that
>open transaction prevents an entire session from being saved, then your
>suggestion merits attention. I personally don't know about that,
>though; the OP didn't mention.
>> 
>> ⁣David T. ​
>
>___
>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.

Re: [GNC] Customer invoice appearance

[Michael or Penny Novack]

On 5/10/2023 11:23 PM, Adrien Monteleone wrote:

All reports can be styled with CSS. (they are simply HTML tables)

You can set up a custom stylesheet and assign it as the default.

You won't be able to re-order elements in the file itself, but you 
could maybe use some CSS positioning rules to gain a bit of flexibility.


If that doesn't get far enough, you'd have to write your own invoice 
report in Scheme.


As for sharing, there's this list, the Using GnuCash page on the Wiki, 
and of course, a PR to get it included in a subsequent release.


Regards,
Adrien 


But --- one solution is to do things like "pretty printing" outside of 
gnucash. Instead of sending the output from gnucash directly to the 
printer, have the output be a file that then goes though a batch editing 
program before finally going to the printer. That gives you complete 
freedom.


The final edit can use a "compositor" program to get really fancy output.

You can respond quicker fixing things like the exact position of the 
name and address << your new box of window envelopes has the window in a 
slightly different position >>


Michael D Novack


___
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.