Cargando…

How to implement market models using VBA /

"Accessible VBA coding for complex financial modellingImplementing Market Models Using VBA makes solving complex valuation issues accessible to any financial professional with a taste for mathematics. With a focus on the clarity of code, this practical introductory guide includes chapters on VB...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Goossens, Francois, 1960-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Chicester, West Sussex UK : John Wiley & Sons, Inc., 2015.
Temas:
Acceso en línea:Texto completo
Texto completo

MARC

LEADER 00000cam a2200000 i 4500
001 EBOOKCENTRAL_ocn898756996
003 OCoLC
005 20240329122006.0
006 m o d
007 cr |||||||||||
008 141224s2015 enk ob 001 0 eng
010 |a  2014049792 
040 |a DLC  |b eng  |e rda  |e pn  |c DLC  |d N$T  |d YDXCP  |d DG1  |d E7B  |d OCLCF  |d UMI  |d EBLCP  |d IDEBK  |d RECBK  |d HEBIS  |d CDX  |d DEBSZ  |d COO  |d OCLCQ  |d DEBBG  |d OCLCQ  |d TEFOD  |d VT2  |d K6U  |d IDB  |d COCUF  |d CCO  |d LIP  |d PIFFA  |d FVL  |d ZCU  |d OCLCQ  |d MERUC  |d U3W  |d OCLCQ  |d STF  |d CEF  |d CRU  |d ICG  |d VTS  |d OCLCQ  |d WYU  |d TKN  |d OCLCQ  |d UAB  |d DKC  |d OCLCQ  |d UKAHL  |d UX1  |d OCLCQ  |d ERF  |d OCLCQ  |d TUHNV  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL 
019 |a 902417444  |a 914287634  |a 927376388  |a 961646639  |a 962625206  |a 988635796  |a 992925546  |a 1005824992  |a 1055332234  |a 1066681482  |a 1081291415  |a 1101720066  |a 1103250690  |a 1148068993 
020 |a 9781118961988  |q (electronic bk.) 
020 |a 1118961986  |q (electronic bk.) 
020 |a 9781118961995  |q (electronic bk.) 
020 |a 1118961994  |q (electronic bk.) 
020 |a 9781119065838  |q (electronic bk.) 
020 |a 1119065836  |q (electronic bk.) 
020 |a 1118962001  |q (electronic bk.) 
020 |a 9781118962008  |q (electronic bk.) 
020 |a 9781322877082 
020 |a 1322877084 
020 |z 9781118962008  |q (hardback) 
029 1 |a AU@  |b 000053965964 
029 1 |a CHBIS  |b 010879955 
029 1 |a CHNEW  |b 000708559 
029 1 |a CHVBK  |b 334959454 
029 1 |a DEBBG  |b BV042743703 
029 1 |a DEBBG  |b BV043019860 
029 1 |a DEBBG  |b BV043397401 
029 1 |a DEBBG  |b BV043615988 
029 1 |a DEBSZ  |b 431874271 
029 1 |a DEBSZ  |b 44947724X 
029 1 |a DEBSZ  |b 45569429X 
029 1 |a DEBSZ  |b 475038142 
029 1 |a GBVCP  |b 817044752 
029 1 |a GBVCP  |b 882845942 
029 1 |a NZ1  |b 15914899 
029 1 |a AU@  |b 000066261008 
035 |a (OCoLC)898756996  |z (OCoLC)902417444  |z (OCoLC)914287634  |z (OCoLC)927376388  |z (OCoLC)961646639  |z (OCoLC)962625206  |z (OCoLC)988635796  |z (OCoLC)992925546  |z (OCoLC)1005824992  |z (OCoLC)1055332234  |z (OCoLC)1066681482  |z (OCoLC)1081291415  |z (OCoLC)1101720066  |z (OCoLC)1103250690  |z (OCoLC)1148068993 
037 |a CL0500000619  |b Safari Books Online 
037 |a 2DF5EFB5-98E1-4235-BA0C-B82F12FBF0EC  |b OverDrive, Inc.  |n http://www.overdrive.com 
042 |a pcc 
050 0 0 |a HG106 
072 7 |a BUS  |x 027000  |2 bisacsh 
082 0 0 |a 332.0285/5133  |2 23 
084 |a BUS027000  |2 bisacsh 
049 |a UAMI 
100 1 |a Goossens, Francois,  |d 1960- 
245 1 0 |a How to implement market models using VBA /  |c Francois Goossens. 
264 1 |a Chicester, West Sussex UK :  |b John Wiley & Sons, Inc.,  |c 2015. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
500 |a Includes index. 
520 |a "Accessible VBA coding for complex financial modellingImplementing Market Models Using VBA makes solving complex valuation issues accessible to any financial professional with a taste for mathematics. With a focus on the clarity of code, this practical introductory guide includes chapters on VBA fundamentals and essential mathematical techniques, helping readers master the numerical methods to build an algorithm that can be used in a wide range of pricing problems. Coverage includes general algorithms, vanilla instruments, multi-asset instruments, yield curve models, interest rate exotics, and more, guiding readers thoroughly through pricing in the capital markets area. The companion website features additional VBA code and algorithmic techniques, and the interactive blog provides a forum for discussion of code with programmers and financial engineers, giving readers insight into the different applications and customisations possible for even more advanced problem solving. Financial engineers implement models from a mathematical representation of an asset's performance by building a program that performs a valuation of securities based on this asset. Implementing Market Models Using VBA makes this technical process understandable, with well-explained algorithms, VBA code, and accessible theoretical explanations. Decide which numerical method to use in which scenario Identify the necessary building blocks of an algorithm Write clear, functional VBA code for a variety of problems Apply algorithms to different instruments and models Designed for finance professionals, this book brings more accurate modelling within reach for anyone with interest in the market. For clearer code, patient explanation, and practical instruction, Implementing Market Models Using VBA is an essential introductory guide"--  |c Provided by publisher. 
588 0 |a Print version record and CIP data provided by publisher. 
504 |a Includes bibliographical references and index. 
505 0 |a Cover; Title Page; Copyright; Contents; Preface; Acknowledgements; Abbreviations; About the Author; Chapter 1 The Basics of VBA Programming; 1.1 Getting started; 1.2 VBA objects and syntax; 1.2.1 The object-oriented basic syntax; 1.2.2 Using objects; 1.3 Variables; 1.3.1 Variable declaration; 1.3.2 Some usual objects; 1.3.3 Arrays; 1.4 Arithmetic; 1.5 Subroutines and functions; 1.5.1 Subroutines; 1.5.2 Functions; 1.5.3 Operations on one-dimensional arrays; 1.5.4 Operations on two-dimensional arrays (matrices); 1.5.5 Operations with dates; 1.6 Custom objects; 1.6.1 Types; 1.6.2 Classes. 
505 8 |a 1.7 Debugging1.7.1 Error handling; 1.7.2 Tracking the code execution; Chapter 2 Mathematical Algorithms; 2.1 Introduction; 2.2 Sorting lists; 2.2.1 Shell sort; 2.2.2 Quick sort; 2.3 Implicit equations; 2.4 Search for extrema; 2.4.1 The Nelder-Mead algorithm; 2.4.2 The simulated annealing; 2.5 Linear algebra; 2.5.1 Matrix inversion; 2.5.2 Cholesky decomposition; 2.5.3 Interpolation; 2.5.4 Integration; 2.5.5 Principal Component Analysis; Chapter 3 Vanilla Instruments; 3.1 Definitions; 3.2 Fixed income; 3.2.1 Bond market; 3.2.2 Interbank market; 3.3 Vanilla derivatives; 3.3.1 Forward contracts. 
505 8 |a 3.3.2 Swaps3.3.3 Bond futures; 3.4 Options basics; 3.4.1 Brownian motion; 3.4.2 Ito integral; 3.4.3 Ito formula; 3.4.4 Black-Scholes basic model; 3.4.5 Risk-neutral probability; 3.4.6 Change of probability; 3.4.7 Martingale and numeraires; 3.4.8 European-style options pricing; 3.5 First generation exotic options; 3.5.1 Barrier options; 3.5.2 Quanto options; Chapter 4 Numerical Solutions; 4.1 Finite differences; 4.1.1 Generic equation; 4.1.2 Implementation; 4.2 Trees; 4.2.1 Binomial trees; 4.2.2 Trinomial trees; 4.3 Monte-Carlo scenarios; 4.3.1 Uniform number generator. 
505 8 |a 4.3.2 From uniform to Gaussian numbers4.4 Simulation and regression; 4.5 Double-barrier analytical approximation; Chapter 5 Monte-Carlo Pricing Issues; 5.1 Multi-asset simulation; 5.1.1 The correlations issue; 5.1.2 The Gaussian case; 5.1.3 Exotics; 5.2 Discretization schemes; 5.3 Variance reduction techniques; 5.3.1 Antithetic variates; 5.3.2 Importance sampling; 5.3.3 Control variates; Chapter 6 Yield Curve Models; 6.1 Short rate models; 6.1.1 Introduction; 6.1.2 Hull and White one-factor model; 6.1.3 Gaussian two-factor model; 6.1.4 Hull and White two-factor model; 6.2 Forward rate models. 
505 8 |a 6.2.1 Generic Heath-Jarrow-Morton6.2.2 LMM (LIBOR market model); Chapter 7 Stochastic Volatilities; 7.1 The Heston model; 7.1.1 Code; 7.1.2 A faster algorithm; 7.1.3 Calibration; 7.2 Barrier options; 7.2.1 Numerical results; 7.2.2 Code; 7.3 Asian-style options; 7.4 SABR model; 7.4.1 Caplets; 7.4.2 Code; Chapter 8 Interest Rate Exotics; 8.1 CMS swaps; 8.1.1 Code; 8.2 Cancelable swaps; 8.2.1 Code; 8.2.2 Tree approximation; 8.3 Target redemption note; 8.3.1 Code; Bibliography; Index; EULA. 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a Finance  |x Mathematical models  |x Computer programs. 
650 0 |a Visual Basic for Applications (Computer program language) 
650 6 |a Finances  |x Modèles mathématiques  |x Logiciels. 
650 7 |a BUSINESS & ECONOMICS  |x Finance.  |2 bisacsh 
650 7 |a Finance  |x Mathematical models  |x Computer programs  |2 fast 
650 7 |a Visual Basic for Applications (Computer program language)  |2 fast 
758 |i has work:  |a How to implement market models using VBA (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGjBKjj6MY6GhgY7jHYGd3  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Goossens, Francois, 1960-  |t How to implement market models using VBA.  |d West Sussex : John Wiley & Sons, Inc., 2015  |z 9781118962008  |w (DLC) 2014041091 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1895819  |z Texto completo 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781118961995/?ar  |z Texto completo 
938 |a Askews and Holts Library Services  |b ASKH  |n AH27098651 
938 |a Askews and Holts Library Services  |b ASKH  |n AH27099165 
938 |a Coutts Information Services  |b COUT  |n 30590593 
938 |a EBL - Ebook Library  |b EBLB  |n EBL1895819 
938 |a ebrary  |b EBRY  |n ebr11012467 
938 |a EBSCOhost  |b EBSC  |n 943225 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis30590593 
938 |a Recorded Books, LLC  |b RECE  |n rbeEB00595878 
938 |a YBP Library Services  |b YANK  |n 12261380 
938 |a YBP Library Services  |b YANK  |n 12281354 
994 |a 92  |b IZTAP