xl-modeling-excel-vba-models-combo-set-set-1-2-and-3-logo.gif

Excel VBA Models Combo Set (Set 1, 2, and 3)

Excel VBA Models Combo Set (Set 1, 2, and 3)

Are you having difficulty understanding how to do option pricing modesl and numerical procedures within Excel? Do you want to see practical examples? The The Excel VBA Models Combo Set solves these problems. It contains practical and well explained examples of:

1. Standard Deviation and Mean
2. Lotto Number Generator
3. Playing Card Probability
4. Normal Distribution Random Number Generator
5. Monte Carlo Integration
6. Black-Scholes Option Pricing Model – European Call and Put
7. Binomial Option Pricing Model
8. Portfolio Optimization
9. Multiple Regression
10. Bootstrap – A Non-Parametric Approach
11. Multivariate Standard Normal Probability Distribution
12. Monte Carlo Simulation
13. Option Greeks Based on Black-Scholes Option Pricing Model

Random Numbers Generator and Statistics Set

14. Log Normal Distribution
15. Log Pearson Type III Distribution
16. Normal Distribution
17. Chi-Square Distribution
18. F-Distribution
19. Student-T Distribution
20. Multivariate Standard Normal Distribution
21. Gamma Distribution
22. Beta Distribution
23. Hypergeometric Distribution
24. Triangular Distribution
25. Binomial Distribution

Numerical Searching Methods and Option Pricing Set

26. Numerical Searching Method – Newton-Ralphson
27. Numerical Searching Method – Secant Method
28. Implied Standard Deviation For Black/Scholes Call – Newton Approach
29. Implied Standard Deviation For Black/Scholes Call – Secant Approach
30. Implied Standard Deviation For Black/Scholes Call – Bisection Approach
31. Implied Standard Deviation For Black/Scholes Put – Newton Approach
32. Implied Standard Deviation For Black/Scholes Put – Secant Approach
33. Implied Standard Deviation For Black/Scholes Put – Bisection Approach
34. European Option Model on Asset with Known Cash Payouts
35. European Option Model on Asset with Continuous Cash Payouts (Index Option)
36. European Option Model on Currency
37. European Option Model on Futures




Purchase the full version for unlimited use

You may also be interested in:

  • Finance and Statistics Models Set (Set 1) Are you having difficulty understanding how to do finance and statistics within Excel? Do you want to see practical examples? The […]
  • Random Numbers Generator and Statistics (Set 2) Do you want to see how random numbers from different probability distribution are generated? The Random Numbers Generator and Statistics […]
  • Numerical Methods and Option Pricing Set (Set3) Are you having difficulty understanding how to do option pricing modesl and numerical procedures within Excel? Do you want to see […]
  • Monte Carlo Financial Modeling 2008 Optimized to run with Microsoft Office 365 and standard Microsoft Excel. Easy & Quick Monte Carlo Risk Analysis and Modeling Spreadsheets […]
  • Real Options Valuation The Excel Real Options Valuation template combines a set of option pricing tools and valuation models to quantify the embedded strategic […]
  • Forms ComboBox Wizard Add-in If you often work in Excel with ComboBoxes from the Forms toolbar this Excel add-in can save you many hours and prevent errors. After […]
  • Excel Download Package This package includes 33 fully accessible Workbook examples that cover topics like, Vlookup,Match,Index,Dfuntions,Advanced […]
  • OzGrid Excel Plus Add-in Formula Report Generator. Allows you to very easily create a report showing formulas within your Workbook that are either external […]
  • Model Assistant Suite Model Assistant Suite is the most useful collection of add-ins for people who use Microsoft Excel as a decision making tool: to build, […]
  • Spreadsheet Consolidator for Excel If your problem involves big volumes of Microsoft Excel spreadsheets and requirements for flexibility in consolidation then Spreadsheet […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>