Posted:
#1
I want to get MLB moneyline and totals data for a couple different books from the past two seasons. Can anyone point me in the right direction to acquire that kind of archived data...
Need MLB Historical Odds Data
...
Views: 20744
Posts: 17
Posted:
#5
All Sports Game / ATS past results from Covers
Here are 4 excel spreadsheet that will allow you to import NBA, NHL, MLB, NHL Game / ATS results from Covers. All you have to do is select the SEASON you want to import from the dropdown and click the "IMPORT" button. The game logs for all the teams will be downloaded to the Covers Data tab.
if you want you can clear the blue cells in the Covers Data tab and start over or add to it. Anytime you import a season it is pasted below the last row.
You can download from the link below:
https://docs.google.com/file/d/0B5dydT9Oe6JbU1BVMlJqVXA0VkU/edit?usp=sharing
Posted:
#6
Wow - that's a wealth of information. Thanks.
I want to sort the information according to the MoneyLine, but the ML data is all alpha numeric with either a W or a L in front of the numeral.
ie: W -160
I would like to separate them into 2 columns.
1 column would be W/L and the other would be the numerical ML.
ie: W -160
Does someone know how to do that? Can they help me?
Posted:
#8
NEVERMIND - I figured it out. My system has been successfully debunked using the data :(
Quote Originally Posted by ronatola:
Wow - that's a wealth of information. Thanks.
I want to sort the information according to the MoneyLine, but the ML data is all alpha numeric with either a W or a L in front of the numeral.
ie: W -160
I would like to separate them into 2 columns.
1 column would be W/L and the other would be the numerical ML.
ie: W -160
Does someone know how to do that? Can they help me?
Posted:
#9
Quote Originally Posted by ronatola:
Wow - that's a wealth of information. Thanks.
I want to sort the information according to the MoneyLine, but the ML data is all alpha numeric with either a W or a L in front of the numeral.
ie: W -160
I would like to separate them into 2 columns.
1 column would be W/L and the other would be the numerical ML.
ie: W -160
Does someone know how to do that? Can they help me?
try using the left or right trim.
https://office.microsoft.com/en-ca/excel-help/remove-characters-from-text-HP010062742.aspx
Posted:
#10
Quote Originally Posted by Bart_:
try using the left or right trim.
https://office.microsoft.com/en-ca/excel-help/remove-characters-from-text-HP010062742.aspx
Here's how I did it (got help from another forum)
Say, you have your Data in Column A beginning from Row 2.
Say in A2 you have W -160
and in A3 you have L 136
In B2 write this.
=LEFT(A2,1)
You will extract the Alphabet W in B2.
Copy B2 and paste it in B3.
You will extract the Alphabet L in B3.
In C2 write this.
=TRIM(MID(A2,2,LEN(A2)-1))
You will extract -160 in C2.
Copy C2 and paste it in C3.
You will extract 136 in C3.
If you have the formula directly in the sheet, in case if you change the data in column A, then your results in Column B & C will change.
As an Alternative, you can copy the results in Col B & C and using Paste Special you can paste only the result excluding the formula in Col D & E.
Posted:
#14
Quote Originally Posted by DegenGamble:
All Sports Game / ATS past results from Covers
Here are 4 excel spreadsheet that will allow you to import NBA, NHL, MLB, NHL Game / ATS results from Covers. All you have to do is select the SEASON you want to import from the dropdown and click the "IMPORT" button. The game logs for all the teams will be downloaded to the Covers Data tab.
if you want you can clear the blue cells in the Covers Data tab and start over or add to it. Anytime you import a season it is pasted below the last row.
You can download from the link below:
https://docs.google.com/file/d/0B5dydT9Oe6JbU1BVMlJqVXA0VkU/edit?usp=sharing
I downloaded the MLB data, but cannot find the run lines data that I need. Any help?
Hot Forum Topics
