Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

My reports are littered with N.A. values

Questions on using, creating, or understanding data in Fund Manager reports.

Postby Milli » Thu Sep 02, 2010 9:30 am

When creating Performance Reports I get lots of N.A. values in the Gain% and Yield columns. I create transactions lists in .CSV format and import those into Fundmanager. Import string looks like this:

YY/MM/DD;PORT;CURRENCY;TRAN;SYMB;BNUM;ANUM;CNUM;NAME;ITYPE;ASSET;GOAL

Are those N.A.'s a bug in Fundmanager?

By the way, the "Subtotal by:" does not work in 10.7. The dropdown only shows "Sub-portfolio" and no other selections. Works fine in 10.6.

Thanks

Milli
Milli
 
Posts: 13
Joined: Tue Nov 17, 2009 6:16 am

Postby Mark » Thu Sep 02, 2010 9:44 am

Hi Milli,

You may get N/A when it doesn't make sense to report a particular number. For example, if you've sold everything, %Gain will be N/A. Yield can be N/A depending on your date range, and yield interpolation range settings. It doesn't matter how you get your data into Fund Manager (manual entry, importing, retrieve), as long as the recorded data makes sense for the figure you're asking for, it will be reported.

To look into one closer, look at the equation for %Gain in the online help. Select "Help / Help on Report..." while you're looking at a Performance report. Look at your recorded transactions for a certain investment, and look at the date range of your report, and see what you would expect it to report. If you would like help. please post an example, as in what transactions are recorded, and what date range you're looking at.

I could not reproduce a problem with the sub-total option in reports. Can you still reproduce this? What report type are you looking at, and what "List By" option to you have selected?
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11807
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Reports

Who is online

Users browsing this forum: No registered users and 1 guest

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