An Iconic Fantasy Baseball Community
Moderator: Baseball Moderators
Element wrote:What exactly is the question .. ?
SAV wrote:Element wrote:What exactly is the question .. ?
lol. I want to know if anyone has already created Excel dynamic queries to obtain player stats from the web. I've used the "Export Data" function in Fangraphs this year and then copy/pasted it into my analysis tool ... but I've HEARD the queries are a far more efficient way to accomplish it ...
Skin Blues wrote:It's hard to fiddle with it now because it stops at the end of the regular season. I don't see any date-specific data in the URL, so maybe it's a caching issue. But if you find a way to alter the URL to go to specific date range then you could do all data collection at once instead of having to do it every single day.
Alternatively, you could just download game logs for every player at the end of the season. It's a lot more work, but you could do it all at once, and/or program something to do it for you. Not sure on the legality of that. Out of curiousity, what do you plan on using this for?
Users browsing this forum: No registered users and 5 guests