How to make price grabbing calculators in Excel or Google Docs
Intro:
After seeing this thread by YoHoJo I ended up creating this tutorial in the thread, thought I would post it here so more people see it.
I have written some php that means you can generate a page with just the price of an item (without any other text) so that you don't have to trim it down in excel. The page is as follows:
Getting the Item ID:Code:http://putonajonnyspricechecker.host-ed.me/price.php?Item=ItemName or http://putonajonnyspricechecker.host-ed.me/price.php?Item=ItemID
It works better with the Item ID if the name of the item is more than 1 word long or there are items with similar names, you can get IDs from this website: http://www.itemdb.biz/index.php
How to:
In excel click on the Data Tab, then click "From Web":
Put the URL in like this, then click Go:Code:http://putonajonnyspricechecker.host-ed.me/price.php?Item=ItemName or http://putonajonnyspricechecker.host-ed.me/price.php?Item=ItemID
You should then see the price of that item appear, click the yellow arrow in the top left.
Click on import:
Select the cell you want the price to appear in:
You should then end up with the price like this:
You can repeat this for as many items as you want. To refresh the prices you just click:
You can configure some refreshing options by:
Or in google docs:
Sorry about the mass of pictures, I thought this was the best way to show this. You can then make your self updating calculators like this one: (Have Fun!)
There seems to be an issue where you can't put something in the cell below an imported price, or that if you do when you update the price it will disappear, this is to do with it importing two lines when it downloads the price, this issue isn't present in google docs, so you could use that, or put the prices in one sheet then paste links to them in another sheet with your calculator on.