Hi, I have this trading log where I need to make some changes. This sheet is for options trading so when I buy say 5 contracts, I am actually buying 500 (5x100) shares. I want to reflect true amount made or lost on the P/L column (O) and true Total Spent column (T) and true Earned / Lost on column (U). Profits on column D are reflected correctly with the multiply by 100 feature. Also, I am getting performance issues.
Last edited: