[GNC] Price database

[Murugan Muruganandam]

if you are looking for historical price data for analysis, you can use google finance function in goolge sheets to get the same, for example =GOOGLEFINANCE("AAPL", "price", DATE(2016,1,1), today(), "DAILY") will give you daily rates from 2016 january




Saludos Cordiales


Murugan

________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> on behalf of john <jralls at ceridwen.us>
Sent: Saturday, October 15, 2022 2:40 PM
To: Elmar <etschme at gmail.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Price database

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.

_______________________________________________
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.