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 🧵:

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])

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

⚡️ Attribute:

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

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

⚡️ 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"

Visa Market Share - 52.6%
Amex Market Share - 19.6%

Visa Revenue 2022 - $29.3 B
Amex Revenue 2022 - $50.6 B

What is the secret of American Express?

Visa/Mastercard are card networks. Their main role is information sharing. When you swipe your card at a POS Machine, how does your credit card issuer know which merchant to transfer the money to?

Your card doesn’t individually maintain a record of all merchants who can accept credit cards.

Instead it ties up with a card network e.g. Visa/MasterCard. Any merchant that has Visa as a network service provider can accept payments from a Visa card.

When the merchant’s bank (acquiring bank) is registered on the card network, the network is completed. Card networks save banks the hassle of onboarding each merchant and maintaining the infrastructure.

Let us see how a typical credit card transaction works.

There are 3 steps - Authorization, authentication and settlement.

You're not using the Notes app on your iPhone to its full potential.

8 features you might not know about:

1. Scan documents and add them as PDFs to your note:

1. Click on the photo icon
2. Select scan documents
3. Scan your documents and click save

You now have a pdf in your note that is searchable:

2. Copy and paste text from a physical document into your note:

1. Click on the photo icon
2. Select scan text
3. Locate your text and click insert

Your text is now in your note as if you had written it manually.

3. Enable the power of Quick Notes:

Go to Settings > Control Centre and add Quick Note

You can now add a note from everywhere by swiping down in the right corner and tapping the Quick Note button. It also saves the context, displaying the note if you visit an URL you've saved.

4. Collaborate on a to-do or shopping list with ease:

1. Create your list
2. Click the share button
3. Make sure Collaborate is selected
4. Share the link with another user

Your list now syncs across your devices!

I have spent the last couple of years thinking quite a bit about health. Experimenting with myself and our team, and supporting startups that are trying to help Indians make healthier choices.

A few thoughts on how and why you should focus on your health. 1/9

In chasing money goals, it is easy to forget that all the money in the world can’t buy good health. As we grow older, our health determines the quality of life, not money.
Good health also means the ability to bounce back faster if unforeseen incidents occur. 2/9

Health goals should be about how you feel, not how you look. Wanting to look a certain way, influenced by celebs and influencers who fake it with lights and photography, use performance-enhancing drugs, or hit the genetic lottery, is a recipe for unhappiness. 3/9

Sitting is the new smoking. Setting simple activity goals in terms of how much I move (calories burnt) and reminders to stand up every 45 mins has had the most impact on me. The current health challenge in Zerodha is to set a daily activity goal & try reaching 90% of the time 4/9

Sleeping by 9 pm & getting a workout at 5 am has been helpful. Sleeping early reduces the chances of bingeing when we are drained and have low self-control at the end of the day. A workout in the morning also increases the odds of making healthier choices throughout the day. 5/9

Google Drive has 1,000,000,000+ active users.

But only a few use the platform effectively.

Here are 9 tips that you'll wish you knew sooner:

1. Search within images

A simple search for word image has, it will fetch you appropriate images.

It even recognizes the text in images.

2. Open PDF and text images as a text document

It is annoying when you get documents that you have to edit in PDF formats.

A hidden Google Drive hack solves this problem.

Upload the PDF or image file in Google Drive and open it with Google Docs.

3. Use the activity pane to get a history of all the changes

The activity pane allows you to keep an eye on all the changes made to a file by anyone.

To view this, select the file or folder and press ‘i’ on your keyboard or the ‘i’ icon on the top left of the home screen.

4. Create a force copy link

Force copy link enables the copy of the file to retain the source file in its original location.

All you need to do is copy the link to the original file in the browser.

Replace the text after the last slash with the word "copy"

Over the last 18 months, I have scaled my income to around ₹10,00,000 or 10 lakhs per week with drawdowns below 10%.

How?

@niki_poojary taught me how to form a weekly trading plan.

I'm going to share what I've learned in this thread.

Here's the simple 10 step process: 🧵

1. Check on the daily chart if Bank Nifty is in a higher high or lower low:

A higher-high (HH) is a bullish pattern, it signifies that it is difficult for the market to go down.

If that has formed on the daily chart, the market will give all the surprises on the upside.

If the market is in a higher high mode, look for good opportunities to sell puts.

Usually, at a higher high, traders buy on breakouts and also buy the dips.

If you want a good Risk-Reward, you can sell puts on a dip. (Only if it's showing some reversal)

2. Take High Probability Trades

Simply knowing a higher high or lower low does not make money. It gives you a bias for the week.

Still, you should try to take higher probability trades that align with your view of the market.

This will get you consistency and a good mindset.

3. Support & Resistance

I would say Support Resistance is the most important and favorite thing for @niki_poojary.

She keeps updating these levels with charts on her Twitter handle during live markets daily.

Attaching some examples will do a detailed thread on this later.

Stop wasting hours choosing platforms to use.

Charting: @tradingview
Strategy Builder: @opstra
Historical Data: @iChartsIndia
Basics: @ZerodhaVarsity
Scanners: @ChartinkConnect
Events: @Investingcom

Start working.

Do you want to know how to create a Trading Plan using only Price Action?

Here's a breakdown of 11 simple yet powerful steps to create one: 🧵

Collaborated with @AdityaTodmal

1/ Know your type:

First and foremost, understand whether you are a Scalper or Intraday trader or Swing trader or Positional Trader.

Create an account in @tradingview

2/ Set the Time Frame (TF) of the Charts:

• Scalper: the TF you would use would be in the range of 1- 5min
• Intraday Trader: 5-15min TF
• Swing Trader: Hourly to Daily
• Positional Trader: Weekly

3/ Be aware of the trend at higher TF.

No matter which type of trader you are, its important to know the trend at higher TF.

Crucial to know whether its a buy on dip market or sell on rise market.

In my outlook for the week for #BANKNIFTY & #NIFTY I cover multi TF analysis.

4/ Identify the major Demand & Supply Zone:

• A supply zone is the price area where traders have the highest selling interest or potential.

• A demand zone is the price area where the traders have the highest buying interest or potential.

Tradingview is one of the most trusted and used web application by traders across the world.

10 hacks that'll get you features of @tradingview premium version for free:🧵

Collaborated with @AdityaTodmal

1/ Free Multi Timeframe Analysis:

Step 1. Download Vivaldi Browser

Step 2. Login to trading view

Step 3. Open bank nifty chart in 4 separate windows

Step 4. Click on the first tab and shift + click by mouse on the last tab.

Step 5. Select "Tile all 4 tabs"

The best part about this is this is absolutely free to do.

Check out this video if you are still unable to figure it

2/ Create Free Multiple Watchlists:

Step 1: Download @TradingView app on your mobile phone, and login.

Step 2: Now create watchlists eg: World Indices, Banking Stocks, NIFTY50 stocks etc.

Step 3: Now go back to your tradingview web browser and click on refresh and you will see the watchlist names on the web browser.

Step 4: Now simply add names in your watchlist on the web browser by clicking on the plus sign.

Some people think technical analysis is useless. But we use technical analysis in all our trades.

Here's a list of 13 technical analysis books to help you learn and grow: 🧵

Collaborated with @AdityaTodmal

1/ Stan Weinstein's Secrets for Profiting in Bull and Bear Markets.

The ideal time to buy/sell, using the best long-term indicators to spot Bull and Bear markets Odds.

Author: Stan

2/ Trade Like a Stock Market Wizard: How to Achieve Super Performance in Stocks in Any Market.

Selecting precise entry/exit points, preserving profits, and getting consistent 3 digit returns.

Author: Mark

3/ Think & Trade Like a Champion: The Secrets, Rules & Blunt Truths of a Stock Market Wizard How to develop the confidence to achieve super performance.

This is a follow-up book for trade like a stock market wizard.

Author: Mark

4/ Trading in the zone.

The author analyses from a psychological perspective the most common issues related to trading.

Author: Michael

Here is the list of Top 5 Free Advanced Technical Indicators that you can use in @tradingview for your trading 🧵:

Few of these indicators are designed by me.

Also, the last indicator is one of my favourite to pick early momentum stocks.

1/ CPR:

It is a popular indicator of the trading community. One can try it for Nifty and Banknifty futures and options

2/ Relative Strength (RS):

This indicator helps in identifying stocks that are showing strength against benchmark (Nifty or any Index). It can help you to hold and ride the

3/ Ratio Chart:

This plots ratio chart of two stocks or index, e.g. Reliance/Nifty.
It is the same as Relative Strength, and you can use PA on the ratio chart to pick momentum stocks

4/ NIMBLR F2F Momentum & Indecisive Candle Finder:

This is based on F2F interview of @Deishma.
This indicator helps you to identify momentum and indecisive candle as discussed in the F2F.

F2F Link:

*MEGA THREAD ON SHORT STRANGLES* 🧵

This thread is a step-by-step guide on what I have learned trading Short Strangles.

Collaborated with @niki_poojary

Here's what you'll learn in this thread:

1. What is a Strangle
2. Benefits and Drawbacks
3. How to extract more profit through strangles?
4. How to adjust them when in loss?
5. Videos on Positional Strangles
6. Vix Correlation

Let's dive in ↓

1/ What is a Strangle?

Selling OTM CE & OTM PE of the same instrument you are trading.

Look at the picture below for an example of a short strangle in current weekly options.

2/ Why do traders like short strangles?

The highest probability of profit is there in a strangle.

By mastering this technique you can earn a consistent weekly income.

Most of the times we can predict the weekly range.

So sell options outside this range to profit consistently.

3/ Benefits of Short Strangles

Higher probability - More than 80% winning chance

Can turn directional too - If your SL hits on one side can sell on the opposite side and make it directional.

The biggest range of profit you'll get in options of any expiry.

I don't want to remember this day as a sad day

Yes, RJ passed away but this will clip will always be there in my heart which shows how happy he was.