i need help before my accountant kills me!!
i need to make a spreadshet for trades, and im stuck on my P&L cell.
here is my cell assignments ...
E2 = POSITION
F2 = BUY PRICE (per share)
G2 = SELL PRICE (per share)
H2 = COMMISSION
what i need (without the excel code) is this: (((E2*G2)-(E2*F2))-H2)
i cant get it to work for anything! so let me step it out and maybe someone can help ...
step 1: PRODUCT(E2*G2)
step 2: PRODUCT(E2*F2)
step 3: SUM(step1 - step2)
step 4: SUM(step3 - H2)
total should be total profit or loss.
i know this is off topic, just hoping someone here can ehlp me! im really in a bind ...
here is a recent trade i made inside the workbook ...
CLICK HERE TO SEE WORKBOOK