Cash price interpolation

[flight]

Mark,

I, or others, may have asked previously but is there a way for cash not to have price interpolation? Is there a setting for me to change? I keep getting the asterik about price interpolation on my portfolio value reports.

[Mark]

Hi flight,

The asterisk means that displayed price was interpolated (there wasn't a price recorded for that specific date). I don't believe you want to not interpolate, but I think you're asking if there is a way to have it not display the asterisk, even when it is interpolating? This is only an option in the Advisor version. It is under "Options / Report Preferences... / General / Show Asterisk When Interpolating Price". The other way to get the asterisk to not display is to record a price for that date in your cash investment.

Interpolating for cash really isn't a concern, you can safely ignore the asterisk, or record a price.

[flight]

Well, for cash, I don't want to interpolate. If all my securities are priced (which they are), and cash was not interpolated (not sure why it needs to be), then asterisk would go away. That's the goal.

[Mark]

Hi flight,

I think we're using the term "interpolate" differently. Let's take an example. If you run a Portfolio Value report for 10/20/17 then every investment listed needs to have a closing price determined for 10/20/17, so a price and market value can be displayed. If your cash investment does not have a price recorded on exactly 10/20/17, then Fund Manager "interpolates" a price based on the surrounding recorded prices. For example, if you had only a single price recorded in cash on 1/1/17 for $1, then Fund Manager will use that $1 price for 10/20/17. It "interpolated" the price of $1 based on the surrounding recorded closing prices. When it has to interpolate to obtain a price it puts the asterisk on that price in the Portfolio Value report, to let you know that price wasn't actually recorded for this date, but was determined by the surrounding recorded prices. For cash this is typically not an issue, as the price usually stays fixed at $1, so an interpolated price is usually just as reliable as an actual recorded price. It may seem like it wasn't "interpolated" since the price is exactly correct, but technically it was still interpolated because it is using a price from 1/1/17 for 10/20/17. Even though the price is exactly correct, it was still interpolated.

If Fund Manager did not interpolate in the above example, it would not be able to obtain a price for 10/20/17 and would have to report "N/A" for the price and market value.

If you don't want to see the asterisk, then you can record a price on 10/20/17 and it will not need to interpolate. You can edit your recorded closing prices in the Data Register under the data type of "Prices".