LINC Course Schedule for Datastream, Reuters and Excel
23th Feb 2010: A new schedule will be out soon for courses in March. Make sure your mail address is correct to recieve all notifications.
All questions can be sent to system@linclund.com
Overview of Software
Datastream is the world's largest financial statistical database with more than 140 million time series. Except from an introduction to the user-friendly standalone software available in the Finance Lab we will also guide you how to use the Excel Add-In where your time series get imported directly into your spreadsheet.
Reuters 3000 Xtra is a real-time integrated information and trading platform. You will experience how you can adapt the platform to your needs and find relevant information fast and careless. It is possible to find quotes and information for almost all publically traded assets and has several advanced worksheets available. The Excel Add-In will also be explained which will enable you to export your quotes to a spreadsheet.
We offer three courses in Microsoft Excel where we focus on common financial application and how to inplement them in Excel.
Course I covers basic topics as cell formatting, importing data from the web, formulas on time series and finding/sorting in large data sets.
Course II covers Pivot Tables, a statistical add-in, conditional functions and a small introduction to macros and VBA.
Course III focus on three parts: firstly optimization, how to find the maximum and minimum to your formulas. Secondly we introduce matrices and how to work with them in Excel and at last we cover more of VBA and see the advantages and limitations of the programming language.