Mandar Oak
by Mandar Oak
2 min read

Categories

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 <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004076491354112/photo/1’</p></div>

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

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

  2. 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.
  3. 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. <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004094031953922/photo/1’</p></div>

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. <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004102739296258/photo/1’</p></div>

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. <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004113430589441/photo/1’</p></div>

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. <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004130685956096/photo/1’</p></div>

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. <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004150382428160/photo/1’</p></div>

➡️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. <div class='jekyll-twitter-plugin'><p>There was a ‘Not Found’ error fetching URL: ‘https://twitter.com/chartians/status/1557004161585389568/photo/1’</p></div>

If you liked this then do like and retweet the initial tweet :

@threadreaderapp unroll <div class='jekyll-twitter-plugin'><blockquote class="twitter-tweet"><p lang="en" dir="ltr">If you liked this then do like and retweet the initial tweet : https://t.co/xEg2LWQ7hC</p>— The Chartians (@chartians) August 9, 2022</blockquote>

</div>