'Datastream User Guide\r'

'INFOSTREAM whitethorn/JUNE cc8 IN THIS erupt app sackage IN US centre talk terms the military personnel’s â€Å"info-noise” with selective developmentstream’s expansive and trusty US-focused circumscribe. sensitive VALUATION RATIOS RELEASED 14 spic-and-span Datastream military rank proportionalitys occupy been w solely told plugd, giving you a accompanimented over peck of grocerys and domains as advantageously as enabling you to comp ar confederacy to constancy ratios. meansS FEATURES Introducing Intelligent In earnation from Thomson Reuters Regional revolve about †Growth in US center growth ENHANCEMENT Functions, Units and soil Datatype Enhancements b atomic number 18-assed Interface for Datastream usage User-Created Indices in Development Coming Soon †interactive Charting 1. Datastream Extranet Samples CONTENT ENHANCEMENT Equities and fair play Indices Update • world bulky Update • USA Update • Middle to copherol Update • Asia Update I/B/E/S planetary Aggregates means Enhancement †get out of Additional monthly chronicle for Five Asian Indices Datastream Delivers Sought-after good Information from Platts Metals Expansion reporting economics Round-up • in the altogether serial • Revisions and methodological analysis Changes • draw Indicator Changes • matter to Rates newfangled evaluation Ratios Released in March Comp every(prenominal)(prenominal) Additions to conceptionscope CONTRIBUTORS 3 4 12 14 16 20 20 23 25 25 27 28 29 31 31 34 35 35 36 39 41 FEATURES INTRODUCING gifted INFORMATION FROM THOMSON REUTERS THOMSON DATASTREAM IS NOW PART OF THOMSON REUTERS. With operations in 93 countries, a grocery place capitalisation in excess of $30 billion and 50,000 employees, Thomson Reuters has the resources and experience to act our employmenters in the m nonpargoniltary, media, legal, tax and accounting, scientific and wellnesscargon food markets.We hold you go forth see many positive changes from Thomson Reuters, head start with our new brand. One thing we do non intend to change, however, is our loading to speed, accuracy, independence and freedom from bias, and our commitment to our customers, employees, sh atomic number 18holders and other(a) stakeholders. We aim to deliver on our predict to bring you intelligent k right offadaysledge that provides k outrightledge to act. regional FOCUS †development IN US CONTENT AMERICA’S DATA OBESITY puzzle: SOLUTION †GO ON A DATASTREAM DIETNegotiate the world’s â€Å"info-noise” with Thomson Datastream’s expansive and reliable US-focused contented. The US investment focus persistence is estimated to be charge over $30 trillion*. To support this financial leviathan, on that point is info in abundance for barter through a host of sources, including the Internet and any subject of financial solutions, reports and deliv ery vehicles, so overmuch so that the vector sum for the end-user is a cacophony of â€Å"infonoise”.The root Neal Stephenson wrote that, â€Å" every last(predicate) reading looks like noise until you split the code. ” With Thomson Datastream, the US plus management persistence has the final code breaker. A modern-day Enigma machine. Thomson Datastream, although supranational in its scope, all toldows unparalleled nettle to a or pull innt of historicly deep, cross- step-up and US-focused selective information, which is being continually expanded to cry knob needs and market developments.Sourced from such(prenominal)(prenominal) certain third base-party suppliers as Frank Russell, The Conference Board, MSCI and The University of Michigan Consumer stacks, to predict but a few, this US-orientated info bath be placed alongside Thomson Datastream’s robust m serial content (100 million serial, including exclusive branded content) to better on a lower floorstand the performance of the US markets and throw investment strategies accordingly.INFOSTREAM may/JUN twain hundred8 © THOMSON REUTERS 2008  Current market conditions ar forcing the US investment comm building blocky to work harder to â€Å" give the code” and divisorrate alpha. Thomson Datastream is the â€Å"codec” that exits them to achieve this, with the continual appendix of North Ameri mess-focused content. Recent improvers in Q1 2008 overwhelm Platts good pricing (see page 29) and increased insurance insurance insurance reporting of US Corporate and Sovereign bonds.The Platts selective informationbase is directly operable as a pass-through content distinguish, and this market-leading entropy provides a full of life insight for goodness-oriented investors in the USA, giving granular situation on the elan vital markets, allowing analysts of the energy sector, risk managers, commodity barterrs, as fasten managers and a nyone wishing to diversify into commodities, the tycoon to view this valuable data, overlie the information against other instruments and command it within Thomson Datastream’s powerful charting and analytical capabilities. Furtherto a greater extent, the modern assenting of 14,000 US bonds signifi stinkpottly increasesUS fixed-income coverage to 43,000 securities for Government, say-so and Corporate bond issues. Within the scotch sphither, Thomson Datastream allows ingress to crucial US-oriented sources to enable the investment management application to crumble macro factors. For simulation, US House tolls, of all condemnation a â€Å"hot topic”, argon under so far to a greater extent than scrutiny when placed within the catamenia subprime context and wider economic conditions. Sources including the home(a) standstill of Realtors (NAR), the Mortgage bevelers Association and the S&P Case-Shiller indicators all give greater visibility into US e conomic health and direction.The chart at a lower place uses Shiller state- take aim data and compargons hearthstone sales by major US cities. We earth-closet see that only in Charlotte, North Carolina, energise house sales covered positive year on year, in 2007 albeit at a low 1. 75% level. The continuing crisis, and in crabby the example of bear out Stearns, has soaringlighted the importance of having citywide cross-as pit coverage obtainable to the asset manager, with denotation default swaps often cited. The CDS market is worth(predicate) round $47 trillion and is demanding constant attention. Thomson Datastream carries a kitchen stove of US-oriented CDS content, including aluable benchmarks for the USA such as the CDX. This indication comprises the most liquid CDS contracts of US- base companies and acts as an indicator of the extension markets. The chart at a lower place shows clear negative correlativity among the CDX great power (North Ameri tail end swap s for investment-grade bonds) and the S&P Composite. INFOSTREAM may/JUN 2008 © THOMSON REUTERS 2008  These, and other CDX indices, measure debt-related derivatives, such as high-yield swaps, and enable US-focused asset managers to hedge their entire portfolios rather than trade from each(prenominal) one individual CDS per bond issue.Sir Arthur Conan Doyle once had Sherlock Holmes remark that, â€Å"It is a capital slide to theorise before one has data. ” Recently launched proprietary global CDS sector indices and the US-orientated suite, exclusive to Thomson Datastream, allow for greater tactical asset allocations across a portfolio, since the CDS market often captures market information faster than the honor markets. On the comprehension of this content, one commandor of question at a US asset management firm commented, â€Å"The CDS indices argon a great innovation. throw out you provide us with the full global range? No-one else has this data. ” Elementary my dear financial markets!The quest example equivalences the US CDS lodgeing sector against devil US fill rate futures indicators. This analysis illustrates that the movement in the US beaching CDS sector anticipated the credit crisis by a little under devil weeks, and shows the starchy correlations (nine and ten-day immure against the sector respectively) that the futures make, comp ard to the sector. INFOSTREAM may/JUN 2008 © THOMSON REUTERS 2008  new(prenominal) modernly add uped proprietary Thomson Datastream content that lends itself to greater investigation and analysis of the US markets is the M&A serial publication constructed from Thomson data.This content, overlaid against the CDS indices, can overhaul give a clearer indication of the overall health of the M&A act in the USA. With the credit crisis in August 2007, the number of completed deals that followed in September dropped and the spread in the CDX exponent correspondingly fe ll, as traders felt the deal market drying up. That relationship has broken down during the first quarter of 2008, which may be cod to other economic factors. INFOSTREAM whitethorn/JUN 2008 © THOMSON REUTERS 2008  Thomson Datastream’s US-focused content is continually expanding.Across all asset classes, data is being added to ensure that the solution fits the high demands of the North American market, be it through the addition of macroeconomic indicators from such sources as S&P Case-Shiller, or through the intro and access of every quarter funda affables. And this investment is ongoing with in short-to-beadded US option coverage for the USA (S&P 500 and the Nasdaq) and Canada. Access to timely, panoptic and accurate data is ever more grave in a world where decisions set out to be do fast.Thomson Datastream’s deep US coverage, across multiple asset classes, allows the US financial manufacturing to cut through the â€Å"infonoise”, access vital moldiness-have information and manipulate it with flexible analytical tools. In these current uncertain times, Thomson Datastream’s blend of reliable, multiple-asset, US content enables investors to make better, more-informed decisions and help avoid the pitfalls best summed up by an old Chinese proverb, which states, â€Å"To risk is cheap. To guess wrongly is expensive. ” *Thomson Sharewatch. stupidd on the AUM from more than 4,000 US companies. INFOSTREAM whitethorn/JUN 2008 THOMSON REUTERS 2008  PRODUCT ENHANCEMENT FUNCTIONS, UNITS AND kingdom DATATYPE ENHANCEMENTS The cushioning ( peg a demeanor) fit has been enhanced to enable set for absent intermediate data points to be derived via additive interpolation, so any missing (N/A) look upons within the time serial provide be calculated by birtharly interpolating between the substantial data values on all side. The format to use linear interpolation is PAD#(Expression, I). Example: To display the FTSE100 determine high (PH) from December 2007 to January 2008 †there are N/A values for Christmas and New Year when the market is closed.Using the brisk PAD dish (without the I contention) the N/A values are replaced by carrying former the last actual value for the previous point. Whereas use the PAD start with the I parameter (last column below), the N/A values are replaced by values calculated by interpolating between the data either side, thereby producing a more ordered series. Code 20/12/2007 21/12/2007 24/12/2007 25/12/2007 26/12/2007 27/12/2007 28/12/2007 31/12/2007 01/01/2008 02/01/2008 03/01/2008 04/01/2008 07/01/2008 FTSE100(PH) 6367. 7 6451. 8 6485. 6 #N/A #N/A 6504. 1 6494 6480. #N/A 6512. 3 6487. 8 6534. 7 6376. 5 PAD#(FTSE100(PH)) 6367. 7 6451. 8 6485. 6 6485. 6 6485. 6 6504. 1 6494 6480. 2 6480. 2 6512. 3 6487. 8 6534. 7 6376. 5 PAD#(FTSE100(PH),I) 6367. 7 6451. 8 6485. 6 6491. 77 6497. 93 6504. 1 6494 6480. 2 6496. 25 6512. 3 6487. 8 6534. 7 6376. 5 The continuous series (CSR) help has been enhanced, specifically for economic series, to allow quarterly series to be displayed at a periodic relation relative frequency apply linear interpolated values, with a similar sweetener for annual series to be displayed at a quarterly or calendar calendar monthly frequency.The format to display interpolated values is CSR#(Series,M) or CSR#(Series,Q). Example: To display 2 quarterly series at a monthly frequency †linked States gross domestic product in factual terms and the Eurozone 15 countries’ gross domestic product in unfeigned terms. The actual quarterly data is: Code 15/05/2006 15/08/2006 15/11/2006 15/02/2007 15/05/2007 15/08/2007 15/11/2007 USgross domestic product…D 11306. 7 11336. 7 11395. 5 11412. 6 11520. 1 11658. 9 11677. 1 EKGDP…D 1859. 84 1870. 18 1884. 62 1899. 5 1904. 74 1919. 03 1926. 38 hither, the US series is in billions of dollars at an annual rate, the Eurozone series is in billions o f euros but not annualised.As the panel below illustrates, the CSR function without the M parameter simply repeats the quarterly value for each month of the quarter, but with the M parameter the data is presented in a more kindred way by interpolating between the quarterly numbers. For the United States series, the mid-quarter value of the monthly series is the homogeneous as the original quarterly series, whereas for the Eurozone series the mid-quarter value of the monthly series is one third of the original series. This is due to Eurozone GDP not being annualised, so the monthly numbers in the final column below represent the â€Å"best” estimate of actual GDP in that month.Code 15/07/2006 15/08/2006 15/09/2006 15/10/2006 15/11/2006 15/12/2006 15/01/2007 15/02/2007 15/03/2007 15/04/2007 15/05/2007 15/06/2007 15/07/2007 15/08/2007 15/09/2007 15/10/2007 15/11/2007 CSR#(USGDP…D) 11336. 7 11336. 7 11336. 7 11395. 5 11395. 5 11395. 5 11412. 6 11412. 6 11412. 6 11520. 1 11520. 1 11520. 1 11658. 9 11658. 9 11658. 9 11677. 1 11677. 1 CSR#(USGDP…D,M) CSR#(EKGDP…D) 11326. 7 11336. 7 11356. 3 11375. 9 11395. 5 11401. 2 11406. 9 11412. 6 11448. 4 11484. 3 11520. 1 11566. 4 11612. 6 11658. 9 11665 11671 11677. 1 1870. 18 1870. 18 1870. 18 1884. 62 1884. 2 1884. 62 1899. 5 1899. 5 1899. 5 1904. 74 1904. 74 1904. 74 1919. 03 1919. 03 1919. 03 1926. 38 1926. 38 CSR#(EKGDP…D,M) 622. 24 623. 39 625 626. 6 628. 21 629. 86 631. 52 633. 17 633. 75 634. 33 634. 91 636. 5 638. 09 639. 68 640. 49 641. 31 642. 13 The rules for calculative these values are as follows (these are impose by the frequency con variate datatype (ECONV)): • If ECONV = AVERAGE (example USGDP…D) †the actual quarterly number is placed in the mid-month of the quarter, and the interact two months are linearly interpolated between the coterminous midquarter numbers. If ECONV = END POINT (example US64MGTLA †mortgage debt of the US financial sector), the a ctual quarterly number is placed in the last month of the quarter, and then the intervening two months are linearly interpolated. • If ECONV = SUM (example EKGDP…D), one third of the quarterly number is placed in the mid-month of each quarter, and the intervening two months are linearly interpolated between the mid-quarter numbers. INFOSTREAM whitethorn/JUN 2008 © THOMSON REUTERS 2008 0 Annual series can be similarly represented at either a monthly or quarterly frequency using CSR#(series,M) or CSR#(series,Q). This new function allows a closer analysis of quarterly series on a monthly basis. For example if we correlate European Union supply GDP (EXGDP…D) against United States GDP (USGDP…D), over the last ten years using a range of monthly tuck ins, we find that the highest correlation, of 0. 99707, is with an 11-month lag of the US series.Note: These new parameters will be amply supported in a later version of the travel interface †but can be used instanter either directly in AFO, or in the expression builder (where the put across that the parameter is unk todayn can be ignored). The economic science magnitude (ESMAG) datatype, which displays the magnitude of the data as a number, eg k for thousand, million for million, etc, has been enhanced so that it is now supported in Datastream expressions.This is useful for displaying a set of economic series data in the same units. In the example below, the total exports of visible goods for a selection of countries are displayed in millions of dollars for the year 2007 total. This is achieved by using the calendar year sum function CYS, converting all series to dollars using the tilde, multiplying by ESMAG and dividing by 1,000,000. In the analysis below the top 3 countries are (in order) Germany, China and United States.EXPORTS IN in style(p) PRICES TYPE AGEXPGDSA AUEXPGDSA CNEXPGDSB CHEXPGDSA FREXPGDSB BDEXPGDSB HKEXPGDSA INEXPGDSA IDEXPGDSA IREXPGDSA ITEXPGDSB JPEXPGDSB K OEXPGDSA MYEXPGDSA MXEXPGDSA NLEXPGDSA NZEXPGDSA NWEXPGDSA RSEXPGDSA SPEXPGDSA SAEXPGDSA ESEXPGDSA SDEXPGDSB SWEXPGDSA TWEXPGDSA THEXPGDSA UKEXPGDSA USEXPGDSB ESUNT US $ one million million million AUST $ MILLION send away $ MILLION 100 MLN US$ EURO MILLIONS EURO BILLIONS HONG KONG MN$ IND rupee BLN US $ MILLION EURO THOUSANDS EURO MILLIONS YEN BILLION US $ MILLION RINGGIT MLN US $ MILLION EURO MILLIONS NZ$ MLN NRWGN KR MLN US $ MILLION SINGAPORE $’000 RAND MILLION EURO THOUSANDS SWEDISH KR MLN SWISS FRANC MLN mainland China $ MLN US $ MILLION ?MILLION US $ MILLION GEOGN ARGENTINA AUSTRALIA CANADA CHINA FRANCE GERMANY HONG KONG INDIA INDONESIA IRELAND ITALY lacquer KOREA MALAYSIA MEXICO NETHERLANDS NEW ZEALAND NORWAY Russian FEDERATION SINGAPORE southeastern AFRICA SPAIN SWEDEN SWITZERLAND mainland China THAILAND linked KINGDOM join STATES X(ESMAG) jillion jillion one thousand thousand meter00000 curtilage000 one thousand million 1000000 1000000000 1000000 1000 100 0000 1000000000 1000000 1000000 1000000 1000000 1000000 1000000 1000000 1000 1000000 1000 1000000 1000000 1000000 1000000 1000000 1000000 ESMAG EXPORTS-MILLIONS OF DOLLARS YEAR 200 CYS#(X~U$*XESMAG/1000)/1000 55933. 98 140975. 1 417035. 5 1217869 551328. 3 1330984 344676. 1 145260. 2 113953. 7 12cl4 491841 713111. 3 371489 176038. 3 272044 476323. 3 26946. 69 139232. 8 355176. 7 298876. 9 69661. 69 248555. 9 169700. 5 171465. 5 246181. 4 152480 436985. 3 1163314 INFOSTREAM whitethorn/JUN 2008 © THOMSON REUTERS 2008 11Two new terra firma datatypes (GGISO and GGISN) have been introduced on Datastream: GGISO ISO Country Code GGISN ISIN Issuer Country The followers table illustrates some examples: get to ASM PACIFIC TECH C C LAND HOLDINGS CARNIVAL EADS (PAR) FRONTLINE GARMIN INVESCO MILLICOM INTL CELU SDB NWS HOLDINGS PARTNERRE PARTYGAMING QIAGEN (XET) RENAISSANCERE HDG royal CARIBBEAN CRUISES ROYAL DUTCH SHELL A(LON) MNEM K:ASMP K:QPAK U:CCL F:EADS N:FRON @GRMN U:IVZ W:MICB K:P APO U:PRE PRTY D:QIAX U:RNR U:RCL RDSA GEOGN HONG KONG HONG KONG coupled STATES FRANCE NORWAY UNITED STATES UNITED STATES LUXEMBOURG HONG KONG UNITED STATES UNITED KINGDOM GERMANY UNITED STATES UNITED STATES NETHERLANDS GGISO HK HK US FR NO US US LU HK US GB DE US US NL GGISN KY BM PA NL BM KY BM SE BM BM GI NL BM LR GBNEW INTERFACE FOR DATASTREAM CUSTOM USER-CREATED INDICES IN DEVELOPMENT Datastream has provided facilities for creating your own custom indices for a number of years, through an integrated interface in progress and Advance for Office (AFO) and a more comprehensive terminal interface. These indices are used drawn-outly for evaluating divergent investment strategies and for use as portfolio benchmarks. We currently have in development a new Advance/AFO interface, offering a range of exciting features. These include support for an wide set of weighting methods (in addition to the current market value weighting method) †such as equal weighting, topical anaesthe tic currency, free mess up and using your own weights (as either a factor or a number of shares). INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 12 major power creation interface currently in developmentThe new interface will also serve the building and configuration of indices with more complex changes to their account statement, so in addition to supporting the importing of a set of contributions for a single point in time (either to use for the full indicator write up, or to use going forward), these facilities will allow changes to lots and weights at different dates to be imported directly from outgo †enabling an Excel range pick outing the complete tarradiddle of portion changes, reflecting either an investment strategy or specific stock selection, to be easily set up on Datastream. Equally, for indices already set up, the percentage history can be exported to Excel, and any changes make before being imported venture to Datastream.We are also working on e xtending the set of datatypes that can be calculated for indices beyond the current add up ( expense great power, return top executive, market value, dividend yield and price earnings) †this will include the 15 new valuation measures that have recently been introduced for equities and Datastream uprightness indices. These include key measures such as sales, profits, debt, and a set of ratios such as return on equity and profit margin. Finally, in addition to supporting equities, the new interface will also support using other indices, and unit trusts as constituents. So, for example, you will be able to get to a market value burden force using thirdparty indices, Datastream indices or other custom user-created indices as their constituents. Further information will be made available via the Datastream Extranet when this new interface becomes available. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 13 COMING SOON †INTER brisk CHARTING 1. 6The next release of Inte ractive Charting will be available before long to all users of Datastream Advance . 0 and will allow users to save their own user-created â€Å" bearings” for charts. Preferences for fonts, colours, chart background and line styles can be specify, stored as a style and then applied to any chart in the user’s library. In addition, it will now be possible to set up custom colours and store these as part of your style. curry text style for your chart title, subtitle and story: Set colour, thickness and style of the chart lines: employment colours can also be defined: INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 1 Save the settings with a name of your choice: INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 1 DATASTREAM EXTRANET SAMPLESThe Datastream Samples page on the Extranet is a valuable source of content and functionality-related AFO tearsheets, that cotton up the breadth and depth of content within the Datastream mainframe. everywhere the last few mo nths, more sit arounds have been added, reservation access to existing and new content sets scour easier. Some of the new sheets are detailed below, chew the fat the Extranet site at: http://extranet. datastream. com/Free_Reports/AFO_SAMPLES. htm and look for the icon for more. Indices †Worldscope great power Valuations This new model displays a unique set of valuation datatypes for Datastream world-wide integrity Indices. Sourced from Worldscope and based on a trailing 12-month period if applicable, the datatypes include such popular items as EBITDA, Enterprise valuate and punkEX. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 1 frugals †Recession Bands Using the academic, two quarters of successive negative QOQ GDP growth, count of recession, this model allows users to select a country and overlay one of several(prenominal) pre-defined series such as Consumer Spending, industrial proceeds and Unemployment rate figures. The chart period can be customised an d a user-defined overlay series can also be utilised. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 1 Options †Implied Volatility Surface Using Datastream’s extensive Options database, this model plots the implied volatility as a function of both the strike price and time to maturity. The resulting graph shows the implied volatility for all the options on a particular underlying series. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 1Equities †strike carrying into action Indicators from Worldscope Effective 15 November 2007, Thomson Financial added lynchpin achievement Indicators (KPIs) for the Hotel, Airline and retail sectors. Initially for the Russell 3000 superpower finger constituents, this model displays the current indicators for all qualifying constituents. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 19 CONTENT ENHANCEMENT EQUITIES AND EQUITY INDICES UP interpret This month sees the release of extra valuation datatypes for the Russell indices. Changes to the way S&P constituent data is provided are powerful from 1 June 2008 and customers are advised to read this cautiously and take action if required. New sharia law indices are also available from S&P and FTSE.Read on for all the details. Global Update S&P Constituent Data †End-User Agreement Now involve for Access to Constituent-Level Data With effect from 1 June 2008, there is a change to the way constituent data for a number of S&P constituent families is provided on a number of Thomson products, such as Datastream, DDL, Datastream Advance in T1IM. From 1 June 2008, customers wishing to insure to access constituent datatypes such as constituent weights, number of shares and free-float data are required to have a direct end-user agreement with S&P. For each list family impacted by this change, a new module is available that provides access to the restricted datatypes.The name and identifiers of each security within each consti tuent amount are not impacted by these changes and will remain unrestricted. This change is a result of S&P no longer licensing constituent-level index data for wholesale distribution through vendors to their clients. New modules created for each of the following index families impacted by this change: S&P US indices This includes the S&P 500, S&P MidCap 400, S&P SmallCap 600, S&P Composite one hundred fifty0, S&P 1000, S&P 900, S&P 100, S&P REIT Composite, S&P Citigroup Style and all underlying sector, industry and style indices. S&P Australia This includes the S&P/ASX 50, S&P/ASX 100, S&P/ASX 200, S&P/ASX 300 and every(prenominal) Ordinaries Indices and all underlying sector, industry and style indices.S&P Global 1200 This includes the S&P Global 1200, S&P Europe 350, S&P/Topix 150, S&P/TSX60, S&P Asia 50 and S&P Latin America 40 and all underlying sector and indus try indices. S&P/MIB This includes the S&P/MIB index. S&P/HKEx This includes the S&P/HKEx Hong Kong indices including the S&P/HKEx Composite index. S&P/ lacquer This includes the S&P Topix 150 index. Restricted Constituent List Datatypes From 1 June 200, the following datatypes are available only in the new modules. The restrictions also apply to these constituent datatypes provided for S&P historical constituent refers. Please raze that not all datatypes are available or valid for all the S&P index families detailed above.A more detailed list, along with all the constituent list mnemonics, is provided on the Datastream Extranet. The names and identifiers of each security within each constituent list are not impacted by these changes and remain unrestricted. DATATYPE WTIDX PIDX NSIDX FFIDX MVIDX CFIDX AFIDX CLS1 CLS1N CLS2 CLS2N CLS3 CLS3N CLS4 CLS4N DESCRIPTION broker WEIGHT PRICE OF each(prenominal) CONSTITUENT IN THE disdain le ader NUMBER OF SHARES include IN THE world power FREE-FLOAT FACTOR OF from each one CONSTITUENT IN THE INDEX MARKET determine OF EACH CONSTITUENT IN THE INDEX upper-case letterPING FACTOR fitting FACTOR GICS SECTOR CODE GICS SECTOR throw GICS INDUSTRY chemical group CODE GICS INDUSTRY GROUP relieve oneself GICS INDUSTRY CODE GICS INDUSTRY NAME GICS SUB-INDUSTRY CODE GICS SUB-INDUSTRY NAMEACTION REQUIRED In order to inform the impact of these changes, it is advisable that you review as soon as possible if you wish to continue to access the above constituent list datatypes. If you do, you should contact S&P to hash out this or complete the form in the attached notification and send it to S&P: http://extranet. datastream. com/data/Equity%20indices/ If you wish to discuss this directly with S&P, please contact one of the following: Americas: Maureen O’Shea EMEA: John Davies Asia: Angeline Choo ANZ: Guy Maguire japan: Uchi Seiichiro Shariah Indices maureen _o’[email&# one hundred sixty;protected] com +212 438 6174 [email&#clx;protected] com +44 (0)20 7176 8456 [email&# one hundred sixty;protected] com +65 6239 6318 [email&# one hundred sixty;protected] com +61 292 559 822 [email protected] com +813 4550 8568 INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 21 A number of new Shariah indices are now available on Datastream. S&P Pan-Asia Shariah index The stocks for this index are drawn from the Asian country indices in the S&P/Citigroup Global Equity Index series, excluding Australia, lacquer and New Zealand. Stocks for the universe must have at least US$ 1 billion in float-adjusted market capitalisation. The number of stocks, for Shariah screening purposes, is express to the top 15 from each country that exceeds the US$1 billion market capitalisation threshold.Each month a universe of stocks conforming to these criteria, selected once a year on 31 March, is screened for Shariah respect to form this index. The countries eligible for inclusion in this index are China, Hong Kong, India, Malaysia, Philippines, Singapore, due south Korea, Taiwan and Siameseland. S&P Global and World Property Shariah index The S&P/Citigroup Global Property index represents and measures the investable universe of publicly traded property companies from developed and rising markets. The constituents are companies engaged in a wide range of real estate related activities, such as property management, development, rental and investment.The component REIT stocks, in particular, include property trusts that invest in sensual real estate assets and other pass-through vehicles. The S&P/Citigroup World Property Index is a subset of the Global Property Index and includes companies from the developed markets only. Each month a universe of stocks conforming to these criteria, selected once a year on 31 March, is screened for Shariah submission to form these indices. INDEX NAME S&P PAN-ASIA sharia law $ S&P PAN-ASIA shariah E S&P WORLD blank space SHARIAH $ S&P WORLD shoes SHARIAH E S&P GLOBAL PROPERTY SHARIAH $ S&P GLOBAL PROPERTY SHARIAH E mnemotechnic SPSHPA$ SPSHPAE SPWPRS$ SPWPRSE SPGPRS$ SPGPRSEDATATYPE PI, RI, NR, MV PI, RI, NR, MV PI, RI, NR, MV PI, RI, NR, MV PI, RI, NR, MV PI, RI, NR, MV proceed DATE 29/12/06 29/12/06 29/12/06 29/12/06 29/12/06 29/12/06 INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 22 FTSE Shariah lacquer 100 $ index FTSE extended its FTSE Shariah Global Equity index family on 3 March 2008 with the release of the FTSE Shariah japan 100 $ index. This index represents the performance of the 100 biggest Shariah-compliant companies by full market capitalisation, that are include in FTSE Japan index. The index is calculated in USD and history is available from 3 March 2008. The index mnemonic is FSJP10$. Further information can be constitute on: http://www. ftse. om/Indices/FTSE_Shariah_Global_Equity_Index_Series/ Down loads/FTSE_Shariah_Japan_100_USD_Valuation. pdf USA Update Russell †Additional Datatypes for benchmark Indices Thomson Reuters has released new datatypes for the Russell bench mark indices. The new datatypes include price to book value (BP), price to cash fertilize (PC), price to sales (PS), return on equity (RE) and return on assets (AR), and complement the existing coverage of price earnings ratio (PE), dividend yield (DY) and market value (MY) for the same indices. Customers who have access to the existing Russell Standard or Russell Premier pass-through modules will be able to access the new datatypes. Click on this link for more details: http://extranet. datastream. om/data/Equity%20indices/documents/Russellreleasemessagev2. doc The valuation ratios are updated at approximately 09:00 GMT on every sixth personal credit line day of the following month. INDEX DESCRIPTION RUSSELL bakshish 50 RUSSELL TOP 200 RUSSELL TOP 200 GROWTH RUSSELL TOP 200 VALUE RUSSELL 1000 RUSSELL 1000 GROWTH RUSSELL 1000 VALUE RUSSELL 2000 RUSSELL 2000 GROWTH RUSSELL 2000 VALUE RUSSELL 2500 INDEX MNEMONIC RRUST50 RRUS200 RRUS20G RRUS20V RRUSS1L RRUS1GR RRUS1VA RRUSS2L RRUS2GR RRUS2VA RRUS250 DATATYPES PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PCBASE DATE 30/01/1998 31/01/2002 29/12/1978 31/01/2002 31/03/1986 31/01/2002 31/03/1986 31/01/2002 29/12/1978 31/01/2002 29/12/1978 31/01/2002 29/12/1978 31/01/2002 29/12/1978 31/01/2002 29/12/1978 31/01/2002 29/12/1978 31/01/2002 29/12/1978 31/01/2002 INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 23 RUSSELL 2500 GROWTH RUSSELL 2500 VALUE RUSSELL 3000 RUSSELL 3000 GROWTH RUSSELL 3000 VALUE RUSSELL 3000E RUSSELL 3000E GROWTH RUSSELL 3000E VALUE RUSSELL SMALL CAP COMPLETENESS RUSSELL SMALL CAP COMPLETENESS GROWTH RUSSELL SMALL CAP COMPLETENESS VALUE RUSSELL MIDCAP RUSSELL MIDCAP GROW TH RUSSELL MIDCAP VALUE RUSSELL MICROCAP RUSSELL MICROCAP GROWTH RUSSELL MICROCAP VALUE RRUS25G RRUS25V RRUSS3L RRUS3GR RRUS3VA RR3000E RR30GRE RR30VAE RRS3XSD RRS3GXD RRS3VXD RRUSMID RRUSMIG RRUSMIV RRUSMIC RRUSMGR RRUSMVAPS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC PS, RE, BP, AR PC 31/03/1986 31/01/2002 31/03/1986 31/01/2002 29/12/1978 31/01/2002 30/03/1979 31/01/2002 30/03/1979 31/01/2002 30/06/2005 30/06/2005 30/06/2006 30/06/2006 30/06/2006 30/06/2006 31/12/1979 31/01/2002 31/12/1979 31/01/2002 31/12/1979 31/01/2002 29/12/1978 31/01/2002 31/03/1986 31/01/2002 31/03/1986 31/01/2002 30/06/2005 30/06/2005 30/06/2006 30/06/2006 30/06/2006 30/06/2006Global Property interrogation Two new indices from Global Property look for are now available on Datastream. record is available from 28 March 2008. INDEX NAME GPR 250 PSI CHINA GPR 250 PSI CHINA E GPR 250 PSI CHINA $ GPR 250 REIT CHINA GPR 250 REIT CHINA E GPR 250 REIT CHINA $ MNEMONIC GPR2CHL GPR2CHE GPR2CH$ GPRRCHL GPRRCHE GPRRCH$ DATATYPE PI, RI, MV, DY, NE PI, RI, MV, DY, NE PI, RI, MV, DY, NE PI, RI, MV, DY, NE PI, RI, MV, DY, NE PI, RI, MV, DY, NE INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 2 Middle East Update Jordan †Additional Equity Datatypes Thomson Reuters has released additional Jordan unadjusted price datatypes on Datastream from 18 March 2008.The additional equity datatypes are: • unadapted price ask (UPA) • unadjusted price call off (UPB) • Unadjusted price high (UPH) • Unadjusted price low (UPL) • Unadjusted price open (UPO) • Unadjusted trade volume (UVO) The Jordan stocks currently covered on Datastream can be found in the list FJORD. The prices are updated at approximately 12:30 GMT. Asia Update Thailan d †Additional Datatypes grocery value (MV) is now available for all Thailand Stock transpose indices. memoir is available from 25 December 2007. In addition to the MV data, other datatypes are also now available for the Thai industriousness Group Indices †these are: PE, BP, DY, MV, VO and VA. History is available from 25 December 2007.Thailand Benchmark and celestial sphere Indices INDEX NAME BANGKOK clique BANGKOK crash 50 BANGKOK SET 100 THAILAND MAI THAILAND SE AGRIBUSINESS THAILAND SE aliment AND BEVERAGE THAILAND SE FASHION THAILAND SE plate & OFFICE PRODUCTS THAILAND SE PERSONAL PRODUCTS & PHARMACEUTICALS THAILAND SE BANKING THAILAND SE FINANCE AND SECURITIES THAILAND SE INSURANCE THAILAND SE self-propelling THAILAND SE INDUSTRIAL MATERIALS & MACHINERY THAILAND SE PACKAGING THAILAND SE PAPER & PRINTING MATERIALS THAILAND SE PETROCHEMICALS & CHEMICALS THAILAND SE tress MATERIALS THAILAND SE PROPERTY DEVELOPMENT THAILAND SE brawniness & UTILITIES THAILAND SE MINING THAILAND SE COMMERCE THAILAND SE HEALTH CARE SERVICES THAILAND SE MEDIA & issue THAILAND SE PROFESSIONAL SERVICES THAILAND SE tourism & LEISURE THAILAND SE TRANSPORTATION & LOGISTICS THAILAND SE electronic COMPONENTS THAILAND SE INFORMATION & COMMUNICATION TECHNOLOGY MNEMONIC BNGKSET BNGKS50 BNGK100 BNGKMAI BNGKAGR BNGKFDI BNGKFHN BNGKHHG BNGKPPH BNGKBNK BNGKFIN BNGKINS BNGKAUT BNGKIMM BNGKPAK BNGKPPM BNGKPET BNGKCTR BNGKPDV BNGKENG BNGKMIN BNGKCOM BNGKHCS BNGKENR BNGKPFS BNGKHOT BNGKTLO BNGKELC BNGKCMM DATATYPE MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV MV INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 2 Thailand labor Group IndicesINDEX NAME THAILAND SE AGRO & FOOD INDUSTRY THAILAND SE CONSUMER PRODUCTS THAILAND SE FINANCIALS THAILAND SE INDUSTRIALS THAILAND SE PROPERTY & CONSTRUCTION THAILAND SE RESOURCES THAILAND SE SERVICES THAILAND SE TECHNOLOGY MNEMONIC BNGKAGF BN GKCON BNGKFNI BNGKIND BNGKPRO BNGKRES BNGKSER BNGKTEK DATATYPE PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA PE, BP, DY, MV, VO, VA INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 2 I/B/E/S GLOBAL AGGREGATES CONTENT ENHANCEMENT †RELEASE OF spare MONTHLY HISTORY FOR FIVE ASIAN INDICES Thomson Reuters has released additional monthly history for five major indices in Asia to I/B/E/S Global Aggregates.Previously going back only one year, monthly history for these indices now goes as far back as January 2005, with weekly history back to January 2006 †providing even more value-added content. The five series are: COUNTRY TAIWAN TAIWAN TAIWAN MALAYSIA MALAYSIA IGA INDEX NAME TAIWAN SE WEIGHTED TAIEX TSEC TAIWAN 50 TSEC TAIWAN MIDCAP 100 KUALA LUMPUR COMPOSITE INDEX (KLCI) KUALA LUMPUR SE EMAS IGA IDENTIFIER TAIEX TSEC50 TSECMID KLCI KLEMAS DATASTREAM MNEMONIC @:TA IEX @:TASEC5 @:TAMID1 @:MYKLCI @:MYEMAS This additional history was made available with the March 2008 monthly run. For except information or assistance, please contact content. [email protected] com or your local Thomson Datastream customer service or account team. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 2DATASTREAM DELIVERS SOUGHT-AFTER trade good INFORMATION FROM PLATTS trade watchers know that commodities are now in their fifth year of a counterfeit run, with many hitting their all-time high price over the last year or so and drawing the attention of hedge funds, investment houses and others spirit to increase their portfolio weightings in this asset class. Now Thomson Datastream clients can access end-of-day commodity price assessments by way of the industry-leading Platts Dispatch product, to help them reduce risk as they make key trading decisions, value positions and analyse data. • Platts, a division of McGraw-Hill, provides industry-standard comm odity price assessments that are critical elements used to settle short- and long-term nonprescription(a) contracts worldwide. Renowned for their energy commodity coverage, Platts pricings help industry specialists understand commodity price trends and developments. Available on a pass-through basis, Platts Dispatch over Thomson Datastream delivers end-of-day price assessments, third-party data, and an historical database of more than 25,000 commodity time series, many with several decades of data. • Platts commodities data spans: oil and shipping; petrochemicals; metallic elementlic elements; electricity and go down on; coal and emissions; data via American Petroleum constitute Statistics; and Petroleum Administration for Defense Districts’ prices. • Overall, the content is available through 129 data categories, which can be chosen individually or grouped into packages, and may contain one or more of the following data attributes: high, low, bid, ask, mid-pri ce, close and volume.Frequency of series ranges from daily, weekly, monthly or infrequently †priced when an event occurs. • Clients subscribing to Platts content through Thomson Datastream will be able to use its existing functionality and integrate this content with other available leading Thomson Datastream content sets. All clients must maintain a direct agreement, which must be in place with Platts prior to the client being entitled to its data. More information on the data and how clients can obtain an agreement for it can be found on: http://extranet. datastream. com/data/Commodities/Index. htm INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 2 METALS EXPANSION COVERAGEThomson Reuters has expanded Datastream’s metal coverage with an additional 00 new time series, viewing Asian metal spot prices with a explicit focus on the Chinese market and the inclusion of steel price indices and other steel-related products. Customers can now access CRU Steel price in dices for semi-finished and finished nose candy steel products, known to be the most widely used benchmarks in the world steel industry. Complementing these indices are SteelHome’s China Steel price indices. In additional to steel indices, Chinese metal prices from local steelmakers with the following characteristics are now available: • untainted steel • Coke/coal • Iron ore • horseshit iron/scrap • Wire rod/rebar • culture medium plates • CR/HR • Section • Ferro-alloy/non-ferrous INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 29Further amplification with a focus on Asian metal prices is now available for the following categories: • Base metals • shaver metals • Rare earths • Ferro-alloys • Refractories • Iron and steel Chinese Base Metals Comparison INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 30 ECONOMICS ROUND-UP New Series More than 3,000 series have recently been add ed to the economic science database, with particular emphasis on more detail in key coverage areas such as international trade. Some of the highlights are summarised below, with golf links inclined to the applicable study Updates on the Datastream Extranet, where more information and series listings are available. look at concomitant for bomb calorimeter More than 300 commodity trade series are now available for Turkey, as sourced from the Turkish Statistical Institute.Import and export coverage is given by iii different classification schemes: broad(a) stinting Categories, global Standard industrial compartmentalization (ISIC) and Standard supranational backing Classification (SITC). too added were trade by country series. All data is monthly, most with start dates from January 1996. (See case Updates #2780, 2791, 2794 and 2819. ) Trade detail has also been recently added for France and Brazil. See the table below. impudence cogitations for Indonesia Series from the coast of Indonesia’s surveys on business and consumer expectations have been released on Thomson Datastream. The new data includes information about business conditions during the current quarter, as well as expectations for the following quarter, by industry. Concepts covered are business activities, selling prices and usage of labour. 2772) The consumer survey is headlined with troika indices †Consumer sanction Index (CCI), Current scotch chassis Index (CECI) and the Consumer Expectation Index (CEI). Also available are price expectations of major commodities in three and six months’ time, consumption plans and appraisal of economic conditions. (2769) In the News • US housing House bribe price indices, produced by the Office of Federal Housing Enterprise Oversight (OFHEO), are now available. Data is reported for the US total and nine nosecount divisions on a quarterly basis. (2824) • Energy in China Series detailing consumption of energy fuel s and electricity by industry have been added.The statistics are annual, as reported by subject potency of Statistics of China (NBS). (2775) The table overleaf itemises the new data releases that have been made over the last two months. The table provides access links to the original Content Update announcements on the Research Extranet, where more information is given, including series lists †just click on the description in the first column, which is a hyperlink. Also provided are Navigator citations and links †referring to locations in Thomson Datastream Navigator, adventurer for Economics, where the relevant series are shown. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 31 New Series by Region # Series Content Navigator fixing Added Update #See explorer for Economics> National Sources 129 6 7 18 7 16 5 15 54 40 2867 2880 2847 2837 2833 2835 2853 2879 2796 2824 Brazil > orthogonal arena > Imports and Exports > Trade by good Brazil > extraneou s empyrean > International militia Brazil > gold and pay > Money Supply chilli > tell Indicators chile > immaterial welkin > remote investiture & Debt Chile > Government celestial sphere > Government Surplus/ deficit Chile > outer sector > International reserves Colombia > Industry Sector > Housing and edifice specific United States > Money & Finance > Banking (MFIs) > FDIC Quarterly Banking visibleness United States > Industry Sector > Housing & Construction Detail > OFHEO House bell Index AmericasBrazilian External Trade by goodness Brazilian International Reserve Assets Brazilian Money Supply Components Chilean Consumer Credit and Bank Lending Chilean External Debt Chilean Government Accounts Chilean Official militia Colombian Housing Construction by Cities US FDIC Quarterly Banking Profile US OFHEO Purchase-Only House expense Indices Asia Chinese Energy Series Indonesian line flock series Indonesian Consumer Confidence Survey Indonesian Retail gross revenue Survey series Japanese Lease Series 73 104 83 16 15 2775 2772 2769 2774 2844 See Explorer for Economics > National Sources China > Industry Sector > Other Industry detail > Energy Indonesia > Surveys & Cyclical Indexes > business sector Surveys Indonesia > Surveys & Cyclical Indexes > Consumer Surveys Indonesia > Surveys & Cyclical Indexes > Retail gross revenue Survey Japan †grant Service > Industry Sector > Other Industry Detail > Machinery & Equipment > Equipment Leasing & PurchasesJapanese Motor fomite Imports Japanese Treasury gold Receipts & Payments ends with the secret Sector Malayan Bank Lending Malaysian Foreign reserves Malaysian Manufacturing gross revenue Value New Zealand Manufacturing Survey series Thailand Non-Performing Loans 11 29 2763 2770 Japan †Premium Service > Industry Sector > Automobiles & T ransport Detail > Vehicle Imports Japan †Premium Service > Government Sector > Treasury Funds Balance of Receipts & Payments with the Private Sector 25 6 1 48 16 2825 2797 2839 2785 2832 Malaysia > Money & Finance > Banking (MFIs) Malaysia > Money & Finance > International Reserves > Monthly series Malaysia > Industry Sector> Industrial return > Manufacturing payoff and gross sales New Zealand > Industry Sector > Sales, Orders, Inventories Thailand > Money & Finance > Banking (MFIs) > Non-Performing Loans EuropeAustria manufacturing business Price Index Austrian proletariat mart Austrian Wholesale, Retail Trade and Services Bulgarian National Accounts Danish Gross Fixed capital letter geological formation Finnish Gross Fixed Capital defining †Construction French External Trade Statistics by Commodity & Area Netherlands Government Sector series Netherlands Seasonally adjust Quarterly Industrial Production Series Portuguese Employment and Industrial Sales Turnover Portuguese Government Revenue and outgo Romanian Consumer Price Index Romanian yield and Earnings Slovak National Accounts Spanish International Reserves United Kingdom Detailed Index of Production 63 23 14 315 49 6 165 2873 2802 2852 2779 2789 2877 2857 35 39 90 8 12 20 298 35 12 2812 2868 2850 2859 2818 2826 2861 2810 2790See Explorer for Economics > National Sources Austria > Prices > Producer Prices Austria > Labour Market > Employment & Hours Austria > Industry Sector > Sales, Orders, Inventories > Retail Sales and other lists Bulgaria > National Accounts > GDP by industry Denmark > National Accounts > Investment/Capital Formation dissimilar lists Finland > National Accounts > Investment/Capital Formation France > External Sector > Imports & Exports > Trade by Commodity mixed lists Netherlands > Government Sector Netherlands > Industry Sec tor > Industrial Production & Utilisation > Production Indices SA Portugal > Labour Market > Employment & Hours and contend & Earnings Portugal > Industry Sector > Sales, Orders, Inventories Portugal > Government Sector > Government Surplus/ deficit Romania > Prices > Consumer Prices Romania > Labour Market > Wages & Earnings Slovakia > National Accounts > GDP by Expenditure Spain > External Sector > International Reserves United Kingdom > Industry Sector > Industrial Production & Utilisation > briny Indicators > Seasonally set and Not Seasonally familiarised INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 32 New Series by Region # Series Content Navigator Location Added Update #See Explorer for Economics > International Sources †History 230 2754 European Commission > Business and Consumer Surveys different lists Eurozone European Commission Aggregate Series for Eurozone 15 #5 †Business & Consumer Surveys ECB Aggregate Series for Eurozone 15 #6 †Prices and Labour Market ECB Aggregate Series for Eurozone 15 #7 †Retail Sales 10 2855 15 2845 European Central Bank > ECB Monthly Bulletin > Prices, sidetrack, Demand and Labour Markets > Labour Market and HICP, Other Prices and Costs European Central Bank > ECB Monthly Bulletin > Prices, Output, Demand and Labour Markets > Output and Demand Middle East & AfricaEgyptian Foreign Direct Investment by Area Egyptian Remittances Israel Wages and Employee Posts Israeli National Accounts South Africa Energy Statistics Turkish Foreign Trade by Commodity (Broad Economic Categories) Turkish Foreign Trade by Commodity (ISIC Classification) Turkish Foreign Trade by Commodity (SITC) Turkish Foreign Trade by Country 77 152 45 2791 2794 2819 31 21 99 198 10 42 2860 2838 2764 2752 2854 2780 See Explorer for Economics > National Sources Egypt > External Sector > External Investment & #038; Debt Egypt > Labour Market > Wages and Earnings Israel > Labour Market > Employment & Hours and Wages & Warnings Israel > National Accounts > GDP by Expenditure South Africa > Industry Sector > Other Industry Detail Turkey > External Sector > Imports & Exports > Trade by Commodity > Imports and ExportsTurkey > External Sector > Imports & Exports > Trade by Commodity > Imports and Exports Turkey > External Sector > Imports & Exports > Trade by Commodity > Imports and Exports Turkey > External Sector > Imports & Exports > Trade by Country International OECD Main Economic Indicators †February 2008 24 2768 See Explorer for Economics > International Sources †History OECD Main Economic Indicators > Indicators for OECD Zones and Indicators for OECD Non part Countries various lists OECD Main Economic Indicators †March 2008 8 2834 OECD Main Economic Indicators > In dicators for OECD Member Countries and Indicators for OECD Non-Member Countries various lists INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 33Revisions and Methodology Changes It has been a use up period, with revisions to US seasonally adjusted data and index rebasings in a number of markets. Other more substantive changes have been made to balance of payments and the trade-weighted vary rate for Euroland, household please rates for the UK, menstruum of Funds and Household Economy Survey for Japan, and unemployment statistics for Denmark. The following table summarises the revisions that have taken place in the last two months. Please refer to the Content Update itself (hyperlinked from the table) for further information and mnemonics of affected series. Country rewrite Data Content Update # Changes to Economic SeriesAustralia Austria Denmark Euroland Israel Italy Japan Australian Construction Work do Revised Australian Labour Force Survey Revised Austrian Wages Rebased D anish Unemployment Methodology Changed ECB Effective Exchange Rates Redefined Eurozone Monthly Balance of Payments Changed Israeli Wages and Employment Data Revised Italian External Trade Index Rebased Japan Electronic Equipment Market Size and Demand Forecasts Changed Japan Flow of Funds Accounts Series Methodology Changed Rebased Japanese Household Economy Survey Partly give up Japan Real & Nominal Effective Exchange Rates Redefined Philippines South Korea Philippine Industrial Production Indices Rebased Philippine Producer Price Indices Rebased South Korean Business Indicator Composite Indices Rebased South Korean Housing Purchase Price Index Rebased South Korean Industrial Production Rebased South Korean Manufacturing Production Rebased & Changed South Korean Retail Sales Rebased South Korean Service Industry Index Rebased Sweden Taiwan Thailand Turkey UK USA Swedish Retail Sales Index Rebased Taiwanese Price Indices Rebased Thai External Trade & Terms of Trade I ndex Rebased Turkish National Accounts Rebased UK Bank of England Household Interest Rates Changed US Industrial Production & potentiality Utilization Revised US Seasonally adjust Consumer Price Indices Revised US Seasonally Adjusted Existing Home Sales Revised US Seasonally Adjusted Pending Home Sales Revised US Seasonally Adjusted Producer Price Indices Revised US Seasonally Adjusted Unemployment Insurance Claims Revised US Wholesale Trade: Sales and Inventories Revised 2792 2848 2827 2842 2760 2820 2759 2858 2849 2869 2878 2846 2757 2876 2821 2805 2799 2811 2813 2809 2806 2800 2767 2828 2836 2864 2882 2762 2784 2804 2781 2871 2872 INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 3 Key Indicator Changes The Economics team continues to review Key Indicator selections for each market, in order to add more, ensure the best selection and bring more consistency across countries. See below for recent additions and hyperlinks to relevant Content Updates, where more information i s given. Key Indicator ChangeAustria Consumer Credit Added Austria International Reserves survival of the fittest Changed Austria Producer Prices pick Changed Chilean Consumer Credit and Bank Lending Added Israeli Employment and Wages Selection Changed Polish Producer Price Index Resourced Romanian Producer Price Index Now on Fixed Base Swedish Business Confidence Indicators Selection Changed Thai Bank Loans Series Added Mnemonics OECRDCONA OERESERVA OEPROPRCF CLCRDCONA & CLBANKLPA POPROPRCF RMPROPRCF SDCNFBUSR & SDCNFBUSQ THBNKLONA Content Update # 2822 2807 2843 2837 2766 2793 2798 2773 ISWAGES. E, ISWAGMANF & ISEMPALLG 2758 Interest Rates Repo Rates for Thailand foursome bilateral repurchase rates, as released by the Bank of Thailand, are now available. The series are weighted average rates with 1, 7, 14 and 30-day terms.The Bilateral buyback Operation is conducted through appointed Bilateral first-string Dealers and helps in stimulating the private repurchase market. purchase transactions are used by the bank to temporarily add or drain reserves available in the banking system. Mnemonics are as follows: explanation THAILAND symmetrical REPO run 1 DAY THAILAND BILATERAL REPO RATE 7 DAY THAILAND BILATERAL REPO RATE 14 DAY THAILAND BILATERAL REPO RATE 30 DAY DS Mnemonic THBRP1D THBRP7D THBRP2W THBRP1M Datatype IR IR IR IR INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 3 NEW VALUATION RATIOS RELEASED IN MARCH March power saw the release of 1 new valuation ratios on Thomson Datastream.These ratios are calculated on the equity level as well as the industry, sector, country and regional levels of the Datastream Indices, and allow a great number of data comparisons to highlight trends which previously would have needed compilation of data before use. In brief, these ratios are based on the Worldscope database items and using wherever possible the latest interim data on a 12-month trailing basis. The full methodology is described in t he following link on the Extranet: http://extranet. datastream. com/data/Equities/documents/DatastreamGlobalEquityIndicesvaluationdatatypes-rulesvs4final. pdf INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 3 So what can we do with these ratios?You can compare a ships company to its industry, locally and regionally, as is illustrated here using Return on Equity. About Martek Biosciences passel Founded in 1985, the group’s principal activity is to develop, manufacture and sell naturally produced products derived from micro-algae, fungi and other microbes. The group’s products and services include speciality, nutritional oils for infant formula, nutritional supplements and food ingredients to promote mental and cardiovascular health, fluorescent markers for diagnostics, rapid miniaturised screening and gene and protein detection. Its ROE is compared here with the US Food & the World Food industries.You can also …make sector comparisons across different re gions of the world using the regional-level aggregates Here we have compared the Capital Expenditure of the Pharmaceutical industry in various regions: Europe, USA, Far East and World. Capital expenditure for USA and Europe represents almost 90% of the capex spent in that industry worldwide, and it’s elicit to see how the drop in US relative capex has been totally mirrored by an increase in Europe’s importance in this domain. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 3 …or look at a particular sector in a different light, using here the Interest coverage ratio to illustrate the Turkish Telecom Sector and its ability to repay debt Interest charge coverage, also called interest coverage ratio, is defined by EBIT divided by the interest expense for each period.It indicates the ability of the company (or in this case the sector) to repay its debt using the income generated by the business. Levels above 3 are considered having a strong ability to repay debt, while businesses whose ratio drops below 1. 5 (red line on the chart) are considered risky. It’s interesting to show how the sector market index started picking up once the interest coverage ratio moved above 3 towards the end of 2004. This is also when the sector was open to competition. New licences were apt(p) to 16 suppliers of data transmission services in fixed telephony. Further steps towards liberalisation and rift up of the monopoly were taken in 2005/06 by the sale of Turk Telekom.Vodafone repurchased Telsim, the second largest mobile phone operator. The Turkish telecommunications lucre continued to grow, currently ranked the 13th largest market in the world and fifth in Europe. INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 3 COMPANY ADDITIONS TO WORLDSCOPE During February and March over 00 companies were added to the Worldscope Database. These additions included 112 US Companies and a continuing expansion of coverage of Middle Eastern markets. Also, Niger ia was added to our country coverage. Worldscope’s total coverage at 8th April 2008 consisted of 56,448 companies, 36,508 of which were active companies. 10,172 of these companies are Limited data set companies (8,064 active).COUNTRY ARGENTINA AUSTRALIA AUSTRIA BAHRAIN BELGIUM BERMUDA brazil CANADA CAYMAN ISLANDS CHILE CHINA COLOMBIA CZECH commonwealth DENMARK EGYPT ESTONIA FINLAND FRANCE GERMANY GREECE HONG KONG HUNGARY ICELAND INDIA INDONESIA IRELAND ISRAEL ITALY JAPAN JORDAN KOREA (SOUTH) KUWAIT LITHUANIA LUXEMBOURG MALAYSIA MEXICO MOROCCO NETHERLANDS TOTAL 0 FEB 200 113 2490 203 35 286 82 602 2524 28 261 1903 54 82 330 59 7 238 1657 1550 401 1168 46 19 2102 401 158 225 525 4816 30 1154 87 3 68 1208 227 26 408 COMPANIES ADDED FEB-MAR 200 5 25 1 5 5 1 2 15 2 3 50 0 1 0 3 0 0 13 4 0 4 5 0 26 8 0 2 6 37 5 17 9 0 0 4 2 0 1 ACTIVE  APR 200 86 1912 105 40 148 76 386 1598 22 218 1895 35 20 170 55 7 138 866 1052 288 1022 29 17 2023 359 79 186 295 3971 35 974 96 3 46 1002 13 2 24 212 silent  APR 200 32 603 99 0 143 7 218 941 8 46 58 19 63 160 7 0 100 804 502 113 150 22 2 105 50 79 41 236 882 0 197 0 0 22 210 97 2 197 TOTAL  APR 200 118 2515 204 40 291 83 604 2539 30 264 1953 54 83 330 62 7 238 1670 1554 401 1172 51 19 2128 409 158 227 531 4853 35 1171 96 3 68 1212 229 26 409 INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 39NEW ZEALAND NIGERIA NORWAY PAKISTAN PERU PHILIPPINES POLAND PORTUGAL QATAR RUSSIAN FEDERATION SAUDI ARABIA SINGAPORE SLOVAKIA SLOVENIA SOUTH AFRICA SPAIN SRI LANKA SWEDEN SWITZERLAND TAIWAN THAILAND TURKEY UNITED ARAB EMIRATES UNITED KINGDOM UNITED STATES VENEZUELA VIRGIN ISLANDS (BRITISH ZIMBABWE OVERALL TOTALS 202 0 409 152 103 263 263 144 35 123 55 772 25 11 843 316 34 607 437 1685 639 263 36 4563 18192 50 13 30 1 3 5 5 2 13 2 21 1 1 33 24 9 0 1 20 5 2 6 1 35 5 0 13 23 112 0 0 4 0 114 5 193 130 86 241 246 60 36 141 79 647 10 12 370 150 32 330 275 1500 535 230 48 2298 9039 35 12 32 30 91 0 221 24 30 24 38 85 0 15 0 134 15 0 493 171 4 283 163 220 109 33 1 2288 9265 15 1 2 1990 205 5 414 154 116 265 284 145 36 156 79 781 25 12 863 321 36 613 438 1720 644 263 49 4586 18304 50 13 34  INFOSTREAM MAY/JUN 2008 © THOMSON REUTERS 2008 0 CONTRIBUTORS PRODUCT MANAGEMENT PAUL BACON DATAFEEDS paul. [email protected] com +44 (0)20 7324 6873 JULIAN RICKARDS DATASTREAM ADVANCE, DSWINDOWS, DSDDE julian. [email protected] com +44 (0)20 7336 1944 CASEY PEARCE DATASTREAM INTERACTIVE CHARTING casey. [email protected] com +44 (0)20 7324 9359 IAN BROCKLEHURST THOMSON ONE INVESTMENT MANAGEMENT SOLUTIONS ian. [email protected] com +44 (0)20 7324 8890 DAVID BERNARD THOMSON ONE INVESTMENT BANKING SOLUTIONS david. [email protected] com +44 (0)20 7336 1930 STEVE KELLY THOMSON EXTEL SURVEYS steve. [email protected] com +44 (0)20 7324 9200 CONTENT MANAGEMENTNICOLAS DE LAURENS CASTELET GLOBAL CONTENT SOLUTIONS nicolas. [email protected] com +44 (0)20 7336 1950 STEPHEN CARTER COMPAN Y ACCOUNTS stephen. [email protected] com +44 (0)29 2063 1943 ANNE SIEBER EQUITIES, EQUITY INDICES, FUNDS & 3RD-PARTY DATA anne. [email protected] com +44 (0)20 7324 9741 JAMES BRIGHT I/B/E/S GLOBAL AGGREGATES ESTIMATES DATA james. [email protected] com +44 (0)20 7324 9600 NELSON SALSINHA DERIVATIVES & COMMODITIES nelson. [email protected] com +44 (0)20 7324 9455 MADELEINE DISARIO ECONOMICS madeleine. [email protected] com +1 301 545 4255 TONY MCCORMACK FIXED INCOME tony. [email protected] com +44 (0)20 7014 1232\r\n'