How to Add Stock and Open Price in Google Sheets
If you just want to keep a simple trading sheet—like a list of stocks and their opening prices—Google Sheets makes it very easy.
1. Open Google Sheets
Go to Google Sheets and create a new blank sheet.
2. Make a Simple Table
Create two column headings:
A1: Stock
B1: Open Price
3. Enter a Stock Symbol
In column A, type the exchange and stock code.
Example for Reliance (NSE):
NSE:RELIANCE
4. Get the Open Price
In column B, use the GOOGLEFINANCE formula:
=GOOGLEFINANCE(A2,"open")
- A2 is the cell where you typed the stock code.
"open"tells Sheets to pull today’s opening price.
5. Add More Stocks
Repeat the same steps in new rows:
A3: NSE:TCS
B3: =GOOGLEFINANCE(A3,"open")Add Stocks
| A (Stock) | B (Open Price) |
|---|---|
| NASDAQ:AAPL | (leave blank for now) |
- NASDAQ:AAPL is the ticker symbol for Apple on the NASDAQ exchange.
Step 2: Enter the Formula
In the Open Price cell (same row), type:
=GOOGLEFINANCE(A3,"open")
(Replace A3 with the correct cell if your sheet uses a different row.)
Step 3: Result
Google Sheets will fetch today’s opening price of Apple stock and show it automatically.