January 6, 200917 yr 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.
January 7, 200917 yr 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]
January 7, 200917 yr Author OK thanks for that, but how do I select just the price of the item to be imported?
January 13, 200917 yr 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.
Create an account or sign in to comment