Re: [GNC] Categories list to setup New Account Hierarchy

2021-05-17 Thread Frank H. Ellenberger
Hi, Am 18.05.21 um 06:42 schrieb Pankaj Jangid: > Mukesh K writes: > >> Derak, Thanks. >> >> I have been using GNUCash for my personal finance for over 10 years. I will >> refine it and then submit. Please advise how to submit (donate) it. >> I am building another one for small business in

Re: [GNC] Categories list to setup New Account Hierarchy

2021-05-17 Thread Pankaj Jangid
Mukesh K writes: > Derak, Thanks. > > I have been using GNUCash for my personal finance for over 10 years. I will > refine it and then submit. Please advise how to submit (donate) it. > I am building another one for small business in services segment. Once this > is matured , will submit it as

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread mike823
Thank you. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] CSV matching produces duplicates?

2021-05-17 Thread flywire
Original post about turning off Bayesian matching prompts: flywire wrote > It's not that hard to match most transactions and add accounts using a > spreadsheet or other tool leaving the rest for manual confirmation. It > would be reasonable to have a setting so they could be imported straight >

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Robin Chattopadhyay
Here's the file; I think the attachment should pass through, the input CSV has no headers and comma separated values in order below: Example: Mnemonic, Price, Price Date (-mm-dd), Namespace, Currency Code "94986H103",62.8194,2021-05-14,"401K","USD" It works for me, in lines 10-12, you can

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Jack Frillman via gnucash-user
And I wrote a Python scripts and a BASH script that scrapes the prices off of the webpage and creates csv file. On 5/17/21 5:28 PM, Robin Chattopadhyay wrote: I have a Python script that I've created that takes in a CSV file and loads the prices into Gnucash. I would be willing to share it; I

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread mike823
I use a SQLite backend and I would love to test your script. Could you email it to me? Thanks. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your

Re: [GNC] CSV matching produces duplicates?

2021-05-17 Thread David Cousens
It is true in that particular case of yours that the internal account and the name it is mapped to are the same. The difficulty is that the importer has to be able to cope with situations where "Assets:Cheque" in the external record may not necessarily be mapped onto the Assets:Cheque internal

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread Robin Chattopadhyay
I have a Python script that I've created that takes in a CSV file and loads the prices into Gnucash. I would be willing to share it; I know it works with the SQLite backend, I haven't tested it with any other backend. Robin On Mon, May 17, 2021 at 6:59 AM mike823 wrote: > I might do it. I am

Re: [GNC] Online quotes for a mutual fund

2021-05-17 Thread jacob
On 2021-05-17 21:29, ja...@larsen.net wrote: This suggests that the issue is with my setup and not the sources as such. Some more googling finally found me this one: http://gnucash.1415818.n4.nabble.com/GNC-Finance-Quote-sort-of-works-almost-td4724226.html So it turns out that I need to

Re: [GNC] Online quotes for a mutual fund

2021-05-17 Thread jacob
On 2021-05-17 02:53, Geoff wrote: It looks like the Financial Times' Funds service will provide prices: Thanks for checking this. I get this for the same command, but verbose: $ gnc-fq-dump -v ftfunds SE0005993078 Finance::Quote fields Gnucash uses: symbol: SE0005993078 <===

Re: [GNC] Cash Flow Report has incorrect values

2021-05-17 Thread Howard M. Fried
I can't say that I understand the circle thing, but the P Report looks correct. I also keep an Excel spread sheet just for Sales by year, and it's total for this year is slightly different from the P Report. I've probably made an error somewhere. Many thanks, Howard On 5/17/21 12:49 PM,

Re: [GNC] Cash Flow Report has incorrect values

2021-05-17 Thread Derek Atkins
The "Cash Flow" report probably is not what you really want. What that report does is allows you to draw a circle around a set of accounts and it will summarize all the transactions that cross that boundary. Any transaction fully inside the circle or fully outside the circle is ignored. Most

[GNC] Cash Flow Report has incorrect values

2021-05-17 Thread Howard M. Fried
Hello, My Cash Flow Report for 01/01/2021-12/31/2012 (or 01/01/2021-Today) shows wildly incorrect values, specifically the "Money In" and "Accounts Receivable" amounts. For example, in the complete Account display, Accounts Receivable shows X (which is correct). But in the Report, it shows

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread John Ralls
> On May 17, 2021, at 4:58 AM, mike823 wrote: > > I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code > bellow in Gnucash::GnucashCli::start . Is another developer already working > on the same functionality? > > > >if (m_quotes_cmd) >{ >if

Re: [GNC] gnucash-cli --quotes get

2021-05-17 Thread mike823
I might do it. I am looking in gnucash/gnucash-cli.cpp and I see the code bellow in Gnucash::GnucashCli::start . Is another developer already working on the same functionality? if (m_quotes_cmd) { if (*m_quotes_cmd != "get") { std::cerr << bl::format

Re: [GNC] CSV matching produces duplicates?

2021-05-17 Thread David Carlson
I can't read that file on my smartphone, but what are we supposed to do with it? Ask our bankers to change their csv format to match it? On Mon, May 17, 2021, 5:32 AM flywire wrote: > Sample account that shouldn't need manual matching: > > < >

Re: [GNC] CSV matching produces duplicates?

2021-05-17 Thread flywire
Sample account that shouldn't need manual matching: -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list