NBA Stituational Bet, SDQL

[pip2]

NBA SDQL 'BEST BET' 2014-15

12/2/14 12:10pm pst Reduced Basketball 511 Dallas Mavericks +1½ -105* vs Chicago Bulls


SDQL:

H and p:AW and pp:AW and season > 2008

SDQL: English

Team at home won the last game which was away and won the game before that which was also away, since 2008....

It also helps that chi was away a whole bunch more games than that...

[nash13]

NBA SDQL 'BEST BET' 2014-15

Play: GS/ORL Over 201.5 (-105) 12/2/14 11:23 CET

SDQL: p:defensive rebounds + poffensive rebounds > 52 and H and p:fouls <26 and season > 2011

SDQL English: Take the Over in a game where the Home Team had total Rebounds of 53 or more in their last game and folded fewer than 26 times.
Take games after 2011.

[Ronald S.]

Thanks cutler for putting it in!

[Ronald S.]

NBA SDQL 'BEST BET' 2014-15

12/2/14 12:10pm pst Reduced Basketball 511 Dallas Mavericks +1½ -105* vs Chicago Bulls


SDQL:

H and p:AW and pp:AW and season > 2008

SDQL: English

Team at home won the last game which was away and won the game before that which was also away, since 2008....

It also helps that chi was away a whole bunch more games than that...

I like this one and will probably play them tonight too. Dallas has done very well off a loss with Rick Carlisle as the coach

team = Mavericks and season >= 2008 and p:AL and A
SU: 35-35 (0.97, 50.0%)
ATS: 47-23-0 (2.39, 67.1%) avg line: 1.4
team = Mavericks and season >= 2008 and p:AL and AD
SU: 17-25 (-2.29, 40.5%)
ATS: 30-12-0 (2.83, 71.4%) avg line: 5.1

EDIT: Ack. Just realized Dallas won their last game. Though the trend doesn't apply, definitely something to keep an eye out for. Added to database as well

[JMon]

Like the play nash,
passing today

[dmitean]

Thanks dmitean!
As I've been doing it for the last week or so I keep thinking it might be worth it to just pay KS to do it automatically. Maybe I'm still slow, but it takes me a good 30 min to go thru them all and do a little analysis.

If anything, it's best to 400$ to someone, to build an app, that will scrape through database...
That way, you can add how many queries you want and it's not for the season, but a one time payment...

[GolfAddict]

NBA SDQL BEST BET

12/2/14 6:56PM EST

Mavericks ML +100

H and p:A and pp:A and ats streak >= 2 and 3 >= line >= -3 and season >= 2008 and playoffs = 0
SU: 45-60 (-0.88, 42.9%)
ATS: 45-59-1 (-1.42, 43.3%)


Fade the home team after a road trip with consecutive away games covering the spread. Works more often on games with a small spread

[nash13]

If anything, it's best to 400$ to someone, to build an app, that will scrape through database...
That way, you can add how many queries you want and it's not for the season, but a one time payment...

I am talking to a guy about automatizing the spreadsheet. Maybe it is something we can get done permanently.

[pip2]

Thanks dmitean!
As I've been doing it for the last week or so I keep thinking it might be worth it to just pay KS to do it automatically. Maybe I'm still slow, but it takes me a good 30 min to go thru them all and do a little analysis.

Thanks to both of you guys! It was time consuming to just go through all the active queries you guys found, let alone the entire bunch!

[Cutler'sThumb]

If anything, it's best to 400$ to someone, to build an app, that will scrape through database...
That way, you can add how many queries you want and it's not for the season, but a one time payment...

That may be a really good idea. If anyone (you or nash13?) knows the right person to build an app like that I'm all for it and would happily chip in to help get it done. Time is money. I'm sure we could all share the duties of sifting thru all the trends every day, but its a grind (esp if we look atultiple sports). I'm happy to keep at it for now, as I'm not as busy with work the last week or two, but there's definitely value long term if the grunt work can be automated.

[Consigliere]

That may be a really good idea. If anyone (you or nash13?) knows the right person to build an app like that I'm all for it and would happily chip in to help get it done. Time is money. I'm sure we could all share the duties of sifting thru all the trends every day, but its a grind (esp if we look atultiple sports). I'm happy to keep at it for now, as I'm not as busy with work the last week or two, but there's definitely value long term if the grunt work can be automated.

Hey guys while I've been away for work I've been working in excel and have coded it so that it will run all the queries automatically but you still have to look through each one to see if there is a play. Would that be helpful? I have a few new trends in my version as well. Again not sure how to share it in excel but Dropbox is an option. My version has lots of lookups so that when you enter the plays it also tells you current year record for that trend as well as z score sample size cusum etc. this file contains all my cusum data as well.

[moshi]

^What do you mean by "run it automatically"? I've just got folders of bookmark dumps and like the others, am looking for a longer term solution that will be less time-consuming.

I think the problem with paying someone else is that if anything goes wrong or you need to change/modify something, you'll have to involve him rather than being able to do it yourself.

[Consigliere]

^What do you mean by "run it automatically"? I've just got folders of bookmark dumps and like the others, am looking for a longer term solution that will be less time-consuming.

I think the problem with paying someone else is that if anything goes wrong or you need to change/modify something, you'll have to involve him rather than being able to do it yourself.

I mean it will automatically open each trend in the list in a browser tab so no clicking through the trends in the sheet. Maybe saves half the time of updating based on my experience.

[nash13]

I will contact my developer tomorrow. If he has a decent offer I will let you know.

[fataliz]

I will contact my developer tomorrow. If he has a decent offer I will let you know.

I'm all in for chipping in to Nash

[JMon]

NBA SDQL "Best Bet" 2014-15

Overall Group Record - 54-44-1 55.1% (+7.10) (max wagered -to win 1 unit)

Yesterday's recap 4-2 (+1.85)

Official Entries: Max 10 of 10:

1. JMon - 8-8 (+.10)

2. pip2 - 9-6 (+2.69)

3. nash13 - 6-4 (+1.82)

4. Ronald S. - 8-6 (+1.55)

5. hyahya - 6-4 (+1.55)

6. Mako-SBR - 5-8 (-3.80)

7. FlyinAir - 1-2 (-1.45)

8. Consigliere - 7-3-1 (+3.84)

9. Sports Mind - 2-0 (+2.00)

10. GolfAddict - 2-3 (-1.20)

[pip2]

I will contact my developer tomorrow. If he has a decent offer I will let you know.

This is great but I think we need to move with a certain amount of caution on this. Whatever solution comes up, is probably going to be making a heavy number of calls to the database servers. If there is just one, or even a few, instances of this going on, its probably not a problem. But if this is somehow published out to too many users/clients, I am worried the heavy load of all accumulated automated queries could impact the servers themselves.

[JMon]

I do recall the ability to purchase the database, where one would have to manually enter the data daily.

[Heart]

Seems like entering daily data from the games would be a ton more work than just working through you guys spreadsheet. Wouldn't think that's a feasible option.

[pip2]

NBA SDQL 'BEST BET' 2014-15

12/3/14 8:30 am NBA Basketball 720 Los Angeles Clippers 1st Quarter -4½ -110* vs Orlando Magic


SDQL:

p:M3 > 0 and A and p:L and rest = 0 and season > 2010

SDQL: English

Since 2010, fade a team in the 1st quarter if they played last night, led at the end of the 3rd quarter, then lost the game.

[Cutler'sThumb]

Spreadsheet updated (NHL too). I combed thru last night, which I think is fine, but maybe the system didn't update everything so if someone sees any plays I missed, just add 'em in. Spurs and Mavs both have multiple trends pointing to them.

[GolfAddict]

I have a friend that would probably be willing to run the queries on a daily basis for a low fee. He is a medically retired marine and is always on his computer and cannot work because he would lose his benefits.... (great country). But he definitely has the time... I can check with him if you guys don't find a solution

[Mako-SBR]

Spreadsheet updated (NHL too). Spurs and Mavs both have multiple trends pointing to them.

DB made it easy today. Didn't have anything active on my own sheet, checked the DB and saw Spurs/Mavs with multiple queries pointing there way...tailed both.

For my Best Bet I chose JMon's NBA 107:

NBA SDQL 'Best Bet' 2014-15

12-3-14 - 11:30a PST

Play: SAS (-8.5) BRK -110

SDQL:
HD and p:AW and points < 105 and 2011<=season and o:rest<2

English:
Simple one, fade a home dog coming off an away win in which they scored less than 105 points on light or no rest. I played with it a bit to filter games outside the div, month, opponent rest, etc, and each came back favoring the Nets fade. BOL all!

[dmitean]

The question is, how much is a win in NY, is an away win, for a team from NY...

[emceeaye]

NBA SDQL 'BEST BET' 2014-15

12/3/14 8:30 am NBA Basketball 720 Los Angeles Clippers 1st Quarter -4½ -110* vs Orlando Magic


SDQL:

p:M3 > 0 and A and p:L and rest = 0 and season > 2010

SDQL: English

Since 2010, fade a team in the 1st quarter if they played last night, led at the end of the 3rd quarter, then lost the game.

Nice...on it too:

4 >= p:M3 >= 1 and D and 0 > p:margin >= -2 and rest = 0

[emceeaye]

mistake

[GolfAddict]

NBA SDQL BEST BET 2014-15
12/3/145:10PM EST

MILWAUKEE BUCKS+5(-110)

streak >= 4 and rest = 0 and pvertime > 0 and playoffs = 0
SU:11-22 (-4.33, 33.3%)
ATS:13-19-1 (-3.33, 40.6%)

streak <= -2 and rest = 0 and opvertime > 0 and playoffs = 0
SU:38-59 (-2.84, 39.2%)
ATS:56-38-3 (1.53, 59.6%)

Fade a team whose previous game went into overtime and is on no rest.This has even better results when that team is on a four or more game winning streak.Also, play a team facing an opponent whose previous game went into overtime and is on a two or more game losing streak.


I would take it ML if they were playing anyone other than Dallas

[JMon]

NBA SDQL 'Best Bet' 2014-15

12-3-14 - 5:00p CT

Play Pistons +5 -110

SDQL: p:ADL and p:ats margin>0 and op:F and op:margin<=-10 and F

English:

Play against a favorite off a cover but lost as a road dog against an oppt off a loss of 10 or more as a favorite.

[Ronald S.]

NBA Best Bet

12/3/14 7:00PM EST

San Antonio -8 -105 (@Brooklyn) (5dimes)

team=Spurs and rest=1 and o:rest=0 and season>=2009

Will try spurs too. Spurs are 32-12 ATS since 2009 when playing on 1 days rest and their opponent is on 0 days rest. 28-12 as a favorite and 8-1 on the road.

[nash13]

I've discussed this with the developer from a software engineering company as I mentioned and they will provide a demo for us as soon as possible. The price for the development and single computer licence will be $2000's and as the deposit they required $500's upfront. I'd like to send the deposit myself, but I need to know that if you guys can help crowd sourcing the remaining $1500s. Application will be fully automatic and user friendly. It will work connected to the spreadsheet we use and the number of queries will be limitless.
They will also give a 2-weeks post delivery support for the fixes. If you guys are good with it, please let me know how much you can support and I will send the deposit fee as soon as we are settled.

Program Specifications :


- Unlimited NBA, MLB, NFL, NHL, NCAABB, NCAAFB queries on demand(no subscription fees such as killersports)
- Fast queries as the best that the SDQL servers allow.
- Hit go and forget the rest approach(hassle-free)
- Community populated valid Trends will be scanned, thus there will be no trouble for you to deal with adding/removing or updating trends.
- 2 weeks post-delivery development support.
- Single user licence + development fee = $2000 ($500 deposit, upfront)
- Individual licences: $500 after development(can include personal customizations on demand)


Program delivery will be done after demo is being presented and the payment is made.

That's the mail I got from them.
if you want to negotiate or contact them directly, i can share details via PM

[Cutler'sThumb]

As long as you are confident that the developer understands what we need and can deliver, this would be a powerful tool and probably worth the $$. Just to clarify, the $2000 gets us one person (presumably you) the ability to interact directly with the program (uploading/adjusting trends, ect), and it is and extra $500 for each extra person that wants separate access. Shouldn't be any issue with this as long as accessing trends as they become active is easy for everyone.
Streamlining access to all the active trends as described above would put the the necessary info at our fingertips so much more efficiently. Time is the one thing you can spend and never get back, and this, assuming this works as advertised, is a massive short cut.

[nash13]

It must not be me, it would be better to have a person who is around regularly. I can give the duties to JMon, Mako (since they are the most active around here). The benefit of having your own crawler is, that you could run it independently and look at line changes.

The pros of this way are: Killersports takes yearly 2$ for 1 trend a season. Which is very good, but if you want to cover all sports and limitless trends without limiting the seasons and if this program works fast, it may worth the money.
The trends in the sheet are 260+ for NFL, NBA and MLB only. Covering them on Killersports costs 500 dollar a year. NHL, NCAAB, NCAAF has no automatic cover method offered by them yet. So that's a huge bonus.

But I would like to see a deno version first before putting huge money on it. But I am not a tech guy, I don't know much about their rates and fees, if anyone would like to contact them directly I can give you the email address via PM. I know them from the past where they produced a crawler for odds and expert/consensus picks on Covers.com

[dmitean]

Bad night for me. Before checking the queries, my strongest bets were Nets and Bucks. Even took both... After looking at the queries, decided not only to hedge, but to take Spurs and Dallas... Annoying...

Added today's NBA queries in the file.
Please note that the 126 and 128 queries are basically the same...

Query 56 that supports Cleveland is only 5 - 8 ATS this season, so don't know how good it is...

Can't say that today we got very strong queries...

[JMon]

damn pistons...can't stand when plays lose in OT.

[JMon]

It must not be me, it would be better to have a person who is around regularly. I can give the duties to JMon, Mako (since they are the most active around here). The benefit of having your own crawler is, that you could run it independently and look at line changes.

The pros of this way are: Killersports takes yearly 2$ for 1 trend a season. Which is very good, but if you want to cover all sports and limitless trends without limiting the seasons and if this program works fast, it may worth the money.
The trends in the sheet are 260+ for NFL, NBA and MLB only. Covering them on Killersports costs 500 dollar a year. NHL, NCAAB, NCAAF has no automatic cover method offered by them yet. So that's a huge bonus.

But I would like to see a deno version first before putting huge money on it. But I am not a tech guy, I don't know much about their rates and fees, if anyone would like to contact them directly I can give you the email address via PM. I know them from the past where they produced a crawler for odds and expert/consensus picks on Covers.com

Something I wouldn't be interested in on my end. Support should be given to the guys that developed sdql. Have you contacted Joe (from sportsdatabase) about a quote? See if he would be willing to beat the offer????