Calculation of the Daily Profit & Lost of UBS Warburg in Opfikon. Financial data is imported, refined and the corresponding calculations are carried out. The output is done using Microsoft Excel and the application is developed using Microsoft Access, VBA and SQL.

• Creation of an application that creates the daily profit and loss account for UBS AG Investmentbank Warburg in Opfikon.
• In this case, a very simple calculation is chosen.
• All income is compared to expenditure.
• The profit & lost statement generated in this way shows the current daily status of the investment bank and is mandatory by law.
• In the past, banks had to deposit the equivalent value in securities when the status was "Lost".
• Nowadays, P&L compensation is carried out in electronic form.
• The data is obtained from the mainframe system, refined and displayed in groups.
• Testing and documentation (user and technical).