Very interested in achieving the following..

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
marko236
Posts: 737
Joined: Fri Jul 12, 2013 11:54 am

Are you betting 1.5 mil a year then :shock:
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

The whole concept of 'longest losing run' is fatally flawed when you are talking about independent events. If you think that dark forces conspire to ensure that at least one favourite loses in every meeting, you are mistaken.

Let's use a coin flip analogy. The chances of you getting four heads in a row is one in 16. The chances of you getting 8 heads in a row is one in 256.

For the sake of this example, you've just had four heads in a row, and the coin is unbiased. The chances of you now ending up with eight heads in a row is one in sixteen. If you think, "I can safely lay these remaining heads with progressive staking because there's a one in 256 chance of me losing money", you're basing your decision on a statistical fallacy.

As a result, when you bet the house on a 2.0 horse losing, the odds of that horse losing are 50%. Anything that's happened previously is completely irrelevant. You're basically betting the farm on the roulette ball landing on red, which is a crazy strategy.

Jeff
elcapitain wrote:Jeff, how about laying the draw on football? how many draws can a team have in a row? ;)
elcapitain
Posts: 45
Joined: Tue Feb 22, 2011 4:01 pm

Jeff i agree about independent events and it remains 50% but if you add all the odds together, Calculate the LLS it is still relevant.

Many people trade this way when events come close to LLS.
Golfer
Posts: 137
Joined: Fri Nov 04, 2011 10:45 pm

Wouldn't get out of bed for 0.5% gross ROI over x years :D

Are you a £2 punter elcapitain?
elcapitain
Posts: 45
Joined: Tue Feb 22, 2011 4:01 pm

Golfer. Good to hear. Lol. Yes i do £2 A time except when 12 reds in a row at Roulette. Lol.
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

There is no theoretical limit to how many favourites can win consecutively, so there is no such thing as a longest losing streak.

If you spin a roulette wheel enough times, eventually you will get 50 consecutive reds.

The odds of seven horses at odds of 3.0 winning consecutively are 1 in 2187. Bet on enough races, and it's just a matter of time before you get stung.

Jeff
elcapitain wrote:Jeff i agree about independent events and it remains 50% but if you add all the odds together, Calculate the LLS it is still relevant.

Many people trade this way when events come close to LLS.
elcapitain
Posts: 45
Joined: Tue Feb 22, 2011 4:01 pm

Jeff. Has the LLS calculation ever been broken in your experience?
For me not.
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

elcapitain wrote:Jeff. Has the LLS calculation ever been broken in your experience?
For me not.
Last year, 21 favourites in a row came in. The mathematical odds of that (conservatively assuming average odds of 3.0) is 1 in 10,460,353,203. Sorry, but black swans do sail in occasionally.

BTW, I'm pleased that your liability is just £2 (or it that your stake? I hope the former). That means that you're probably not going to go bankrupt with this system (unless you take loss chasing to the nth degree!).

I ran a simulation on my spreadsheet, using £2 liability and a starting bank of £100. To add extra realism, I changed the odds range to 2.5 to 6.0. Anyway, I've attached the simulation. As you can see, you did great for a while before crashing (but at least you didn't lose tens of thousands!). :lol: If you run a few simulations yourself, you'll find that that pattern is fairly typical.

Jeff
You do not have the required permissions to view the files attached to this post.
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

PS My advice to you would be to thank Lady Luck for sparing you for so long, and quit while you're ahead. :)

Jeff
elcapitain
Posts: 45
Joined: Tue Feb 22, 2011 4:01 pm

Jeff. Try favourites at bsp of 3 only and the longest winning streak is 4.

Does your spreadsheet handle that?
marko236
Posts: 737
Joined: Fri Jul 12, 2013 11:54 am

your not getting much backing elcapitain have you wondered why yet, i spent a few years trying to work out how to make money using your system 99% of the time on paper then trying it with small bets, it was a total waste of my time.

you have to find an edge a skill in whether its betting or trading thats the only way to make money.

martingale ended up with nothing, he made money for a while then ended up broke.
elcapitain
Posts: 45
Joined: Tue Feb 22, 2011 4:01 pm

Only 3 Meetings tomorrow. Im guessing its its another winning day for the Cap'n! :lol:
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

elcapitain wrote:Jeff. Try favourites at bsp of 3 only and the longest winning streak is 4.
Nope - the longest winning streak was 6 on the simulation I ran to test your theory. ;) See graph below.

In case that was an anomaly, I did the same on another simulation, and this was what happened at lay 1838:

Horse Lost £2 £0.95
Horse Won £2 -£2.00
Horse Won £4 -£4.21
Horse Won £13 -£13.07
Horse Won £41 -£40.60
Horse Won £126 -£126.08
Horse Won £391 -£391.50

Before then, you were doing great, having built up a £100 bank to over £800.
elcapitain wrote:Does your spreadsheet handle that?
[/quote]
That's like asking if someone's Ferrari can do 80! :lol:

Jeff
You do not have the required permissions to view the files attached to this post.
Iron
Posts: 6793
Joined: Fri Dec 11, 2009 10:51 pm

The chances of 4 consecutive 3.0 winners is 1 in 81.

If you are betting day in, day out, don't you think it's going to happen sooner or later?

It's not a longest losing run by any normal meaning of the term...

Jeff
elcapitain
Posts: 45
Joined: Tue Feb 22, 2011 4:01 pm

But jeff. Stake sizes are much teduced. Its free money.

Rgds
Cap'n
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”