Re: Historical prices

[ Q2 03 - Q4 05 Archive ] [ Current Message Board ] [ Archives ] [ Search ]

In Reply to: Historical prices posted by Michael on February 07, 2005 at 14:23:35:

: Hi Mark,

: I am relatively new to fund manager and have recently just completed setting up my portfolios. So far, it is going great.

: I have two questions:

: 1) How can I import historical prices for particular investments for certain date ranges. A lot of the investments i set up i have owned for a number of years. After inputting all the transaction, i only have price points for the particular transaction dates. When I run performance reports for certain date ranges, fm estimates prices for the particular dates if an actual price is not populated for that date. To overcome this issue and have accurate reporting, i need to be able to import the historical prices.

: 2)With regards to unexercised stock options, how do i get fm to reflect just the spread between the current stockprice and the strike price. Currently, it is reflecting the value as if the option has already been exercised and the underlying security is the asset.

: Thanks for your help.

Hi Michael,

1) Just go into "Options / Internet Settings..." and change the default
quote server to Yahoo (Historical) and then do a price retrieve. If you
haven't done a price retrieve yet, check out:
http://www.fundmanagersoftware.com/intrtv.html

By default a price retrieve gets prices for all your open investments. If you
only want to update a few, select them in the Portfolio Editor, and then
right mouse click and choose "Retrieve Selected Prices".

2) These sound like employer granted options? Fund Manager doesn't have
support for these. One (rather ugly) work-around is to add in a
cash account with a negative balance, equal to the grant value, so that the
sum of the 2 investments equals your real value. This works okay if the
actual price is above your grant price.

Thanks,
Mark
--
Mark Beiley
Fund Manager, portfolio management software for Windows 95/98/ME/NT/00/XP/2003

Replies: