OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Horse Race Betting Systems (http://forums.ozmium.com.au/forumdisplay.php?f=10)
-   -   losing streak (http://forums.ozmium.com.au/showthread.php?t=13201)

wesmip1 22nd April 2006 05:13 PM

La Mer,

Thanks for passing on the site ..

The ROR software is quite good and thats exactly where I got the results from.

Good Luck

marcus25 22nd April 2006 07:02 PM

Losing runs
 
If you only want to find out how many losing runs you have for a certain win percentage here is a rough and ready code snippet you can put into a dummy macro.
'----------------------------------
Dim x, y, z As Single

z = (100 - ActiveCell.Value) / 100

If ActiveCell.Value <> "" Then

For y = 1 To 100
If x <= 0.992 Then
x = 1 - (z ^ y)
Else: Exit For
End If
'Debug.Print x
Next
ActiveCell.FormulaR1C1 = y
Else: MsgBox "Type in losing %!"
End If
'---------------------------
I put in (0.992) 99.2 % is close enough for accuracy, you can change it.
Once you created the macro just type in a WINNING percentage number into a cell and run the macro. Note! keep that cell as active!!! The number of outs will replace the percentage in the cell.
I know little about Excel, but can guarantee that this code will work.
Most of you can make a better macro out of it than I ever could.
Good luck with it.

marcus25 23rd April 2006 05:58 AM

Likely longest outs the easy way
 
1 Attachment(s)
Here is a text file with the likely longest outs calculated to both 99.2% and 99.99%, from 5 to 90% win strikerate.
Hope it helps.
Cheers


All times are GMT +10. The time now is 03:41 PM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.