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....@gnucash.org> on behalf of john
<jra...@ceridwen.us>
Sent: Saturday, October 15, 2022 2:40 PM
To: Elmar <etsc...@gmail.com>
Cc: Gnucash Users <gnucash-user@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 <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.
_______________________________________________
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.
