Showing posts with label Spreadsheets. Show all posts
Showing posts with label Spreadsheets. Show all posts

Thursday, October 4, 2012


Calculadora para Barrier Options

Con esta calculadora, que utiliza el modelo binomial, ustedes podrán calcular precios de Opciones de todo tipo, Call/Put, European/American, Down/Up, Out/In. Incluso si lo desean también pueden calcular precios de opciones con Rebate. Asmismo, también pueden utilizarla para observar la sensibilidad del precio respecto a las distintas variables.




Tuesday, September 4, 2012

Calculadora para estrategia con opciones

Les presento una calculadora para armar estrategias con opciones, básicamente yo la usé para evaluar una estrategia para explotar discrepancias en Skew de diferentes índices, pero puede ser utilizada para evaluar cualquier estrategia.

Espero que les sea de utilidad y compartan conmigo su experiencia usándola.

Monday, July 30, 2012

Binomial Options Calculator

With this spreadsheet you are going to calculate the price of an option using the binomial model. This calculator is flexible in tree dimensions, Put or Call, European or American and number of nods in the tree. Furthermore, you are going to be able to calculate Delta and Gamma of the option.



Wednesday, May 30, 2012

PDE SOLVER

Today I present a PDE solver applied to options valuation. The interesting thing of this model is that you not only get the price of the option but also  the price of it for all the possible Spot prices of the underlying.

Monday, April 23, 2012

Interpolation

This is a file help you to perform linear, polynomial or cubic spline interpolation. Is a flexible file that let you choose the kind of interpolation and the amount of original data points. Usefull for interpolate Interest Rates, Implied Volatility, etc.

Options Calculator

Here I share with you an option calculator using Black-Scholes formula. With this calculator you are going to be able to obtain the Price and all the Greeks for European Calls and Put Options