Excel and Finance

  • Impressum

Category: Excel

MS Solver for Excel

2018-12-182018-12-18 rodo82ExcelLeave a Comment on MS Solver for Excel

To install a solver in MS Excel follow the instructions in the video.

Correlation matrix

2018-12-052018-12-05 rodo82ExcelLeave a Comment on Correlation matrix

<iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/w5Do76xC7Eg” frameborder=”0″ allow=”accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture” allowfullscreen></iframe>

Net present value

2018-12-042018-12-04 rodo82Excel, StocksLeave a Comment on Net present value

In this video we show how to calculate the net present value (NPV) of a financial investment in MS Excel. The cashflows for more than one period must be given…

Read More→

Markowitz portfolio selection

2018-12-042018-12-18 rodo82Excel, Portfolio, StocksLeave a Comment on Markowitz portfolio selection

In this tutorial we show how to solve the Markowitz portfolio selection problem in Excel by help of Solver. The expected returns for each asset and covariance matrix are given. The…

Read More→

Dynamic histogram

2018-12-012018-12-04 rodo82ExcelLeave a Comment on Dynamic histogram

Consider you want to draw in Excel an histogram which is automatically updating when the input data is changing:

Calculating covariance matrix

2018-12-012018-12-04 rodo82Excel, StocksLeave a Comment on Calculating covariance matrix

To calculate covariance matrix using Excel:

Simulation of stock prices

2018-11-302019-02-13 rodo82Excel, StocksLeave a Comment on Simulation of stock prices

Modeling the volatility of an asset (e.g., index, bond, stock, commodities) allows to simulate the value of that asset. Based on the simulated value range derived or composite financial products…

Read More→

Recent Posts

  • MS Solver for Excel
  • Correlation matrix
  • Net present value
  • Markowitz portfolio selection
  • Dynamic histogram

Archives

  • December 2018
  • November 2018

Categories

  • Excel
  • Portfolio
  • Stocks
Copyright © All rights reserved.
Blog Kit by WP Charms
WP DSGVO Tools (GDPR) for Wordpress and WooCommerce The website uses cookies in order to provide you the most relevant information. Please accept cookies for optimal performance. OK Decline