[GNC] Price database

[john]

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 <etschme at 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 at 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.