Why do a few positions in portfolio editor show yield since inception as NA I have checked the positions and there is nothing odd about the entries
alan
|
|
Yield shows NA
12 posts
• Page 1 of 1
Hi alan,
To get an explanation, create a Custom report with the field "ROI Yield (Inception)" and set the ending date to the current date. For any N/A values, you will get an explanation under "Help / Logs / Report Calculation...".
Hi Alan,
I didn't understand? Can you rephrase your question or the problem?
Hi Alan,
Can you tell me the exact message in the log file?
Custom Calculation Log
FIF ALAN 6/16/2020 - 6/17/2020 Unable to calculate ROI yield for NFLX for date range 4/12/2018 - 6/17/2020. (Did not own shares for all dates in yield term (7/19/2019)) Unable to calculate ROI yield for ALL for date range 4/1/2015 - 6/17/2020. (Did not own shares for all dates in yield term (5/27/2015)) Unable to calculate ROI yield for CLX for date range 12/22/2015 - 6/17/2020. (Did not own shares for all dates in yield term (11/15/2016)) Unable to calculate ROI yield for CFR for date range 12/12/2013 - 6/17/2020. (Did not own shares for all dates in yield term (9/19/2016)) Unable to calculate ROI yield for GOOG for date range 6/5/2019 - 6/17/2020. (Did not own shares for all dates in yield term (9/3/2019)) Unable to calculate ROI yield for COP for date range 8/15/2018 - 6/17/2020. (Did not own shares for all dates in yield term (5/7/2019)) Unable to calculate ROI yield for VIFN for date range 9/20/2019 - 6/17/2020. (Did not own shares for all dates in yield term (2/14/2020)) Unable to calculate ROI yield for VIPS for date range 4/22/2014 - 6/17/2020. (Did not own shares for all dates in yield term (3/3/2015)) Unable to calculate ROI yield for CSGN for date range 6/3/2013 - 6/17/2020. (Did not own shares for all dates in yield term (7/1/2016))
Hi Alan,
You had at least one time between the beginning/ending yield date range where you didn't own each of these. It is an option on whether you want to calculate yields when you didn't own the item over the whole yield term. See "Options / Yield Interpolation Range... / Only Report ROI Yields When Item is Owned for Entire Yield Term". Press "Help..." in that dialog for a detailed discussion of this option. For example:
This is saying it was trying to calculate the yield from 4/12/18 - 6/17/20, but as of 7/19/19 you didn't own any shares, thus it reported NA. It sounds like you initially bought it on 4/12/18, and probably sold everything on 7/19/19.
Yes, you can make it calculate even if you didn't own it for the whole period. You can either change the yield term to be a different date range, or turn off that option that prevents an ROI from being calculated if you didn't own it over the whole yield term.
Keep in mind if you calculate a yield and didn't own it over the full period, only the time you owned it will be factored in, since ROI is time and money weighted. You can read more about the impacts of this option in the documentation here. In particular, see the section on "Only Report ROI Yields When Item is Owned for Entire Yield Term".
Same problem here
The Yields above the cost value graph all show N.A. except for the gph one, even though I've owned most of them for many years. i.e not showing yields for the interim periods, in my case 3m 6m 1y 3y 5y 10y I did a custom report as suggested and it shows a total yield for each investment I still own for the report period. The log shows a message relating to shares I've disposed of as expected.
Hi amsadl,
If the yields above a graph show NA, you can find the reason for each NA by choosing "Help / Logs / Graph Calculation...".
12 posts
• Page 1 of 1
Return to Prices and Transactions Who is onlineUsers browsing this forum: No registered users and 12 guests |
FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy |
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved. |