Has anyone ever been able to find any good system using solely betfair SP ? (greyhounds)
https://promo.betfair.com/betfairsp/prices
...or is it just waste of time and its just useless piece of crap ?
Does anyone actually use it like...at all ?
Betfair SP database -Useful or Useless?
- ilovepizza82
- Posts: 515
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
- ilovepizza82
- Posts: 515
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
But i think if he had found smth interesting he wouldnt be offering his app services right now
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
All information is useful to an extent but those free files are used by thousands of people so you probably won't find much in them. If you want useful data either get the PRO data and/or start collecting something niche.
- ilovepizza82
- Posts: 515
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Whats in the PRO ver ?
And how much does it cost ?
And how much does it cost ?
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
First link when you google 'betfair data' https://historicdata.betfair.com/#/home
- ilovepizza82
- Posts: 515
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Thanks guys !
Appreciate it !
Appreciate it !
- ilovepizza82
- Posts: 515
- Joined: Thu Nov 02, 2017 3:41 pm
- Location: Sewers
- Contact:
Got it
Thanks Peter.
WHere does the "illumination" come from tho ?
Thanks Peter.
WHere does the "illumination" come from tho ?
- shakey1964
- Posts: 118
- Joined: Mon Nov 19, 2018 2:56 pm
- Location: Usually in my truck
Hi All
I have been slowwwwwly putting together a spreadsheet that may help anyone thinking of laying the fav on UK greyhounds
The attached excel file only has January 2021 stats in it at present but is throwing some interesting figures out
To explain my findings it is important to point out the following points
The sheet named January 2021 has been created from all the "dwbfgreyhoundwinxxxxxxxx.csv files from the website that Ilovepizza refers to for January of 2021
I have deleted all AUS and NZL races and have also deleted all "non favourite dogs records" leaving just the favs for the races, their BSP and some other stuff. (trap number, volume of money, etc.)
The summary sheet can be manipulated to determine the p/l on laying the fav at distance, track, trap number, or race class.
I havnt protected the workbook so if you down load it be careful to only change the entries in cells N5 - N8. These are changed by a drop box
The p/l is determined by the stake amount in cell O1
The P/L figures in cells o6-8 will show green for profit and red for loss and they are totally independent of the other stats. I am still trying to figure out how to get a P/L for a dog that ran at x track over xxx distance in a xx class race so if any bright excel boffin can shine a light I will gladly share this with them for a direct edit to benefit other members.
If anyone has any questions please pm me
just as a started for 10 the profit /Loss in January if you laid all the 3983 favorites at minimum Betfair stake of 2 quid you woud only be 25 quid down
If on the other hand you only laid favs at the Newcastle track then you would have been 77 of the queens sterling pound in profit
More months to come now that I have sussed the basic procedures
I have been slowwwwwly putting together a spreadsheet that may help anyone thinking of laying the fav on UK greyhounds
The attached excel file only has January 2021 stats in it at present but is throwing some interesting figures out
To explain my findings it is important to point out the following points
The sheet named January 2021 has been created from all the "dwbfgreyhoundwinxxxxxxxx.csv files from the website that Ilovepizza refers to for January of 2021
I have deleted all AUS and NZL races and have also deleted all "non favourite dogs records" leaving just the favs for the races, their BSP and some other stuff. (trap number, volume of money, etc.)
The summary sheet can be manipulated to determine the p/l on laying the fav at distance, track, trap number, or race class.
I havnt protected the workbook so if you down load it be careful to only change the entries in cells N5 - N8. These are changed by a drop box
The p/l is determined by the stake amount in cell O1
The P/L figures in cells o6-8 will show green for profit and red for loss and they are totally independent of the other stats. I am still trying to figure out how to get a P/L for a dog that ran at x track over xxx distance in a xx class race so if any bright excel boffin can shine a light I will gladly share this with them for a direct edit to benefit other members.
If anyone has any questions please pm me
just as a started for 10 the profit /Loss in January if you laid all the 3983 favorites at minimum Betfair stake of 2 quid you woud only be 25 quid down
If on the other hand you only laid favs at the Newcastle track then you would have been 77 of the queens sterling pound in profit
More months to come now that I have sussed the basic procedures
You do not have the required permissions to view the files attached to this post.
- shakey1964
- Posts: 118
- Joined: Mon Nov 19, 2018 2:56 pm
- Location: Usually in my truck
Over the last 3 days (Sat 5 feb 22 to Monday 7th Feb 22) I have run a basic lay the fav automation on UK greyhound races covering a blanket system without selecting any race criteria to a £1.00 stake to get a record of the races that favs generally win or more importantly lose and have a running profit of around 20 quid I attach my betting p/l logs from betfair below
file 2 is sunday 6th feb
file 3 is Monday 7th feb
After 39 races so far today I am currently breaking even
I will post todays blanket run in the morning
file 1 is saturday 5th feb file 2 is sunday 6th feb
file 3 is Monday 7th feb
After 39 races so far today I am currently breaking even
I will post todays blanket run in the morning
You do not have the required permissions to view the files attached to this post.
- shakey1964
- Posts: 118
- Joined: Mon Nov 19, 2018 2:56 pm
- Location: Usually in my truck
Just as a footnote for today and a sort of answer to the pizza loving originator of the post as to whether or not the files are useful or useless, a factor I havn't looked at yet but is included in the files is the volume of money matched on the favourite in relation to the second favourite or the rest of the field in respect of "wisdom of the crowds"
for isnstance if the volume of money on the favourite is vastly disproportionate to the rest of the field should the lay be avoided?
If, when you are making a more complex automation file, can this be factored in to the conditions. This question is directed at Dallas more than anyone else as it seems he is the total oracle on this type of thing
for isnstance if the volume of money on the favourite is vastly disproportionate to the rest of the field should the lay be avoided?
If, when you are making a more complex automation file, can this be factored in to the conditions. This question is directed at Dallas more than anyone else as it seems he is the total oracle on this type of thing
Yes it can be factored in, the way to do it would be to use stored values and store a value of the 'a selections traded volume'shakey1964 wrote: ↑Tue Feb 08, 2022 1:56 pmJust as a footnote for today and a sort of answer to the pizza loving originator of the post as to whether or not the files are useful or useless, a factor I havn't looked at yet but is included in the files is the volume of money matched on the favourite in relation to the second favourite or the rest of the field in respect of "wisdom of the crowds"
for isnstance if the volume of money on the favourite is vastly disproportionate to the rest of the field should the lay be avoided?
If, when you are making a more complex automation file, can this be factored in to the conditions. This question is directed at Dallas more than anyone else as it seems he is the total oracle on this type of thing
you'd need to do this for the fav and 2nd fav
Then you'd add a third stored value which would subtract the stored value of the 2nd fav from the stored value of the fav
giving you a stored value of the volume difference
Your lay bet rule can then use a Stored value condition to test the stored value named 'difference' (or whatever you called it) is less or greater than your specified amount
Another option is the same steps as above but instead of storing a selections traded volume you store the volume % of a selection
This gives you a relative comparison to work from (ie, favs traded volume % is 10% greater than the 2nd favs volume%) rather than fixed values which might not always be met each market
- shakey1964
- Posts: 118
- Joined: Mon Nov 19, 2018 2:56 pm
- Location: Usually in my truck
Thanks DallasYes it can be factored in, the way to do it would be to use stored values and store a value of the 'a selections traded volume'
you'd need to do this for the fav and 2nd fav
Then you'd add a third stored value which would subtract the stored value of the 2nd fav from the stored value of the fav
giving you a stored value of the volume difference
Your lay bet rule can then use a Stored value condition to test the stored value named 'difference' (or whatever you called it) is less or greater than your specified amount
Another option is the same steps as above but instead of storing a selections traded volume you store the volume % of a selection
This gives you a relative comparison to work from (ie, favs traded volume % is 10% greater than the 2nd favs volume%) rather than fixed values which might not always be met each market
You have just made my brain melt
Just done a 13 hour day behind the wheel and will have to break down what you just said into very little bits