Does it mean that you backtest your strategy on 20/30 markets only?
Or do you have an algorithm that, after setting your strategy’s signals, can backtest thousands of markets in a couple of seconds?
Does it mean that you backtest your strategy on 20/30 markets only?
This would be hugely beneficial and very gratefully received.
There are different flavours of SQL .. and cost etc. The free version of 2014 - Microsoft SQl server, , has a 10gb database size limit.Might see if here are any companies still around where I can load a market and go through the basics in SQL, mode analytics used to do this I think. As you guys are right, the time consuming part is data quality and loading. Is sql express really 10gb? I thought it was 2gb?
Python is a computer language that several people on here use to create models/bots (outside of BetAngel). It's a multi-threaded language that's fast and also well know for being logical and readable at the same time. https://en.wikipedia.org/wiki/Python_(p ... _language)
SQL is a generic term for a database / database access method. VAX is a computer system. Common SQL databases are Microsoft SQL, Oracle and then some free ones like MySQL, SQLite, etc. etc.
It depends on what you are doing. I backtest against 14,000 races with 580 different 'WhatIf' permutations - and that takes a lot of computer power!
Both.
I think that this is more meant to describe an automated strategy. E.g. "how" people trade. A formula might be "Back horses > 3/1 and Lay if horse odds fall to < 2/1". That can be done in Excel VBA, another language such as Python or the built in capabilities of BetAngel (there are some real experts on this, like Dallas). Can be done in Excel formulas, but for anything that gets quite clever/complicated, then using a programming language rather than just formulas is the way that a lot of people go.
Interesting, what does 2017 look like?ShaunWhite wrote: ↑Fri Jan 05, 2018 7:40 pmThis thread seemed an appropriate place to post this.
I was backtesting something on the 2013-2016 data and ended up with the results below.
You can see from that graph why I was questioning the 2016 data on the other thread now !! WTF happened in '16 to wreck 3 solid years? (mostly a rhetorical question).
You'd think that if something was performing for 37,000 races you'd cracked it. It always makes me smile when I hear new guys taking about running automation 'all day' and then bursting into tears or getting the exotic holiday brouchures out. The should look at the duration of some of the dips in the graph below even when it was performing well.
Really hope we find the '17 data appearing somewhere soon, anyone seen it? 2018 data would be even better
It's a brilliant post & highlights a couple of really interesting points.
Yep, que será, será. (little nod there to a tune from 1956 for Memphis)
Are you trying to kill me? I'd planned an early night and you send me a link to data and something to read. Thanks a lot.LinusP wrote: ↑Fri Jan 05, 2018 9:14 pmInteresting, what does 2017 look like? viewtopic.php?f=54&t=13157&p=141407#p141407
Relavent article just posted by Buchdahl: https://www.pinnacle.com/en/betting-art ... 3vjy59y4q3