Replies to post #8693 on A.I.M. Users Bulletin Board (AIMUSERS)

[Conrad]

Linda,


You wrote:

I was trying to input a Buy of 5000 shares at 1.475 but input it at 147.50. According to notepad, this changed Portfolio Control from 620363 to 251613.1

(????How can de PC go down on a Buy???? I thought that in Newport the pc-update is PC(new)=PC(old) + 1/2*Buy.

I am not sure if this will work for you but I think you can simply enter a negative buy of the same (wrong) magnitude as the Error Input. This should return the Portfolio to the same position as before:

5000 shares @ $ -147.50

The PC and the share value should then return to the original values. If negative prices are prevented then you might get an Error message. Then try a Buy with a negative share quantity, or a Sell of the same magnitude.

In my program(Vortex) I can simply correct such mistakes by using a Sell of the same magnitude or using negative Buy parameters.

[bernieg]

Hi Linda,
Here it is from the Newport Help file:"If you make an error on a trade (the wrong number of shares, wrong price, wrong date, etc.), the best thing to do is to reverse it. To do this enter the trade again with all of the same (incorrect) information, but change the number of shares traded to a negative (place a minus sign [-] in front of the number). This will reset all of the information that was changed in error including Portfolio Control and Original Investment. Then go ahead and enter the trade correctly."
Bernie

[smilin]

Linda,

My spread sheet calculates PC, stock value, safe value, cash available, buy/sell recommendation, total shares owned, and portfolio value. All you have to do is input the stock price and the number of shares you have bought or sold and the spread sheet does the rest. It is a simplified version of the Exel spread sheet that's floating around out in cyberspace. I like it because it is very simple and, since I wrote it, I know exactly what its supposed to do.

Smilin'