Investment performance

Filipe Giusti filipegiusti at
Tue Oct 25 08:48:22 EDT 2016


thanks for putting the business analyst hat.

Indeed I've been using GnuCash to achieve an asset allocation strategy
successfully for years. I wanna go beyond, I wanna evaluate the
effectiveness of that strategy. As I was doing, I was updating asset
percentage yearly, however due to negative interest rates, political
turmoils in my country, I wanna update that faster and I wanna evaluate the
effectiveness of that choices.

Does that makes sense?

Filipe Vernetti Giusti

2016-10-21 18:36 GMT-02:00 Edward Doolittle <edward.doolittle at>:

> On 21 October 2016 at 13:49, Filipe Giusti <filipegiusti at> wrote:
> 2016-10-21 17:15 GMT-02:00 Wm <wm_o_o_o at>:
>> > On 20/10/2016 16:28, Filipe Giusti wrote:
>> >> Like a fund manager showing to customers what
>> >> happened.
>> > GnuCash does not record the trading related data you seem to think it
>> does.
> I'm probably not being clear. GnuCash has all the data needed for what I
>> want but it doesn't have a report to show the data the way I need.
> Filipe, your GnuCash data file probably doesn't have all the stock price
> data that you would want. Even if you set things up to download price data
> at a given frequency, say once a week or once a day, inevitable glitches
> may mean that the data isn't necessarily downloaded correctly every time
> you ask for it. And price data may be removed, either manually or
> automatically. For example, my understanding is that only one price can be
> stored per day by GnuCash. If you buy a stock during the day, and then
> download price data using Finance::Quote at the end of the day, one of the
> two data sources will be silently deleted.
> So counting on GnuCash to store all the price data you may want is risky.
> When it comes time to make a report, GnuCash will do the best it can
> ("nearest in time", for example), but it may not be exactly what you expect.
> If you want to do-it-yourself, you might find Google Sheets or Excel
> provides the tools you need, in particular access to more-or-less current,
> and historic, price data. You can write a program to pull some data from
> GnuCash and insert it into the spreadsheet, where you could combine with
> price data to produce the reports you want. If you want access to more
> detailed, up-to-date, and reliable data, you'll have to pay for it, in
> which case you might prefer to use the tools provided by the platform that
> supplies the data.
> Edward
> --
> Edward Doolittle
> Associate Professor of Mathematics
> First Nations University of Canada
> 1 First Nations Way, Regina SK S4S 7K2
> « Toutes les fois que je donne une place vacante, je fais cent mécontents
> et un ingrat. »
> -- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI

More information about the gnucash-user mailing list