5 things that a trader should know and implement:
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 :
5 things that a trader should know and implement:
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
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
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"
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.
=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.
=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.
=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.
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.
➡️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.
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.
https://t.co/xEg2LWQ7hC
Google sheets is used by almost 99% people in the world \U0001f30e
— The Chartians (@chartians) August 9, 2022
Most people don\u2019t know how to use it for TRADING and INVESTING purposes \U0001f4d6
10 features everyone should know :
CHARTIANS LIFETIME FREE GROUP ANNOUNCEMENT!
— The Chartians (@chartians) August 8, 2022
\u26a1\ufe0f Positional option strategies [ Stock + Index ].
\u26a1\ufe0f Hero zero calls.
\u26a1\ufe0f Our High Probable Cash and Positional picks \U0001f60e
\u26a1\ufe0f Short & long term Swing bets.
\u26a1\ufe0fIndex Option Spreads for Safe players
How to Join |https://t.co/pUjh0jw1Kk pic.twitter.com/5koT8A2lEi
More from The Chartians
Do Share the above tweet 👆
These are going to be very simple yet effective pure price action based scanners, no fancy indicators nothing - hope you liked it.
https://t.co/JU0MJIbpRV
52 Week High
One of the classic scanners very you will get strong stocks to Bet on.
https://t.co/V69th0jwBr
Hourly Breakout
This scanner will give you short term bet breakouts like hourly or 2Hr breakout
Volume shocker
Volume spurt in a stock with massive X times
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
Trading on chart patterns is difficult, Until you see this:
— The Chartians (@chartians) August 6, 2022
Free Technical Analysis course (1/10) \U0001f9f5
2/ Cup and Handle:
A bullish technical pattern that is very popular in Technical
Trading on chart patterns is difficult, Until you read this ! \u26a1\ufe0f
— The Chartians (@chartians) August 21, 2022
Everything about Cup and Handle Pattern
Free Technical Analysis course (2/10) \U0001f9f5
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
Trading on chart patterns is difficult until you read this !\u26a1\ufe0f
— The Chartians (@chartians) August 28, 2022
Everything about Ascending Triangle Pattern
Free Technical Analysis course (3/10) \U0001f9f5
4/ Head and Shoulder Pattern:
It is one of several top patterns that signal an upward trend is nearing its
Trading on chart patterns is difficult, Until you read this ! \u26a1\ufe0f
— The Chartians (@chartians) October 9, 2022
Everything about Head and Shoulder Pattern
Free Technical Analysis course (4/10) \U0001f9f5
More from All
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.
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
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
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