Value of stocks in reports?

David T. sunfish62 at
Sun Oct 23 05:17:26 EDT 2016


It’s my understanding that the Asset Barchart/Piechart both allow different price settings: Average Cost/Weighted Average/Most Recent/Nearest in Time. The Most Recent setting here would give value based on the latest entry in the price db, I believe. 

For what it’s worth, I tried to look at the scheme to understand the difference between the other three settings for this option, but by the time I located the code in question (in commodity-utilities.scm), my head hurt too much to determine the differences.


> On Oct 23, 2016, at 10:14 AM, prl <prl at> wrote:
> On 23/10/2016 13:44, John Ralls wrote:
>>> On Oct 22, 2016, at 6:12 PM, prl <prl at> wrote:
>>> I'm not sure whether this is an accounting question or a Gnucash question, but when I look in some assets reports (Asset Barchart/Piechart, Balance Sheet, Net Worth Barchart/Piechart), the displayed value of the stocks we hold is the Basis, not the Value (as given in the Advanced Portfolio report). That isn't what I'd expect. I'd expect the current value of the stocks to appear in assets reports, not what it cost to buy the shares.
>>> Is that what Gnucash is supposed to report (i.e. is my expectation of the report incorrect), or is this a Gnucash error?
>>> Is there some way to get reports like Net Worth to use the current value of stocks rather than the basis?
>> It's what you should expect for the accounting reports. ...
>> Net worth is one of the reports that does use market value if you set things up correctly. First, as you probably know you must populate the price database with current prices. Second, you must set the report option Price Source on the General tab to Nearest in time.
> Thanks, John. That's exactly what I needed to know. I already had a pretty good stocks price history (weekly, which is all I feel I need). The side effect of the Price Source setting wasn't what I expected, but it certainly works.
> The current (market) value of the assets is what our superannuation adviser likes to see. That's really the only time I use these reports.
> Thanks again,
> Peter
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

More information about the gnucash-user mailing list