NSE hasn’t setup intra-day data release for the currency futures market. I got impatient and setup something by myself, a Unix scripting solution that polls their website. I had this up and running by the afternoon, and managed to capture 1009 distinct observations of their `market-by-price’ (`MBP’) for the near month (September) contract yesterday (from 1:41 PM to 5 PM). NSE’s term `market by price’ or `MBP’ pertains to the quantities available for both buy and sell at the best five prices. This is unprecedented transparency when compared with the history of currency trading in India. Today (3rd) I got around to looking at this data. This was Day 3 of the currency futures market, where trading had started on 29th August.
The time-series of the spread
For a frame of reference, by and large, the OTC market has a spread of Rs.0.0025 for quantities of $0.5 million, which corresponds to 500 contracts on the currency futures market. Now, the OTC market is an opaque market and customers get bad deals; the fact that there is a spread of Rs.0.0025 there doesn’t mean that customers get such tight execution. Yet, it’s a natural reference point for understanding where the exchange-traded product has come.
On the currency futures, the tick size is Rs.0.0025 so to attain the spread of the OTC market, the spread has to be one tick. Here’s a picture of the spread in the data that I captured:
Click on the image to see it more clearly. The dashed blue line at the bottom is at the spread of Rs.0.0025, the smallest value this can attain and the typical spread of the OTC market. It was often bigger within the day; occasionally it exceeded Rs.0.02 or 2 paisa.
Distribution of the spread (in ticks)
Here’s the distribution of the all the observations of the spread. The spread is expressed in ticks – one tick is Rs.0.0025, 4 ticks is 1 paisa, and so on.
Click on the image to see it more clearly. The modal value – the value that’s observed most often – is 1 tick. Roughly 45% of the time, the market is at a spread of 1 or 2 ticks. Not bad. But there is a fair bit of occurence of large spreads with values of more than 1 paisa. It’s rarely above 2 paisa.
The intra-day time-series of bid and offer
Here’s the intra-day time-series of the bid and the offer:
Click on the image to see it more clearly. There were periods when the market was sleepy (e.g. near 15:06). But when the prices were moving (e.g. near 15:54), numerous values in the MBP were getting modified every few seconds. It was almost as good as a stock. The currency futures did roughly Rs.180 crore on this day – which is as good as many stocks.
Suppose I want everything that’s available in the MBP
I thought to myself: Suppose I want the entire quantity that’s visible in the MBP. Note that I’m not talking about the `total order quantity’ for buy or sell that’s shown on the NSE screen. That doesn’t mean much because the prices can be pretty bad. I focus only on the top 5 best prices and sum up the quantities available here. I sum up both buy and sell quantities. Here’s the intra-day picture of how much quantity is available:
Click on the image to see it more clearly. For the bulk of the day, the quantity available was in excess of $0.5 million. Note that I’m summing across quantity on the buy side and quantity on the sell side. I’m only trying to get a sense of the mass that’s visible on the MBP.
When this number crosses $1 million, i.e. when the quantity available on one side is roughly above $0.5 million, there is a potential for arbitrage between the OTC forward market (where the market lot is $0.5 million) and the screen. Someone would be able to toss a market order for 500 contracts on the screen, and do a reverse trade on the forward market.
How bad do these prices get, if one takes everything visible in the MBP? I draw a graph here of the worst price in the MBP on both buy and sell sides. Note that if you put in a market order for the full quantity available in the MBP, as you walk down the book, you are getting many different execution prices, and I’m only showing you the worst bit.
I think this market is quite ready for hedging/speculative customers doing quantities of 10-100 contracts (i.e. $10,000 to $100,000). This is a large audience and so there’s plenty of action in store. The big milestone will be where someone will be able to toss in a single market order for 500 contracts ($0.5 million) and back-to-back do an arbitrage against the OTC market. When these trades begin, this market will quadruple in size, i.e. it will come in the list of NSE’s top 10 underlyings of the day.
Originally published at Ajay Shah’s Blog and reproduced here with the author’s permission.