GnuCash Feature Request: List all commodity prices in the data file sorted by date
David G Hamblen
dhamblen at afrinc.com
Fri Oct 28 15:51:55 EDT 2016
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>
More information about the gnucash-user
mailing list