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

Wm wm_o_o_o at
Fri Oct 28 17:01:38 EDT 2016

On 28/10/2016 20:51, David G Hamblen wrote:
> 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?


I *love* that sort of SQL, thanks, David


More information about the gnucash-user mailing list