Excel Stock Quotes Template. To get started, you need either a valid excel price feed trial or subscription (if you have neither then you can start a free 10 day trial by pressing the big yellow button at the top of the page). You can enter up to 10 tickers and select a metric like opening price, closing price, or trading volume for the selected securities.
Enter company names or stock codes. It's as easy as typing text into a cell and converting it to the stocks data type. With the cell still selected, open the “data” tab, and then click “stocks” in the “data types” section of the ribbon.