# Programmatically acquiring draft data

**URL:** https://community.ottoneu.com/t/programmatically-acquiring-draft-data/14308
**Category:** Baseball Tools
**Created:** [March 31, 2024, 6:12pm UTC](https://community.ottoneu.com/t/programmatically-acquiring-draft-data/14308 "2024-03-31T18:12:29Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![chrislee100](https://community.ottoneu.com/letter_avatar_proxy/v4/letter/c/9e8a1a/32.png) [@chrislee100](https://community.ottoneu.com/u/chrislee100)
#### Post date: [March 31, 2024, 6:12pm UTC](https://community.ottoneu.com/t/programmatically-acquiring-draft-data/14308/1 "2024-03-31T18:12:29Z")

</div>

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](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