Hi,
I’m building a little tool in Sheets just for my own draft day use. I’m feeling my way around what’s available and welcome anyone’s opinions. It looks the way to get info as draft proceeds is this:
=importdata(“https://ottoneu.fangraphs.com/leagueID/draftresults?export=1”)
Please guide me if you think I’m wrong, but this seems like an inexpensive (resource-wise) call compared to constantly re-loading league rosters. My question is: what do I get if I make this call after a player is nominated for auction but before he is sold? I assume I get everything up to and including the last completed auction sale. What I’d like to also be able to acquire is the name of a player currently being auctioned but not yet sold. (This could be used, for example, to display his stats.) Anybody know a way to get this?
Unfortunately, I missed this baseball draft season for testing but I suppose I can probably test it on a basketball or football league to be ready for next baseball season. (Why didn’t I start on this earlier?)
Appreciate any thoughts on this… Thanks, Chris