[GNC] Export-import GnuCash historical prices

[David Carlson]

I have no idea what to do with that paragraph


On Tue, Nov 25, 2025 at 1:01 PM sunfish62 at yahoo.com <sunfish62 at yahoo.com>
wrote:

> I don't know if this will help, but try it and see what you get. I believe
> it also gives the number of shares owned, but it's been a while.
>
> SELECT c.mnemonic, c.guid,
>   ROUND(SUM((s.quantity_num*1.0/s.quantity_denom)),
> LENGTH(REPLACE(c.fraction, '1', ''))),
>   MIN(t.post_date), MAX(t.post_date)
>   FROM accounts as a, commodities as c, splits as s, transactions as t
>   WHERE (a.account_type='MUTUAL' OR a.account_type='STOCK')
>   AND a.guid=s.account_guid AND s.tx_guid=t.guid AND
> a.commodity_guid=c.guid
>   GROUP BY c.mnemonic
>
> ⁣David T.​
>
> On Nov 25, 2025, 7:48 PM, at 7:48 PM, David Carlson <
> david.carlson.417 at gmail.com> wrote:
> >I recently lost most of the historical prices out of my main data file.
> > I
> >have backups with the old price data intact.  I want to export them
> >from a
> >backup and import them into my current file.  I have saved the backup
> >in
> >mysql format and found the price table but it is using guid's instead
> >of
> >currency names and commodity names.  I don't know how to create a
> >proper
> >csv file to import the prices into my current data file.  Has anyone
> >done
> >something similar in the past?
> >
> >--
> >David Carlson
> >_______________________________________________
> >gnucash-user mailing list
> >gnucash-user at gnucash.org
> >To update your subscription preferences or to unsubscribe:
> >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.
>
>

-- 
David Carlson