01 Context
An investment management firm relied on manual data collection from Bloomberg for financial analysis. Data downloaded was hard-coded, making the process slow and inefficient, especially when analyzing multiple companies and industries.
02 Problem
- Manual data collection was time-consuming and repetitive, and took 2 days to prepare the data for analysis.
- Data was static and required re-downloading for updates.
- No ability to create custom variables or dynamic analyses.
- Limited capacity to analyze multiple companies or perform complex data exercises efficiently.
03 Objective
- Automate data collection and presentation, make data analysis dynamic and customizable.
- Increase the speed and scale of financial research by enabling cross-sectional and time-series analysis across industries and companies.
04 Solutions
Industry Databases in BQL
Developed industry-specific databases using Bloomberg Query Language (BQL) in Excel.
Dynamic Excel Templates
Created dynamic customisable Excel templates for company financials, industry and global peers, and valuation metrics.
Tearsheets & Watchlists
Built tearsheets, watchlists, and worksheets for quick reference and to track/monitor the portfolio.
05 Outcomes
- Faster data processing, cutting time taken from 15 hours to 3 hours.
- 3x more companies analyzed weekly, increasing our research coverage.
- Higher customisation using industry-specific variables.
06 Reflection
Automation unlocks capacity for scalability of research, not just efficiency. Integration of powerful tools like Python for visualisation would have enabled faster data processing and better visualisation flexibility for data analysis.