Grabbing exp from RS HighScores

Adbot · **Posted:** November 24th, 2009, 8:38 am

Davo · **Posted:** November 24th, 2009, 9:01 am

I can't vouch for how Mike does it, but it's usually done by a script (PHP) that retrieves text or code and parses it into exp, levels, ranks, etc.. Once the raw data is obtained, functions can be written to calculate daily exp and whatnot. It's basically scripts that fetch text or code, given a specific link.

There is actually a special link that not a lot of people know about called Hiscores Lite. It's just CSVs of all the exp, levels, and ranks of a given user. I think the order they are arranged is Rank,Level,Experience,...etc. Here is an example:

http://hiscore.runescape.com/index_lite.ws?player=Tal_Ormanda

Hope this helps you out a little bit!

Tal Ormanda · **Posted:** November 24th, 2009, 10:30 am

How to get it and throw it onto excel would be my question..

hummerwar921 · **Posted:** November 24th, 2009, 2:21 pm

http://forum.tip.it/topic/220194-how-to-use-google-docs-to-extract-ge-prices-by-brainymidget/

That is how you do it with the Grand Exchange, but you can adapt this to work with the High Scores.

addiv · **Posted:** November 25th, 2009, 2:49 am

Data / Import External Data / Import Data

In the dialog box change the File of Type to '*'
In the File Name type in the url to the RS stats web service:

http://hiscore.runescape.com/index_lite.ws?player=tal ormanda

Bryan · **Posted:** November 25th, 2009, 4:53 pm

I used Excel 2010 Beta but IT DOES WORK IN EXCEL 2007, maybe not the same steps but it works the same way.
=D
EDIT: Actually, thinking of which, I've tried most Excel versions from 2000, and I think they all have this feature...

Firstly, go into the ribbon, you want to get to the Data Tab.

Spoiler for Ribbon:

Next, in the Get External Data Group, choose From Web.

Spoiler for Import:

A mini browser will open up. Navigate to the Highscores page. (Rsbandb's and the official ones work) and see if there is a mini arrow next to a table.

Spoiler for Grab Data:

The arrow should then turn into a green check mark, and will sometimes have shaded in the "table".

Spoiler for Grab Data:

You have selected your tables.
Click Import at the bottom to continue.

Now, every time you open this spreadsheet, it will grab your stats from the highscores page and refresh it on to this worksheet.
You can customize it to make it look fancy...

Spoiler for My Excel Spreadsheet:

Like adding Data Bars and stuff.
Or you can simply save it and send it to your friends, or for your own personal use.

Spoiler for save:

Hope I helped!

Adbot · **Posted:** November 25th, 2009, 4:53 pm

Earth · **Posted:** November 25th, 2009, 4:56 pm

Bryan made me one, it works amazingly well

Bryan · **Posted:** November 25th, 2009, 4:57 pm

Earth271072 wrote:

Bryan made me one, it works amazingly well

What was the time I did it in?
:oops:

Earth · **Posted:** November 25th, 2009, 7:40 pm

asovse1 wrote:

Earth271072 wrote:

Bryan made me one, it works amazingly well

What was the time I did it in?
:oops:

1 minute 35 seconds.

Tal Ormanda · **Posted:** November 26th, 2009, 10:46 am

Cool so.. I have openoffice.

Bryan · **Posted:** November 27th, 2009, 8:57 am

Oh.
I found this for you then Tal, see if it works.

Quote:

#

* For Open Office Calc: Under the "Insert" tab, click on "Link To External Data". Enter the item's URL and click OK. The data should appear in a few seconds.

# If the data needs to be imported without the pictures or colour (i.e. just the text), make sure "None" is selected under "Options -> Formatting" before the data is imported.
# To update, click "Data", and click "Refresh Data".

Aquw VettelS 776 · **Posted:** November 27th, 2009, 2:54 pm

I know you didn't ask for it, but PM me if you want the PHP method.

Tal Ormanda · **Posted:** November 29th, 2009, 12:46 am

asovse1 wrote:

Oh.
I found this for you then Tal, see if it works.

Quote:

#

* For Open Office Calc: Under the "Insert" tab, click on "Link To External Data". Enter the item's URL and click OK. The data should appear in a few seconds.

# If the data needs to be imported without the pictures or colour (i.e. just the text), make sure "None" is selected under "Options -> Formatting" before the data is imported.
# To update, click "Data", and click "Refresh Data".

After I enter the URL the OK button is still grayed out...