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

You might be using chart patterns incorrectly if you've not seen this.

Data says 81% of people trade these patterns incorrectly, and you might be one of them.

Read now or regret later:: A complete guide on Top 5 chart patterns in this thread 🧵:

1/ Rounding Bottom:

Rounding Bottom or U Pattern or Saucer all are one and the same with different names and it is a bullish


2/ Cup and Handle:

A bullish technical pattern that is very popular in Technical


3/ Ascending Triangle:

Ascending triangle is created by price moves that allow for a horizontal line to be drawn along the swing highs and a rising trendline to be drawn along the swing


4/ Head and Shoulder Pattern:

It is one of several top patterns that signal an upward trend is nearing its

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.
ChatGPT is a phenomenal AI Tool.

But don't limit yourself to just ChatGPT.

Here're 8 AI-powered tools you should try in 2023:

1. KaiberAI

@KaiberAI helps you generate beautiful videos in minutes.

Transform your ideas into the visual stories of your dreams with this Amazing Tool.

New features:
1. Upload your custom music
2. Prompt Templates
3. Camera Movements:

Check here

https://t.co/ivnDRf628L


2. @tldview TLDV

Best ChatGPT Alternative for meetings.

Make your meetings 10X more productive with this amazing tool.

Try it now:

https://t.co/vOy3sS4QfJ


3. ComposeAI

Use ComposeAI for generating any text using AI.

It’s will help you write better content in seconds.

Try it here:

https://t.co/ksj5aop5ZI


4. Browser AI

Use this AI tool to extract and monitor data from any website.

Train a robot in 2 minutes to do your work.

No coding required.

https://t.co/nNiawtUMyO

You May Also Like

Department List of UCAS-China PROFESSORs for ANSO, CSC and UCAS (fully or partial) Scholarship Acceptance
1) UCAS School of physical sciences Professor
https://t.co/9X8OheIvRw
2) UCAS School of mathematical sciences Professor

3) UCAS School of nuclear sciences and technology
https://t.co/nQH8JnewcJ
4) UCAS School of astronomy and space sciences
https://t.co/7Ikc6CuKHZ
5) UCAS School of engineering

6) Geotechnical Engineering Teaching and Research Office
https://t.co/jBCJW7UKlQ
7) Multi-scale Mechanics Teaching and Research Section
https://t.co/eqfQnX1LEQ
😎 Microgravity Science Teaching and Research

9) High temperature gas dynamics teaching and research section
https://t.co/tVIdKgTPl3
10) Department of Biomechanics and Medical Engineering
https://t.co/ubW4xhZY2R
11) Ocean Engineering Teaching and Research

12) Department of Dynamics and Advanced Manufacturing
https://t.co/42BKXEugGv
13) Refrigeration and Cryogenic Engineering Teaching and Research Office
https://t.co/pZdUXFTvw3
14) Power Machinery and Engineering Teaching and Research
Moderna CEO Stephane Bancel was previously CEO of bioMerieux in France from 07-10.

Alain Merieux, who owns bioMerieux, was instrumental in the creation of the Wuhan Institute of Virology P4 Lab.

The same people who helped create the virus, also helped to create the vaccines...


Moderna partnered with French Pasteur Institute in 2015 to develop mRNA vaccine technology.

Pasteur Institute partnered with the Wuhan P4 Laboratory in 2017 along with the Merieux Foundation to study emerging viruses...
https://t.co/yFsHwrNYaK
https://t.co/9M5lydBKhM


Nobel prize winning scientist Luc Montagnier asserts that Sars-Cov-2 is man-made and originated from the Wuhan Institute of Virology.

Montagnier did extensive work with the Pasteur Institute in France which was partnered with the Wuhan P4.

Merieux Foundation & the Chinese government have worked together since 1965, and partnered to study emerging pathogens in Africa in 2015.

Their research included "PATHOGENS CARRIED BY BATS" that provoke respiratory diseases.

🚨🚨🚨
https://t.co/gVwpT0ssqI