E-raamat: Essentials of Excel VBA, Python, and R: Volume II: Financial Derivatives, Risk Management and Machine Learning

Chapter
1. Introduction.
Chapter
2. Introduction to Excel Programming.-
Chapter
3. Introduction to VBA Programming.
Chapter
4. Professional
Techniques Used in Excel and Excel VBA Techniques.
Chapter
5. Decision Tree
Approach for Binomial Option Pricing Model.
Chapter
6. Microsoft Excel
Approach to Estimating Alternative Option Pricing Models.
Chapter
7.
Alternative Methods to Estimate Implied Variances.
Chapter
8. Greek Letters
and Portfolio Insurance.
Chapter
9. Portfolio Analysis and Option
Strategies.
Chapter
10. Alternative Simulation Methods and Their
Applications.
Chapter
11. Linear Models for Regression.
Chapter
12. Kernel
Linear Model.
Chapter
13. Neural Networks and Deep Learning.
Chapter
14.
Applications of Alternative Machine Learning Methods for Credit Card Default
Forecasting.
Chapter
15. An Application of Deep Neural Networks for
Predicting Credit Card Delinquencies.
Chapter
16. Binomial/Trinomial Tree
Option Pricing Using Python.
Chapter
17. Financial Ratios and its
Applications.-
Chapter
18. Time Value Money Analysis.
Chapter 19. Capital
Budgeting under Certainty and Uncertainty.
Chapter 20. Financial Planning
and Forecasting.
Chapter 21. Hedge Ratios: Theory and Applications.-
Chapter 22. Application of simultaneous equation in finance research: Methods
and empirical results.
Chapter
23. Using R Program to Estimate Binomial
Option Pricing Model and Black & Scholes Option Pricing Model.

John C. Lee is Director of the Center for PBBEF Research. A Microsoft Certified Professional in Microsoft Visual Basic and Microsoft Excel VBA, Mr. Lee has worked over 20 years in both the business and technical fields as an accountant, auditor, systems analyst, as well as a business software developer. Formerly, the Senior Technology Officer at the Chase Manhattan Bank and Assistant Vice President at Merrill Lynch, he is also the author of Business and Financial Statistics Using Minitab 12 and Microsoft Excel 97, as well as Financial Analysis, Planning and Forecasting with Cheng-Few Lee and Alice Lee. Jow-Ran Chang is Professor and Department Chairperson of the Department of Quantitative Finance at National Tsing Hua University (Taiwan). He is the author of Financial Engineering and Computational Finance: A Matlab-based Introduction (2007). Dr. Chang's research focuses on asset pricing, risk management, financial management, and financial product design. Lie-Jane Kao is a Professor and Dean of the college of Finance at Takming University of Science and Technology (Taiwan). Dr. Kao's research focuses on quantitative financial/risk modeling, machine learning in finance, blockchain and its application, and had published papers in relevant Journals, including Review of Derivatives Research, Economic Modelling, International Journal of Information Technology and Decision Making, International Review of Economics & Finance, etc. Cheng-Few Lee is a Distinguished Professor of Finance at Rutgers Business School, Rutgers University and was chairperson of the Department of Finance from 19881995. He has also served on the faculty of the University of Illinois (IBE Professor of Finance) and the University of Georgia. He has maintained academic and consulting ties in Taiwan, Hong Kong, China and the United States for the past three decades. He has been a consultant to many prominent groups including, the American Insurance Group, the World Bank, the United Nations, The Marmon Group Inc., Wintek Corporation, and Polaris Financial Group.Professor Lee founded the Review of Quantitative Finance and Accounting (RQFA) in 1990 and the Review of Pacific Basin Financial Markets and Policies (RPBFMP) in 1998, and serves as managing editor for both journals. He was also a co-editor of the Financial Review (1985-1991) and the Quarterly Review of Economics and Finance (1987-1989).In the past 42 years, Dr. Lee has written numerous textbooks ranging in subject matters from financial management to corporate finance, security analysis and portfolio management to financial analysis, planning and forecasting, and business statistics. In addition, he edited five popular books, Encyclopedia of Finance (with Alice C. Lee), Handbook of Quantitative Finance and Risk Management (with Alice C. Lee and John Lee), Handbook of Financial Econometrics and Statistics, Handbook of Financial Econometrics, Mathematics, Statistics, and Machine Learning, and Handbook of Investment Analysis, Portfolio Management, and Financial Derivatives. Dr. Lee has also published more than 250 articles in more than 20 different journals in finance, accounting, economics, statistics, and management. Professor Lee was ranked the most published finance professor worldwide during the period 1953-2008.Professor Lee was the intellectual force behind the creation of the new Masters of Quantitative Finance program at Rutgers University. This program began in 2001 and has been ranked as one of the top fifteen quantitative finance programs in the United States. Professor Lee started the Conference on Financial Economics and Accounting in 1989. This conference is a consortium of Rutgers University, New York University, Temple University, University of Maryland, Georgia State University, Tulane University, Indiana University, and University of Toronto. This conference is the most well-known conference in finance and accounting.