You have been granted access to this page through First Click Free. Subsequent use of TabbFORUM will require logging in. If you don't have an account, registration is free.

Videos

  • Rail_thumb_screen_shot_2013-02-19_at_3

    Know Your Counterparty

    With the move to SEFs and other electronic platforms in the swaps market, participants no longer know who their counterparties are, creating a lack of trust, according to MarkitSERV...
     
  • Rail_thumb_screen_shot_2013-02-05_at_9

    Fragmentation of Swaps: The Good, the Bad and the Ugly

    Is fragmentation in the swaps market good for the industry? Is the futurization of swaps the natural evolution of the market? From the proliferation of SEFs and the search...
     
  • Rail_thumb_jln

    CFTC Proposal Poses “Monumental” Challenge to FCMs

    A rule proposed by the Commodity Futures Trading Commission (CFTC) designed to strengthen safeguards for customer deposits at futures commission merchants (FCMs) is threatening to...
     
 

More Video | Podcasts

Advertisement
Original_300x250
Original_broadridge_300x250_multi-asset
Original_original_300x250_12493_0
Original_equityjune_300x250
Author_bollenbacher
George Bollenbacher

G. M. Bollenbacher & Co., Ltd.

More From
George Bollenbacher

Spotlight-blackOTC Derivatives Reform (more stories)

09 January 2013

Using the Swaps Data at the DTCC SDR

The DTCC’s Swap Data Repository began operating on January 2. Already, we are seeing both the uses and limitations of this data.

On January 2, the DTCC’s Swap Data Repository (SDR) began operating. One of the requirements the Dodd-Frank Act (DFA) put on any SDR was the public availability of the trade (and other transaction) reports being sent in by market participants. Already, we are seeing both the uses and limitations of this data.

In order to see anything, we need to know where to look. The public access URL is https://rtdata.dtcc.com. This opens the window below:

The Slice windows will allow you to filter trade data by product type, and the Report Center will allow you to access reports that you have generated elsewhere. Clicking on any of the links in the slice windows will download the data as a zip file that can be unpacked into a spreadsheet.

The output of the second general slice report, in a cleaned up spreadsheet, contains a variety of swaps types: FRAs, fixed-floating, cross-currency basis, and OIS. They are sorted in order of execution timestamp, but could be sorted by product type and then legs, to group like transactions for price comparison. Columns can also be filtered, so that you only see trades within product types or execution windows, or start and end dates.

Thus a spreadsheet gives us a very flexible way to see the data. For example, filtering on InterestRate:FRA in the taxonomy column shows you a price trend for three-month FRAs from 0.3042 to 0.2975. The Cumulative Slice window accesses very large files of all the transactions in the SDR for a particular product type.

While the data looks fairly accurate for swaps, it appears decidedly less so for options, unless I misunderstand the column headings. For example, the strike price and the option price (which I would take to be the premium) are listed as the same for all options, which I would not expect to be true. 

The next most interesting window is the ticker, which shows trade (and other transaction) reports as they come in. It is divided into four sub-windows, for credit swaps, credit options, rates swaps and rates options. The rates section looks like this:

Watching this window can become addictive, as you see transactions pop up on the screen. At the left of each entry is a link that takes you to the detail for each entry. But beware: Some of these entries are a bit perplexing.

As one swaps trader said to me, upon first seeing this data, “It’s definitely a whole new world!” Already traders and salespeople are trying to figure out who the parties are on many of the larger trades, but that may be a fruitless exercise. Of much more value may be the use of this data to spot trends and opportunities that were hidden before. Adaptation is the order of the day, as it really is a whole new world.

Spotlight-white-trans For more stories in the OTC Derivatives Reform Spotlight Series click here.

Comments | Post a Comment

2 Comments to "Using the Swaps Data at the DTCC SDR":
  • Missing
    Cezary

    11 January 2013

    Thanks for outpointing, George. Am guessing this is the first time this type of data is being made available in the market?

  • Comment_bollenbacher
    gbollenbacher

    11 January 2013

    Yes, this is the first time. Some of the data quality is suspect, like the format of prices, but I suspect it will improve over time.

You must log in to comment.