Might be a really dumb question (I love how most posts on this forum start this way, I’m just as guilty) but is there a way to show my bank balance in a spreadsheet where it shows my current total balance if I were to close all trades now?
For example, if I have £100 in my account then Cell C4 will show £100. If I put £10 on a selection and it goes in my favour so my current closing option is say 20p profit, then I want a cell to show £100.20. At the moment it just shows £90 (as I have staked £10) and my green up as 20p lower down. I want the balance + staked amount + current green up.
In a simple one selection example like this it seems easy to figure out but what about if I have open trades on all 20 runners in a 20 horse race? Is there a clean, efficient way of showing this?
Cheers,
CPerry.
Current Balance with Multiple Open Trades
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Anybody?
Horse 1 = 6p up
Horse 2 = 14p up
Horse 3 = 4p down
(Total profit = 16p right now)
Rest of horses have not been traded. £100 in bank to start with. I've placed three £10 bets so C4 is currently showing my balance as £70. I want a cell to show me £100.16 as this would be my total balance if I were to green everything right now. Suggestions please?
Horse 1 = 6p up
Horse 2 = 14p up
Horse 3 = 4p down
(Total profit = 16p right now)
Rest of horses have not been traded. £100 in bank to start with. I've placed three £10 bets so C4 is currently showing my balance as £70. I want a cell to show me £100.16 as this would be my total balance if I were to green everything right now. Suggestions please?