Events - Seminars

Introduction to MATLAB for Financial Applications for Excel Users

Seminar Overview

Many finance professionals find that they run into limitations using Excel for their financial modelling applications. During this introductory seminar, MathWorks financial engineers will provide an overview of MATLAB and demonstrate how Excel users with little or no prior experience can enhance their application development process using MATLAB and associated tools.

Through live demonstrations they will illustrate how MATLAB can complement the capabilities of Excel and provide tips on gaining easy access to the pre-built engineering and advanced analysis and visualisation tools within the MATLAB environment, whilst maintaining the ability to manipulate data between the two programs.

Join us for this free event to learn why finance professionals worldwide use MATLAB and the MathWorks suite of financial tools to conduct research, rapidly prototype algorithms, and develop financial models.

Thank you for your interest in MathWorks Seminars. There are no dates currently scheduled for this Seminar. For more information on our seminars and products contact MathWorks sales or please visit:

Who Should Attend

This seminar is relevant to those with little or no previous knowledge of MATLAB involved in the following application areas:

Portfolio Management
Risk Management
Trading
Quantitative Analysis
Credit Evaluation
Econometric Measurement
Insurance Modelling

Seminar Highlights

Through live demonstrations you will learn how to:

Replicate and enhance common Excel functionality in MATLAB
Exchange data between MATLAB and Excel
Automatically generate reports to document your analysis
Freely distribute your MATLAB functions as Excel add-ins

Agenda
09:30 - 10:00	Coffee and Registration
10:00 - 10:10	Welcome and Introduction
10:10 - 11:00	Introduction to MATLAB MATLAB for finance customers Using MATLAB versus Excel
11:00 - 11:30	Coffee Break
11:30 - 12:15	Guest Presentation: Andy Harvell - Director of Quantitative Research, FTSE International Ltd
12:15- 13:00	MATLAB Tips for Excel Users This session will look into common issues faced by new users coming to MATLAB from Excel. It will aim to show how common Excel functionality can be replicated and enhanced in MATLAB.
13:00 - 14:00	Lunch
14:00 - 15:00	Reporting results using MATLAB An overview of how MATLAB can be used to report results in various formats including: Automatic generation of HTML and Word formats Building Excel-based reports
15:00 - 15:30	Back to Excel To complete the work flow, this session will look at ways to integrate MATLAB and Excel to allow users to share results and functionality with colleagues. It will cover: Using Excel and MATLAB in tandem Generating Excel add-ins from MATLAB for deployment
15:30	Questions and Close

Products & Services	Industries	Academia	Support	User Community	Company