Time Series and Cross Sectional Data

In investment analysis, we observe two types of data, namely, time-series data and cross-sectional data.

Time-series data refers to observations made over a period of time at regular intervals. For example, when we take daily closing prices of a stock for 1 year, it is time-series data. The time unit of observation could be anything such as day, week, month, or year.

Note that time-series data contains observations on a single phenomenon (prices of one stock) over multiple periods of time.

Cross-sectional data on the other hand, contains observations on multiple phenomena observed at a single point of time. For example, closing price of 100 stocks at the end of a year.

The following tables illustrate the difference.

Time Series Data

DayClosing Stock Price of Stock A
1.
2.
3.
4.
5.

Cross Sectional Data

Closing Stock PriceStock AStock BStock CStock DStock E
Dec 31, 2013.....

As you can see, both time-series data and cross-sectioned data are one-dimensional.

We can combine time-series and cross-sectional data to form two-dimensional data sets.

Panel Data

Observations on multiple phenomena over multiple time periods are called panel data. The following table shows closing price of 5 stocks for years. This is an example of panel data. Note that it contains multi-period data (5 years) of a single characteristic (closing price) of multiple entities (5 different stocks).

Closing Stock PriceStock AStock BStock CStock DStock E
Year 1.....
Year 2.....
Year 3.....
Year 4.....
Year 5.....

Longitudinal

We can also have a data set that contains multi-period data (say 5 years) of multiple characteristics (say closing price, P/E ratio, and Market cap) of a single entity (Say a single stock – Stock A).

Stock AClosing PriceP/E RatioMarket Cap
Year 1...
Year 2...
Year 3...
Year 4...
Year 5...

Related Downloads

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.