Email Me | Resume | Home Page | Publications | SAS Code | VB6 Code


Title Miscellaneous Downloads
Miscellaneous Downloads

This section offers some PowerPoint Slides, Word Documents, Excel Spreadsheets, and items not otherwise categorized as SAS Code or VB6 Code. As always, I have to say that these downloads are without warranty and I accept no liability for their use or installation.

Survey of Scoring Techniques

This is an excellent discussion of credit scoring techniques covering topics such as logistic regression, probit regression, neural nets, CART, incorporating economic indictors in models, profitability scoring, and behavior scoring. At the end of the article, the author provides a comprehensive list of references.

Stress Test Simulator in SHAZAM

This is a program written in SHAZAM that estimates a Pooled Cross Section Time Series Model and simulates the result of a change in employment. The example used does not represent real data, but is shown for illustration purposes only.

LifeCast Pro Manual

This is a summary manual for LifeCast Pro for new product forecasting. Even if you are not interested in purchase, the information provided here may prove interesting.

New Product Diffusion Article

This is a good 2004 article about forecasting new product launches using diffusion theory.

LifeCast Pro software update

This is an upgrade to LifeCast Pro software. It requires a previous version to be already loaded on your computer.

The Bass Diffusion Model

This is an Excel file showing you how to develop the Bass model in a spreadsheet. The Bass Model is often used for forecasting a new product or service.

Case Study in New Product Forecasting

This document discusses an approach to new product forecasting using the Bass Diffusion Model and a simulation procedure through Logistic Regression.

Neural Net Primer

If you have a background in regression and want to learn about neural nets, this paper is for you. It gives a discussion of neural nets from an econometrics perspective through a question and answer format. Very useful.

Credit Modeling

This is an informative discussion of credit modeling that serves as a good introduction to different best practices in the industry.

New Product Forecasting Presentation

This is a powerpoint presentation discussing new product forecasting techniques. It was presented at the IBF conference in 2002.

Forecasting Dictionary

Here is a dictionary of forecasting terms that is great for including in documentation and reports.

Reject Inferencing

This is a discussion of a technique often used in credit scoring to enhance model accuracy. The paper serves as a good introduction to the subject.

Reject Inferencing

This paper presents some research that shows reject inferencing is not that bad a problem if you can increase your sample size as is possible in credit card modeling. This is an excellent paper and worth reading with practical implications concerning reject inferencing.

Tobit Alternative: Beta Transform

Here is an Excel spreadsheet showing the transformation process where you can more appropriately apply linear regression. Some say you can use this method where the dependent variable is clustered around upper or lower boundaries. This is seen by some as an alternative to using a Tobit Model. This procedure is used by Moody's to estimate their LOSSCALC recovery model.

Understanding Basel II in Banking

Here is a great summary of the Basel II regulatory requirements that will be imposed on many of the larger banks in the U.S. and worldwide, scheduled to go into effect in 2007. It requires banks to risk rate ALL their loans in order to reduce their capital requirements.

Good paper on Credit Risk

Very good summary of History of Credit Risk - mostly consumer based.

Link to Economic Time Series Data

Good link to Economic data for Modeling - FREE!

SAS Code References for BootStrapping

Link to SAS code for Bootstrapping

ROC Curve Calculations

Here is a method for numerically calculating the area under the ROC curve which is often used to determine the accuarcy of credit scoring models.

Dymnamically Writing SAS Code

Here is a paper that describes how to use SAS to dynamically write out SAS code. I have put example code of this type in my SAS download section, but this paper should give a more detailed discussion of this very important concept.

CART and Logistic Regression

This is a powerpoint presentation on how to integrate logistic regression with C.A.R.T. modeling. Makes sense!

Survival Analysis

This is a good practical discussion of Survival Analysis in SAS.

Survival Analysis

This is another good practical discussion of Survival Analysis in SAS. Focus here is Telecommunications.

PROC QLIM in SAS

SAS has a new procedure called PROC QLIM which can be used for a number of different types of models including discrete choice and Tobit Regression.

Hybrid Modeling Platform

This is a powerpoint presentation describing a modeling platform combining VB6 and SAS. This was presented in St. Pete Florida at the 2003 SEUG conference in September.

Value of Economic Data

This is a paper presented in the RMA Journal on the role of Economic Data and its usefulness in Credit Modeling (by Jiong Liu & Xiaoqing Eleanor Xu).

SHAZAM Double Tobit

This is the programming code, data file, and output for a double sided tobit model in SHAZAM which will match the output from the SAS double sided tobit model using PROC QLIM that can be obtained from my SAS download page.

SHAZAM Examples by Greene

This is a link to SHAZAM programs written to illustrate William Greene's textbook 'Econometric Analysis' published in 2000. Great resource for econometric analytics!

Portfolio Stress Testing

Good article on portfolio stress testing.

Portfolio Stress Testing

Good article on portfolio stress testing.

Portfolio Stress Testing

Using Pooling in Portfolio Stress Testing.

Vintage Analysis and Macroeconomics

Vintage Analysis for Mortgage Loans.

Macroeconomic Modeling

Economic Modeling in Risk Models.

Portfolio Forecasting

This article compares PD modeling vs. Portfolio modeling using economic data.

Loss Forecasting Techniques

This article reviews different loss forecasting techniques such as roll rates, econometrics, vintages.

Overview Of Credit Modeling

This article is a good nontechnical overview of modeling credit data over the entire lifecycle.

Basel II Modeling

This article is a good technical discussion of modeling Basel PD, LGD, EAD and stress testing. I personally do not agree with trying to incorporate economic data directly in those models, but here is another view.

Explaining Basel II & III

Good summary of Basel as of 2011.

Logistic Regression in Excel

You can now do logistic regression in Excel.