Chumley Posted January 6, 2009 Share Posted January 6, 2009 Does anyone know whether it is possible to use Excel to grab GE prices? I have a spreadsheet where I record XP rates, costs of certain skills etc. and it would be really useful if I were able to automatically plug GE prices in. I'm guessing the answer will be no, but any assistance would be appreciated. Link to comment Share on other sites More sharing options...
JoeDaStudd Posted January 7, 2009 Share Posted January 7, 2009 In excel. Select the cell to import to, Data -> Import External Data -> New Web Query [hide=Drops]Dragon Axe x11Berserker Ring x9Warrior Ring x8SeercullDragon MedDragon Boots x4 - all less then 30 kcGodsword Shard (bandos)Granite Maul x 3Solo only - doesn't include barrows[/hide][hide=Stats][/hide] Link to comment Share on other sites More sharing options...
Chumley Posted January 7, 2009 Author Share Posted January 7, 2009 OK thanks for that, but how do I select just the price of the item to be imported? Link to comment Share on other sites More sharing options...
Chumley Posted January 13, 2009 Author Share Posted January 13, 2009 Is anyone else able to help with this? Link to comment Share on other sites More sharing options...
thrash-boy Posted January 13, 2009 Share Posted January 13, 2009 maybe you could host a php file somewhere (there are plenty of free hosts) that strips the page down to just the item price, and then point excel to that php file. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now