Results 1 to 6 of 6

Thread: How to make price grabbing calculators in Excel or Google Docs

  1. #1
    Join Date
    Oct 2011
    Location
    UK
    Posts
    1,322
    Mentioned
    2 Post(s)
    Quoted
    1 Post(s)

    Default How to make price grabbing calculators in Excel or Google Docs

    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:

    Code:
    http://putonajonnyspricechecker.host-ed.me/price.php?Item=ItemName 
    or 
    http://putonajonnyspricechecker.host-ed.me/price.php?Item=ItemID
    Getting the Item ID:
    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.

  2. #2
    Join Date
    Mar 2012
    Location
    Color :D
    Posts
    938
    Mentioned
    0 Post(s)
    Quoted
    0 Post(s)

    Default

    +rep!

  3. #3
    Join Date
    Dec 2011
    Location
    Hyrule
    Posts
    8,662
    Mentioned
    179 Post(s)
    Quoted
    1870 Post(s)

  4. #4
    Join Date
    Feb 2012
    Location
    Minneapolis
    Posts
    117
    Mentioned
    0 Post(s)
    Quoted
    0 Post(s)

    Default

    Nice guide.
    Progress Report:
    2/3

  5. #5
    Join Date
    Apr 2007
    Location
    Rimmington
    Posts
    168
    Mentioned
    0 Post(s)
    Quoted
    1 Post(s)

    Default

    Really Helpful guide, no more profit calcs for me will have it all done =] thanks +1

    Edit:
    looks like this has been taken down really gutted it was really useful for tracking my profits and knowing what to bot pm me if you would like me to host it for you (free off course) would be good to see it back up and running!
    Learning To Code - So Excuse the n00b questions!

  6. #6
    Join Date
    Feb 2012
    Location
    Somewhere, over the rainbow...
    Posts
    2,272
    Mentioned
    3 Post(s)
    Quoted
    45 Post(s)

    Default

    About time you made this tut.

    Very useful

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •