FTSE INDEX DATA

Projects

• Automated collection of FTSE index data and transfer into operational databases

• Balance portfolios using standard XIP functionality
• Identify discrepancies in the master file and reference data
• Audit and control of source data achievable
• Improved scenario planning through easier index adjustment

• FTSE index data collected automatically daily
• Data loaded and annotated into an Oracle database into a form that can be exported to XIP index tracking spreadsheets
• Ability to create forecast benchmarks based on the notified additions and subtractions to the market indices

• Oracle Database, PL/SQL
• Microsft Query / Excel

• Incorporating process in engineered process makes audit and control of source data achievable
• Simple data loading approach ensures reliability and efficiency
• Data is converted to a form that makes adjusting indexes for scenario planning easier