Build a database to test a strategy

[Ianhski]

Hi,

I am working on a strategy and will try to automate it - will probably ask AI to help me build and automation as I am a novice and probably miss safeguards.

Anyway, I would like to get some race stats so I can then try some limited back testing. I am paying for BA so wondering if it can help build this?

At this point, if anyone knows of free race stats I can utilise, please let me know!

I was thinking of loading Guardian with races in UK, and
Capturing at least BSP but ideally prices for all runners at some intervals prior to off.
Capturing the winner at least but ideally the top 4 place results
If available, also capture jockey and trainer names
Obviously include event details
Can I have an automation to do this?

I would then export to Excel and with AI help, analyse strategy idea and build a series bots

Yes, I can pay another subscription to do this but that is on-going cost and I want to put BA to work so I can recover BA Pro cost soon, starting with a low bank of £100-200 and % of bank staking so stakes and winnings will be low.

I hope this makes sense and could be useful to others
Thanks, Ian

[tico]

Hi Ian
Try the adrian massey site ,it's completely free and is by far the best horse stats site in the net.It's not a downloadable database though ,but you can examine every aspect of horse racing via it's custom reports .
www.adrianmassey.com
Regards
Tico

[Ianhski]

Ooh, interesting. I will take a look.

BA question re collecting info remains, I saw a video where Peter clearly collected lots of data and it got me wondering.

Thanks
Ian

[Aberdeentrad]

Hi,

I am working on a strategy and will try to automate it - will probably ask AI to help me build and automation as I am a novice and probably miss safeguards.

Anyway, I would like to get some race stats so I can then try some limited back testing. I am paying for BA so wondering if it can help build this?

At this point, if anyone knows of free race stats I can utilise, please let me know!

I was thinking of loading Guardian with races in UK, and
Capturing at least BSP but ideally prices for all runners at some intervals prior to off.
Capturing the winner at least but ideally the top 4 place results
If available, also capture jockey and trainer names
Obviously include event details
Can I have an automation to do this?

I would then export to Excel and with AI help, analyse strategy idea and build a series bots

Yes, I can pay another subscription to do this but that is on-going cost and I want to put BA to work so I can recover BA Pro cost soon, starting with a low bank of £100-200 and % of bank staking so stakes and winnings will be low.

I hope this makes sense and could be useful to others
Thanks, Ian

Hi Ian,

Yes possible to do most, if not all of what you are looking for with BA (not sure about place results but winner can be done).

The BA API is useful for this, I use a Python script to write to a SQL database, SQLite is a useful free database tool for looking at the data. Basically load the races into guardian and the python script can be used to record whatever data you want at a frequency you choose. You can use another python script to clear old markets and load the next days markets in guardian so it would be hands off once its set up. The BetAngel user manual has some good API documentation but happy to share the scripts if it helps, you'd need to update to suit your needs though.