Yield shows NA

[alpappy]

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

[Mark]

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...".

[alpappy]

HI Mark Done that I am using since inception so that should cover all dates not NA Am I missing something?
alan

[Mark]

Hi Alan,

I didn't understand? Can you rephrase your question or the problem?

[alpappy]

Hi The button I ticket is to show the yield since inception I get the error on the log that the date range is not covered and that shows as yield NA yet Sureley inception means from the first time the shares were owened
alan

[Mark]

Hi Alan,

Can you tell me the exact message in the log file?

[alpappy]

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))

[Mark]

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:

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))

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.

[alpappy]

Hi yes I sold then bought back all of the positions and it still cannot calculate the yield can the software be altered to take into account last purchase date or average

[Mark]

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".

[amsadl]

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.

[Mark]

Hi amsadl,

If the yields above a graph show NA, you can find the reason for each NA by choosing "Help / Logs / Graph Calculation...".