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

[David G Hamblen]

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: compactPricesTable.sql
Type: application/sql
Size: 1911 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20161028/161069ca/attachment.sql>