Re: [GNC] Transaction Report Sign Reverses

2019-08-11 Thread Adrien Monteleone
David, Try Display > Amount > Double (default is ’Single’) I’m not sure why this works when both debit & credit columns are visible, and not when only the credit column is visible, but it does. I have my Global preference for Sign Reverses set to ‘Credit Accounts’ and I set the report to

Re: [GNC] Transaction Report Sign Reverses

2019-08-11 Thread Christopher Lam
https://wiki.gnucash.org/wiki/FAQ#Q:_Why_does_the_Transaction_Report_.27Sign_Reversal.27_setting_not_work_on_subtotals This issue could be fixed if the scenario addressed in this FAQ can be resolved. I don't really know how to handle that particular case. On Mon., 12 Aug. 2019, 13:02 David T.

[GNC] Transaction Report Sign Reverses

2019-08-11 Thread David T. via gnucash-user
Hello, I am trying to create a YTD Capital Gains report, and am encountering a problem with how the Transaction Report implements the Sign Reverses setting. I recall some time back a discussion about the fact that the Sign Reverses setting reverses signs in these reports in a confusing way.

Re: [GNC] journal entries

2019-08-11 Thread David Cousens via gnucash-user
Harald, The following section in the GnuCash help manual gives the details of creating a transaction entry in GnuCash (https://www.gnucash.org/docs/v3/C/gnucash-help/trans-enter.html). It assumes that you have the register (table of transactions for a specific account) open. You can do this in

[GNC] Windows Report Options Dialog Setting

2019-08-11 Thread David T. via gnucash-user
Hello, GnuCash 3.5 on Windows 10. I have discovered a UI problem that I believe to be a bug. It appears that if a user maximizes the Options dialog for a report, and then saves the options by clicking OK, the maximized window size becomes the default options window size from that point

Re: [GNC] journal entries

2019-08-11 Thread Harold via gnucash-user
I have looked but didn't see an explanation that I could understand. On Aug 11, 2019, 5:15 PM, at 5:15 PM, John Ralls wrote: > > >> On Aug 11, 2019, at 11:56 AM, Harold via gnucash-user > wrote: >> >> I want to start tracking the cash payments that I make for drugs. I >have been searching about

Re: [GNC] journal entries

2019-08-11 Thread John Ralls
> On Aug 11, 2019, at 11:56 AM, Harold via gnucash-user > wrote: > > I want to start tracking the cash payments that I make for drugs. I have been > searching about making a journal entry in Gnucash but haven't found anything > yet. Where do I find how to enter a journal entry in Gnucash

[GNC] journal entries

2019-08-11 Thread Harold via gnucash-user
I want to start tracking the cash payments that I make for drugs. I have been searching about making a journal entry in Gnucash but haven't found anything yet. Where do I find how to enter a journal entry in Gnucash using Linux? ___ gnucash-user

Re: [GNC] Importing FX rates into gnucash

2019-08-11 Thread Jeff Abrahamson
Aha, thanks! Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 11/08/2019 19:55, John Ralls wrote: > >> On Aug 11, 2019, at 10:37 AM, Jeff Abrahamson wrote: >> >> I have a table of historic FX rates I'd like to import into gnucash. I >> don't see how to do this inside

Re: [GNC] FX fetching strangeness

2019-08-11 Thread Jeff Abrahamson
Ah, that works, thanks.  Although within gnucash I'm now able to update USD, CHF, and GBP against EUR but JPY gives an error (Get Quote -> "Unable to retrieve quotes for these items: ... Continue using only the good quotes?"). I read that I am limited to 5 quote per minute, this would be three

Re: [GNC] Importing FX rates into gnucash

2019-08-11 Thread John Ralls
> On Aug 11, 2019, at 10:37 AM, Jeff Abrahamson wrote: > > I have a table of historic FX rates I'd like to import into gnucash. I > don't see how to do this inside gnucash, and googling about and reading > the docs I don't see mention of it. Is this possible? Or is there a > work-around?

Re: [GNC] FX fetching strangeness

2019-08-11 Thread John Ralls
The "alphavantage" source is for stock quotes. To retrieve currency exchange rates use "currency": gnc-fq-dump currency EUR JPY 1 EUR = 118.31 JPY That's hard-coded inside of Finance::Quote to use alphavantage and so requires an API key. Regards, John Ralls > On Aug 11, 2019, at 10:35 AM,

Re: [GNC] Get online quote for Canada Fund

2019-08-11 Thread Kaman Wu
thanks a lot. I will try it. On Sun, Aug 11, 2019 at 1:40 PM Ove Grunnér wrote: > I was looking at the code in cpan, and it looks like the module is using > this base url > > http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2= > > and then adding the code after it, e.g. >

Re: [GNC] Get online quote for Canada Fund

2019-08-11 Thread Ove Grunnér
I was looking at the code in cpan, and it looks like the module is using this base url http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2= and then adding the code after it, e.g. http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743 however when trying this url, I get Error 404, unknown

[GNC] Importing FX rates into gnucash

2019-08-11 Thread Jeff Abrahamson
I have a table of historic FX rates I'd like to import into gnucash.  I don't see how to do this inside gnucash, and googling about and reading the docs I don't see mention of it.  Is this possible?  Or is there a work-around?  (I'm using the sqlite backend, if that matters, which I hope it

Re: [GNC] FX fetching strangeness

2019-08-11 Thread Jeff Abrahamson
Somewhat related, the Alphavantage docs as well as gnucash itself suggest that Yen is JPY.  And yet jeff@birdsong:~ $ gnc-fq-dump alphavantage EUR JPY Finance::Quote fields Gnucash uses:     symbol: EUR (deduced)    <=== required   date: ** missing **    <===

Re: [GNC] FX fetching strangeness

2019-08-11 Thread Jeff Abrahamson
That was it.  Thanks. I've also filed this: https://bugs.gnucash.org/show_bug.cgi?id=797343 Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 04/08/2019 21:39, John Ralls wrote: > Do you have an Alphavantage key set in $ALPHAVANTAGE_API_KEY (for command > line tools

Re: [GNC] Price in Register Account report not decimal

2019-08-11 Thread John Ralls
That preference is for the GUI. I don't think that it has any affect on reports. I can reproduce this, where a price for 5712 shares has a value of 85,505.78 and is represented as 14.9695 in the register but as 14 + 276889/285600 on the Account Report. I don't think that there's an immediate

Re: [GNC] Get online quote for Canada Fund

2019-08-11 Thread Kaman Wu
Hello Ove, Thanks for reply my question. I did try "1743". Still get the same error message. I really need solve the problem, otherwise, I have to manually input the price for all funds I have. PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary 1743 Finance::Quote

Re: [GNC] Setting up a new accounting scheme in GnuCash

2019-08-11 Thread Frank ter Braak
Together with alle the previous posts this final explanation helped a lot. I finally feel equipped to start building my own scheme or know where to add my own accounts to the existing logic of GnuCash. Thanks to Frank, Adrien, David and Liz! > Op 9 aug. 2019, om 12:38 heeft David Cousens het

Re: [GNC] Get online quote for Canada Fund

2019-08-11 Thread Ove Grunnér
Hi Kaman, according to https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary "This module uses an id that represents the mutual fund on an id used by www.fundlibrary.com. There is no easy way of fetching the id except to jump onto the fundlibrary website, look up the fund and view the url for

Re: [GNC] Price in Register Account report not decimal

2019-08-11 Thread Joe Normandeau
Colin Yep Build ID: 3.6 + (2019-06-29) JoeCanuck On 11/08/2019 5:36 pm, Colin Law wrote: On Sun, 11 Aug 2019 at 07:00, Joe Normandeau wrote: Apologies Adrien I should have stated that flag is already turned on and I've cycled it number of times and it makes no difference to the Register

Re: [GNC] Price in Register Account report not decimal

2019-08-11 Thread Colin Law
On Sun, 11 Aug 2019 at 07:00, Joe Normandeau wrote: > > Apologies Adrien > > I should have stated that flag is already turned on and I've cycled it > number of times and it makes no difference to the Register Account Report. Have you tried that again since you upgraded to 3.6? Also are you sure