This new and unique book demonstrates that Excel and VBA can play an important role in the explanation and implementation of numerical methods across finance. Advanced Modelling in Finance provides a comprehensive look at equities, options on equities and options on bonds from the early 1950s to the late 1990s. The book adopts a step-by-step approach to understanding the more sophisticated aspects of Excel macros and VBA programming, showing how these programming techniques can be used to model and manipulate financial data, as applied to equities, bonds and options. The book is essential for financial practitioners who need to develop their financial modelling skill sets as there is an increase in the need to analyse and develop ever more complex 'what if' scenarios.* Specifically applies Excel and VBA to the financial markets* Packaged with a CD containing the software from the examples throughout the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
"synopsis" may belong to another edition of this title.
No. 4 bestseller in 'General Finance' (erivativesreview.com, December 2001)
We only use macros where VBA functions cannot be used (such as for charts and Solver). For everything else, the spreadsheets are complemented with scores of VBA user-defined functions that do everything up to and including solving for eigenvalues and option valuation using binomial trees with thousands of steps. In particular, chapter 12 uses simulation to value options and the asociated VBA user-defined functions include both antithetic-variate and quasi-random numbers (with not a macro in sight)
"About this title" may belong to another edition of this title.
Shipping:
£ 2.98
Within U.S.A.
Shipping:
£ 3.17
Within U.S.A.
Seller: Bookmonger.Ltd, HILLSIDE, NJ, U.S.A.
hardcover. Condition: USED_VERYGOOD. **CD Included** Crease on cover* Ex-library book*. Seller Inventory # mon0000666716
Quantity: 1 available
Seller: New Legacy Books, Annandale, NJ, U.S.A.
Condition: Good. The dust jacket shows normal wear. Fast shipping and order satisfaction guaranteed. A portion of your purchase benefits Non-Profit Organizations, First Aid and Fire Stations!. Seller Inventory # 0WOPD40048M5
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. Har/Cdr. Used book that is in clean, average condition without any missing pages. Seller Inventory # 5850938-6
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Very Good. Har/Cdr. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # GRP62927305
Quantity: 1 available
Seller: BooksRun, Philadelphia, PA, U.S.A.
Hardcover. Condition: USED_GOOD. First Edition. Supplements included Ship within 24hrs. Satisfaction 100% guaranteed. APO/FPO addresses supported. Seller Inventory # 0471499226-11-18-116
Quantity: 1 available
Seller: Wonder Book, Frederick, MD, U.S.A.
Condition: Good. Good condition. Good dust jacket. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included. Seller Inventory # T09E-01540
Quantity: 1 available
Seller: Wonder Book, Frederick, MD, U.S.A.
Condition: As New. Like New condition. Very Good dust jacket. With CD! A near perfect copy that may have very minor cosmetic defects. Seller Inventory # Q07P-01210
Quantity: 1 available
Seller: Seattle Goodwill, Seattle, WA, U.S.A.
Condition: Good. May have some shelf-wear due to normal use. Your purchase funds free job training and education in the greater Seattle area. Thank you for supporting Goodwills nonprofit mission!. Seller Inventory # 0KVOG200DUJ5_ns
Quantity: 1 available
Seller: ThriftBooks-Phoenix, Phoenix, AZ, U.S.A.
Hardcover. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.35. Seller Inventory # G0471499226I4N00
Quantity: 1 available
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Hardcover. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.35. Seller Inventory # G0471499226I4N00
Quantity: 1 available