Re: [GNC] Transaction Report Sign Reverses
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 ‘Global Preference’. Regards, Adrien > On Aug 12, 2019, at 12:00 AM, David T. via gnucash-user > wrote: > > 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. There was some > discussion about reversing the individual transactions but not the totals. > Although I do not recall the specifics of the discussion, I am encountering > the same situation now, where the transactions themselves respect the user > setting, but the totals do not. To say this is confusing is an understatement. > > It seems to me that other financial applications must have encountered the > problem of displaying income to users as a positive value (since that is how > most of us view income!) while still finding a way to display the correct > accounting information. > > To display my YTD report of Capital Gains, I ran a Transaction Report and > selected the Income:Realized Gains accounts for the current year. The result > shows losses as positive numbers, and gains as negative. I don't know about > you, but my expectation is reversed from this. If I change the Sign Reverses > setting to Income and Expense, then the transactions switch, but the totals > do not. This result was the gist of the discussion in an earlier thread. > Bleah! > > Now, I know that I can copy the data, paste it into another program and > change all the settings to my heart's content, but I am looking for a way to > run a report in GnuCash that directly and unambiguously shows me whether I > have gained money (a positive) or lost it (a negative) over the current year. > Does anyone have suggestions? > > FWIW, I attempted to turn this report around and have a report that lists > transactions in the asset accounts, filtered by the Income:Realized Gains > accounts, but that seems to report only the Asset account currency--in this > case, the mutual fund or stock shares involved on the Gain/Loss transaction. > Unfortunately, that's not the actual Gain/Loss value... > > It would be nice if the sign reverses setting could be fixed. Barring that, > does anyone have a workaround report setup that can give me a sensible YTD > Capital Gains total as described? > > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction Report Sign Reverses
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. via gnucash-user, < gnucash-user@gnucash.org> wrote: > 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. > There was some discussion about reversing the individual transactions > but not the totals. Although I do not recall the specifics of the > discussion, I am encountering the same situation now, where the > transactions themselves respect the user setting, but the totals do not. > To say this is confusing is an understatement. > > It seems to me that other financial applications must have encountered > the problem of displaying income to users as a positive value (since > that is how most of us view income!) while still finding a way to > display the correct accounting information. > > To display my YTD report of Capital Gains, I ran a Transaction Report > and selected the Income:Realized Gains accounts for the current year. > The result shows losses as positive numbers, and gains as negative. I > don't know about you, but my expectation is reversed from this. If I > change the Sign Reverses setting to Income and Expense, then the > transactions switch, but the totals do not. This result was the gist of > the discussion in an earlier thread. Bleah! > > Now, I know that I can copy the data, paste it into another program and > change all the settings to my heart's content, but I am looking for a > way to run a report in GnuCash that directly and unambiguously shows me > whether I have gained money (a positive) or lost it (a negative) over > the current year. Does anyone have suggestions? > > FWIW, I attempted to turn this report around and have a report that > lists transactions in the asset accounts, filtered by the > Income:Realized Gains accounts, but that seems to report only the Asset > account currency--in this case, the mutual fund or stock shares involved > on the Gain/Loss transaction. Unfortunately, that's not the actual > Gain/Loss value... > > It would be nice if the sign reverses setting could be fixed. Barring > that, does anyone have a workaround report setup that can give me a > sensible YTD Capital Gains total as described? > > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Transaction Report Sign Reverses
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. There was some discussion about reversing the individual transactions but not the totals. Although I do not recall the specifics of the discussion, I am encountering the same situation now, where the transactions themselves respect the user setting, but the totals do not. To say this is confusing is an understatement. It seems to me that other financial applications must have encountered the problem of displaying income to users as a positive value (since that is how most of us view income!) while still finding a way to display the correct accounting information. To display my YTD report of Capital Gains, I ran a Transaction Report and selected the Income:Realized Gains accounts for the current year. The result shows losses as positive numbers, and gains as negative. I don't know about you, but my expectation is reversed from this. If I change the Sign Reverses setting to Income and Expense, then the transactions switch, but the totals do not. This result was the gist of the discussion in an earlier thread. Bleah! Now, I know that I can copy the data, paste it into another program and change all the settings to my heart's content, but I am looking for a way to run a report in GnuCash that directly and unambiguously shows me whether I have gained money (a positive) or lost it (a negative) over the current year. Does anyone have suggestions? FWIW, I attempted to turn this report around and have a report that lists transactions in the asset accounts, filtered by the Income:Realized Gains accounts, but that seems to report only the Asset account currency--in this case, the mutual fund or stock shares involved on the Gain/Loss transaction. Unfortunately, that's not the actual Gain/Loss value... It would be nice if the sign reverses setting could be fixed. Barring that, does anyone have a workaround report setup that can give me a sensible YTD Capital Gains total as described? 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] journal entries
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 the Accounts tab which is the first window GnuCash opens at by double clicking on a specific account, e.g. an Asset:Current Assets: Checking Account if you have initially created a default Common Account heirarchy when you first opened GnuCash. Gnucash is a formal double entry accounting package. To use it effectively you will need at least some basic information on double entry accounting which is presented in the section headed The Basics in the Getting Started section of the guide (https://www.gnucash.org/docs/v3/C/gnucash-guide/chapter_basics.html) that John referred you to earlier. The help manual referenced above is a description of the GnuCash interfaces and how to use them while the Tutorial and Concepts guide is more oriented at how to perform common accounting functions using GnuCash. To track a single expense you will require a minimum of two accounts, one Asset account to record where the cash (e.g. Asset:CurrentAssets:Cash in Wallet) you are paying for drugs is coming from and an Expense account to record your purchases of drugs from the pharmacy (e.g. Expense:Pharmacy:Drugs) and each purchase is recorded as taking money from your cash account ( a credit to it) and a corresponding debit entry to the Expense:Pharmacy:Drugs accountto record receiving the drugs in return for the money. If this is the only expenditure you really want to track GnuCash will possibly be overkill for you and a simple spreadsheet may better meet your needs. David Cousens - David Cousens -- 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: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Windows Report Options Dialog Setting
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 forward. This newly-saved window has the added unfortunate behavior that the edges of this window are not resizable without first moving the window, so it appears to the user as if the new arrangement for this dialog is a permanent change. This is confusing; I was prepared to ask the list how I should get back the options dialog as a window, but ultimately figured out the odd steps needed to reset the window dimensions. I would expect that the original window size would remain in effect, and that the maximized toggle status would also remain in effect. In other words, if I reopen the options dialog, I would either expect to see the original dialog window dimensions *or* a maximized dialog window that allows me to toggle back to normal size. Instead, some version of the maximized window size is saved as the new dialog size. I say "some size" because the options window that opens up on subsequent tries is not the full screen--and the maximize button opens the (previously maximized) dialog a little bit more. As I said, I believe this behavior is a bug. 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] journal entries
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 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? >> ___ > >Have you studied the Tutorial and Concepts Guide [1]? > >Regards, >John Ralls > >[1] http://www.gnucash.org/viewdoc.phtml?rev=3=C=guide or >Help>Tutorial and Concepts Guide from inside the program. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] journal entries
> 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 using Linux? > ___ Have you studied the Tutorial and Concepts Guide [1]? Regards, John Ralls [1] http://www.gnucash.org/viewdoc.phtml?rev=3=C=guide or Help>Tutorial and Concepts Guide from inside the program. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] journal entries
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 mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Importing FX rates into gnucash
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 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 doesn't. ;-) > Format your table into a CSV and use File>Import>Import prices from a CSV > File > > Regards, > John Ralls > -- ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] FX fetching strangeness
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 plus an error. So I presume it's not that. Except that if I first do a single quote from the commandline, gnucash then fails on two of the four instead of three of the four. So it's looking like rate limit. Jeff Abrahamson http://p27.eu/jeff/ http://transport-nantes.com/ On 11/08/2019 19:53, John Ralls wrote: > 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, Jeff Abrahamson wrote: >> >> 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 **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >>nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >> ** This stock quote cannot be used by GnuCash! >> >> = >> >> Finance::Quote fields Gnucash uses: >> symbol: JPY (deduced)<=== required >> date: ** missing **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >>nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >> ** This stock quote cannot be used by GnuCash! >> >> jeff@birdsong:~ $ >> >> I'm I confused or is there a different way of fetching JPY FX? >> >> Thanks. >> >> Jeff >> >> >> >> On 11/08/2019 19:20, Jeff Abrahamson wrote: >>> 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 like gnc-fq-dump) and in Preferences>Online Quotes (for GnuCash's internal use)? Regards, John Ralls > On Aug 4, 2019, at 11:45 AM, Jeff Abrahamson > wrote: > > I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04). > I'm trying to get FQ to work for me. > > When I enter a dual-currency transaction, the quote editor pops up. If > I touch the "fetch rate" button, I see a dialog that says "unable to > retrieve quotes for these items: CURRENCY:CHF" and three other currencies. > > I have precisely those four currencies in use, though I'm a bit confused > why FQ would have tried to fetch all four at once when I only needed > one. I'm also confused why it found none. > > Based on a conversation on this list in 2018, I tried this: > >jeff@birdsong:~ $ gnc-fq-dump currency USD EUR >1 USD = EUR >jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR >Finance::Quote fields Gnucash uses: >symbol: USD (deduced)<=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > >** This stock quote cannot be used by GnuCash! > >= > >Finance::Quote fields Gnucash uses: >symbol: EUR (deduced)<=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: <=\ > nav: <=== one of these > price: <=/ > timezone: <=== optional > >** This stock quote cannot be used by GnuCash! > >jeff@birdsong:~ $ > > Any suggestions on what to do or what to test? > > -- > > Jeff Abrahamson > +33 6 24 40 01 57 > +44 7920 594 255 > > > http://p27.eu/jeff/ > http://transport-nantes.com/ > > > ___ > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription
Re: [GNC] Importing FX rates into gnucash
> 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? (I'm using the sqlite backend, if that matters, which I > hope it doesn't. ;-) Format your table into a CSV and use File>Import>Import prices from a CSV File Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] FX fetching strangeness
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, Jeff Abrahamson wrote: > > 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 **<=== recommended > currency: ** missing **<=== required > last: <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > = > > Finance::Quote fields Gnucash uses: > symbol: JPY (deduced)<=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > jeff@birdsong:~ $ > > I'm I confused or is there a different way of fetching JPY FX? > > Thanks. > > Jeff > > > > On 11/08/2019 19:20, Jeff Abrahamson wrote: >> 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 like gnc-fq-dump) and in Preferences>Online Quotes (for >>> GnuCash's internal use)? >>> >>> Regards, >>> John Ralls >>> >>> >>> On Aug 4, 2019, at 11:45 AM, Jeff Abrahamson wrote: I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04). I'm trying to get FQ to work for me. When I enter a dual-currency transaction, the quote editor pops up. If I touch the "fetch rate" button, I see a dialog that says "unable to retrieve quotes for these items: CURRENCY:CHF" and three other currencies. I have precisely those four currencies in use, though I'm a bit confused why FQ would have tried to fetch all four at once when I only needed one. I'm also confused why it found none. Based on a conversation on this list in 2018, I tried this: jeff@birdsong:~ $ gnc-fq-dump currency USD EUR 1 USD = EUR jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR Finance::Quote fields Gnucash uses: symbol: USD (deduced)<=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! = Finance::Quote fields Gnucash uses: symbol: EUR (deduced)<=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! jeff@birdsong:~ $ Any suggestions on what to do or what to test? -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. >> -- >> >> Jeff Abrahamson >> +33 6 24 40 01 57 >> +44 7920 594 255 >> >> >> http://p27.eu/jeff/ >> http://transport-nantes.com/ > -- > > Jeff Abrahamson > +33 6 24 40 01 57 > +44 7920 594 255 > > > http://p27.eu/jeff/ > http://transport-nantes.com/ ___ gnucash-user mailing list
Re: [GNC] Get online quote for Canada Fund
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. > http://www.fundlibrary.com/funds/db/_fundcard.asp?t=2=1743 > > however when trying this url, I get Error 404, unknown web page, > > It could be that the module is not current and fails on everything. > > if you are comfortable with perl, you could try changing the url in the > module. > > I tried also to retrieve the mutual fund from my ubuntu based gnucash, and it > also fails. > > there are contact details for this module on this url: > https://metacpan.org/author/ECOCODE > > the author of the code may be able to help more. > > br Ove. > > > > > On Sun, 11 Aug 2019 at 15:44, Kaman Wu wrote: > >> 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 fields Gnucash uses: >> symbol: 1743 (deduced) <=== required >> date: ** missing **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >>nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >> ** This stock quote cannot be used by GnuCash! >> >> >> All fields returned by Finance::Quote for stock 1743 >> >> stock field value >> - - - >> 1743 errormsg: Fund name 1743 not found >> 1743 last: **missing** >> 1743 nav: **missing** >> 1743price: **missing** >> 1743 success: 0 >> >> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v canadamutual >> 1743 >> Finance::Quote fields Gnucash uses: >> symbol: 1743 (deduced) <=== required >> date: ** missing **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >>nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >> ** This stock quote cannot be used by GnuCash! >> >> >> All fields returned by Finance::Quote for stock 1743 >> >> stock field value >> - - - >> 1743 errormsg: Error determining fund code for 1743. >> 1743 last: **missing** >> 1743 nav: **missing** >> 1743price: **missing** >> 1743 success: 0 >> >> >> >> >> >> >> On Sun, Aug 11, 2019 at 6:56 AM Ove Grunnér wrote: >> >>> 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 >>> clues to its id number." >>> the url for TDB900 is: >>> >>> https://www.fundlibrary.com/MutualFunds/Detail/td-canadian-index-fund-e-series/1743 >>> so try 1743 >>> >>> br Ove. >>> >>> On Sun, 11 Aug 2019 at 04:07, Kaman Wu wrote: >>> I did some search, and found some old posts which are not very helpful. I think I can use: https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary Basing on this module, it use the data from http://www.fundlibrary.com/ I do can search TDB900 on this website and find the correct fund. BUT when I setup it up in gnucash, I get quote failed. PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary TDB900 Finance::Quote fields Gnucash uses: symbol: TDB900 (deduced) <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock TDB900 stock field value - - - TDB900 errormsg: Fund name TDB900 not found TDB900 last: **missing** TDB900nav: **missing** TDB900 price: **missing** TDB900success: 0 Any one know how to fix it? or how (where) to report this problem? Thanks. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:
Re: [GNC] Get online quote for Canada Fund
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 web page, It could be that the module is not current and fails on everything. if you are comfortable with perl, you could try changing the url in the module. I tried also to retrieve the mutual fund from my ubuntu based gnucash, and it also fails. there are contact details for this module on this url: https://metacpan.org/author/ECOCODE the author of the code may be able to help more. br Ove. On Sun, 11 Aug 2019 at 15:44, Kaman Wu wrote: > 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 fields Gnucash uses: > symbol: 1743 (deduced) <=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > > All fields returned by Finance::Quote for stock 1743 > > stock field value > - - - > 1743 errormsg: Fund name 1743 not found > 1743 last: **missing** > 1743 nav: **missing** > 1743price: **missing** > 1743 success: 0 > > PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v canadamutual > 1743 > Finance::Quote fields Gnucash uses: > symbol: 1743 (deduced) <=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > > All fields returned by Finance::Quote for stock 1743 > > stock field value > - - - > 1743 errormsg: Error determining fund code for 1743. > 1743 last: **missing** > 1743 nav: **missing** > 1743price: **missing** > 1743 success: 0 > > > > > > > On Sun, Aug 11, 2019 at 6:56 AM Ove Grunnér wrote: > >> 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 >> clues to its id number." >> the url for TDB900 is: >> >> https://www.fundlibrary.com/MutualFunds/Detail/td-canadian-index-fund-e-series/1743 >> so try 1743 >> >> br Ove. >> >> On Sun, 11 Aug 2019 at 04:07, Kaman Wu wrote: >> >>> I did some search, and found some old posts which are not very helpful. >>> >>> I think I can use: >>> https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary >>> Basing on this module, it use the data from http://www.fundlibrary.com/ >>> >>> I do can search TDB900 on this website and find the correct fund. >>> >>> BUT when I setup it up in gnucash, I get quote failed. >>> >>> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary >>> TDB900 >>> Finance::Quote fields Gnucash uses: >>> symbol: TDB900 (deduced) <=== required >>> date: ** missing **<=== recommended >>> currency: ** missing **<=== required >>> last: <=\ >>>nav: <=== one of these >>> price: <=/ >>> timezone: <=== optional >>> >>> ** This stock quote cannot be used by GnuCash! >>> >>> >>> All fields returned by Finance::Quote for stock TDB900 >>> >>> stock field value >>> - - - >>> TDB900 errormsg: Fund name TDB900 not found >>> TDB900 last: **missing** >>> TDB900nav: **missing** >>> TDB900 price: **missing** >>> TDB900success: 0 >>> >>> >>> Any one know how to fix it? or how (where) to report this problem? >>> 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 >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by
[GNC] Importing FX rates into gnucash
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 doesn't. ;-) Thanks! -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] FX fetching strangeness
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 ** <=== recommended currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! = Finance::Quote fields Gnucash uses: symbol: JPY (deduced) <=== required date: ** missing ** <=== recommended currency: ** missing ** <=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! jeff@birdsong:~ $ I'm I confused or is there a different way of fetching JPY FX? Thanks. Jeff On 11/08/2019 19:20, Jeff Abrahamson wrote: > > 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 like gnc-fq-dump) and in Preferences>Online Quotes (for GnuCash's >> internal use)? >> >> Regards, >> John Ralls >> >> >>> On Aug 4, 2019, at 11:45 AM, Jeff Abrahamson wrote: >>> >>> I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04). >>> I'm trying to get FQ to work for me. >>> >>> When I enter a dual-currency transaction, the quote editor pops up. If >>> I touch the "fetch rate" button, I see a dialog that says "unable to >>> retrieve quotes for these items: CURRENCY:CHF" and three other currencies. >>> >>> I have precisely those four currencies in use, though I'm a bit confused >>> why FQ would have tried to fetch all four at once when I only needed >>> one. I'm also confused why it found none. >>> >>> Based on a conversation on this list in 2018, I tried this: >>> >>>jeff@birdsong:~ $ gnc-fq-dump currency USD EUR >>>1 USD = EUR >>>jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR >>>Finance::Quote fields Gnucash uses: >>>symbol: USD (deduced)<=== required >>> date: ** missing **<=== recommended >>> currency: ** missing **<=== required >>> last: <=\ >>> nav: <=== one of these >>> price: <=/ >>> timezone: <=== optional >>> >>>** This stock quote cannot be used by GnuCash! >>> >>>= >>> >>>Finance::Quote fields Gnucash uses: >>>symbol: EUR (deduced)<=== required >>> date: ** missing **<=== recommended >>> currency: ** missing **<=== required >>> last: <=\ >>> nav: <=== one of these >>> price: <=/ >>> timezone: <=== optional >>> >>>** This stock quote cannot be used by GnuCash! >>> >>>jeff@birdsong:~ $ >>> >>> Any suggestions on what to do or what to test? >>> >>> -- >>> >>> Jeff Abrahamson >>> +33 6 24 40 01 57 >>> +44 7920 594 255 >>> >>> http://p27.eu/jeff/ >>> http://transport-nantes.com/ >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. > -- > > Jeff Abrahamson > +33 6 24 40 01 57 > +44 7920 594 255 > > http://p27.eu/jeff/ > http://transport-nantes.com/ -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] FX fetching strangeness
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 like gnc-fq-dump) and in Preferences>Online Quotes (for GnuCash's > internal use)? > > Regards, > John Ralls > > >> On Aug 4, 2019, at 11:45 AM, Jeff Abrahamson wrote: >> >> I'm using gnucash 3.4 and Finance::Quote 1.47 on linux (ubuntu 19.04). >> I'm trying to get FQ to work for me. >> >> When I enter a dual-currency transaction, the quote editor pops up. If >> I touch the "fetch rate" button, I see a dialog that says "unable to >> retrieve quotes for these items: CURRENCY:CHF" and three other currencies. >> >> I have precisely those four currencies in use, though I'm a bit confused >> why FQ would have tried to fetch all four at once when I only needed >> one. I'm also confused why it found none. >> >> Based on a conversation on this list in 2018, I tried this: >> >>jeff@birdsong:~ $ gnc-fq-dump currency USD EUR >>1 USD = EUR >>jeff@birdsong:~ $ gnc-fq-dump alphavantage USD EUR >>Finance::Quote fields Gnucash uses: >>symbol: USD (deduced)<=== required >> date: ** missing **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >> nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >>** This stock quote cannot be used by GnuCash! >> >>= >> >>Finance::Quote fields Gnucash uses: >>symbol: EUR (deduced)<=== required >> date: ** missing **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >> nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >>** This stock quote cannot be used by GnuCash! >> >>jeff@birdsong:~ $ >> >> Any suggestions on what to do or what to test? >> >> -- >> >> Jeff Abrahamson >> +33 6 24 40 01 57 >> +44 7920 594 255 >> >> http://p27.eu/jeff/ >> http://transport-nantes.com/ >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. -- Jeff Abrahamson +33 6 24 40 01 57 +44 7920 594 255 http://p27.eu/jeff/ http://transport-nantes.com/ ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Price in Register Account report not decimal
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 solution for that other than to paste the report into a spreadsheet and stick an '=' in front of the price to make it a formula. Regards, John Ralls > On Aug 11, 2019, at 3:24 AM, Joe Normandeau > wrote: > > 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 Account Report. >> Have you tried that again since you upgraded to 3.6? >> Also are you sure it is definitely running 3.6? Check in Help > About. >> >> Colin >> >>> JoeCanuck >>> >>> >>> On 10/08/2019 11:58 pm, Adrien Monteleone wrote: Preferences > General > Numbers > Force prices to display as numbers Regards, Adrien > On Aug 10, 2019, at 4:09 AM, Joe Normandeau > wrote: > > > On 10/08/2019 5:37 pm, Colin Law wrote: >> On Sat, 10 Aug 2019 at 06:19, Joe Normandeau >> wrote: >>> I'm just new to this mail list so if I get something wrong be gentle. >>> >>> I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price >>> in the register account report to be decimal. It always comes out as 2 >>> + a fraction ie. 2 + 6227/6779. I must be missing a configuration >>> setting but I can't seem to get the right one. Can someone assist >>> please? >> I think that may have been a bug in 3.3. Why are you not using the >> latest available for Windows, which is 3.6 I think? >> https://gnucash.org/download.phtml >> >> Colin > Thanks for your comments Collin. > > I've loaded 3.6 and the same thing happens. Don't know where to go from > here as I need these reports for my auditor. > > JoeCanuck ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. >>> --- >>> This email has been checked for viruses by AVG. >>> https://www.avg.com >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> 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 >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Get online quote for Canada Fund
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 fields Gnucash uses: symbol: 1743 (deduced) <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock 1743 stock field value - - - 1743 errormsg: Fund name 1743 not found 1743 last: **missing** 1743 nav: **missing** 1743price: **missing** 1743 success: 0 PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v canadamutual 1743 Finance::Quote fields Gnucash uses: symbol: 1743 (deduced) <=== required date: ** missing **<=== recommended currency: ** missing **<=== required last: <=\ nav: <=== one of these price: <=/ timezone: <=== optional ** This stock quote cannot be used by GnuCash! All fields returned by Finance::Quote for stock 1743 stock field value - - - 1743 errormsg: Error determining fund code for 1743. 1743 last: **missing** 1743 nav: **missing** 1743price: **missing** 1743 success: 0 On Sun, Aug 11, 2019 at 6:56 AM Ove Grunnér wrote: > 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 > clues to its id number." > the url for TDB900 is: > > https://www.fundlibrary.com/MutualFunds/Detail/td-canadian-index-fund-e-series/1743 > so try 1743 > > br Ove. > > On Sun, 11 Aug 2019 at 04:07, Kaman Wu wrote: > >> I did some search, and found some old posts which are not very helpful. >> >> I think I can use: >> https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary >> Basing on this module, it use the data from http://www.fundlibrary.com/ >> >> I do can search TDB900 on this website and find the correct fund. >> >> BUT when I setup it up in gnucash, I get quote failed. >> >> PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary >> TDB900 >> Finance::Quote fields Gnucash uses: >> symbol: TDB900 (deduced) <=== required >> date: ** missing **<=== recommended >> currency: ** missing **<=== required >> last: <=\ >>nav: <=== one of these >> price: <=/ >> timezone: <=== optional >> >> ** This stock quote cannot be used by GnuCash! >> >> >> All fields returned by Finance::Quote for stock TDB900 >> >> stock field value >> - - - >> TDB900 errormsg: Fund name TDB900 not found >> TDB900 last: **missing** >> TDB900nav: **missing** >> TDB900 price: **missing** >> TDB900success: 0 >> >> >> Any one know how to fix it? or how (where) to report this problem? >> 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 >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Setting up a new accounting scheme in GnuCash
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 > volgende geschreven: > > Frank, > > I think the term Balans accounts will refer to Assets , Liability and Equity > accounts while Gain and Loss accounts will refer to Income and Expense > accounts. > > In accounting the latter are known as temporary accounts as they record the > income and expenses for the current accounting period and are used to > calculate the profit or loss for that period. In the end of period closing > calculations, this is usually transferred to an Equity:Retained Earnings > account to reflect the change in equity produced by that profit or loss. > > The Assets Liability and Equity account balances on the other hand show the > overall long term position of your accounts at the date the balances are > taken. > > David Cousens ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Get online quote for Canada Fund
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 clues to its id number." the url for TDB900 is: https://www.fundlibrary.com/MutualFunds/Detail/td-canadian-index-fund-e-series/1743 so try 1743 br Ove. On Sun, 11 Aug 2019 at 04:07, Kaman Wu wrote: > I did some search, and found some old posts which are not very helpful. > > I think I can use: https://metacpan.org/pod/Finance::Quote::Cdnfundlibrary > Basing on this module, it use the data from http://www.fundlibrary.com/ > > I do can search TDB900 on this website and find the correct fund. > > BUT when I setup it up in gnucash, I get quote failed. > > PS C:\Program Files (x86)\gnucash\bin> perl .\gnc-fq-dump -v fundlibrary > TDB900 > Finance::Quote fields Gnucash uses: > symbol: TDB900 (deduced) <=== required > date: ** missing **<=== recommended > currency: ** missing **<=== required > last: <=\ >nav: <=== one of these > price: <=/ > timezone: <=== optional > > ** This stock quote cannot be used by GnuCash! > > > All fields returned by Finance::Quote for stock TDB900 > > stock field value > - - - > TDB900 errormsg: Fund name TDB900 not found > TDB900 last: **missing** > TDB900nav: **missing** > TDB900 price: **missing** > TDB900success: 0 > > > Any one know how to fix it? or how (where) to report this problem? > 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 > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Price in Register Account report not decimal
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 Account Report. Have you tried that again since you upgraded to 3.6? Also are you sure it is definitely running 3.6? Check in Help > About. Colin JoeCanuck On 10/08/2019 11:58 pm, Adrien Monteleone wrote: Preferences > General > Numbers > Force prices to display as numbers Regards, Adrien On Aug 10, 2019, at 4:09 AM, Joe Normandeau wrote: On 10/08/2019 5:37 pm, Colin Law wrote: On Sat, 10 Aug 2019 at 06:19, Joe Normandeau wrote: I'm just new to this mail list so if I get something wrong be gentle. I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price in the register account report to be decimal. It always comes out as 2 + a fraction ie. 2 + 6227/6779. I must be missing a configuration setting but I can't seem to get the right one. Can someone assist please? I think that may have been a bug in 3.3. Why are you not using the latest available for Windows, which is 3.6 I think? https://gnucash.org/download.phtml Colin Thanks for your comments Collin. I've loaded 3.6 and the same thing happens. Don't know where to go from here as I need these reports for my auditor. JoeCanuck ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. --- This email has been checked for viruses by AVG. https://www.avg.com ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Price in Register Account report not decimal
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 it is definitely running 3.6? Check in Help > About. Colin > > JoeCanuck > > > On 10/08/2019 11:58 pm, Adrien Monteleone wrote: > > Preferences > General > Numbers > Force prices to display as numbers > > > > Regards, > > Adrien > > > >> On Aug 10, 2019, at 4:09 AM, Joe Normandeau wrote: > >> > >> > >> On 10/08/2019 5:37 pm, Colin Law wrote: > >>> On Sat, 10 Aug 2019 at 06:19, Joe Normandeau > >>> wrote: > I'm just new to this mail list so if I get something wrong be gentle. > > I've just upgraded to GnuCash 3.3 from 2.6.13 and I can't get the price > in the register account report to be decimal. It always comes out as 2 > + a fraction ie. 2 + 6227/6779. I must be missing a configuration > setting but I can't seem to get the right one. Can someone assist please? > >>> I think that may have been a bug in 3.3. Why are you not using the > >>> latest available for Windows, which is 3.6 I think? > >>> https://gnucash.org/download.phtml > >>> > >>> Colin > >> Thanks for your comments Collin. > >> > >> I've loaded 3.6 and the same thing happens. Don't know where to go from > >> here as I need these reports for my auditor. > >> > >> JoeCanuck > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > > - > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > --- > This email has been checked for viruses by AVG. > https://www.avg.com > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.