[GNC] Calculating IRR of an investment account

[Vincent Dawans]

As for exporting the correct data for the XIRR function in OpenOffice Calc
or Excel, the trick is to use the account filtering feature of the
transaction report to exclude any internal transactions within the
investment account (such as reinvested dividends, etc); only external
transactions (money in money out) need to be included for the XIRR
calculation, along with (separately) adding the current value of the
account at the bottom. Which accounts need to be included or excluded
depends on your account structure and how investment contributions, income,
expenses and distributions are recorded, so it's not easy to give specific
advice without knowing that. Also worth noting that typically you have to
reverse signs on the numbers because the XIRR function expects negative
numbers for money in but positive for money out. You can just multiply by
-1 in your spreadsheet to easily do that.

Sincerely,

Vincent Dawans

On Sat, Apr 8, 2023 at 4:36 PM John Ralls <jralls at ceridwen.us> wrote:

> GnuCash doesn't even claim to have an IRR calculation, so exporting to a
> spreadsheet is the only option.
>
> The advanced portfolio report does have "rate of gain" and "rate of
> return" columns but they're really just percent return, independent of
> holding period or timing of cash flows.
>
> Regards,
> John Ralls
>
> > On Apr 8, 2023, at 3:03 PM, R Losey <rlosey at gmail.com> wrote:
> >
> > Personally, I don't necessarily trust what some program may call the
> IRR...
> > if I wanted to calculate it, I would export the necessary data to a
> > spreadsheet and then use the spreadsheet's power to calculate it.
> >
> > On Sat, Apr 8, 2023 at 11:41 AM David Carlson <
> david.carlson.417 at gmail.com>
> > wrote:
> >
> >> This thread has been hijacked and no longer ir relating to the original
> >> request about creating a report for Internal Rate of Return (IRR).
> >> I would like to see an answer to that question.
> >>
> >> On Sat, Apr 8, 2023 at 10:33 AM William Prescott <will at theprescotts.com
> >
> >> wrote:
> >>
> >>> Or, as another example: sites that require a phone number (maybe for
> 2FA
> >>> [second factor authentification]), but only accept US phone numbers. It
> >> is
> >>> a major pain for those of us that don't live in the US, but have
> >> extensive
> >>> dealings with US companies.
> >>>
> >>> Will
> >>>
> >>> On Apr 8, 2023, at 09:18, Michael or Penny Novack <
> >>> stepbystepfarm at comcast.net> wrote:
> >>>
> >>> PS -- What makes you think commercial software is better in that
> regard?
> >>> It will be designed according to how the designers think the majority
> of
> >>> their customers would want. Choice of behavior MIGHT be provided if
> they
> >>> think the minority also a significant number. But often is not.
> >>>
> >>>      For example, I live where there is no cell service. Do you know
> >> what
> >>> percentage of websites requiring account creation REQUIRE a mobile
> number
> >>> (verification by text) vs how many provide an alternative (email of
> land
> >>> line number sent an automated call). I do. I can even recognize one
> >>> situation where I can tell more than one designer involved in the
> design
> >>> (early in the process allows use of the alternative "verify via code
> sent
> >>> by automated voice to a land line or by email" but at the completion of
> >> the
> >>> process "must enter mobile number for verification sent by text" -----
> >>> insanely this is a process for setting up "paperless billing" FOR A
> LAND
> >>> LINE). The point is maybe 97% of people here in the US live where can
> >> have
> >>> a mobile, only 3% live where no service, so forget about them.
> >>>
> >>>
> >>>
> >>> _______________________________________________
> >>> 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.
> >>>
> >>
> >>
> >> --
> >> David Carlson
> >> _______________________________________________
> >> 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.
> >>
> >
> >
> > --
> > _________________________________
> > Richard Losey
> > rlosey at gmail.com
> > Micah 6:8
> > _______________________________________________
> > 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.
>