Tweeting stock picks .. using FnO tricks – part 2

Hi there !

Over the last month the markets have seemed to be turning up. And we’ve been trying to do some stock picks of late using simple F&O data analysis with no rocket science:). We have been tweeting these stock picks on,  and oh boy ! are we happy or what –> 8 out of last 10 picks given nice returns.

Just thought we should share these ideas with the myfno community & look forward to your views so we can all build F&O knowledge along the way

If you’ve been following us on twitter, hope you would have liked the below stock picks , if not, there should be more to come to choose from:) Wish us luck !


Just to reiterate & to add a disclaimer here –> we love to design & build great softwares & are NOT in the business of stock recommendation / advisory. We are doing this stock picking purely at a goodwill and to showcase what the power of F&O data could do. 

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 !

Unravel the mystery behind rollover costs

We have all heard about rollovers & some even the rollover cost, but how do we interpret & how do we see if it signals a change in price trend

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

Essentially rollover% is an indication of how much % of positions is getting rolled over to the next month ( be it long or short) .. and a higher rollover% indicates that the base direction for the next expiry action is set strongly by the bulls/bears prior to its beginning itself.

And whether the price trend reversal will be up or down can be seen clearly by a positive/negative or a change in the rollover cost which essentially in the price of next month future – current month future expressed as a %percentage premium/discount

So wondering how the rollover% and especially the rollover cost works out during the expiry / rollover week and what it gives a hint of ?

Well, what better way to showcase it in various scenarios than through a single ‘selfie’ to understand pic  –>

the mystery behind rollover costs

the above pic is is for a month trend.. to see expiry day trend you can choose daterange as ‘1d’,  so that you can see if there are any last day rollcost changes/reversals happening in long/short buildups , indicating where the buy/sell pressure is taking place.

to see what how you could have made money on the last trading day of the expiry  see this example–>

rollcost on the expiry day itself!

To view this live in one-single click you can directly goto our directly created ‘Rollcost’ view template in the ‘Trends’ module –>

The trick i used to find this turnaround stock

I like to see stocks which are near their high /low range . And not only in terms of price , but also other F&O parameters, especially Open Interest (OI) and Delivery.

Why ? because OI itself is like a pressure cooker, there is a limit to how high can it go, and at the tipping point either the bulls or the bears will eventually give in, and the price would flow in the reverse direction. And if coupled with high delivery volumes, it is like a sure shot .

But how do identify if these parameters are near their high/low ranges from so many F&O stocks in a quick & easy way? For this the “Ranges” screen in the MyFnO app comes real handy.

The trick of finding such stocks is shown in our one-page pic –>

NOTE: I personally like to choose ‘percentile‘ form of data as that gives me how many % of times the value has been below the current value


Magic of the PCR (putcall-ratio)

the magic of PCR

The Put-Call ratio (PCR-OI) has a very simple definition

PCR = Open Interest of ALL Puts
           Open Interest of ALL Calls

Albeit its simplicity, it is a very powerful indicator, as it actually gives a sense of where the market is heavy –> on the buy or sell side.

Remember we use the PCR of OI (open int.)  and NOT volume.

Since OI by its nature itself is cumulative, (i.e. builds up over trading sessions) and has the inherent property of quantifying positions being ‘open’ i.e. how much money is at stake.

So, any pressure from either bulls or bears can take the market in their direction.
It is just that who has the upper hand & takes the lead, and of which we can get a sense of understanding through the magic of PCR 🙂

My observations are highlighted in the picture below.

the magic of PCR
the magic of PCR

NOTE: Like any other indicator, this is not to be seen in isolation, but used as a confirmation along with other parameters to confirm any view on the market.

Today on 18 Sep 2014, Markets again went up almost 2%.. but just see what was happening in PCR ( a U-turn) a day before from 16th to 17th sep. which is generally a signal of trend reversal in the making –>