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
Over 99% of the option traders lose money in option trading because of not following proper Risk Management and Position Sizing.
In this thread 🧵, shared three steps that can help you in Option Trading even with small capital.
A complete course worth ₹ 50K for free.
1/ Creating a view based on some analysis:
It can be Technical/Chart, Option Chain or some Data analysis.
We have written a thread last week on what all the basic strategies you can use based on your view.
Checkout the thread
Now, after forming a view on a stock or index, don't directly jump to take the position.
Analyze the position first.
Some free tools that you can use are:
- Opstra
- @BeSensibull : Integrated with your Broker
We will talk on how to analyze Nifty Option trades from option selling perspective and what all things to look at.
Same thing you can replicate for Stock or Banknifty Options as well.
2/ Analyzing the position:
Let's say I am having bullish view on Nifty, then I can simply short Put Options and Hedge it as well so that margin requirement will reduce.
Let's assume Nifty is at 17000.
So I am looking to short 17000 PE and Buying 17800 PE.
In this thread 🧵, shared three steps that can help you in Option Trading even with small capital.
A complete course worth ₹ 50K for free.
1/ Creating a view based on some analysis:
It can be Technical/Chart, Option Chain or some Data analysis.
We have written a thread last week on what all the basic strategies you can use based on your view.
Checkout the thread
Option trading is tough as there are many strategies based on different market view.
— Yash Mehta (@YMehta_) September 30, 2022
Sharing 6 basic Option Strategies for free that you can use based on different market view (sold as a \u20b9 25,000 course!).
A thread \U0001f9f5:
Now, after forming a view on a stock or index, don't directly jump to take the position.
Analyze the position first.
Some free tools that you can use are:
- Opstra
- @BeSensibull : Integrated with your Broker
We will talk on how to analyze Nifty Option trades from option selling perspective and what all things to look at.
Same thing you can replicate for Stock or Banknifty Options as well.
2/ Analyzing the position:
Let's say I am having bullish view on Nifty, then I can simply short Put Options and Hedge it as well so that margin requirement will reduce.
Let's assume Nifty is at 17000.
So I am looking to short 17000 PE and Buying 17800 PE.
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
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
You May Also Like
🌿𝑻𝒉𝒆 𝒔𝒕𝒐𝒓𝒚 𝒐𝒇 𝒂 𝑺𝒕𝒂𝒓 : 𝑫𝒉𝒓𝒖𝒗𝒂 & 𝑽𝒊𝒔𝒉𝒏𝒖
Once upon a time there was a Raja named Uttānapāda born of Svayambhuva Manu,1st man on earth.He had 2 beautiful wives - Suniti & Suruchi & two sons were born of them Dhruva & Uttama respectively.
#talesofkrishna https://t.co/E85MTPkF9W
Now Suniti was the daughter of a tribal chief while Suruchi was the daughter of a rich king. Hence Suruchi was always favored the most by Raja while Suniti was ignored. But while Suniti was gentle & kind hearted by nature Suruchi was venomous inside.
#KrishnaLeela
The story is of a time when ideally the eldest son of the king becomes the heir to the throne. Hence the sinhasan of the Raja belonged to Dhruva.This is why Suruchi who was the 2nd wife nourished poison in her heart for Dhruva as she knew her son will never get the throne.
One day when Dhruva was just 5 years old he went on to sit on his father's lap. Suruchi, the jealous queen, got enraged and shoved him away from Raja as she never wanted Raja to shower Dhruva with his fatherly affection.
Dhruva protested questioning his step mother "why can't i sit on my own father's lap?" A furious Suruchi berated him saying "only God can allow him that privilege. Go ask him"
Once upon a time there was a Raja named Uttānapāda born of Svayambhuva Manu,1st man on earth.He had 2 beautiful wives - Suniti & Suruchi & two sons were born of them Dhruva & Uttama respectively.
#talesofkrishna https://t.co/E85MTPkF9W
Prabhu says i reside in the heart of my bhakt.
— Right Singh (@rightwingchora) December 21, 2020
Guess the event. pic.twitter.com/yFUmbfe5KL
Now Suniti was the daughter of a tribal chief while Suruchi was the daughter of a rich king. Hence Suruchi was always favored the most by Raja while Suniti was ignored. But while Suniti was gentle & kind hearted by nature Suruchi was venomous inside.
#KrishnaLeela
The story is of a time when ideally the eldest son of the king becomes the heir to the throne. Hence the sinhasan of the Raja belonged to Dhruva.This is why Suruchi who was the 2nd wife nourished poison in her heart for Dhruva as she knew her son will never get the throne.
One day when Dhruva was just 5 years old he went on to sit on his father's lap. Suruchi, the jealous queen, got enraged and shoved him away from Raja as she never wanted Raja to shower Dhruva with his fatherly affection.
Dhruva protested questioning his step mother "why can't i sit on my own father's lap?" A furious Suruchi berated him saying "only God can allow him that privilege. Go ask him"
The entire discussion around Facebook’s disclosures of what happened in 2016 is very frustrating. No exec stopped any investigations, but there were a lot of heated discussions about what to publish and when.
In the spring and summer of 2016, as reported by the Times, activity we traced to GRU was reported to the FBI. This was the standard model of interaction companies used for nation-state attacks against likely US targeted.
In the Spring of 2017, after a deep dive into the Fake News phenomena, the security team wanted to publish an update that covered what we had learned. At this point, we didn’t have any advertising content or the big IRA cluster, but we did know about the GRU model.
This report when through dozens of edits as different equities were represented. I did not have any meetings with Sheryl on the paper, but I can’t speak to whether she was in the loop with my higher-ups.
In the end, the difficult question of attribution was settled by us pointing to the DNI report instead of saying Russia or GRU directly. In my pre-briefs with members of Congress, I made it clear that we believed this action was GRU.
The story doesn\u2019t say you were told not to... it says you did so without approval and they tried to obfuscate what you found. Is that true?
— Sarah Frier (@sarahfrier) November 15, 2018
In the spring and summer of 2016, as reported by the Times, activity we traced to GRU was reported to the FBI. This was the standard model of interaction companies used for nation-state attacks against likely US targeted.
In the Spring of 2017, after a deep dive into the Fake News phenomena, the security team wanted to publish an update that covered what we had learned. At this point, we didn’t have any advertising content or the big IRA cluster, but we did know about the GRU model.
This report when through dozens of edits as different equities were represented. I did not have any meetings with Sheryl on the paper, but I can’t speak to whether she was in the loop with my higher-ups.
In the end, the difficult question of attribution was settled by us pointing to the DNI report instead of saying Russia or GRU directly. In my pre-briefs with members of Congress, I made it clear that we believed this action was GRU.
First thread of the year because I have time during MCO. As requested, a thread on the gods and spirits of Malay folk religion. Some are indigenous, some are of Indian origin, some have Islamic
Before I begin, it might be worth explaining the Malay conception of the spirit world. At its deepest level, Malay religious belief is animist. All living beings and even certain objects are said to have a soul. Natural phenomena are either controlled by or personified as spirits
Although these beings had to be respected, not all of them were powerful enough to be considered gods. Offerings would be made to the spirits that had greater influence on human life. Spells and incantations would invoke their
Two known examples of such elemental spirits that had god-like status are Raja Angin (king of the wind) and Mambang Tali Arus (spirit of river currents). There were undoubtedly many more which have been lost to time
Contact with ancient India brought the influence of Hinduism and Buddhism to SEA. What we now call Hinduism similarly developed in India out of native animism and the more formal Vedic tradition. This can be seen in the multitude of sacred animals and location-specific Hindu gods
i wonder if you can make a thread bout witchcraft in malaysia.. or list of our own local gods/deites..
— r a y a \U0001f319 (@lcvelylilith) February 20, 2020
Before I begin, it might be worth explaining the Malay conception of the spirit world. At its deepest level, Malay religious belief is animist. All living beings and even certain objects are said to have a soul. Natural phenomena are either controlled by or personified as spirits
Although these beings had to be respected, not all of them were powerful enough to be considered gods. Offerings would be made to the spirits that had greater influence on human life. Spells and incantations would invoke their
Animist ceremonies of a religious or magical nature were normally held for the purpose of divination or making a request. This would either be done at a keramat or at a shrine similar to the Thai spirit houses or Chinese roadside shrines pic.twitter.com/I1hliyi0x3
— \u2745\u1710\u170b\u1713\u170e (@uglyluhan) June 16, 2019
Two known examples of such elemental spirits that had god-like status are Raja Angin (king of the wind) and Mambang Tali Arus (spirit of river currents). There were undoubtedly many more which have been lost to time
Contact with ancient India brought the influence of Hinduism and Buddhism to SEA. What we now call Hinduism similarly developed in India out of native animism and the more formal Vedic tradition. This can be seen in the multitude of sacred animals and location-specific Hindu gods