New nba power rating system

[Formulawiz]

Todays NBA-PR Chart

NBA PR Chart

[diogee]

Interesting stuff Formulawiz. Always good to add a little something extra to the capping...thanks for posting.

[Formulawiz]

Updated NBA _PR System Spreadsheet

Download the updated NBA PR system spreadsheet ver. 7. Its been updated to include yesterday's closing lines and scores. I have been following the picks and they seem to be working correctly. Make sure you enter the lines prior to looking at the picks. The lines influence the picks. Make certain you manually compare your picks with the spreadsheets picks and if you find any error, let me know immediately.

The spreadsheet still works the same way. For instructions go to one of my earlier posts.

NBA picks will be up later.

[Ditaln1]

Thanks FW!

[Formulawiz]

Todays NBA Plays

Todays NBA Plays based on early lines

DEN - 4.5 or <
CHI + 4.5 or >
MIN + 8 or >

Good Luck

[Bookman]

Thanks Wiz.

I agree, last night was a tough one to navigate using your system. Both Orlando and GS dropped out by my count, but they were both borderline right up to game-time. Also, the Denver game looked good even though they were a no-play here, again illustrating your point that using other resources is critical in developing the right 'touch' when choosing plays.

[Achilles15]

Todays NBA Plays based on early lines

DEN - 4.5 or <
CHI + 4.5 or >
MIN + 8 or >

Good Luck

these plays are not very good , day after day i come here and they lose, denver only had to lay -2, and it wasnt even close, so this system is not very productive

[gameday10]

these plays are not very good , day after day i come here and they lose, denver only had to lay -2, and it wasnt even close, so this system is not very productive

lol, wow...no mention of football jesus in your post. Shocked.

[MJAZER]

Download the updated NBA PR system spreadsheet ver. 7. Its been updated to include yesterday's closing lines and scores. I have been following the picks and they seem to be working correctly. Make sure you enter the lines prior to looking at the picks. The lines influence the picks. Make certain you manually compare your picks with the spreadsheets picks and if you find any error, let me know immediately.

The spreadsheet still works the same way. For instructions go to one of my earlier posts.

NBA picks will be up later.

Is it only me??

When I press through the Macro tabs to get

Get-Power –Averages and press Run

I get

Run-time error 91
Object variable or with block variable not set


Then


Public Function get_stats_game_range(yesterdayDate As Date) As Range
Dim dateRange As Range
Dim statsSheet As Worksheet
Set statsSheet = Sheets("Stats")
Set dateRange = statsSheet.Range("A1", "A1231")
Dim dateString As String
Dim rFound As Range
dateString = Format(yesterdayDate, "dd-mmm-yy")
Set rFound = dateRange.Find(dateString, After:=dateRange.Cells(1, 1), LookIn:=xlValues)
Dim startRow As Integer
startRow = rFound.row
Dim currRow As Integer
currRow = startRow
Dim sameDay As Boolean
sameDay = True
Dim currDate As Date
Dim value As Date
While sameDay = True
currDate = statsSheet.Range("A" & CStr(currRow + 1)).value

If currDate < yesterdayDate Then
sameDay = False
End If

If sameDay = True Then
currRow = currRow + 1
End If
Wend
Dim game_range As Range
Set game_range = statsSheet.Range("A" & CStr(startRow), "K" & CStr(currRow))
Set get_stats_game_range = game_range
End Function

[Formulawiz]

Is it only me??

When I press through the Macro tabs to get

Get-Power –Averages and press Run

I get

Run-time error 91
Object variable or with block variable not set


Then


Public Function get_stats_game_range(yesterdayDate As Date) As Range
Dim dateRange As Range
Dim statsSheet As Worksheet
Set statsSheet = Sheets("Stats")
Set dateRange = statsSheet.Range("A1", "A1231")
Dim dateString As String
Dim rFound As Range
dateString = Format(yesterdayDate, "dd-mmm-yy")
Set rFound = dateRange.Find(dateString, After:=dateRange.Cells(1, 1), LookIn:=xlValues)
Dim startRow As Integer
startRow = rFound.row
Dim currRow As Integer
currRow = startRow
Dim sameDay As Boolean
sameDay = True
Dim currDate As Date
Dim value As Date
While sameDay = True
currDate = statsSheet.Range("A" & CStr(currRow + 1)).value

If currDate < yesterdayDate Then
sameDay = False
End If

If sameDay = True Then
currRow = currRow + 1
End If
Wend
Dim game_range As Range
Set game_range = statsSheet.Range("A" & CStr(startRow), "K" & CStr(currRow))
Set get_stats_game_range = game_range
End Function

This looks like way beyond me. When you go to the macros your only suppose to use update scores. Secondly I think your getting this error because possibly you dont have enough games when updating. Maybe one of the gurus can explain this.

[Formulawiz]

Yesterdays plays

Yesterday we went 1-3

YTD 51-34 = 60%

Since I have been keeping win/loss records I have noticed we have lost quite a few games due to the fact the overlay of 2 may be too close to the line. I think if we raise our overlay in the pro's to at least 3 instead of 2 this may improve our wins.
Luckily the college system is saving my ass again yesterday, I went 5-3.
Any thoughts out there

[peterpan19]

formulawiz,

well I dont know if we raise it to 3 (I already raised it to 2.5), what I have is that games under 3 went 10-4 (since I keep record of the score) and games under 4 are 22-13 and games over 4 are 21-23, I mean thats at least what I have

[Formulawiz]

formulawiz,

well I dont know if we raise it to 3 (I already raised it to 2.5), what I have is that games under 3 went 10-4 (since I keep record of the score) and games under 4 are 22-13 and games over 4 are 21-23, I mean thats at least what I have

Peterpan, I am talking about the overlay which is the difference between the line and the PR which is set at 2.5 or > which is the way we have it now. So therfore I am suggesting we go to 3.5 or >. I am not sure what you are referring to. Can you explain yourself a little better.

[Formulawiz]

Todays NBA PR chart and plays

Since everyone should have the new PR spreadsheet, this will be the last day I will post the NBA PR chart.

I will continue to put the plays up.

Based on early lines today we have
NYK + 8.5 or >
CHA + 4.5 or >
SAC + 4.5 or > good luck with this team
UTA -3 or <

[peterpan19]

Peterpan, I am talking about the overlay which is the difference between the line and the PR which is set at 2.5 or > which is the way we have it now. So therfore I am suggesting we go to 3.5 or >. I am not sure what you are referring to. Can you explain yourself a little better.

well I was talking about the Line Value, if it is under 4 and above 2.5 the record I got was 22-13 and above 4 it was only 21-23, at least for the games I followed, so dont know what you have ? or if I just did it wrong ?

[MJAZER]

This looks like way beyond me. When you go to the macros your only suppose to use update scores. Secondly I think your getting this error because possibly you dont have enough games when updating. Maybe one of the gurus can explain this.

Formulawiz, the same happens when i try to update scores??

Formulawiz, would you please mind posting the PRs for the next few days OR someone else just so the figs i have (or anyone else with this issue) can cross reference?

When i open the xl doc it says

Enable automatic refresh so i press this

and hope it is refreshing the PR values fingers crossed but i will not know if they are not on the forum so could you please help us out?

Many thanks

[Formulawiz]

Formulawiz, the same happens when i try to update scores??

Formulawiz, would you please mind posting the PRs for the next few days OR someone else just so the figs i have (or anyone else with this issue) can cross reference?

When i open the xl doc it says

Enable automatic refresh so i press this

and hope it is refreshing the PR values fingers crossed but i will not know if they are not on the forum so could you please help us out?

Many thanks

NO problem

[NBA Hero]

on utah to win another on the road

[Formulawiz]

well I was talking about the Line Value, if it is under 4 and above 2.5 the record I got was 22-13 and above 4 it was only 21-23, at least for the games I followed, so dont know what you have ? or if I just did it wrong ?

Are you referring to the pros or college. I know the college is really lighting it up this year.

[Cranium]

Anything to tighten up the system is great Wiz. Any idea how going to 3 would change the overall record?
Thanks for posting Wiz!
Cranium

[Formulawiz]

Anything to tighten up the system is great Wiz. Any idea how going to 3 would change the overall record?
Thanks for posting Wiz!
Cranium

I believe some of our losses were right at the 2.5 point overlay. By going to 3.5 we may bypass more losses then wins and of course a few less games. Again this is just for the pros. College is doing just fine.

[peterpan19]

formulawiz
pros it is, never really got on the train with the college games, would be nice if you could post the plays here too

[Ditaln1]

Wiz. What's the college record at? I haven't seen any posts with plays..

[Formulawiz]

formulawiz
pros it is, never really got on the train with the college games, would be nice if you could post the plays here too

You might be on to something I missed.
Lets look at todays games
LAK + 5 has a 3 pt overlay
CHA + 8 has 6 pt
SAC +7 has 5 pt
UTA -1.5 has 4
NO -3 has 3
So 3 out of 5 games fall into your 2.5 to 4 category and 2 games fall > 4 Correct.
Where is 4 counted in your win/loss record

[peterpan19]

well i got 5 games for today: Char, Sac, Lak, NO -3 and Utah
Lak and NO between 2.5 and 4
and Char, Sac and Utah over 4
edit:
to decide were I put 4 I look into the original sheet to make my decision, so utah would be above 4 in that one
dont know if it works out, but I think we give it a shot

[PerfecTrader]

these plays are not very good , day after day i come here and they lose, denver only had to lay -2, and it wasnt even close, so this system is not very productive

Day after day? You have been a member here for 14 days. What the fvck is it with people like you? Find another forum or stfu about other peoples picks. Why don't you pick some games on your own so you won't have anyone else to blame? There's a novel idea or does it just make more sense to play the follower and bark when things don't go your way?

[Formulawiz]

Wiz. What's the college record at? I haven't seen any posts with plays..

I am not keeping any records and I dont post plays. Its just too time consuming. Just go to sportrends and get the power ratings off their website.
Ex: today it started off with one game, Richmond -5.5 or < and that game went to -6 so I wound up with no plays.

[gameday10]

well i got 5 games for today: Char, Sac, Lak, NO -3 and Utah
Lak and NO between 2.5 and 4
and Char, Sac and Utah over 4
edit:
to decide were I put 4 I look into the original sheet to make my decision, so utah would be above 4 in that one
dont know if it works out, but I think we give it a shot

I don't quite understand your reasoning behind utah not being between 2.5-4. I have it at 4. Could you explain.

[jholl]

Day after day? You have been a member here for 14 days. What the fvck is it with people like you? Find another forum or stfu about other peoples picks. Why don't you pick some games on your own so you won't have anyone else to blame? There's a novel idea or does it just make more sense to play the follower and bark when things don't go your way?

well i have been a member for awhile, this guy doesnt have to post picks, he didnt make the claim that his system worked, the burden is on the system to prove itself, without exceptions , so far it seems to be 50-60 % , as good as most pros out there.

check the record tonite of todays "plays " you will see.

Based on early lines today we have
NYK + 8.5 or >
CHA + 4.5 or >
SAC + 4.5 or > good luck with this team
UTA -3 or <

[Formulawiz]

well i have been a member for awhile, this guy doesnt have to post picks, he didnt make the claim that his system worked, the burden is on the system to prove itself, without exceptions , so far it seems to be 50-60 % , as good as most pros out there.

check the record tonite of todays "plays " you will see.

Based on early lines today we have
NYK + 8.5 or >
CHA + 4.5 or >
SAC + 4.5 or > good luck with this team
UTA -3 or <

Lets keep this thread civil. No one is forcing anyone to follow our PR system. Its up to you. Instead of those individuals who continually bash and complain about our system, I ask you wouldnt it be better if you had something of value to add. Obviously, there is no system, trend, situation or whatever that will continually win. Its funny I follow another thread on our forum called the 70% system with over 250,000 hits. This 70% system is an old system called the Christmas system and if used properly has a record of 19-16, thats 54%. I dont see people in that thread going nuts over a 54% win/loss record. Everyone seems to be civil and trying to help each other. Our system is at 60% and hopefully it will improve. If it does not so be it, we tried. So lets all calm down and hope for the best.

[BoomerOK95]

Lets keep this thread civil. No one is forcing anyone to follow our PR system. Its up to you. Instead of those individuals who continually bash and complain about our system, I ask you wouldnt it be better if you had something of value to add. ...... Everyone seems to be civil and trying to help each other. Our system is at 60% and hopefully it will improve. If it does not so be it, we tried. So lets all calm down and hope for the best.

yes please keep posting em , im finding them VERY helpful

[MexicanStallion]

Lets keep this thread civil. No one is forcing anyone to follow our PR system. Its up to you. Instead of those individuals who continually bash and complain about our system, I ask you wouldnt it be better if you had something of value to add. Obviously, there is no system, trend, situation or whatever that will continually win. Its funny I follow another thread on our forum called the 70% system with over 250,000 hits. This 70% system is an old system called the Christmas system and if used properly has a record of 19-16, thats 54%. I dont see people in that thread going nuts over a 54% win/loss record. Everyone seems to be civil and trying to help each other. Our system is at 60% and hopefully it will improve. If it does not so be it, we tried. So lets all calm down and hope for the best.

That system is actually 16-3. There is another standings listed testing it out to see how it works without the filters such as letting games count with injuries and back to back games. The original formula though with filters is 16-3 on the year

[Formulawiz]

That system is actually 16-3. There is another standings listed testing it out to see how it works without the filters such as letting games count with injuries and back to back games. The original formula though with filters is 16-3 on the year

Tex, I know the system real well it was developed by sportrends many years ago and originally called the Christmas system. It is being followed by several sports forums throughout the internet. I have been using it for years and with yesterdays 2 wins it is now 21-16, if followed the way the rules were originally outlined. I am in no way knocking your system and there is nothing wrong with making changes to improve it by using different parameters as your are. Thats what these forums are all about, to help each other win. So based on your new system I dont doubt the win/loss record is 16-3.

[Formulawiz]

Todays NBA-PR Chart and yesterdays record

Yesterday record was 4-1
YTD 55-35 = 61.1%

Todays Plays will be up later

Todays NBA PR Chart

[MexicanStallion]

I have no idea, how it is going. I pop inot it and see how it goes. At least your system is going strong