Re: Minor Problem and a Suggestion
[ Q2 00 - Q2 01 Archive ]
[ Current Message Board ]
[ Archives ]
[ Search ]
Posted by Michael Burgess on May 04, 2000 at 20:47:43:
In Reply to: Re: Minor Problem and a Suggestion posted by Mark on April 28, 2000 at 19:38:49:
: : Hi Mark,
: : I usually update prices on my investments once a week on
: : Fridays after market close. April 21st was a holiday, so when
: : I updated prices, some of my investments got updated with a price
: : from thursday, April 20th. When I tried to go into Edit/Prices
: : and correct the date from 20th to 21st, I see that the date
: : field is not editable. Is there any way to correct this problem
: : other than by reentering the same price data manually for the 21st
: : and then deleting the price data for the 20th? BTW, the date
: : comes in as 20th when I did an internet price retrieve. I did the
: : update only on the 21st, but FM seems to insert the date associated
: : with the last available price in the date column.
: : Also, when I pay margin interest, I put it in as negative
: : dividends/interest mainly because the distribution screen does not
: : have a category called margin interest. I think it may be a useful
: : addition though I can manage without it right now. Maybe you can
: : look into this for your next release.
: : Thanks.
: : Balaji Ramanathan
: Hi Balaji,
: Yout cannot edit the date of a price, you would have to record new ones
: for the 20th. Some quote servers return the date of the quote, and some
: don't. When they don't, FM uses the "default date", which you can control.
: By default it is your computer's current date when you do the retrieve.
: You can read up on which servers provide the date, and which will use the
: default date at:
If you have a large number of investments to change (and the data relates to your last update) you can simply edit the "prices.csv" file in the Fund Manager program folder and then re-import the data.
You need to use the "delete all items for one date" option to get rid of the incorrect data, then change the dates in the "prices.csv" file using "search and replace all" in either a text editor or a spreadsheet and then re-import the data.
It is actually easier than it sounds and is preferable to manually updating several hundred stocks.
Having said that, it would be nice to have a "change all dates for one day" function (Mark please note subtle request). Especially as Yahoo UK is not consitent about the time it switches dates - sometimes it happens at midnight sometimes not.