NBA Stituational Bet, SDQL

perryhs · 01-16-15, 05:21 AM

NCAABB

game number>20 and tA(line is None)=0 and rank is None and p:W and op:U

perryhs · 01-16-15, 07:11 AM

NCAABB

game number>20 and tA(offensive rebounds>o:defensive rebounds)>=0.2 and op:W

perryhs · 01-16-15, 08:13 AM

NCAABB

game number>20 and tA(steals>=10)>=0.5 and p

oints>80

perryhs · 01-16-15, 08:54 AM

NCAABB

game number>20 and tA(half scores[0]<25 or half scores[1]<25)>=0.5 and p:LD and H

Alex Vaile · 01-16-15, 10:47 AM

Originally posted by nash13

I don't know, maybe the Best Bet thing was not going well enough, or they have better things to do. I will keep updating the spreadsheet and use it as always, all of you are invited to discuss, contribute and criticize.

Hey Nash I've been checking the soreadsheet but it stops in early January on the active queries. Am I missing something?

Cutler'sThumb · 01-16-15, 11:04 AM

Originally posted by perryhs

NCAABB

game number>20 and tA(half scores[0]<25 or half scores[1]<25)>=0.5 and p:LD and H

Hey Perry, thanks for the contributions. Do you have access to the spreadsheet? If so, maybe you can just throw all your best trends on there? That way they don't get lost in the shuffle of the thread. If you don't have access just PM Nash13.

nash13 · 01-16-15, 11:47 AM

Originally posted by Alex Vaile

Hey Nash I've been checking the soreadsheet but it stops in early January on the active queries. Am I missing something?

I do the tracking all by myself lately. I will update them as soon as possible.

nash13 · 01-16-15, 11:48 AM

Originally posted by Cutler'sThumb

Hey Perry, thanks for the contributions. Do you have access to the spreadsheet? If so, maybe you can just throw all your best trends on there? That way they don't get lost in the shuffle of the thread. If you don't have access just PM Nash13.

He has access to it. But I transferred most of the trends from him here or from google group to the sheet already.

Alex Vaile · 01-16-15, 11:51 AM

Originally posted by nash13

I do the tracking all by myself lately. I will update them as soon as possible.

Ok thanks. Good luck to u!

perryhs · 01-16-15, 08:47 PM

Originally posted by Cutler'sThumb

Hey Perry, thanks for the contributions. Do you have access to the spreadsheet? If so, maybe you can just throw all your best trends on there? That way they don't get lost in the shuffle of the thread. If you don't have access just PM Nash13.

I post query here. because I hope someone can discuss the query itself. If you don't like it. It's OK. And I'll stop post it. and let the board clean. Sorry to make you inconvenience.

nash13 · 01-16-15, 08:58 PM

No i think he meant otherwise. He appreciates your postings and like what you are doing.

JMon · 01-16-15, 09:14 PM

Originally posted by nash13

I don't know, maybe the Best Bet thing was not going well enough, or they have better things to do. I will keep updating the spreadsheet and use it as always, all of you are invited to discuss, contribute and criticize.

For real..??? "Best Bet was not going well" 200+ bets and plus units..yes it was going well. I asked if anyone would help track (had bad week where I needed help) and NO ONE OFFERED. NASH...THAT's WHY.

TheLineShifter · 01-16-15, 09:15 PM

Hey perryhs,

Thank you very much for your valuable contributions especially for the NCAABB category. I would be more than happy to see more trends like those if you don't mind.

nash13 · 01-16-15, 09:19 PM

Originally posted by JMon

For real..??? "Best Bet was not going well" 200+ bets and plus units..yes it was going well. I asked if anyone would help track (had bad week where I needed help) and NO ONE OFFERED. NASH...THAT's WHY.

No offense, i was not disrespecting your work or anything else like this. I just speculated why everyone stopped posting their best bets. It was a good discussion platform. The record was not the most interesting aspect in it.
Beside from that. The development and achieving 600+ different queries in 3 months is beyond awesome. I can not thank every single one for that enough.

Cutler'sThumb · 01-17-15, 11:29 AM

Originally posted by perryhs

I post query here. because I hope someone can discuss the query itself. If you don't like it. It's OK. And I'll stop post it. and let the board clean. Sorry to make you inconvenience.

Originally posted by nash13

No i think he meant otherwise. He appreciates your postings and like what you are doing.

Yep, agree with Nash...I definitely appreciate you posting. The more the better, in fact. I just wanted to make sure we didn't lose them, as I didn't have time to cross check the spreadsheet and it looked like they might not all be making it over to there. Nash's back tests seem pretty clear that the larger the volume of (quality) trends, the better the net effect is for that sport. Before you started posting, NCAABB clearly needed some help, so thanks very much for your willingness to contribute (hockey too)!

JMon · 01-17-15, 12:09 PM

Originally posted by nash13

No offense, i was not disrespecting your work or anything else like this. I just speculated why everyone stopped posting their best bets. It was a good discussion platform. The record was not the most interesting aspect in it.
Beside from that. The development and achieving 600+ different queries in 3 months is beyond awesome. I can not thank every single one for that enough.

it's all good nash!

Cutler'sThumb · 01-17-15, 02:03 PM

These are the raw numbers from NCAABB so far this season with the 85 trends currently on the spreadsheet. I only applied "season=2014" to each trend and added up the cumulative record, so these numbers don't account for doubles or conflicting plays.

ATS: 239-146, 62.08%
Totals: 359-259, 58.09%
Combined: 598-405, 59.62%, 13.82% ROI

This is an unbelievable record, and half of the trends have come from you, perryhs, so YES!!! please keep sharing. It was my mistake to not check the spreadsheet before I posted yesterday.

Heart · 01-17-15, 07:38 PM

Yes keep posting the trends, PerryHS! Thank you for your contributions!

TheLineShifter · 01-17-15, 08:19 PM

Dear nash13,

I wish you a healthy, happy and a serene year. Thank you very much for all your hard work and leading this beautiful community in order to beat up the bookmakers. Happy birthday!

moshi · 01-17-15, 11:42 PM

Hi guys. Trying to interpret a query that has "P:game number=game number-1"

Does this mean the previous matchup between these teams, the game number was one less, so if today's game is game number 67, the previous matchup would be 66?

If that's the case, is that even relevant?

Heart · 01-18-15, 11:04 AM

it means the last time both teams played against each other was the previous game the team played... back to back same matchup basically.

and yeah i wouldn't be surprised if there could potentially be some interesting data to be mined based on back to back same matchup

neilb1973 · 01-18-15, 12:58 PM

NCAABB

HF and streak >= 6 and -16.5 <= line <= -7 and p:A and pp:A and ppp:A

moshi · 01-19-15, 02:57 AM

Thanks Heart. That makes way more sense :P

Cutler'sThumb · 01-19-15, 04:26 AM

Originally posted by dasdqlgambler

Hey guys had some problems on here but I am back...used to be Con sig...new handle now. The NCAAB does look good in back testing but I have been using it this week and it has been horrible to try and use in real time. The problem is before the games the lines and totals are rarely posted, especially the totals. The are put in afterwards so they show up great in back testing but cant take advantage of them in real life. Need that database to really get up and going and stable before I am going to use it I think....but it will be great in future Im sure. On that note, NBA and NHL have been putting up some serious units these days depending on how you filter your queries. Had two days this week where 8-0 and 9-0 in NHL and NBA. All other days also posted profit of at least half a unit. Great work by everyone on here.

Good to know. I definitely noticed that many of the totals were spotty, and many of the smaller school games that are listed were only offered at BetOnline according to the sbr odds page. Didn't realize that some are being filled in after the fact tho. Thanks for the heads up! Hopefully they get it running properly soon.

itsshaggy · 01-19-15, 09:17 AM

What happened to there actually being plays posted? This stuff is confusing as hell to someone that barely can check their email.

birdsfan · 01-19-15, 01:52 PM

todays nba stuff

minnesota charlotte

minnesota 214 / 143 / 104
under 214
over 87 / 62
charlotte 192

76ers wizards

under 238
76ers 183 / 51 / 76

pistons hawks

pistons 255 / 16 / 46

celtics clippers

na

nuggets warriors

nuggets 183 / 15 / 51 / 76
over 87

back with rest in a bit

birdsfan · 01-19-15, 04:17 PM

dal mem

mavs 235
under 205 / 146
over 75

nola nyk

under 204 / 151
nola 47

ind hou

over 108 / 95
ind 11 / 4

bulls cavs

bulls 241 / 33 / 16
cavs 176
under 103

tor milw

milw 152
tor 13

lakers suns

la 241 / 210
under 220
over 87

Cutler'sThumb · 01-20-15, 09:43 AM

Thanks for posting birdsfan! This is really the best way to show all the active trends on a given day. Very clear and easy to see what's going on. Some version of this is a must for anyone wanting to use the trends in a systematic way.

nash13 · 01-20-15, 01:09 PM

I brought the tool and can look up multiple trends at once.
Here are the plays for NBA tonight.
Spurs@Nuggets
Play Spurs (4 Trends)
40,52,120,177
Under
8,128,146,187

Thunder@Heat
Play Thunder:
107,136,167,177
Play Heat:
63

dmitean · 01-20-15, 02:14 PM

74 query also supports the Thunder.

nash13 · 01-20-15, 02:33 PM

Originally posted by dmitean

74 query also supports the Thunder.

i will report the bug

willydk · 01-20-15, 06:49 PM

Gl guys

Cutler'sThumb · 01-20-15, 07:11 PM

I'm noticing that #63 is a ST trend according to rating standards from earlier this season. Who knows on an individual play, but this seems like a good example of when judging a trends strength is relevant.

dmitean · 01-21-15, 03:35 AM

I don't see any reason why ST trend is weaker than LT trend, for short term...

If there is a trend that works this season, that's all I care about. If trend was great for 10 years, but doesn't work this season, I won't use it.
I always check many things, but 2 main ones - how the trend is doing this season and how it does in the current month overall (previous seasons as well of course - but current month).
There are trends that are great, but in one month, for some reason just don't work. Don't forget that each month in the NBA is different. Fatigue wise, importance wise, rest wise.
Each month stands for something else, though December and January are similar imo more or less.

pip2 · 01-21-15, 11:49 AM

Originally posted by dmitean

I don't see any reason why ST trend is weaker than LT trend, for short term...

If there is a trend that works this season, that's all I care about. If trend was great for 10 years, but doesn't work this season, I won't use it.
I always check many things, but 2 main ones - how the trend is doing this season and how it does in the current month overall (previous seasons as well of course - but current month).
There are trends that are great, but in one month, for some reason just don't work. Don't forget that each month in the NBA is different. Fatigue wise, importance wise, rest wise.
Each month stands for something else, though December and January are similar imo more or less.

I think you are right, except maybe "month" is just our best working approximation of clumps of time where teams have slightly different outlooks on b-ball and b-ball in relation to their lives in general. The kinds of markers the team personnel might be paying attention to might be Xmas, Thanksgiving, all-star break, and playoffs, maybe, more than months...