I'm struggling to solve a problem with my Excel document so I'm hoping that someone more experienced can help?
I have a cell that updates my account balance after each trade is recorded. I then have in my ROW for each trade the % P&L based on the account balance at the time the row is completed - the problem is that the account balance cell is dynamic so as that changes then so does the individual trade P&L % (win/loss) in each row? I have tried to use the $h$1 cell lock but this is not working?
I started with a £5k balance so what I need to achieve is the % P or L for that particular trade at the time the trade was closed; currently it keeps changing as the account balance changes which is no use for recording purposes?
Can any one help? Thank