1 / 19

Standard and Poor’s Index Services Universal File Format (UFF) Overview

Standard and Poor’s Index Services Universal File Format (UFF) Overview. July 24, 2008. Legacy Issues . Data across families have differing data fields. Constituent level identifiers are not standardized – multiple identifiers for same constituent.

anisa
Télécharger la présentation

Standard and Poor’s Index Services Universal File Format (UFF) Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Standard and Poor’s 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.

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

  5. Identifier Mapping – Constituent Level • Where there were multiple identifiers, there will now be one unique identifier – Stock Key.

  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

  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. Today’s 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://@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://Inde6262:j7Sb34VP@edx.standardandpoors.com • Client usernames and passwords available. Contact Client Services if you have not received new information. • Index_Production@StandardandPoors.com(212) 438-2046

  16. Questions & Answers • General • UFF sample files for all indices (ASX, TSX, S&P/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 S&P 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 S&P Developed BMI Markets; Enhancements to the S&P BMI Indices • November 1, 2008 – Annual Reconstitution for S&P Emerging BMI Markets; Country restructuring for Emerging and Frontier Markets • S&P 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

More Related