Capping & Betting #101 - The Straight Scoop!

Sunday March 15th:

morning all, this will be my year long thread and will also include any CBB or NBA games and any other money making opportunities that might come our way

The objective of this thread is as follows:

My first post of the day will include have the date and day in the title, so that you will only need to go back a few posts to see anything new for the day

Any Rx members are welcome to post info in this thread on any subject. Feel free to ask any questions you might have regarding capping MLB, or any other sport as well. If I don’t know the answer, I’ll sure find someone that does. I’ve lived in Vegas for many years, and still have some great contacts and information sources, so feel free to ask any questions. only dumb question are one's you dont ask.

THIS IS YOUR THREAD. SAME AS WITH LIFE, YOU GET OUT WHAT YOU PUT IN!!!

This is NOT a “I give out my picks thread”. You have a enough dumb fucks already doing that, so follow or FADE one of them. Here we will be collecting key data that will be used to make betting decisions.

Last year I created a excel spreadsheet that has no equal when it comes to data and analysis. This is the basis for all the analysis i do b4 i make any decisions etc. The the complete program and file from last year is 2460 rows and 95 col of individual game data plus around 100 key pivot tables for the analysis of this information. I'll post the complete spreadsheet with all macro's in the next posts. It's almost 25 MB. If you dont have Excel (Using 2007 Version) or dont know how to use it, dont waste your time and bandwidth d/l it as it will be an anchor taking up space on your hard drive. This file will stay on the Rx thru the end of April and my daily files will stay on site for D/L about 7 days. I only use the daily to update my YTD data base. I will NOT update any 2009 data bases or pivot tables. It will be up to anyone that wants data to take my daily data and add it to there own data base in whatever format they want.

I'm not a programmer, but i do know how to use Excel and it's features to make it easy to collect data and information. The key to being successful if to gather info as fast and easy as possible. You can only make money the old fashion way. Working for it, no free lunches when it comes to betting any sport.

Contributions come in many sizes and forms. Quality posts and information posted in the thread is #1. From prividing key links were the everyone can get information and data eg. The key players spent the night in the drunk tank etc

In previous years i had people helping to collect data and information, but right now my programs have evolved to the point where it takes less than 2 mins to gather all the data and information i need to start my daily analysis. There might be times when key opportunities come up where some special effort is required, but i dont see the need for this at this time.

Rx said that i'll have 35 MB of available space for daily download of spreadsheets and data so let give it a try. the 2nd post in this thread will be the MLB 2008 master files (hope the upload works). so if you think you know how to use excel have at. i know there will be a bunch of things on it you dont understand etc, so let the questions began. almost 15 days to understand the basics etc so fire away

tks and glta

p.s. dont look for great grammer or correct spelling etc. as i tend to fat finger or type faster than i can think as well as drink and drive etc

MLB 2008 Master Data Base in the line below

p.s hope this works. file is 25mb

enjoy

file would not upload. working with rx now to resolve the problem. will upload as soon as i know the fix

Isn't today Saturday, March 14? >

Jetplane said:

Isn't today Saturday, March 14? >

Click to expand...

it's sunday morning where i'm at

Thanks Pops, looking forward to working with you this year!

FYI - Rx trying to resolve tech prob associated with upload files. just tried again and no cigar. i'll try to upload a small file (nothing important will be there so dont bother to d/l

also i'll try to post GMT -5 as my date so everyone does not get confused as my times and locations will be much diff that most viewing

small excel file for test. just ref 2007 tourny locations

Pops,
can you give a thumbnail sketch of what you are actually trying to do, is it a collective thing? if so who makes one post better than the other. I'm all for collective thinking but it tends to need an overseer to sift between views and make a definite play, otherwise it gets very murky.

As for questions, which WHIP would you consider best, the starter or the bullpen? I would assume that in this ERA the more People whipping, the better the reward!!! As long as one isnt asked to put balls on base with a home plater umpire under a 1st base looking for a LICK. :drink:

while were waiting for a fix to the large file d/l i've attached an example of what the daily mlb schedule data will look like. there will be one line for every game played with all the pre game info avail. the items in the cols a - ah in light blue at the top are the schedule data including starting pitchers stats along with opening ML and O/U numbers. nothing will be in the pink col AA and AE, nor any of the final game data in col AK thru AW in the light Tan cols. the yellow AX-AZ are calc data off of the home and away data and will be included as will the other light blue BC thru BJ

this should be straight forward with the exceptions of the data in col BG, BH and BJ which i use for bracked data analysis. feel free to d/l and take a look and question or comment

win: no collective with respect to betting etc. i'm just providing a vehicle all loaded up with the initial data for every game as a basic starting point for individual analysis etc

although i do provide whip data, with respect to what and how i'm using the data era for home and away along with pig pen data is more important to me. whip come more into play for my analysis for o/u along with umpire data as well

once i'm able to upload the spreadsheet it will clear up some of the questions and raise more

gl

looks like we have a solution. i've compressed the file with pkzip so it's a winraw file that you will need to uncompress to start using. it's free shareware

but i hate the extra step, although it will speed up the file up and d/l. so the 2008 MLB spreadsheet is below. d/l and have at it

glta

fuck it didnt attach. back to square one

test

test attach 1

sstech said:

test attach 1

Click to expand...

i just tried and and it failed. i saw that you had added the .rar extention to the list of formats. prob cause it was b4 you were finished

ok guys. this is the master MLB from last year. you need to uncompress and have at. let me know if you have any question etc

looks like were in business. love it when a plan comes together

p.s. if anyone has problems d/l file please post here

tks for help sst

Thanks for the data. Does anyone have any good websites that help explain the use of excel spreadsheets with handicapping? I have been reading up over the past year, but excel is still fairly foreign to me at this point. I've been wanting to read up on it to help me organize me info much better and to see how others use excel to manage there data. Thanks for any help.

Zeeto

This may be of some help.

How to Use Excel - Excel Tutorials for Beginners.



Best of luck, wilheim

zee: 1st step is to start using the program. just think of it as a large box of 300,000 drawers (about the size of the file i posted) that you can open if a fraction of a second and find any piece of info your looking for and format it any way you want in the same amount of time

right now your kind of swiming up stream. you need to walk b4 you can run

ton of books out there. i'm prob only using 1% of it's capabilities and trying to keep it as simple as possible

gl

pops - do you think it would more efficient if you had an online storage site to upload to (i.e. box.net is pretty popular and they offer 1gb storage for free i think) - it would be just one link and people could click on it to access anything you've uploaded

zeeto said:

Thanks for the data. Does anyone have any good websites that help explain the use of excel spreadsheets with handicapping? I have been reading up over the past year, but excel is still fairly foreign to me at this point. I've been wanting to read up on it to help me organize me info much better and to see how others use excel to manage there data. Thanks for any help.

Click to expand...

prob more important than using excel it to:

1. determine what you are going to bet on
2. what type of information is it that you will need to make a better decision on making that wager
3. finding the best sources for getting that information
4. collecting it as fast and accurate as possible
5. organizing it into a usable format
6. analyisis of that information
7. make your decision etc

years ago i spent 99% of my time finding and collecting data and information, and less than 1% of the time with analysis. had it all ass backwards. now i spend less than 5% of the time collecting and 95% analysis

no program is going to give you who will win etc. you just want to be able to bracket your info into buckets that give you the highest probability of the outcome your looking for

every event has a random outcome. any pitcher with a 20.00 era can pitch a no hitter, or a batter with an .083 avg hit a grand slam in the bottom of the 9th. shit happens all the time in every event. no such thing as a goy or can lose bet, but there are situations where you will have a higher probability of getting the results your looking for..

gl

Vince_Carter said:

pops - do you think it would more efficient if you had an online storage site to upload to (i.e. box.net is pretty popular and they offer 1gb storage for free i think) - it would be just one link and people could click on it to access anything you've uploaded

Click to expand...

vince: that's what we have here. one click and you have the file and data. plus you have a spot available to ask questions and exchange info. the other leads to email email and mo email.. i dont answer emails as i want everyone to get the same info vs one or two or answer the same question 1000 time

Hi Pops, its great to see you back.

Its funny how most of the posters still around are the ones who were active in your threads. Lots of others are broke and long gone. To me, that shows what a thread like this can do. You might not make a living doing it, but you can scratch out a profit.

Did you do well with fading National League totals last year? Anything that moved 1/2 a run, I was on and had a great MLB season.

Looking forward to the season.