Analysis of Financial Time Series
Web page for Analysis of Financial Time Series
(Ruey S. Tsay, Wiley 2002, Financial Engineering)
ISBN 0-471-41544-8
Data sets and commands of computer programs used in the book.
Software packages used in the book:
SCA (Scientific Computing Associates),
RATS (Regression Analysis of Time Series),
and S-Plus and R .
Some free softwares are available at Statlib, including neural networks on S-Plus and the package R.
Errata of the book.
(Some of the errors have been corrected in the new printing.)
Solutions to exercises are available for instructors who use the book as a textbook. [Please see the information in the 2nd edition of the book.]
I have used the book for my MBA course ''Analsis of Financial Time Series." Instructors interested in my lecture notes may contact me directly.
Chapter 1: Financial Time Series and Their Characteristics
Data used in the text:
(1) Daily log returns of IBM (62/7/3 to 97/12): d-ibmln.dat
(2) Daily simple returns of value-weighted and equal-weighted indexes: d-vwew.dat
(3) Daily simple returns of Intel stock: d-intc.dat
(4) Daily simple returns of 3M stock: d-mmm.dat
(5) Daily simple returns of Microsoft stock: d-msft.dat
(6) Daily simple returns of Citi-group stock: d-citi.dat
(7) Monthly bond returns (30 yrs, 20 yrs, ..., 1 yr): m-bnd.dat
(8) Monthly Treasury rates (10 yrs, 5 yrs, ..., 1 yr): m-gs.dat
(9) Weekly Treasury Bill rates: w-tb3ms.dat & w-tb6ms.dat
Data sets for Exercises:
1. Log returns of Alcoa stock: d-aa9099.dat
Log returns of American Express stock: d-axp9099.dat
Log returns of Disney stock: d-dis9099.dat
Log returns of Chicago Tribune stock: d-trb9099.dat
Log returns of Tyco International stock: d-tyc9099.dat
2. Monthly log stock returns of five U.S. companies:
Alcoa: m-aa6299.dat
American Express: m-axp7399.dat
Disney: m-dis6299.dat
General Motors: m-gm6299.dat
Hershey Foods: m-hsy6299.dat
Mellon Financial Co.: m-mel7399.dat
3. See Alcoa stock returns in Problem 2.
4. See American Express stock returns in Problem 2.
5. See American Express stock returns in Problem 1.
6. Exchange rates of Canadian Dollar, German Mark, United Kingdom Pound, Japanese Yen, andFrench Franc versus U.S. Dollar: forex-c.dat
Chapter 2: Linear Time Series Analysis and Its Applications
Data sets used in the chapter:
(1) U.S. quarterly growth rates of GNP: q-gnp.dat
(2) Monthly value-weighted index returns: m-vw.dat
(3) Monthly equal-weighted index returns: m-ew.dat
(4) Monthly log returns of 3M stock: m-3m4699.dat
(5) Quarterly earnings per share of Johnson & Johnson: jnj.dat
(6) Weekly U.S. Treasury 1-y and 3-y constant maturity rates:
w-gs1yr.dat and w-gs3yr.dat
Data sets for Exercises:
3. Simple returns on monthly U.S. bonds: m-bnd.dat
4. Daily log returns of Alcoa stock: d-aa9099.dat
5. Daily log returns of Hewlett-Packard, value-weighted,
equal-weighted and SP500 index: d-hwp3dx8099.dat
6. Monthly log returns of equal-weighted index: m-ew6299.dat
7. See Problem 5.
8. Daily log returns of equal-weighted index: see Problem 5.
Calendar of 1980 on (yr,mm,dd,date): day80on.dat
Dummy variables (M,T,W,R,yr,mm,dd,days): wkdays8099.dat
9. Log prices of futures and spot of SP500: sp5may.dat
10. U.S. quarterly unemployment rates: q-unemrate.dat
11. Quarterly GDP implicit price deflator: gdpipd.dat
Chapter 3: Conditional Heteroscedastic Models
Data sets used in the text:
(1) Monthly simple returns of Intel stock:m-intc.dat
RATS program for an ARCH(3) model: m-intc.rats
(2) 10-m log returns of FX (Mark-US): exch-perc.dat
(3) Excess returns of S&P500: sp500.dat
RATS programs for various volatility models:
(a) AR(3)-GARCH(1,1): m-sp-ar-garch11.rats
(b) GARCH(1,1): m-sp-garch11.rats
(c) GARCH(1,1) with t_5: t5-garch11.rats
(d) GARCH(1,1) with t: garch11-t.rats
(e) IGARCH(1,1): m-sp-igarch.rats
(f) GARCH(1,1)-M model: m-sp-garchm.rats
(g) CHARMA model: sp-charma.rats
(4) Monthly log returns of IBM stock: m-ibmln.dat
RATS program for EGARCH(1,0): ibm-egarch10.rats
(5) Daily log returns of SP500 index: see d-hwp3dx8099.dat
in Chapter 2.
(6) Monthly log returns of IBM stock & SP500: m-ibmspln.dat
Data set for Example 3.5: m-ibmsplnsu.dat
RATS program without summer effect: summer.rats
RATS program with summer effect: summer1.rats
RATS program for Example 3.6: charmax.rats
Data sets for exercises:
5. Monthly log returns of Intel stock: m-intc.dat
6. Monthly simple returns of Merck stock: m-mrk.dat
(The file contains the simple returns in Column 1.
The sample period is from 1946/6 to 1999/12.)
7. Monthly simple returns of 3M stock: m-mmm.dat
8. Monthly log returns of GM stock & Sp500: m-gmsp5099.dat
9. See problem 8.
10. Daily log returns of IBM stock: d-ibmln.dat
Chapter 4: Nonlinear Models and Their Applications
Data sets used in the text:
(1) Monthly simple returns of equal-weighted index: m-ew.dat
(2) Daily log returns of IBM stock: d-ibmln99.dat
RATS program for TAR-GARCH model: ibm-ar-tar.rats
(3) Monthly simple returns of 3M stock: m-mmm.dat
RATS program for smooth TAR: star.rats
(4) Quarterly growth rates of U.S. gnp: q-gnp.dat
(5) Monthly log returns of IBM stock: m-ibmln99.dat
(6) Quarterly unemployment rates: q-unemrate.dat
To run neural networks on S-Plus or R, visit the Modapplstat at the
S-Archive on Statlib for free software
R and S commands for Example 4.5 are in nnet-ibm.sor and the
data set is m-ibmln99.dat.
Data sets for exercises:
1. Monthly log returns of GE stock: m-ge2699.dat
5. Weekly U.S. interest rates:
(a) Treasury 1-year constant maturity rates: wgs1yr.dat
(b) Treasury 3-year constant maturity rates: wgs3yr.dat
Chapter 5: High-Frequency Data Analysis and Market Microstructure
Data stes used in the text:
(1) IBM transactions data (11/1/90-1/31/91): The columns
are date/time, volume, bid quote, ask quote, and
transaction price: ibm.txt (large)
(2) IBM transactions data of December 1999.
(day. time, price): ibm9912-tp.dat (large)
(3) Adjusted time durations between trades (11/01/90-
1/31/91). Positive durations only: ibmdurad.dat
(4) Adjusted durations in (3) for the first 5 trading days:
ibm1to5-dur.dat
(5) Data for Example 5.2 (files are relatively large)
(a) The ADS file: ibm91-ads.dat
(b) The explanatory variables as defined: ibm91-adsx.dat
(6) Transactions data of IBM stock on November 21, 1990
(a) original data: day15-ori.dat
(b) data for PCD models: day15.dat
data descriptions in file day15.txt
RATS programs for estimating duration models:
The data file used is ibm1to5-dur.dat.
(a) EACD model: eacd.rats
(b) WACD model: wacd.rats
(c) GACD model: gacd.rats
(d) Threshold-WACD model: tar-wacd.rats.
Data sets for exercises:
3. Adjusted durations of IBM stock (11/2/90): ibm-d2-dur.dat
5. Transactions data of 3M (12/99): mmm9912-dtp.dat (large)
6. Adjusted durations of 3M (12/99): mmm9912-adur.dat
Chapter 6: Continuous-Time Models and Their Applications
Data sets used in the text:
(1) Daily simple returns of IBM stock in 1998: ibmy98.dat
(2) Daily log returns of Cisco stock in 1999: d-cscoy99ln.dat
Source code of a Fortran program for European call and put options based on the simple jump diffusion model discussed in the text: kou.f (You need to compile the program.)
Chapter 7: Extreme Values, Quantile Estimation, and Value at Risk
Data sets used in the text:
(1) Daily log returns of IBM stock: d-ibmln98.dat (9190 obs)
The returns are in percentages.
(2) RATS programs used in Example 7.3:
(Note: returns used in the example are not in percentages.)
(a) AR(2)-GARCH(1,1): example7-3a.rats
(b) AR(2)-GARCH(1,1)-t5: example7-3b.rats
(3) Daily log returns of Intel stock (Example 7.4): d-intc7297.dat
(4) Data used in Subsection 7.7.6
(a) Mean-corrected daily log returns of IBM: ibmln98wm.dat
(b) The explanatory variables on page 294: ibml25x.dat
Data sets for exercises:
1. Daily log returns (in percentages) of GE stock: d-geln.dat
2. Daily log returns (in percentages) of Cisco stock: d-csco9199.dat
3. See problem 2.
4. Daily log returns of HP and 3 indexes: d-hwp3dx8099.dat
Chapter 8: Multivariate Time Series Analysis and Its Applications
Data sets used in the text:
(1) Monthly log returns of IBM and SP 500: m-ibmspln.dat
The SCA commands used to analyze the series: sca-ex-ch8.txt
Source code of a Fortran program for multivariate Q-stat: qstat.f
(2) Monthly simple returns of bond indexes: m-bnd.dat
(3) Monthly U.S. interest rates of Example 8.6: m-gs1n3.dat
SCA commands used: sca-ex8-6.txt
(4) Log prices of SP500 index futures and shares: sp5may.dat
(5) Monthly log returns of IBM, HWP, INTC, MER & MWD: m-5cln.dat
Data sets for exercises:
1. Monthly log returns of MRK et al.: m-mrk2vw.dat
2. Monthly U.S. interest rates (1 & 10 yrs): m-gs1n10.dat
3. See problem 2.
4. See problem 2.
Chapter 9: Multivariate Volatility Models and Their Applications
Data sets used in the text:
(1) Daily log returns of HK and Japan market index (Example 9.1):
Data file (491 data pts): hkja.dat
Bivariate GARCH programs: hkja-c.rats and hkja-c1.rats
(2) Monthly log returns of IBM and SP 500: m-ibmspln.dat
Constant-correlation GARCH program: ibmsp-ex92.rats
Time-varying correlation GARCH: ibmsp-ex92q.rats
Cholesky Decomposition: ibmsp-choles.rats
(3) Daily log returns of S&P 500, Cisco and Intel stocks:
Data (3 columns): d-cscointc.dat
Time-varying 3-dim GARCH model: cholesky-ex93.rats
Data sets for exercises:
1. Problems 1 to 5: Monthly log returns of S&P 500, IBM
and GE stocks: m-spibmge.dat
6. Daily log returns of Dell and Cisco stocks: d-dellcsco9099.dat
Chapter 10: Markov Chain Monte Carlo Methods with Applications
Data sets used in the text:
(1) Change series of weekly US interest rates (3-y & 1-y):
w-gs3n1c.dat
(2) Change series of weekly US 3-yr interest rate: w-gs3c.dat
(3) Monthly log returns of S&P 500 index: m-sp6299.dat
(4) Monthly log returns of IBM stock & SP 500: m-ibmsp6299.dat
(5) Monthly log returns of GE stock: m-geln.dat
Data sets for exercises:
4. Monthly log returns of GM stock & SP500: m-gmsp5099.dat
5. Daily log returns of Cisco stock: d-csco9199.dat
6. See Problem 4.