+ Reply to Thread
Results 1 to 2 of 2

WebService Formula (Or other solution) to pull in prices from Amazon

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    Midwest
    MS-Off Ver
    2013
    Posts
    2

    WebService Formula (Or other solution) to pull in prices from Amazon

    I'd like to use the WebService formula or other solution (VBA and PowerQuery included) to pull in the price for an Amazon item. I'd like the formula to go to my chosen item's URL (let's have it be hardcoded for now) and return the price.

    Desired output on worksheet:
    Item | Price
    Scarf| $5
    Hat | $10
    Etc.


    I currently have a similar setup to pull in a stock price from Yahoo Finance. For example, the webservice formula would look like this to get the Microsoft stock price at the current moment: =WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s="&"MSFT"&"&f=l1")

    Any Ideas?

    Thanks in advance for any help.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: WebService Formula (Or other solution) to pull in prices from Amazon

    https://search.yahoo.com/search;_ylt...fr=yfp-t-339-s

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. WebService Formula (Or other solution) to pull in prices from Amazon
    By kazoli in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-13-2015, 05:40 PM
  2. Replies: 2
    Last Post: 06-15-2015, 01:48 AM
  3. Pull Share (Stock) Prices from Yahoo! Finance
    By DJB in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2015, 09:13 AM
  4. [SOLVED] Excel VBA To Pull Item Prices for Multiple Suppliers
    By CHRISEWRIGHT20 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-29-2012, 06:02 PM
  5. [SOLVED] Extracting latest prices from a price book with past and present prices
    By benoj2005 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-10-2012, 04:08 AM
  6. Replies: 15
    Last Post: 01-19-2011, 11:37 PM
  7. Replies: 1
    Last Post: 10-07-2005, 11:05 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1