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.
Bookmarks