Ask UBS AG for the BuyList application.This application deals with analysts' recommendations concerning the trading of securities. The individual recommendations are published weekly on the UBS website. The data from the various Excel files are read, the overall recommendation is calculated with the help of complex calculations and finally published on the Internet. The application is built with Microsoft Excel and VBA.

• The analysts of UBS AG give their recommendations on the securities traded on the stock exchanges on a weekly basis.
• 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 read file by file using Microsoft Visual Basic for Application into the new, consolidated and re-evaluated Excel file, based on defined mathematical principles and complex projections.
• Taking all recommendations into account, a recommendation is recalculated for each security (buy, hold, sell).
• The Microsoft Excel file consolidated in this way will be available to UBS AG clients on the UBS AG Internet.
• Testing and documentation (user and technical).