<< Back to General Forum   Search

Posts 1 - 7 of 7   
How to do this? (coding help): 11/26/2015 19:31:13


Legacy 
Level 56
Report
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!
How to do this? (coding help): 11/26/2015 19:32:25


Fleecemaster 
Level 59
Report
Did you try Alt+F4?
How to do this? (coding help): 11/26/2015 19:34:42


Legacy 
Level 56
Report
Yes, and rabbits fell from the sky. Not too helpful
How to do this? (coding help): 11/26/2015 19:43:56


knyte 
Level 58
Report
You want to retrieve a player's current ladder rating? Could you elaborate a bit?
How to do this? (coding help): 11/26/2015 19:46:31


Legacy 
Level 56
Report
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.
How to do this? (coding help): 11/26/2015 19:51:21


knyte 
Level 58
Report
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.
How to do this? (coding help): 11/26/2015 20:04:31


Legacy 
Level 56
Report
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.
Posts 1 - 7 of 7