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 <[email protected]> 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 >[email protected] >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. _______________________________________________ gnucash-user mailing list [email protected] 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.
