Storing Betfair Data

Post Reply
Michael5482
Posts: 1216
Joined: Fri Jan 14, 2022 8:11 pm

Evening

I've started collating data for greyhound markets and as a newbie it's quickly apparent I need a database to store this information! This means more learning which I don't mind. SQL is beyond my technical capabilities but looking online MS Access would appear to be a beginners solution? Would anyone recommend anything else or indeed suggest some creditable MS Access training courses online?

Cheers
User avatar
ODPaul82
Posts: 683
Joined: Sun May 08, 2011 6:32 am
Location: Digswell Herts

With Access you would need minimal SQL as it has a query builder (it's not the most efficient SQL that it creates but does the job)

For learning the basics with Access the following would be fine
https://support.microsoft.com/en-us/top ... AAA=Basics

For a gentle introduction to SQL I'd recommend the following
https://www.w3schools.com/sql/default.asp
User avatar
MemphisFlash
Posts: 2126
Joined: Fri May 16, 2014 10:12 pm
Location: Leicester

Capture.JPG
excel works fine for me
You do not have the required permissions to view the files attached to this post.
mateinone
Posts: 2
Joined: Mon May 02, 2022 6:01 pm

With data collection are you doing it automatically?
Also are you able to do things like collect the back price every say 30 seconds for each horse race and lay that out into one column?
I have found a way to do this, by having a new rule every 30 seconds, naming each rule then exporting all rules to a file.
But it would be nicer if the one rule could rearm itself every x seconds and then outlay that data without all the labels in order of when it was collected.

Of course it is possible to write some "post" scripts to reorder all of the data, but it would be nice to be able to get it all at once within the tool if anyone has any hints on this or example price collection scripts.

I did see one where it outputted data to the one-click screen done by Dallas, but unless I am missing something it still has separate rules for each and I didn't see an export function.
You do not have the required permissions to view the files attached to this post.
Michael5482
Posts: 1216
Joined: Fri Jan 14, 2022 8:11 pm

ODPaul82 wrote:
Mon May 02, 2022 7:00 pm
With Access you would need minimal SQL as it has a query builder (it's not the most efficient SQL that it creates but does the job)

For learning the basics with Access the following would be fine
https://support.microsoft.com/en-us/top ... AAA=Basics

For a gentle introduction to SQL I'd recommend the following
https://www.w3schools.com/sql/default.asp
Much appreciated Paul I will take a look
Michael5482
Posts: 1216
Joined: Fri Jan 14, 2022 8:11 pm

mateinone wrote:
Mon May 02, 2022 9:35 pm
With data collection are you doing it automatically?
Also are you able to do things like collect the back price every say 30 seconds for each horse race and lay that out into one column?
I have found a way to do this, by having a new rule every 30 seconds, naming each rule then exporting all rules to a file.
But it would be nicer if the one rule could rearm itself every x seconds and then outlay that data without all the labels in order of when it was collected.

Of course it is possible to write some "post" scripts to reorder all of the data, but it would be nice to be able to get it all at once within the tool if anyone has any hints on this or example price collection scripts.

I did see one where it outputted data to the one-click screen done by Dallas, but unless I am missing something it still has separate rules for each and I didn't see an export function.
I'm collecting data using an Excel data capture sheet from the forum and not rules files as seems to be the more efficient way (for me anyway). There's some here if you've not come across them viewforum.php?f=54

Cheers
Post Reply

Return to “Betfair Data”