Forums

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

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
pats12
21 Sep 11 21:05
Joined:
Date Joined: 23 Jan 06
| Topic/replies: 87 | Blogger: pats12's blog
Good evening,

Does anyone have a link or excel calculation to help a frustrated gambler here?

For example, if you enter with a lay at 1.1.
The exit point for 50% profit is 1.16.
The exit point for 50% loss is 1.05.

Is there a simple way to calulate the exit points for 1.1, 1.15, 1.2, 1.25 etc (without playing with betfair myself?)

Thanks guys!
Show More
Loading...
Report Lori • September 21, 2011 9:39 PM BST
I've done this a bit quickly, but I think it's right (always easy to miss a +1 or divide a minus sign or some other simple error though)

okay

a1-a10 copy text:

Backer Stake
Lay Price
Profit %
Loss %
Max Red
Max Green
Taken Win
Taken Loss
Amount needed to improve red divided by amount taken off green (plus 1 for odds)
Amount needed to take off green divided by amount to improve red

in B1 put 100
in B2 put 1.1 (you can change this)
in B3 format to percent and put 50 (you can change this)
in B4 format to perenct and put 50 (you can change this too)
in B5 put =-B1*(B2-1)
in B6 put =B1 (yeah it's an unneeded line but I worked it out the slow way)
in B7 put =-(B5*B3)
in B8 put =B5*B4
in B9 put =1+((B8-B5)/(B6-B8)) (I get 1.047619)
in B10 put =1+((B7-B5)/(B6-B7)) (I get 1.157895)

I genuinely have no idea if that's correct, but those two numbers match yours so it probably is. With the lines matching up you can probably fiddle around with my reasoning and see if it works.

*As usual with my excel work, there will be far easier ways.

**I'm off out for a few mins so sorry if I don't help out with further questions or accept any insults/compliments that come from this.
Report pats12 • September 21, 2011 10:24 PM BST
Thanks Lori, very much appreciated!

You might also be able to help with this query......

I am looking for a piece of software/bot that will automatically green out at 50% return on investment (stake)or red out at a 67% loss if the market moves against me (and cancel the other bet)

Is there anything capable of this as I am looking to take it more robotic after a few years on here.
Report pats12 • September 21, 2011 10:24 PM BST
Thanks Lori, very much appreciated!

You might also be able to help with this query......

I am looking for a piece of software/bot that will automatically green out at 50% return on investment (stake)or red out at a 67% loss if the market moves against me (and cancel the other bet)

Is there anything capable of this as I am looking to take it more robotic after a few years on here.
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com