Stats Exportable to Excel - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to Baseball Leftovers

Stats Exportable to Excel

Moderator: Baseball Moderators

Stats Exportable to Excel

Postby The Loveable Losers » Thu May 19, 2005 12:33 pm

I have some numbers I want to crunch to rank pitchers but I can't find a good site to export/copy-paste the number from into Excel that brings them into Excel as values (everything's coming in as labels for me and then I can't do any number crunching).

Anyone know of any good place to get current and previous season totals that either will export to Excel or paste in as values?
The Loveable Losers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterWeb Supporter
Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

Postby Mordraken » Thu May 19, 2005 1:35 pm

I'm sure there are better sites, or methods, but I go through the "all players" listings in Yahoo and copy/past special text. It takes a while, but it works, and the numbers come in as numbers and not lables/text.

Here's the page:
http://sports.yahoo.com/mlb/stats

Chose a position and start selecting, copying and pasting.
Mordraken
Minor League Mentor
Minor League Mentor

User avatar

Posts: 382
Joined: 24 Mar 2003
Home Cafe: Baseball
Location: Toronto

Postby yellowdog » Thu May 19, 2005 1:40 pm

"It's like a full-body dry-heave set to music"
yellowdog
College Coach
College Coach

User avatar

Posts: 196
Joined: 16 Jan 2003
Home Cafe: Baseball
Location: Chillicothe, Ohio

Postby acsguitar » Thu May 19, 2005 1:45 pm

I know that there is a way with excel to have it constantly updated using Macros I think or some formula...i konw with like the stock market you can keep stats updated via online ... I'd have to look into it but it would keep your spreadsheet constantly updated.
I'm too lazy to make a sig at the moment
acsguitar
Hall of Fame Hero
Hall of Fame Hero

User avatar
Graphics Expert
Posts: 26722
Joined: 7 Apr 2004
Home Cafe: Baseball
Location: Back in General Talk WOOO!!!

Postby StlSluggers » Thu May 19, 2005 1:50 pm


I use this one religiously. Easy to work with and even tracks odd stats like Quality Starts. Saves as a text file, but that's easy enough to convert.

Highly recommended!

;-D ;-D
StlSluggers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterMock(ing) DrafterWeb Supporter
Posts: 14716
(Past Year: 10)
Joined: 24 May 2004
Home Cafe: Baseball
Location: Parking in the gov't bldg @ 7th and Pine. It's only $3.00 on game day!

Postby The Loveable Losers » Thu May 19, 2005 2:35 pm

Thanks a ton! I'm working on trying to equally weight the team's offense (which is the primary predicter of wins outside of the pitcher's stats), K/9, WHIP and ERA (for a 5x5 league). If I had more time I'd weight the pitcher's past performance too but this is just a nice little side project to look for pitchers whose value isn't reflected in Yahoo rankings. Unfortunately it will be skewed toward early success this year since I'm not taking the time to post in previous year's stats but a bit of common sense can go a long way there.
The Loveable Losers
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterWeb Supporter
Posts: 7290
Joined: 30 Mar 2005
Home Cafe: Baseball
Location: Cubs Win!!! Cubs Win!!!

Postby rmeesig » Thu May 19, 2005 2:48 pm

When pasting into Excel, choose Paste Special...then choose TEXT instead of HTML
If a man dwells on the past, then he robs the present.
But if a man ignores the past, he may rob the future.
The seeds of our destiny are nurtured by the roots of our past.
[i]-- Master Po[/i]
rmeesig
Minor League Mentor
Minor League Mentor

User avatar

Posts: 683
Joined: 5 May 2004
Home Cafe: Baseball

Postby Rirruto » Thu May 19, 2005 3:22 pm

StlSluggers wrote:Saves as a text file, but that's easy enough to convert.

;-D ;-D


Do you mind filling me in? Never done it before.
Image
Rirruto
General Manager
General Manager

User avatar
Cafeholic
Posts: 2525
Joined: 29 Mar 2004
Home Cafe: Baseball
Location: Mezzanine Section 12 @ Shea

Postby Q » Thu May 19, 2005 3:32 pm

I have actually created an entire excel file which includes career statistics from every noteworthy pitcher in the league and pasted in formulas that show their hit percentage, walk rate, strikeout rate and home run rate. I used Yahoo's. Those paste in pretty well.
Q
Minor League Mentor
Minor League Mentor


Posts: 635
Joined: 5 Mar 2005
Home Cafe: Baseball

Postby Amazinz » Thu May 19, 2005 5:46 pm

There's another alternative to copy/paste called "Web Queries" in Excel. There are plenty of tutorials online, just Google it. They're really easy to use and it's mostly automated. It makes importing data from the Web really easy and it will auto-update itself. ;-D
Image
Maine has a good swing for a pitcher but on anything that moves, he has no chance. And if it's a fastball, it has to be up in the zone. Basically, the pitcher has to hit his bat. - Mike Pelfrey
Amazinz
Mod in Retirement
Mod in Retirement

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeWeb SupporterPick 3 Weekly WinnerSweet 16 SurvivorLucky Ladders Weekly Winner
Posts: 18800
Joined: 16 Mar 2004
Home Cafe: Baseball
Location: in Canada, toughening up figure skaters

Next

Return to Baseball Leftovers

Who is online

Users browsing this forum: Brisbane and 7 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Monday, Jul. 28
(All times are EST, weather icons show forecast for game time)

San Diego at Atlanta
(12:10 pm)
Milwaukee at Tampa Bay
(7:10 pm)
indoors
Philadelphia at NY Mets
(7:10 pm)
Washington at Miami
(7:10 pm)
indoors
Arizona at Cincinnati
(7:10 pm)
Toronto at Boston
(7:10 pm)
Colorado at Chi Cubs
(8:05 pm)
NY Yankees at Texas
(8:05 pm)
Oakland at Houston
(8:10 pm)
Pittsburgh at San Francisco
(10:15 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact