If you open your data file with an sql reader (Windows has DB Browser for SQLite https://sqlitebrowser.org/), you can use this command in the SQL window to retrieve a listing.
David T. On Nov 26, 2025, 12:44 AM, at 12:44 AM, 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.
