KillerCapper
KillerCapper
KillerCapper
KillerCapper
KillerCapper
KillerCapper
KillerSports
f 
Search Page
Queries Remaining: 4
Advanced Tools:
Copy Query URL Share on  
Logo
Record (W-L, Avg Cover Margin, Win %)ROIProfitP-Value
SU:37-31 (-0.2, 54.4%)5.0% / -9.3%$416 / $-7640.27275526
RL:32-35-0 (-0.4, 47.8%)-0.7% / -5.5%$-56 / $-4800.40445194
OU:39-27-2 (1.6, 59.1%)12.8% / -20.7%$955 / $-1,5400.08771336

team = Rockies and H and nnnnnnnn:site streak = -7 and season >= 2011

Date Day Season Site Team Opp Starter o:Starter Final Margin SUr OU Margin OUr Hits Errors BL/BD Line Total Innings
Sep 01, 2024Sun2024homeRockiesOriolesTy Blach - LZach Eflin - R1-6-5L-4U6-92-00-6156119
Jul 24, 2024Wed2024homeRockiesRed SoxCal Quantrill - RNick Pivetta - R20-713W16.5O21-111-417-012410.59
Jul 07, 2024Sun2024homeRockiesRoyalsTanner Gordon - RBrady Singer - R1-10-9L0.5O6-120-00-914510.59
Jun 05, 2024Wed2024homeRockiesRedsDakota Hudson - RGraham Ashcraft - R7-12-5L7.5O13-120-14-511011.59
May 12, 2024Sun2024homeRockiesRangersTy Blach - LJose Urena - R3-12W-6.5U7-90-02-112510.59
Aug 02, 2023Wed2023homeRockiesPadresKyle Freeland - LNick Martinez - R1-11-10L-0.5U4-141-10-1017012.59
Jun 11, 2023Sun2023homeRockiesPadresDinelson Lamet - RBlake Snell - L5-41W-2.5U8-72-01-217011.59
May 28, 2023Sun2023homeRockiesMetsAustin Gomber - LTylor Megill - R11-101W8O15-140-15-4121139
Apr 19, 2023Wed2023homeRockiesPiratesAustin Gomber - LJohan Oviedo - R3-14-11L6O5-180-20-12110119
Sep 25, 2022Sun2022homeRockiesPadresKyle Freeland - LMike Clevinger - R6-13-7L8.5O12-171-00-712510.59
Aug 24, 2022Wed2022homeRockiesRangersJose Urena - RMartin Perez - L4-16-12L9O9-180-00-12115119
Jul 31, 2022Sun2022homeRockiesDodgersGerman Marquez - RTony Gonsolin - R3-7-4L-1U8-122-01-4165119
Jul 03, 2022Sun2022homeRockiesDiamondbacksChad Kuhl - RZac Gallen - R6-51W0P8-110-01-5-105119
Jun 05, 2022Sun2022homeRockiesBravesRyan Feltner - RCharlie Morton - R7-8-1L4O12-112-10-4130119
May 22, 2022Sun2022homeRockiesMetsAustin Gomber - LTaijuan Walker - R0-2-2L-8.5U6-71-00-2-10510.59
Apr 20, 2022Wed2022homeRockiesPhilliesGerman Marquez - RZach Eflin - R6-9-3L4O12-120-02-5100119
Sep 08, 2021Wed2021homeRockiesGiantsJon Gray - RAnthony DeSclafani - R4-7-3L-0.5U10-110-03-312611.59
Aug 22, 2021Sun2021homeRockiesDiamondbacksJon Gray - RTaylor Widener - R4-8-4L0.5O5-110-01-6-17511.59
Jul 21, 2021Wed2021homeRockiesMarinersAustin Gomber - LKeynan Middleton - R6-33W-2.5U6-50-05-0-13011.59
Apr 25, 2021Sun2021homeRockiesPhilliesJon Gray - RChase Anderson - R12-210W2.5O16-70-110-2-12011.59
Sep 20, 2020Sun2020homeRockiesDodgersAntonio Senzatela - RTony Gonsolin - R6-33W-3.5U10-70-05-018012.59
Aug 18, 2019Sun2019homeRockiesMarlinsPeter Lambert - RJordan Yamamoto - R7-61W-0.5U10-110-21-2-17413.510
Jul 17, 2019Wed2019homeRockiesGiantsJon Gray - RShaun Anderson - R8-11-3L5.5O11-181-01-6-17013.59
Jun 16, 2019Sun2019homeRockiesPadresPeter Lambert - RNick Margevicius - L13-14-1L14O19-151-15-3-135139
May 12, 2019Sun2019homeRockiesPadresAntonio Senzatela - RNick Margevicius - L10-73W5O13-100-17-0-115129
Apr 24, 2019Wed2019homeRockiesNationalsGerman Marquez - RAnibal Sanchez - R9-54W3.5O12-120-06-3-16010.59
Sep 13, 2018Thu2018homeRockiesDiamondbacksKyle Freeland - LMatt Koch - R10-37W3O16-71-07-0-190109
Jul 29, 2018Sun2018homeRockiesAthleticsGerman Marquez - RFrankie Montas - R3-21W-6.5U8-50-03-0-13511.59
May 13, 2018Sun2018homeRockiesBrewersJon Gray - RFreddy Peralta - R3-7-4L-0.5U6-130-10-7-15010.59
Apr 25, 2018Wed2018homeRockiesPadresJon Gray - RTyson Ross - R5-23W-3U10-40-04-0-165109
Apr 11, 2018Wed2018homeRockiesPadresGerman Marquez - RLuis Perdomo - R6-42W-1.5U9-60-25-0-15511.59
Sep 06, 2017Wed2017homeRockiesGiantsKyle Freeland - LJohnny Cueto - R3-11-8L2O8-171-10-8-180129
Jun 22, 2017Thu2017homeRockiesDiamondbacksAntonio Senzatela - RZack Godley - R3-10-7L1.5O7-110-01-9-12011.59
Jun 07, 2017Wed2017homeRockiesGuardiansKyle Freeland - LTrevor Bauer - R8-17W-2U11-70-17-0104119
May 14, 2017Sun2017homeRockiesDodgersAntonio Senzatela - RJulio Urias - L9-63W4.5O13-120-13-212210.59
Sep 21, 2016Wed2016homeRockiesCardinalsGerman Marquez - RLuke Weaver - R11-110W-0.5U12-80-210-012312.59
Sep 07, 2016Wed2016homeRockiesGiantsJorge De La Rosa - LAlbert Suarez - R6-51W-1U11-130-01-3-105129
Jul 24, 2016Sun2016homeRockiesBravesTyler Chatwood - RTyrell Jenkins - R7-25W-3U11-51-17-0-215129
May 15, 2016Sun2016homeRockiesMetsTyler Chatwood - RJacob deGrom - R4-31W-3U6-80-01-2113109
Apr 27, 2016Wed2016homeRockiesPiratesJon Gray - RJon Niese - L8-9-1L6.5O18-150-00-7-10910.510
Sep 06, 2015Sun2015homeRockiesGiantsYohan Flande - LMadison Bumgarner - L4-7-3L1O9-140-02-5175109
Aug 05, 2015Wed2015homeRockiesMarinersChristopher Rusin - LTaijuan Walker - R7-52W1O9-120-02-31061110
Jul 26, 2015Sun2015homeRockiesRedsKyle Kendrick - RMichael Lorenzen - R17-710W12.5O15-140-011-2-10511.59
Jun 25, 2015Thu2015homeRockiesDiamondbacksJorge De La Rosa - LRubby De La Rosa - R6-42W-0.5U7-90-14-1-10510.59
Aug 24, 2014Sun2014homeRockiesMarlinsChristian Bergman - RBrad Hand - L7-43W0.5O14-110-03-0-11210.59
Jul 27, 2014Sun2014homeRockiesPiratesFranklin Morales - LEdinson Volquez - R5-7-2L1.5O10-160-12-211010.59
Jun 25, 2014Wed2014homeRockiesCardinalsYohan Flande - LMarco Gonzales - L6-9-3L3.5O9-122-04-312011.59
May 22, 2014Thu2014homeRockiesGiantsJorge De La Rosa - LTim Hudson - R2-20P--10-50-01-1--9
May 06, 2014Tue2014homeRockiesRangersJuan Nicasio - RRobbie Ross - L12-111W2.5O21-80-111-1-12010.59
Apr 09, 2014Wed2014homeRockiesWhite SoxJuan Nicasio - RErik Johnson - R10-46W4O16-80-16-1-165109
Sep 04, 2013Wed2013homeRockiesDodgersJorge De La Rosa - LEdinson Volquez - R7-52W2O11-112-15-1-125109
Aug 14, 2013Wed2013homeRockiesPadresJorge De La Rosa - LAndrew Cashner - R4-22W-3.5U8-80-02-0-1459.59
Jul 28, 2013Sun2013homeRockiesBrewersJhoulys Chacin - RDonovan Hand - R6-51W1.5O12-101-01-2-1759.59
Jul 04, 2013Thu2013homeRockiesDodgersJhoulys Chacin - RChris Capuano - L9-54W4O12-130-16-1-135109
Jun 16, 2013Sun2013homeRockiesPhilliesJhoulys Chacin - RCole Hamels - L5-23W-2.5U9-60-05-0-1119.59
Apr 24, 2013Wed2013homeRockiesBravesTyler Chatwood - RTim Hudson - R6-51W1.5O15-102-02-21209.510
Sep 12, 2012Wed2012homeRockiesGiantsJeff Francis - LTim Lincecum - R3-8-5L1O8-150-00-5111109
Sep 02, 2012Sun2012homeRockiesPadresJeff Francis - LCasey Kelly - R11-101W10.5O11-201-24-3-11010.59
Aug 19, 2012Sun2012homeRockiesMarlinsDrew Pomeranz - LJosh Johnson - R3-21W-4.5U9-62-01-21209.59
Jul 01, 2012Sun2012homeRockiesPadresDrew Pomeranz - LKip Wells - R0-2-2L-10U7-71-00-2-148129
Jun 14, 2012Thu2012homeRockiesAthleticsAlex White - RJarrod Parker - R2-8-6L-0.5U6-143-00-8-11010.59
May 06, 2012Sun2012homeRockiesBravesJuan Nicasio - RBrandon Beachy - R2-7-5L0P4-90-00-611099
Aug 24, 2011Wed2011homeRockiesAstrosAaron Cook - RWandy Rodriguez - L7-61W3.5O13-141-12-2-1559.510
Aug 07, 2011Sun2011homeRockiesNationalsAaron Cook - RJohn Lannan - L2-3-1L-5.5U9-71-10-2-12010.59
Jul 21, 2011Thu2011homeRockiesBravesJhoulys Chacin - RTommy Hanson - R6-9-3L6.5O10-100-04-3-1108.59
Jul 03, 2011Sun2011homeRockiesRoyalsJason Hammel - RLuke Hochevar - R8-16-8L14O7-211-20-8-150109
Jun 19, 2011Sun2011homeRockiesTigersAaron Cook - RJustin Verlander - R1-9-8L1O4-132-10-812599
May 29, 2011Sun2011homeRockiesCardinalsJhoulys Chacin - RKyle Lohse - R3-4-1L-2U9-61-00-3-13099
Apr 06, 2011Wed2011homeRockiesDodgersJason Hammel - RChad Billingsley - R7-52W3O9-101-13-2-12099
Query Fundamentals

For more detailed information on SDQL including manuals and videos go HERE

The syntax for access to the NBA team data is: game reference:parameter. To see the date, team, and opponent where the team scored +120 points after scoring +120 runs in the previous game use the SDQL: date,team,o:team@points>120 and p:points>120

The syntax for access to the NBA player data: [team:]player name:game reference:parameter. To see the date, team, opponent and number of points by Kobe Bryant in the game after he scored more than 30 use the SDQL: date,team,o:team,Kobe Bryant:points@Kobe Bryant:p:points>30

Query Fundamentals:

A query consists of one or more clauses joined by and or or.

Examples:

The query:

50 < Kobe Bryant : points

and

site = away

The explain:

returns home games where Kobe Bryant scored more than 50 points on the road

If no player is given then results for the team are checked. E.g.

The query:

120 < Bulls : points

and

site = home

returns games in which the Bulls scored more than 120 points at home

points < 60

returns games when the team scored fewer than 60 points

Multiple conditions can be imposed using a comma delimited format.

points < 90,100,110

gives results grouped by points < 90, points < 100, and points < 110

You can comma-group on both sides of the inequality as per:

70,80,90,100 < points < 90,100,110

Game Reference

p :

team's previous game

N :

next match up

on :

opponent's next game

P :

previous match up

S :

starter's previous match up start

n :

team's next game

s :

starter's previous start

op :

opponent's previous game

Examples:

The query:

100 < t:rushing yards

and

to:rushing yards < 100

The explain:

Use this SDQL to see how teams do when rushing for more than 100 yards while holding their opponent to few than 100 yards

Queryable Fields

· after all star break
· at bats
· attendance
· bad start
· biggest lead
· bullpen runs allowed
· date
· day
· division
· double header
· double plays
· doubles
· dpa
· dps
· earned runs
· errors
· extra base hits
· game number
· hit batters
· hit by pitchers
· hits
· home runs
· inning runs
· innings led
· innings tied
· league
· left on base
· line
· losses
· manager
· margin
· matchup losses
· matchup wins
· month
· multiple run innings
· opponent
· opponents
· ou margin
· ou streak
· over
· pitchers used
· playoffs
· quality start
· rest
· rl margin
· rl streak
· round
· run line
· run line runs
· runs
· score
· scored first
· scored in innings
· season
· seed
· series game
· series games
· series losses
· series wins
· site
· site streak
· srslg
· start time
· starter
· starter balls
· starter batters faced
· starter earned run average
· starter hits
· starter homeruns
· starter innings pitched
· starter losses
· starter matchup losses
· starter matchup wins
· starter pitches thrown
· starter runs allowed
· starter strikeouts
· starter strikes thrown
· starter throws
· starter walks
· starter wins
· streak
· strike outs
· team
· team left on base
· team strikes thrown
· temperature
· time zone
· times tied
· total
· triples
· umpires
· under
· walks
· wins

The query:

40 < p:points

and

40 < p2:points

and

40 < p3:points

and

40 < p4:points

Use this SDQL to see how teams do after scoring more than 40 points their last four games

2*P:points in the paint < Po:points in the paint

and

P:season = season

return games in which the team was outscored in the paint by a factor of 2 in their previous match up

The query:

0.25*p:points<=p:fast break points

and

po:points

The explain:

return games with a team off a win in which they scored at least 25% of their points from fast breaks

Short Cuts

H, A, W, L, F, D, O, U, C, X   are short cuts for home,away,win,loss,favorite,dog,over the total,under the total, and conference. As with the parameter prefixes, these can be strung together without limit.

Examples:

The query:

HF

×

and

p:HFL

×

and

pp:HFL

×

The explain:

returns home favorites after they just lost as home favorites their last two games

P:O

×

and

PP:O

×

and

PPP:O

×

and

PPPP:O

×

and

PPPPP:O

×

and

PPPPPP:O

×

The explain:

returns games where teams have gone over the total their last six matchups

In addition to the above single letter short cuts the following abbreviations are available:

· AASB - After All-Star Break
· AWP - Away Winning Percentage
· BASB - Before All-Star Break
· BL - Biggest Lead
· BPRA - Bull Pen Runs Allowed
· BS - Bad Start (4 or fewer innings and 5 or more earned runs)
· DAY - Day (start time<1800)
· DDP - Defensive Double Plays
· DIV - Divisional Game
· FGS - First Game of a Series
· HPR - Hits Per Run
· HPU - Home Plate Umpire
· HR - Home Runs
· HWP - Home Winning Percentage
· IL - Innings Led
· IT - Innings Tied
· LGS - Last Game of a Series
· LOB - Left on Base
· MRI - Multiple Run Innings
· NDIV - Not a Divisional Game
· NGT - Night (start time>=1800)
· NQS - Non Quality Start
· ODP - Offensive Double Plays (hit into double plays)
· PBRS - Percent Base Runners Scored
· PO - During the Playoffs
· PU - Pitchers Used
· QS - Quality Start (at least 6 innings and 3 or fewer earned runs)
· REG - During the Regular Season
· RG3 - Rubber Game 3 (3rd game of a 3 game series and they split the first 2)
· RMAX - The maximum runs the team scored in any one inning
· SERA - Starter Earned Run Average in the Referenced Game
· SF - Scored First: How many runs a team scored before their opponent scored
· SG - Series Game
· SGS - Series Games
· SHA - Starter Hits Allowed
· SHF - Starter Hitters Faced
· SHRA - Starter Home Runs Allowed
· SII - Scored In Innings
· SIP - Starter Innings Pitched
· SO - Strikeouts
· SOPW - Strikeouts Per Walk
· SPB - Strike Per Ball
· SPPH - Starter Pitch Per Hitter
· SPT - Starter Pitches Thrown
· SRA - Starter Runs Allowed
· SSO - Starter Strike Outs
· SSPB - Starter Strike Per Ball
· STDHPR - Season To Date Hits Per Run
· STDSERA - Starter Season To Date ERA
· STDSOPW - Season To Date Stike Outs Per Walk
· STDSPB - Season To Date Stikes Per Ball
· STDSSOPW - Starter Season To Date Stike Outs Per Walk
· STDSSPB - Starter Season To Date Stikes Per Ball
· STDSWHIP - Starter Season To Date WHIP
· STL - Starter Throws Left
· STR - Starter Throws Right
· SWA - Starter Walks Allowed
· SWHIP - Starter Walks Plus Hits Per Inning Pitched
· TLOB - Team Left On Base
· TT - Times Tied
· WOW - Walk Off Win
· WP - Winning Percentage
· XBH - eXtra Base Hits (doubles + triples)

MLB Trend Builder

For a more detailed review of how to use the Trend Builder, go HERE












    MLB Field Options
     as 
    • starter +" - "+ starter throws as "Starter"✓
    • str(int(biggest lead))+"-"+str(int(o:biggest lead)) as "BL/BD"✓
    • after all star break+
    • at bats+
    • attendance+
    • bad start+
    • biggest lead+
    • bullpen runs allowed+
    • date#
    • day+
    • division+
    • double header+
    • double plays+
    • doubles+
    • dpa+
    • dps+
    • earned runs+
    • errors+
    • extra base hits+
    • game number+
    • hit batters+
    • hit by pitchers+
    • hits+
    • home runs+
    • inning runs✓
    • innings led+
    • innings tied+
    • league+
    • left on base+
    • line✓
    • losses+
    • manager+
    • margin✓
    • matchup losses+
    • matchup wins+
    • month+
    • multiple run innings+
    • opponent+
    • opponents+
    • ou margin✓
    • ou streak+
    • over+
    • over_invest✓
    • over_profit✓
    • pitchers used+
    • playoffs+
    • quality start+
    • rest+
    • rl margin✓
    • rl streak+
    • rl_invest✓
    • rl_profit✓
    • round+
    • run line✓
    • run line runs+
    • runs+
    • score+
    • scored first+
    • scored in innings+
    • season✓
    • seed+
    • series game+
    • series games+
    • series losses+
    • series wins+
    • site✓
    • site streak+
    • srslg+
    • start time+
    • starter+
    • starter balls+
    • starter batters faced+
    • starter earned run average+
    • starter hits+
    • starter homeruns+
    • starter innings pitched+
    • starter losses+
    • starter matchup losses+
    • starter matchup wins+
    • starter pitches thrown+
    • starter runs allowed+
    • starter strikeouts+
    • starter strikes thrown+
    • starter throws+
    • starter walks+
    • starter wins+
    • streak+
    • strike outs+
    • su_invest✓
    • su_profit✓
    • team#
    • team left on base+
    • team strikes thrown+
    • temperature+
    • time zone+
    • times tied+
    • total✓
    • triples+
    • umpires+
    • under+
    • under_invest✓
    • under_profit✓
    • walks+
    • wins+
    • Day✓
    • Opp✓
    • o:Starter✓
    • Final✓
    • SUr✓
    • OUr✓
    • Hits✓
    • Errors✓
    • BL+
    • Innings✓
    Queryable Fields

    · after all star break
    · at bats
    · attendance
    · bad start
    · biggest lead
    · bullpen runs allowed
    · date
    · day
    · division
    · double header
    · double plays
    · doubles
    · dpa
    · dps
    · earned runs
    · errors
    · extra base hits
    · game number
    · hit batters
    · hit by pitchers
    · hits
    · home runs
    · inning runs
    · innings led
    · innings tied
    · league
    · left on base
    · line
    · losses
    · manager
    · margin
    · matchup losses
    · matchup wins
    · month
    · multiple run innings
    · opponent
    · opponents
    · ou margin
    · ou streak
    · over
    · pitchers used
    · playoffs
    · quality start
    · rest
    · rl margin
    · rl streak
    · round
    · run line
    · run line runs
    · runs
    · score
    · scored first
    · scored in innings
    · season
    · seed
    · series game
    · series games
    · series losses
    · series wins
    · site
    · site streak
    · srslg
    · start time
    · starter
    · starter balls
    · starter batters faced
    · starter earned run average
    · starter hits
    · starter homeruns
    · starter innings pitched
    · starter losses
    · starter matchup losses
    · starter matchup wins
    · starter pitches thrown
    · starter runs allowed
    · starter strikeouts
    · starter strikes thrown
    · starter throws
    · starter walks
    · starter wins
    · streak
    · strike outs
    · team
    · team left on base
    · team strikes thrown
    · temperature
    · time zone
    · times tied
    · total
    · triples
    · umpires
    · under
    · walks
    · wins

    SimpleSearch Tips

    Tips on Asking Questions:

    1.) Commas save lives: Lets eat, grandma. Lets eat grandma. Two very different things. Use of commas:

    Houston when not a dog coming off a home game


    This means Houston is neither a dog nor coming off a home game.

    Houston when not a dog, coming off a home game


    This means Houston is not a dog and is coming off a home game.

    2.) Be precise, literal, and don't assume.

    How have the Bengals have done after having won 4 of their last 5 games?


    This means how have the Bengals done after having won exactly 4 of their last 5 games. If they won 5 of their last 5 those instances would not appear in your results. If you want know how the Bengals have done after having won AT LEAST 4 of their last 5 games, specify it.

    3.) Try to write proper English in a tangible complete sentence.

    If you misspell words or don't articulate yourself clearly you're increasing the chances that you won't be understood or get the answer you're looking for. Don't hesitate to ask a question in our Discord Community if you're unsure.

    Notes:

    1.) We've tested the language learning model to be over 95% accurate at translating English, especially for simpler inquiries, and with its machine learning algorithms it will only continue to improve. Be aware that SimpleSearch may not understand you or properly translate 100% of the time dependent upon how articulate and concise your question is. Give your search results a Thumbs Up or Thumbs Down to help it learn. If you don't think it gave you the right answer, let it know. Conversely, if it looks correct, also let it know.


    2.) SimpleSearch is not trained on player specific queries, yet.


    3.) SDQL itself currently still provides more versatility for detailed searches like open ended queries, list searches, and custom table queries.


    4.) SimpleSearch is currently available for NFL and NBA and we are actively working to expand its availability to all other sports.