#NIFTY Blueline is 20M EMA. One of key support in uptrend. From Sept'18 (peak) and Feb'16 (bottom), current NIFTY CAGR: 8.7% and 14.8%. Same in Oct'21, 16% and 21%. If stays at these levels for 1 year, 4.5 year CAGR will be 6.7%. Something to chew on reversion to mean

So, above Rs 250 Cr market cap (thats where I like to play mostly), out of 1168 companies:

> 40% correction : 6% companies
> 30% correction : 18% companies
> 20% correction : 45% companies

Not bad. So, almost evey second company is down by 20% from life time high

What all do I read to keep myself informed about new opportunities and to keep updating myself with the new happenings in the world?

Time for a thread about all tools I use to research,Find information and update myself about different subjects

🧵🧵🧵🧵🧵🧵

Blog Subscriptions I am subscribed to for investing:

1. @borrowed_ideas
2. Non-Gaap Substack
3. The Flywheel substack
4. Read The Generalist
5. Kiran D- has a blog on word press
6. Uncommon Profits
7. Used to read stalwart but they reduced the posting
8. @rohitchauhan

9. @IntelsenseI
10. @SeekingAlpha
11. @themotleyfool
12. Betaoalpha Substack by @mehrotra_saket
13. @MarcellusInvest
14. @PerfectResearch

Others that I like to read

1. @TheKenWeb
2. @EconomicTimes Prime. Recently they have improved
3. @TheEconomist
4. @forbes_india

Sectoral experts/Analysts that I follow:

For Pharma- @AdityaKhemka5 , @unseenvalue & @punitbansal14 + Contract Pharma for cdmo

For Banking- @HemindraHazari , Digant Haria and Ashish Gupta from Credit Suisse (he's terrific)

For chemicals- Rohit Nagraj from Emkay Global

and chemical weekly+Chemical reports monthly from B&K securities

Broker reports that I like to read whenever I can:

1. Spark capital-hands down the best reports in the country.

2. Ambit- publish some good stuff. But rarely available

3. JM Financial- exceptional reports.

@Trendmyfriends Super Trend 10,2

@buzz_chronicles save as screeners

#CPR is an indicator which is used for #Intraday in Stock Market.

This learning thread would be on
"𝙐𝙨𝙚𝙨 𝙤𝙛 𝘾𝙋𝙍"

Like❤️& Retweet🔁for wider reach and for more such learning thread in the future.

Also, an investment strategy is shared using CPR in the end.

1/24

Central Pivot Range (CPR) acts like a magnetic level for any stock/index. Traders use it for intraday but it works on higher time frame as well.
CPR is just the three lines which is like a magnet and price approaches these levels. CPR acts like a support or resistance.

2/24

What are these three lines now?

𝗣𝗶𝘃𝗼𝘁 = (High + Low + Close)/3
𝗕𝗖 = (High + Low)/2
𝗧𝗖 = (Pivot – BC) + Pivot

For intraday chart use previous day candle HLC. Similarly, for Daily Chart it would be Monthly HLC. For Weekly/Monthly Chart use Yearly HLC.

3/24

This indicator is available on Zerodha Kite (web version) and it works well there. It's also available in @tradingview but setup needs to be done based on the time frame.

Images are shared for CPR setup of both the terminals (Zerodha and Tradingview).

4/24

CPR can be used in finding trend.

If CPR is moving up for the next day, then trend is up. If CPR is moving down for the next day, then trend is down.

Some examples for both:
In the below chart of Nifty (5 mins), CPR is moving down and price is also in downtrend.

5/24

Gold to dxy has made a double bottom on weekly. Gold is showing a breakout on daily falling trendline.
In the correction everything falls, first to move up is gold, followed by equity

@nishkumar1977 @caniravkaria

For first time Dxy correcting with markets, bearish divergence on dxy charts as well

I've used Microsoft Excel for 20 years, and these 20 tips & functions will make you an expert and increase your productivity 100X📊

Don't ever use Excel again without knowing these 20 tips & functions:

Here are 20 MUST KNOW Microsoft Excel tips & functions (with pictures & examples of each below):

(1) Wildcards
(2) Duplicate
(3) Remove Duplicates
(4)Transpose
(5) Filter
(6) Conditional Formatting
(7) Sparklines
(8) Pivot Tables
(9) Auto-fill
(10) TRIM

11-20:

(11) XLOOKUP
(12) IF
(13) SUMIF
(14) SUMIFS
(15) COUNTIF
(16) COUNTIFS
(17) UPPER, LOWER, PROPER
(18) CONVERT
(19) Stock Market data
(20) Geography / Maps

Let's discuss each in detail (with pictures & examples):

(1) Wildcards

A wildcard is a special character that allow you to perform partial matches on text in your Excel formulas.

Excel has three wildcards: an asterisk "*", question mark "?", and "~"

(2) Duplicate

Duplicate the data from the cell above.

Ctrl + D fills and overwrites a cell with the contents of the cell above it