Hi forum
With the Grand National coming up very soon I am just trying to get my data logger spreadsheet ready, thought not to put the name of the event as the subject of this thread.
I have a few questions:
The current template that I have used to build my more complex models with only have room for around 30 selections, I have never seen a market with anything more than about 20 so what happens? Do the selections get pushed through to occupy rows 9 to 89? (40 selections x 2 rows each).
This is my first National trading and data collecting so eager to get prepared. Only 40 runners race but there are more than that named usually isn't there? By the time the market opens, what will it look like? I just need to know the dimensions to to capture and anything else people can recommend; don't want to make any stupid mistakes so any tips would be greatly appreciated.
Also, as a rule of thumb, the money starts coming in so most traders are active around 15/20 minutes out with the 'normal' horse markets so this is when I usually start logging from but how often before this event most year do you suggest I log from?
Callum
Handling Markets with lots of Selections
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
As far as I remember the extra selections just occupy extra rows.
Personally I don't find including novelty events like the GN & Laytown in my std data to be especially useful for what I do, quite the opposite. But I'm sure there's those who find a use for it and would disagree .
Personally I don't find including novelty events like the GN & Laytown in my std data to be especially useful for what I do, quite the opposite. But I'm sure there's those who find a use for it and would disagree .
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
ShaunWhite wrote: ↑Mon Apr 01, 2019 9:35 pmPersonally I don't find including novelty events like the GN & Laytown in my std data to be especially useful for what I do, quite the opposite. But I'm sure there's those who find a use for it and would disagree .
I agree … the 'popular' races bring in money from those that don't regularly bet and that can distort the market (like Frankie with the MILFs at Ascot! )
Thats, why I have my festival data on there own separate analysis sheets (so one for Cheltenham, one for Aintree, one for Royal Ascot and so on) partly because I collect more of it than I do for regular races and in different waysfirlandsfarm wrote: ↑Tue Apr 02, 2019 8:53 amShaunWhite wrote: ↑Mon Apr 01, 2019 9:35 pmPersonally I don't find including novelty events like the GN & Laytown in my std data to be especially useful for what I do, quite the opposite. But I'm sure there's those who find a use for it and would disagree .
I agree … the 'popular' races bring in money from those that don't regularly bet and that can distort the market (like Frankie with the MILFs at Ascot! )
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
or ... "pick a grey one so you can see it."firlandsfarm wrote: ↑Tue Apr 02, 2019 8:53 amI agree … the 'popular' races bring in money from those that don't regularly bet and that can distort the market (like Frankie with the MILFs at Ascot! )ShaunWhite wrote: ↑Mon Apr 01, 2019 9:35 pmPersonally I don't find including novelty events like the GN & Laytown in my std data
Not all women who think Frankie is a DILF are MILFs...he should be so lucky. He rides better looking fillies than 90% of them.
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
Thanks for the replies, so you recommend capturing just the 40 selections in the top 80 rows from around 9am in the morning?
That was my thinking Dallas, I have done the same for Cheltenham festival too with having my analysis workbooks separate from the ‘normal’ races to revisit next year. Chelt had a nice consistent 40 mins between markets going which was easy to see, like I said I’m just trying to get myself ahead with this big one.
When I was little and we went to the dogs I would always watch them coming out and if any had a poo I would bet on it as it was now lighter, that was my theory anyways. I made some money as an 8 year old using that strategy... I may back-test it...
That was my thinking Dallas, I have done the same for Cheltenham festival too with having my analysis workbooks separate from the ‘normal’ races to revisit next year. Chelt had a nice consistent 40 mins between markets going which was easy to see, like I said I’m just trying to get myself ahead with this big one.
That is some good logic anyone know of a website that collects the colour of the horse to add to my data?... I bet there is actually one out there.
When I was little and we went to the dogs I would always watch them coming out and if any had a poo I would bet on it as it was now lighter, that was my theory anyways. I made some money as an 8 year old using that strategy... I may back-test it...
- firlandsfarm
- Posts: 2720
- Joined: Sat May 03, 2014 8:20 am
I'm sure there will be a website that can give a horse's colour but I doubt very much if you will find one recording a dogs bowel activity!CallumPerry wrote: ↑Tue Apr 02, 2019 5:52 pmThat is some good logic anyone know of a website that collects the colour of the horse to add to my data?... I bet there is actually one out there.
When I was little and we went to the dogs I would always watch them coming out and if any had a poo I would bet on it as it was now lighter, that was my theory anyways. I made some money as an 8 year old using that strategy... I may back-test it...
-
- Posts: 3
- Joined: Fri Feb 08, 2019 7:43 pm
If you've got access to the Betfair API then you can get the horse's colour from the runner metadata in the listMarketCatalogue command.CallumPerry wrote: ↑Tue Apr 02, 2019 5:52 pmThat is some good logic anyone know of a website that collects the colour of the horse to add to my data?... I bet there is actually one out there.
I know that's not quite what you are asking but someone might find it useful.