Archives for November, 2011

MS Excel and Risk Management does not blend, or does it?

In many businesses, the risk management grows from a very simple spread sheet into a complex cash flow model. If this complex cash-flow model stays in Excel, then you get an explosive combination. A conference on risk management with spreadsheet models now focuses on this combination:

What shall I choose for implementing an Excel plugin and UDF?

This question often arises, when you need to provide pricing functions for end-users and connect them to data sources, especially real-time data feeds. The answer heavily depends on your existing code you would like to include.

How do I get free real-time market Data into Excel?

This is a though one… Everybody wants real time market data – in MS Excel, in Matlab, in Java, in Theta Suite etc. But, obtaining market data is very hard and cost intensive because the stock exchanges do not want to provide real-time data for free. Ok, but what can you do about it?

How do you get free historical market data?

This is a very important and usual task. Historical data is mainly required for risk management purposes, model validation and back-testing. For these tasks software systems like Theta Suite, Matlab, Java or Excel are the main work space. We need to import the data here.

Pricing and Hedging 101

One of the main methods required in option pricing is the Black-Scholes framework. This theory is very appealing and somewhat convincing as we will see in the following. 

Welcome to Computer Aided Finance

Welcome to the Computer Aided Finance Blog or in short: the CAF Blog. In the future, I will post more or less regularly about financial modeling and all the tool for economic models.