Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Portfolio Value - wrong price and total

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

Postby dnaumov » Sun May 10, 2020 2:43 pm

Hi

Been a few years since I last used Fund Manager, just downloaded the eval of the latest version, created a new portfolio and added a single investment, but can't get the Portfolio Value to display the correct price and total value.

ATG1V.HE (updated via Reuters), 4 shares purchased on 2.1.2010 for 32,90€ each with a 1,32€ transaction fee. Current last price is 33,10€.

The portfolio itself shows the correct current total value, which is 132,40€, but Portfolio Value report claims that value = 131,60€ and is showing an interpolated price of 32,90€. Why is it using any sort of "interpolated price" which seems to match the initial purchase cost when it already knows and shows the correct 33,10€ price in the portfolio view?

Similar thing seems to happen to 2nd stock I added, only it's worse as the report shows wrong currency:

1 share of BRKb.N purchased on 13.1.2010 for 226,89$ with a 2,27$ transaction fee. Portfolio default currency is EUR, the share is obviously USD. Portfolio view displays current value of 176,83$, which is the correct last price. Yet, Portfolio Value report shows Value (€): 226,89. Not only is the value not correct (correct would be 163,66€), it displays the initial 226,89$ purchase price as current € value.
dnaumov
 
Posts: 7
Joined: Mon Nov 21, 2011 5:41 pm

Postby Mark » Sun May 10, 2020 3:57 pm

Hi dnaumov,

Prices shown in the Portfolio Value report are not from your transactions. Look at the date of your report, and then look at your recorded closing prices for your investments in the Data Register. Closing prices and transaction prices are separate. In the Data Register, select "Prices" for the Data Type to see only your closing prices, which are the prices that will be used in calculating a market value on each of those dates. A price would be interpolated if you don't have a closing price recorded for the date you're reporting on.

When you record a transaction, if you don't already have a closing price for that date, FM will update the closing price based off your transaction price.
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 10 guests

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