Microsoft - Data Management MS Excel Developer

Company: Deutsche Bank, Frankfurt

Technology: MS SQL Server, Microsoft Excel, VBA

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Apr 2014 – Apr 2015

Cost: no details

---

• Every week, the analysts of UBS AG give their recommendations regarding the securities traded on the stock exchanges.
• The recommendations made by the analysts (Microsoft Excel) are summarised, consolidated and re-evaluated in another Excel file.
• For this purpose, the individual recommendations are imported file by file into the new Excel file using Microsoft Visual Basic for Application, consolidated and re-evaluated on the basis of defined mathematical principles and complex projections.
• Taking all recommendations into account, a new recommendation is calculated for each security (buy, hold, sell).
• The consolidated Microsoft Excel file is then made available to UBS AG clients on the Internet.
• Testen and documentation (user and technical).

 

Order a similar project