Re: [GNC] Security pricing sources

2023-05-11 Thread 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

Re: [GNC] Security pricing sources

2023-05-11 Thread 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

Re: [GNC] Bank statement

2023-05-11 Thread 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

Re: [GNC] Bank statement

2023-05-11 Thread 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

Re: [GNC] Bank statement

2023-05-11 Thread 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>

[GNC] Bank statement

2023-05-11 Thread 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

Re: [GNC] Security pricing sources

2023-05-11 Thread 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

Re: [GNC] Security pricing sources

2023-05-11 Thread 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

Re: [GNC] Security pricing sources

2023-05-11 Thread 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

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

2023-05-11 Thread 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 >

[GNC] Security pricing sources

2023-05-11 Thread 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

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

2023-05-11 Thread 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 ;

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

2023-05-11 Thread 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

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

2023-05-11 Thread 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

Re: [GNC] Auto commit with auto save?

2023-05-11 Thread 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

Re: [GNC] from James Baxter to do with bank charge

2023-05-11 Thread 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

Re: [GNC] from James Baxter to do with bank charge

2023-05-11 Thread 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.

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

2023-05-11 Thread 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

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

2023-05-11 Thread 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

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

2023-05-11 Thread 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 >

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

2023-05-11 Thread 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

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

2023-05-11 Thread 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

Re: [GNC] Auto commit with auto save?

2023-05-11 Thread 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

Re: [GNC] Customer invoice appearance

2023-05-11 Thread 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