Monday, April 14, 2014

Starting to Sort Things Out

Finally, I have the sortable stats up and running at RotoGuru.com. While the generally layout and functionality is similar to that of recent seasons, there are some new features this year that should be of particular value in supporting daily contest lineup decisions.

Here's a quick rundown on the current capabilities:

  • The six affiliated contest sites (Fanduel, DraftStreet, StarStreet, FanTrowdown, DraftKings, and DraftDay) are incorporated, including point histories and salaries.
  • Points are totaled (and averaged) over four different periods: YTD, 30-day, 15-day, or 7-days. Pick your favorite period(s), or switch back and forth.
  • You can see the salary changes for the past day, past week, or YTD. This may be a useful screen to see which players are trending. You can also see (via color coding) if a player's current salary is his max or min for the season.
  • You now have the option to view points for all games, or just points for games in which a player started. The latter option conveniently allows you to screen out data for games in which a player did not start.
  • The schedule filter allows you to see only players for teams scheduled to play on a given day.
  • You can select to see only scheduled starting pitchers. You can also select to see only hitters who are facing an "opposite handed" starter. In each case, if you hover your mouse over the player name, the underlying matchup details should appear.
  • Links to each player's detailed game-by-game history are provided, as well as quick links to that player's info page at ether RotoWorld or RotoWire.
  • You can sort the table on any linked column.
  • You can show all players, of just those who are currently on an active 25-man roster. Active players reflect reporting at MLB.com, and are updated hourly.
  • You can filter out players with salaries above a specified threshold.
Hopefully, the selection options are relatively intuitive. Contest salaries should be updated for the new day at 11pm ET each night, and point data should be updated at 4:15am ET.

Since the updates are now set up to run automatically, there is always a chance that some data will be screwed up if the various data feeds fail. I'll do my best to make sure that all data is getting populated on schedule, but if you notice anything that looks goofy, please let me know via email. Your eyes are my best spot-checking tool. Don't assume that I'm already aware of any apparent glitch.

With this "basic" version of the sortable stats now up and automated, I hope to add some additional filtering capabilities - particularly regarding lefty/righty matchup histories. Not sure how soon that will be incorporated, though.

Thursday, April 10, 2014

In search of a few good correspondents

The focus at DBD is to assemble and consolidate statistics in a way that facilitates decision-making for setting daily baseball lineups, particularly for daily contests where you have complete flexibility from day to day. DBD offers a variety of tools to support that analysis.

As the sole manager of DBD, I feel that my time and efforts are best devoted to managing the data assimilation, looking for alternate formatting options, expanding the range of stats analyzed, and generally keeping things running smoothly.

What has been missing from DBD for some time is a flow of articles, recommendations, and ideas that provide fresh daily narrative content. In order to get this from "wish list" to actual practice, I’m now looking to recruit a few “correspondents” who will provide a variety of fresh perspectives. I would expect each correspondent to provide no more than 1-2 articles per week. Articles could be narrowly focused on a single daily contest format, or generally suited to any lineup-setting decision. They would typically appear in this “blurb” space, and could be rather short (top recommendations for today) or they could be lengthier discussions of strategies or new analytical approaches. They could be duplicates of articles already published on your own site or blog, or completely unique material. Ideally, I’d have one fresh article each day, posted sometime in the morning, from a variety of rotating correspondents.

At this point, I’m not looking to pay cash for these submissions. However, I can offer the opportunity to promote your own web site or blog via links and/or other attributive statements associated with each posted item. Free advertising, so to speak.

If you are interested in pursuing this, please send an email to davehall@rotoguru2.com, and we can begin the discussions. Thanks! - Dave Hall

Wednesday, April 9, 2014

Publishing Periodic Player Points

I’ve made some significant progress in retooling my baseball stats processing at RotoGuru. The stats now cover all six of the affiliated daily contest sites listed above, and are now updated automatically early each morning. While the sortable stats reports are not yet available for 2014, I do have the following pages/reports ready:
  • Daily point recaps - a listing of all player points for each game for each contest scoring system, showing listed position eligibility, salaries, and stat details.
  • Individual player detail pages, with links to related player pages at many other sites, plus a day-by-day history of stats, fantasy points, and salaries.
I'm doing my own independent point calculations based on publicly available stats applied to the published formula for each contest site. Based on some limited spot checking, they appear to conform to the official point calculations at each affiliated site. If there are differences (that aren't related to occasional stat differences), please let me know. It's possible that I've misapplied some factor, or that one of the contest sites has made a formula change of which I'm unaware.

Daily contest salaries and position eligibilities are based on feeds from each of the sites. These seem to be complete and accurate, although occasionally I may be missing a player based on a change in name spelling or some other feed anomaly. If you notice any discrepancies, please let me know via email. Do not assume that I am aware of the issue; usually, I'm not!

Now that I have this data assembled and organized, the next step is to feed it into the traditional sortable stats reporting. That should be done within the next week, and this year will include some new filtering capabilities that should be useful for daily contest analysis.

Tuesday, April 1, 2014

Taking a step back

In getting the various reports ready for 2014, I've come to realize that I need to redesign and automate some of the processing that used to have some manual steps involved. Some of these processes are very much at the front end - including keeping track of active rosters and team affiliations. I hope to rebuild most of that framework within the next few days. But that will defer the production of sortable stats for a few more days.

It will serve all of us better to automate as much of the routine as possible. Arguably, I should have been working on this last month. But frankly, there's noting like working with live data - and that's what I have now.

What does this mean for you? If some players seem to be missing from certain reports, or if some players are listed with incorrect team affiliations, be patient.

Back to the salt mines...

Sunday, March 30, 2014

Game on!

As far as I know, all of the links in the left three menu bars should be working now - Batter vs Pitcher, Weather, and Other Tools. (Some of the BvP position coding for FanDuel and DraftStreet will be incorrect, however.)

Sortable stats will not be up for a little while. I'm still working out some kinks there. Hopefully, I'll have those up by the end of the week.

Note that I'm expanding the range of covered daily sites to six. Perhaps more to come. But for now, let me get the six up and running in the sortable stats before looking beyond those.

Please let me know if you see anything that seems to be off.

Friday, March 21, 2014

Awakening the hibernating bear

I'm starting to reactivate the site as the MLB season draws near.

The Batter vs Pitcher report is active for the two games in Australia, but will probably not pick up any of next week's spring training games.

Perhaps of more preseason interest, the bullpen usage summary is now active and capturing spring training activity.

The daily player stats program has already been up and running throughout spring training.

The weather and lineup dashboards are not yet functional for 2014, but should be ready when games begin play in the U.S.

I haven't yet begin to load and scrub the data for the sortable stats for the various daily contest sites, and that may not be completely ready until after the season starts.

Thursday, January 16, 2014

2014 MLB Schedule

I've posted a spreadsheet with the 2014 MLB schedule. Two formats are included - one with the teams in columns (and dates in rows), and one that is flipped. (Both are in the same spreadsheet - find the appropriate tab along the bottom.) Here is the link: http://dailybaseballdata.com/dbd/MLB_schedule_2014.xls

The schedule was pulled from MLB.com in early January, and appears to be complete. At least, each team has 81 home games and 81 away games. If you notice any errors, please let me know.

Note that the regular season begins with two games in Australia on March 22-23. After those two games, the rest of the season doesn't start until a week later, with a single game on Sunday night, March 30. Most teams begin action on March 31st, although Houston and the Yankees don't play until April 1st.