Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Yield shows NA

General questions about using Fund Manager that do not fit into any other forum.

Postby alpappy » Thu Oct 31, 2019 8:47 pm

HI Still getting around new version Thanks it looks Great Some of my equities show the yield as NA How can I fix this Any possibility of getting trigger if any share falls or gains more than say 5% in one day
Alan
alpappy
 
Posts: 254
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri Nov 01, 2019 9:56 am

Hi Alan,

Usually NA values in yields are because of insufficient pricing data, or too tight of settings on how much interpolation is allowed. To find out the reason for an NA in a report, choose "Help / Logs / Report Calculation...". It will tell you the specific reason, so you can see how to correct it.

Sorry, we weren't able to add this type of alert. It is something we've had on the list for a while, but hasn't made it in yet.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9776
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri Nov 01, 2019 4:00 pm

The NA is in the portfolio window not a report Can I fix it
alan
alpappy
 
Posts: 254
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri Nov 01, 2019 4:05 pm

Hi Alan,

There is no log for the Portfolio Editor calculations, so calculate that same yield in a Report window, and then look at the report log. The Portfolio Editor calculates yields ending on the current date. So, create a Custom report with the field:

ROI Yield (Between)

Set the report date range to match the length of the yield term in the Portfolio Editor, and ending today. For example, if you have Yield 1y, the dates would be 11/2/18 - 11/1/19 to get the equivalent yield as shown in the Portfolio Editor.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9776
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri Nov 01, 2019 4:09 pm

Where does portfolio editor get the yield from...is it downloaded from server or a calculation I get the NA on random shares All not US based either GPB Eu or CHF
thanks
alan
alpappy
 
Posts: 254
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri Nov 01, 2019 4:13 pm

Hi alan,

It is calculated. You need to have historical price data in order for the calculation to work. Specifically, you need pricing data for the beginning and ending dates of the yield term. For much more detail on yields, see the documentation on yields.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9776
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri Nov 01, 2019 4:41 pm

Only happens on a few non US shares The quotes are from yahoo uk swiss quote and yahoo uk and irelend They are set up the same as other investments using the same server yet in port editor retrurn yield NA I have tried what you advised no luck
alan
alpappy
 
Posts: 254
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri Nov 01, 2019 5:34 pm

Hi Alan,

What does the log file say when you created the Custom report with the yield field?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9776
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri Nov 01, 2019 6:01 pm

nable to calculate ROI yield for DIEGEO for date range 9/4/2013 - 11/1/2019. (Price for investment "DIEGEO" on 9/3/2013 could not be interpolated. Check pricing data or adjust "Yield Interpolation Range..." options.)
Unable to calculate ROI yield for NESTLE for date range 11/2/2011 - 11/1/2019. (Price for investment "NESTLE" on 11/1/2011 could not be interpolated. Check pricing data or adjust "Yield Interpolation Range..." options.)
Unable to calculate ROI yield for COLGATE for date range 11/2/2011 - 4/25/2019. (Price for investment "COLGATE" on 11/1/2011 could not be interpolated. Check pricing data or adjust "Yield Interpolation Range..." options.)
alpappy
 
Posts: 254
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Fri Nov 01, 2019 6:24 pm

Hi alan,

nable to calculate ROI yield for DIEGEO for date range 9/4/2013 - 11/1/2019. (Price for investment "DIEGEO" on 9/3/2013 could not be interpolated. Check pricing data or adjust "Yield Interpolation Range..." options.)


These log entries are saying that you don't have pricing recorded at the beginning of the yield term. For the example above, you were trying to calculate a yield for the date range of 9/4/2013 - 11/1/2019. When you calculate a yield, FM needs to know the price at the beginning and end. That error message is saying you don't have a price for the beginning (9/3/13). You can verify this by looking at your recorded closing prices for this investment in the Data Register.

Even if you don't have a price recorded on exactly the needed date, but have prices near there, FM can "interpolate" a price for you. For example, if you're missing prices for a couple days, but you have the price before/after that, FM will interpolate based on surrounding prices. You control how this interpolation is done, and how flexible it should be in getting a price. See the "Options / Yield Interpolation Range..." dialog for these controls.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9776
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby alpappy » Fri Nov 01, 2019 9:38 pm

Thanks fixed now I am going to upgrade to 2020 do I need a new login code to activate
thanks
alan
alpappy
 
Posts: 254
Joined: Sat Aug 17, 2013 3:59 am

Postby Mark » Sat Nov 02, 2019 6:46 am

Hi alan,

Great, glad you got it fixed. Yes, you would need to purchase an "Upgrade" for FM 2020. You can buy this here. To order an upgrade you need to enter your prior license name and serial number, which you can find under "Help / About..." in the program.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 9776
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to General

Who is online

Users browsing this forum: No registered users and 2 guests

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