NBA Stituational Bet, SDQL

mem/lac O 1 unit
den beats bkn 4 units
tor/no U 2 units
no beats tor 5 units
phi/mia O 2 units
sa/ut O 2 units
ut beats sa 5 units
mn beats hou 1 unit
bos/phx U 1 unit

Pip,
What do you think of this for tonight?

0 < p:M3<=5 and AD and -2 > p:margin >=-7 and rest = 0 and p:overtime=1 and rest = 0 and [M1 > -2.5]

Originally Posted by emceeaye

Pip,
What do you think of this for tonight?

0 < p:M3<=5 and AD and -2 > p:margin >=-7 and rest = 0 and pvertime=1 and rest = 0 and [M1 > -2.5]

Sorry, I just got back from work and it looks like that game already sailed. But I sure as heck didn't see anything wrong with the query. I kind of stopped with those 1st quarter games because I got stung too many times. Maybe if I come across one where the two teams from last night were both major contenders, and the loss for one of them was heartbreaking, and today that team is playing some run of the mill team full of eager beavers who always come out strong and then fade at the end (bos as the spoiler rather than the team that lost the tough one the night before?)...Unfortunately I will probably always look for some reason to make that bet..

mem/lac O 1 unit --> -1
den beats bkn 4 units --> -4
tor/no U 2 units --> -2
no beats tor 5 units --> +5
phi/mia O 2 units --> +2
sa/ut O 2 units --> -2
ut beats sa 5 units --> +5
mn beats hou 1 unit --> -1
bos/phx U 1 unit --> -1

total +1
running total +14
(81-67)

cle/det U 1 unit
det beats cle 2 units
tor beats dal 1 unit
wsh beats gs 10 units
gs/wsh O 3 units
okc beats ind 4 units

cle/det U 1 unit --> +1
det beats cle 2 units --> -2
tor beats dal 1 unit --> -1
wsh beats gs 10 units --> -10
gs/wsh O 3 units --> +3
okc beats ind 4 units --> +4

Total -5
Running total +9
(89-80)

Good to see ya goin boys

phi/mil O 3 units
phi beats mil 2 units
cha/chi U 1 unit
chi beats cha 2 units
mem/sac O 1 unit
sac beats mem 1 unit
bos beats ny 2 units
lal beats ut 1 unit
orl beats mia 1 unit
dal beats atl 1 unit
dal/atl O 1 unit
no beats bkn 2 units
phx/den U 1 unit
den beats phx 2 units
wsh/mn O 1 unit
wsh beats mn 1 unit
por beats sa 1 unit

What's the point in posting all losing picks? good luck with that.

Originally Posted by smize

What's the point in posting all losing picks? good luck with that.

very entertaining indeed. don't you have better things to do?

phi/mil O 3 units --> +3
phi beats mil 2 units --> -2
cha/chi U 1 unit --> +1
chi beats cha 2 units --> -2
mem/sac O 1 unit --> -1
sac beats mem 1 unit --> +1
bos beats ny 2 units --> +2
lal beats ut 1 unit --> +1
orl beats mia 1 unit --> -1
dal beats atl 1 unit --> -1
dal/atl O 1 unit --> -1
no beats bkn 2 units --> +2
phx/den U 1 unit --> +1
den beats phx 2 units --> -2
wsh/mn O 1 unit --> -1
wsh beats mn 1 unit --> -1
por beats sa 1 unit --> +1

total 0 units
running total +9
(101-92)

cle beats gs 3 units
gs/cle O 1 unit
okc/phx U 2 units
phx beats okc 3 units

cle beats gs 3 units --> +3
gs/cle O 1 unit --> -1
okc/phx U 2 units --> -2
phx beats okc 3 units --> +3

total +3
running total +12
(107-95)

mn beats chi 3 units
mn/chi O 1 unit
cle/ind U 1 unit
ind beats cle 2 units
cha/bos U 1 unit
bos beats cha 1 unit
mem beats lac 1 unit
lac/mem U 1 unit
mia beats no 1 unit
ny/det O 1 unit
lal beats mil 7 units
orl/atl U 1 unit
hou beats bkn 6 units
bkn/hou O 1 unit
sac beats sa 7 units
sa/sac O 1 unit
okc/por O 1 unit
okc beats por 1 unit
phi beats wsh 3 units

Going to give the trends (that make sense to me i.e. have an angle I can understand) another try starting tonight after some time to get back into routine after the all break. After whittling down to that subset I'm even further throwing out any trend hitting less than 53-54% on the season, or month, or day. Any unusual rest patterns will be taken into account as well.