Since OP said they had saved in sql format, I gave them an sql solution. I also made the assumption (incorrect, as it turns out) that they would be able to use the sql and see whether it helped.
David T. On Nov 25, 2025, 9:13 PM, at 9:13 PM, Patrick James via gnucash-user <[email protected]> wrote: >This is not going to work well with the default XML file format. > >Also if someone is not familiar with SQL commands, then even the >elementary SELECT is going to be a bit foreign, especially when using >the AS in the FROM section. > >So starting with the default XML, "save as" sqlite, and then... > >> On 11/25/2025 11:35 AM PST sunfish62--- via gnucash-user ><[email protected]> wrote: >> >> >> 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. >_______________________________________________ >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.
