Professional Financial Computing Using Excel and VBA /

Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Tung, Humphrey K. K. (Humphrey Kwong Kwai)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Singapore : John Wiley & Sons (Asia), 2010.
Colección:Wiley finance series.
Temas:
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
Microsoft Visual Basic for applications
Finance, Personal > Computer programs.
BUSINESS & ECONOMICS > Investments & Securities > General.
Finance, Personal > Computer programs
Finances > Informatique.
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 a 4500
001 EBOOKCENTRAL_ocn769928284
003 OCoLC
005 20240329122006.0
006 m o d
007 cr cnu---unuuu
008 120102s2010 si a ob 001 0 eng d
010 |a  2010281187 
040 |a EBLCP  |b eng  |e pn  |c EBLCP  |d OCLCQ  |d YDXCP  |d N$T  |d DG1  |d CDX  |d E7B  |d OCLCQ  |d OCLCO  |d OCLCQ  |d DEBSZ  |d OCLCF  |d OCLCA  |d OCLCE  |d OCLCQ  |d UKDOC  |d IDEBK  |d OCLCQ  |d DEBBG  |d OCLCQ  |d COO  |d NLGGC  |d OCLCQ  |d AZK  |d DG1  |d LOA  |d DG1  |d MOR  |d LIP  |d PIFAG  |d ZCU  |d OCLCQ  |d MERUC  |d OCLCQ  |d OCLCO  |d NJR  |d OCLCQ  |d OCLCO  |d STF  |d WRM  |d ICG  |d VT2  |d OCLCQ  |d OCLCO  |d WYU  |d DKC  |d OCLCQ  |d UKCRE  |d BOL  |d OCLCO  |d GA0  |d OCLCQ  |d INARC  |d OCLCO  |d OCLCL  |d OCLCQ  |d OCLCL  |d EZC 
015 |a GBA9A3962  |2 bnb 
016 7 |a 015402413  |2 Uk 
019 |a 752384920  |a 773669830  |a 778620581  |a 784124273  |a 816882095  |a 839335280  |a 852506326  |a 961684665  |a 962615512  |a 965973893  |a 988474519  |a 992031951  |a 992857977  |a 1034961528  |a 1037753158  |a 1038578790  |a 1055400446  |a 1066449548  |a 1081240417  |a 1114467133  |a 1153479197  |a 1228562516  |a 1392326360 
020 |a 9781118179062  |q (electronic bk.) 
020 |a 1118179064  |q (electronic bk.) 
020 |a 9781118390405  |q (electronic bk.) 
020 |a 1118390407  |q (electronic bk.) 
020 |a 9780470824399  |q (cloth) 
020 |a 0470824395  |q (cloth) 
020 |a 1283401509 
020 |a 9781283401500 
024 8 |a 9786613401502 
029 1 |a AU@  |b 000053284912 
029 1 |a CHBIS  |b 010879260 
029 1 |a CHNEW  |b 000602553 
029 1 |a CHNEW  |b 000938823 
029 1 |a CHVBK  |b 480191077 
029 1 |a DEBBG  |b BV041167605 
029 1 |a DEBBG  |b BV041907724 
029 1 |a DEBBG  |b BV044160717 
029 1 |a DEBSZ  |b 383100992 
029 1 |a DEBSZ  |b 397219156 
029 1 |a DEBSZ  |b 428124615 
029 1 |a DEBSZ  |b 431081875 
029 1 |a DEBSZ  |b 449279677 
029 1 |a GBVCP  |b 790035324 
029 1 |a GWDNB  |b 1060965283 
029 1 |a GWDNB  |b 106744338X 
029 1 |a NZ1  |b 14675348 
029 1 |a NZ1  |b 14792935 
029 1 |a NZ1  |b 15952594 
035 |a (OCoLC)769928284  |z (OCoLC)752384920  |z (OCoLC)773669830  |z (OCoLC)778620581  |z (OCoLC)784124273  |z (OCoLC)816882095  |z (OCoLC)839335280  |z (OCoLC)852506326  |z (OCoLC)961684665  |z (OCoLC)962615512  |z (OCoLC)965973893  |z (OCoLC)988474519  |z (OCoLC)992031951  |z (OCoLC)992857977  |z (OCoLC)1034961528  |z (OCoLC)1037753158  |z (OCoLC)1038578790  |z (OCoLC)1055400446  |z (OCoLC)1066449548  |z (OCoLC)1081240417  |z (OCoLC)1114467133  |z (OCoLC)1153479197  |z (OCoLC)1228562516  |z (OCoLC)1392326360 
037 |a 10.1002/9781118390405  |b Wiley InterScience  |n http://www3.interscience.wiley.com 
042 |a dlr 
050 4 |a HG173 
072 7 |a BUS  |x 036000  |2 bisacsh 
072 7 |a KFF  |2 bicssc 
082 0 4 |a 658.152  |2 23 
049 |a UAMI 
100 1 |a Tung, Humphrey K. K.  |q (Humphrey Kwong Kwai)  |1 https://id.oclc.org/worldcat/entity/E39PCjFWVXj7x3MHfYjK86Gfv3 
245 1 0 |a Professional Financial Computing Using Excel and VBA /  |c Humphrey K.K. Tung, Donny C.F. Lai, and Michael C.S. Wong ; with Stephen Ng. 
260 |a Singapore :  |b John Wiley & Sons (Asia),  |c 2010. 
300 |a 1 online resource :  |b illustrations. 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
340 |g polychrome.  |2 rdacc  |0 http://rdaregistry.info/termList/RDAColourContent/1003 
347 |a text file  |2 rdaft  |0 http://rdaregistry.info/termList/fileType/1002 
490 1 |a [Wiley finance] 
500 |a Includes index. 
505 0 |a Professional Financial Computing Using Excel & VBA; Contents; Preface; CHAPTER 1: Financial Engineering and Computing; 1.1 Financial Engineering and Spreadsheet Modeling; 1.2 Lehman Brothers' Products for Retail Investors; 1.3 Risk Management and Basel II; 1.4 About the Book; 1.5. Chapter Highlights; 1.6 Other Remarks; CHAPTER 2: The GARCH(1,1) Model; 2.1. The Model; 2.2. Excel Implementation; 2.3. Excel Plus VBA Implementation; CHAPTER 3: Finite Difference Methods; 3.1. Difference Equations; 3.2. Excel Implementation; 3.3. VBA Implementation; 3.4. Crank-Nicholson Scheme. 
505 8 |a CHAPTER 4: Portfolio Mean-Variance Optimization4.1. Portfolio Selection; 4.2. Excel Implementation; 4.3. Excel Plus VBA Implementation; CHAPTER 5: Newton-Raphson Method; 5.1. Newton-Raphson Method for Systems of Equations; 5.2. VBA Routine; CHAPTER 6: Yield Curve Construction Using Cubic Spline; 6.1. Cubic Spline Interpolation; 6.2. Yield Curve Construction; 6.3. Excel Plus VBA Implementation; CHAPTER 7: Binomial Option Pricing Model; 7.1. Risk-Neutral Option Pricing and the Binomial Tree; 7.2. VBA Implementation; CHAPTER 8: The Black-Derman-Toy Model. 
505 8 |a 8.1. The Term Structure Model and the Black-Derman-Toy Tree8.2. Excel Plus VBA Implementation; CHAPTER 9: Monte Carlo Option Pricing; 9.1. TheMonte Carlo Method; 9.2. Risk-Neutral Valuation; 9.3. VBA Implementation; 9.4. Exotic Options; 9.5. American Options; CHAPTER 10: Portfolio Value-at-Risk; 10.1. Portfolio Risk Simulation; 10.2. Monte Carlo Simulation for Multiple-Asset Portfolios; 10.3. Historical Simulation for Multiple-Asset Portfolios; 10.4. VBA Implementation of Portfolio Risk Simulation; 10.5. Drill Down of Portfolio Risk; CHAPTER 11: The Hull-White Model. 
505 8 |a 11.1. Hull-White Trinomial Tree11.2. Excel Plus VBA Implementation; 11.3. The General Hull-White Model; 11.4. Implementation of the General Hull-White Model; CHAPTER 12: CreditMetrics Model; 12.1. The CreditMetrics Model; 12.2. Individual (Segregate) Asset Valuation Framework; 12.3 Monte Carlo Simulation in Detail; 12.4. Excel and VBA Implementation; CHAPTER 13: KMV-Merton Model; 13.1. KMV-Merton Model of Credit Risk; 13.2. Excel and VBA Implementation; APPENDIX A: VBA Programming; A.1 Introduction; A.2 A Brief History of VBA; A.3 Essential Excel Elements for VBA; A.3.1 Excel Cell Reference. 
505 8 |a A.3.2 Excel Defined NamesA. 3.3 Excel Worksheet Functions; A.4 The VBA Development Environment (VBE); A.4.1 The Developer Tab in the Ribbon; A.4.2 The Windows of VBE; A.4.3 The Project Explorer; A.4.4 The VBA Project Structure; A.4.5 The Procedure to Create a VBA Subroutine; A.4.6 The Procedure to Create a VBA Function; A.5 Basic VBA Programming Concepts; A.5.1 Variables and Data Types; A.5.2 Declaration and Assignment Statements; A.5.3 Flow Control Statements; A.6 VBA Arrays; A.7 Using Worksheet Matrix Functions in VBA; A.8 Summary; APPENDIX B: The Excel Object Model. 
500 |a APPENDIX C: VBA Debugging Tools. 
520 |a Professional Financial Computing Using Excel and VBA is an admirable exposition that bridges the theoretical underpinnings of financial engineering and its application which usually appears as a "black-box" software application. The book opens the black-box and reveals the architecture of risk-modeling and financial engineering based on industry-standard stochastic models by utilizing Excel and VBA functionality to create a robust and practical modeling tool-kit. Financial engineering professionals who purchase this book will have a jumpstart advantage for their customized financial engineering. 
504 |a Includes bibliographical references and index. 
506 |3 Use copy  |f Restrictions unspecified  |2 star  |5 MiAaHDL 
533 |a Electronic reproduction.  |b [S.l.] :  |c HathiTrust Digital Library,  |d 2011.  |5 MiAaHDL 
538 |a Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.  |u http://purl.oclc.org/DLF/benchrepro0212  |5 MiAaHDL 
583 1 |a digitized  |c 2011  |h HathiTrust Digital Library  |l committed to preserve  |2 pda  |5 MiAaHDL 
588 0 |a Print version record. 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 0 |a Microsoft Visual Basic for applications. 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast 
630 0 7 |a Microsoft Visual Basic for applications  |2 fast 
650 0 |a Finance, Personal  |x Computer programs. 
650 7 |a BUSINESS & ECONOMICS  |x Investments & Securities  |x General.  |2 bisacsh 
650 7 |a Finance, Personal  |x Computer programs  |2 fast 
650 6 |a Finances  |x Informatique. 
758 |i has work:  |a Professional Financial Computing Using Excel and VBA (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCGJ9hJxwgW3VYWKCgdxwbq  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |a Tung, Humphrey K.K. (Humphrey Kwong Kwai).  |t Professional financial computing using Excel and VBA.  |d Singapore : Wiley, 2010  |z 9780470824399  |w (OCoLC)773669830 
830 0 |a Wiley finance series. 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=832453  |z Texto completo 
938 |a 123Library  |b 123L  |n 52038 
938 |a Coutts Information Services  |b COUT  |n 20575473  |c 95.00 USD 
938 |a EBL - Ebook Library  |b EBLB  |n EBL832453 
938 |a ebrary  |b EBRY  |n ebr10524052 
938 |a EBSCOhost  |b EBSC  |n 420757 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n 340150 
938 |a YBP Library Services  |b YANK  |n 7310731 
938 |a YBP Library Services  |b YANK  |n 9571153 
938 |a YBP Library Services  |b YANK  |n 12670878 
938 |a Internet Archive  |b INAR  |n professionalfina0000tung 
994 |a 92  |b IZTAP 

Ejemplares similares