We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
Chit Chat
There is currently 1 person viewing this thread.
I've posted this in Genral Betting, but we all know it's quiet in there, so I thought I'd try my luck here.
I have created a couple of spreadsheets for recording bets. Back, Lay, etc but mainly for level stakes or backing a percentage of a bank.
What I want is ficed liablity laying, and I can't seem to be able to work it out. Saying that, I am pretty hopeless with Excel.
So for exmaple, if I wanted a liability of £10, and H3 is my stake & I3 is the lay odds, what would be the calculation?
Cheers.
I have created a couple of spreadsheets for recording bets. Back, Lay, etc but mainly for level stakes or backing a percentage of a bank.
What I want is ficed liablity laying, and I can't seem to be able to work it out. Saying that, I am pretty hopeless with Excel.
So for exmaple, if I wanted a liability of £10, and H3 is my stake & I3 is the lay odds, what would be the calculation?
Cheers.
sort by:
Show
per page
Replies: 6
|
By:
ficed liability laying is the way to go ....
|
|
By:
If I understand you correctly, H3 must be a variable based on the odds available with a fixed stake of £10? In which case I think you would need to use the goal seek function
|
|
By:
I've never even heard of that function. Like I said, I'm quite a novice.
I guess it's probably best to do it manually then. |
|
By:
just open the help file and search for "goal seek" and it should explain it there - but basically you want to make the cell with the liability always have a value of 10.00 by altering the value of H3 using a calculation on H3 & I3
|
|
By:
The formula for H3 is 10/(I3-1)
Why do you need to bother when Betfair do it for you? |
|
By:
Good question Foinavon.
|