Help
Join Now
Remember me
Forgot your
username
/
password
?
Safer Gambling
Exchange
Sportsbook
Virtual Sports
Betfair Community
Everything
Forums
Blogs
Search
launch community pop-up
Home
›
General Betting Forum
›
Excel Formula Needed
Switch to Community Classic
App Directory
Forums
Forum - How To Join
Announcements
Service
New Products and Features
Forum Chat
Site Feedback
Sports
Football
Horse Racing
Ante Post Racing
Bloodstock & Breeding
US Racing
Cheltenham Festival
Grand National
Golf
Cricket
Tennis
Cycling
Darts
Rugby
Snooker
Greyhounds
Australian
American Football
Basketball
Boxing
Mixed Martial Arts
Irish Sports
Motor Sports
Poker
Games
Other
Specials
General Betting
Chit Chat
Politics
Tradefair & Financials
Your Competitions
Developers
Labs Chat
Help Forum
Guidelines
Terms & conditions
General Betting
Forum
General Betting Blogs
‹ back to topics
There is currently 1 person viewing this thread.
Excel Formula Needed
This user is offline.
TRFC Kev
Date Joined:
18 Aug 02
Add contact
27 Sep 14 21:34
Joined:
Date Joined:
18 Aug 02
|
Topic/replies:
2,201
|
Blogger:
TRFC Kev's blog
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.
Switch to Live View
refresh
Post Reply
Post your reply
Text Format:
Table:
Smilies:
Forum does not support HTML
Insert Photo
Post Reply
Cancel
sort by:
Newest First
Oldest First
My Comments
Show
5
10
20
40
per page
Replies:
1
By:
dave1357
Date Joined:
05 Sep 10
Add contact
When:
27 Sep 14 22:32
If your liability is to be £10 you should divide £10 by the odds -1 to get the stake eg odds are 3 then stake is 10/(3-1)=5 So H3 = 10/(I3-1)
sort by:
Newest First
Oldest First
My Comments
Show
5
10
20
40
per page
Switch to Live View
refresh
Post Reply
Post your reply
Text Format:
Table:
Smilies:
Forum does not support HTML
Insert Photo
Post Reply
Cancel
‹ back to topics
launch community pop-up
www.betfair.com
Betfair