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

David G Hamblen dhamblen at
Fri Oct 28 15:51:55 EDT 2016

On 10/28/2016 01:36 PM, David T. wrote:
>> On Oct 28, 2016, at 10:10 PM, David G Hamblen <dhamblen at> wrote:
>> A few years back, I wrote a small SQL script that copied the price table, keeping only one entry per month.  As I recall, it wasn't too difficult, but one needs some comfort level with SQL. (I use mysql as my backing store and save a copy as XML occasionally).
> Would you share that?
Here's what I had (it's several years old, but it worked back then :).  
Do attachments work on this list?

dhamblen at
home phone (207) 633-4342
Cell Phone (207) 350-0440

-------------- next part --------------
A non-text attachment was scrubbed...
Name: compactPricesTable.sql
Type: application/sql
Size: 1911 bytes
Desc: not available
URL: <>

More information about the gnucash-user mailing list