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

MASTER THREAD on Short Strangles.

Curated the best tweets from the best traders who are exceptional at managing strangles.

• Positional Strangles
• Intraday Strangles
• Position Sizing
• How to do Adjustments
• Plenty of Examples
• When to avoid
• Exit Criteria

How to sell Strangles in weekly expiry as explained by boss himself. @Mitesh_Engr

• When to sell
• How to do Adjustments
• Exit


Beautiful explanation on positional option selling by @Mitesh_Engr
Sir on how to sell low premium strangles yourself without paying anyone. This is a free mini course in


1st Live example of managing a strangle by Mitesh Sir. @Mitesh_Engr

• Sold Strangles 20% cap used
• Added 20% cap more when in profit
• Booked profitable leg and rolled up
• Kept rolling up profitable leg
• Booked loss in calls
• Sold only


2nd example by @Mitesh_Engr Sir on converting a directional trade into strangles. Option Sellers can use this for consistent profit.

• Identified a reversal and sold puts

• Puts decayed a lot

• When achieved 2% profit through puts then sold

You May Also Like

1. Project 1742 (EcoHealth/DTRA)
Risks of bat-borne zoonotic diseases in Western Asia

Duration: 24/10/2018-23 /10/2019

Funding: $71,500
@dgaytandzhieva
https://t.co/680CdD8uug


2. Bat Virus Database
Access to the database is limited only to those scientists participating in our ‘Bats and Coronaviruses’ project
Our intention is to eventually open up this database to the larger scientific community
https://t.co/mPn7b9HM48


3. EcoHealth Alliance & DTRA Asking for Trouble
One Health research project focused on characterizing bat diversity, bat coronavirus diversity and the risk of bat-borne zoonotic disease emergence in the region.
https://t.co/u6aUeWBGEN


4. Phelps, Olival, Epstein, Karesh - EcoHealth/DTRA


5, Methods and Expected Outcomes
(Unexpected Outcome = New Coronavirus Pandemic)