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"
1/ Fetching Stock Price Live

GOOGLEFINANCE("NSE:TCS","PRICE")

This function will help you in fetching stock price live.

Make sure you mention exchange and ticker code properly.
Attribute can be price or any of the above attribute.
2/ Fetching Stock Price of any particular date:

=GOOGLEFINANCE("TCS","PRICE", "01/02/2022")

This function will fetch the TCS stock price as on 1st Feb 2022.

Output is shown in the image below image.
3/ Fetching Stock Price for an interval:

=GOOGLEFINANCE("NSE:TCS","price","01/01/2022","15/01/2022")

This will fetch Trent Daily Stock Price from 1st June to 15th June 2022.

Output is shown in the image below image.
4/ Fetching Stock Price for an interval on weekly basis:

=GOOGLEFINANCE("NSE:Tcs","price","01/10/2021","15/01/2022", "Weekly")

This will fetch Trent Weekly Stock Price from 1st Oct to 15th Jan 2022.

Output is shown in the image below image.
5/ These were the Google Finance functions for stocks.

Some basic function which you can use are:
1. "Today()" = Fetch Current Date.
2. "Today()-30" = Fetch 30 days back date.
3. EDATE("01/02/2022",-3) = Fetch 3 months back date.
How you can use this Google Sheet in your trading?

➡️Track all your open and close position just like how we are doing this for years.

➡️If you monitor your closed position, then you can create a graph of your capital and NAV/Equity Curve easily.
➡️Pull out entire data of any stock or index for any particular duration automatically.

In the image, we are fetching the last 7 years' data of TCS stock price in just a few seconds, otherwise it would have taken hours.

Above data, you can use to do backtesting of any strategy.
If you liked this then do like and retweet the initial tweet :

https://t.co/xEg2LWQ7hC
More about our free lifetime group: https://t.co/bMyEe5HXjr

More from The Chartians

Here are the compilation of free educational contents we shared till now.

Kindly RETWEET and LIKE if you feel our efforts adding to your knowledge.


🩸Types of


🩸 Detailed guide on TX, a free trading tool by


🩸 Fibonacci retracement and golder ratio - Part


🩸 Fibonacci retracement and golden ratio - Part

More from All

You May Also Like

I think a plausible explanation is that whatever Corbyn says or does, his critics will denounce - no matter how much hypocrisy it necessitates.


Corbyn opposes the exploitation of foreign sweatshop-workers - Labour MPs complain he's like Nigel

He speaks up in defence of migrants - Labour MPs whinge that he's not listening to the public's very real concerns about immigration:

He's wrong to prioritise Labour Party members over the public:

He's wrong to prioritise the public over Labour Party