ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Select Stock for O.C. Analyser (Lite)
4
Version: Brilli (1.0)
5
Prepared by: Ajeet Singh
6
Choose a Stock from Dropdown list ⤵
7
ICICIBANK
8
Number of Stocks available for Pro users: 50
9
Number of Stocks available for Lite users:10
10
After choosing stock, Click below link ⤵
11
https://tinyurl.com/22737173
12
Customization can be done but please dont alter this excel. In case of Problem, you can comment here at top right or in forum.
13
Validity: Till nseindia don't change its API
14
Click here to get list of all my Excels.
15
Click here to post your feedback/suggestion.
16
17
Instructions:
18
• We all know the concept of change of open interest with change
19
 of price. But its in case of futures.
20
• Here we are taking leap forward and applying this concept
21
 to option chain of a stock.
22
• Imagine where the stock will be heading if almost all CE's
23
 prices are rising with high change in open interest.
24
• Currently in this Lite version, limit set by server end is 10 stocks
25
• You try it and in case you wanna change any stock then comment.
26
• Sheet will start updating after 9.15am on every trading day,
27
 when new data starts pouring in.
28
• Although it gives realtime live data but it dont updates in background
29
 suppose stock already selected is ICICIBANK and you want to
30
 see its current option data then select any other stock
31
 and again select icicibank.
32
33
34
35
36
37
38
39
Link to this excel: https://tinyurl.com/22737172
40
server: trade.ajeetsingh.net/p/ocanalyser
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100