News Focus
News Focus
icon url

Conrad

05/07/10 3:57 AM

#31802 RE: mille01652 #31796

On Stock Splitting: OK Mille01652, good to hear that you found "the split-fix". I am sure I did something in the past.

I have not yet time to look at why my first attempt did not work for me: The PC for the next entry did not remains constant. . . I think it is because the `PC-change` calculation in my case uses the share price instead of total value. . .so when the price goes to 50% the PC seed a drop in value of 50% and this generates a huge Buy for the next entry. That must be it. . .The PC must of course remain the same.

icon url

Conrad

05/08/10 9:11 PM

#31811 RE: mille01652 #31796

Hi mille01652,

I finally had a look today at my spreadsheet for the stock split 2:1 and found my error. Maybe you are doing the same as I now:

1) On the price column I went from $40 to $ 20.
2) Right next to it on the same row is the Qty of the shares calculated the previous entry after a trade and I doubled that. That's all! The PC remains the same as before now.

In principle this procedure must be the same as you have done but you are using a different column to change the share quantity. The simple procedure is exactly as I stated it before but I made the error to change the share quantity in the wrong column and that the reason the my PC increased!

It is May. . are you too going away?
I have no stocks now, so I am not going anywhere :-)

It seems like a good time for Americans to buy Euro's now!