Yes, they do. Which is why I was able to go back and research this whole concept. I think my next step is going to be to go back into last season. I'll try and get a month done every day and see what the data shows. I'll have to see if sbr odds has lines that go back to last year first though. otherwise there is no point in going back.
-
Comment -
April
30th 1-0
29th 4-0
28th 3-0
27th 0-1
26th none
25th 2-2
24th 2-0
23rd none
22nd 1-2
21st 1-0
20th 2-2
19th 6-2
18th 2-2
17th 5-0
16th 1-1
15th 2-1
14th 1-2
13th 2-2
12th 3-1
11th 3-2
10th 0-5
9th 1-1
8th 4-1
7th 0-2
Will do more when I have timeLast edited by grey area; 05-01-15, 08:25 AM.Comment -
Thank you Optional and whoever else that contributed to working on the excel sheet. Very cool how much you can do on there. I had no idea.Comment -
thank you teecee! I will look into that for sure!Comment -
-
I could not work out the formula to calculate $$ for the 5% + Cold Picks etc boxes.
If someone knows excel well enough to do that bit it would be appreciated.Comment -
very cool optional! thanks again!
also if anyone knows how to calculate the formula for the $ on the different %'s, I would greatly appreciate it!Comment -
it would also be cool to analyze records of favorites and dogs. if someone knows how to do that, it would be greatly appreciated!Comment -
awesome! thank you. i was expecting the favorites to lose money. interesting to see its generated a little profitComment -
I have been fading the streak for cash favorites from time to time for a while now but decided to run the the numbers from last year after coming across this thread. I am through July 6th of last year, just past the mid way point and the numbers do not look very good.
2014 MLB Season thru July 6th
Looking at all picks between 0-25% on ESPN Streak For Cash
Overall Record: 254-311
Overall Profit: -$2165
0-5.9% (Profit based on $100 bet per pick): +$1726
6.0-15.9% (Profit based on $100 bet per pick): -$1031
16.0%-25% (Profit based on $100 bet per pick): -$2860
I did rush through this quickly so numbers may not be completely accurate but should be very close. I was actually quite surprised to be down over 21 units, however at one point during calculating this it was down close to 40 units so it has been turning around lately. I will finish the season up and let you guys know how it goes. I also was going to do the other major sports once I get a chance.Interesting to see how much better the 0-5.9% did then the others but I still got alot more games to go so we will see if it holds up.Comment -
thanks for taking the time to go back through and do that. interesting to know it didn't generate any profit. Guess i'll have to be cautious. It's dropped below 0 profit twice this year, once at the beginning and once again about halfway through the picks. so we'll definitely have to be cautious. it's good to know that the 0-5% plays are generating profit though. that may be our bread and butterComment -
No problem. I would like to spend more time analyzing favorites and underdogs as well and also go back to the previous years also. It seems to me that just a lot fewer underdogs won last year.Comment -
how were you able to get back into the 2014 streak picks? other than clicking day to day lol
I'd like to go back and enter these into excel and see what it showsComment -
use this as your url and just adjust the last code "20140708"
This represents the date you want to see, in this case July 8th, 2014Comment -
awesome, thanks. is that where you began?Comment -
No, I started on 3/31/2014 the first day of the regular season. That is where I currently am at.Comment -
ah okay, idk what i was thinking..lol I am going to start at the beginning of the 2014 season and enter that data in first.Comment -
I did some calculation to fill the missing cells. So now you can check some additional criteria for picks.Comment -
Adding TwinsComment -
Could you do that on the 2014 excel sheet as well!? That'd be awesome!
Also if anyone would be interested in adding some more of the data to the 2014 MLB Season, that would be awesome. I didn't get all of April finished. Have a few more days left. My eyes are just killing me and i need to take a break. I'll get back to it tomorrow though.
Any help would be awesome though.
Thanks everyone. Have a good night!
Go Twins!Comment -
Done.
Comment -
If you get a couple of back seasons data Poirot, myself or someone else might be inspired to create a page to allow you to make whatif queries on the data and able to set/change your percentage numbers and odds you are interested in looking at etc.
Could do a breakdown of how it works each week/month of the season. Maybe a by team breakdown too..Comment -
Must of been still not quite awake missed the Rays and Astros not being listedComment -
I just finished up May 2014. If someone wants to start on June, that would be awesome. I'm gonna take a break though. If not, I'l get back to it a little later.Comment -
4/30
4% Phillies +220
7% Twins +137
4/30: 1-1 (+$37)
Season: 87-79 (+$1847)
Comment -
5/1
2% Brewers +170
3% Rangers +135
2% Diamondbacks +135
8% Pirates +132
14% Indians -138
14% Nationals +103
24% Braves +112
17% Rockies +129
5/1: 2-6 (-$388)
Season: 89-85 (+$1459)
Last edited by McCarthyFam; 05-02-15, 07:33 AM.Comment -
I will contribute when I get the chance. Which site are you getting your odds from?Comment -
you could start the 2013 season on excel if you'd like. I'm gonna grind out July real quickComment
