This is a risk analysis app.
I'm not very good at sheets and looking for advice
Can anyone advise how to adjust the account balance to account for each time pnL unrealized updates? I'd like it to accumulate all the numbers that are Generated each time the page refreshes?
For example if page refreshes 3 times and the values of purple pnL unrealized happened to be -200, 500, 250
Account balance would update each time and would finally read
Account balance = $50,550.
I'm using the random number generator =RANDBETWEEN(-C6,C6) For the pnL unrealized.
Not great at these formulas and any advice would be greatly appreciated! Thank you in advance!
Aucun commentaire:
Enregistrer un commentaire