This repo shows a set of tools that I used to tackle the Bloomberg API project at my engineering school. The project consists of a relational set of data retrieved from Bloomberg using OPI. The goal of the project is to get data from Bloomberg, display basic data, calculate performances & volatility and learn basics about portfolio pricing. The data is related to financial products and portfolios. For each financial product, we retrieve basic data (name, description, currency, exchange market, …), calculate perfs and volatility (perfs and vol array on 1, 3 and 6 months and 1 and 3 years, performance chart). For portfolios, we calculate portfolio prices with “no buy, no sell” hypothesis. The project also involves optimizing multiple calls to Bloomberg.
- General Development Rules:
- Adaptivity
- Professional problematics
- Development:
- Excel & VBA
- C#/WPF & POO
- Job:
- Reports
- Financial calculus
- Course #1: Introduction
- Development basics / Minds refreshing (30 minutes)
- Bloomberg OAPI: Light presentation, Operations / Fields / Keywords / Demo (30 minutes)
- Project Launch: Groups making, Language choice (VBA or C#), Talking about
- Courses #2 & #3
- Course #2: Project point (~10 minutes per team, 2 hours max), Explanations about portfolio pricing (25 minutes)
- Course #3: Project point (~15 minutes per team), Estimate of the final grade
- Project Milestones
- Launch: 30/01 to 20/03
- Mid point: 13/02 to 06/03
- Final point: 06/03 to 20/03
- Upload closed: 22/03 23h55
- 4 members : PERIER-TOMA-LEHAF-GHAZZALI
- Points:
- Mid Point & Final point (each on 10)
- Objectives understanding (4)
- Done work according to schedule (2)
- Work quality (3)
- Teacher mark (binary) (1)
-
Product Report:
- Main objectives:
- Get data from Bloomberg with OAPI
- Display basic data
- Calculate perfs & volatility
- Details:
- Get data from Bloomberg (VBA: Blg Open API Wrapper of Mikael Katajamäki, C#: My own wrapper)
- Display basic data (Name, description, currency, exchange market, …)
- Calculate perfs and volatility (Perfs and vol array on 1, 3, and 6 months and 1 and 3 years, Performance chart)
- User parameters (Custom time period, Custom financial product with ticker or ISIN)
- Main objectives:
-
Portfolio Report:
- Second and harder project.
- Main objectives:
- Optimize multiple calls to Bloomberg
- Make a first professional approach of finance
- Learn basics about portfolio pricing
- Details:
- Optimize multiple calls to Bloomberg (handle many products, each call takes time)
- Professional approach (ergonomy, user-friendly interface, important financial market information)
- Portfolio pricing (calculate portfolio prices with “no buy, no sell” hypothesis)