Non Runner

[knot]

if a non runner is declared 2 mins before the off how is this shown in BA as its too late to remove the horses from list of runners. I ask this as i only place my selection if the total number of runners is less than 14 and i use BA with excel.

[alrodopial]

if a non runner is declared 2 mins before the off how is this shown in BA as its too late to remove the horses from list of runners. I ask this as i only place my selection if the total number of runners is less than 14 and i use BA with excel.

If horse's name is Muhajaar it becomes Muhajaar (NR)

[knot]

would it be possible to count the number of non-runners using an excel formula?

[throwmeadisc]

=COUNTIF(A5:A40,"* (NR)*")


Try that.

Al

[knot]

throwmeadisc thank you

[knot]

also is it possible using a true/false formula to determine if cell A1 begins with the letter "H" ?

[Ian]

=IF(LEFT(A1,1)="H","TRUE","FALSE")

[Roger]

Or just

=LEFT(A1)="H"

[knot]

thank you

[laffo16]

just back to the old non-runners subject, if the non-runner is declared before the market is opened in BA, i dont think it displays any information about the (NR) at all, can anyone confirm this? and so how do you go about finding the non-runner either from excel or COM in this case?

[PeteB]

If you open the market after the non-runner is declared, then it's no longer in the betfair list of runners. But the API does also return a list of non-runners - I'm not sure if BA picks this up at the mo. It could no doubt send it to another cell in Excel if there was enough demand
(it's just a text string with all the non-runners, so it would then be up to you to split it up and use it as you wanted)

[throwmeadisc]

That Non-Runner information in Excel would be useful to me. Even if it was one string I could split it up. Also the Reduction Factor would be of some use too and the time it was taken out.

What do you say Gary?

Al

[marin71]

Gary,

any chance to get the Non-Runner information added to Excel? Would need it also.

thank you.