Near-end of the race

[yrufset]

Hello
i wondered:
In Excel triggering, is there a way to know how the race is close to it's end?
My goal is to lay a horse at medium price (i guess between odds 6-10) in the last few seconds, if such one exist?

Thanks in advance,
Love the software

[alrodopial]

Only if you create an in play timer and estimate the duration of the race.
There is no other way.

[mak]

Probably you need the following (it is Gary's Code see the thread also)


'''''Garys timer inPlay
'' http://www.gruss-software.co.uk/forum/v ... hp?t=2404&


Insert the following code into sheet1

Private Sub Worksheet_Change(ByVal Target As Range)
If updating Then Exit Sub
updating = True
If cells(2, 5) = "In Play" Then
If cells(1, 27) = "" Then cells(1, 27) = cells(2, 3)
If cells(1, 27) <> "" Then cells(1, 28 ) = DateDiff("s", cells(1, 27), cells(2, 3))
End If
If cells(2, 5) <> "In Play" And cells(2, 6) <> "Suspended" Then
cells(1, 27) = ""
cells(1, 28 ) = ""
End If
updating = False
End Sub

Create a new module and add the following line.

Public updating As Boolean

Cell AA1 will contain the time the market went in play and cell AB1 will contain the number of seconds from when the market went in play.

[yrufset]

Thanks for the informational reply!
much appreciated
will check it today and report.

[mak]

There are 2 more formulas which can help you
I have mine at cells BT1 & BT2 (switch them for your needs)

BT1 (reads cell A1 end gives the distance of the race-eg 2M)
=IF(MID(A1,FIND(":",A1)+6,1)="",MID(A1,FIND(":",A1)+4,2),MID(A1,FIND(":",A1)+4,4))


BT2 (reads cell BT1 and calculates distance in furlongs-eg 16)
=IF(TYPE(FIND("m",BT1))=16,LEFT(BT1,LEN(BT1)-FIND("f",BT1)+1)*1,IF(TYPE(FIND("f",BT1))=16,LEFT(BT1,LEN(BT1)-FIND("m",BT1)+1)*8,LEFT(BT1,FIND("m",BT1)-1)*8+MID(BT1,FIND("m",BT1)+1,FIND("f",BT1)-FIND("m",BT1)*1-1)))

then you have to place a final formula which depends on how much you estimate the time of a furlong -eg 11.5 sec

so it is 11.5*BT2

[alrodopial]

If you go with the way mak suggested you must know that in many cases BF states the length of a race as i.e. 2m1f and in reality it is 2m & 1 1/2f .
You may have up to 1/2f diff because of the round up.

[mak]

Hi Al
you are right
I really don't know any better way for doing this,
but from my small experience there is not a "need" for a trigger to be so extremely time accurate to make it work...odds are a very strong indicator as well

[osknows]

If you want to be more precise you could factor in the standard course times for each course based on race type and distance. Eg this link gives standard times for Newcastle

http://www.racingpost.com/horses/course ... urse_id=37

[doris_day]

The other factor you need to take into account is that quite often Betfair put their races into play 5 or more secs before the actual off.

[yrufset]

Couldn't ask for better answers,
thanks for your kind advices.

[alrodopial]

Also depending on the ground Good/Heavy etc (and the dist) you may get up to 30secs diff at the same dist with diff going

[osknows]

This thread may also help http://www.gruss-software.co.uk/forum/v ... php?t=5924

[bolpx001]

Hi Doris - how does betfair know to put the race in play 5 seconds before off, is somebody making an estimate based on horses being loaded into stalls? If you are correct then a good price might be just a second or two after the off. I am trying to develop a system and that could just be the key to it unless I have the wrong end of the stick- Paul