Advanced modelling in finance using Excel and VBA
Author: Mary Jackson, Mike Staunton
List Price: $75.00
Our Price: Click to see the latest and low price
ISBN: 0471499226
Publisher: John Wiley & Sons (30 May, 2001)
Sales Rank: 2,096
Average Customer Rating: 4.78 out of 5
Customer Reviews
Rating: 5 out of 5
Advanced modelling in finance using Excel and VBA
This is probably the best book written on financial modeling in excel, definitely worth the $50. Comes with a great CD-ROM. The books strength is its illustration of financial models and implantation in Excel. Since the models focus on static solutions the book is probably of greater use in academics than in industry. It would be great if there was instruction about how to input real time data into Excel and implement the models dynamically. Of particular interest to me is the great VBA code given on the CD, namely the code to calculate autocorrelation, cubic spines, eigenvalues and eigenvectors. This alone was worth the 50 bucks.There are some major deficiencies in this book. Noticeably absent topics include: bond portfolio immunization; swap pricing; forwards and futures hedging; the ARCH, GARCH and CHARMA models.
My background is in finance, mathematics and computer science. Unlike the guy above, I don't see any need for advanced mathematics in order to study this book. In fact I am sure you don't. The point is to make excel do it for you. However it will a lot easier for those who understand the finance and mathematics behind what they are telling excel to do. I am assuming that those who are considering this book most likely have taken at least one college level calculus course and one statistics course. But I don't think even that is necessary and definitely not stochastic calculus.
Rating: 5 out of 5
Stochastic Calculus?
Being a professional Azerbijani Yak trader, I (like my esteemed colleague) have used extensively Stochastic Calculus!
I am also very strong in the modelling & programming, area.
Just like my esteemed colleague, I stand in awe before this book, and certainly class it as a godsend!The book not only applies to my current vocation, but i have found practical application for this book in the Scandanavian Seal clubbing industry.
I have stopped my wheels spinning, life is a truly experience after reading this book.
I also highly recommend Dr. Zeus, Cat in the Hat & Green eggs & Ham!
Rating: 5 out of 5
Highly Recommended
VBA is one of those tools I long knew I should be proficient in but never got around to learning. That is, not until I found this book. It makes it easy for a financial professional to quickly come up to speed and start coding VBA within spreadsheets. The fact that the focus is on financial applications means that you learn coding techniques that will be useful on the job. I highly recommend the book! Similar Products
Market Models: A Guide to Financial Data Analysis
The Complete Guide to Option Pricing Formulas
Monte Carlo Methods in Finance
Options, Futures, and Other Derivatives (5th Edition)
Financial Modeling - 2nd Edition
Book Index