![]() |
|
|
| |
« Rosenthal's Latest: Sabathia, Blake, Greinke, Tejada | Main | Padres Sign Tomko »
A student from Villanova University, Brendan Bianowicz, emailed me asking if he could help with the site in any way. I had always wanted a full trading history of all 30 GMs. Brendan jumped at the opportunity to compile this data.
Today we have Billy Beane's Trade History for you to download in Excel form. Brendan gets extra credit for putting free agent and draft pick info in the spreadsheet as well. Thoughts on this spreadsheet or the endeavor in general?
TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d834515b9a69e200e553749e008833
Listed below are links to weblogs that reference GM Trade History - Billy Beane:
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.


|
|
Love it. Well done.
Posted by: J G | June 27, 2008 at 03:08 PM
what does "count" (the last column" mean?
Posted by: wallybackman | June 27, 2008 at 03:11 PM
Was really informative and great info great job... but I think there was one mistake on the Mark Kotsay trade... he was in the recieved column and Joey Devine was in the traded column.
Posted by: Ksow45 | June 27, 2008 at 03:17 PM
My mistake...count means the number of trades Beane has made with each GM. So, he's made the most deals with J.P. Ricciardi at nine.
We will get the Kotsay error fixed, thanks.
Posted by: Tim Dierkes | June 27, 2008 at 03:18 PM
I like it. Any chance Brendan can whip up a Theo spreadsheet?
Posted by: DunkinDonuts | June 27, 2008 at 03:25 PM
Looks great. Can't wait to see some other teams!
Posted by: thehoagster07 | June 27, 2008 at 03:26 PM
Impressive list, but another a's-rangers trade i thought up wasn't on there. adam melhuse for cash during the 07 season. was there any other trades he missed?
Posted by: txrangers22 | June 27, 2008 at 03:38 PM
Awesome idea, Tim. This is always something I've wanted to see somewhere. Definitely continue with it.
Posted by: Derek Carty | June 27, 2008 at 04:02 PM
This is a great idea. I hope you plan on incorporating a weblink on your website. You could grow into a baseball version of hoopshype.com...or even sell the idea/data to Baseball-reference.com.
Anyway, keep up the good work.
Posted by: Ralow | June 27, 2008 at 04:04 PM
Great information. Looking forward to seeing the others.
I would suggest, though, you get rid of the COUNT column. I didn't know what it was at first - like many others, I assume - and even now that I do, I don't find it to be all that useful, especially when it's not carried all the way down the column. The only way to use it as it's listed now is to scroll all the way to the top and see if those GMs hooked up on deals before.
Posted by: cmac1973 | June 27, 2008 at 04:13 PM
great job, Brendan!
Go Nova!
Posted by: robojake0_0 | June 27, 2008 at 04:14 PM
Wow! Even multi-team trades are in there and easy to comprehend too. How in the world do you even start something like this?
I agree with 'Ralow' - eventually migrating this to the web would be extremely cool. Clicking on another GM would show his trade history or a player would show his trip around the majors.
Posted by: fijis | June 27, 2008 at 04:25 PM
Magnificient! It actually is exactly what I need for a research project I've been noodling on that takes a different approach to calculating the value of trades.
Posted by: George Purcell | June 27, 2008 at 04:43 PM
That's a great idea, migrating it to the web. I will seriously look into that once we get done with all the GMs.
I like the count column, I just need to explain and maybe format it better. But I find it very useful to see each GM's most frequent trading partners.
Posted by: Tim Dierkes | June 27, 2008 at 04:47 PM
Tim, I would really like to do Kenny Williams GM Trade History for your site. If you are interested in my help, let me know via email at TheMLBWire@gmail.com. Thanks
Posted by: Jenks45Monster | June 27, 2008 at 05:03 PM
Tim, the site continues to impress. Thank you for creating and building such a wonderful source of information.
I still say if you can ever get a list of Options Status for every player, that's the holy grail. :)
Posted by: notsellingjeans | June 27, 2008 at 05:12 PM
Great idea. I think it would come in especially handy for guys like Jim Bowden and Dave Dombrowski who have had the GM job with multiple teams. A clearer pattern would emerge when all the info was presented together.
Posted by: ThaWalrus9 | June 27, 2008 at 05:28 PM
One other correction. The trade where the A's got Durazo shows that Durazo came from the Reds. This was a 4-team trade, but Durazo came from the D-Backs. The Reds were the only team in the trade that the A's were not actually involved with (did not send a player to, nor received a player from them).
Posted by: AsFanInLA | June 27, 2008 at 05:31 PM
I like the idea a lot as well. However, I would try to add in the team's record at the time of the trade, just to paint a better picture of the GM's thought process.
Posted by: blangen | June 27, 2008 at 05:34 PM
You should also say if the trade was good bad or a bust for both teams and add them up to see how the gm trades overall.
Posted by: willie randolph sucks | June 27, 2008 at 06:29 PM
Hey Tim,
I would really like to do a GM Trade File on Giants General Manager Brian Sabean. I don't really know who else would do a profile on Sabean since many people here on MLB Trade Rumors don't like him, but I would be more than happy to do one on him. If you're interested, email me at Alexolson19@gmail.com.
Posted by: It's Giant's Time! | June 27, 2008 at 06:34 PM
very nice. im looking at all these trades and it looks like beane has traded away as much talent as hes acquired. everyone gives beane so much credit but i think the athletics scouting and drafting people deserve more credit. beanes made really good trades but also really bad ones. hes just had so much young talent to work with.
Posted by: Joelcards | June 27, 2008 at 08:33 PM
Brendan is going to tidy up these errors and we'll re-post this sheet. It'll become a permanent sidebar link, this series.
Brendan is going to all the GMs, but thanks for the offers.
Posted by: Tim Dierkes | June 27, 2008 at 10:30 PM
Thanks for the feedback. I'll start on one for Theo and then maybe Brian Cashman. Any other suggestions would be welcomed because I still have a lot of GM's to go. As long as I know there are people reading them I'm more than happy to make more . I also found it very interesting he never signed a major free agent, and also how good the A's scouting was that they drafted guys like Papelbon, Hudson, Towles, Ethier, and Harden in such late rounds.
Posted by: brendanb | June 27, 2008 at 10:56 PM
Ha, I have the unfortunate fate of being a Phillies fan, in terms of Pat Gillick and the fact that he's 200 years old and has made about a million moves. Would a Gillick one interest anyone? It would probably take a while, but I could chip away and certainly it would be something cool to look at for the deadline.
Posted by: phillyvic | June 27, 2008 at 11:23 PM
Unfortunately I'm a Phillies fan too, I'll probably get to him sometime during the next week, and to answer ThaWalrus' suggestion I'd like to do the GM's history with their current teams first and then go back and update anyone who has held the same position for another team. But by the time it's all done I'd like to have each GM's complete history. Thanks for your suggestions, there should be an update of Beane's Trade History posted very soon, hope you all like it!
Posted by: brendanb | June 27, 2008 at 11:38 PM
This could be one of the coolest tools on the web when its complete.
And I'll throw in another plug for the Phils before all the Red Sox, Cubs and Yanks fans flood this thread.
Posted by: benjoua | June 28, 2008 at 12:48 AM
Retrosheet maintains a CSV file of every trade/free agent signing since the early 1900s. You could probably automate a lot of the effort, simply with a list of who was GM for what team when and a few database queries.
Posted by: Colin Wyers | June 28, 2008 at 01:18 AM
I think Jack Cust was traded for cash considerations.
Excellent idea - love it!
Posted by: DeJay | June 28, 2008 at 04:51 AM
Hey Tim I'll trade you Jose Vidro AND Richie Sexson to have this guy Brendan work for the Mariners along side Pelekoudas... If I have to, I'm not scared to raise it a crate of baseball bats and two bags of practice balls! Seriously though, Brendan, you've done a great job, keep up the good work... How about Vidro and Sexson for an electric pencil sharpner?! I'm flexible, you don't even have to include the batteries if it takes them!
Posted by: BaseballGuru | June 28, 2008 at 05:31 AM
This is awesome...for other teams you should do the past 2 GM's if one's tenure is 4 years or less.
Posted by: btownfu | June 28, 2008 at 08:20 AM
Guru, dont you know? Richie Sexson is just lulling the opposing pitchers to sleep so that they give him better pitches in the second half. This was part of his plan ever since spring training. He will hit 45 HR's after the all star break and be right back on the HOF fast track. I thought you would have known this..
Posted by: nrmax88 | June 28, 2008 at 08:27 AM
Brendan and Tim, the trade profile looks great. I think that we're all interested in seeing one created for each GM (in time, of course). Brendan it sure looks like there are plenty of people willing to help you out with these so don't be afraid to ask.
Posted by: Aaron | June 28, 2008 at 09:26 AM
The Kotsay trade is wrong, kotsay went to the braves, some of the other trades are like that to.
Posted by: StrosFan | June 28, 2008 at 09:43 AM
Colin, most of my transaction information is actually taken from Retrosheet but I do it all manually. I downloaded the database but when I opened the file I had no idea what it was. Is there anyway you can help with this? And thanks to everyone for the encouragement.
Posted by: brendanb | June 28, 2008 at 09:48 AM
GM trade history is a nice idea, good work. However, I don't think a spreadsheet is the right format... makes it hard to maintain and difficult for people to always get the most up-to-date version. How about a simple a set of wiki pages or a small CMS type application?
Posted by: trilambda | June 28, 2008 at 10:51 AM
Great stuff - I linked to it from my site. I know a lot of people that would be interested in this.
Salary info would be helpful too.
Posted by: bleggin | July 07, 2008 at 10:02 PM