Quote from marketxls.com:
How do you automatically update stock prices in Excel?
You can either use streaming functions to stream real time prices inside excel automatically, or you can use =qm_last(symbol) functions and press refresh button at the top left corner of marketxls to update the stock price in excel.