Munich Personal RePEc Archive

A MS-Excel Module to Transform an Integrated Variable into Cumulative Partial Sums for Negative and Positive Components with and without Deterministic Trend Parts.

Hatemi-J, Abdulnasser and Mustafa, Alan (2016): A MS-Excel Module to Transform an Integrated Variable into Cumulative Partial Sums for Negative and Positive Components with and without Deterministic Trend Parts.

This is the latest version of this item.

[img]
Preview
PDF
MPRA_paper_73813.pdf

Download (1MB) | Preview

Abstract

Our aim is to describe how a software component called TDICPS can be used. TDICPS is a MS-Excel module developed in VBA (visual basics for applications) by the authors that transforms an integrated variable into cumulative partial sums for positive and negative components along with graphs for a potential sample size of more than one million observations. Several options are available. The variable might have both drift and trend, only drift or no deterministic trend parts. We demonstrate step by step how the stock price index of the US market can be transformed into partial components for positive and negative changes. Any other variable can also be transformed in a similar way. The transformed data can be used for implementing the asymmetric causality tests as developed by Hatemi-J (2012). It can also be used for estimating the asymmetric generalized impulse response functions and the asymmetric variance decompositions as introduced by Hatemi-J (2014). Other options are also possible. The MS-Excel code is available by e-mail from the authors.

Available Versions of this Item

  • A MS-Excel Module to Transform an Integrated Variable into Cumulative Partial Sums for Negative and Positive Components with and without Deterministic Trend Parts. (deposited 20 Sep 2016 17:03) [Currently Displayed]
UB_LMU-Logo
MPRA is a RePEc service hosted by
the Munich University Library in Germany.