IDEAS home Printed from https://ideas.repec.org/p/zbw/safewp/300.html
   My bibliography  Save this paper

An extensible model for historical financial data with an application to German company and stock market data

Author

Listed:
  • Gram, Dennis
  • Karapanagiotis, Pantelis
  • Krzyzanowski, Jan
  • Liebald, Marius
  • Walz, Uwe

Abstract

Broad, long-term financial and economic datasets are a scarce resource, in particular in the European context. In this paper, we present an approach for an extensible, i.e. adaptable to future changes in technologies and sources, data model that may constitute a basis for digitized and structured longterm, historical datasets. The data model covers specific peculiarities of historical financial and economic data and is flexible enough to reach out for data of different types (quantitative as well as qualitative) from different historical sources, hence achieving extensibility. Furthermore, based on historical German company and stock market data, we discuss a relational implementation of this approach.

Suggested Citation

  • Gram, Dennis & Karapanagiotis, Pantelis & Krzyzanowski, Jan & Liebald, Marius & Walz, Uwe, 2021. "An extensible model for historical financial data with an application to German company and stock market data," SAFE Working Paper Series 300, Leibniz Institute for Financial Research SAFE.
    • Handle: RePEc:zbw:safewp:300
    DOI: 10.2139/ssrn.3770607
    as

    Download full text from publisher

    File URL: https://www.econstor.eu/bitstream/10419/229429/1/174740165X.pdf
    Download Restriction: no
    File URL: https://libkey.io/10.2139/ssrn.3770607?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. Òscar Jordà & Moritz Schularick & Alan M. Taylor, 2017. "Macrofinancial History and the New Business Cycle Facts," NBER Macroeconomics Annual, University of Chicago Press, vol. 31(1), pages 213-263.
    2. Björn Richter & Moritz Schularick & Paul Wachtel, 2021. "When to Lean against the Wind," Journal of Money, Credit and Banking, Blackwell Publishing, vol. 53(1), pages 5-39, February.
    3. Wouter Van Overfelt & Marc Deloof & Ann Vanstraelen, 2010. "Determinants of Corporate Financial Disclosure in an Unregulated Environment: Evidence from the Early 20th Century," European Accounting Review, Taylor & Francis Journals, vol. 19(1), pages 7-34.
    4. Fabian Waldinger, 2016. "Bombs, Brains, and Science: The Role of Human and Physical Capital for the Creation of Scientific Knowledge," The Review of Economics and Statistics, MIT Press, vol. 98(5), pages 811-831, December.
    5. Asaf Bernstein & Eric Hughson & Marc D. Weidenmier, 2014. "Counterparty Risk and the Establishment of the New York Stock Exchange Clearinghouse," NBER Working Papers 20459, National Bureau of Economic Research, Inc.
    6. Jan Annaert & Frans Buelens & Marc Deloof, 2015. "Long-run stock returns: evidence from Belgium 1838–2010," Cliometrica, Journal of Historical Economics and Econometric History, Association Française de Cliométrie (AFC), vol. 9(1), pages 77-95, January.
    7. Anderson, Heather M. & Dungey, Mardi & Osborn, Denise R. & Vahid, Farshid, 2011. "Financial integration and the construction of historical financial data for the Euro Area," Economic Modelling, Elsevier, vol. 28(4), pages 1498-1509, July.
    8. Òscar Jordà & Katharina Knoll & Dmitry Kuvshinov & Moritz Schularick & Alan M Taylor, 2019. "The Rate of Return on Everything, 1870–2015," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 134(3), pages 1225-1298.
    9. Jérémie Ducros & Elisa Grandi & Raphaël Hékimian & Emmanuel Prunaux & Angelo Riva & Stefano Ungaro, 2018. "Collecting and storing historical financial data : the DFIH project," PSE-Ecole d'économie de Paris (Postprint) halshs-01884372, HAL.
    10. D. Acemoglu & J. Robinson, 2013. "Economics versus politics: pitfalls of policy advice," Voprosy Ekonomiki, NP Voprosy Ekonomiki, issue 12.
    11. Petra Moser & Alessandra Voena & Fabian Waldinger, 2014. "German Jewish ?migr?s and US Invention," American Economic Review, American Economic Association, vol. 104(10), pages 3222-3255, October.
    12. Fabio Braggion & Lyndon Moore, 2011. "Dividend Policies in an Unregulated Market: The London Stock Exchange, 1895--1905," The Review of Financial Studies, Society for Financial Studies, vol. 24(9), pages 2935-2973.
    13. Jon Danielsson & Marcela Valenzuela & Ilknur Zer, 2018. "Learning from History: Volatility and Financial Crises," The Review of Financial Studies, Society for Financial Studies, vol. 31(7), pages 2774-2805.
    14. Schlag, Christian & Wodrich, Anja, 2000. "Has there always been underpricing and long-run underperformance? IPOs in Germany before World War I," CFS Working Paper Series 2000/12, Center for Financial Studies (CFS).
    15. Moortgat, Leentje & Annaert, Jan & Deloof, Marc, 2017. "Investor protection, taxation and dividend policy: Long-run evidence, 1838–2012," Journal of Banking & Finance, Elsevier, vol. 85(C), pages 113-131.
    16. Philippe Jorion & William N. Goetzmann, 1999. "Global Stock Markets in the Twentieth Century," Journal of Finance, American Finance Association, vol. 54(3), pages 953-980, June.
    17. Calomiris, Charles W. & Mason, Joseph R. & Weidenmier, Marc & Bobroff, Katherine, 2013. "The effects of reconstruction finance corporation assistance on Michigan's banks' survival in the 1930s," Explorations in Economic History, Elsevier, vol. 50(4), pages 526-547.
    18. Asaf Bernstein & Eric Hughson & Marc Weidenmier, 2019. "Counterparty Risk and the Establishment of the New York Stock Exchange Clearinghouse," Journal of Political Economy, University of Chicago Press, vol. 127(2), pages 689-729.
    19. Barton, Jan & Waymire, Gregory, 2004. "Investor protection under unregulated financial reporting," Journal of Accounting and Economics, Elsevier, vol. 38(1), pages 65-116, December.
    20. Ryan Lampe & Petra Moser, 2016. "Patent Pools, Competition, and Innovation—Evidence from 20 US Industries under the New Deal," The Journal of Law, Economics, and Organization, Oxford University Press, vol. 32(1), pages 1-36.
    21. Annaert Jan & Buelens Frans & Angelo Riva, 2016. "Financial History Databases: Old Data, Old Issues, New Insights?," Post-Print halshs-01509708, HAL.
    22. Mehra, Rajnish & Prescott, Edward C., 1985. "The equity premium: A puzzle," Journal of Monetary Economics, Elsevier, vol. 15(2), pages 145-161, March.
    23. Thomas Gehrig & Caroline Fohlin, 2006. "Trading Costs in Early Securities Markets: The Case of the Berlin Stock Exchange 1880–1910," Review of Finance, European Finance Association, vol. 10(4), pages 587-612, December.
    24. Alessandro Iaria & Carlo Schwarz & Fabian Waldinger, 2018. "Frontier Knowledge and Scientific Production: Evidence from the Collapse of International Science," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 133(2), pages 927-991.
    25. Brock, William & Lakonishok, Josef & LeBaron, Blake, 1992. "Simple Technical Trading Rules and the Stochastic Properties of Stock Returns," Journal of Finance, American Finance Association, vol. 47(5), pages 1731-1764, December.
    26. Goetzmann, William N. & Ibbotson, Roger G. & Peng, Liang, 2001. "A new historical database for the NYSE 1815 to 1925: Performance and predictability," Journal of Financial Markets, Elsevier, vol. 4(1), pages 1-32, January.
    27. Carmen M. Reinhart & Kenneth S. Rogoff, 2011. "From Financial Crash to Debt Crisis," American Economic Review, American Economic Association, vol. 101(5), pages 1676-1706, August.
    28. Goetzmann, William N. & Huang, Simon, 2018. "Momentum in Imperial Russia," Journal of Financial Economics, Elsevier, vol. 130(3), pages 579-591.
    29. John D. Turner & Qing Ye & Wenwen Zhan, 2013. "Why Do Firms Pay Dividends?: Evidence from an Early and Unregulated Capital Market," Review of Finance, European Finance Association, vol. 17(5), pages 1787-1826.
    30. Piet Eichholtz & Matthijs Korevaar & Thies Lindenthal & Ronan Tallec & Stijn Van Nieuwerburgh, 2021. "The Total Return and Risk to Residential Real Estate [House prices and fundamentals: 355 years of evidence]," The Review of Financial Studies, Society for Financial Studies, vol. 34(8), pages 3608-3646.
    Full references (including those not matched with items on IDEAS)

    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. Turner, John D., 2014. "Financial history and financial economics," QUCEH Working Paper Series 14-03, Queen's University Belfast, Queen's University Centre for Economic History.
    2. Xavier De Scheemaekere & Kim Oosterlinck & Ariane Szafarz, 2012. "Addressing Economic Crises: The Reference-Class Problem," Working Papers CEB 12-024, ULB -- Universite Libre de Bruxelles.
    3. Baltussen, Guido & Swinkels, Laurens & Van Vliet, Pim, 2021. "Global factor premiums," Journal of Financial Economics, Elsevier, vol. 142(3), pages 1128-1154.
    4. Bai, Hang & Zhang, Lu, 2022. "Searching for the equity premium," Journal of Financial Economics, Elsevier, vol. 143(2), pages 897-926.
    5. Mathias Klein & Roland Winkler, 2021. "The government spending multiplier at the zero lower bound: International evidence from historical data," Journal of Applied Econometrics, John Wiley & Sons, Ltd., vol. 36(6), pages 744-759, September.
    6. Casabianca, Elizabeth Jane & Catalano, Michele & Forni, Lorenzo & Giarda, Elena & Passeri, Simone, 2022. "A machine learning approach to rank the determinants of banking crises over time and across countries," Journal of International Money and Finance, Elsevier, vol. 129(C).
    7. Xavier De Scheemaekere & Kim Oosterlinck & Ariane Szafarz, 2014. "Issues in Identifying Economic Crises: Insights from History," Working Papers CEB 14-014, ULB -- Universite Libre de Bruxelles.
    8. le Bris, David & Goetzmann, William N. & Pouget, Sébastien, 2019. "The present value relation over six centuries: The case of the Bazacle company," Journal of Financial Economics, Elsevier, vol. 132(1), pages 248-265.
    9. Moortgat, Leentje & Annaert, Jan & Deloof, Marc, 2017. "Investor protection, taxation and dividend policy: Long-run evidence, 1838–2012," Journal of Banking & Finance, Elsevier, vol. 85(C), pages 113-131.
    10. Stephan Schulmeister, 2000. "Technical Analysis and Exchange Rate Dynamics," WIFO Studies, WIFO, number 25857, April.
    11. Del Negro, Marco & Giannone, Domenico & Giannoni, Marc P. & Tambalotti, Andrea, 2019. "Global trends in interest rates," Journal of International Economics, Elsevier, vol. 118(C), pages 248-262.
    12. Prat, Georges, 2013. "Equity risk premium and time horizon: What do the U.S. secular data say?," Economic Modelling, Elsevier, vol. 34(C), pages 76-88.
    13. Andy Lardon & Marc Deloof, 2014. "Financial disclosure by SMEs listed on a semi-regulated market: evidence from the Euronext Free Market," Small Business Economics, Springer, vol. 42(2), pages 361-385, February.
    14. Rozite, Kristiana & Bezemer, Dirk J. & Jacobs, Jan P.A.M., 2019. "Towards a financial cycle for the U.S., 1973–2014," The North American Journal of Economics and Finance, Elsevier, vol. 50(C).
    15. Gorodnichenko, Yuriy & Pham, Tho & Talavera, Oleksandr, 2021. "Conference presentations and academic publishing," Economic Modelling, Elsevier, vol. 95(C), pages 228-254.
    16. Laura Hueber & Rene Schwaiger, 2021. "Debiasing Through Experience Sampling: The Case of Myopic Loss Aversion," Working Papers 2021-01, Faculty of Economics and Statistics, Universität Innsbruck.
    17. Robert J. Barro, 2006. "Rare Disasters and Asset Markets in the Twentieth Century," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 121(3), pages 823-866.
    18. LeBaron, Blake, 2000. "Agent-based computational finance: Suggested readings and early research," Journal of Economic Dynamics and Control, Elsevier, vol. 24(5-7), pages 679-702, June.
    19. Wonnho Choi, 2014. "Habit Formation and Risk-free Rate Puzzle," International Journal of Financial Research, International Journal of Financial Research, Sciedu Press, vol. 5(4), pages 155-170, October.
    20. Josefin Meyer & Carmen M Reinhart & Christoph Trebesch, 2022. "Sovereign Bonds Since Waterloo," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 137(3), pages 1615-1680.

    More about this item

    JEL classification:

    • C81 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Methodology for Collecting, Estimating, and Organizing Microeconomic Data; Data Access
    • C82 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Methodology for Collecting, Estimating, and Organizing Macroeconomic Data; Data Access

    NEP fields

    This paper has been announced in the following NEP Reports:

    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:zbw:safewp:300. 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: ZBW - Leibniz Information Centre for Economics (email available below). General contact details of provider: https://edirc.repec.org/data/csafede.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.