Current Balance with Multiple Open Trades

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
CallumPerry
Posts: 575
Joined: Wed Apr 19, 2017 5:12 pm
Location: Wolverhampton

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.
CallumPerry
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?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”