Only advice I could add would be to particularise the data you want to compile to make the future search easier and quicker. You can dispense with splitting your data into blocks and the Slicer feature in Excel lets you select your criteria via a button style interface.
The screenshot, Sandown, September, Rank 5 as sorted by BSP. You can now consider how likely it is to do well tomorrow or at any other Sandown meetings this month. A small step forward from a stab in the dark.
How to discover profitable automation strategies?
- wearthefoxhat
- Posts: 3243
- Joined: Sun Feb 18, 2018 9:55 am
Nice tables.Atho55 wrote: ↑Thu Sep 10, 2020 8:03 pmOnly advice I could add would be to particularise the data you want to compile to make the future search easier and quicker. You can dispense with splitting your data into blocks and the Slicer feature in Excel lets you select your criteria via a button style interface.
Strategy Search.jpg
The screenshot, Sandown, September, Rank 5 as sorted by BSP. You can now consider how likely it is to do well tomorrow or at any other Sandown meetings this month. A small step forward from a stab in the dark.
I could spend some time testing out some lay data on that spready.
- firlandsfarm
- Posts: 2724
- Joined: Sat May 03, 2014 8:20 am
I agree on SQL Shaun, the most pernickety language I have ever had the misfortune to use but no competitor! But Access? It's drag-and-drop! I didn't find any problem getting stuck in on day one! And you can start to dabble with SQL while cruising on Access.ShaunWhite wrote: ↑Thu Sep 10, 2020 3:45 pmAccess and SQL are great but quite a learning curve if you're not used to that world. But there's a perfectly adequate way to do it using just excel.
Create a simple query with two or three connecting tables, add a few conditions or filters, click on the SQL tab and the code looks absolutely horrendous.firlandsfarm wrote: ↑Sat Sep 12, 2020 2:35 pmI agree on SQL Shaun, the most pernickety language I have ever had the misfortune to use but no competitor! But Access? It's drag-and-drop! I didn't find any problem getting stuck in on day one! And you can start to dabble with SQL while cruising on Access.ShaunWhite wrote: ↑Thu Sep 10, 2020 3:45 pmAccess and SQL are great but quite a learning curve if you're not used to that world. But there's a perfectly adequate way to do it using just excel.
- firlandsfarm
- Posts: 2724
- Joined: Sat May 03, 2014 8:20 am
But why look at the code if you are a newbie to the technology? It will work perfectly from the drag-and-drop design screen! You don't need to know how an internal combustion engine works to be able to drive a car.Derek27 wrote: ↑Sat Sep 12, 2020 3:17 pmCreate a simple query with two or three connecting tables, add a few conditions or filters, click on the SQL tab and the code looks absolutely horrendous.firlandsfarm wrote: ↑Sat Sep 12, 2020 2:35 pmI agree on SQL Shaun, the most pernickety language I have ever had the misfortune to use but no competitor! But Access? It's drag-and-drop! I didn't find any problem getting stuck in on day one! And you can start to dabble with SQL while cruising on Access.ShaunWhite wrote: ↑Thu Sep 10, 2020 3:45 pmAccess and SQL are great but quite a learning curve if you're not used to that world. But there's a perfectly adequate way to do it using just excel.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
it's like recording excel macros, 30 lines of code for what you could do in 3. I don't do anything very fancy in SQL. My code just does basic writes and time seq reads for collection or doing a sim, but I dump it to excel to do any analysis. Mainly for the visualisatons and it's familiar. I know you can get software to do that directly from sql but there's only so many days in a year and always too much to learn and do. Compared to Liam my tech skills look pretty outdated.
Tbh data is only the start, it's learning how to use it that's the hard part. Sample sizes, normal distribution, statistical significance etc all take some homework. Even knowing that the Law of Large Numbers is a mathematical 'thing' and the Law of Averages is no more than a commonly held belief isn't knowledge you get at school.
There's not much point finding out some subset is value if it's within the normal range of natural varience. In fact following anomalies like that is more likely to produce worse results than having no data and sticking a pin in the Racing Post.
Better not look at the code then.
I've got some tremendously complexed queries courtesy of Betfair's $6000 NSW limit that probably wouldn't be so complex if I built them from scratch. Thankfully, my databases aren't likely to get large enough to force me to move to SQL.
I've got some tremendously complexed queries courtesy of Betfair's $6000 NSW limit that probably wouldn't be so complex if I built them from scratch. Thankfully, my databases aren't likely to get large enough to force me to move to SQL.
- ShaunWhite
- Posts: 9731
- Joined: Sat Sep 03, 2016 3:42 am
Excel is hard to beat. That's why even if I had terabytes of data I'd just extract some to play with rather than use it all at once. But not surprisingly there's a whole world of software for doing analytics on sql but picking the right one and then learning it is time consuming. It's always easier to add stuff to your ToDo list than it is to cross things off. I started trading for the easy life and it's more work than a proper job was most days.Derek27 wrote: ↑Sat Sep 12, 2020 5:07 pmBetter not look at the code then.
I've got some tremendously complexed queries courtesy of Betfair's $6000 NSW limit that probably wouldn't be so complex if I built them from scratch. Thankfully, my databases aren't likely to get large enough to force me to move to SQL.
- firlandsfarm
- Posts: 2724
- Joined: Sat May 03, 2014 8:20 am
Excel is great for analysing but no good for making extractions from the databank in my opinion. It maybe because I will look over data for as far back as I can go to make sure it's a consistent trend and not just a 12 month freak in the variance. How/Where do you store your long term data Shaun? You can't store 2gb a day in Excel, can you!ShaunWhite wrote: ↑Sat Sep 12, 2020 5:31 pmExcel is hard to beat. That's why even if I had terabytes of data I'd just extract some to play with rather than use it all at once. But not surprisingly there's a whole world of software for doing analytics on sql but picking the right one and then learning it is time consuming. It's always easier to add stuff to your ToDo list than it is to cross things off. I started trading for the easy life and it's more work than a proper job was most days.
- abgespaced
- Posts: 176
- Joined: Sun Aug 23, 2020 2:25 am
- Location: Australia
A lot of great points here and I will add that it's very tempting to put the cart before the horse. Just this morning I was watching YouTube videos about statistical significance, proportions, sample sizes etc. I was determined to approach my theory from a statistical standpoint.
But I eventually got frustrated when I realised I don't have the background skills or knowledge to ask the right question as to which statistical model to use. So I just did what I know how and plugged all the data into a graph in Excel and immediately got the picture I was looking for. So it was actually a blessing in disguise.
I'm sure I'll get into formulas and statistics and stuff later down the track. But for now I don't think my questions are complicated enough to warrant that kind of approach.
But I eventually got frustrated when I realised I don't have the background skills or knowledge to ask the right question as to which statistical model to use. So I just did what I know how and plugged all the data into a graph in Excel and immediately got the picture I was looking for. So it was actually a blessing in disguise.
I'm sure I'll get into formulas and statistics and stuff later down the track. But for now I don't think my questions are complicated enough to warrant that kind of approach.
Well put. I keep mine safely stored inside my muscle memory, the body's equivalent of an SSDShaunWhite wrote: ↑Thu Sep 10, 2020 7:06 pmManual vs auto init. Your edge is is in your head, mine is in an SSD.
Which helps free up the head for more important things! So there's a lot of empty storage space there, just the way I like it
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Is there anyone that could point me in the correct direction to back test a lay the football correct score strategy.
I am interested in the strike rate over a period of time/games.
Thanks in advance as always!
I am not excel or program competent.
Cheers
Micky
I am interested in the strike rate over a period of time/games.
Thanks in advance as always!
I am not excel or program competent.
Cheers
Micky
-
- Posts: 70
- Joined: Mon Aug 31, 2020 3:01 pm
Like it.gazuty wrote: ↑Tue Sep 01, 2020 7:14 amDirected at the OP - old hands already know what followsShaunWhite wrote: ↑Mon Aug 31, 2020 11:29 pmAutomation is as easy as manual trading.
Automation is as difficult as manual trading.
Delete as applicable.
Actually I think the key to automation is all captured in these lyrics (played forward not backwards)
And if you listen very hard
the tune will come to you at last
when all is one and one is all
to be a rock and not to roll
////
And if you listen very hard - poetic licence, listen, watch observe the markets
the tune will come to you at last - you will notice things that you can exploit
when all is one and one is all - they might be quite simple things, you only need one thing (I have one main idea that accounts for 99% of my profits)
to be a rock and not to roll - don't think you need to copy other people
How long between from when you noticed things that you can exploit to when you had your profitable bot.
btw I'm at the noticing/building bot stage.