Tracking NBA playoff odds

JenniferMurphy

Well-known Member
Joined
Jul 23, 2011
Messages
2,691
Office Version
  1. 365
Platform
  1. Windows
I want to track the Vegas odds for the NBA playoff teams for the last few games of the season and through the playoffs. I have created a worksheet with tables like this.

[TABLE="class: grid, width: 330"]
<tbody>[TR]
[TD="align: center"]R/C[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Team[/TD]
[TD="align: center"]Odds[/TD]
[TD="align: center"]Prob[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Golden State Warriors[/TD]
[TD="align: center"]6/5[/TD]
[TD="align: right"]45.45%[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Houston Rockets[/TD]
[TD="align: center"]8/5[/TD]
[TD="align: right"]38.46%[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Cleveland Cavaliers[/TD]
[TD="align: center"]15/2[/TD]
[TD="align: right"]11.76%[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Toronto Raptors[/TD]
[TD="align: center"]10/1[/TD]
[TD="align: right"]9.09%[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]Philadelphia 76ers[/TD]
[TD="align: center"]25/1[/TD]
[TD="align: right"]3.85%[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]Oklahoma City Thunder[/TD]
[TD="align: center"]50/1[/TD]
[TD="align: right"]1.96%[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]Portland Blazers[/TD]
[TD="align: center"]50/1[/TD]
[TD="align: right"]1.96%[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]Boston Celtics[/TD]
[TD="align: center"]55/1[/TD]
[TD="align: right"]1.79%[/TD]
[/TR]
</tbody>[/TABLE]

This is the data for today. Tomorrow, when they update the odds after today's games, I want to add two new columns with those odds. The problem is that they sort it by the odds, so if the odds change, the order will be different. How do I add new data and get it pair up with the right teams?

The only solution I could come up with was to sort the table above alphabetically by team, then paste the new data complete with the team names and sort that the same way. Then I can delete the team name column for the new data and resort by the new odds.

Is there a better way?

PS: I have a UDF that will convert the odds between several different formats. If anyone would like it, I can post it.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,224,823
Messages
6,181,173
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top