Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Yield shows NA

Questions about updating prices or transactions in Fund Manager

Postby alpappy » Tue Jun 16, 2020 2:10 pm

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
alpappy
 
Posts: 354
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Tue Jun 16, 2020 3:57 pm

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...".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Tue Jun 16, 2020 4:29 pm

HI Mark Done that I am using since inception so that should cover all dates not NA Am I missing something?
alan
alpappy
 
Posts: 354
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Tue Jun 16, 2020 4:38 pm

Hi Alan,

I didn't understand? Can you rephrase your question or the problem?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Tue Jun 16, 2020 4:47 pm

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
alpappy
 
Posts: 354
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Tue Jun 16, 2020 5:00 pm

Hi Alan,

Can you tell me the exact message in the log file?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Tue Jun 16, 2020 5:11 pm

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))
alpappy
 
Posts: 354
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Wed Jun 17, 2020 7:47 am

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.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Wed Jun 17, 2020 2:10 pm

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
alpappy
 
Posts: 354
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Wed Jun 17, 2020 3:56 pm

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".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby amsadl » Wed Oct 27, 2021 9:31 pm

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.
amsadl
 
Posts: 9
Joined: Fri Sep 26, 2008 12:17 am

Postby Mark » Wed Oct 27, 2021 10:20 pm

Hi amsadl,

If the yields above a graph show NA, you can find the reason for each NA by choosing "Help / Logs / Graph Calculation...".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11252
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Prices and Transactions

Who is online

Users browsing this forum: No registered users and 18 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.