I have Data .......

[thunderfoot]

I have data that covers the 5 minutes, in 3 second steps, leading up to 20 seconds before the scheduled start time, (c. 90 records for each race) and covers the first 16 selections in a race (so 17th+ runner not available ...... EXCEL limitations!!).

Only did this because I wanted to 'crack' the often asked question of how to record data in EXCEL

What does the team think I/we/you can do with this?? Polite replies only please.

[throwmeadisc]

No idea....

But if you want to get past Excel limitations... move to Excel 2007.

Worksheet size 1,048,576 rows by 16,384 columns

http://office.microsoft.com/en-us/excel ... 91033.aspx



Al

[Spike]

I tried moving to excel 2007 but it made all my code take 5 times longer to execute so I moved back. Bloody Microsoft.

[doris_day]

Doubt it has much use really...a lot can happen in 3 secs so anything you read into the data may not be valid.....

[Steve Voltage]

I have data that covers the 5 minutes, in 3 second steps, leading up to 20 seconds before the scheduled start time, (c. 90 records for each race) and covers the first 16 selections in a race (so 17th+ runner not available ...... EXCEL limitations!!).

Only did this because I wanted to 'crack' the often asked question of how to record data in EXCEL

What does the team think I/we/you can do with this?? Polite replies only please.

How many races ? From what date ?

[osknows]

If you have data for just a few races then perhaps not too useful...but...

If you are able to build sufficient samples you could build a time series prediction tool to assess movement and projected odds

How accurate all of this could be..who knows?

[osknows]

Excel 2003 should be sufficient for amount of data if you structure it correctly

Take 1 race, 17 runners, say 5 minutes data capture at interval 3 seconds capturing back and lay (best price of each only)

One row per horse
Each horse/row requires 2*(5*60)/3 = 200 columns for odds capture alone

Leaving another 55 columns to capture other race/horse specific data

[thunderfoot]

How many races ? From what date ?

From 28th July, so c. 200 races so far.

[Steve Voltage]

Let me know when you have five years worth

[thunderfoot]

Let me know when you have five years worth

.......... then I'll be charging for it

[Steve Voltage]

Let me know when you have five years worth

.......... then I'll be charging for it

Then you will be in court