Skip to main content

Analysis of Financial Time Series 2nd Edition

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 AmazonBarnes 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). 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 relativelylarge)
(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 codeof aFortranprogram 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 aFortranprogram 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.