Use the Google Finance Function to pull live market data into Sheets from the internet. Very useful to help you build sheets with shares of your interest.
Here is a video tutorial for the same: