5 things that a trader should know and implement:
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 🧵:
5 things that a trader should know and implement:
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
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
⚡️ 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"
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/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.
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:
⚡️ "Today()" = Fetch Current Date.
⚡️ "Today()-30" = Fetch 30 days back date.
⚡️ 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 price in just a few seconds, otherwise it would have taken hours.
Above data, you can use to do backtesting of any strategy.
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.
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
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
There are various Options Greeks like: Delta, Gamma, Vega, Rho, Theta.
— Yash Mehta (@YMehta_) September 4, 2022
A complete guide on how these #Option Greeks impact option price.
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
Option trading is tough but here\u2019s what can make it easier for you
— The Chartians (@chartians) September 17, 2022
8 option strategies that you can use in any market (sold as a \u20b9 50,000 course !)
3/ What are the things that you should look at before taking any Option
They say options trading can make YOU BANKRUPT - is it true ?
— The Chartians (@chartians) September 23, 2022
If yes then why ?
A thread on Risk management and Position sizing in options trading (worth 50k\u20b9 course)\U0001f9f5
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
101 guide on how you can start option selling to generate active returns with less capital (Rs 1 Lakh) \U0001f9f5:
— Yash Mehta (@YMehta_) August 19, 2022
A course on option selling available for free.
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.
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
Our Hans Kristian Andersen working with Jens H. Kuhn, Sina Bavari, Robert F. Garry, Stuart T. Nichol,Gustavo Palacios, Sheli R. Radoshitzky from USAMRIID and Fort Detrick to tell more fairy tales? Full emails listed for queries...https://t.co/kLRoQTxiGD pic.twitter.com/uHNuGraPP2
— Billy Bostickson \U0001f3f4\U0001f441&\U0001f441 \U0001f193 (@BillyBostickson) August 26, 2020
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: