Home | Webstore
Latest News: OOTP Update 20.6 - OOTP 20 Available - FHM 5 Available

  

Go Back   OOTP Developments Forums > Prior Versions of Our Games > Earlier versions of Out of the Park Baseball > Earlier versions of OOTP: Historical Simulations

Reply
 
Thread Tools
Old 01-09-2011, 05:44 PM   #1
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
Database of transactions by day

Hey all.

I'm looking to find a database that has all major league transactions for all seasons going back as far as possible. I can find websites that seem to access such a database, but I'm looking to get a hold of an actual database (or something I could easily make into one - hopefully something downloadable.

I have this idea that I may want to recreate history including trades, signings, etc. on appropriate dates. I don't know if I'll really go through with it, but getting a database would be a first step.

Anyone know where I could get this?
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 01-09-2011, 06:08 PM   #2
Chicagofan76
Banned
 
Join Date: Oct 2009
Location: Diamond, IL
Posts: 6,339
Thanks: 3,340
Thanked 579x in 505 posts
Infractions: 2/2 (3)
I couldnt find anythign on Google for ya best i found is u can do yearly on Baseball ref.

heres some for the White Sox

1963 Chicago White Sox Trades and Transactions - Baseball-Reference.com
Chicagofan76 is offline   Reply With Quote
Old 01-09-2011, 06:15 PM   #3
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
I actually just found what I was looking for at retrosheet. For some reason I couldn't find it before. They actually have a downloadable zip with every transaction listed. I couldn't have asked for anything better.
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 01-10-2011, 09:41 AM   #4
Charlie Hough
Hall Of Famer
 
Charlie Hough's Avatar
 
Join Date: May 2006
Posts: 2,986
Thanks: 109
Thanked 1,118x in 585 posts
Just be aware that the Retrosheet data are not complete. There are still many transactions that remain unknown and unreported.
Charlie Hough is offline   Reply With Quote
Old 01-10-2011, 09:57 AM   #5
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
Yeah, thanks. I figure they've probably got the most exhaustive list, though.

Looking it over, I'm not sure I want to undertake this after all. I mean, there are over 60,000 transactions there. Even when I filter out the ones that would be irrelevant in OOTP, like amateur draft signings, I still see around 50,000. I think that's a bit much to keep up with for me. It would be cool to be able to have OOTP read the file and make the appropriate transactions, though it's not exactly a priority.
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 01-10-2011, 02:29 PM   #6
BaseballMan
Hall Of Famer
 
BaseballMan's Avatar
 
Join Date: Jan 2002
Posts: 5,503
Thanks: 68
Thanked 506x in 324 posts
Before I accidentally formatted my hard drive I had something like that. I also had a retire and unretire list cause some players retire and unretire. So I'm gonna redo it. I will make a spreadsheet and match the players games played to that teams schedule if there is no historical trade date. If the player isn't traded then I will just mark him has released. I am also gonna redo my retiregunretire list.
BaseballMan is offline   Reply With Quote
Old 01-10-2011, 03:47 PM   #7
Charlie Hough
Hall Of Famer
 
Charlie Hough's Avatar
 
Join Date: May 2006
Posts: 2,986
Thanks: 109
Thanked 1,118x in 585 posts
Quote:
Originally Posted by ctorg View Post
It would be cool to be able to have OOTP read the file and make the appropriate transactions, though it's not exactly a priority.
This has been proposed on a number of occasions. It may ultimately come down to whether OOTP Developments considers it acceptable to use a data source that is only partially correct.
Charlie Hough is offline   Reply With Quote
Old 01-10-2011, 05:29 PM   #8
BaseballMan
Hall Of Famer
 
BaseballMan's Avatar
 
Join Date: Jan 2002
Posts: 5,503
Thanks: 68
Thanked 506x in 324 posts
Yeah but they use a modified database for historical
replay in cases where there is no data. So why not just add it
as an optional database? I'm sure people are not gonna go crazy over
2 mistakes but its better than doing it manually and would make
The game more enjoyable for historical simmers.
BaseballMan is offline   Reply With Quote
Old 01-10-2011, 06:12 PM   #9
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
Yeah, it's fine if it's inexact. It could work in conjunction with the Lahman database by refreshing the rosters each season - i.e., if there's a record of a guy playing for Team X in year 1 and Team Y in year 2, but there's nothing about it in the transaction file, the game could move the guy automatically and maybe just record it as "[player] moved from Team X to Team Y".
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 01-10-2011, 07:33 PM   #10
BaseballMan
Hall Of Famer
 
BaseballMan's Avatar
 
Join Date: Jan 2002
Posts: 5,503
Thanks: 68
Thanked 506x in 324 posts
Does the game recognize the AA,UA, etc abbreviations now.
I had database for the rookies for each league. I still haven't got
OOTP 11. Not that I don't want it but I'm stuck with an old system
And I'm slowly building a new one.
BaseballMan is offline   Reply With Quote
Old 01-10-2011, 07:44 PM   #11
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,376
Thanks: 2,825
Thanked 3,647x in 2,030 posts
Spritze claims to have a Lahman/OOTP-compatible Transaction.csv.

Last edited by pstrickert; 01-10-2011 at 10:40 PM.
pstrickert is offline   Reply With Quote
Old 01-11-2011, 10:31 AM   #12
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,199
Thanks: 319
Thanked 3,239x in 1,907 posts
I Are Showing This Having File Claim

Here is a sample. It is way to humongous to upload here.

I put the full thing on my ftp site.

Has not been updated for a year or so as there was no interest in it from nobody and I don't use it the way I play da game.
Attached Files
File Type: xls TransSample.xls (26.0 KB, 114 views)
Spritze is offline   Reply With Quote
Old 01-11-2011, 12:41 PM   #13
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,363
Thanks: 164
Thanked 904x in 479 posts
The retrosheet database is actually much more correct than you'd realize, at least in terms of comings and goings as long as you're only focusing on a player's professional debut with a major league organization and then his transactions during his major league career. Where it is lacking is in minor league transactions and post major league transactions.

For when the player is floating around the minors it may be missing a few but if he played in the majors for an organization it has when they went to that organization.

I use this database for doing the opening day team assignments in the Gambo/Spritze database and really have not found that ommision. The transaction database will occasionally have designated "January 1960 Joe Blow goes to Los Angeles Dodgers in an unknown transaction"
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 01-11-2011, 01:00 PM   #14
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,376
Thanks: 2,825
Thanked 3,647x in 2,030 posts
Based on what I've seen, the data is there. Is there enough interest in including it in OOTP12? Would it sell more copies? BTW, as-played lineup files are available, too (at least from 1901).
pstrickert is offline   Reply With Quote
Old 01-11-2011, 01:05 PM   #15
pstrickert
Hall Of Famer
 
pstrickert's Avatar
 
Join Date: Dec 2005
Posts: 12,376
Thanks: 2,825
Thanked 3,647x in 2,030 posts
Even Puresim has real-life transaction and as-played lineup files. I'd hope to see them in OOTP, too.
pstrickert is offline   Reply With Quote
Old 01-11-2011, 01:10 PM   #16
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
If it's not a programming nightmare, I think it could only help bring more people in.
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 01-11-2011, 02:46 PM   #17
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,199
Thanks: 319
Thanked 3,239x in 1,907 posts
4,517 Major League Players have no entry at all in the transaction database. Is that close enough? About 200 of them are players that debuted in Lahman after the last TranDB Update so they don't count.
Spritze is offline   Reply With Quote
Old 01-11-2011, 04:52 PM   #18
Gambo
Hall Of Famer
 
Gambo's Avatar
 
Join Date: Mar 2002
Location: Oklahoma
Posts: 2,363
Thanks: 164
Thanked 904x in 479 posts
Quote:
Originally Posted by Spritze View Post
4,517 Major League Players have no entry at all in the transaction database. Is that close enough? About 200 of them are players that debuted in Lahman after the last TranDB Update so they don't count.
Only 25% that's not too bad. This is also part of the reason I combine info from the transaction database with your minor league stats when doing my database. It fills in alot of voids and gets me as close to accurate as I can.
__________________
Give me league evolution with historical imports!!!

OOTP MODS:
Historical Face Gen Project, Spritze/Gambo Database, OOTP Stadium Chart and Ballpark Images, MLB Compiled Uniform & Logo Pack
available at...
http://www.ootpmods.com
Gambo is offline   Reply With Quote
Old 01-11-2011, 05:48 PM   #19
ctorg
Global Moderator
 
ctorg's Avatar
 
Join Date: Nov 2002
Location: Queens, NY
Posts: 9,848
Thanks: 79
Thanked 147x in 82 posts
Wow, that's a lot of missing transactions.

Is it accurate back to a certain date? I.e., are there players who debuted after, say, 1980 who are not in the transaction DB?
__________________
My music

"When the trees blow back and forth, that's what makes the wind." - Steven Wright

Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils
ctorg is offline   Reply With Quote
Old 01-11-2011, 06:57 PM   #20
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,199
Thanks: 319
Thanked 3,239x in 1,907 posts
If the average player had 7.51934 transactions in a career that might be 33,965 missing transactions give or take. Of course that 7.51934 number could be suspect itself as I just made it up. Anyway, that could be a bunch of missing transactions that might be missing in a transactional transcendental sense tangentally targeted.
Spritze is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:49 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments