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.
