NBA Stituational Bet, SDQL

[JMon]

It's good to see Phil get their first win.

[JMon]

NBA SDQL "Best Bet" 2014-15

Overall Group Record - 56-47-1 54.3% (+5.85) (max wagered -to win 1 unit)

Yesterday's recap 2-3 (-1.25)

Official Entries: Max 10 of 10:

1. JMon - 8-9 (-1.00)

2. pip2 - 10-6 (+3.69)

3. nash13 - 6-4 (+1.82)

4. Ronald S. - 8-7 (+.50)

5. hyahya - 6-4 (+1.55)

6. Mako-SBR - 5-9 (-4.90)

7. FlyinAir - 1-2 (-1.45)

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

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

10. GolfAddict - 3-3 (-.20)

[Heart]

I don't think 2 weeks of support would be enough. If the API calls to the DB change or something gets tweaked on the server end you are out $2k.

[pip2]

I don't think 2 weeks of support would be enough. If the API calls to the DB change or something gets tweaked on the server end you are out $2k.

What if the programmer gets a couple of days into the project and suddenly realizes its going to be more difficult than he thought, so they now need $4,000 or $6,000, or whatever?

[Cutler'sThumb]

Like Jmon's idea of contacting sportsdatabase. a) competition is always good, and b) if they offer this kind of thing we wouldn't have to worry about them understanding the specifics. Nash 13, you want to shoot them an email since you have the specifics on the other quote?

[Consigliere]

Hey guys a friend and I setup a crawler a few years back to scrape the daily results of the sdql. It was pretty easy and I almost guarantee this is the method the developer is offering. I will be home this weekend and talk to my friend. I bet we can do this for free but would require more than the two week time frame.

[hyahya]

Here's one that's active for today that supports the other query results:

tS(HW,N=4)>=3 and p:HW and AF and line<-3 and season>2005 and 190<=total<=200<total<200< html=""></total<200<>

[Heart]

Here's one that's active for today that supports the other query results:

tS(HW,N=4)>=3 and p:HW and AF and line<-3 and season>2005 and 190<=total<=200<total<200< html=""></total<200<>

just learning this stuff... is this indicate a play on Cavs -7?

[moshi]

Like Jmon's idea of contacting sportsdatabase. a) competition is always good, and b) if they offer this kind of thing we wouldn't have to worry about them understanding the specifics. Nash 13, you want to shoot them an email since you have the specifics on the other quote?

Be careful with that. What this is asking for is a direct challenge to their business model. I'm not sure he'll be so accommodating or welcome to the idea. Last thing you want is for them to put up barriers to prevent web scraping.

[nash13]

Be careful with that. What this is asking for is a direct challenge to their business model. I'm not sure he'll be so accommodating or welcome to the idea. Last thing you want is for them to put up barriers to prevent web scraping.

That's the point. It is a two sided sword. On the one hand they are offering a great great tool and I would be pleased to pay for a package including all sports, but that is not possible. Without using your own workaround, you can get NBA, MLB and NFL automated right now.
If you like CFL, College FB and BB or NHL you have to do something. They are offering API free and API is usually used to do these kind of scraping.

In the open market there is only one comparable tool: It is BetLabs I suppose, and look what they charge you for their services. And it is not like they are significantly better.

[hyahya]

just learning this stuff... is this indicate a play on Cavs -7?

Mainly the under but Cavs as well.

[pip2]

NBA SDQL 'BEST BET' 2014-15

12/4/14 12:55pm Reduced Basketball 501 Cleveland Cavaliers -7 -103* vs New York Knicks


SDQL:

playoffs = 0 and game number > 5 and season > 2007 and tA(points - TPM*3 - points in the paint - FTM) > ( tA(points)*.285)

SDQL: English

Since 2007 and after 5 games have already been played in the season, a team that has averaged scoring over 28% of its points via mid-range shots is in a slump and will probably lose ats until it decreases that average ratio.

[JMon]

NBA SDQL 'BEST BET' 2014-15

12/4/14 12:55pm Reduced Basketball 501 Cleveland Cavaliers -7 -103* vs New York Knicks


SDQL:

playoffs = 0 and game number > 5 and season > 2007 and tA(points - TPM*3 - points in the paint - FTM) > ( tA(points)*.285)

SDQL: English

Since 2007 and after 5 games have already been played in the season, a team that has averaged scoring over 28% of its points via mid-range shots is in a slump and will probably lose ats until it decreases that average ratio.

Boy this situation is as unique as they come. Only 7 different teams, with only the Knicks this year and no teams in 2012-13

[Cutler'sThumb]

I got the NHL trends done this morning, but ran out of time for the NBA. Just thought I'd mention it, as someone had posted some of the NHL plays before me but only posted 4 or 5 for the possible 25 trends. I don't have time now to double check NBA, but if someone has looked at all the trends, maybe just verify that the Cle -7 and the Under are the only active trends.

[Heart]

Where are all the trends? Someone mentioned in a spreadsheet somewhere? What page of the thread is that on?

[nash13]

Where are all the trends? Someone mentioned in a spreadsheet somewhere? What page of the thread is that on?

Write me a Pm withy your Email-adress, i will give you access

[JMon]

passing today..

[JMon]

Where are all the trends? Someone mentioned in a spreadsheet somewhere? What page of the thread is that on?

Heart do you have some of your own queries to share with the group?

[nash13]

Passing today too. There is just too much juice on the Cavs.

[Heart]

Heart do you have some of your own queries to share with the group?

not yet! I want to take a look and continue on my learning curve. Hopefully I'll be able to contribute in the near future though.

Nash, PM sent. Thanks!

[JMon]

Passing today too. There is just too much juice on the Cavs.

I was hoping of a line around 4...understanding we have some major revenge going on here...with Knicks winning su as 12.5 dogs-in season. I have a query-and perhaps the doc as well, want to play them b/c of that! You playing?

[JMon]

not yet! I want to take a look and continue on my learning curve. Hopefully I'll be able to contribute in the near future though.

Nash, PM sent. Thanks!

great...will be looking forward to seeing your contributions in the near future. Hard work pays off!

[Ronald S.]

NBA Best Bet

12/4/14 6:30 PM EST

New Orleans +9.5 -105 (@Golden St) (5dimes)

H and streak >= 6 and p:line <= -9 and p:margin <= 4
SU: 24-7 (7.03, 77.4%)
ATS: 8-23-0 (-3.69, 25.8%) avg line: -10.7
O/U: 15-15-1 (1.23, 50.0%) avg total: 197.7

Fade the home team on a winning streak of 6 or more that just escaped with a narrow win as a heavy favorite in their previous game. Although sample size is fairly small, what I like is that the trend gets better (or actually, worse) as the winning streak increases. Also same if we decrease the winning margin. I think this bodes well for this game since Warriors are actually on a 10 game winning streak and won their previous game by just 1 point. Even though sample size is small, I'll give this one a shot!

H and streak >= 6 and p:line <= -9 and p:margin <= 1,2,3,4,5,6,7
H and streak >= 4,5,6,7,8,9,10 and p:line <= -9 and p:margin <= 4

Notice the steady decrease in the ATS record.

[FortySix]

Hey fellas,

Gotta apologize to you all for not doing any best bets and I saw that I was replaced which is ok because of lack of posting but I have been away for awhile. Hope you are all doing well with the plays and I will just post a few of my own queries from now on.

[JMon]

Hey fellas,

Gotta apologize to you all for not doing any best bets and I saw that I was replaced which is ok because of lack of posting but I have been away for awhile. Hope you are all doing well with the plays and I will just post a few of my own queries from now on.

Hey 46,,,tried to get a hold of you..hope all is well. I'm trying to get in touch with flyinair with no response. I may be able to fit you in there..if interested.

[FortySix]

Hey 46,,,tried to get a hold of you..hope all is well. I'm trying to get in touch with flyinair with no response. I may be able to fit you in there..if interested.

Everything is all good. Thanks Jmon. I will take Flyinair's spot if thats ok. Will have a query shortly.. Thank you again for all that you guys do on this thread.

[pip2]

NBA Best Bet

12/4/14 6:30 PM EST

New Orleans +9.5 -105 (@Golden St) (5dimes)

H and streak >= 6 and p:line <= -9 and p:margin <= 4
SU: 24-7 (7.03, 77.4%)
ATS: 8-23-0 (-3.69, 25.8%) avg line: -10.7
O/U: 15-15-1 (1.23, 50.0%) avg total: 197.7

Fade the home team on a winning streak of 6 or more that just escaped with a narrow win as a heavy favorite in their previous game. Although sample size is fairly small, what I like is that the trend gets better (or actually, worse) as the winning streak increases. Also same if we decrease the winning margin. I think this bodes well for this game since Warriors are actually on a 10 game winning streak and won their previous game by just 1 point. Even though sample size is small, I'll give this one a shot!

H and streak >= 6 and p:line <= -9 and p:margin <= 1,2,3,4,5,6,7
H and streak >= 4,5,6,7,8,9,10 and p:line <= -9 and p:margin <= 4

Notice the steady decrease in the ATS record.

Thanks for this query Ronald. I'm tailing!

[nash13]

I will be away for a few days. Take care everyone. See y'all Monday.

[GolfAddict]

HF and rest =1 and o:rest = 1 and HWP >= 82 and o:AWP <= 34 and season >= 2012
SU:64-12 (11.84, 84.2%)
ATS:39-35-2 (1.01, 52.7%)avg line: -10.8

Is there a way to only find how often teams cover the spread or are within 4 points of covering?Would it be ATSm >= -4?
For example on tonight’s games GS and Portland fit this and I was trying to find out if you can run a query to find out if a two team teaser would be a good play on these games.I know its kinda late for these games but I would like to use this in the future if its possible

[Ronald S.]

HF and rest =1 and o:rest = 1 and HWP >= 82 and o:AWP <= 34 and season >= 2012
SU:64-12 (11.84, 84.2%)
ATS:39-35-2 (1.01, 52.7%)avg line: -10.8

Is there a way to only find how often teams cover the spread or are within 4 points of covering?Would it be ATSm >= -4?
For example on tonight’s games GS and Portland fit this and I was trying to find out if you can run a query to find out if a two team teaser would be a good play on these games.I know its kinda late for these games but I would like to use this in the future if its possible

Yep ats margin is what you are looking for. Sorry couldn't answer sooner though.

[Ronald S.]

Thanks for this query Ronald. I'm tailing!

Ugh. Failed miserably on this one. Thought Pellies would be a bad matchup for them too but man Warriors are just too good right now!

[dmitean]

Updated tonight's queries in the file.

A lot of queries fit the game in Philly. A bit too much even...

Obviously three games that don't have lines, may have queries that fit them, after the lines will be released...

[Cutler'sThumb]

Updated tonight's queries in the file.

A lot of queries fit the game in Philly. A bit too much even...

Obviously three games that don't have lines, may have queries that fit them, after the lines will be released...

Thanks D! Defiantly appreciated. I'm working on the NHL now. I started on them overnight too, but was concerned that I would miss plays due to lines not being out (Jets/Avalanche line finally out now). Both sports have generally been in the dumps this week...hopefully time for a bounce over the weekend.

NBA note: Boy, woulda been good to get on the overnight lines, especially the totals. Almost all are moving the way we would like. Totals have been horrible lately (the main reason NBA generally has been bad). Maybe time for a correction.

[Ronald S.]

NBA Best Bet

12/5/14 1:00PM EST

Atlanta -1.5 -105 (@Brooklyn) (5dimes)

HD and p:HW and p:margin <= 3 and P:L and 17 < WP < 47.5
SU: 25-100 (-9.26, 20.0%)
ATS: 33-92-0 (-4.02, 26.4%) avg line: 5.2
HD and p:HW and p:margin <= 3 and P:L and 17 < WP < 47.5 and 0 <= p:line <= 8.5
SU: 11-62 (-10.12, 15.1%)
ATS: 17-56-0 (-4.56, 23.3%) avg line: 5.6


Will go with cutler's excellent trend (with a couple small tweaks) today to hopefully get back into the black. Play against the home dog with a poor to moderate record that narrowly won their last game at home and lost their previous matchup against their opponent today. Changed max WP to 47.5 from 47 and took out the line parameter to accommodate the nets being just a 1.5 underdog though this could change as early money seems to be on the hawks.

[Heart]

Yeah the Thunder -12.5 coming up in about 10 of the trends