MLB - Situation Plays - SDQL

**BasesLoaded314** · 06-13-14, 09:55 PM

Originally posted by otunj

Fade the Rays SU or fade Rays RL. Strong start to 2014

S(1@t:starter and t:site = away and to:team) is None and team = Rays and season = 2014 and o:WP < 55

yo, what does that phrase mean? ive never seen anything like it

**emceeaye** · 06-15-14, 09:26 AM

jMON,

I'm Having trouble bringing up the same record for your getaway game under system. what needs to be changed?

LGS and SG=3 and DAY and p:NGT and season=2013 and A and day=Sunday and division!=NLEast and month!=April and 10.5>total>7

[QUOTE=emceeaye;21984351]

Originally posted by JMon

My rendition of the MLB Getaway Day. These games normally fall on Wednesday, Thursday and most predominantly, Sunday. Sunday will be the day I use within my situation(s) of this day. In short, a Getaway Day is the last game of series and the road team is leaving.

The basic logic behind a Getaway Day is resting starters, lack of motivation- looking to get home after playing a night game which ends with a day game, look-ahead situations, and end of starter rotation.

I will focus on two situations (a fade and under play) that relate to the Getaway Day. I will also list plays and track its progression. For ease of tracking I will name them Situation A and B.

Situation A: FADE

Parameters (these must be met to consider a play)

Last game of a three game series
Road team
Day game
Played a night game the day before
Sunday game
NL conference team
A favorite of 140 or below and a dog of 200 and below (* lines are dependent on database lines)

Tracking: FADE

2014: 11-19 (+513)
2013: 33-53 (+814)
2012: 31-55 (+1794)
2011: 25-65 (+3504)
2010: 32-61 (+2115)
2009: 42-53 (-5)
2008: 44-56 (+60)
2007: 36-69 (+2560)

Situation B: UNDER

Parameters (these must be met to consider a play

Last game of a three game series
Road team
Day game
Played a night game the day before
Sunday game
Can NOT be a NL East team
Can NOT be in the month of April
Total from 10.5 to 7 (* lines are dependent on database lines)

Tracking: (O/U)

2014: 11-11-2 (-120)
2013: 37-81-2 (+4085)
2012: 48-62-7 (+930)
2011: 56-51-10 (-1190)
2010: 63-70-11 (+60)
2009: 62-80-2 (+1160)
2008: 62-71-4 (+260)
2007: 56-78-7 (+1590)
2006: 51-73-1 (+1615)
2005: 52-62-3 (+205)
2004: 46-64-5 (+1340)

(c)Jmon

[/QUOTEJ

Jmon,
excellent-Thank you!!

**JMon** · 06-16-14, 11:08 AM

sorry for the late response. I had golf tourn over the weekend. It appears the getaways did not do so well this sunday.

Here's the under system.

SG = SGS = 3 and LGS and A and p:NGT and DAY and day = Sunday and division!= NL East and 10.5>total>=7 and month>4

**emceeaye** · 06-17-14, 07:52 AM

No problem--Thank you.

Originally posted by JMon

sorry for the late response. I had golf tourn over the weekend. It appears the getaways did not do so well this sunday.

Here's the under system.

SG = SGS = 3 and LGS and A and p:NGT and DAY and day = Sunday and division!= NL East and 10.5>total>=7 and month>4

**BasesLoaded314** · 06-19-14, 04:54 AM

man, this thread has gone stale as of late.... ok, heres some stuff ive uncovered recently, im letting most of these queries mellow out for the time being and seeing how they perform "post discovery". please respond with any feedback/opinions/ concerns etc... ill be c&p ing quickly here so if any of these pop up errors, lemme know

(SG = 1 or SG = 4) and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1

(SG = 1 or SG = 4) and H and 6 > ou streak > -2 and s:SRA < 6 and s:SPT > 50 and ss:SPT > 48 and os:SPT < 114 and oss:SPT < 107 and starter rest < 9 and p:runs < 10 and pp:runs < 12 and 3 < (op:runs + opp:runs) < 16 and tA(HR, N=10) > .8 and oA(HR, N=10) < 1.8 and oA(doubles, N=10) > 1.1 and tA(doubles, N=10) > .9 and tA(errors, N=10) < 1.1 and .3 < oA(errors, N=10) < .9 and oA(walks, N=10) > 1.9 and day != Wednesday and oA(hits, N=10) > 6.8 and total < 10 and 6.5 < p:total < 11 and (STDSWHIP + o:STDSWHIP) < 3.105 and (s:SSO + ss:SSO + sss:SSO) > 6 and s:SSO < 10 and (os:SSO + oss:SSO + osss:SSO) > 5 and op:BPRA < 3

SG = 4 and SGS = 4 and H and p:HR != 0 and op:HR = 0 and pp:HR < 4 and opp:hits > 4 and op:hits < 11 and p:hits < 14 and s:SRA < 6 and os:SRA > 0 and s:SHA > 4 and os:SHA < 10

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < o

u streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

(ou streak = 4 or ou streak = 5) and s:SRA < 5 and os:SRA < 6 and SGS = 4 and 85 < s:SPT < 112 and starter rest < 8 and op:HR < 4 and o

u streak < 7

H and 9.5 > total > 7.5 and SG = 3 and SGS < 6 and playoffs = 0 and 73 < os:SPT < 109 and o:starter rest > 6 and month != 6 and 2 < p:hits < 16 and 1 < tA(doubles, N=10) < 2.3

4 < so:inning runs so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

(so:inning runs so:R1 = 3 or so:inning runs so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

6 > p:inning runs p:R1 > 1 and 2 < p:runs < 10 and 18 > p:hits > 9 and (SG = 1 or SG = 3) and 7 > SGS > 2 and s:SRA < 6 and 3 < s:SHA < 9 and s:SWA != 3 and 0 < s:SSO < 10 and s:SPT < 123 and starter rest > 4 and -3 < streak < 5 and 3 < os:SHA < 11 and os:SRA != 0 and os:SSO < 9 and op:runs < 14 and (line > 122 or line < 105) and game number > 14 and 1 < oA(doubles, N=10) < 2.8

1.8 > tA(runs, N=10) - oA(runs, N=10) > -.2 and H and tA(hits, N=10) - oA(hits, N=10) < 2.2 and 3 < s:SRA < 8 and s:SWA < 6 and os:SRA < 7 and 15 > op:hits > 9 and 1.7 > oA(HR, N=10) > .6 and SG < 3 and line < 115 and os:SPT > 75 and 4 < starter rest < 7 and o:starter rest < 7 and day != Saturday and tA(doubles, N=10) < 2.8 and tA(SO, N=10) > 5.4 and STDSWHIP > 1.04

H and streak = -1 and (SG = 2 or SG = 3) and 75 < s:SPT < 113 and starter rest < 21 and 4 < o:starter rest < 23 and playoffs = 0 and SGS < 5 and 88 < ss:SPT < 124 and s:SHA > 4 and 7 > s:SRA > 0 and 4 < ss:SHA < 10 and (p:BPRA + op:BPRA) < 9 and (p:HR + op:HR) < 5 and tA(doubles, N=10) < 2.5 and p:hits < 13 and day != Friday and (game number > 79 or game number < 60) and rest = 0 and .5 < oA(BPRA, N=10) < 2.3 and s:batters faced < 49 and 29 < os:batters faced < 49 and (p:start time - start time) < 700

-6 > p:margin > -10 and SG < 4 and day != Tuesday and month < 9 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 7 and os:SRA != 0 and os:SRA < 8 and line > -200 and p:hits < 13 and op:hits < 19 and opp:hits < 14 and oA(hits, N=10) < 11.5 and tA(runs, N=10) < 5.9 and total < 11.5 and tA(doubles, N=10) > 1 and oA(doubles, N=10) < 2.9 and 57 < s:SPT < 113 and os:SPT > 56 and starter rest < 11

streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 18 > p:hits > 3 and line > -225 and 1.7 > oA(HR, N=10) > .5 and tA(HR, N=10) > .3 and 2.6 > oA(doubles, N=10) > 1.05 and op:walks != 0 and STDSWHIP > .95 and o:STDSWHIP < 1.8 and ou streak > -6 and o

u streak < 4 and p:rest < 3 and (STDSERA < 1.58 or STDSERA > 2.71) and (85 > game number > 11 or game number > 101)

tA(BPRA) < oA(BPRA) and SG = 2 and s:SRA < 5 and 8 > ss:SRA > 0 and (s:SHA + s:SWA) < 12 and os:SHRA > 0 and oss:SHRA < 2 and (game number < 41 or 87 > game number > 61 or 103 > game number > 90 or game number > 130) and op:HR < 4 and op:hits < 14 and p:margin > -7 and -10 < pp:margin < 9 and -10 < opp:margin < 9 and streak > -4 and tA(hits, N=10) > 8.1 and oA(runs, N=10) < 5.3 and -243 < line < 165 and s:SPT > 76 and os:SPT > 66 and SGS < 5 and oA(doubles, N=10) < 2.6 and tA(errors, N=10) < 1.2

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

(s:SPT + ss:SPT) > 222 and s:SPT > 96 and ss:SPT < 132 and 58 < sss:SPT < 123 and s:SHA < 8 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 6 and ss:SHA > 3 and 7 > s:SWA > 0 and ss:SWA < 6 and sss:SWA < 4 and starter rest < 9 and s:starter rest < 8 and s:SSO > 3 and 12 > ss:SSO > 2 and total < 11 and p:hits < 16 and 19 > pp:hits > 3 and 1 < ppp:hits < 22 and streak < 6 and ou streak > -5 and game number > 30 and 8 > os:SRA > 0 and 14 > o:starter rest > 4 and 23 > os:starter rest > 3 and 24.5 > (s:SIP + ss:SIP + sss:SIP) > 16 and (os:SIP + oss:SIP + osss:SIP) > 11.35 and o:streak < 5 and oA(hits, N=10) < 11 and tA(doubles, N=10) < 2.9 and tA(BPRA, N=10) < 2.5 and oA(BPRA, N=10) > .4

**b1slickguy** · 06-19-14, 05:03 PM

AD and p:L and p:runs>4 and p:margin=-1 and pp:L and pp:runs>4 and pp:margin=-1 and month>4

**Alex Vaile** · 06-20-14, 01:31 AM

Originally posted by BasesLoaded314

man, this thread has gone stale as of late.... ok, heres some stuff ive uncovered recently, im letting most of these queries mellow out for the time being and seeing how they perform "post discovery". please respond with any feedback/opinions/ concerns etc... ill be c&p ing quickly here so if any of these pop up errors, lemme know

(SG = 1 or SG = 4) and H and 10.5 > total > 7 and 12.6 > oA(hits, N=10) > 9.1 and 9.2 < tA(hits, N=10) < 12.6 and 12 > s:SHA > 4 and s:SRA != 0 and s:SPT > 83 and 119 > os:SPT > 69 and o:starter rest < 10 and 19 > p:hits > 4 and op:hits > 4 and oA(walks, N=10) < 4.7 and ss:SPT < 116 and oA(HR, N=10) < 1.8 and tA(HR, N=10) < 2 and p:HR < 4 and oA(errors, N=10) < 1.1 and tA(errors, N=10) > .1

(SG = 1 or SG = 4) and H and 6 > ou streak > -2 and s:SRA < 6 and s:SPT > 50 and ss:SPT > 48 and os:SPT < 114 and oss:SPT < 107 and starter rest < 9 and p:runs < 10 and pp:runs < 12 and 3 < (op:runs + opp:runs) < 16 and tA(HR, N=10) > .8 and oA(HR, N=10) < 1.8 and oA(doubles, N=10) > 1.1 and tA(doubles, N=10) > .9 and tA(errors, N=10) < 1.1 and .3 < oA(errors, N=10) < .9 and oA(walks, N=10) > 1.9 and day != Wednesday and oA(hits, N=10) > 6.8 and total < 10 and 6.5 < p:total < 11 and (STDSWHIP + o:STDSWHIP) < 3.105 and (s:SSO + ss:SSO + sss:SSO) > 6 and s:SSO < 10 and (os:SSO + oss:SSO + osss:SSO) > 5 and op:BPRA < 3

SG = 4 and SGS = 4 and H and p:HR != 0 and op:HR = 0 and pp:HR < 4 and opp:hits > 4 and op:hits < 11 and p:hits < 14 and s:SRA < 6 and os:SRA > 0 and s:SHA > 4 and os:SHA < 10

p:HR = 2 and op:HR < 3 and SG < 5 and SG != 3 and 1 < SGS < 5 and s:SRA < 6 and os:SRA < 6 and (s:SHA + ss:SHA) < 17 and (os:SHA + oss:SHA) < 17 and 2.6 < tA(runs, N=10) < 6.8 and oA(runs, N=10) < 6.6 and total < 10.5 and 84 < os:SPT < 119 and starter rest < 20 and o:starter rest < 25 and (rest = 1 or rest = 0) and p:hits < 17 and 3 < op:hits < 18 and .8 < tA(doubles, N=10) < 2.5 and .8 < oA(doubles, N=10) < 3.1 and day != Wednesday and -2 < ou streak < 5 and -2 < o

u streak < 3 and month < 10 and (game number < 107 or game number > 116) and tA(walks, N=10) > 1.9 and 1.9 < oA(walks, N=10) < 4.7 and tA(BPRA, N=10) > .4 and p:hits > 5 and (start time - p:start time < -306 or start time - p:start time > -102) and (p:SO + op:SO) > 7

(ou streak = 4 or ou streak = 5) and s:SRA < 5 and os:SRA < 6 and SGS = 4 and 85 < s:SPT < 112 and starter rest < 8 and op:HR < 4 and o

u streak < 7

H and 9.5 > total > 7.5 and SG = 3 and SGS < 6 and playoffs = 0 and 73 < os:SPT < 109 and o:starter rest > 6 and month != 6 and 2 < p:hits < 16 and 1 < tA(doubles, N=10) < 2.3

4 < so:inning runs so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

(so:inning runs so:R1 = 3 or so:inning runs so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

6 > p:inning runs p:R1 > 1 and 2 < p:runs < 10 and 18 > p:hits > 9 and (SG = 1 or SG = 3) and 7 > SGS > 2 and s:SRA < 6 and 3 < s:SHA < 9 and s:SWA != 3 and 0 < s:SSO < 10 and s:SPT < 123 and starter rest > 4 and -3 < streak < 5 and 3 < os:SHA < 11 and os:SRA != 0 and os:SSO < 9 and op:runs < 14 and (line > 122 or line < 105) and game number > 14 and 1 < oA(doubles, N=10) < 2.8

1.8 > tA(runs, N=10) - oA(runs, N=10) > -.2 and H and tA(hits, N=10) - oA(hits, N=10) < 2.2 and 3 < s:SRA < 8 and s:SWA < 6 and os:SRA < 7 and 15 > op:hits > 9 and 1.7 > oA(HR, N=10) > .6 and SG < 3 and line < 115 and os:SPT > 75 and 4 < starter rest < 7 and o:starter rest < 7 and day != Saturday and tA(doubles, N=10) < 2.8 and tA(SO, N=10) > 5.4 and STDSWHIP > 1.04

H and streak = -1 and (SG = 2 or SG = 3) and 75 < s:SPT < 113 and starter rest < 21 and 4 < o:starter rest < 23 and playoffs = 0 and SGS < 5 and 88 < ss:SPT < 124 and s:SHA > 4 and 7 > s:SRA > 0 and 4 < ss:SHA < 10 and (p:BPRA + op:BPRA) < 9 and (p:HR + op:HR) < 5 and tA(doubles, N=10) < 2.5 and p:hits < 13 and day != Friday and (game number > 79 or game number < 60) and rest = 0 and .5 < oA(BPRA, N=10) < 2.3 and s:batters faced < 49 and 29 < os:batters faced < 49 and (p:start time - start time) < 700

-6 > p:margin > -10 and SG < 4 and day != Tuesday and month < 9 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 7 and os:SRA != 0 and os:SRA < 8 and line > -200 and p:hits < 13 and op:hits < 19 and opp:hits < 14 and oA(hits, N=10) < 11.5 and tA(runs, N=10) < 5.9 and total < 11.5 and tA(doubles, N=10) > 1 and oA(doubles, N=10) < 2.9 and 57 < s:SPT < 113 and os:SPT > 56 and starter rest < 11

streak = 1 and SG = 2 and s:earned runs < 9 and s:SHA < 10 and ss:SHA < 12 and 0 < os:SRA < 7 and 63 < s:SPT < 117 and 9.76 > oA(hits, N=4) > 5.76 and 5.0 > oA(walks, N=10) > 2.1 and o:streak > -7 and 2.2 < oA(runs, N=7) < 5.99 and 18 > p:hits > 3 and line > -225 and 1.7 > oA(HR, N=10) > .5 and tA(HR, N=10) > .3 and 2.6 > oA(doubles, N=10) > 1.05 and op:walks != 0 and STDSWHIP > .95 and o:STDSWHIP < 1.8 and ou streak > -6 and o

u streak < 4 and p:rest < 3 and (STDSERA < 1.58 or STDSERA > 2.71) and (85 > game number > 11 or game number > 101)

tA(BPRA) < oA(BPRA) and SG = 2 and s:SRA < 5 and 8 > ss:SRA > 0 and (s:SHA + s:SWA) < 12 and os:SHRA > 0 and oss:SHRA < 2 and (game number < 41 or 87 > game number > 61 or 103 > game number > 90 or game number > 130) and op:HR < 4 and op:hits < 14 and p:margin > -7 and -10 < pp:margin < 9 and -10 < opp:margin < 9 and streak > -4 and tA(hits, N=10) > 8.1 and oA(runs, N=10) < 5.3 and -243 < line < 165 and s:SPT > 76 and os:SPT > 66 and SGS < 5 and oA(doubles, N=10) < 2.6 and tA(errors, N=10) < 1.2

s:SRA < 2 and 5 > ss:SRA > 0 and sss:SRA < 4 and ssss:SRA < 6 and 0 < sssss:SRA < 8 and os:SRA < 5 and SG < 4 and day != Tuesday and day != Thursday and 4 < starter rest < 10 and o:starter rest < 11 and 161 > game number > 27 and line > -165 and 2 > p:margin > -9 and 11.2 > tA(hits, N=10) > 6.7 and 6.2 < oA(hits, N=10) < 11.3 and STDSWHIP > .948 and ss:SPT > 67 and 40 < oss:SPT < 113 and tA(doubles, N=10) < 2.5 and tA(errors, N=10) > .1 and .3 < oA(BPRA, N=10) < 2.6 and tA(BPRA, N=10) < 2.8

(s:SPT + ss:SPT) > 222 and s:SPT > 96 and ss:SPT < 132 and 58 < sss:SPT < 123 and s:SHA < 8 and s:SRA < 6 and ss:SRA < 7 and sss:SRA < 6 and ss:SHA > 3 and 7 > s:SWA > 0 and ss:SWA < 6 and sss:SWA < 4 and starter rest < 9 and s:starter rest < 8 and s:SSO > 3 and 12 > ss:SSO > 2 and total < 11 and p:hits < 16 and 19 > pp:hits > 3 and 1 < ppp:hits < 22 and streak < 6 and ou streak > -5 and game number > 30 and 8 > os:SRA > 0 and 14 > o:starter rest > 4 and 23 > os:starter rest > 3 and 24.5 > (s:SIP + ss:SIP + sss:SIP) > 16 and (os:SIP + oss:SIP + osss:SIP) > 11.35 and o:streak < 5 and oA(hits, N=10) < 11 and tA(doubles, N=10) < 2.9 and tA(BPRA, N=10) < 2.5 and oA(BPRA, N=10) > .4

Thanks for posting these Bases. I've made some good money using your total queries from last time you added a bunch. I looked up many of these and they look great!

**Alex Vaile** · 06-20-14, 01:32 AM

4 < so:inning runs so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

(so:inning runs so:R1 = 3 or so:inning runs so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

These 2 showed no results when I ran them Bases.

**BasesLoaded314** · 06-20-14, 03:36 AM

(so:R1 = 3 or so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

4 < so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

**posey** · 06-20-14, 08:01 AM

May I ask what "R1" means?

**Alex Vaile** · 06-20-14, 12:09 PM

Originally posted by BasesLoaded314

(so:R1 = 3 or so:R1 = 4) and SG != 2 and 5 > SGS > 1 and s:SRA < 10 and 3 < s:SHA < 10 and s:SWA < 5 and 6 > s:SSO > 1 and starter rest < 17 and s:SPT > 56 and os:SRA < 8 and s:SHRA < 4 and os:SHRA < 2 and os:SPT > 69 and o:starter rest < 18 and p:hits < 12 and 0 < ss:SSO < 12 and ss:SPT > 66 and -8 < os:margin < 6 and tA(hits,N=10) > 6.8 and oA(LOB, N=10) < 18.5 and 1.4 < oA(walks, N=10) < 4.8 and tA(walks, N=10) > 1.7

4 < so:R1 < 9 and s:SRA < 10 and s:SPT < 110 and starter rest < 40 and s:SHRA < 3 and SG != 3 and (game number > 118 or game number < 107) and os:SRA < 7 and os:SHA > 2 and os:SSO < 10 and os:SHRA < 3 and ou streak > -3

Thanks for the additional queries Bases.

**Alex Vaile** · 06-20-14, 12:55 PM

Originally posted by posey

May I ask what "R1" means?

It means runs scored in that inning.

**posey** · 06-20-14, 02:53 PM

Ah I see, thank you very much.

**JMon** · 06-20-14, 08:17 PM

you guys wants post and track plays in here? I'm game. Perhaps 3-5 a piece ????

**posey** · 06-21-14, 03:04 AM

16-47 (-2.03, 25.4%)	avg line: 137.0 / -149.7	on / against: -$2,727 / +$2,549	ROI: -43.3% / +27.0%
25-38 (-0.58, 39.7%)	avg line: -158.7 / 145.9	on / against: -$3,391 / +$2,949	ROI: -33.6% / +46.0%
36-24-3 (1.17, 60.0%)	avg total: 8.3	over / under: +$1,025 / -$1,600	ROI: +15.0% / -22.8%

**JMon** · 06-21-14, 11:27 AM

under play

9<=total and 5.7>=STDSERA>=5.2 and conference=AL and s:starter earned runs<=1 and (SG=2 or SG=3) and month!=7 and month!=9

**JMon** · 06-21-14, 11:29 AM

I believe I posted this one before ....under play on very nice heater

A and 10 >= total >= 7 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and conference = NL and Sum(hits@team and season) / Sum(at bats@team and season) <= .250 and o:conference = NL and STDSERA <= 2.70 and 2011<=season and SG!=2

**Alex Vaile** · 06-21-14, 01:11 PM

Originally posted by JMon

I believe I posted this one before ....under play on very nice heater

A and 10 >= total >= 7 and 9 * oS(o:earned runs - starter earned runs) / oS(9 - starter innings pitched) <= 3.33 and conference = NL and Sum(hits@team and season) / Sum(at bats@team and season) <= .250 and o:conference = NL and STDSERA <= 2.70 and 2011<=season and SG!=2

Looks good. And it coincides with one of base's queries that lists this game and pads game both under later. Best of luck.

**Alex Vaile** · 06-21-14, 01:17 PM

Originally posted by JMon

you guys wants post and track plays in here? I'm game. Perhaps 3-5 a piece ????

Let's do it JMon track them up.

Today I'll go with:
Under 7 in Braves Nats game -105
Under 6.5 in Pads and Dodgers -105
Blue Jays + 111
Phillies + 137

**barryt** · 06-22-14, 08:42 AM

Originally posted by JMon

My rendition of the MLB Getaway Day. These games normally fall on Wednesday, Thursday and most predominantly, Sunday. Sunday will be the day I use within my situation(s) of this day. In short, a Getaway Day is the last game of series and the road team is leaving.

The basic logic behind a Getaway Day is resting starters, lack of motivation- looking to get home after playing a night game which ends with a day game, look-ahead situations, and end of starter rotation.

I will focus on two situations (a fade and under play) that relate to the Getaway Day. I will also list plays and track its progression. For ease of tracking I will name them Situation A and B.

Situation A: FADE

Parameters (these must be met to consider a play)

Last game of a three game series
Road team
Day game
Played a night game the day before
Sunday game
NL conference team
A favorite of 140 or below and a dog of 200 and below (* lines are dependent on database lines)

Tracking: FADE

2014: 11-19 (+513)
2013: 33-53 (+814)
2012: 31-55 (+1794)
2011: 25-65 (+3504)
2010: 32-61 (+2115)
2009: 42-53 (-5)
2008: 44-56 (+60)
2007: 36-69 (+2560)

Situation B: UNDER

Parameters (these must be met to consider a play

Last game of a three game series
Road team
Day game
Played a night game the day before
Sunday game
Can NOT be a NL East team
Can NOT be in the month of April
Total from 10.5 to 7 (* lines are dependent on database lines)

Tracking: (O/U)

2014: 11-11-2 (-120)
2013: 37-81-2 (+4085)
2012: 48-62-7 (+930)
2011: 56-51-10 (-1190)
2010: 63-70-11 (+60)
2009: 62-80-2 (+1160)
2008: 62-71-4 (+260)
2007: 56-78-7 (+1590)
2006: 51-73-1 (+1615)
2005: 52-62-3 (+205)
2004: 46-64-5 (+1340)

(c)Jmon

Hi jmon
I'm very new to SDQL. I was drawn to this post as it gave both the logic and a plain English list of parameters (Often it's hard to make heads nor tails out of a long list of SDQL) .
I have 2 questions on the implementation and a couple of queries about the logic
Fade
Are the odds those of the FADE team or the team being played ON?
How critical are the odds as prices vary between books and timing of the bet. Which begs another question. Where does SDQL get it's odds? Consensus Las Vegas closing odds?

LOGIC
Why are April and NOT NL east both critical to the Under, but neither to the Fade?
I presumed , then checked, that the Fade doesn't yield a +ve ROI in the AL. I suppose its logical that the DH changes the chemistry of when to change pitchers in previous games.
Why not SGS=4?...too infrequent?. I checked and SGS=4 actually gives a higher ROI for the Fade. This did not surprise me as the logic of the Getaway would apply, if not more so, to a 4 game series.

I would appreciate comments from you on this post.
Tx
Barryt
Since you posted Fade 3-3 ;Under 3-4
ADDING:the ROI on the Fade,is slightly better if Fading Favourites..(and AF)

**JMon** · 06-22-14, 10:06 AM

Originally posted by barryt

Hi jmon
I'm very new to SDQL. I was drawn to this post as it gave both the logic and a plain English list of parameters (Often it's hard to make heads nor tails out of a long list of SDQL) .
I have 2 questions on the implementation and a couple of queries about the logic
Fade
Are the odds those of the FADE team or the team being played ON?
How critical are the odds as prices vary between books and timing of the bet. Which begs another question. Where does SDQL get it's odds? Consensus Las Vegas closing odds?

LOGIC
Why are April and NOT NL east both critical to the Under, but neither to the Fade?
I presumed , then checked, that the Fade doesn't yield a +ve ROI in the AL. I suppose its logical that the DH changes the chemistry of when to change pitchers in previous games.
Why not SGS=4?...too infrequent?. I checked and SGS=4 actually gives a higher ROI for the Fade. This did not surprise me as the logic of the Getaway would apply, if not more so, to a 4 game series.

I would appreciate comments from you on this post.
Tx
Barryt
Since you posted Fade 3-3 ;Under 3-4
ADDING:the ROI on the Fade,is slightly better if Fading Favourites..(and AF)

I am tracking the odds of the team we are fading. Prices and line movement , I presume, are critical to each individual. I am just tracking database lines; which has been my understanding they have an individual in Vegas entering lines manually which or neither opening or closing. Many have asked this question on the google group with no clear answer.

Too be honest, I didn't even think of a four games series and you are right it does provide decent results. Free feel to track it( looks like there is a fade today on Atl-btw), but I am just going to track the parameters I posted. I think your addition of logic is sound, perhaps the freshness of both teams (or even line makers) in the month of April has an affect on the total. NL east is an outlier for some reason I am unsure about.

**JMon** · 06-22-14, 10:09 AM

Couple of posted total winners yesterday! I will see if I can dig up some for winners... Getaway's coming too.

**JMon** · 06-22-14, 10:15 AM

ref post #750

Situation A: Fade a Sunday NL Getaway team

2014 tracking results on the fade: 14-22 (+445)

Fading(play against):

Pirates
Dodgers

**JMon** · 06-22-14, 10:25 AM

ref post #750

Situation B: Sunday Under Getaway

2014 tracking results on the under: 14-14-2 (-150)

Play under

Pirates
Tigers
Dodgers
Giants

**JMon** · 06-22-14, 10:52 AM

Mad Max appears to respond well after giving up two or more HRs....appears to be a decent price...

starter=Max Scherzer and s:SHRA>=2 and 20100530<=date

**JMon** · 06-22-14, 11:01 AM

History tells to back a NL team putting a lot of runs b2b, even with a season-to-date subpar BA

Sum(hits@team and season)/Sum(at bats@team and season)<=.250 and conference=NL and p:runs>=8 and pp:runs>=8 and 2006<=season and 150>=line>=-250 and SG<4

**JMon** · 06-22-14, 11:10 AM

Hammer play is active TB today...

hammer play not doing well of late

**Alex Vaile** · 06-22-14, 11:30 AM

Originally posted by Alex Vaile

Let's do it JMon track them up.

Today I'll go with:
Under 7 in Braves Nats game -105
Under 6.5 in Pads and Dodgers -105
Blue Jays + 111
Phillies + 137

Well 2 and 2 to start the picks for a total of 0 units. All plays are for 1 unit.
Today its
Under 7 +110 in Washington Atl
Under 7 -115 in San Diego
Mil - 126
Top 3 plays supported by queries. Bottom 2 plays supported by trends
Giants -143
Marlins +101

**JMon** · 06-22-14, 11:35 AM

bol Alex

**Alex Vaile** · 06-22-14, 11:55 AM

Originally posted by JMon

Hammer play is active TB today...

hammer play not doing well of late

Right we got worked on last couple but I'll try it again today. Thanks for the heads up. It's hard to know what's active with so many queries. Thanks JMon and good luck!

**emceeaye** · 06-22-14, 12:03 PM

Card:
As SU
Rays SU
Twins/WS under
Pirates RL
As/RS under

**emceeaye** · 06-22-14, 12:04 PM

with that high of a win rate we need to give more of a chance
with respect to the hammer play that is

**Alex Vaile** · 06-22-14, 12:40 PM

Originally posted by emceeaye

with that high of a win rate we need to give more of a chance
with respect to the hammer play that is

It is a great win rate and I played most of them, but for some reason its only 5 and 3 this year with last 2 big losses. Bedard has been pretty bad this year too and Astros pitcher been solid. But it's the Hammer play for a reason. Good luck you guys!

**Alex Vaile** · 06-22-14, 12:42 PM

Originally posted by JMon

History tells to back a NL team putting a lot of runs b2b, even with a season-to-date subpar BA

Sum(hits@team and season)/Sum(at bats@team and season)<=.250 and conference=NL and p:runs>=8 and pp:runs>=8 and 2006<=season and 150>=line>=-250 and SG<4

That and Dickey has been awful on the road. I like it JMon and I used it to make a play today.

**otunj** · 06-22-14, 01:00 PM

H and series game=series games=3 and temperature=Indoors and season=2014

Play the under when there is a game 3 of a 3 game home series when roofs are closed. Only losing season was 2004 (-$70). This season, the OU is 14-25-3 (+$970, ROI 20.5%)

Today's play would be the Dbacks vs Giants (roof is closed for game)