skip to content
How to implement market models using VBA Preview this item
ClosePreview this item
Checking...

How to implement market models using VBA

Author: Francois Goossens
Publisher: Chicester, West Sussex UK : John Wiley & Sons, Inc., 2015.
Series: Wiley finance series.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
"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  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Goossens, Francois, 1960-
How to implement market models using VBA.
West Sussex : John Wiley & Sons, Inc., 2015
(DLC) 2014041091
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Francois Goossens
ISBN: 9781118961988 1118961986 9781118961995 1118961994 9781119065838 1119065836 1118962001 9781118962008 9781322877082 1322877084
OCLC Number: 898756996
Notes: Includes index.
Description: 1 online resource.
Contents: 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. 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. 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. 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. 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.
Series Title: Wiley finance series.
Responsibility: Francois Goossens.
More information:

Abstract:

Accessible VBA coding for complex financial modelling How to Implement Market Models Using VBA makes solving complex valuation issues accessible to any financial professional with a taste for  Read more...

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/898756996> # How to implement market models using VBA
    a schema:Book, schema:MediaObject, schema:CreativeWork ;
    library:oclcnum "898756996" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/2250266287#Topic/business_&_economics_finance> ; # BUSINESS & ECONOMICS--Finance
    schema:about <http://experiment.worldcat.org/entity/work/data/2250266287#Topic/visual_basic_for_applications_computer_program_language> ; # Visual Basic for Applications (Computer program language)
    schema:about <http://dewey.info/class/332.02855133/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/2250266287#Topic/finance_mathematical_models_computer_programs> ; # Finance--Mathematical models--Computer programs
    schema:bookFormat schema:EBook ;
    schema:creator <http://experiment.worldcat.org/entity/work/data/2250266287#Person/goossens_francois_1960> ; # Francois Goossens
    schema:datePublished "2015" ;
    schema:description "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."@en ;
    schema:description ""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"--"@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/2250266287> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/2250266287#Series/wiley_finance_series> ; # Wiley finance series.
    schema:isSimilarTo <http://worldcat.org/entity/work/data/2250266287#CreativeWork/how_to_implement_market_models_using_vba> ;
    schema:name "How to implement market models using VBA"@en ;
    schema:productID "898756996" ;
    schema:url <http://site.ebrary.com/lib/rdcollege/Doc?id=11012467> ;
    schema:url <http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&db=nlabk&AN=943225> ;
    schema:url <https://www.overdrive.com/search?q=2DF5EFB5-98E1-4235-BA0C-B82F12FBF0EC> ;
    schema:url <http://ebookcentral.proquest.com/lib/gprc-ebooks/detail.action?docID=1895819> ;
    schema:url <http://ezproxy.agpc.talonline.ca:80/login?url=http://site.ebrary.com/lib/gprc/Doc?id=11012467> ;
    schema:url <http://ebookcentral.proquest.com/lib/macewan-ebooks/detail.action?docID=1895819> ;
    schema:url <http://lib.myilibrary.com/detail.asp?id=718990> ;
    schema:url <http://proxy.ufv.ca:2048/login?url=http://site.ebrary.com/lib/ucfv/Doc?id=11012467> ;
    schema:url <http://lib.myilibrary.com?id=718990> ;
    schema:url <http://proquest.safaribooksonline.com/9781118961995> ;
    schema:url <http://ebookcentral.proquest.com/lib/ucm/detail.action?docID=1895819> ;
    schema:url <http://site.ebrary.com/lib/concordiaab/Doc?id=11012467> ;
    schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=1895819> ;
    schema:url <http://iclibezp1.cc.ic.ac.uk/login?url=http://onlinelibrary.wiley.com/book/10.1002/9781119065838> ;
    schema:url <http://catalogimages.wiley.com/images/db/jimages/9781118962008.jpg> ;
    schema:url <http://proquest.tech.safaribooksonline.de/9781118961995> ;
    schema:url <http://proquest.safaribooksonline.com/?fpi=9781118961995> ;
    schema:url <http://dx.doi.org/10.1002/9781119065838> ;
    schema:url <https://ezproxy.kpu.ca:2443/login?url=http://site.ebrary.com/lib/kwantlen/Doc?id=11012467> ;
    schema:url <http://ebookcentral.proquest.com/lib/illcencol-ebooks/detail.action?docID=1895819> ;
    schema:url <http://swbplus.bsz-bw.de/bsz44947724xcov.htm> ;
    schema:url <http://ebookcentral.proquest.com/lib/columbia/detail.action?docID=1895819> ;
    schema:url <http://0-ebookcentral.proquest.com.oasys.lib.oxy.edu/lib/oxy/detail.action?docID=1895819> ;
    schema:url <http://site.ebrary.com/lib/interpuertorico/Doc?id=11012467> ;
    schema:url <http://ebookcentral.proquest.com/lib/rdc/detail.action?docID=1895819> ;
    schema:url <http://ebookcentral.proquest.com/lib/warw/detail.action?docID=1895819> ;
    schema:url <http://site.ebrary.com/lib/macewan/Doc?id=11012467> ;
    schema:url <http://onlinelibrary.wiley.com/book/10.1002/9781119065838> ;
    schema:url <http://rbdigital.oneclickdigital.com> ;
    schema:url <http://www.myilibrary.com?id=718990> ;
    schema:url <https://samples.overdrive.com/how-to-implement-2df5ef?.epub-sample.overdrive.com> ;
    schema:url <http://ebookcentral.proquest.com/lib/concordiaab-ebooks/detail.action?docID=1895819> ;
    schema:url <http://site.ebrary.com/id/11012467> ;
    schema:workExample <http://worldcat.org/isbn/9781118962008> ;
    schema:workExample <http://worldcat.org/isbn/9781322877082> ;
    schema:workExample <http://worldcat.org/isbn/9781119065838> ;
    schema:workExample <http://worldcat.org/isbn/9781118961995> ;
    schema:workExample <http://worldcat.org/isbn/9781118961988> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/898756996> ;
    .


Related Entities

<http://0-ebookcentral.proquest.com.oasys.lib.oxy.edu/lib/oxy/detail.action?docID=1895819>
    rdfs:comment "Read e-book on Ebook Central (Occidental College authentication required)" ;
    .

<http://ebookcentral.proquest.com/lib/concordiaab-ebooks/detail.action?docID=1895819>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://ebookcentral.proquest.com/lib/gprc-ebooks/detail.action?docID=1895819>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://ebookcentral.proquest.com/lib/illcencol-ebooks/detail.action?docID=1895819>
    rdfs:comment "Available for ICC via Ebook Central. Click here to access." ;
    .

<http://ebookcentral.proquest.com/lib/macewan-ebooks/detail.action?docID=1895819>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://ebookcentral.proquest.com/lib/rdc/detail.action?docID=1895819>
    rdfs:comment "from Ebook Central Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://experiment.worldcat.org/entity/work/data/2250266287#Person/goossens_francois_1960> # Francois Goossens
    a schema:Person ;
    schema:birthDate "1960" ;
    schema:familyName "Goossens" ;
    schema:givenName "Francois" ;
    schema:name "Francois Goossens" ;
    .

<http://experiment.worldcat.org/entity/work/data/2250266287#Series/wiley_finance_series> # Wiley finance series.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/898756996> ; # How to implement market models using VBA
    schema:name "Wiley finance series." ;
    schema:name "Wiley finance series" ;
    .

<http://experiment.worldcat.org/entity/work/data/2250266287#Topic/business_&_economics_finance> # BUSINESS & ECONOMICS--Finance
    a schema:Intangible ;
    schema:name "BUSINESS & ECONOMICS--Finance"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2250266287#Topic/finance_mathematical_models_computer_programs> # Finance--Mathematical models--Computer programs
    a schema:Intangible ;
    schema:name "Finance--Mathematical models--Computer programs"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/2250266287#Topic/visual_basic_for_applications_computer_program_language> # Visual Basic for Applications (Computer program language)
    a schema:Intangible ;
    schema:name "Visual Basic for Applications (Computer program language)"@en ;
    .

<http://ezproxy.agpc.talonline.ca:80/login?url=http://site.ebrary.com/lib/gprc/Doc?id=11012467>
    rdfs:comment "from ebrary Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://onlinelibrary.wiley.com/book/10.1002/9781119065838>
    rdfs:comment "URL des Erstveröffentlichers" ;
    .

<http://proxy.ufv.ca:2048/login?url=http://site.ebrary.com/lib/ucfv/Doc?id=11012467>
    rdfs:comment "An electronic book accessible through the World Wide Web; click to view" ;
    .

<http://site.ebrary.com/lib/concordiaab/Doc?id=11012467>
    rdfs:comment "from ebrary Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://site.ebrary.com/lib/interpuertorico/Doc?id=11012467>
    rdfs:comment "An electronic book accessible through the World Wide Web; click to view" ;
    .

<http://site.ebrary.com/lib/macewan/Doc?id=11012467>
    rdfs:comment "from ebrary Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://site.ebrary.com/lib/rdcollege/Doc?id=11012467>
    rdfs:comment "from ebrary Academic Complete" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;
    .

<http://worldcat.org/entity/work/data/2250266287#CreativeWork/how_to_implement_market_models_using_vba>
    a schema:CreativeWork ;
    rdfs:label "How to implement market models using VBA." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/898756996> ; # How to implement market models using VBA
    .

<http://worldcat.org/isbn/9781118961988>
    a schema:ProductModel ;
    schema:isbn "1118961986" ;
    schema:isbn "9781118961988" ;
    .

<http://worldcat.org/isbn/9781118961995>
    a schema:ProductModel ;
    schema:isbn "1118961994" ;
    schema:isbn "9781118961995" ;
    .

<http://worldcat.org/isbn/9781118962008>
    a schema:ProductModel ;
    schema:isbn "1118962001" ;
    schema:isbn "9781118962008" ;
    .

<http://worldcat.org/isbn/9781119065838>
    a schema:ProductModel ;
    schema:isbn "1119065836" ;
    schema:isbn "9781119065838" ;
    .

<http://worldcat.org/isbn/9781322877082>
    a schema:ProductModel ;
    schema:isbn "1322877084" ;
    schema:isbn "9781322877082" ;
    .

<https://ezproxy.kpu.ca:2443/login?url=http://site.ebrary.com/lib/kwantlen/Doc?id=11012467>
    rdfs:comment "An electronic book accessible through the World Wide Web; click to view" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.