Web page for Analysis of
Financial Time Series, Second Edition
(Ruey S. Tsay,
Wiley-Interscience 2005, Probability and Statistics)
ISBN 0-471-69074-0
This page contains data sets used and other
information about the book.
Most data files are different from those of the
first edition.
You may find the book on Amazon, Barnes and Noble, and Wiley.
Software
packages used in the book:
SCA (Scientific Computing Associates),
S-Plus with FinMetrics
(Insightful)
RATS
(Regression Analysis of Time Series),
and
R with RMetrics (newer version is
recommended.)
Instructions
and some demonstrations for using R and S-Plus
can be found in my
teaching web: R-demo
Errata of the book.
Solutions to
exercises are available for instructors who use
the book as a textbook.
Please send request to Jackie
Palmieri of
Wiley via e-mail at jpalmier@wiley.com or via mail at
Ms Jackie Palmieri
MS 8-01
John Wiley & Sons, Inc.
111 River
Street
Hoboken, NJ 07030-5774
U.S.A.
Chapter 1: Financial Time Series and Their
Characteristics
Data used in the text:
(1) Daily simple returns of IBM, VW, EW, SP
(7/3/62-12/31/03):
(Format: date, IBM, VW, EW
& SP): d-ibmvwewsp6203.txt
(2) Daily simple returns of
Intel stock (12/15/72-12/31/03): d-intc7303.txt
(3) Daily simple returns of 3M
stock: d-3m6203.txt
(4) Daily simple returns of Microsoft stock: d-msft8603.txt
(5) Daily simple returns of Citi-group
stock: d-c8603.txt
(6) Monthly simple returns of IBM, VW, EW, SP
(1/26-12/03):
(Format: date, IBM, VW, EW, & SP):
m-ibmvwewsp2603.txt
(7) Monthly simple returns of Intel stock: m-intc7303.txt
(8) Monthly simple returns of 3M stock: m-3m4603.txt
(9) Monthly simple returns of Microsoft stock: m-msft8603.txt
(10)
Monthly simple returns of Citi-group stock: m-c8603.txt
(11) Monthly 10-yr and 1-yr Treasury constant maturity rates
(4/53-3/04):
(Format: year, month, date,
rate): m-gs10.txt
& m-gs1.txt
(12) Daily exchange rate between U.S. dollar and Japanese
yen:
(Format: ddmmyy, fx): d-fxjp00.txt
(13) Monthly bond returns (1-12m, 24-36m, 48-60m,
61-120m):
(Format: date, bond returns):
m-fama-bond5203.txt
(14) Monthly 3-yr and 5-yr Treasury constant maturity
rates:
m-gs3.txt
and m-gs5.txt
(15) Weekly Treasury Bill rates: w-tb3ms.dat & w-tb6ms.dat
Data sets for Exercises:
1. Daily simple stock returns of
American Express, Caterpillar,
and Starbucks: d-3stock.txt
2. Monthly simple returns of IBM stock, VW, EW,
and S&P:
m-ibm3dx7503.txt
3. See S&P returns in Problem 2.
4. See American Express stock returns in Problem 1.
5. Exchange rates of Canadian Dollar: d-fxca00.txt
United Kingdom Pound: d-fxuk00.txt,
Japanese Yen: d-fxjp00.txt,
and
Euro: d-fxeu00.txt
versus U.S. Dollar.
Chapter 2: Linear Time Series Analysis and Its Applications
Data sets used in the chapter:
(1) Monthly
IBM stock returns: m-ibm2697.txt
(2) Monthly returns of VW index: m-vw2697.txt
(3) Growth rate of U.S. quarterly real gnp: q-gnp4791.txt
(4) Monthly returns of EW index: (Date, IBM, VW, EW &
SP)
4th column of the file m-ibm3dx2603.txt
(5) Monthly simple returns of 3M stock: m-3m4697.txt
(6) U.S. quarterly GDP: q-gdp4703.txt
(7) Daily values of S&P 500 index: d-sp9003lev.txt
(8) Quarterly earnings of JNJ (1960-1980): q-jnj.txt
(9) Monthly simple returns of Deciles 1, 5, 10: m-decile1510.txt
(10) Weekly 1-yr & 3-yr interest rates: w-gs1n36299.txt
Data sets for
Exercises:
3. Monthly U.S. unemployment rate & help-wanted
ads: m-unemhelp.txt
4. Monthly simple returns of Deciles 1, 5, 10: m-decile1510.txt
5. Daily returns of IBM (Date, IBM, VW, EW & SP): d-ibmvwewsp6202.txt
6. Demand of electricity in logarithm: power6.txt
7. Daily returns of EW: d-ew8099.txt
8 & 9. Daily returns of S&P 500
index: (see text for information)
d-dell3dx0003.txt
10-12. Monthly yields of Moddy's AAA
& BAA seasoned bonds:
m-aaa.txt
and m-baa.txt
13. Monthly returns of EW: m-ew6299.txt
14. Log prices of futures and spot of SP500: sp5may.dat
15. Quarterly GDP implicit price deflator: q-gdpdef.txt
Chapter 3: Conditional Heteroscedastic Models
Data sets used in the text:
(1) Monthly simple
returns of Intel stock: m-intc7303.txt
(2) 10-minute FX log returns (Mark-Dollar): exch-perc.txt
(3) Monthly excess returns of the S&P 500 index: sp500.dat
(4) Monthly returns of IBM stock: m-ibm2697.txt
(5) Daily returns of IBM stock, VW, EW, and SP5: d-ibmvwewsp6203.txt
(6) Monthly log returns of IBM stock and S&P 500 index: m-ibmspln.dat
Data for Example 3.4: m-ibmsplnsu.dat
(7) Daily returns of S&P 500 index: d-sp8099.txt
Data sets for Exercises:
5. Monthly
simple returns of Intel stock: m-intc7303.txt
6. Monthly simple returns of Merck stock: m-mrk4603.txt
7. Monthly simple returns of 3M stock: m-3m4603.txt
8-10. Monthly returns of GM stock & SP500: m-gmsp5003.txt
11-15. Daily returns of GM stock and SP500: d-gmsp9303.txt
Chapter 4: Nonlinear Models and Their Applications
Data sets used in the text:
(1) Monthly U.S.
civilian unemployment rate(48-04): m-unrate.txt
(2) Daily returns of IBM stock in the file: d-ibmvwewsp6203.txt
(3)
Monthly simple returns of 3M stock: m-3m4697.txt
RATS program for smooth TAR: star.rats
(4) Quarterly growth rates of U.S. gnp: q-gnp4791.txt
(5) Weekly 3-month Treasury Bill rates: w-3mtbs7097.txt
(5) Monthly log returns, in percentages, of IBM stock: m-ibmln2699.txt
(6)
Quarterly unemployment rates: q-unemrate.txt
R and S commands for Example 4.7 are in nnet-ibm.sor
Data sets for Exercises:
1. Daily returns of JNJ stock:
d-jnj9003.txt
2,3,5: Monthly returns of GE stock: m-ge2603.txt
6. Weekly U.S. interest rates:
(a) Treasury 1-year constant maturity rates: w-gs1yr.txt
(b) Treasury 3-year constant maturity rates: w-gs3yr.txt
Chapter 5: High-Frequency Data Analysis
and
Market
Microstructure
Data sets 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): ibmdurad.dat
(4)
Adjusted durations in (3) for the first 5 trading
days:
Positive durations only: 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.txt.
(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.txt
4 & 5. Transactions data of 3M (12/99): mmm9912-dtp.txt (large)
6. Adjusted durations of 3M (12/99): mmm9912-adur.txt
7. Trade data of GE stock: taq-t-ge-dec5.txt
Number of trades in 5-minute intervals: taq-ge-dec5-nt.txt
8. 5-minute intraday returns of GE stock: taq-ge-dec5-5m.txt
9. 10-minute intraday returns of GE stock: taq-ge-dec5-10m.txt
10. See problem 5.7.
Chapter 6: Continuous-Time Models
and Their Applications
Data sets used in the text:
(1) Daily simple
returns of IBM stock in 1998: d-ibmy98.txt
(2)
Daily log returns of Cisco stock in 1999: d-cscoy99.txt
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 returns of
IBM stock: d-ibm6298.txt
(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.txt
(4)
Data used in Subsection 7.7.8
(a) Mean-corrected
daily log returns of IBM: d-ibmln98wm.txt
(b) The explanatory variables on page 294: d-ibml25x.txt
Data sets for
Exercises:
1. Daily returns of GE stock: d-ge6299.txt
2 & 3. Daily returns of Cisco stock: d-csco9199.txt
4. Daily returns of HP and 3 indices: d-hwp3dx8099.txt
5, 6, & 7. Daily returns of Alcoa stock and
S&P 500 index: d-aaspx8003.txt
Chapter 8: Multivariate Time Series Analysis and Its Applications
Data sets used in the text:
(1) Monthly returns of
IBM and S&P 500: m-ibmsp2699.txt
log returns: m-ibmspln.txt
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.txt
(3) Monthly U.S. interest rates of Example 8.6: m-gs1n3-5301.txt
SCA commands used: sca-ex8-6.txt
(4) Weekly U.S. interest rates (3-m & 6-m): w-tb3n6ms.txt
(5) Log prices of SP500 index futures and shares: sp5may.dat
Data sets for
Exercises:
1. Monthly returns of MRK et al.: m-mrk2vw.txt
2, 3, & 4. Monthly U.S. interest rates (1 &
10 yrs): m-gs1n10.txt
7. Monthly U.S. interest rates (1-yr & 3-yr): m-gs1n3-5304.txt
Chapter 9:
Principal Component Analysis and Factor Models
Data sets used in the text:
(1) Monthly stock
returns of Table 9.1: m-fac9003.txt
(2) Monthly macroeconomic variables: (CPI &
CE16):
m-cpice16-dp7503.txt
(3) Monthly excess returns of Table 9.2: m-barra-9003.txt
(4) Monthly log returns, in percentages, of IBM, HWP, INTC,
MER & MWD stocks: m-5cln.txt
(5) Monthly returns of U.S. bond indices: m-bnd.txt
(6) Monthly returns of 40 stocks in Table
9.6:
(Company ID, date, return): m-apca0103.txt
Data sets for
Exercises:
1. Monthly returns of stocks and VW index: m-mrk2vw.txt
2 to 6. Monthly simple excess returns: m-excess-c10sp-9003.txt
Chapter 10: Multivariate Volatility Models and Their Applications
Data sets used in the text:
(1) Daily log returns
of HK and Japan market indices (Example 9.1):
Data file (491 data pts): d-hkja.txt
Bivariate GARCH programs: hkja-c.rats and
hkja-c1.rats
(2)
Monthly returns of Pfizer and Merck stocks:
m-pfe6503.txt
and m-mrk6503.txt
(3) Monthly returns of IBM and S&P 500: m-ibmsp2699.txt
Constant-correlation GARCH program: ibmsp-ex92.rats
Time-varying correlation GARCH: ibmsp-ex92q.rats
Cholesky
Decomposition: ibmsp-choles.rats
(4) Daily log returns of S&P 500, Cisco and Intel
stocks:
Data (3 columns): d-spcscointc.txt
Time-varying 3-dim GARCH model: cholesky-ex93.rats
Data sets for
Exercises:
1. Problems 1 to 4: Monthly log returns of S&P 500, IBM
and GE stocks: m-spibmhpq6203.txt
5. Problems 5 to 8: Monthly log returns, in
percentages, of
S&P 500 index, IBM and GE
stocks: m-spibmge.txt
9. Daily log returns of Dell and Cisco stocks: d-dellcsco9099.txt
Chapter 11: State-Space Models and Kalman Filter
Data sets used in the text:
(1) Daily realized
volatility series of Alcoa stock: (5m, 10m,
20m)
aa-3rv.txt
(2) Monthly excess returns of GM stock: see Table
9.1 of Chapter 9.
(3) Quarterly earnings of Johnson and Johnson: see Chapter
2.
Data sets for
Exercises:
2. Realized volatility of Alcoa stock (20m interval):
aa-rv-20m.txt
3. Monthly simple excess returns of Pfizer stock and
S&P 500 index:
m-pfesp-ex9003.txt
Chapter 12: 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.txt
(2)
Change series of weekly US 3-yr interest rate: w-gs3c.txt
(3) Monthly log returns of S&P 500 index: m-sp6299.txt
(4)
Monthly log returns of IBM stock & SP 500: m-ibmspln6299.txt
(5) Monthly log prices of S&P 500 index: m-sp5-6204.txt
(6)
Monthly log returns of GE stock: m-geln.txt
Data sets for
Exercises:
4. Monthly log returns of GM stock and S&P500: m-gmsp5099.txt
5. Daily returns of Cisco stock: d-csco9199.txt
6. Monthly returns of GM stock and S&P 500 index:
See Problem 4.