Excel/VBA Applications of  Niklas Karlström

The following applications have been created in Visual Basic for Applications
in Excel. Please feel free to download and evaluate any of the applications

If you have any questions or suggestions for improvement, please drop me a line at niklas.karlstrom@hanken.fi

Download Description Screen shot Updated  

Black & Scholes
Option Pricing Add-in

This is an Excel Add-In for calculating option prices on European Call and Put options. It has a userfriendly interface and can be accessed anytime by simply right-clicking in any cell in Excel. When installed, right click with your mouse on any cell in the spreadsheet and the shortcut to the application will appear in the menu.
 


 

11-07-2005

 

Monte Carlo Simulator Add-In

A very fast Monte Carlo simulator, able to iterate up to 50,000 random numbers with various distributions in any Excel spreadsheet. This is an Excel Add-In and was created as a final project in my Financial Modelling class. (Grade: A).
The application can easily be used in valuation of companies, estimation of project times and various cost simulations and stress testing in Excel. Please use the install file to install the Add-In.
 

08-07-2005

 
Golf Tracker (Beta) Program that helps you keep track of your golf rounds. The application comes with three golf courses included. (Pirilö, Kråklund and Kokkola golf courses). The application can handle scores of unlimited number of players and golf courses and has a nice and userfriendly interface. Give it a shot, because I've worked quite long with it.
 
29-06-2005


 
 
Random Password Generator VBA application to generate random password phrases. It also has the ability to analyze how long it would take to break the password with a Pentium 4 CPU.
 
10-06-2005


 
 
Finnish Bank References

 

Small template with built-in functions for calculating the check digit of bank references used in Finland.
 

 
08-06-2005  
Trow a Dice

 

Have you ever been given the home assignment to bring home a dice and throw it 50 times and then record the results? Then you wish you had this small Excel application. With this somewhat useless application you can throw a dice as many times as you wish and record the results for easy printing.
 

 
26-02-2005