What is the best way to record the data of the races e.g price traded ranges and volumes?
Are there any sheets on the forum that are available? I am terrible with excel
Trading Psychology : How long does it take to judge whether a system is working?
There are several data capture sheets in the data sectiondragontrades wrote: ↑Fri Jul 27, 2018 1:30 pmWhat is the best way to record the data of the races e.g price traded ranges and volumes?
Are there any sheets on the forum that are available? I am terrible with excel
viewforum.php?f=54
Do you find these niches have longer term profitability or does the market spot the "hole" and/or revert to mean after a short period so you have to identify the next niche ? Or is that asking too much info
Most of them seem to be structural in terms of the way the market operates. But everything changes, always.
 Kafkaesque
 Posts: 482
 Joined: Fri Oct 06, 2017 10:20 am
In terms of sample size and drawing conclusions, I would only deem it legitimate once it’s mathmatically sound, and you need such a big sample size to do so, that it isn’t really relevant, particularly at the price range you’re operating in, where the variance is going to be huge. I’ll be posting a potential formula in a minute in response to another post here. I say potential because apart from sharing, I’d love to have the math sanitychecked.dragontrades wrote: ↑Thu Jul 26, 2018 10:56 pmI have been testing a straight betting strategy in practice mode for a while now so a few days ago I started running it for real on small stakes.
It had a bad day today which has got me worried.
I know you need to run these things for a long, long time to get a good big enough sample but when is the right time to stop and adjust some parameters or kill of the strategy?
And how large does the sample size need to be before making a judgement?
The strike rate is around 1in10 and I am staking by book % so how many races would be enough to draw some conclusions? Is there a formula for figuring the sample size out?
Hopefully someone can point me in the right direction
As the next best thing to mathmatical certainty (or anywhere close to it), you’ll just have to do your best to dissect and analyse your spots as objectively as possible afterwards. With the goal being to try to determine, whether your net results – no matter if they’re positive or negative – are primarily the result of sound strategy or variance. Some things to consider: Did the market behave as you expected before and after you got in? Did the price at the off end up shorter or longer than the price you got? Did some freak occurence influence the end result? And anything else during the race which may suggest whether you were actually on to something or not pre. I’m not a horse racing trader, so that is most likely an incomplete list. How long or what sample size, before you can determine anything from that, is then imo a matter of how strong indicators you feel you get from the above, and how confident you are/were in the strategy in the first place.
I’d very much second Euler’s input. Subdivide your results in as many formats as you can possible think of. It’ll of course make the variance even greater, with the smaller sample for each subcategory, but it can very much open to specific spots where the strategy works best, among other things.
 Kafkaesque
 Posts: 482
 Joined: Fri Oct 06, 2017 10:20 am
Once upon a time on this www thing, I stumbled across this spreadsheet, which relates the standard deviation to your average odds, and along with yield and sample size churns out a pvalue. I’m no math whiz as such. If you, or anyone, would check that the formulaes behind this are sound, it would be much appreciated (and possibly of help to Dragontrades and others).marksmeets302 wrote: ↑Fri Jul 27, 2018 9:27 amThe required sample size depends on how sure you want to be of an edge. Start recording the returns, and every time calculate the mean and standard deviation. Excel will do this for you. You will see that with more samples the standard deviation will tend to become lower: most returns will resemble the mean and you will have relatively fewer outliers. If you are aiming to be 95% sure of an edge, that translates to 2 standard deviations. If you deduct 2 standard deviations from the mean and this is a positive number then you can be 95% sure that you have an edge (a positive expectancy). This is under the assumption your returns are normally distributed, which they usually are. Unless you consider really long time periods where the market starts to change. If you only want to be 68% sure (that's one standard deviation) you deduct only 1 standard deviation from the mean. Of course for this you need much less samples. 3 standard deviations is like 99.7% and you will need a lot more samples for this.dragontrades wrote: ↑Thu Jul 26, 2018 10:56 pmThe strike rate is around 1in10 and I am staking by book % so how many races would be enough to draw some conclusions? Is there a formula for figuring the sample size out?
Hopefully someone can point me in the right direction
Note that you can never be 100% sure.
You do not have the required permissions to view the files attached to this post.
 ShaunWhite
 Posts: 4290
 Joined: Sat Sep 03, 2016 3:42 am
How is that different to pattern fitting? Not a critisism, just wondered.Kafkaesque wrote: ↑Fri Jul 27, 2018 2:29 pmI’d very much second Euler’s input. Subdivide your results in as many formats as you can possible think of. It’ll of course make the variance even greater, with the smaller sample for each subcategory, but it can very much open to specific spots where the strategy works best, among other things.
And at a minimum the 'as many formats as posible' must surely have to actually relate to things likely to actually affect your strategy?
Sub dividing into grey or brown horses won't help much.
 ruthlessimon
 Posts: 1651
 Joined: Wed Mar 23, 2016 3:54 pm
Let's assume (when cutting the data) you found, removing markets priced @ 2.70, 2.72, 2.74  massively improved a strategy (doubled its profitability). Is that enough to be immediately tradable? or is it important to understand why those 2.70, 2.72, 2.74 markets were destroying the original strategy in the first place?
Surely the latter is extremely important  because being aware of the cause, you'll be far far ahead of the market should something change?
Now I've deliberately cut the title, because I don't want people knowing what this is But it's a P&L distribution based on where the entry took place. Notice how the biggest, most frequent losers are coming from entries @ 2,70, 2.72, 2.74  but importantly there aren't any winners either. Why is this happening??
 ruthlessimon
 Posts: 1651
 Joined: Wed Mar 23, 2016 3:54 pm
That was my initial thought, but no  because those 2.70s  2.74s would've been clean through 7/4 on entry. Plus the markets @ 2.80  3.0, you;d expect would be the biggest losers  but they aren't

 Information

Who is online
Users browsing this forum: No registered users and 1 guest