SDQL Portfolio Beta

Updated on April 7, 2017 in Sports Betting Research
13 on January 9, 2016

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
– Yield
– 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

http://sportsdatabase.com/mlb/query?output=default&ou=1&invested=1&sdql=total+%3C%3D+11+and+team+%3DRockies+and+month+%3E%3D+8+and+H&submit=++S+D+Q+L+%21++

The OU results are interesting:
174-109-14 (1.48, 61.5%)
over: +$5,635
ROI: +17.3%

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.

https://blooming-stream-4451.herokuapp.com

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.

  • Liked by
  • TheFivePack
  • pcg
Reply
0 on January 11, 2016

Sounds interesting. Will have to take a look.

  • Liked by
Reply
Cancel
4 on January 26, 2016

I cannot seem to get this to work with the MLB example…

getting an error after pressing  query

[SDQL Portfolio Error] Cannot read property ‘error’ of null

Subscriber
on January 26, 2016

Can you give me a query that does not work?

Subscriber
on January 26, 2016

The one right form the example ” total <= 11 and team =Rockies and month >= 8 and H” and I chose MLB

Subscriber
on January 26, 2016

It’s fixed

Subscriber
on January 26, 2016

Thanks!

Show more replies
  • Liked by
Reply
Cancel
0 on February 12, 2016

This is a good post. I checked with Joe to make sure that there wasn’t any problem / conflict of interest. I think the post you did was just mis-categorized; so all is good.

I think that you’re clear a good programmer and we have a lot of potential here.

Let’s keep this going!

  • Liked by
Reply
Cancel
0 on April 7, 2017

First of all this tool is brilliant. However I’m not sure it works intirely as intended (Or as I expected). Despite it sounds impossible, there is a slight chance, that I simple just misunderstand the tool.

Shouldn’t it be TO WIN when teams are favorites..?? (team=Cubs and season=2017 =+75 on killersports.com and return 0,48 in the tool). The 0,48 is RISK on all 3 games this season and divided into average return.

I have understood that it eliminates opposite trends from a portfolio. But i tested the tool and I think it also eliminates trends that are ‘equal’ in a portfolio. If a 2 different trends both point to Cubs, it removes both trends. I think it should Count for one but not two in the evaluation.

  • Liked by
Reply
Cancel
0 on April 7, 2017

First of all this tool is brilliant. However I’m not sure it works intirely as intended (Or as I expected). Despite it sounds impossible, there is a slight chance, that I simple just misunderstand the tool.

Shouldn’t it be TO WIN when teams are favorites..?? (team=Cubs and season=2017 =+75 on killersports.com and return 0,48 in the tool). The 0,48 is RISK on all 3 games this season and divided into average return.

I have understood that it eliminates opposite trends from a portfolio. But i tested the tool and I think it also eliminates trends that are ‘equal’ in a portfolio. If a 2 different trends both point to Cubs, it removes both trends. I think it should Count for one but not two in the evaluation.

  • Liked by
Reply
Cancel
0 on April 7, 2017

First of all this tool is brilliant. However I’m not sure it works intirely as intended (Or as I expected). Despite it sounds impossible, there is a slight chance, that I simple just misunderstand the tool.

Shouldn’t it be TO WIN when teams are favorites..?? (team=Cubs and season=2017 =+75 on killersports.com and return 0,48 in the tool). The 0,48 is RISK on all 3 games this season and divided into average return.

I have understood that it eliminates opposite trends from a portfolio. But i tested the tool and I think it also eliminates trends that are ‘equal’ in a portfolio. If a 2 different trends both point to Cubs, it removes both trends. I think it should Count for one but not two in the evaluation.

  • Liked by
Reply
Cancel
0 on April 7, 2017

First of all this tool is brilliant. However I’m not sure it works intirely as intended (Or as I expected). Despite it sounds impossible, there is a slight chance, that I simple just misunderstand the tool.

Shouldn’t it be TO WIN when teams are favorites..?? (team=Cubs and season=2017 =+75 on killersports.com and return 0,48 in the tool). The 0,48 is RISK on all 3 games this season and divided into average return.

I have understood that it eliminates opposite trends from a portfolio. But i tested the tool and I think it also eliminates trends that are ‘equal’ in a portfolio. If a 2 different trends both point to Cubs, it removes both trends. I think it should Count for one but not two in the evaluation.

  • Liked by
Reply
Cancel
0 on April 7, 2017

First of all this tool is brilliant. However I’m not sure it works intirely as intended (Or as I expected). Despite it sounds impossible, there is a slight chance, that I simple just misunderstand the tool.

Shouldn’t it be TO WIN when teams are favorites..?? (team=Cubs and season=2017 =+75 on killersports.com and return 0,48 in the tool). The 0,48 is RISK on all 3 games this season and divided into average return.

I have understood that it eliminates opposite trends from a portfolio. But i tested the tool and I think it also eliminates trends that are ‘equal’ in a portfolio. If a 2 different trends both point to Cubs, it removes both trends. I think it should Count for one but not two in the evaluation.

  • Liked by
Reply
Cancel
0 on April 7, 2017

First of all this tool is brilliant. However I’m not sure it works intirely as intended (Or as I expected). Despite it sounds impossible, there is a slight chance, that I simple just misunderstand the tool.

Shouldn’t it be TO WIN when teams are favorites..?? (team=Cubs and season=2017 =+75 on killersports.com and return 0,48 in the tool). The 0,48 is RISK on all 3 games this season and divided into average return.

I have understood that it eliminates opposite trends from a portfolio. But i tested the tool and I think it also eliminates trends that are ‘equal’ in a portfolio. If a 2 different trends both point to Cubs, it removes both trends. I think it should Count for one but not two in the evaluation.

  • Liked by
Reply
Cancel