Standard and Poor

1
Standard and Poors Index ServicesUniversal File
Format (UFF)Overview

• July 24, 2008

2
Legacy Issues

• Data across families have differing data fields.
• Constituent level identifiers are not
  standardized multiple identifiers for same
  constituent.
• Index level identifiers are not standardized
  across databases.
• Data retrieval from multiple locations -
  different indices have different FTP access
  points.
• Addition of a new index or index family would
  require a client to rewrite any load program as
  the file format could be different.

3
File Formats

• Multiple legacy file formats with both
  overlapping and unique fields.

Database 1 Database 2 Database 3
Index Level Fields 11 11 5
Constituent Level Fields 19 24 14
4
File Formats

• Leveraging the unique characteristics of each
  file format into one universal file format (UFF).

New Database Universal File Format
16
35
Database 1 Database 2 Database 3
Index Level Fields 11 11 5
Constituent Level Fields 19 24 14
5
Identifier Mapping Constituent Level

• Where there were multiple identifiers, there will
  now be one unique identifier Stock Key.

Database Index Unique Identifier Stock Key
1 US Indices, Shariah, ASX, etc RIC, Bloomberg Ticker, CUSIP, ISIN and/or SEDOL 12345678
2 SP/Citigroup, Shariah, etc. SP ID 12345678
3 EMDB, IFCI, IFCG Frontier Market ID and/or IFC ID 12345678
6
Identifier Mapping Index Level

• New Database - parsable index code (Index Key)
• Refer to EDX location to view EMDB_Mapping
  Legacy to index key_FIN.xls

Index code Maximum Characters Notes
SP Standard Poor's 2  Branding
Index family 4  
Index specific 4  
Index currency - 3 letter 3 ISO code
Weight schema 2 FF - Free FloatUF Unrestricted Float
Index attribute 2 G GrowthV Value "--" in not needed
Index Type 2 P Price T Total Return N Net Total Return 1 Hedged Price 2 Hedged Total Return 3 Hedged Net Total Return
Region Country 3 R for region 2 letter region code or2 letter ISO code"-" orC for composite
Size 3 using a look up table"---" if not needed
GICS 8 GICS helps create Index Key, null if not needed
Total 33 Can be reduced to under 30 by concatenating with GICS Code
7
EMDB Market ID (legacy identifier)

• Historic Market ID was concatenated with file
  specific column to make unique ID (file
  specific).

8
EMDB Index level identifiers

• Although unique for a file, codes were not unique
  at a database level.

9
Why transition to interim index code?

• New engine is populating Index Key.
• No direct mapping between Market ID and Index
  Code (1 market ID to a 3 indices price, TR
  NTR).
• Create a concatenated ID, a concatenated (plus)
  ID and an interim Index Code.
• Use EMDB_Mapping Legacy to Index Key_FIN.xls file
  (Available on EDX site).

10
Migration Timeline

• April 16, 2008 - Client Announcement.
• May 1, 2008 - UFF daily files only using Chained
  Paasche methodology.
• July 1, 2008 - UFF Parallel files with new
  Divisor methodology.
• July 31, 2008 - End of parallel run. Last day of
  legacy file delivery.
• August 1, 2008 - Official UFF file delivery with
  new Divisor Methodology.

11
UFF File Reference Table
Daily Index Level File Summary
Index Month End file summary
12
UFF File Reference Table (continued)
Constituent Detail File Summary
Corporate Action File Summary
13
UFF File Reference Table (continued)

• Newly added GCCINVESTABLE files
• _GCCINVESTABLE.SPA
• _GCCINVESTABLE.SPC
• _GCCINVESTABLE_ADJ.SPC
• Why add these files?
• In the legacy UFF files, these countries were
  included in the EMDBINVESTABLE, but were not
  included in the New Intergration System UFF
  parallel files.

14
V3.1 changes to Index Level, Constituent Details,
Corporate Actions

• INDEX LEVEL CHANGES
• File suffix is changed from ICL to SPL
• INDEX KEY will be newly generated ID
• Additional column added - INDEX CODE (LEGACY)
  will provide a definitive mapping document.
• INDEX CONSTITUENT DETAILS CHANGES
• File suffix changed from ICD to SPC
• STOCK KEY will be newly generated ID (formerly
  ID1)
• Additional column added LEGACY KEY will provide
  a definitive mapping document.
• July 1,2008 begins ADJ.SPC
• CORPORATE ACTIONS CHANGES
• File suffix changes from ICA to SPA
• STOCK KEY will be newly generated ID (formerly
  ID1)
• Additional column added LEGACY KEY will provide
  a definitive mapping document.
• Jul 1, 2008 begins SPA forward looking dates 7
  days
• e.g. Todays EOD file (May 14, 2008) would
  reflect changes effective tonight through EOD May
  21, 2008.

15
Availability of Enterprise Data eXchange (EDX)

• A more robust FTP site is now active to access
  files.FTP site ftp//_at_edx.standardandpoors.com
  
• Current technology versus Co-branding
• High Availability
• Load balanced
• Full Disaster Recovery
• Additional secure file transfer protocol
• More user-friendly website for downloading
• Download latest version of Specification file
  from EDX.
• ftp//Inde6262j7Sb34VP_at_edx.standardandpoors.com
• Client usernames and passwords available.
  Contact Client Services if you have not received
  new information.
• Index_Production_at_StandardandPoors.com(212)
  438-2046

16
Questions Answers

• General
• UFF sample files for all indices (ASX, TSX,
  SP/CITI, etc.) are being generated.
• GICS Index code field is in the SPL , SPC and SPA
  files.
• Effective July 1, 2008, the LOCAL PRICE field
  will reflect the value of the trade currency.
• Pre June 30, 2008, the value represented was
  in local currency.
• Weekly
• IFC weekly files will be discontinued as of
  August 1, 2008.
• Monthly
• IFC monthly GICS files will end the first week in
  August 2008.
• Parallel month end files will start the first
  week following May 31, 2008 and end the first
  week in September 2008.
• A monthly subscriber, would receive
  YYYYMMDD_INDEXAlias_EOM.SPC. The fields appended
  to EOM.SPC are market code, stock code, high
  price, low price, total value traded in US
  dollar, number of shares traded, number of days
  traded, price-earnings ration (P/E), price-book
  value ratio (P/BV), profit, book value, and
  depreciation.
• Sample _EOM.SPL and _EOM.SPC files have been
  provided.
• No month-end adjusted close file will be
  provided.

17
Questions Answers (continued)

• Effective August 1, 2008, the ADR database files
  will be discontinued.
• A sample GICS file has been published to the EDX
  location.
• NDO (Next Day Open) files
• Adjusted market cap, adjusted divisor, and
  adjusted count, these are not capabilities of the
  legacy system. Files created from the new system
  will have these fields populated. The NDO file
  will begin July 1, 2008.
• GV key
• Is the SP Compustat unique identifier
  (fundamental data) and is another identifier
  similar to RIC, MIC, etc.

18
Upcoming Events

• Topic Methodology and Branding
• http//www2.standardandpoors.com/portal/site/sp/en
  /us/page.topic/indices_methodologychanges/2,3,2,2,
  0,0,0,0,0,0,0,0,0,0,0,0.html
• Important Dates
• October 1, 2008 Annual Reconstitution for SP
  Developed BMI Markets Enhancements to the SP
  BMI Indices
• November 1, 2008 Annual Reconstitution for SP
  Emerging BMI Markets Country restructuring for
  Emerging and Frontier Markets
• SP and MSCI Barra announce revisions to the
  Global Industry Classification Standard (GICS)
• Constituent files will be announced on July 31
  thru GICS Direct. The information will be
  published and effective after the close of
  business on August 29, 2008.

19
Thank you