Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread 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

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread John Ralls
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, J

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread edodd
On Sat, 8 Apr 2023 13:00:43 +0100 Graham wrote: > I have tried the manual without much success, and tried two different > AIs [ChatGPT and Nova] but both give me instructions that don't seem > to exist, such as : I was wondering if the AI was capable of answering questions as well as the users.

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread R Losey
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 wrote: > This thread has been hijacked a

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread Adrien Monteleone
I long ago turned off auto-saving drafts for that very reason. Mail.app on MacOS does the same. It will auto-save while you are typing at various stages and you'll end up with multiple drafts of the same in-progress message. I consider that a bug for both apps. I see neither has been addressed

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread Adrien Monteleone
ChatGPT and other 'AI' bots are merely really fancy auto-complete. They produce 'plausible' text, but they have no concept of accuracy or any understanding of the meanings of any of the words used. I have no fear of them because I understand that is what they are. My fear is that others think

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread David Carlson
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 wrote: > Or, as another example: sites that require a phone

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread William Prescott
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 P

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread Michael or Penny Novack
On 4/8/2023 10:27 AM, Stan Brown wrote: Thunderbird autosaves drafts, and they do not disappear automatically from the Drafts folder after you send the message. You have to delete them manually. (It's bad design, I agree, because it leads to confusion. But there it is: we get what we pay for.)

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread Stan Brown
Thunderbird autosaves drafts, and they do not disappear automatically from the Drafts folder after you send the message. You have to delete them manually. (It's bad design, I agree, because it leads to confusion. But there it is: we get what we pay for.) Stan Brown Tehachapi, CA, USA https://Brow

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread Stan Brown
On 2023-04-08 05:02, Graham wrote: > I have tried the manual without much success, and tried two different > AIs [ChatGPT and Nova] but both give me instructions that don't seem to > exist, such as : > > 1. Click on the "Reports" menu and select "New Report". > 2. In the "Report Type" dropdown, s

Re: [GNC] Calculating IRR of an investment account

2023-04-08 Thread G R Hewitt
The clue is in the name - Artificial Intelligence (AI) adjective: artificial: made or produced by human beings rather than occurring naturally, especially as a copy of something natural. Fear not, AI is much stupider. On Sat, 8 Apr 2023 at 13:01, Graham wrote: > I have tried the manual wi