If there was some way to search for or display transactions that contained a non-zero exchange rate in one or more of it's split lines it might be possible to track this down.
If the OP had made a typo years ago and corrected it but GnuCash left some garbage it would not be easy to find. I suppose that he could try Check and Repair All to see if it makes a difference. The fact that " setting the calculation mode to "average" or "nearest in time" " makes a difference suggests that there may be more than one transaction with a non-zero exchange rate and on different dates. One other place to look is in the chart of accounts choose View > Filter by > Other and check Show Hidden Accounts. Then make sure the Commodity column is shown and click on it two or three times to see if any account has a currency other than his base currency. If so, that would be the place to look. David C On Wed, Apr 4, 2018 at 7:34 PM, Adrien Monteleone < adrien.montele...@gmail.com> wrote: > But the OP specifically said he doesn’t deal with stocks or any other > investments. So there should be no such added prices. (and technically, > those would be manual inputs via the transaction, just not via the Price > Editor) As far as I’m aware, GnuCash doesn’t just grab prices from online > without being told to in some fashion. > > Regards, > Adrien > > > On Apr 4, 2018, at 3:55 PM, nvsoar <nvs...@charter.net> wrote: > > > > Hmmmmm. Seems to me that a price is added to the system any time a > stock is purchased or sold, or when a dividend is reinvested. > > nvsoar > > > > On 04/04/18 09:32, Adrien Monteleone wrote: > >> The value will usually change based on that setting. Sometimes ‘latest’ > and ’nearest in time’ will be the same, but that depends on running the > report ON an actual day (not FOR an actual day) that is on or after a price > update and before the next price update. > >> > >> First, you say you deleted all rates updated automatically by GC > without you noticing. (does not happen, you have to open the price editor > and tell it to ‘get quotes’) This leaves the presumption that there are > other prices in the db that you either entered manually or intentionally > updated with the ‘get quotes’ button. > >> > >> Then you say there are NO rates in the system. > >> > >> Which is it? > >> > >> If you open the Price Database is there anything at all listed in the > window? (this includes a Currencies tree) > >> > >> Do you have ANY transactions where you purchased or entered an opening > balance for a commodity or any currency other than the default book > currency? (EUR) > >> > >> If you go to File > Properties, is ‘Use Trading Accounts’ checked? > >> > >> Regards, > >> Adrien > >> > >>> On Apr 4, 2018, at 11:10 AM, cag...@free.fr wrote: > >>> > >>> I suspect there is a bug that should be reported: > >>> > >>> As I do NOT manage currencies other than EUR and no traders accounts > taking into account share values, I have deleted all exchanges rates that > had been updated automatically by GC without my noticing. > >>> BUT my Unrealized loss on a given day varies according to my setting > the calculation mode to "average" or "nearest in time" for instance. It > doesn's seem to make sense since there are NO exchange rates in my system. > >>> > >>> Ideas? > >>> TIA > >>> Alain > >>> > >>> > >>> > >>> > >>> De: "sunfish62" <sunfis...@yahoo.com> > >>> À: cag...@free.fr, "John Ralls" <jra...@ceridwen.us> > >>> Cc: "gnucash-user" <gnucash-user@gnucash.org> > >>> Envoyé: Lundi 2 Avril 2018 14:52:46 > >>> Objet: Re: Unrealized loss > >>> > >>> Alain, > >>> > >>> Your new transaction is balanced, and won't affect the imbalance in > another transaction. > >>> > >>> I personally find the unrealized gains issue to be exceedingly > difficult to understand. Since you say you don't care about this, just > ignore it. > >>> > >>> David T > >>> > >>> > >>> > >>> > >>> On Mon, Apr 2, 2018 at 17:02, cag...@free.fr > >>> <cag...@free.fr> wrote: > >>> > >>> > >>> > >>> De: [ mailto:cag...@free.fr | cag...@free.fr ] > >>> À: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > > >>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | > gnucash-user@gnucash.org ] > > >>> Envoyé: Lundi 2 Avril 2018 13:51:03 > >>> Objet: Re: Unrealized loss > >>> > >>> > >>> > >>> > >>> De: "John Ralls" < [ mailto:jra...@ceridwen.us | jra...@ceridwen.us ] > > > >>> À: [ mailto:cag...@free.fr | cag...@free.fr ] > >>> Cc: "gnucash-user" < [ mailto:gnucash-user@gnucash.org | > gnucash-user@gnucash.org ] > > >>> Envoyé: Dimanche 1 Avril 2018 15:34:43 > >>> Objet: Re: Unrealized loss > >>> > >>> > >>> > >>> > >>> > >>> > >>> On Apr 1, 2018, at 5:13 AM, [ mailto: [ mailto:cag...@free.fr | > cag...@free.fr ] | [ mailto:cag...@free.fr | cag...@free.fr ] ] wrote: > >>> > >>> > >>> Hello. > >>> > >>> I have have had an "unrealized loss" showing on my balance sheet for > years. I haven't bothered too much as the amount is extremely small. > (€7.70). > >>> > >>> I had kind advice on this forum as to identify the date on which the > loss showed up and the procedure to cancel it. I did find the date but > stangely not the transaction. So I'm not going to keep trying to cancel the > loss any longer. > >>> > >>> I read that, without actually "cancelling" the loss, it is possible to > prevent it from showing. I know that this is not legal for a company, but > my book keeping is fully personal so I'd like to know the procedure. > >>> > >>> > >>> > >>> > >>> “Cancelling” isn’t really the right term. You need to record the loss > as either expense or negative income depending on how you handle capital > gains. There’s an explanation of how to do this in [ [ > https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | > https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] | > [ https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html | > https://www.gnucash.org/docs/v2.6/C/gnucash-guide/invest-sell1.html ] ] . > >>> > >>> Regards, > >>> John Ralls > >>> > >>> > >>> > >>> I have identified the day on which the unrealized lossed first > appeared. I have drawn a transaction report for that day (and the day > before). There is no transaction that can remotely explain the loss. > >>> I do not handle foreign currencies. Regarding shares I do not use > trader accounts or split transactions including profits or losses. I do not > enter share values into GC until the day I sell them. There is no way in > the meantime GC can take into account a difference in value. > >>> > >>> Something might help identify where the problem comes from: I had > another instance with an unrealized loss as big as my total yearly income. > It went away a few weeks (or months I'm not sure) after it showed up. There > is no way a single transaction (or even a few ) on a particular day > triggered an unrealized loss as big as my yearly income. > >>> > >>> What I would like at this stage is simply set GC NOT to SHOW > unrealized losses/gains. No legal problem as I'm only managing my personal > familyaccounts. > >>> > >>> TIA for you help > >>> Regards > >>> Alain > >>> > >>> > >>> I tried the following: > >>> C an equity account "Unrealized loss" : EUR 7.70 > >>> D an income account "Realized loss" : EUR 7.70 > >>> The total Equity remained the same - 7.70 > >>> I changed the signs and the total equity remained at - 7.70 > >>> I don't get it. > >>> > >>> TIA > >>> Alain > > > > _______________________________________________ > > 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.