Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

NA in Sharpe Ratio report

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

Postby Alex246 » Mon Mar 13, 2017 10:14 am

Hi,

I created a custom report for my portfolio and selected Sharpe Ratio for display. I'm seeing NA for each investment, and an NA for the total. I updated historical price data right before creating the report.

What information does FM need to produce a Sharpe Ratio report for a portfolio?

Any help will be appreciated.

Alex
Alex246
 
Posts: 1
Joined: Mon Mar 13, 2017 10:10 am

Postby Mark » Mon Mar 13, 2017 2:39 pm

Hi Alex,

For the portfolio Sharpe ratio you need to have all the investments in that portfolio reporting a value. For each investment you need monthly prices, with no gaps bigger than your allowed interpolation range settings. The monthly prices need to be back as far as the "Comparison Period" is set in the "Options / Report Preferences... / Benchmark" tab.

So, check your comparison period, and retrieve historical prices back as far as that comparison period goes, or shorten your comparison period. You can also increase the interpolation range settings to interpolate for a little wider gaps if you're missing prices, like over a long weekend. See "Options / Yield Interpolation Range...". Just for test purposes you can turn on interpolation in all cases by disabling the first option to "Enforce Maximum..." and turn on the second option to "Allow Interpolation Prior to Earliest Recorded Data".
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
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 6 guests

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