Brief Stock Market Time Series Data Analysis

The purpose of this blog is to show the application possibilities of SAP Lumira regarding a brief time series data analysis of stock market data.

Basically, I picked several companies that are traded on the NYSE and gathered their historical data, such as opening price, closing price, adj. price, traded volume, market capitalization and so on. Once the data was gathered, I decided to take a closer look on the performance of the closing prices of these corporations over ten years for my first data analysis with Lumira.

As soon as I had my .csv files merged into Lumira and prepared for the analysis, I started to assign the necessary key figures. Once I had the closing prices and the corresponding dates, I was ready to start. The graphics could be easily created by applying the closing prices to the y-axis and the date to the x-axis.

3M – MMM (2003 – 2013) Closing Price Time Series

AXP – American Express (2003 – 2013) Closing Price Time Series

BA – Boeing Company (2003 – 2013) Closing Price Time Series

CAT- Caterpillar (2003 – 2013) Closing Price Time Series

CSCO – Cisco Systems (2003 – 2013) Closing Price Time Series

CVX – Chevron (2003 – 2013) Closing Price Time Series

DD – du Pont de Nemours (2003 – 2013) Closing Price Time Series

GE – General Electric (2003 – 2013) Closing Price Time Series

GS – Goldman Sachs Group (2003 – 2013) Closing Price Time Series

KO – Coca Cola (2003 – 2013) Closing Price Time Series

PG – Procter & Gamble (2003 – 2013) Closing Price Time Series

SAP – SAP (2003 – 2013) Closing Price Time Series

Moreover, I was curious how each share performed in comparison to the others. Therefore, I created a time series analysis that took all available closing prices into account.

Total Performance 2007 – 2013

Furthermore I wanted to compare the performance of each share in between the year 2007 and 2009 (before / after the subprime crisis & Lehman) and also particularly in the year 2008.

Total Performance 2007 – 2009

Total Performance 2008

It was obvious that in fall 2008 (25^th of September – exactly one week after Lehman filed chapter 11 / bankruptcy) the closing prices of almost each share in the comparison began to drop heavily.

Performance Drop  2008

Although a similar analysis can be created with common computing tools, I found it quite interesting to make my first steps with Lumira and to explore the software’s functionalities.

Have a nice day and thank you for reading 🙂