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"
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/06/2022","15/06/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:

⚡️ "Today()" = Fetch Current Date.
⚡️ "Today()-30" = Fetch 30 days back date.
⚡️ 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 price in just a few seconds, otherwise it would have taken hours.

Above data, you can use to do backtesting of any strategy.
⚡️ Create your money or risk management tool on Google Sheet:

This is how you can create your own Risk Management Google Sheet with basic functions.

Based on risk % per trade, it will automatically calculate the quantities that you can buy in a stock.
These are the best features of Google Sheet that a trader should try out in their trading and analysis.

If you found this useful, please RT the first tweet.

For live trading and stock market related updates, you can join our Telegram Channel⤵️

https://t.co/RblJ0wWKCv

More from Yash Mehta

Option Trading is very difficult to master as there are so many things to understand.

Here is a master thread related that will help a beginner to understand about Options Trading.

A complete course worth Rs 50K for free.

1/ A detailed thread on basics of Option Greeks and how it impacts Options


2/ Basic Option Trading Strategies:

There are many option strategies to trade. But keeping your strategy simple is the key.

In this thread, all the basic option trading strategies are being


3/ What are the things that you should look at before taking any Option


4/ Is Option Selling Possible with Rs 1 Lakh Capital?

Even a beginner can start trading in option selling with capital as low as Rs 1 Lakh.

What are the techniques one can use and how to mitigate the infinite loss risk is shared in this

More from All

https://t.co/6cRR2B3jBE
Viruses and other pathogens are often studied as stand-alone entities, despite that, in nature, they mostly live in multispecies associations called biofilms—both externally and within the host.

https://t.co/FBfXhUrH5d


Microorganisms in biofilms are enclosed by an extracellular matrix that confers protection and improves survival. Previous studies have shown that viruses can secondarily colonize preexisting biofilms, and viral biofilms have also been described.


...we raise the perspective that CoVs can persistently infect bats due to their association with biofilm structures. This phenomenon potentially provides an optimal environment for nonpathogenic & well-adapted viruses to interact with the host, as well as for viral recombination.


Biofilms can also enhance virion viability in extracellular environments, such as on fomites and in aquatic sediments, allowing viral persistence and dissemination.
1. Mini Thread on Conflicts of Interest involving the authors of the Nature Toilet Paper:
https://t.co/VUYbsKGncx
Kristian G. Andersen
Andrew Rambaut
Ian Lipkin
Edward C. Holmes
Robert F. Garry

2. Thanks to @newboxer007 for forwarding the link to the research by an Australian in Taiwan (not on

3. K.Andersen didn't mention "competing interests"
Only Garry listed Zalgen Labs, which we will look at later.
In acknowledgements, Michael Farzan, Wellcome Trust, NIH, ERC & ARC are mentioned.
Author affiliations listed as usual.
Note the 328 Citations!
https://t.co/nmOeohM89Q


4. Kristian Andersen (1)
Andersen worked with USAMRIID & Fort Detrick scientists on research, with Robert Garry, Jens Kuhn & Sina Bavari among


5. Kristian Andersen (2)
Works at Scripps Research Institute, which WAS in serious financial trouble, haemorrhaging 20 million $ a year.
But just when the first virus cases were emerging, they received great news.
They issued a press release dated November 27, 2019:

You May Also Like