David C, It might be easier for you to export your txns since the last backup you have available with intact price history. Then open the backup in Gnucash and import the txns to that and save it as your normal gnucash data file ?
Cheers David H. On Wed, 26 Nov 2025 at 05:15, David Carlson <[email protected]> wrote: > I have no idea what to do with that paragraph > > > On Tue, Nov 25, 2025 at 1:01 PM [email protected] <[email protected]> > 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 < > > [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. > > > > > > -- > 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.
