Jackson, Mary; Staunton, Mike <br/><br/>
Advanced modelling in finance using Excel and VBA 

 - Chichester  John Wiley & Sons  2001 
 - xii, 263p.,cd  25 cm ; Hard Bound 
<br/><br/> 63.95 $ 
<br/><br/>Introduction <br/>Advanced Excel Functions and Procedures <br/>Introduction to VBA <br/>Writing VBA User-Defined Functions <br/>Introduction to Equities <br/>Portfolio Optimisation <br/>Asset Pricing <br/>Performance Measurement and Attribution <br/>Introduction to Options on Equities <br/>Binomial Trees <br/>The Black <br/>Scholes Formula <br/>Other Numerical Methods for European Options <br/>Non-Normal Distributions and Implied Volatility <br/>Introduction to Valuing Options on Bonds <br/>Interest Rate Models <br/>Matching the Term Structure <br/>Appendix: Other VBA Functions 
<br/><br/> Advanced Modelling in Finance Using Excel and VBA outlines a step-by-step approach to using the more sophisticated aspects of Excel macros and VBA programming to model and manipulate financial data, illustrating with practical examples how these can be applied to a variety of financial problems and situations. 
<br/><br/><label>ISBN: </label>0471499226 
<br/><br/><label>Subjects--Topical Terms: </label><br/>Finance--Mathematical models<br/>Microsoft Visual Basic for applications<br/>Microsoft Excel (Computer file)