[rake922]

In the NBA, Totals of 183 and lower; how often do they go over?

[Arnold]

OU: 1307-1258 in regular season.
OU: 171-181 in playoffs.

[durito]

I have 1668-1597 O/U since 1990

[Arnold]

My data is since 96-97 season.

[rake922]

I appreciate this guys.... It always seemed to me that totals 183 or lower usually go under.....

thanks for setting me straight and showing me it's almost a coin toss

[Arnold]

Originally Posted by rake922

I appreciate this guys.... It always seemed to me that totals 183 or lower usually go under.....

thanks for setting me straight and showing me it's almost a coin toss

Yeah, that's the thing is when you look at a small sample, or even worse - track it by memory, without documented records. The only way to know is to look at long term records.

[T40]

Can you guys tell me where I could look up stats like those O/U's that you just noted? Thanks

[Arnold]

It's my personal database. I don't know if something like that is available online.

[rake922]

Originally Posted by Arnold

It's my personal database. I don't know if something like that is available online.

how much time do you spend on that? weekly and or daily

[ktorp18]

Originally Posted by Arnold

It's my personal database. I don't know if something like that is available online.

would you be willing to post it up on google docs?

[Arnold]

Originally Posted by rake922

how much time do you spend on that? weekly and or daily

No time now. It's all setup and stats are updated automatically (daily). It did take time to collect the data and organize it. You need to know how to program in order to do this. It's not done by hand.

[Arnold]

Originally Posted by ktorp18

would you be willing to post it up on google docs?

I don't think it will be possible.

[ktorp18]

Originally Posted by Arnold

I don't think it will be possible.

Would you be willing to share your files?

[Ganchrow]

You can harvest all this data from (among other sources) Covers and DonBest Real-Tiem Odds service.

You'll just need to write an HTML scraper if you want to automate the process.

[LT Profits]

Rake,

Don't you have WinPicks? If so, you could have gotten that info yourself.

[LT Profits]

I get 1696-1633-63.

[rake922]

yes but I don't know how to get the answer to what I asked using that

[LT Profits]

Under File, do an Export Games.

That will dump all games since 1990 to an Excel file. Then add three columns to the right (should be columns I, J, K) and label then Over, Under, Push. In first cell under Over, put in formula IF(H2+G2>F2,1,0). (I am assuming your file looks like mine, where H is home score, G is away score and F is game total). Then copy that formula accross under Under and Push, substituting "<" in the Under column and "=" in the push column, and then copy all three formulas down to the last game.

Then on the bottom of the three columns, put in SUBTOTAL formulas (NOT SUM. You wll see why later). Then put cursor in A1 and put in Auto Filter. Finally, in Over/Under column, filter on less than or equal to 183. By doing this, the SUBTOTAL adjusts itself, whereas if you had used SUM, it would have kept a constant sum of the whole sheet.

[Arnold]

Originally Posted by ktorp18

Would you be willing to share your files?

This is not something one would share, since it is work. Try WinPicks, as LT suggested.

[rake922]

ok

I got 27 overs and 36 unders for the 2007/2008 regular season and postseason. many of those games involved spurs or heat

I used a game total of 183 or lower