Sector Analysis of FnO data – How to see the bigger picture ?

One of the best ways to pick a winning trade is through a top down approach . First identify the sector showing a trade opportunity and then look for the best stock in it.

In MyFnO, we have always strived to figure out how we can deliver that extra edge using F&O data.

And today we are proud to introduce to be seen for the FIRST time anywheresectorTrends
Sectorwise Charts with aggregated F&O data of price, oi, volume, rollover, basis, iv, pcr, delivery
(P.S. avaliable in PLATINUM plan only)


Computation methodology used ->

  1. For Open Interest (OI), Future Volume, Delivery, we calculate in Value terms (INR cr) and add up the Total of all the sector components so that they can be compared on a common base.
  2. For others like basis,iv,pcr,rollover we take the Average at any tick point of all the sector constituents
  3. For price we compute a simple average index where the initial price of each stock in the sector is rationalized to base 100

This sectoral data can now be beautifully analyzed across various modules in MyFnO

Our favourite one is the “Trends” page where you can get a clear understanding of the action happening across sectors in one screen all together.  Click below image to see full screen

Sector Trends
Sector Trends

Now you can also see a full Sector Chart for the first time with aggregated F&O data & Technical indicators combined together in one screen !



In Markets page , you can also see Sector wise TopX gainers/losers across aggregated sector data like price%, oi% , avg premium/disc %, avg Rollovers % / delivery% etc.


In Sectors page itself you can see % changes of various F&O aggregrated parameters across any time frame/interval.. be it Days/week/Month or any custom N days.. or even intraday of 5/10/15/hourly changes. so you know where the action is taking place. You can also use this interval chg in other screens like Markets, Heatmap, etc. whereever applicable


In Changes page you can see smooth trends with colored heatmap where it is then easy to identify regions of sector weakness/ strengths and turnarounds



In Ranges page you can lookout for sectors where F&O data reaching extremes of the period ranges and especially if there is a gap or divergence of 2 parameters like price & oi


In Compare page you can actually compare for eg. F&O data like Sector avg Rollover % across ‘monthly’ time frame in a easy to analyse graph



So as you can see there are various ways to see the bigger picture in action happening across sectors. It is all out there for you to see. Just waiting for you to spot it !

FnO Indicators – how to read in between their lines

MyFnO specializes in F&O data / indicators and it is for a reason.

These parameters add that extra edge into chart reading and can signal important trigger points for a trend change

the definitions of F&O indicators we’ve already laid out in our post on our post–>
F&O data … the basic fundas

and how best to make use of these F&O indicators is best laid out with some examples in our  one-page pic –> selfie’ explainatory 🙂

( click image below to zoom into image –> )



you can see all these parameters combined in the ‘charts’ module also –>

F&O indicators in one chart!



you can also see them one by one overlayed in the ‘trends’ module–>

Open Interest

Implied Volatility

PutCall Ratio



Rollover Cost





F&O data – the basic fundas

The Basics (not the usual price/volume):

  1. Open Interest (OI) :
    in simple terms, this is the net number of long/short positions outstanding at any given point of time. For each buyer of an F&O contract there must be a seller.

    From the time the buyer or seller opens the F&O contract (call/put/future) until the counter-party closes it, that contract is considered 'open'.

    A large open interest indicates more activity and liquidity for the contract. The more the buildup the heavier the counter becomes, and depending on who comes out stronger, the bulls or the bears, the price follows.

  2. Basis (premium/discount) :
    is the difference of the Future price over the underlying spot price. It essentially is a bullish/bearish indicator of whether the buyer is willing to pay extra premium & expects the price to rise in future, or whether the short-seller is selling at a discount thinking the price is going to fall in the future. When expressed as a percentage it is called the basis% and is calculated as

    basis% = 100*(future-spot)/spot.

    CoC (cost of carry) is nothing but the basis computed in annualized terms, as good as the rate of interest for carrying the position forward.

    Coc=(basis% *365) / (days-to-expiry)

  3. Near (1), Next (2), Far (3), Long (4) : the data for the 3 month’s series we can see break up as

    near: for current month(1)
    next: for month 2
    far: month 3
    long: for long-dated contracts beyond the 3 regular months

  4. Rollover : is a close estimate of how many future positions are actually being carried over to the next month series, (but no one actually knows the actual figure, it is just a notional assumption). The formula we use is :

    Rollover% = 100 * (OI_Next(2) + OI_Far(3) )/ (OI_future of all 1+2+3 months combined)

  5. RollCost: is essentially the difference in the next & current month ‘Futures’ price only  i.e. the premium/discount the buyers/sellers are willing to pay to roll their positions to the next month. A positive rollcost generally indicates that a bullish position is being rolled or built for the next month and a negative rollcost indicates a bearish one

    RollCost% = 100 * (Price_Next(2) - Price_Near(1) )/ (Price_Near)

  6. Implied Volatility (IV) : in simple terms it is how much volatility the market is expecting in the future ( vis-à-vis the Historical Volatility HV which is calculated from the past price movements). A higher IV means people expecting a lot of volatility & are thus willing to pay a higher price / premium in options to protect their interests. A lower volatility means people are getting comfortable with current market scenario.
    For IV we use black-scholes formula to calculate IV for each strike, using futures price for underlying & zero interest rate ( since all are European options). Then we apply a volume-weight and calculate overall IV of a symbol through a volume-weighted avg of IVs across strikes to arrive at one common IV for that stock/symbol i.e.

    IVsum = (IV1*Qty1) + (IV2*Qty2) + ... (IVn * Qtyn)
    QtySum = ( Qty1 + Qty2 + ........... QtyN)
    IVavg = IVsum / QtySum
    where 1,2,…N represent individual strike contracts

  7. PutCall Ratio (PCR) : a barometer for investor sentiment, it is the ratio of the open-interest positions of Puts to Calls.

    PCR_OI = OI_Puts / OI_Calls

    A very high PCR can trigger a fall and a very low PCR can trigger a rise in in the markets. There is also a PCR for volume which is a ratio of puts traded to calls traded, representing bullish/bearish sentiment for traders.

  8. Delivery : it is the positions carried over trading sessions in the cash market of all exchanges combined

    (i.e. it goes into the demat account of the trader’s portfolio).

    Delivery is to cash market like OI is to derivatives market. Spikes in deliveries are indicators that major price action can happen from that point, as it forms a support or resistance, depending on whether big positions have been built up or offloaded.

    What we show in is 3 unique things –>
    1.  BSE + NSE delivery qty combined
    2.  delivery% of the total both exchanges traded quantity to get an overall pic
    3.  delivery %change  vis-a-vis the previous day.. so any delivery spikes can be visible if delivery_chg>100%

all-in-one F&O data
all-in-one F&O data