Seems like the post was removed from the Google Groups. Just in case, for those who have missed it.
Sportsdatabase and SDQL is a great way to find profitable systems. But then I found hard to know if it will be consistent in the future so I build a tool.
The tool is easy to use, you just have to input the SDQL query (the same as you would with sportsdatabase) and you’ll get metrics about the systems.
The current metrics are:
– Average Count
– Average Return
– Minimum Bankroll
– Worst Season Return
– Losing Season
– Sharpe Ratio
As an example I’ll take a MLB system: total <= 11 and team =Rockies and month >= 8 and H
The OU results are interesting:
174-109-14 (1.48, 61.5%)
So I plug that system in the tool and I get the following metrics:
Average Count: 24.750
Average Return: 3.000
Yield: 12.12 %
Minimum Bankroll: -7.833
Worst Season Return: -3.833
Losing Season: 3
Sharpe Ratio: 0.629
Note: I use -120 odd for OVER system.
You can see that the system generates around 25 plays per season, for an average return of 3 units. The minimum bankroll to play the system without running out of money is about 8 units (-7.833). The system is not a winner each season (3 losing seasons) but in the worst case scenario, you will lose 4 units (-3.833). The Sharpe Ratio is a measure for calculating risk-adjusted return, a ratio greater than 1 is great.
Unfortunately past performance is no guarantee of future results, so all that metrics are not 100% accurate for the future but the tool should be useful to compare systems.
The tool allows you to create a portfolio of systems. You will get the same information but for all systems together.
Below is the address to try the tool. Just type a SDQL query (and season is added to each query). It might be slow the first time because I use a free hosting account, and the server has to boot up if it was idled.
The tool does not replace sportsdatabase, it’s a complement to validate if your systems are worth playing.
Let me know of any bugs, feature you would like to see.