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 <jra...@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 <rlo...@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....@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 <w...@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 < > >>> stepbystepf...@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@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. > >>> > >> > >> > >> -- > >> David Carlson > >> _______________________________________________ > >> 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. > >> > > > > > > -- > > _________________________________ > > Richard Losey > > rlo...@gmail.com > > Micah 6:8 > > _______________________________________________ > > 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.
