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

Finance Train Premium
Accelerate your finance career with cutting-edge data skills.
Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.
I WANT TO JOIN
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.

Saylient AI Logo

Accelerate your finance career with cutting-edge data skills.

Join Finance Train Premium for unlimited access to a growing library of ebooks, projects and code examples covering financial modeling, data analysis, data science, machine learning, algorithmic trading strategies, and more applied to real-world finance scenarios.