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.Originally Posted by JMon
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.
Thanks for this query Ronald. I'm tailing!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.
I will be away for a few days. Take care everyone. See y'all Monday.
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.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
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!Thanks for this query Ronald. I'm tailing!
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.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...
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.
Last edited by Cutler'sThumb; 12-05-14 at 11:15 AM.
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.
Yeah the Thunder -12.5 coming up in about 10 of the trends
NBA SDQL 'BEST BET' 2014-15
12/5/14 9:30AM pst Reduced Basketball 803 Oklahoma City Thunder -12½ -109* vs Philadelphia 76ers
SDQL:
AF and p:AL and total >= 198
SDQL: English
Bet the away favorite when they lost their last away game as a favorite and the total is more than 198 and when you feel pretty sure that the Thunder are not in the kind of frame of mind to leave the back door open for the sixers...
Another one tonight with CHA vs NY (who blew their lead over CLE last night)...Nice...on it too:
4 >= p:M3 >= 1 and D and 0 > p:margin >= -2 and rest = 0
NBA SDQL 'Best Bet' 2014-15
12-5-14 - 12:30p PST
Play: TOR (-3.5) CLE -110
SDQL:
A and p:W and pp:W and ppp:W and pppp:W and ppppp:W and rest=0 and line>=-8 and month in [12,1] and season>=2009
English:
Fading an away team that's won their last four in a row on no rest, in the months of December and January only and with a line no larger than -8
Notes:
A short term trend that's only been good lately, this one conflicts with literally four other systems today...all of which have CLE. But I like to roll the dice when it comes to the Best Bet, need to break out so will let it fly...
Nice! Thanks, pip...on it again!Another one tonight with CHA vs NY (who blew their lead over CLE last night)...
Taking a closer look, Fridays is one of the better days for this query, and especially in Dec, Mar, and Apr. Fridays in Dec show an average 1st quarter point differential of 8.8.... when the team that blew it the night before loses ATS the first quarter.
p:M3 > 0 and D and 0 > p:margin >= -8 and rest = 0 and [M1 < - line / 4] = [True] and day = Friday and month
Otherwise, overall (N=2), on Fridays in December, the point differential is 8:
p:M3 > 0 and D and 0 > p:margin >= -8 and rest = 0 and day = Friday and month=12
Last edited by emceeaye; 12-05-14 at 03:17 PM. Reason: Correction
conference='Western' and o:conference='Eastern' and 20141001<=date
SU: 71-31 (5.25, 69.6%) ATS: 58-43-1 (2.24, 57.4%) avg line: -3.0 O/U: 40-60-2 (-1.64, 40.0%) avg total: 200.2
That is just amazing!
Western teams have almost 70% success rate against the East...
Talk about difference between Conferences...
