Excel VBA Models Set 3 v.XL-VBA3.0

Advertisement

Excel VBA Models Open Source Code Learning Tool - Numerical Methods and Option Pricing Set Contains topics in applying different numerical searching methods to solve mathematical equations and implied volatility from option pricing models. It also includes vanilla option pricing models on future, currency (foreign exchange), stock index, and stock that pays a known dividend.

It contains practical and well explained examples of:
1. Numerical Searching Method - Newton-Ralphson
2. Numerical Searching Method - Secant Method
3. Implied Standard Deviation For Black/Scholes Call - Newton Approach
4. Implied Standard Deviation For Black/Scholes Call - Secant Approach
5. Implied Standard Deviation For Black/Scholes Call - Bisection Approach
6. Implied Standard Deviation For Black/Scholes Put - Newton Approach
7. Implied Standard Deviation For Black/Scholes Put - Secant Approach
8. Implied Standard Deviation For Black/Scholes Put - Bisection Approach
9. Black-Scholes Option Pricing Model - European Call and Put
10. Option Greeks Based on Black-Scholes Option Pricing Model
11. European Option Model on Asset with Known Cash Payouts
12. European Option Model on Asset with Continuous Cash Payouts (Index Option)
13. European Option Model on Currency
14. European Option Model on Futures

excel vba, numerical searching method, newton-raphson, secant method, implied standard deviation, bisection approach, black-scholes option pricing model, option greeks, index option, currency option, option on futures, open source code, finance, math

 
  • Shareware
  • 224 Kb
  • 766
  • $14.95
 
 

Review Excel VBA Models Set 3

  • captcha
 

Other software of Excel Business Solutions Int'l Corp.
  • Excel VBA Models Set 1  v.XL-VBA1.0Excel VBA Models with Open Source Code - Option Greeks, Lotto Number, Probability, Normal Distribution, Monte Carlo simulation, Black-Scholes, Binomial Option Pricing, Portfolio Optimization, Multiple Regression, Bootstrap, Multivariate distribution ...
  • Excel VBA Models Set 2  v.XL-VBA2.0Provides 12 random numbers generators - Log Normal, Log Pearson Type III, Normal, Chi-Square, F-Distribution, Student-T Distribution, Multivariate Standard Normal Distribution,Gamma, Beta, Hypergeometric, Triangular, and Binomial distributions ...

New Spreadsheets software
  • Data Curve Fit Creator Add-in  v.2.62Adds data curve fitting, interpolation and data smoothing functions to Excel. Functions include polynomial fits, several types of splines, and local regressions. Filters include moving average, Gaussian smoothing and median filtering.
  • Mightymacros Excel Multifind  v.2.1.2mightymacros new Excel Multifind is simple, and easy to use. It adds to the functionality of Excel's tool set and installs onto Excel's ribbon data tab.The Excel Multifind is an extremely useful time saving tool, and a critical one, when it comes to findi ...
  • HistogramPlus  v.1.2HistogramPlus is aimed at giving to the data analyst the ultimate Swiss knife for creating Excel histograms from data and interactively analyzing them in depth. It features 4 normality tests and P-P plots for 8 distributions ...
  • Bank2PDF  v.2.2.2.9Bank2PDF is an useful utility to convert your bank, credit card, investment broker statement OFX, QFX, QIF, QBO, OFC files to PDF format. Simply browse for your file, review transactions, save it as PDF.Bank2PDF knows many bank, credit card, investment br ...
  • Excel VBA Models Set 2  v.XL-VBA2.0Provides 12 random numbers generators - Log Normal, Log Pearson Type III, Normal, Chi-Square, F-Distribution, Student-T Distribution, Multivariate Standard Normal Distribution,Gamma, Beta, Hypergeometric, Triangular, and Binomial distributions ...
  • XP TCP/IP Repair  v.2.2XP TCP/IP Repair is a Graphical User Interface (GUI) for commands in Windows XP that repair your TCP/IP registry settings and your Winsock LSP settings.