Product details

By continuing to use our site you consent to the use of cookies as described in our privacy policy unless you have disabled them.
You can change your cookie settings at any time but parts of our site will not function correctly without them.
Compact case
Authors: Renaud Beaupain (IESEG School of Management); Nicolas Eugster (IESEG School of Management)
Originally published in: 2019
Version: 5-Jun-2019
Revision date: 18-Jun-2019

Abstract

This case suggests a method to automate the conversion of time series data from Thomson Reuters Datastream to a vertical dataset using Excel functions or VBA. Indeed, Thomson Reuters Datastream presents time series data vertically for the time, but horizontally, company-per-company, for the other variables. Presented in this way, it is not possible to directly export and use the dataset in statistical software. The dataset must be first vertically converted to be utilized, that is, each identical variable must be in a single column. The case uses the example of a panel regression of the return on equity on two explanatory variables for the period 2008-2018.

Teaching and learning

This item is suitable for undergraduate, postgraduate and executive education courses.

Geographical setting

Region:
World/global
Country:
United States

Featured companies

Apple Inc
Microsoft
IBM

About

Abstract

This case suggests a method to automate the conversion of time series data from Thomson Reuters Datastream to a vertical dataset using Excel functions or VBA. Indeed, Thomson Reuters Datastream presents time series data vertically for the time, but horizontally, company-per-company, for the other variables. Presented in this way, it is not possible to directly export and use the dataset in statistical software. The dataset must be first vertically converted to be utilized, that is, each identical variable must be in a single column. The case uses the example of a panel regression of the return on equity on two explanatory variables for the period 2008-2018.

Teaching and learning

This item is suitable for undergraduate, postgraduate and executive education courses.

Settings

Geographical setting

Region:
World/global
Country:
United States

Featured companies

Apple Inc
Microsoft
IBM

Related