football monster & espn leagues

sangamc  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

sangamc  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,"(.*)\,")),"")

ken_admin  9/22/2017 11:25 AM

Does this only work with public leagues?

sangamc  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" :(