{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["report2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"report2","index":0,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[12,2,12,3],[12,4,12,5],[13,2,13,3],[13,4,13,5],[14,2,14,3],[14,4,14,5],[15,2,15,3],[16,2,16,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[35,2,35,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA990007675450403321"]
[null,null,"Autore",null,"De Marco, Carmelo"]
[null,null,"Titolo",null,"La prescrizione nell'assicurazione privata / Carmelo De Marco"]
[null,null,"Pubbl/distr/stampa",null,"Milano : Giuffre, 1982"]
[null,null,"Descrizione fisica",null,"150 p. ; 24 cm"]
[null,null,"Collana",null,"Centro studi assicurativi- Milano. Collana di studi. ; 6"]
[null,null,"Disciplina",null,"346.08"]
[null,null,"Locazione",null,"DDCP"]
[null,null,"Collocazione",null,"21-E-7"]
[null,null,"Lingua di pubblicazione",null,"Italiano"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,"2.","Record Nr.",null,"UNINA9910811234803321"]
[null,null,"Autore",null,"Tung Humphrey K. K (Humphrey Kwong Kwai)"]
[null,null,"Titolo",null,"Professional financial computing using Excel and VBA / / Humphrey K.K. Tung, Donny C.F. Lai, and Michael C.S. Wong ; with Stephen Ng"]
[null,null,"Pubbl/distr/stampa",null,"Singapore ; ; Hoboken, NJ, : Wiley, 2010"]
[null,null,"ISBN",null,"9786613401502"]
[{"$nulls":4},"9781118179086"]
[{"$nulls":4},"1118179080"]
[{"$nulls":4},"9781283401500"]
[{"$nulls":4},"1283401509"]
[{"$nulls":4},"9781118390405"]
[{"$nulls":4},"1118390407"]
[{"$nulls":4},"9781118179062"]
[{"$nulls":4},"1118179064"]
[null,null,"Edizione",null,"[1st ed.]"]
[null,null,"Descrizione fisica",null,"1 online resource (365 p.)"]
[null,null,"Collana",null,"[Wiley finance]"]
[null,null,"Disciplina",null,"332.0285536"]
[null,null,"Soggetti",null,"Finance - Data processing"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Note generali","Series statement from jacket."]
[null,null,null,"Nota di bibliografia","Includes bibliographical references and index."]
[null,null,"Nota di contenuto",null,"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"]
[{"$nulls":4},"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; "]
[{"$nulls":4},"CHAPTER 8: The Black-Derman-Toy Model"]
[{"$nulls":4},"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"]
[{"$nulls":4},"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"]
[{"$nulls":4},"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"]
[{"$nulls":4},"APPENDIX C: VBA Debugging Tools"]
[null,null,null,"Sommario/riassunto","\"\"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"]