Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

NA for 3mo ROI

Questions about updating prices or transactions in Fund Manager

Postby bonafideduck » Wed Aug 31, 2016 6:46 pm

I'm trying to better understand the ROI reports. I created a clean portfolio and imported the attached data with settings. I am seeing NA for the 3mo ROI. There is a yield listed for the TEST portfolio. What causes the NA for the fund ROI?

Data Register.png
Data Register.png (25.43 KiB) Viewed 1166 times

Report Settings.png
Report Settings.png (25 KiB) Viewed 1166 times

ROI Yield.png
ROI Yield.png (16.64 KiB) Viewed 1166 times


PORT,SYMB,YY/MM/DD,TRAN,ANUM,BNUM,CNUM,MEMO
TEST,XYZ,2012/12/31,BUY,10,1,0,note
TEST,XYZ,2013/06/30,BUY,20,1,0,note
TEST,XYZ,2013/12/31,BUY,30,1,0,note
TEST,XYZ,2014/06/30,BUY,40,1,0,note
TEST,XYZ,2014/12/31,BUY,50,1,0,note
TEST,XYZ,2015/06/30,BUY,60,1,0,note
TEST,XYZ,2015/12/31,BUY,70,1,0,note
TEST,XYZ,2016/06/30,BUY,80,1,0,note

Thanks for your excellent support,

=mark
bonafideduck
 
Posts: 7
Joined: Wed Aug 12, 2015 6:41 pm

Postby Mark » Wed Aug 31, 2016 7:43 pm

Hi mark,

It is often due to insufficient pricing data. You need to have pricing data at the beginning and end of the yield term. Your interpolation range settings control how flexible Fund Manager will be in interpolating missing price points. To find the exact reason for the N/A use "Help / Report Calculation Log..." while viewing this ROI Yield report.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby bonafideduck » Thu Sep 01, 2016 5:34 pm

Hi Mark,

Thanks for the quick and helpful reply. I looked at the error log, added a price for 3/31/2016, and the NA went away. I'll now know how to debug this problem in the future. I'll likely make sure to have monthly prices and avoid the issue altogether.

=mark
bonafideduck
 
Posts: 7
Joined: Wed Aug 12, 2015 6:41 pm


Return to Prices and Transactions

Who is online

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