Thank you. This will be a new experience for me - I have never even
looked at SQL, much less have any facility with it. All the included
reports don't touch the price database itself, and I don't know how to
create an appropriate one from the menu in GC. Off to look at the wiki
:) Probably tomorrow - too late today, and I have other more homely
tasks still to do.
- Elmar
On 10/15/22 13:40, john wrote:
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 <[email protected]> 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
[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.
