Google Sheet is a powerful tool and over 2 billion people use it in the world 🌎

Most people don’t know how to use it for TRADING and INVESTING purposes 📖

Top Google Sheet features every trader should know in this thread 🧵:

How you can use some secret features of Google Sheet and Google Finance in your trading together?

5 things that a trader should know and implement:

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

The above function is a basic one.

Let's decode each parameter in this:
⚡️ Ticker: This is the symbol of the stock.

"NSE: RELIANCE" is the ticker for Reliance Industries

⚡️ Attribute:

The attribute to fetch about ticker from Google Finance and is required if a date is specified.

The following data can be fetched:
-Open
-Close
-High
-Low
-Volume
-Market Cap
-Price (Ltp)
-52-week high
-52-week low
-Change in price

⚡️ Start_Date (Optional): The start date when fetching historical data.

⚡️ End_Date|Num_Days (O): The end date when fetching historical data, or the number of days from start_date for which to return data.

⚡️ Interval (O): The frequency of returned data; either "D" or "W"