(Bloomberg Gadfly) -- Try this at home. Anywhere on a Microsoft Excel spreadsheet, type =RAND(). You'll see a decimal number between 0 and 1. Close the worksheet and reopen it a second later, and you'll see a different figure.
It's hard to believe that the absence of a simple random-number algorithm has thrown a question mark around almost one-third of National Stock Exchange of India Ltd.'s revenue.
The chairman of India's No. 1 bourse is confident of taking it public before the end of this year. Yes, the NSE needs to give existing investors a chance to exit. But the awful gaps in systems, processes -- and most importantly, ethical behavior -- revealed by a forensic study by Deloitte Touche Tohmatsu, mean that offering penance (and penalties) would be more helpful before the exchange starts its $1.5 billion IPO.
Late last year, just as the NSE was getting ready to file its draft prospectus, Gadfly advised the exchange to drop the hubris it carried with its lineage. As a government-sponsored alternative to the broker-owned casinos that dotted the capital-markets landscape until the 1980s, the NSE has been a tremendous success, consistently trading four to six times as much equity as its rival, the much older Bombay Stock Exchange, or BSE Ltd.
In recent years, though, the combination of proximity to government and market leadership has led to swollen heads and bad behavior. Both were on display in co-location, which allows traders to place their computers close to the exchange's so they can pare microseconds when executing trades. NSE offered the service to high-frequency traders. But not fairly.
The exchange didn't use something like RAND() to grant fair access to its tick-by-tick system. Those who connected to servers first saw securities prices sooner. It took the Deloitte analysis to discover that the development team was using a "randomizer" for servers other than those handling real-time price data. In other words, the exchange knew it was giving an unfair advantage to some traders, and profited from it.
Co-location services account for 30 percent of the exchange's revenue, which for now is going into an escrow account set up at the regulator's behest. NSE Chief Executive Officer Chitra Ramkrishna resigned last December. Vice Chairman Ravi Narain, a co-founder, left this month.
The old method of disseminating price data has been junked. Still, it'll take a more decisive round of spring cleaning by incoming CEO Vikram Limaye to fix the culture.
As for cozy relationships with the authorities, the Securities and Exchange Board of India, the market regulator, has a new chairman. Ajay Tyagi has no incentive to go easy on the NSE. Any preferential treatment would be rightly seen as repeating the behavior that got the exchange into this mess.
Looking at the BSE, which listed in February and has given IPO investors 36 percent returns to date, it's clear that the NSE has caused a serious opportunity loss to stakeholders including Morgan Stanley, Goldman Sachs Group Inc., Citigroup Inc., Temasek Holdings Pte, and Tiger Global Management LLC.
This column does not necessarily reflect the opinion of Bloomberg LP and its owners.
Andy Mukherjee is a Bloomberg Gadfly columnist covering industrial companies and financial services. He previously was a columnist for Reuters Breakingviews. He has also worked for the Straits Times, ET NOW and Bloomberg News.
The Deloitte report says that OPG Securities Ltd. was consistently connecting first to the lightly used (thus faster) server between December 2012 and May 2014. OPG is one of India's biggest high-frequency trading firms. After its name showed up in an inquiry by a panel set up the market regulator, CEO Sanjay Gupta told Bloomberg News that rivals jealous of his success were leveling baseless allegations. "They can't get why I win all the time," he said.
NSE doesn't intend to raise money for itself in the IPO.