GnuCash Feature Request: List all commodity prices in the data file sorted by date
wm_o_o_o at yahoo.co.uk
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 afrinc.com>
>>> 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