Skip to content
MathWorks - Mobile View
  • Inicie sesión cuenta de MathWorksInicie sesión cuenta de MathWorks
  • Access your MathWorks Account
    • Mi Cuenta
    • Mi perfil de la comunidad
    • Asociar Licencia
    • Cerrar sesión
  • Productos
  • Soluciones
  • Educación
  • Soporte
  • Comunidad
  • Eventos
  • Obtenga MATLAB
MathWorks
  • Productos
  • Soluciones
  • Educación
  • Soporte
  • Comunidad
  • Eventos
  • Obtenga MATLAB
  • Inicie sesión cuenta de MathWorksInicie sesión cuenta de MathWorks
  • Access your MathWorks Account
    • Mi Cuenta
    • Mi perfil de la comunidad
    • Asociar Licencia
    • Cerrar sesión

Vídeos y webinars

  • MathWorks
  • Vídeos
  • Vídeos-Inicio
  • Buscar
  • Vídeos-Inicio
  • Buscar
  • Comuníquese con ventas
  • Software de prueba
1:53 Video length is 1:53.
  • Description
  • Full Transcript
  • Related Resources

How to Execute a Custom MATLAB Function in Excel

Execute a custom MATLAB® function using data from Microsoft® Excel® and display the results in Excel. The reason is to extend Excel with the computational and visualization capabilities of MATLAB. The custom MATLAB function creates random stock paths using Monte Carlo simulation. It simulates random stock paths using Geometrical Brownian Motion.

In this video I am going to show you how to execute a custom MATLAB function using data from MS Excel and display the results in Excel. The reason is to extend Excel with the computational and visualization capabilities of MATLAB.

The custom MATLAB function creates random stock paths using Monte Carlo simulation.

Monte Carlo simulation of a stochastic process is a procedure for sampling random outcomes for the process.

The custom function that I created, Paths, takes as inputs the GBM parameters and generates the stock paths. In this example we will generate 65,000 EuroStoxx paths for 21-time steps and visualize 500 paths starting at S0, which is the last available price for the index in question.

  1. First, we bring the Excel data into MATLAB.
  2. Next, we execute the custom function in MATLAB Paths.
  3. Finally, we bring the results back to Excel. The data in the worksheet updates.

We can see the 65,000 paths generated for 21-time steps.

To recap, using Spreadsheet Link, you can import a function already created in MATLAB and benefit from the computational speed and visualization capabilities of MATLAB directly from Excel.

To find out more about Spreadsheet Link applications, please visit the Spreadsheet Link product page where you can read the documentations, watch additional videos, and find examples. Thank you for watching.

Related Products

  • Spreadsheet Link
  • MATLAB

Learn More

Download code

3 Ways to Speed Up Model Predictive Controllers

Read white paper

A Practical Guide to Deep Learning: From Data to Deployment

Read ebook

Bridging Wireless Communications Design and Testing with MATLAB

Read white paper

Deep Learning and Traditional Machine Learning: Choosing the Right Approach

Read ebook

Hardware-in-the-Loop Testing for Power Electronics Control Design

Read white paper

Predictive Maintenance with MATLAB

Read ebook

Electric Vehicle Modeling and Simulation - Architecture to Deployment : Webinar Series

Register for Free

How much do you know about power conversion control?

Start quiz

Feedback

Featured Product

Spreadsheet Link

  • Request Trial
  • Get Pricing

Up Next:

2:05
Easy Custom Excel Import to MATLAB

Related Videos:

19:50
How to Build Custom Motor Controllers for Zynq SoCs with...
17:50
Using try/catch in a While Loop to Repeatedly Execute...
3:05
Technical Computing with MATLAB, Part 2: Importing from...
3:30
Package a Custom MATLAB Toolbox

View more related videos

MathWorks - Domain Selector

Select a Web Site

Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .

  • Switzerland (English)
  • Switzerland (Deutsch)
  • Switzerland (Français)
  • 中国 (简体中文)
  • 中国 (English)

You can also select a web site from the following list:

How to Get Best Site Performance

Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.

Americas

  • América Latina (Español)
  • Canada (English)
  • United States (English)

Europe

  • Belgium (English)
  • Denmark (English)
  • Deutschland (Deutsch)
  • España (Español)
  • Finland (English)
  • France (Français)
  • Ireland (English)
  • Italia (Italiano)
  • Luxembourg (English)
  • Netherlands (English)
  • Norway (English)
  • Österreich (Deutsch)
  • Portugal (English)
  • Sweden (English)
  • Switzerland
    • Deutsch
    • English
    • Français
  • United Kingdom (English)

Asia Pacific

  • Australia (English)
  • India (English)
  • New Zealand (English)
  • 中国
    • 简体中文Chinese
    • English
  • 日本Japanese (日本語)
  • 한국Korean (한국어)

Contact your local office

  • Comuníquese con ventas
  • Software de prueba

MathWorks

Accelerating the pace of engineering and science

MathWorks es el líder en el desarrollo de software de cálculo matemático para ingenieros

Descubra…

Explorar productos

  • MATLAB
  • Simulink
  • Software para estudiantes
  • Soporte para hardware
  • File Exchange

Probar o comprar

  • Descargas
  • Software de prueba
  • Comuníquese con ventas
  • Precios y licencias
  • Cómo comprar

Aprender a utilizar

  • Documentación
  • Tutoriales
  • Ejemplos
  • Vídeos y webinars
  • Formación

Obtener soporte

  • Ayuda para la instalación
  • MATLAB Answers
  • Consultoría
  • Centro de licencias
  • Comuníquese con soporte

Acerca de MathWorks

  • Ofertas de empleo
  • Sala de prensa
  • Misión social
  • Casos prácticos
  • Acerca de MathWorks
  • Select a Web Site United States
  • Centro de confianza
  • Marcas comerciales
  • Política de privacidad
  • Antipiratería
  • Estado de las aplicaciones

© 1994-2022 The MathWorks, Inc.

  • Facebook
  • Twitter
  • Instagram
  • YouTube
  • LinkedIn
  • RSS

Únase a la conversación