An introduction to excel VBA programming: with applications in finance and insurance / (Record no. 196773)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 01372cam a2200313 i 4500 |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9781138197152 |
| 040 ## - CATALOGING SOURCE | |
| Transcribing agency | CUS |
| 082 00 - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.54 |
| Item number | GAN/A |
| 100 1# - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Gan, Guojun |
| 245 13 - TITLE STATEMENT | |
| Title | An introduction to excel VBA programming: with applications in finance and insurance / |
| Statement of responsibility, etc. | Guojun Gan |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Place of publication, distribution, etc. | Boca Raton: |
| Name of publisher, distributor, etc. | CRC press, |
| Date of publication, distribution, etc. | 2017. |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | xvi, 284 p. |
| Dimensions | 24 cm |
| 504 ## - BIBLIOGRAPHY, ETC. NOTE | |
| Bibliography, etc | Includes bibliographical references (pages 275-277) and index. |
| 505 ## - FORMATTED CONTENTS NOTE | |
| Formatted contents note | VBA PreliminariesIntroduction to VBA Getting Started Modules VBA Classes The ExcelMacro Recorder Excel ObjectsThe Excel ObjectModel The Application Object TheWorkbook Objects TheWorksheet Objects TheWorksheetFunction Object Variables, Data Types, and Scopes Variable Declaration and Data Types Arrays Constants Strings Dates Scopes Operators and Control StructuresOperators Flow Control Loops Functions, Events and File IO User-Defined Functions Events File IO Error Handling and Debugging 109Error Handling Debugging VBA Code Best Practices of VBA Coding II ApplicationsGenerating Payment Schedules Introduction Public Holidays in the United States The Julian and Gregorian Calendars Day Count ConventionsBusiness Day Conventions Implementation TheMDateModule TheMHolidayModule TheMScheduleModule TheMInterfaceModule Bootstrapping Yield Curves Introduction Interpolation Bootstrapping Yield Curves Finding Roots of an Equation Implementation TheMCurveModule TheMInterfaceModule Generating Risk-Neutral Scenarios Introduction The Black-ScholesModel Generating Random Normal NumbersImplementation TheMGeneratorModule TheMInterfaceModule Valuing a GMDBIntroductionLife Table Construction GMDB Valuation Greek Calculation Implementation TheMLifeTableModule TheMGMDBModule TheMInterfaceModule Connecting to DatabasesActiveX Data Objects SQL Implementation TheMDatabaseModule TheMInterfaceModule Object-Oriented Programming 233Introduction Objects Implementation The CZeroCurveModule The CSwapModule The CBootstrapperModule An OO Bootstrapping Tool Solutions to Selected Exercises |
| 650 #0 - SUBJECT | |
| Keyword | Visual Basic for Applications (Computer program language) |
| 650 #0 - SUBJECT | |
| Keyword | Finance |
| General subdivision | Computer programs. |
| 650 #0 - SUBJECT | |
| Keyword | Insurance |
| General subdivision | Computer programs. |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | General Books |
| Withdrawn status | Lost status | Damaged status | Not for loan | Home library | Current library | Date acquired | Cost, normal purchase price | Full call number | Accession number | Date last seen | Koha item type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Central Library, Sikkim University | Central Library, Sikkim University | 27/03/2019 | 5019.84 | 005.54 GAN/A | 47779 | 27/03/2019 | General Books |