MLB DFS - Request

thehazyone  9/14/2017 7:23 AM

I know it's late in the season but would it be possible to add something it to tie the hitters to the starting pitchers?  For instance if I export the hitters to excel and the pitchers to excel, I would like to be able to do vLookups somehow to pull in information from both spreadsheets into one "Main" tab.  I haven't found an easy way to do this without a ton of formulas.

If not for this year, next season would be great!  Thanks for all you do!!!

ken_admin  9/14/2017 7:31 AM

This would be a single export with hitters first and then pitchers next even if the data columns switch between the two? Or are you looking for hitter and pitcher stats for all players regardless of their position.  In other words, all zeros for hitting stats if a pitcher?

thehazyone  9/14/2017 7:37 AM

For instance, I would export the hitters and put them on one tab.  Then export the pitchers and put them on the other tab.  Then I would like to be able to lookup a hitters starting pitcher.  For instance I would like to be able to look up Giancarlo Stantons versus pitcher stats.  I.E. I want to be able to pull over just Jake Thompson's name in the hitter export instead of @PHI (Thompson R) R Ord 2.  I can't use vlookup for other stats I have from fangraphs without doing a bunch of formatting to get his name.  

Actually it would be helpful to have the pitchers full name, batters hand, pitchers hand, batting order spot all in separate columns instead of the way they are.  Because right now I have to run a bunch of formulas to extract that information.

thehazyone  9/14/2017 8:18 AM

Example:

Hitter          Team     Opp     Home/Away          Pitcher                  Bats     PH   BO

Stanton       MIA       PHI        Away                  Jake Thompson     R          R     2

sangamc  9/14/2017 8:41 AM

I use a 3rd tab that can be populated using Fangraphs probable SP leader board or Roto grinders mlb schedule (https://rotogrinders.com/schedules/mlb).

This tab acts as link between my bbm batters and bbm SP tabs. 

You can then pull the SP from the 3rd tab into your Batters sheet using vlookup (or even better use index())

After that it should be easy to pull the SP data you want to see.

I highly reccomend creating and index simillar to this: http://crunchtimebaseball.com/master.csv

This can be pulled automatically into excel or google sheets. I added an extra column with BBM player ID so its even easier to get player info without worrying that one site has Ben Lively as the SP name and another has Edward Lively :)

thehazyone  9/14/2017 12:09 PM

Thanks!  I still think it would help to have that field separated into separate fields.  But that is my opinion.  Maybe in the excel export?

sangamc  9/15/2017 10:37 AM

it would help eliminate the "3rd Tab" So hopefully its somethng that can be added in the near future

ken_admin  9/15/2017 10:51 AM

I can add an optional set of columns that would be available in the Excel export (and on the page).  Are these it:

• Pitcher Full Name
• Batter Bats
• Pitcher Throws
• Batting Order

thehazyone  9/18/2017 5:14 AM

Yes, that would be helpful.  Thanks!