Is it possible to make a cell reference a live stock price

[nva2k4]

Hi Guys,

Is it possible to make a cell reference a current stock price and continue to update the price as it fluctuates? If not, is it possible to import the latest stock price if I create a command button? I would like the command button to import the latest stock price every time I hit the button.

I have attached a sample excel table to reference that was created in Excel 2013. I would like C2:C8 to automatically update when I have the sheet open and continue to update as long as it is open. If that is not possible, I can create a command button that will pull the latest price from yahoo finance or something and enter them into C2:C8 every time I hit the button.

Thank you for your help.

Book1.xlsx

[mikeTRON]

You can force it to update very frequently, or when you push a button.

You can also use PowerQuery (formerly known as Data Explorer).
http://datapigtechnologies.com/blog/...data-explorer/