Information Management Data Exchange

Advertisement

FREE SITE REGISTRATION

Sign up today and take advantage of member-only content — the kind of timely, cutting edge industry insight that only Securities Industry News can deliver.

FREE site registration entitles you to:

Exclusive Online Only Content

Newsletters and Alerts

Industry White Papers

Online Seminars ... and Much More!

BLOGS | OPSREPORT

Data Management 2010: The Ins and Outs

Chris Kentouris
Securities Industry Blog, December 29, 2009

Effective data management will become critical in 2010, as regulators on both sides of the Atlantic scrutinize, identify and try to limit systemic risk. This means firms will have to keep a closer tab on risk within their own shops.

What will that entail? The Enterprise Data Management Council’s latest “What’s In” and “What’s Out” list of 44 items provides a glimpse.

Creating source tagging to eliminate data scrubbing: Firms often rely on multiple vendors to find the best reference, counterparty, corporate action and market data.

To come up with a “golden copy” of the data they must then “scrub” or cleanse the data by reconciling the differences through either an internal or external engine. Wouldn’t it be easier if firms could just tag data at the source so they wouldn’t be faced with “transforming” the data?

Such a scenario is already happening with financial reporting due to the Securities and Exchange Commissions’ requirement for XBRL tagging. The same could soon apply for corporate action notifications if the efforts of XBRL U.S, the U.S. arm of XBRL International, Depository Trust & Clearing Corp. and Swift to push issuers to use XBRL tagging for corporate actions succeed.

Developing business semantics and metadata repositories instead of relying on data definitions and spreadsheets: The definitions, business rules, quality metrics, data relationships, policies and stewardship roles that enable efficient data management can all be captured and maintained through effective use of metadata – data that describes other data.

“Precise business semantics is the foundation of effective data management,” says Michael Atkin, managing director of the EDM Council in New York. The EDM Council has developed a business semantics dictionary to give firms a common data model and dictionary for the information in their securities files.

Such a repository separates the meanings behind the terms used in data fields, from the physical and logical models. Because the repository relies on metadata-based standards, it will help reduce handcoded data mapping and provide information vendors a set of tags that can be used to mark up data at the time the data is originated.

Creating a corporate data culture and understanding of the value of data enterprise-wide rather than aligning data to business lines: Too often firms store data from dozens of internal applications, vendors and counterparties in a number of disconnected databases.

The databases often do not share identical names and definitions. This makes comparing data difficult, if not impossible. Because the databases and applications are tied to individual business lines, data governance is often relegated to a particular business unit. Such a scenario often creates inconsistencies in data which doesn’t bode well for enterprise-wide risk management. Be relentless in reinforcing the importance of sharing data – which in turn means identifying data the same way, throughout the organization.

Assigning data management to Office of Data Management instead of relegating data management to the IT department: What better way to ensure a solid decision-making process behind how data is maintained, distributed and accessed than putting the job in the hands of people who understand it best. This would be a central team of data management experts who can report to C-level executives. Who wants computer geeks – even the best ones –to be in charge when it is business executives who must and will use the data to achieve bottom line objectives?

Helping to create an industry-wide repository instead of relying on disparate data silos and standards at each firm.: “Regulators are being asked to rely on data knowing that counterparties might be mislabeled, subsidiaries segregated differently or specific products defined differently,” says Alan Grody, president of Financial InterGroup, a New York consultancy specializing in risk management. “Non-standard data is adding unnecessary risk and higher costs to each financial firm and the financial industry overall. Aka – its is increasing systemic risk.

Which leads to this New Year’s question: Wouldn’t it be ideal if the financial industry rallied around using common data standards and a single centralized data repository?

Grody says that such a repository, which he calls the Central Counterparty for Data Management (CCDM) will allow firms to throw away their legacy data systems and access a single industry source for fundamental data, such as reference data on securities, counterparty data and corporate actions data. The CCDM would be funded by the “enormous savings” financial firms would realize in using a central database of common business entity identifiers; data attributes; corporate event reporting and consistent terms and conditions.

The European Central Bank has asked the EDM Council, the European Commission, U.S. regulators and lawmakers for its support in creating what it calls a global securities reference data utility. The utility would leverage the data model the European Central Bank uses for its centralized database.

How much would it cost to implement EDM Council’s objectives? Not known. But Atkin says that proving returns on investment and cost containment to justify any new data management initiative may well be passe in 2010. Doing more with less is the new mantra. As athletes might be urged: Just do it. With the teams you’ve got.

 

0 Comments

Be the first to comment on this post using the section below.

Add Your Comments...

Already Registered?

If you have already registered to Securities Industry, please use the form below to login. When completed you will immeditely be directed to post a comment.


Forgot your password?

Not Registered?

You must be registered to post a comment. Click here to register.

Blog Archive

Getting a Grip on Bilaterally Cleared Trade

The National Securities Clearing Corp. will soon launch a service called the Obligation Warehouse, which will offer its broker-dealer participants an automated way of reducing operating costs – and risk – with trades involving equities, corporate bonds, municipal bonds and unit investment trusts.

NYSE Wraps Up First Phase of Floor Renovation

The first phase of New York Stock Exchange's next-generation trading floor went live this week, bringing the upstairs downstairs.

To Attract Institutional Capital, Hedge Funds Need IT Edge

There's good news for hedge funds -- at least, for those able to meet the increasingly rigorous standards of institutional investors in critical areas such as risk management, transparency and operations.

Calling for Action

The call was great: A "consolidated data pool should be surveilled by a unified single regulator,’’ the head of FINRA said in late October. “A single regulator that can bring the best technology, the best people, and a unified set of rules needs to be empowered." How's the empowering going?

The Will and Way to Surveill

Whether government regulators or market centers or other self-regulatory organizations should conduct trading surveillance of our markets may not be the ultimate question.

Overcoming the Hurdles of Data Retrieval

In this Monday's issue, S.I.N. will examine why the toughest part about data storage is not the storage-- it’s the retrieval.

Consumer Agency Wrangling Obscures Derivatives Reform

A consumer financial protection agency may be important. But protection from weapons that can produce mass financial destruction -- derivatives -- is more urgent.

Color the Numbers: BlackRock vs. Black Swan

How are you supposed to deal with the "unprecedented stimulus" that is both strengthening the U.S. economy and making it more fragile, at the same time?

Government Putting Its Thumb On Stock Prices

James Chanos says a company’s cash flow, the quality of its balance sheet, its potential to perform well, drive equity values. Efforts to prop up stock prices where the fundamentals will not sustain them will inevitably fail.

Home State Moves to Regulate Hedge Funds

Connecticut is not waiting for Congress to come up with legislation requiring hedge funds to register with the Securities and Exchange Commission and open their books to inspection. The state that is the capital of the hedge fund industry wants to take fund regulation into its own hands.

Interacting with Jeff Banker

As companies line up to bid for Interactive Data Corp, the firm pushes forward with new technology initiatives. Q&A With Interactive Data EVP Jeff Banker.

Creating A Global Data Repository: Who Will Blink First?

The Fed wants to take on the role of systematic risk overseer in the U.S. if not the globe. And it needs data to analyze to do it. How will it get it?

Facing Up to Social Networking

If you listen to Allan T. Hackney at John Hancock Financial Services, social networking is relevant “here and now.” And critical to your future.

Dealing With the Data Deluge

Market data numbers are expected to continue on an upward trajectory, reaching unprecedented levels never before imagined. With this in mind, industry experts agree it’s time to start planning ahead.

When Seconds Count, Mobility Matters

Seconds count – and can be worth millions of dollars, almost instantly, in today’s fast-paced world of high-speed trading.

Pre-Trade Compliance Technology is No Longer an Option

Since the financial crisis blew through the securities industry, the impact on IT systems has been dramatic. In one key area, pre-trade compliance technology, the crisis has spurred a transition from option to near-necessity.

Developing Software? Be Forewarned and Forearmed

You think you have just achieved the American dream by producing a piece of software that the securities industry needs, wants and has to use. Nothing can go wrong, right? Not exactly. You have to protect your dream first.

The Social Networking of Electronic Delivery

The right way to spur electronic delivery of annual reports and other documents to shareholders is ... to create better, slimmer print documents, prove their value to readers and then let them opt to get the "excruciating detail" online.

Surveilling the Real Risks

Despite the early warnings and increased focus on risk management, the events of the current crisis exposed the interconnectedness of all market participants.

Rounding Out the Trading Desktop

Thomson Reuters' recent acquisition of Aegisoft “rounds out our whole proposition for the desktop across the entire transaction workflow for exchange-traded markets.”

Regulations Haven’t Caught Up with the Cloud

Regulatory and licensing issues are delaying adoption of cloud computing and online, on-demand computing, known as Software as a Service (SaaS), by securities firms. Nevertheless, as rules are worked out, these technologies should take hold over time.

Final Countdown to New Options Symbols: Get Ready (or Else)

There are only three days left until ticker symbols for U.S. options expand from five characters to as many as 21. Are you ready?

The New Audit: Security

Companies on Wall Street and off have long been required and gotten used to the requirement that their financial condition be audited every quarter and every year by independent, professional eyes. Don't be surprised, however, if annual reports and filings with the SEC in the not-too-distant future include a second opinion.

High Performance Databases: A Tool for Quant Traders

As firms continue to add new trading areas and struggle to meet regulatory requirements, high performance databases are becoming increasingly vital.

Embracing the Change

If there's one thing the recent financial crisis taught us, it's that the status quo is clearly not good enough. Not for our markets. Not for investors. And, not for our economy.

Technology -- And Preventing Another Crisis

It’s widely recognized that politics – particularly as practiced by Congress --plays a central role in the outcome of financial regulatory reform. But in a January report from Boston-based research firm Aite Group titled “Smart Regulation,” author and senior Aite analyst Paul Zubulake goes a step further. Leaving politics aside, he writes, “The key component of all the discussion is how regulators can use technology to prevent another crisis.” …

The Season for Fairer Value in Annual Reports

Operations executives, data analysts, valuation experts and IT staff will need to brace themselves to do even more work to do when it comes to valuing their securities correctly this year. Simply striking a correct price on assets held by a fund manager, bank or brokerage firm won’t be enough.

Emailing It In: No Simple Matter

Your securities firm operates in 30 countries. That means the email you exchange with customers, business partners and service suppliers has to abide by the storage, retrieval and compliance laws of 30 nations. Right? Wrong.

Tracking Market Data Rates

Market data appliance company Exegy is working with Essex Radez to relaunch a Web site that tracks real-time market data rates every second.

Mind your E-Manners (sort of)

It’s not only the courts and the Securities and Exchange Commission that are looking over brokers’ shoulders when they communicate electronically. FINRA has now weighed in with guidance to member firms on how they use social networking sites – including Facebook, Twitter, LinkedIn and blogs – in communicating with the public.

Bloomberg: It Can’t All Be Free

Last year, Bloomberg became the first data vendor to provide its unique, proprietary identification codes for stocks, bonds, options contracts and other financial instruments for free on a new website. But that doesn’t mean that Bloomberg wants to give everything away for free.

The Function of Fast

Wall Street should always be about finding the systems and means to fund the formation of new firms and the growth of existing ones. Or make yourself and your customers wealthier. So they’re ready to put more of their money into the strategies and companies you’re trading in. This is why speed matters.

Don’t Tax the Recovery

The securities transaction tax is one initiative that threatens to throw sand directly into the gears of the marketplace.

Middleware Matters

Next Monday’s issue of S.I.N. will include two features about the use of middleware— the plumbing that helps software applications communicate over a network.

He Said, She Said in Securitization Split

The Securities Industry and Financial Markets Association (SIFMA) is wasting no time getting back on its feet after a dust-up with the American Securitization Forum (ASF) that led to the termination of their eight-year-old affiliation earlier this month.

Dear CEOs: Get More Data for Risk Analysis

U.S. financial firms aren’t the only ones who need to worry about how to shore up their data management skills to comply with potential legislation for monitoring enterprisewide risk.

Dow 48,000

Want some sobering numbers on just how intransigent this non-Depression economy has become? Want to argue about whether we are going to face a “lost decade” like Japan? Maybe it’s already been lost.

Data Centers as Important As Trading Floor

Data centers are the new keystone for U.S. equity trading, said Tabb Group senior analyst and report author Kevin McPartland in a study released this month, “U.S. Equity Technology 2010: The Sell Side Perspective.”

An Act of Blankfein: Was That a Mea Culpa?

Let it be noted at the outset that Goldman Sachs chief executive Lloyd Blankfein did not use the term "Act ..." or "Acts of God" in describing the events that led to the financial crisis of 2008 to the present. But he still has said bankers are doing ... God's work.

Finally, the Truth about Hedge Funds

Step aside, Securities and Exchange Commission. The Managed Funds Association – the main hedge fund trade association – is launching an ambitious data collection initiative aimed at finally getting its arms around the true size and nature of the industry.

Slowing Down Real-Time Trading

The Securities and Exchange Commission this morning (Wednesday, January 13, 2010) moved to ban "naked access" to electronic markets, saying it will require some kind of pre-trade risk controls on all orders. Here's why slowing down real-time trading makes sense.

Who Pays for Proxy Reform?

Proxy reform. It’s on the Securities and Exchange Commission’s list of initiatives this year but just what it should spell will likely continue to be one of the most heated topics to cross the regulator’s desk.

FIN50: A Wall Street Meter

On New Year's Eve, Securities Industry News quietly introduced the FIN50 Index, to capture by the second just how Wall Street itself is faring. Its 50 component stocks are all publicly traded companies who make Wall Street tick.

'10 Plus 10

It’s that time where forecasts abound. Wall Street is breathing easier, after its brush with death in 2008. But the Dow Jones Industrial Average has hardly changed since first crossing 10,000 on March 19, 1999. Let’s see what you forecast for the next 10 years. Then go back 10 years to see where things were a decade ago.

Do You Really Need the Market Data You Want?

The race has begun. Algorithmic trading and other types of electronic trading with a wider range of liquidity providers will mean a lot more ticks flowing through applications, at record speeds. But can you afford all the data about markets you want, to support the trading?

The Accidental Advantage of Naivete

Some times, it’s better not to know what you don’t know about financial markets. Then, you might just do things right.

Hedge Fund Transparency Won’t Extend to Media

For journalists covering the traditionally secretive hedge fund industry, opportunities to meet with leading hedge fund executives are few and far between. An exception: The Managed Fund Association’s annual networking conference, which features a large exhibit hall, first-rate speakers, and plenty of opportunities to talk with some of the industry’s best-known names. Until this year.

Data Tsunami About to Hit Shore

As financial firms consider just how to keep their budgets lean and mean in 2010, they will be facing pretty tough challenges in complying with the requirements of the so-called financial reform. Particularly when it comes to managing the data involved.

A Year of Trading, Every Day

When you break it down, what high-frequency trading is breaking down each trading day into the equivalent of a year of trading (or, you could contend, multiple years). And, you cash out, at the end of each year, er, each day.

A Wall Street Christmas Poem (Lieberman edition)

As the gathering storm over financial regulatory reform approaches, this poem is dedicated to folks who fear Lieberman may provide a storm all his own.

Canadian Connections

Canadian trading venues are establishing connectivity partnerships and seeking to cut latency, providing investors with even more options in terms of market models and lower trading costs.

Transfer Agents and Investors Beware: When it Comes to Unclaimed Accounts, State Laws End Up Hurting Everyone (Except the State)

States are increasingly trying to pull a fast one on investors. In fact, you could say those investors could soon feel cheated on escheatment.

Wall Street 2(009)

On the ground floor of the building in which this is being typed, Oliver Stone has set up shop. Barely a stone’s throw from the New York Stock Exchange and in direct eyeshot of the Statue of Liberty, the movie producer is at it again. He’s shooting Wall Street 2. But he may be looking for "villainy" in the wrong place.

Rolling Thunder

When industry lobbyists target a Congressional proposal for defeat, the roar can be deafening.

A DTCC For Trading Issues?

If there’s one piece of new regulation you can probably expect to see come out of the Securities and Exchange Commission early next year, it will be a set of rules on how “sponsored access” has to be controlled. It’s not too late to determine who controls the controls.

Next Up for Investigation: ID Codes for Counterparties?

The European Commission seems to think that identification codes for financial instruments should be obtained for free.

Will Free be a Four-Letter Word in ‘Licensing’ ID Codes?

The European Commission’s investigation into the licensing of identification codes for financial instruments by Standard and Poor’s CUSIP Global Services and Thomson Reuters has aptly generated several basic and underlying questions that have been long overdue.

States Step in Where Feds Fear to Tread

In the $330 billion auction rate securities (ARS) scandal, when the market froze up after customers were told the risky securities were as safe as cash, state regulators took the initiative in winning money back for ordinary investors, and holding the wrongdoers accountable.

Trading Ideas on Trading Technology

This is the first post of Trading Spaces, a weekly commentary that will provide you with fresh analysis of industry trends -- and an opportunity to engage in thought-provoking conversation about the state of trading technology.

Twilight Saga for Ponzi Schemes

If the securities industry is determined enough, it could easily include algorithms that track every use, every transfer of an investor’s dollars between accounts at an investment firm and how those dollars were used. And block Ponzi schemes like Bernie Madoff's or even Tom Petters' from getting off the ground.

Mind Over Model

No matter what happens with the rest of this Greatest Recession Since the Depression let’s stop trying to blame it on runaway quantum finance. Math is not the problem. It gives answers. It provides precision (sometimes illusory). And, translated into computer coding, it runs endlessly and tirelessly. But somebody had to make it up in the first place. And maintain it. And manage it.