football monster & espn leagues

   Back to Forum Search Topics Edit User Settings Scroll to Bottom


 You can add an avatar image from your User Settings page.

avatarsangamc (54 posts)  9/20/2017 4:55 PM

A long shot question but you might be able to help.

I'd like to pull my entire ESPN league into a spreadsheet so I can match players up with FBM projections. THis way I can see free agents that can be picked up without boucing back and forth between 2 web pages.

can you provide any insight into how you do team import for Basbeball and Basketball monster?

i understand it may be too advanced to do with simple spreadsheet importhtml functions but any pointers would help.

Thanks


0% Agree (0 votes)
avatarsangamc (54 posts)  9/22/2017 10:41 AM

I found a way to do this. It wasnt as bad as i thought

 

={importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",3);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",4);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",5);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",6);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",7);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",8);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",9);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",10);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",11);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",12);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",13);importhtml("http://games.espn.com/ffl/leaguerosters?leagueId=805290","table",14)}

 

to extract the player names without the fluff, put the following in row1 to the left of the roster data and copy all the way down

 

=iferror(if(iferror(find("D/ST",C1),0)>0,REGEXEXTRACT(C1,"(.*) D\/ST "),REGEXEXTRACT(C1,"(.*)\,")),"")

 


0% Agree (0 votes)
avatarkslight (2575 posts)  9/22/2017 11:25 AM

Does this only work with public leagues?


0% Agree (0 votes)
avatarsangamc (54 posts)  9/22/2017 12:24 PM

Yes it appears public leagues onlu. I tried it on one of my leagues that is not set to public and the formula returns "imported content does not have query with give index" :(

 


0% Agree (0 votes)

    Scroll to Top