Where to get help for TRTH?

Help is available in many places for users of TRTH. Much of it is located on the home page of a new TRTH session. The next screen shot highlights examples each of these.

You can see six different regions highlighted in that image. They all provide useful information to TRTH users.

On the left hand side:

  • the brown oval surrounds the Speedguide link. The Speedguide is a comprehensive reference source describing TRTH components as they were throughout TRTH’s history. The Speedguide has its own date parameter for that purpose, which is independent of dates defined for your sample period. The Speedguide is explained in more detail here Speedguide Explained
  • the black box is where you go for detailed TRTH help. Everything is covered here. There is information to help you get started quickly. Other information on Gaps in data coverage; a description of Message Types; and a Reference section providing detailed explanations of Brokerage Characters, RIC Chains, the Speedguide and importantly, Message Qualifiers. Follow the Message Qualifiers link to download a PDF which links to further files describing all of the many qualifier codes reported market by market on trade and quote records in TRTH. These are the final links, at the time of writing.

Equity Codes (https://customers.reuters.com/a/support/paz/pazDocs.aspx?dId=447163).

Futures Codes (https://customers.reuters.com/a/support/paz/pazDocs.aspx?dId=447169).

You will need a Customer Zone account to download these files (see below for more on the Customer Zone).

  • the yellow box encloses announcements of recent software upgrades. TRTH is both the incredible underlying data set and the software designed to surface that data to users. Announcements in the yellow box report the latest software and data content improvements.

On the right hand side:

  • the green oval takes you to Thomson Reuters Customer Zone. You will need an account to use the Customer Zone. Use the online services to register – it is free to academic users of TRTH. The Customer Zone contains all current information for TRTH and other Thomson Reuters products. Use the Knowledge Centre FAQs link to search for help on problems already addressed by Thomson Reuters. Another useful link for researchers using Raw formatted data (see below for more on Raw formats) is the Data Field (FID) Lookup link. This maps FID numbers to names and back again, and describes the meaning of each FID.
  • the blue oval is another path to the Help services behind the black box.
  • the red oval surrounds a collection of useful PDFs you can download directly from TRTH’s home page. This collection is constantly being updated and improved and includes more files over time. Among files currently there you will find a Quick Start Guide that explains all the features of the TRTH interface; another on How to find data on Thomson Reuters Quickly and Easily, which contains a comprehensive description of RICs; a file on TRTH Data Coverage listing all the trading venues for each asset type and when data is available – for Equity Exchanges it also reports which exchanges provide buyer and seller IDs; a Data Message guide which describes all the available variables for each message type – go here when you want to know what a column heading means on your data output; a file describing how Cancellations and Corrections are handled in TRTH; and finally another file. Raw Format User Guide explains how to interpret the fundamental data underlying TRTH – TRTH transforms raw data into a more user friendly structure but this fundamental data, delivered by each source, remains accessible too, for those who wish to use it.
Of course, Dinkum Data pages are another source of information and so is direct contact. Please write to us directly at SIRCA if you have questions or comments about TRTH.

What is TRTH?

Thomson Reuters Tick History (TRTH) is a unique data base of tick level price and other information spanning the world’s markets. It dates from January 1996 and is updated four times each day, as the world’s new data unfolds. TRTH is a faithful record of information reported moment by moment on Thomson Reuter’s world-wide real-time Integrated Data Network (IDN). It captures and reports the world’s financial activity, in miniscule time intervals, as it was when it reached Thomson Reuters’ network hubs in London and New York.

All of the world’s major asset classes and markets are covered. Data on all traded equity instruments is available from over 250 regular stock exchanges around the planet. Many over-the-counter markets are covered too. Price, quote and other data is stored for the world’s markets in Futures, Options, Commodities & Energy, Foreign Exchange, Money, Fixed Income. Also available are global data on Indices, Funds and Economic Indicators. TRTH comprises more than 35 million different instruments.

Information can be delivered direct from TRTH as tick data, which displays all trades and every movement in the best bid and ask quotes, every moment through each day; or it can be aggregated by TRTH through the day into seven intervals ranging from 1 second to 1 hour; or it can be delivered as end-of-day data. Bid and ask limit order books, or the market depth of each order book, is also available for many exchanges. TRTH permits users to easily select the most appropriate data type and frequency for their research.

TRTH is an unrivalled resource for academic researchers; in terms of transaction frequency (records have been timed at thousandths of a second and will soon be at millionths of a second), in terms of global coverage of any asset class, in terms of asset classes covered, and in terms of functionality. The sheer spread and volume of data available make TRTH unique. But TRTH also possesses other exceptional qualities. Among these is the powerful, unique and proprietary identification system called Reuters Instrument Codes (RICs). Thomson Reuters’ RIC technology is applied in every market and across every asset class, giving researchers an unparalleled ability to precisely filter and identify instruments, both across markets and through time.

Commercial users also have access to TRTH via Application Programming Interfaces (APIs), allowing them to craft, parameterise and test algorithmic trading routines in real-life trading scenarios.

TRTH is the definitive record of detailed global financial market activity and is presented in ways tailored to meet the expanding needs of its users.

What is a RIC Chain?

A RIC chain is a powerful method to identify a portfolio of RICs using only a single label. Suppose, for example, you are interested in values of a particular market index, like the S&P ASX 200. The RIC for this index is “.AXJO” (notice the leading decimal point). When you add .AXJO to a New Request screen in TRTH you can obtain various statistics about the performance of that index through time.

Suppose though, your interest includes the composition of that index and you wish to know which companies have been used to form it. This is a task for a RIC chain and the particular RIC chain you need is 0#.AXJO. The addition of “0#” to the start of the RIC “.AXJO” is all that has changed. “0#” is the signal that a RIC chain is submitted. With one exception (see below), “0#” is always the signal for a RIC chain.

When you add 0#.AXJO to a New Request screen, TRTH will interpret that request according to your preference settings. When these are set correctly, the RIC chain will be expanded into its components and your New Request screen will contain a list of 201 RICs. The first of these will be the index, ”.AXJO”. The other 200 RICs will be the 200 companies used to generate the index results.

RIC chains can be used for many, many different tasks. In fact, much of TRTH is accessible via chains. For instance, the Speedguide also displays results in RIC chains. When you click on a RIC chain in a Speedguide page it automatically expands into its constituents. One useful example is 0#.INDEX, which displays RICs for the world’s major indices and can be added directly into a New Request screen. 0#.INDEXTOP is another example. It focuses on just the top world indices. Other examples are: 0#REUTERS, which displays all markets in chain format, 0#ENERGY, and 0#COMMOD, which lead on to further information about the world’s energy and commodity markets.

Another common application for RIC chains is to identify all derivatives on a particular instrument. Finding all options on an equity RIC is a good example. Suppose you wanted to find the 200 constituents of the S&P ASX 200 because you were interested in options trading on those stocks. Scores of options could be trading for each constituent company. The entry What is a RIC? describes how to construct RICs for options on equity instruments. Implementing those rules is a considerable task for all options of a single stock. It is even more challenging for many stocks. A far simpler method is to use a RIC chain. The RIC chain identifying all options on a single stock is like this “0#BHP*.AX”. In this example “BHP.AX” is the RIC code of the company and “0#” is the prefix signalling RIC chain. The new character, “*”, inserted after the root code, “BHP” and before the exchange identifier, “.AX”, is the options chain character. When “0#BHP*.AX” is added to a New Request screen all options traded on BHP.AX, both puts and calls, will be displayed. There are often more than 800 options for BHP.AX so you can see a RIC chain is a very efficient method to find these.

If you add “++” to the end of an option RIC chain, you can even restrict the results to at-the-money options, which lie within three strike prices above or below a prevailing spot price. “0#BHP*.AX++” is that RIC chain for our BHP.AX example.

A different example of a RIC chain is when the entire collection of futures contracts is required. Like the previous options example, a special character is added to a RIC root, which is preceded by the RIC chain symbols, “0#”. The special character for a futures RIC chain is a “:”. “0#YAP:” is an example of its use. In this case it delivers all futures contracts on the S&P ASX 200 contract, which has a root code of YAP on the Sydney Futures Exchange. The “:” futures chain character follows the RIC root code.

Like at-the-money options, there are also special RIC chains for futures contracts. Often of particular interest are details for futures contracts that are closest to expiry. The identity of such contracts will change, as time proceeds and the closest expires, leaving another contract as the closest remaining. Identification of such series is a task for a RIC chain. The special symbol now is a “c1”. The “1” (one) here indicates the first contract to expire. A “2” (two) would locate a series of second contracts to expire. Similarly for a “3”. The complete YAP example for a first level continuation RIC is “0#YAPc1”. (Note the case of letters is important and must be entered precisely with the “c” being in lower case and everything-else in upper case).

More information and examples of RIC chains can be found at these other Dinkum Data entries: for futures see Tick History / Futures / Instrument Codes, and for options on futures go here, Tick History / Options on Futures / Instrument Codes.

Another useful resource for RIC chain examples is the Search screen of TRTH. You normally use the Search screen when you want to identify instruments by name or exchange, rather than RIC. However, the Search screen is also helpful for RIC chain construction because it gives examples of RIC chains for each Asset Class. The screen shot below shows the Search screen for the Commodities & Energy Asset Class. At the bottom of that screen is an example chain “0#LPG-“ which applies to this asset class. Screens for other Asset Classes are similarly helpful. For instance, on the Economic Indicators Search screen you will see 0#ECONUS as an example. This provides a selection of US economic indicators. Other examples are 0#ECONALLUS for all US economic indicators, 0#ECON for all indicators across countries and 0#ECONCPI for CPI measures across countries.

Two matters remain to be clarified. The first is the single exception to “0#” as the chain prefix. This is “Z#”. Use “Z#” when you require information on US options reported through the Options Price Reporting Authority (OPRA). For example, “Z#IBM*.U” will deliver all IBM options available through OPRA.

The final matter concerns your TRTH preference settings. RIC chains are expanded according to selections made under the category of Expand Chain RIC on the Preferences page of Settings. If you select At start date then the RIC chain is expanded into its components at the beginning of your sample period. (Your sample period is defined in the bottom left had corner of a New Request screen). This is appropriate when you define your sample at the start of your observation interval. For example, which companies are constituents of the S&P ASX 200 at the beginning of your sample? You should receive 200 different company RICs. If you choose At end date then RIC expansion occurs on the last date of the your sample period. This finds companies that are S&P ASX 200 constituents on the final day of your sample period. Again, you should receive 200 different company RICs (which also differ from the At start date sample, when these dates are distant from each other). Finally, if you choose Over date range then any RICs that are members of your chain between the start and end of your sample period will be identified. This would deliver all companies that had been S&P ASX 200 constituents at any time between your sample start and end dates. It should be a list of more than 200 different company RICs for every sample period long enough to span changes to the composition of the S&P ASX 200.

What is a RIC?

Reuters Instrument Codes (RICs) are proprietary identifiers for every security, instrument or service distributed across Thomson Reuters real-time network and therefore captured in Tick History.

RICs have well defined structures that differ according to the instrument they identify. A RIC for a common share has a different structure to that for an option, or warrant, which is different again from that for a bond issue, or a futures contract, or a foreign exchange transaction. Differences are due to the characteristics of the instruments concerned. Instruments like options, bonds and futures all have maturity dates, which must be included in their respective RICs in order to uniquely identify each security. Strike prices, coupon rates and contract term can be other relevant attributes. None of these are required for the RIC of a common share.

The simplest RICs are those for a common share traded on organised, regulated exchange. Their structure is generally:

“Exchange Ticker code” + “.” + “Exchange Identifier Code”

The period, “.”, in this RIC is a delimiter separating the Ticker and Exchange Identifier codes. Other delimiters are also used in RICs. Some of these are mentioned briefly below.

An example of a common share RIC is “BHP.AX”. “BHP” is the ticker code for the common shares of BHP Billiton Limited, listed on the Australian Securities Exchange (ASX). “.” is the delimiter for an equity instrument and “AX” is Thomson Reuters’ code for the ASX. Another example is “VOD.L”. This refers to Vodafone Group, whose ticker is “VOD”, listed on the London Stock Exchange, with exchange identifier “L”. A final example is “IBM.N” for International Business Machines Corporation, with ticker “IBM”, listed on the NYSE, whose exchange identifier is “N”. Once you know a company’s ticker code, or root code, you only need the exchange identifier to build the appropriate RIC for its common shares.

Exchange identifiers can all be found in TRTH’s Speedguide, on pages EXCHID02 through to EXCHID17. An index for each of these appears on page EXCHID01 (see our separate entry, Speedguide Explained, for more information on the Speedguide and how to use it). A recent snapshot of exchange identifiers on a particular date can be seen here Tick History – Exchange Identifiers

Consolidation RICs are one exception to the previous rule for equity RICs. Consolidation RICs identify trades and quotes, which are consolidated across several North American Exchanges to deliver the best quotes available. Consolidation RICs contain no equity delimiter or exchange identifier (e.g. “IBM” is the consolidation RIC for IBM) and will be described in a separate Dinkum Data entry.

RIC definitions for other instrument types are also described elsewhere in Dinkum Data. RICs for futures are explained here, Tick History / Futures / Instrument Codes, RICs for options on futures are here, Tick History / Options on Futures / Instrument Codes, and for foreign exchange transactions at Tick History / Foreign Exchange / Instrument Codes.

The Speedguide is another useful resource. Page RULES1 is an index of RIC definitions for futures (RULES2 and RULES5), options (RULES2 and RULES7), options on futures (RULES2 and RULES 5), continuation futures (RULES2 and RULES6), identifiers for exchanges trading futures and options (RULES 3 and RULES 4), plus more.

The previous references are recommended for detailed descriptions of RIC structures applicable to non-equity instruments. However, brief descriptions of several RIC structures follow to illustrate the variety of instruments they can represent. It is not an exhaustive list of those structures.

Options on Equity

Ticker Code + Expiration Month Code + Expiration Day + Expiration Year Code + Strike Price + “.” + Exchange Identifier Code

Examples

BHP3000A1.AX is a call option on BHP common shares expiring at the end of January 2011 with a strike price of 3000 cents, traded on the ASX. BHP3000M1.AX is the put option with the same expiry and strike price. VOD160N1.L is a put option on VOD common shares with a strike price of 160 pence, expiring in February 2011 and trading on the Euronext LIFFE exchange. VOD160F2.L is a call option on the same exchange with strike price of 160 pence expiring in June 2012. IBML311012500.U is a call option on IBM expiring in December 31 2010 with a strike price of 12500 cents and IBMX311012500.U is the corresponding put option. Prices for both IBM options are sourced from the Options Reporting Authority (OPRA).

Futures

Root Code + Delivery Month Code + Expiry Year Code

Examples

YAPF1 corresponds to a futures contract on the ASX/S&P 200 index that expires in January 2011. YAP” is the root code, “F” the delivery month code and “1” the delivery year code. Similarly, SPH1 is a futures contract on the S&P 500 index expiring in March 2011 (“SP” + “H” + “1”); CIFG1 is a futures on the Chinese CSI 300 expiring in February 2011 (“CIF” + “G” + “1”); and FTSEBF1 is a futures on the FTSE/ATHEX-CSE Greek Banking index with January 2011 expiry (FTSEB” + “F” + “1”)

Options on Futures

Root Code + Strike Price + Expiry Month Code + Delivery Year Code

Examples

GC190H1 is a call option with a strike price of $US190 expiring in July on a futures contract for 100 troy oz of gold that matures in August 2011 (“GC” + “190” + “H” + “1”). GCQ1 is the RIC for that underlying gold futures (“GC” + “Q” + “1” using the previous definition for RIC futures). Similarly, GC350X6 is a put option with strike price $US350, expiring in November on a futures contract for 100 troy oz of gold that matures in December 2016 (“GC” + “ 350” + “X” + “6”). The underlying gold futures RIC is GCZ6.

Foreign Exchange

Spot rates: ISO Country Code + “=”

Examples

EUR= or AUD= the default base currency is usually USD and these RICs refer to exchange rates for Euros per US dollar and Australian dollars per US dollar.

Cross rates: ISO Country Code base currency + ISO Country Code + “=”

Examples

EURAUD= gives the number of AUD per one EUR; GBPCHF= provides the number of Swiss francs per one pound stirling.

Forward rates: ISO Country Code + Delivery Period Code + “=”

Examples

GBP2M= is a contract to exchange GBP for USD in 2 months.

As you can see from the previous examples, RICs are enormously versatile, so much so in fact that they accommodate all the instruments available in TRTH. They can become quite complex and although it is possible to construct RICs for yourself once you understand their structure, it is often much easier to use another feature of RICs called a chain. Entire families of RICs can be easily identified and filtered via RIC chains, which are extremely powerful and will be the subject of their own Dinkum Data entry.