IDEAS home Printed from https://ideas.repec.org/p/pra/mprapa/73813.html
   My bibliography  Save this paper

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

Author

Listed:
  • Hatemi-J, Abdulnasser
  • Mustafa, Alan

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.

Suggested Citation

  • Hatemi-J, Abdulnasser & 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," MPRA Paper 73813, University Library of Munich, Germany.
    • Handle: RePEc:pra:mprapa:73813
    as

    Download full text from publisher

    File URL: https://mpra.ub.uni-muenchen.de/73813/3/MPRA_paper_73813.pdf
    File Function: original version
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Abdulnasser Hatemi-J, 2012. "Asymmetric causality tests with an application," Empirical Economics, Springer, vol. 43(1), pages 447-456, August.
    2. Hatemi-J, Abdulnasser, 2013. "A New Asymmetric GARCH Model: Testing, Estimation and Application," MPRA Paper 45170, University Library of Munich, Germany.
    3. Hatemi-J, Abdulnasser, 2014. "Asymmetric generalized impulse responses with an application in finance," Economic Modelling, Elsevier, vol. 36(C), pages 18-22.
    4. Hatemi-J, Abdulnasser, 2020. "Asymmetric Panel Causality Tests with an Application to the Impact of Fiscal Policy on Economic Performance in Scandinavia," Economia Internazionale / International Economics, Camera di Commercio Industria Artigianato Agricoltura di Genova, vol. 73(3), pages 389-404.
    5. Abdulnasser Hatemi-J & Youssef El-Khatib, 2016. "An extension of the asymmetric causality tests for dealing with deterministic trend components," Applied Economics, Taylor & Francis Journals, vol. 48(42), pages 4033-4041, September.
    6. George A. Akerlof, 1970. "The Market for "Lemons": Quality Uncertainty and the Market Mechanism," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 84(3), pages 488-500.
    7. Joseph E. Stiglitz, 1974. "Incentives and Risk Sharing in Sharecropping," The Review of Economic Studies, Review of Economic Studies Ltd, vol. 41(2), pages 219-255.
    8. Abdulnasser Hatemi-J & Alan Mustafa, 2016. "TDICPS: OCTAVE module to Transform an Integrated Variable into Cumulative Partial Sums for Negative and Positive Components with Deterministic Trend Parts," Statistical Software Components OCT001, Boston College Department of Economics.
    9. Michael Spence, 1973. "Job Market Signaling," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 87(3), pages 355-374.
    10. Abdulnasser, Hatemi-J, 2011. "Hidden panel cointegration," MPRA Paper 31604, University Library of Munich, Germany.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Hatemi-J, Abdulnasser, 2020. "Asymmetric Panel Causality Tests with an Application to the Impact of Fiscal Policy on Economic Performance in Scandinavia," Economia Internazionale / International Economics, Camera di Commercio Industria Artigianato Agricoltura di Genova, vol. 73(3), pages 389-404.
    2. Awartani, Basel & Maghyereh, Aktham & Ayton, Julie, 2020. "Oil price changes and industrial output in the MENA region: Nonlinearities and asymmetries," Energy, Elsevier, vol. 196(C).
    3. Clement Olalekan Olaniyi & James Temitope Dada & Nicholas Mbaya Odhiambo & Xuan Vinh Vo, 2023. "Modelling asymmetric structure in the finance-poverty nexus: empirical insights from an emerging market economy," Quality & Quantity: International Journal of Methodology, Springer, vol. 57(1), pages 453-487, February.
    4. Hatemi-J, Abdulnasser & Mustafa, Alan, 2016. "Testing for Financial Market Integration of the Chinese Market with the US Market," MPRA Paper 72733, University Library of Munich, Germany.
    5. Abdulnasser Hatemi-J, 2021. "Dynamic Asymmetric Causality Tests with an Application," Papers 2106.07612, arXiv.org, revised Jun 2021.
    6. Alsamara, Mouyad & Mrabet, Zouhair & Hatemi-J, Abdulnasser, 2020. "Pass-through of import cost into consumer prices and inflation in GCC countries: Evidence from a nonlinear autoregressive distributed lags model," International Review of Economics & Finance, Elsevier, vol. 70(C), pages 89-101.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Hatemi-J, Abdulnasser, 2020. "Asymmetric Panel Causality Tests with an Application to the Impact of Fiscal Policy on Economic Performance in Scandinavia," Economia Internazionale / International Economics, Camera di Commercio Industria Artigianato Agricoltura di Genova, vol. 73(3), pages 389-404.
    2. Abdulnasser Hatemi-J, 2021. "Dynamic Asymmetric Causality Tests with an Application," Papers 2106.07612, arXiv.org, revised Jun 2021.
    3. Nouira, Ridha & Hadj Amor, Thouraya & Rault, Christophe, 2019. "Oil price fluctuations and exchange rate dynamics in the MENA region: Evidence from non-causality-in-variance and asymmetric non-causality tests," The Quarterly Review of Economics and Finance, Elsevier, vol. 73(C), pages 159-171.
    4. Hatemi-J, Abdulnasser, 2014. "Asymmetric generalized impulse responses with an application in finance," Economic Modelling, Elsevier, vol. 36(C), pages 18-22.
    5. Gunay, Samet, 2020. "Seeking causality between liquidity risk and credit risk: TED-OIS spreads and CDS indexes," Research in International Business and Finance, Elsevier, vol. 52(C).
    6. Hatemi-J, Abdulnasser & Mustafa, Alan, 2016. "Testing for Financial Market Integration of the Chinese Market with the US Market," MPRA Paper 72733, University Library of Munich, Germany.
    7. Hatemi-J, Abdulnasser, 2011. "Asymmetric generalized impulse responses and variance decompositions with an application," MPRA Paper 31700, University Library of Munich, Germany.
    8. Debi P Bal & Badri N Rath, 2019. "Nonlinear causality between crude oil price and exchange rate: A comparative study of China and India - A Reassessment," Economics Bulletin, AccessEcon, vol. 39(1), pages 592-604.
    9. repec:eee:labchp:v:2:y:1986:i:c:p:789-848 is not listed on IDEAS
    10. Awartani, Basel & Maghyereh, Aktham & Ayton, Julie, 2020. "Oil price changes and industrial output in the MENA region: Nonlinearities and asymmetries," Energy, Elsevier, vol. 196(C).
    11. Storchevoy, Maxim A., 2010. "A general theory of the firm: From Knight to relationship marketing," Working Papers 765, Graduate School of Management, St. Petersburg State University.
    12. Abdulnasser Hatemi-J & Abdulrahman Al Shayeb & Eduardo Roca, 2017. "The effect of oil prices on stock prices: fresh evidence from asymmetric causality tests," Applied Economics, Taylor & Francis Journals, vol. 49(16), pages 1584-1592, April.
    13. Veli Yilanci & Onder Ozgur & Muhammed Sehid Gorus, 2021. "Stock prices and economic activity nexus in OECD countries: new evidence from an asymmetric panel Granger causality test in the frequency domain," Financial Innovation, Springer;Southwestern University of Finance and Economics, vol. 7(1), pages 1-22, December.
    14. Clement Olalekan Olaniyi, 2020. "Application of Bootstrap Simulation and Asymmetric Causal Approach to Fiscal Deficit-Inflation Nexus," Global Journal of Emerging Market Economies, Emerging Markets Forum, vol. 12(2), pages 123-140, May.
    15. Hatemi-J, Abdulnasser, 2019. "The Causal Impact of Stock Market Development on Economic Development in the UAE: An Asymmetric Approach," Economia Internazionale / International Economics, Camera di Commercio Industria Artigianato Agricoltura di Genova, vol. 72(2), pages 171-184.
    16. Xiaojuan He & Dervis Kirikkaleli & Melike Torun & Zecheng Li, 2021. "Modeling Economic Risk in the QISMUT Countries: Evidence From Nonlinear Cointegration Tests," SAGE Open, , vol. 11(4), pages 21582440211, October.
    17. Joseph E. Stiglitz, 2017. "The Revolution of Information Economics: The Past and the Future," NBER Working Papers 23780, National Bureau of Economic Research, Inc.
    18. Guochen Pan & Jingyan Guo & Qiaoling Jing, 2016. "The Relationship between Insurance Industry and Banking Sector in China: Asymmetric Granger Causality Test," Journal for Economic Forecasting, Institute for Economic Forecasting, vol. 0(2), pages 114-127, June.
    19. Clement Olalekan Olaniyi & Olaolu Richard Olayeni, 2020. "A new perspective into the relationship between CEO pay and firm performance: evidence from Nigeria’s listed firms," Journal of Social and Economic Development, Springer;Institute for Social and Economic Change, vol. 22(2), pages 250-277, December.
    20. Abdulnasser Hatemi‐J & Chi‐Chuan Lee & Chien‐Chiang Lee & Rangan Gupta, 2019. "Insurance activity and economic performance: Fresh evidence from asymmetric panel causality tests," International Finance, Wiley Blackwell, vol. 22(2), pages 221-240, August.
    21. David Mhlanga, 2021. "Financial Inclusion in Emerging Economies: The Application of Machine Learning and Artificial Intelligence in Credit Risk Assessment," IJFS, MDPI, vol. 9(3), pages 1-16, July.

    More about this item

    Keywords

    VBA; Software Component; Asymmetry; Causality; Impulses; The US.;
    All these keywords.

    JEL classification:

    • C6 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling
    • C60 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - General
    • G0 - Financial Economics - - General
    • G00 - Financial Economics - - General - - - General

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:pra:mprapa:73813. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Joachim Winter (email available below). General contact details of provider: https://edirc.repec.org/data/vfmunde.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.