If you guys followed onething in case of #tv18broadcast #TV18BRDCST which we discussed so many times I guess..
Then you must have saved your money & avoided such setup in advance 😊

** Never expect multiyear breakout when monthly RSI above 70 **

A lot of websites provide you with data for trading.

However, I liked the free website of Icici Direct the most.

Here is a breakdown of what it can do: 🧵

Collaborated with @niki_poojary

Advantages:

1. Quantitative Analysis in one place
2. Easy to find stocks where action taking place
3. Find the exact price levels at which OI is being added.

You can check out this free website by clicking on this

Where is the action taking place?

For eg, Nifty Heatmap Can easily scan for:

- Long Build up = Price Up and OI up
- Long Unwinding = Price Down and OI down
- Short Buildup = Price Down and OI up
- Short Covering = Price Up and OI down

Price levels of OI being added:

• Check 15 mins Built-up in any stock
• Can find Intraday Bullish and bearish trend
• Eg of IBUL who was down 5% on Friday. Short Built-up had started in the morning itself.
• Shows the quantities which are being traded in those intervals.

Time Intervals:

• There are 25, time intervals available every day.

• If a stock has to go up or down a lot it will be heavily dominated in these time intervals.

• IBUL had 10 times short built up on Friday. -5.79 %

• ITC had 14 long built-ups on Friday. +2.6%.

Basics of PMS / IM for New Investors :

Basic Qualification Criteria :

~ Sales CAGR > 15 %
~ ROCE > 18%
~ PEG < 2.5
~ 1 Year Forward PE < 30
~ Debt / Equity < 0.3
~ *Prom stake > 51 %
~ Analyse Quarterly Results closely.
~ Minimum 15 stocks
~ Time - 2 year
#investing

Stocks that I have been tweeting often #JindalPoly #BorosilRenewables #accelya #routemobile #apcotex are all at 65 MA, even metal index. We should start seeing a bounce from here
#willaimOneil

Just an update for my follower family

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

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