With the Google Finance function, you can easily extract stock ticker information, display it on the worksheet, and then chart as necessary.
