MS Access, VBA
UBS AG, Zürich
PROJECT LINK: Not available
People in the PROJECT: Stefan Troehler
PROJECT Duration: 3 months
PROJECT Value: SFR. 70'000.00
People in the PROJECT: Stefan Troehler
PROJECT Duration: 3 months
PROJECT Value: SFR. 70'000.00
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT
- The UBS AG analysts give their recommendations on the securities traded on the stock exchanges on a weekly basis.
- The recommendations made by the analysts (Microsoft Excel) are summarized, consolidated and reassessed in another Excel file.
- For this purpose, the individual recommendations are read in file by file using Microsoft Visual Basic for Application into the new Excel file, consolidated and reevaluated using defined mathematical principles and complex projections.
- Taking into account all recommendations, a recommendation is recalculated for each security (buy, hold, sell).
- The Microsoft Excel file consolidated in this way will then be made available to UBS AG customers on the UBS AG Internet.
- Testing and documentation (user and technical).
Stefan Tröhler
Datawarehouse - DWH Developer, Consultant
14 Sep01:41:02 PM
Datawarehouse - SQL Server Developer
04 May01:41:02 PM
Data warehouse - Oracle
18 Mar12:41:02 PM
Data warehouse - customer evaluation
08 Mar12:41:02 PM