Guys to eliminate smiley's
1. Make your post as normal
2. Edit your post.
3. Click disable smiley's from text
4. Save.
Thanks for the tip and for the awesome-looking queries, jmon! (Score 1 already!)Originally Posted by JMon
Guys to eliminate smiley's
1. Make your post as normal
2. Edit your post.
3. Click disable smiley's from text
4. Save.
Hi fellas, trying to do an SDQL but struggling a little bit. I want to know how teams do after a home loss, then away loss and then back home as a dog (Lakers vs Clippers). I did the following
HD and p:AL and P:HL and P:margin<=-18 and rest<=0 and line<12
But for some reason it is not listing the Lakers vs Clippers on the list. Any help would be great..
HD and pp:HL and p:AL and p:margin<=-18 and o:rest=0Hi fellas, trying to do an SDQL but struggling a little bit. I want to know how teams do after a home loss, then away loss and then back home as a dog (Lakers vs Clippers). I did the following
HD and p:AL and P:HL and P:margin<=-18 and rest<=0 and line<12
But for some reason it is not listing the Lakers vs Clippers on the list. Any help would be great..
Thanks JAnthony. Much appreciated. Wasn't as good as I was hoping.HD and pp:HL and p:AL and p:margin<=-18 and o:rest=0
thanks bud, 2-0Thanks for the tip and for the awesome-looking queries, jmon! (Score 1 already!)
Struggling again fellas...
Trying to find an angle for the Lakers vs Clippers game
So I did
AF and p:HW and opp:HL and op:AL and ats marging <-9
I did -9 because the line yesterday for the Clippers was -12 and they only won by 3 so that would mean -9. When I enter it in, it gives me a list but no Lakers vs Clippers match up. Help would be very appreciated..
Just to get it running mechanically:Struggling again fellas...
Trying to find an angle for the Lakers vs Clippers game
So I did
AF and p:HW and opp:HL and op:AL and ats marging <-9
I did -9 because the line yesterday for the Clippers was -12 and they only won by 3 so that would mean -9. When I enter it in, it gives me a list but no Lakers vs Clippers match up. Help would be very appreciated..
AF and p:HW and opp:HL and op:AL and p:ats margin <=-9
I guess this situation doesn't happen very often so I tried "-4" instead of "-9" and
got this, which might indicate something worth dinking around with in an exploratory fashion:
SU: 22-10 (6.16, 68.8%)
ATS: 19-13-0 (0.47, 59.4%) avg line: -5.7
O/U: 17-14-1 (1.17, 54.8%) avg total: 196.4
Thank you Pip for your quick reply.Just to get it running mechanically:
AF and p:HW and opp:HL and op:AL and p:ats margin <=-9
I guess this situation doesn't happen very often so I tried "-4" instead of "-9" and
got this, which might indicate something worth dinking around with in an exploratory fashion:
SU: 22-10 (6.16, 68.8%)
ATS: 19-13-0 (0.47, 59.4%) avg line: -5.7
O/U: 17-14-1 (1.17, 54.8%) avg total: 196.4
Just wanted to say a big shout out to all of you on here that contribute. You have opened my eyes to a brand new way of handicapping. Appreciate all the knowledge you guys bring to this thread and Im glad I discovered it.. Thank you again.
Here is one I pieced together from an idea on a different site:
losses=1 and wins=0 and o:losses=1 and o:wins=0 and game number<3 and total>190
SU: 30-30 (0.00, 50.0%)
ATS: 30-30-0 (0.00, 50.0%) avg line: 0.0
O/U: 18-38-4 (-6.40, 32.1%) avg total: 197.8
If you move the total up to 200 the size gets tiny but the % goes up nicely:
SU: 9-9 (0.00, 50.0%)
ATS: 9-9-0 (0.00, 50.0%) avg line: 0.0
O/U: 4-14-0 (-9.17, 22.2%) avg total: 204.1
Last edited by pip2; 10-31-14 at 08:45 AM.
Good find Pip but do you know why it's duplicating some of the results?Here is one I pieced together from an idea on a different site:
losses=1 and wins=0 and o:losses=1 and o:wins=0 and game number<3 and total>190
SU: 30-30 (0.00, 50.0%)
ATS: 30-30-0 (0.00, 50.0%) avg line: 0.0
O/U: 18-38-4 (-6.40, 32.1%) avg total: 197.8
If you move the total up to 200 the size gets tiny but the % goes up nicely:
SU: 9-9 (0.00, 50.0%)
ATS: 9-9-0 (0.00, 50.0%) avg line: 0.0
O/U: 4-14-0 (-9.17, 22.2%) avg total: 204.1
Oh crap! I didn't put anything in there to nail the point of view down to one team in a given game..Good find Pip but do you know why it's duplicating some of the results?
losses=1 and wins=0 and o:losses=1 and o:wins=0 and game number < 3 and 200 < total and H
That really brings the size down to nothing! Sorry!
SU: 7-2 (7.56, 77.8%)
ATS: 7-2-0 (2.83, 77.8%) avg line: -4.7
O/U: 2-7-0 (-9.17, 22.2%) avg total: 204.1
Last edited by pip2; 10-31-14 at 09:27 AM.
No site specification. H or AGood find Pip but do you know why it's duplicating some of the results?
Good luck.
Great work thus far fellas! I've been hanging over in the NHL situational thread and have found me way here. I'm working through a lot of the queries and went 1-1 last night. I'm still trying to collect all of them from previous posts. Keep up the good work! Loving it.
