The easiest would be to save your book to SQLite3: File>Save As..., pick Sqlite3 from the drop-down at the top of the dialog, pick a file name and location. Then run a query on the prices table (see https://wiki.gnucash.org/wiki/SQL#Prices for the schema; you may want to join on commodities to get the security's symbol and namespace and the currency's ISO-4217 code). Note that the actual price is saved in two fields, value_num and value_denom, that represents a fraction. Sqlite3 has a -csv option to output csv and a -o option to write a file.
Regards, John Ralls > On Oct 15, 2022, at 9:39 AM, Elmar <etsc...@gmail.com> wrote: > > Asking again - is there any way to get the accumulated data copied from the > price database into a spreadsheet? > > - Elmar > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > 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 gnucash-user@gnucash.org 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.
