Follow these steps to load Retrosheet box score data into a database. I've done this for SQL Server Express and believe it should work for MySQL. The box...
415
tangotiger
Dec 14, 2011 5:39 pm
Richard, Your attachments did not come through for me. You may find it more helpful to login directly to Yahoo Groups, and upload files through their "Files"...
416
willkoky
Dec 15, 2011 3:47 am
Richard, Can you elaborate a little on the different parts of these command line options? I take it one is supposed to run the .exe twice, once with each...
417
rfbain
Dec 15, 2011 5:40 am
As I'm sure you have guessed, I'm new to the procedures of Yahoo groups and the culture of this group in particular. I read elsewhere that the way to upload...
418
rfbain
Dec 15, 2011 5:57 am
No, the program only needs to be run once. The command line argument represents the syntax required by the database for its version of the Bulk Load command....
419
KJOK
kjokbaseball
Jan 12, 2012 6:10 am
If anyone has already loaded the Retrosheet 2011 event files AND the latest boxscore files to their database, and is willing to run a few simple queries by...
420
Kyle W. Willkomm
willkoky
Jan 16, 2012 4:01 am
This post is to announce version 5.0 of BBOS. 5.0 adds Retrosheet support thanks almost entirely to the Python scripts written by Wells Oliver. If you wish...
421
KJOK
kjokbaseball
Jan 26, 2012 3:27 am
OK, then does anyone have instructions for loading both event and boxscore files to either MySQL or MS Access? THANKS, Kevin...
422
Kyle W. Willkomm
willkoky
Jan 26, 2012 3:53 am
Someone posted this loader for the box scores a few months ago but I have not successfully run it against MySQL yet. I believe it will work I just have not...
423
tangotiger
Jan 26, 2012 4:06 am
Kevin, Which data from the Boxscore files do you need, that wouldn't exist in the event or gameloges files? Tom...
424
KJOK
kjokbaseball
Jan 26, 2012 6:12 pm
For games not in the Event files (basically pre-1950), looking for summary at team/Park level for each batting component for both the team and it's opponents,...
425
tangotiger
Jan 26, 2012 6:20 pm
Ah, ok. When I first read your note, I seem to remember you asking for Event AND Boxscore files for 2011. That's why I didn't reply, because I never load the...
426
tangotiger
Jan 26, 2012 6:23 pm
Ah, ok. When I first read your note, I seem to remember you asking for Event AND Boxscore files for 2011. That's why I didn't reply, because I never load the...
427
Nicholas Miceli
nsmiceli
Apr 5, 2012 6:20 pm
Dear Group Members, Please excuse the cross-posting. A while back (2009) I wrote an article on baseball that was published in the Journal of Quantitative...
428
Nicholas Miceli
nsmiceli
Apr 6, 2012 7:20 pm
Dear Members, Thank you to all who responded to my request for help for readers. As I get into the planning process for research, I'm sure that list members ...
429
N. S. Miceli, Ph.D.
nsmiceli
Apr 19, 2012 2:52 pm
Dear group members, Please excuse the cross posting. When examining more than one season's worth of data, do you think that there is a need to examine the data...
430
tangotiger
Apr 19, 2012 3:48 pm
Can you elaborate by what you mean when you say "time series"? Do you intend to mean to weight recent data more? To "seasonally adjust" data? To... ?? I...
431
nsmiceli
Apr 19, 2012 6:14 pm
Tangotiger, Thank you for your response, and your suggestion. I'll take it seriously. To me, time series means a set of data where you have a series of...
432
tangotiger
Apr 19, 2012 6:22 pm
If I understand you correctly, then would weight=.999 ^ daysAgo be an example of autocorrelation? The further back in time you go, the less relevant the data...
433
nsmiceli
Apr 20, 2012 8:42 pm
Tom, This is exactly right. The software written to handle time series data takes that autocorrelation into account. I'd suspect that performance is strongly...
434
Theodore Turocy
arb1ter
Apr 20, 2012 8:49 pm
... *blinks* It's trivial that player performance is massively autocorrelated over time, whether at the annual, monthly, daily, per-PA levels; after all, the...
435
tangotiger
Apr 20, 2012 8:52 pm
Then to answer your original question: ALL forecasting systems use a scheme like the one below, to some extent or other. Therefore, when you say that you...
436
nsmiceli
Apr 21, 2012 6:34 pm
Tom and Dr Turocy, Thank you for your time and thoughtful answers. As I said, I'm just now planning this study and doing the background reading and literature...
437
Tom Hannon
thannon1010
Apr 22, 2012 5:42 pm
Is there anyone part of this group who would be interested in working with me to make this data live on my site, www.thebaseballpage.com. Tom...
438
Marty Resnick
golablues
Apr 22, 2012 6:19 pm
What exactly are you trying to do Sent from my iPhone...
439
Tom Hannon
thannon1010
Apr 23, 2012 12:03 am
I am looking to get all the box scores and play by play on my site and cross reference it with ball parks, players, teams. Once the data is set up to be...
440
tangotiger
Apr 23, 2012 12:55 am
It sounds like you want to replicate alot of what Baseball-Reference and Baseball-Almanac already does, but you might have a couple of extras? Are you asking...
441
Tom Hannon
thannon1010
Apr 23, 2012 1:39 am
I dont think anyone can copy baseball reference, that is not my goal. My goal is to have the basic data but have the images, video, and the content we have...
442
dangerwhatevs
May 2, 2012 1:11 pm
Hey guys, I get my retrosheet sql data from 'Want Linux' (here <http://www.wantlinux.net/2009/04/retrosheet-baseball-mysql-database-dow\ nload/> ), but the...
443
Josh Smith
sigepsmitty
May 2, 2012 1:28 pm
retrosheet.org, then use the exes to create tab delimited files. BGAME.exe,Bevent.exe ... -- Joshua Smith 508-507-1722 sigepsmitty@......
