GnuCash Feature Request: List all commodity prices in the data file sorted by date

david.carlson.417 david.carlson.417 at
Fri Oct 28 13:17:57 EDT 2016

I like the roach motel allegory.  I want a simple to implement way into the price db part of the data file so users can more easily find and delete stale prices.
I do not need anything fancy.
David C

Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT&T 4G LTE smartphone

-------- Original message --------
From: "David T." <sunfish62 at> 
Date: 10/28/16  12:44 PM  (GMT-05:00) 
To: John Ralls <jralls at> 
Cc: David Carlson <david.carlson.417 at>, gnucash-user at 
Subject: Re: GnuCash Feature Request: List all commodity prices in the data file sorted by date 

Unfortunately, GnuCash includes the storage of historical commodity prices, and users really ought to be able to manage the data stored in the file. As it stands, the price db is like the proverbial roach motel: prices check in, but they never check out ( 
Today, just for yucks, I took a look at my own price db, accumulated over the last ten years. I was looking to clear out entries that were unnecessary, because I had sold the stocks, and no longer needed daily entries for those holdings. I figured to retain monthly or quarterly values for these holding, so that I might be able to see how the stock had performed over the time period that I held it. I went through and removed many entries for many of those holdings (a total of 100k from my 3.8MB compressed GnuCash data file). It was a three hour process, notable for its fundamentally manual, commodity-by-commodity, date-by-date elimination process. 
It is unfortunate that GnuCash is unable to offer its user base a better option to manage the prices in the price db.
David T.
On Oct 28, 2016, at 7:14 PM, John Ralls <jralls at> wrote:

On Oct 28, 2016, at 12:03 AM, David Carlson <david.carlson.417 at> wrote:

I would like to see a feature to list all historical prices in the data
file sorted by date  without needing to drill down through the commodity
data, trying to guess which commodities might still have prices from before
the American Revolution.

Of course, the display should include the date (optionally showing day of
the week), commodity, price, source, and most important, a check box to
individually select prices to delete, somewhat similar to the list of
emails in your email in-box.

A nice additional feature might be to show the total number of shares in
the data file of each commodity across all accounts on the dates included
in the historical price data.  That would probably work best as a different

That would work best as a separate program entirely. GnuCash is not a portfolio management program, it's an accounting program.

John Ralls

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