simple hedge calculator

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
koszmar
Posts: 4
Joined: Sun Oct 09, 2022 12:09 pm

Hello evryone, at the beginning I will say that I am an amateur, I don't have access to betfair (maybe that will change soon) and I have to improvise. I'm looking for a simple ladder hedge calculator where, for example, after entering a back rate in the odds column, it will automatically calculate the lay rate and vice versa. I hope I was understood
User avatar
Derek27
Posts: 23476
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

koszmar wrote:
Mon Nov 28, 2022 12:52 pm
Hello evryone, at the beginning I will say that I am an amateur, I don't have access to betfair (maybe that will change soon) and I have to improvise. I'm looking for a simple ladder hedge calculator where, for example, after entering a back rate in the odds column, it will automatically calculate the lay rate and vice versa. I hope I was understood
Are you talking about simulating a ladder in Excel?
koszmar
Posts: 4
Joined: Sun Oct 09, 2022 12:09 pm

@Derek27

Exactly, I could have described it much simpler :D
User avatar
Derek27
Posts: 23476
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

It's not really straightforward. You'd need a column for the prices. Another to enter your back bets, with a total. Another for your profits on back bets, perhaps hidden, with a total. Then you'd need a column to display your lay stake required. Each cell would contain:

(total profits + total back bets) / price

Do you have a problem with opening a Betfair account? If not it would be far simpler to open an account and use Bet Angel.
koszmar
Posts: 4
Joined: Sun Oct 09, 2022 12:09 pm

Unfortunately I can't access Betfair right now
User avatar
Realrocknrolla
Posts: 1903
Joined: Fri Jun 05, 2020 7:15 pm

I have what your looking for, pretty sure I posted elsewhere!
koszmar
Posts: 4
Joined: Sun Oct 09, 2022 12:09 pm

Thank you for your help, it will help me a lot :)
User avatar
Derek27
Posts: 23476
Joined: Wed Aug 30, 2017 11:44 am
Location: UK

Realrocknrolla wrote:
Mon Nov 28, 2022 6:22 pm
viewtopic.php?t=23122
That is impressive RRR. :)
User avatar
Dallas
Posts: 22674
Joined: Sun Aug 09, 2015 10:57 pm
Location: Working From Home

Derek27 wrote:
Mon Nov 28, 2022 6:54 pm
Realrocknrolla wrote:
Mon Nov 28, 2022 6:22 pm
viewtopic.php?t=23122
That is impressive RRR. :)
+1 that is really cool, i'll make that a sticky topic for you

Image

Just a quick suggestion could you add a 'Clear' button to remove the back/lay/all bets from the ladder?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”