Hey, fellow programmers/spreadsheet addicts! I would like to make my Google Spreadsheet automatically update the sheet based on ladder ratings. How can I do this? I'm assuming this will use the =import("https://www.warlight.net/LadderTeam?LadderTeamID=x","something?",1) command?

Thank you in advance!

Did you try Alt+F4?

Yes, and rabbits fell from the sky. Not too helpful

You want to retrieve a player's current ladder rating? Could you elaborate a bit?

Yes. That's really all that cell needs to do.


This is for Warlight's new stock market! I would like my spreadsheet to automatically track the ratings of players I've invested in. This way, I can let my hedge fund grow to many new players over time without having to do much extra work to track it all.

My best guess is IMPORTHTML. I know that players' ladder ratings are stored in a table (at least I checked the source on my ladder pages and saw that my current rating was stored in two places, one of which was inside a <table> tag.

I've looked at the source code, and it's being stored in the "Ranked x with a rating of x" text in the table. I'm not sure how it's getting the ratings/ranks, or how to separate the rating from the rest of the text.