Thanks for the heads up in the individual % gain/loss there chookie, i never noticed it myself. I was adding up the totals of the 6 above % gains/losses rather than % on the 600,000.00 number itself. It's now been corrected. So thank you. Tedious indeed, putting is the data was the easy part, it was making the formulas correct which took the longest. But once that was right just a quick copy paste to all the relevant cells and it was done.... well, that particular area to which that formula was working :P Then it was onto the next formula. :(
finserv I have changed your SSNO to SSN... for some reason the "updating data" isnt pulling the option price all the time, just here and there. Then its leaving your SSNO as a full 100,000.00 loss. Due to the data closing price being shown as 0.000. So just to make it work all the time ive replaced the option to the fully paid share, Sorry about that.
