Google sheets is used by almost 99% people in the world 🌎

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

10 features everyone should know :

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])

Above function is a basic one.

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

"NSE: RELIANCE" is the ticker for Reliance Industries

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

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

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

4. 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.

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