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

[David T.]

Thanks. Now I’ll do some testing here…

David T.

> On Oct 29, 2016, at 12:51 AM, David G Hamblen <dhamblen at afrinc.com> 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?
> 
> -- 
> dhamblen at afrinc.com
> home phone (207) 633-4342
> Cell Phone (207) 350-0440
> 
> <compactPricesTable.sql>_______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.