Friends,
in this thread, I shall explain important trading concepts in simple way.

It takes time to create content. I hope you find it worthy of RETWEET.

If response is good, then I shall continue with this series to cover more in depth concepts/ different scenarios.

#tatapower
- broke out of consolidation & gave ATH close
- volumes highest in 4 months
- COI rose by 6%, still it is avg
- Options data still slightly bearish.

I shall look for Long opportunity preferably on pullback to vwaps. (I generally avoid direct BO.)

Fellas, today's range breach is to be watched for....
Do you know why?

Nifty, BNF, RIL, Infy, some major banks all took resistance around their respective SVWAPs.

#tcs trivia:
Last 5/ 5 times, next day after qtrly results, stock had Close < Open.

Series VWAP. If interested in knowing more, check a FREE writeup here....

https://t.co/WxKNShO3pk

Friends,
I am planning to write Stock mkt related thread (/writeup) on..

WHY STUFF WORK?

E.g. Why prior Support acts as Resistance?
If u have such questions related to Data/ TA, DM me. If possible, I shall incorporate reasoning for that as well.....
#learning #stocks

Friends,
Here we go.....

In this running thread, I shall explain my understanding/ observations on WHY aspect of Trading/ Investing/ Market analysis..

#trading #StockMarket

1. WHY Support turns Resistance and vice versa....

2. WHY few MA (like 200) work, sometimes?

3. WHY Support/ Resistance are more likely to break after multiple visits?

This is in response to the question by @unseenvalue

If I had to buy 1 stock today, anywhere in the world, no avg. up or down, 5 year holding period (I will make that as 10 year for thesis to play out)

Since I track mainly Indian equities, restricting the choice to this space

Few points to look for
1. Strong macro tailwind rather than headwind, huge growth runway for company/segment. It can't be in a niche space & demand must not be easily substitutable
2. Strong Biz Model, high growth curve (15%+ over the period), strong ROE profile (hurdle rate 20%)

3. Low or no leverage, efficient capital allocation, (read minimal or zero fresh dilution requirements), strong cash flows and correspondingly high dividend payout ratios (consistent dividend history) and finally strong moat and with limited regulatory involvement / no reg issues

4. Promoter quality and intention must be beyond reproach, proven management with skin in the game
5. Capability to manage disruption, and if possible to even profit from it. If you can't be disrupted easily, you will eventually adapt your game to gain scale

6. There must be a possibility of non-linear growth if the scale-up hypothesis gets proven right. It's like an FD with low fixed return plus significant upside optionality. Multiple revenue streams / margin levers / IP that can provide non linearity in growth

Some underrated websites for investing research & analysis👇

1. https://t.co/lxen3s2wyP
2. https://t.co/WZfcE248ss
3.

𝗦𝘁𝗼𝗰𝗸 𝗦𝗰𝗿𝗲𝗲𝗻𝗲𝗿𝘀 🚀🚀

All my screeners in one place.

I like to keep it simple, so use just a few basic screens. And a lot of manual chart reading.

(Thread 🧵, read on...)

Trend Template for Momentum Stocks

My main screen which I run every weekend to prepare my watchlist.

Link -

Near All-Time-High (ATH)

My auxiliary screen that I generally use when the trend template is generating too many candidates, and I need to zero in on the very best.
(Happens usually during strong up trending market)

Link -

Relative Strength (RS) List

My utility screen which I usually run at times when the market is experiencing general weakness within a longer term bull market, or during a bearish phase.

Gets me stocks holding up the best in the general weakness.

Link -

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