It's a data connection, which literally pulls a live-updating table from the marketwatch mobile website. I've used marketwatch.com/m/, because the mobile pages are smaller and take up less space on the sheet.
Essentially, I created a new data connection to "marketwatch.com/m/Quote/TICKER", which are two columns wide, and then wrote a function which locates and pulls the Last Price from the 11th row. We'll use AAPL as the example.
1) Create tab "Ticker Quotes"
2) A1:="TICKER"
3) A2:="$LAST"
4) Select & Merge B1+C1: [alt], [h], [m], [m].
5) Select & Merge B2+C2: ''
6) B2+B3:="AAPL"
7) Select B3, Open & Import a Data Connection from Web: [alt], [a], [f], [w]
8) In "New Web Query" pane, browse to marketwatch.com/m/Quote/AAPL, and Click on the Yellow and Black Arrow in the upper right corner of the page (to select the entire page for import), and then Import.
9) Excel will confirm that you want to pull the data to the selected cell: [enter]
10) If you look at B11, it should read along the lines of "Last: $624.31 ( -5.01, -0.80%)". I wrote a function that locates the price in this string of text; it looks for the first "." character in the string, and then truncates two character spaces to the right, and then strips the first six character spaces, leaving only the quote, in dollars. For the ticker data imported to cell B3, the formula is B2:=1*RIGHT(LEFT(B11,FIND(".",B11)+2),FIND(".",B11)-5)
