Major new features

[llama]

It is blank for historical markets.

Will it ever become available?

[SWV]

[quote="GaryRussell"][quote="SWV"]Thanks Gary.

Also only one meeting (Lingfield) on 04/03/22 for British horse racing. There should be four.[/quote]
The data simply isn't available from Betfair yet. Usually all data is available from 6 days ago, anything newer cannot be guaranteed.[/quote]

Ok that’s great info. Thanks for the speedy reply.

[llama]

[quote="GaryRussell"][quote="llama"]Is it just me, but when I tick 'Race Status' from the Additional columns box, I can see the heading in my Z4 cell of 'Race Status', but underneath there is no sign of the status?

The Result tick box within Additional columns works fine.[/quote]
Is it blank for live markets or historical markets? It's not included in historical data so isn't available.[/quote]

Can someone help me please:

It is just that historically, i have used 'Race Status' to quantify the length of a race. Using VBA, I count how many seconds the Race Status has a value of "OFF".

What do other people use to calculate the duration of a race?

A long while ago I used to the F2 field which has a value of "Unsuspended" whilst the race is running, however, the problem with that is that on close finishes, the market goes back to "Unsuspended" after the race has finished for post trading.

[GaryRussell]

Is it just me, but when I tick 'Race Status' from the Additional columns box, I can see the heading in my Z4 cell of 'Race Status', but underneath there is no sign of the status?

The Result tick box within Additional columns works fine.

Is it blank for live markets or historical markets? It's not included in historical data so isn't available.

Can someone help me please:

It is just that historically, i have used 'Race Status' to quantify the length of a race. Using VBA, I count how many seconds the Race Status has a value of "OFF".

What do other people use to calculate the duration of a race?

A long while ago I used to the F2 field which has a value of "Unsuspended" whilst the race is running, however, the problem with that is that on close finishes, the market goes back to "Unsuspended" after the race has finished for post trading.

Are you trying to determine the actual duration of the race or the time until betting is fully suspended (ie. after photo finish)?
If it's just the time spent racing then it's from the time "In Play" appears in E2 until "Suspended" appears in F2 at the end of the race. "Suspended" can briefly appear when it first goes in play so just ignore it if it appears in the first 20 seconds for example.

[GaryRussell]

It is blank for historical markets.

Will it ever become available?

I will ask Betfair if we are allowed to record it ourselves. I also plan to include silks, jockey, trainer etc. which I we will have to record ourselves so it will only be available from the time we start recording it.

[llama]

[quote="GaryRussell"][quote="llama"]It is blank for historical markets.

Will it ever become available?[/quote]
I will ask Betfair if we are allowed to record it ourselves. I also plan to include silks, jockey, trainer etc. which I we will have to record ourselves so it will only be available from the time we start recording it.[/quote]



i wouldn't worry too much.

I am sure I can capture T1 as it goes Unsuspended and then make sure that I ignore any subsequent Unsuspended instances.

One thing I would like to be confirmed is that my observation is that horse prices that are traded 2 hours before a horse race are NOT available?

[llama]

Just to confirm that I am looking to quantify the time it takes from the start line to the finish line.

Using T1 whilst F2 is "Unsuspended" does not work for me as a race goes back to "Unsuspended" on photo finishes after the horses have crossed the line.

[GaryRussell]

One thing I would like to be confirmed is that my observation is that horse prices that are traded 2 hours before a horse race are NOT available?

You can load them from the time the market opens if you wish. Just select historical data tab in preferences and change the value in the drop down list.

Screenshot 2022-03-09 093941.png (10 KiB) Viewed 33848 times

[llama]

[quote="GaryRussell"][quote]One thing I would like to be confirmed is that my observation is that horse prices that are traded 2 hours before a horse race are NOT available?[/quote]
You can load them from the time the market opens if you wish. Just select historical data tab in preferences and change the value in the drop down list.

[attachment=0]Screenshot 2022-03-09 093941.png[/attachment][/quote]

WOW! That is brilliant....I did not see that option.

Thank you......

[GaryRussell]

Just to confirm that I am looking to quantify the time it takes from the start line to the finish line.

Using T1 whilst F2 is "Unsuspended" does not work for me as a race goes back to "Unsuspended" on photo finishes after the horses have crossed the line.

I'm not sure what you have in T1 in your spreadsheet. Surely suspended appears before they reopen the market so not sure why photo finishes would make a difference.

[GaryRussell]

Look at Kempton 5th Oct 2021 20:30. It's suspended at 20:32:09 at the end of the race at which time you would record it. There is a photo finish followed by a final suspension, but you can ignore that as you would have opportunity to record the first suspension time.

[llama]

[quote="GaryRussell"][quote="llama"]Just to confirm that I am looking to quantify the time it takes from the start line to the finish line.

Using T1 whilst F2 is "Unsuspended" does not work for me as a race goes back to "Unsuspended" on photo finishes after the horses have crossed the line.[/quote]

I'm not sure what you have in T1 in your spreadsheet. Surely suspended appears before they reopen the market so not sure why photo finishes would make a difference.[/quote]


i wrote this code some 12 years ago, when my VBA skills were very limited, and i used to 'Save' T1, within VBA, whilst F2 was "Unsuspended". T1 is the perfect field seeing that it initialises itself to 0 at the start of a race and increments from then on, one second at a time. This concept worked perfectly seeing that F2 would go to "Suspended" as soon as the horses crossed the line and I would have captured the latest and largest value of T1 whilst F2 was "Unsuspended".

However, on Photo Finishes, F2 would go back to "Unsuspended" and I would therefore capture erroneous values of T1, whilst there was photo finish trading after the race. T1 continues to be incremented and I would continue to capture it, seeing that F2="Unsuspended" during post trading in photo finishes.

Then Race Status came along and that made my life so much more simple seeing that all I had to do was capture and save T1 whilst the Race Status was equal to "OFF" seeing that Race Status only stays as "OFF" whilst the horses were running and goes to "Finished" even after a Photo Finish.

But as I say, i am sure i can find a method of capturing T1 and making sure that photo finishes do not confuse me.

[NorthView]

There are still some issues with the balance. I placed some bets on a racing market resulting in a £14.12 profit but the balance increased by £28.24 (twice the profit).

[GaryRussell]

There are still some issues with the balance. I placed some bets on a racing market resulting in a £14.12 profit but the balance increased by £28.24 (twice the profit).

If you know how to replicate this it would be helpful. I haven't seen this while testing.

[NorthView]

I sent you an email with a screen shot which I hope will help.