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.
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!