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

Wm 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>
>>> 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?

Yup.

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

-- 
Wm




More information about the gnucash-user mailing list