FREE Stock Lookup in Google Sheets

Description
This template will show price and other key information about a stock of your choice. All you need to enter is the stock (the exchange code and the ticker symbol corresponding to a stock).


Below, we shall see the following details covered:

Features of the Stock Lookup template
Formulas in Google Sheets for Stocks


Stock Lookup Template features
Type a Stock Exchange code and Ticker symbol to see relevant info. In the below screenshot, I have entered the same for Apple Inc for the NASDAQ exchange.
Once these are entered, the template automatically populates key details about the stock.



The template shows the information in different sections

1. About the Company and its name
2. Details of the Currency
3. Latest Price and Change in price
4. Latest day Price range
5. Market Cap and P/E
6. Price history in the 52 weeks
7. Shares outstanding and trade volume
8. Time that the data represents
   I have entered an offset of -7 hours from UTC to arrive at pacific time.
   Please use this link (savvytime.com) if you need to know how many hours ahead or behind. If you are ahead, enter positive number. If behind enter negative number.


You can change the Exchange code and Ticker symbol and immediately view the information for a stock of your choice.