General questions about using Fund Manager that do not fit into any other forum.
by chris319 » Mon Dec 20, 2021 11:59 am
In the Portfolio Performance report I am getting N.A. in the %Gain column for just one security. All of the other securities have what appear to be valid %Gain values. There is a valid value in the adjacent Gain column for the security in question.
What are the likely causes of the N.A. and is there a fix? I have checked the extrapolation period and found nothing amiss.
Thank you.
-
chris319
-
- Posts: 46
- Joined: Thu Sep 23, 2021 4:34 pm
by Mark » Mon Dec 20, 2021 1:06 pm
Hi chris319,
Select "Help / Logs / Report Calculation..." and you should get an explanation. Let me know if you need further clarification once you read that.
-
Mark
- Site Admin
-
- Posts: 11595
- Joined: Thu Oct 25, 2007 2:24 pm
- Location: Chandler, AZ
-
by chris319 » Tue Dec 21, 2021 4:07 am
Mark wrote:Hi chris319,
Select "Help / Logs / Report Calculation..." and you should get an explanation. Let me know if you need further clarification once you read that.
There is no Report Calculation menu item in the Help -> Logs menu.
-
chris319
-
- Posts: 46
- Joined: Thu Sep 23, 2021 4:34 pm
by Mark » Tue Dec 21, 2021 8:46 am
Hi chris319,
Make sure you are in the report in question, and then it will be there. If you're in a non-report window (Portfolio Editor or Graph), you won't see Report Calculation....
-
Mark
- Site Admin
-
- Posts: 11595
- Joined: Thu Oct 25, 2007 2:24 pm
- Location: Chandler, AZ
-
by chris319 » Tue Dec 21, 2021 4:04 pm
Here is what the log says: Unable to calculate %Gain for TQQQ due to non-positive OOP basis (-66830.17) Unable to calculate %Gain-V for TQQQ. Beginning value is zero or negative (0.00) Unable to calculate ROI for investment CASH_BAL for dates 4/17/2017 - 12/21/2021. (Negative share balance for investment "CASH_BAL" between 4/16/2017 and 12/21/2021.) Unable to calculate %Gain for CASH_BAL due to non-positive OOP basis (-24656.60) Unable to calculate %Gain-V for CASH_BAL. Beginning value is zero or negative (0.00) Unable to calculate ROI for sub-portfolio Margin Account for dates 4/17/2017 - 12/21/2021. (Unable to solve object yield equation) Unable to calculate %Gain-V for Margin Account. Beginning value is zero or negative (0.00)
-
chris319
-
- Posts: 46
- Joined: Thu Sep 23, 2021 4:34 pm
by Mark » Tue Dec 21, 2021 5:06 pm
Did you have any remaining questions after reading that log? If you're wondering about the negative OOP basis restriction on %Gain calculations, see the documentation here: https://www.fundmanagersoftware.com/hel ... n_oop.htmlThe denominator of this equation is your OOP basis. As the OOP basis goes to zero, the %Gain approaches infinite. When the OOP basis is negative, the %Gain is reported as N.A..
-
Mark
- Site Admin
-
- Posts: 11595
- Joined: Thu Oct 25, 2007 2:24 pm
- Location: Chandler, AZ
-
by chris319 » Wed Dec 22, 2021 11:25 am
For some reason I can't make the N.A. go away.
Forget it. I'll use Excel to calculate my IRR.
-
chris319
-
- Posts: 46
- Joined: Thu Sep 23, 2021 4:34 pm
Return to General
Who is online
Users browsing this forum: No registered users and 8 guests
|