A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | |||||||||||||||||||||||||||
3 | Stock Trend Indicator | Disclaimer: I am not sebi registered financial advisor. I have made this excel for persoanl use and shared in lieu of money or free. Losses do occur and they are part of trading. I am just sharing strategy to minimize losses. Keep in mind, stoploss do hit and you yourself are responsible for losses. You may loose all your invested money. I won't be responsible for any of your trading decisions. | |||||||||||||||||||||||||
4 | Version: Cleav (1.0) | ||||||||||||||||||||||||||
5 | Prepared by: Ajeet Singh (www.ajeet.co.in) Valid till: 31 Dec 2025 | Contact me at: www.ajeet.co.in | |||||||||||||||||||||||||
6 | Symbol | Trend just Started | Trend Developing | Mid way | Strong Trend | Signal | Q. How to use this Excel sheet? | ||||||||||||||||||||
7 | ADANIPORTS | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 1431.23 | A. Whenever there is strong signal, lets say bearish, then run 2 mins graph of that | ||||||||||||||||||||
8 | ASIANPAINT | Bullish started | Weak Bullish | Bullish | Strong Bullish | Buy @ 3367.24 | symbol and look for sell signal. I use my personal afl for buy/sell signals, | ||||||||||||||||||||
9 | AXISBANK | Bearish Started | Weak Bearish | Sell @ 1185.52 | you can use any based on stoch, macd, ema crossover, rsi..... means anything. | ||||||||||||||||||||||
10 | BAJAJ-AUTO | Bearish Started | Sell @ 11427.44 | target hitting probability is very high as stock is already in trend so targets are | |||||||||||||||||||||||
11 | BAJAJFINSV | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 1831.3 | achieved quickly. | ||||||||||||||||||||
12 | BAJFINANCE | Bearish Started | Buy @ 7345.29 | See example below. | |||||||||||||||||||||||
13 | BHARTIARTL | Bearish Started | Weak Bearish | Sell @ 1579.42 | |||||||||||||||||||||||
14 | BPCL | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 340.07 | |||||||||||||||||||||
15 | CIPLA | Bearish Started | Weak Bearish | Sell @ 1632.12 | |||||||||||||||||||||||
16 | COALINDIA | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 484.16 | |||||||||||||||||||||
17 | DRREDDY | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 6619.54 | |||||||||||||||||||||
18 | EICHERMOT | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 4724.99 | |||||||||||||||||||||
19 | GAIL | Bullish started | Buy @ 216.92 | ||||||||||||||||||||||||
20 | GRASIM | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 2681.59 | |||||||||||||||||||||
21 | HCLTECH | Bearish Started | Weak Bearish | Sell @ 1781.12 | |||||||||||||||||||||||
22 | HDFC | ||||||||||||||||||||||||||
23 | HDFCBANK | Bearish Started | Weak Bearish | Bearish | Buy @ 1644.96 | ||||||||||||||||||||||
24 | HEROMOTOCO | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 5654.74 | |||||||||||||||||||||
25 | HINDALCO | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 648.11 | |||||||||||||||||||||
26 | HINDPETRO | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 409.68 | |||||||||||||||||||||
27 | HINDUNILVR | Bearish Started | Weak Bearish | Bearish | Buy @ 2907.86 | ||||||||||||||||||||||
28 | IBULHSGFIN | ||||||||||||||||||||||||||
29 | ICICIBANK | Bullish started | Weak Bullish | Bullish | Strong Bullish | Buy @ 1236.43 | |||||||||||||||||||||
30 | INDUSINDBK | Bearish Started | Weak Bearish | Bearish | Sell @ 1421.87 | ||||||||||||||||||||||
31 | INFRATEL | ||||||||||||||||||||||||||
32 | INFY | Bearish Started | Weak Bearish | Bearish | Sell @ 1911.6 | ||||||||||||||||||||||
33 | IOC | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 169.88 | |||||||||||||||||||||
34 | ITC | Bearish Started | Weak Bearish | Sell @ 514.12 | Above is screenshot for 11 Feb 2019 | ||||||||||||||||||||||
35 | JSWSTEEL | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 927.62 | Here Cipla and Drreddy, both are from pharma sector but have different trends | ||||||||||||||||||||
36 | KOTAKBANK | Bearish Started | Weak Bearish | Bearish | Sell @ 1790.32 | So lets check their 2 mins graphs | |||||||||||||||||||||
37 | LT | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 3538.78 | |||||||||||||||||||||
38 | M%26M | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 2652.85 | |||||||||||||||||||||
39 | MARUTI | Bearish Started | Weak Bearish | Buy @ 12241.06 | |||||||||||||||||||||||
40 | NTPC | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 390.09 | |||||||||||||||||||||
41 | ONGC | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 285.28 | |||||||||||||||||||||
42 | POWERGRID | Bearish Started | Weak Bearish | Sell @ 333.47 | |||||||||||||||||||||||
43 | RELIANCE | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 2903.67 | |||||||||||||||||||||
44 | SBIN | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 769.75 | |||||||||||||||||||||
45 | SUNPHARMA | Bearish Started | Weak Bearish | Buy @ 1847.43 | |||||||||||||||||||||||
46 | TATAMOTORS | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 976.76 | |||||||||||||||||||||
47 | TATASTEEL | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Buy @ 148.23 | |||||||||||||||||||||
48 | TCS | Bearish Started | Weak Bearish | Bearish | Buy @ 4485.37 | ||||||||||||||||||||||
49 | TECHM | Bearish Started | Weak Bearish | Sell @ 1605.28 | |||||||||||||||||||||||
50 | TITAN | Bearish Started | Weak Bearish | Bearish | Buy @ 3710.54 | ||||||||||||||||||||||
51 | ULTRACEMCO | Bearish Started | Weak Bearish | Bearish | Sell @ 11487.59 | ||||||||||||||||||||||
52 | UPL | Bearish Started | Weak Bearish | Bearish | Sell @ 611.04 | ||||||||||||||||||||||
53 | VEDL | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 426.48 | |||||||||||||||||||||
54 | WIPRO | Bearish Started | Weak Bearish | Bearish | Strong Bearish | Sell @ 515.28 | |||||||||||||||||||||
55 | YESBANK | Bullish started | Weak Bullish | Bullish | Strong Bullish | Sell @ 23.84 | |||||||||||||||||||||
56 | ZEEL | Bearish Started | Weak Bearish | Bearish | Sell @ 135.83 | ||||||||||||||||||||||
57 | Here we have to take only buy signals and book profits on sell signals | ||||||||||||||||||||||||||
58 | |||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||
60 | ✿ Link to this excel: https://tinyurl.com/22737226 | ||||||||||||||||||||||||||
61 | ✿ Sheet will go off for 30secs for calculation and then again display the result for 10 secs | ||||||||||||||||||||||||||
62 | ✿ If its showing #Ref! or "Loading" then wait for 30 secs | ||||||||||||||||||||||||||
63 | ✿ If still data is not shown then refresh the sheet | ||||||||||||||||||||||||||
64 | ✿ Link to all of my excel sheets, posted here: https://tinyurl.com/2277777 | ||||||||||||||||||||||||||
65 | ✿ Levels mentioned are valid only when price crosses first time that level | ||||||||||||||||||||||||||
66 | ✿ when all are green I buy as per supertrend and vice versa | ||||||||||||||||||||||||||
67 | ✿ I personally use SuperTrend for entry points and dont follow above buy/sell levels | ||||||||||||||||||||||||||
68 | ✿ Trade in only those stocks which have strong trend | ||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||
78 | As Drreddy is strong bearish mode so we will only take sell signals and exit at buy signals. | ||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||
80 | There may be some whipsaws but try to enter in all clear trends and stop trading, moment you | ||||||||||||||||||||||||||
81 | get 1% after brokerage. thats our target. | ||||||||||||||||||||||||||
82 | Although success ratio is lesser than Breakout sheet but its more easier to work with this sheet. | ||||||||||||||||||||||||||
83 | Proper money management can fetch you handsome returns. | ||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||
100 | |||||||||||||||||||||||||||
101 |