Charting from Excel in BA

The sport of kings.
Post Reply
Valda
Posts: 106
Joined: Mon Sep 17, 2018 8:11 pm

Atho55 wrote:
Tue Mar 19, 2019 3:37 pm
Yes that is a good start. I had a browse at the Ranking results this morning. Rank 11 & 16 bringing nothing to the party at the moment. Rank 11 is roughly -£2k so might be worth dropping those if they continue to underperform. Can post the results tomorrow for today if you want to do a x check.
That would be interesting - good price rank 5 just won - today will be good.
I’m pretty sure races where 1st fav is < x will be ones to avoid and I reckon x will vary by runners and race type, but maybe not. Worth studying.
Valda
Posts: 106
Joined: Mon Sep 17, 2018 8:11 pm

ShaunWhite wrote:
Tue Mar 19, 2019 4:36 pm
Is this purely based on rank, or some other qualifications? I can't see how rank in itself has any underlying reason to perform long term.
And by looking at rank, aren't you indevertantly just looking at price?
It’s looking at historical occurances and seeking an edge from that. Odd approach yes but as valid as looking at 7 day runners or trainer stats - does the result repeat at a rate which would yield a +ev.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Valda wrote:
Tue Mar 19, 2019 4:49 pm
ShaunWhite wrote:
Tue Mar 19, 2019 4:36 pm
Is this purely based on rank, or some other qualifications? I can't see how rank in itself has any underlying reason to perform long term.
And by looking at rank, aren't you indevertantly just looking at price?
It’s looking at historical occurances and seeking an edge from that. Odd approach yes but as valid as looking at 7 day runners or trainer stats - does the result repeat at a rate which would yield a +ev.
I'd never look at trainer stats etc, that's not my type of thing. I was just curious to understand how rank/price/number of runners had any logical basis.
Don't get me wrong, I've no doubt you're seeing something and I've no doubt you can find anomalies like that which appear to work across a whole year of data....but why would it also be there next year? I don't trust anything I've found profitable last month to work next month unless I've understood why it should still be there. It's like those fund manager performance tables, someone has to be top and most of the time that's the only time they are.
Atho55
Posts: 638
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

There is no guarantee that it will work tomorrow, next week or ever again but what does happen is that horses fall (Sir Erec) outsiders come in and all the other unpredictable stuff that turns into unexpected results.

It`s as simple as that and it`s worked today (I believe), yesterday and the day before so why worry what might happen next year.
Laugro1968
Posts: 83
Joined: Thu Oct 06, 2016 12:04 pm

It's a pretty amazing approach. Does it take race type into consideration (Flat or Jumps)? Does it perform on Hcaps and non-Hcaps alike?
I'll ad it my automated betting for small stakes. We'll see.

Best,
Laurent
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Atho55 wrote:
Tue Mar 19, 2019 7:16 pm
It`s as simple as that and it`s worked today (I believe), yesterday and the day before so why worry what might happen next year.
Worrying what might happen next minute/day/month/year is the game I'm in. But it's differences of opinion that makes a market so the fact I disagree is no great surprise.

When I see a stat that stands out, be it a rank or a course or a footy team on a streak, my first instinct isn't to follow it, it's the opposite, I want to oppose it. But that's because of my faith in mean reversion..... Unless there's a reason for that not to happen.

It comes down to are you a person who thinks 'this will never end' or a person who thinks "this can never last". Life experience colours that I guess but if you posted a stat that says back X because it won for 10 days straight, I'll be laying it. And so a market is formed.
User avatar
wearthefoxhat
Posts: 3220
Joined: Sun Feb 18, 2018 9:55 am

ShaunWhite wrote:
Tue Mar 19, 2019 8:22 pm
Atho55 wrote:
Tue Mar 19, 2019 7:16 pm
It`s as simple as that and it`s worked today (I believe), yesterday and the day before so why worry what might happen next year.
Worrying what might happen next minute/day/month/year is the game I'm in. But it's differences of opinion that makes a market so the fact I disagree is no great surprise.

When I see a stat that stands out, be it a rank or a course or a footy team on a streak, my first instinct isn't to follow it, it's the opposite, I want to oppose it. But that's because of my faith in mean reversion..... Unless there's a reason for that not to happen.

It comes down to are you a person who thinks 'this will never end' or a person who thinks "this can never last". Life experience colours that I guess but if you posted a stat that says back X because it won for 10 days straight, I'll be laying it. And so a market is formed.
As someone, for a long while, spotted trends thinking they could be a new strategy/method only for it to be dashed after doing some simple research on the Adrian Massey site, I can see the sense in what you say. (I do still like to read about stuff that examines the unpredictability of horse racing)

Although only a small sample presented, the range of selections do have a pattern with the odds-ranking and the number of runners.
eg; 4/5/6/7/8th ranked within races of runners of 9 to 18.

This can become a starting point for dutch backing then trading before the off. Laying the 1st/2nd fav's...etc... or as given in the examples, level staking.

It's good to see a different approach, maybe a little sporadic. but it does get the creative juices flowing...
trifletastic
Posts: 13
Joined: Sat May 26, 2018 4:41 am

This is the whole basis of Puntersform isn't it? Or at least the System Finder side of that app.
Valda
Posts: 106
Joined: Mon Sep 17, 2018 8:11 pm

Laugro1968 wrote:
Tue Mar 19, 2019 8:16 pm
It's a pretty amazing approach. Does it take race type into consideration (Flat or Jumps)? Does it perform on Hcaps and non-Hcaps alike?
I'll ad it my automated betting for small stakes. We'll see.

Best,
Laurent
I think Atho has just followed the no. of runners and rank no. that looked promising from his pivot tables and I followed the same today to see what would happen.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

ok stats fans, here's a free edge for you if you like following trends and favouritism rankings. 4,200 dogs so it's a decent sample.

Chart shows £1 level stake commision paid. 300pts profit in a month, easy money.

Lay the dog ranked 4th fav....that's it.
Should be easy in Guardian, £20 a race, 6 grand a month. Set it up and phone the car dealership. Who says nobody ever gives away an edge on here. :)
You do not have the required permissions to view the files attached to this post.
User avatar
ShaunWhite
Posts: 9731
Joined: Sat Sep 03, 2016 3:42 am

Now let's ffwd 6 weeks and see how you all did.....

mmmm not so good is it, i wonder if they'll take the new car back?

But this chart is entirely predictable, laying the 4th fav on dogs has no 'substance', no fundamental reason why it should work. So what we get is a reversion to mean, just as you'd expect. By all means try to make hay while the sun shines on a strategy, but unless you know why it's working, you'll probably need your brolly sooner rather than later.
You do not have the required permissions to view the files attached to this post.
Atho55
Posts: 638
Joined: Tue Oct 06, 2015 1:37 pm
Location: Home of Triumph Motorcycles

Why did you feel the need to introduce a strategy on dogs that does not resemble the gist of the thread. I think most would have found it more constructive to take the criteria, run it through the dataset I know you have from 1st Feb 18 to 19th Mar 19 then we can all look at a historical v current chart.

I don`t think anyone is saying it`s a get rich scheme. It worked for a few days, failed for a lot more days and has just worked for a few more days. It can just as easily start to fail again.

If we can find some clues why it worked when it did then we might be able to find an entry point with less risk.
User avatar
wearthefoxhat
Posts: 3220
Joined: Sun Feb 18, 2018 9:55 am

ShaunWhite wrote:
Wed Mar 20, 2019 3:07 am
Now let's ffwd 6 weeks and see how you all did.....

mmmm not so good is it, i wonder if they'll take the new car back?

But this chart is entirely predictable, laying the 4th fav on dogs has no 'substance', no fundamental reason why it should work. So what we get is a reversion to mean, just as you'd expect. By all means try to make hay while the sun shines on a strategy, but unless you know why it's working, you'll probably need your brolly sooner rather than later.
What could also have happened was that the 4th ranked dog became the 5th ranked dog, after the trend had been spotted by systemites, cos everyone that layed the 4th ranked dog then pushed the price out. In that case you'd need to be flexible with your approach. Good graphs though.

In this thread, at least the range of ranks are covered so offers a little more cover.
User avatar
BetScalper
Posts: 1139
Joined: Sun Jul 02, 2017 10:47 pm

ShaunWhite wrote:
Wed Mar 20, 2019 2:52 am
ok stats fans, here's a free edge for you if you like following trends and favouritism rankings. 4,200 dogs so it's a decent sample.

Chart shows £1 level stake commision paid. 300pts profit in a month, easy money.

Lay the dog ranked 4th fav....that's it.
Should be easy in Guardian, £20 a race, 6 grand a month. Set it up and phone the car dealership. Who says nobody ever gives away an edge on here. :)
Hey Shaun,

What would the profit line look like if the 4th favourite was in Trap 1 at Nottingham, which only has a 14.3% win rate regardless of Ranking ?

😎
Valda
Posts: 106
Joined: Mon Sep 17, 2018 8:11 pm

This can be checked using the HorseRaceBase data in its system builder (not the dogs obviously).
Will try to run all the runner/rank combinations and let you know - might not be today tho. :D
Post Reply

Return to “Trading Horse racing”