Business solutions for you portfolio


Company: UBS Warburg, Opfikon

Technology: MS Access, VBA, SQL, MS Excel.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Feb 2000 – Oct 2001

Cost: no details

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

  • Create an application that generates the daily profit and loss statement of UBS AG Investmentbank Warburg in Opfikon.
  • In this case, a very simple calculation is chosen.
  • All income is compared to the expenses.
  • The profit and loss account prepared in this way shows the current daily balance of the investment bank and is required by law.
  • In the past, banks had to deposit the equivalent value in the form of securities in the event of a "lost" status.
  • Nowadays, P&L accounting is done in electronic form.
  • Data is obtained from mainframe systems, refined and presented in groups.
  • Testing and documentation (user and technology).
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.