Grambrinus db ?

[Bugsy]

line doesn't seem to work. What do I use to indicate the spread? Thx

[Bugsy]

"HF and line" - That works.

"HF and line>7" - That doesn't work.

[Bugsy]

Nevermind. I'm an idiot.

[Bugsy]

Here's where I was going. Home Favorites in 2021 of 3 to 6.5 are 17-37 ATS.

season=2021 and HF and line>-7 and line<-2.5

Play on Chargers and Giants (check late line).

[Bugsy]

season>2016 and P:L and P:season=season and A and F

13-3 ATS

Play on SF

[Thomas]

Here's where I was going. Home Favorites in 2021 of 3 to 6.5 are 17-37 ATS.

season=2021 and HF and line>-7 and line<-2.5

Play on Chargers and Giants (check late line).

Trouble here Paul it's on a 3 game skid right now but 69% with 54 plays in season is pretty good stuff

If you don't mind here's an easier way to write your query, little less work and cleaner

season=2021 and HF and -6.5<=line<=-3

You can also use the > symbol like this for same results

season=2021 and HF and -3>=line>=-6.5

when using the < symbol the lower number is on the left of the parameter (-6.5 to -3)

when using the > symbol the higher number is on the left of the parameter (-3 to -6.5)

[rolltide]

anyone know why this one doesn't show up for today? Reid's team off a bye playing a team with at least 20% WP

coach=Andy Reid and p:week + 2 = week and o:WP >= 20

[rolltide]

and this one should be showing up for Seattle but does not

HD and streak=-3 and o:streak=3

[Gambrinus]

anyone know why this one doesn't show up for today? Reid's team off a bye playing a team with at least 20% WP

coach=Andy Reid and p:week + 2 = week and o:WP >= 20

Try this:

http://www.gimmethedog.com/NFL?q=coa...%20o%3AWP%3E20

[Gambrinus]

and this one should be showing up for Seattle but does not

HD and streak=-3 and o:streak=3

I did this to investigate, and it tells me I forgot to run the process that calculates streak for the current week. I'm running it now and it should be good by 11:50 EST. Dec5.PNG

[Gambrinus]

season>2016 and P:L and P:season=season and A and F

13-3 ATS

Play on SF

Gald you figured it out!

[rolltide]

thx G
http://www.gimmethedog.com/NFL?q=coa...%20o%3AWP%3E19

Andy Reid teams are 5-23 ou off a bye when playing a team that isn't horrible and are 25-4 SU with 20 covers allowing just 15.7 ppg. When used in 6-pt teasers they are 28-1. Denver has also gone under in 10 straight div road games scoring avg 15.7 ppg so a KC win with u47 points looks good. You can use the same-game parlay at betMGM and get KC win with u52.5 -115

[rolltide]

home dogs on 3g losing streak are 21-4 ATS facing opponent on 3g winning streak that didn't score 39+ last game. They have won 18 of these SU. This improves to 16-1 ATS when it's a conference opponent and 9-0 ATS when a division opponent

ON SEA

http://www.gimmethedog.com/NFL?q=HD%...0season%3E1993

[Chamblin]

[rolltide]

this one should be active against MIN on Thursday. 2nd half of the season teams that lost to a previously winless team are 5-18 SUATS against an opponent off a win

po:wins<1 and week>7 and p:L and op:W

http://gimmethedog.com/NFL?q=po%3Awi...nd%20op%3AW%0A