About Me

Hi, I’m Kai CUntitledhen. I was a PhD student in accounting at the School of Accounting and Finance, University of Waterloo when I created this blog. Now I am an assistant professor in accounting at Wilfrid Laurier University. This website serves as a repository for coding tips and SAS/Stata/Python programs for archival research in financial accounting. I personally benefit a lot from other persons’ blogs or websites. I hope I can use my expertise to help others in return.

I wish this blog can promote code transparency and reusability in our community.

I like running (finished my first half marathon on May 1, 2016), photography, videography, astronomy, programming, website building, and all cool tech gadgets. If I were not in the field of accounting (auditor and financial advisor at Big 4, accounting PhD and now professor), I would probably have been a good programmer.

Happy coding, and share!

6 Responses to About Me

  1. Dennis Coppens says:

    Hi Kai,

    Thank you for the explanation on exporting files from Factiva in a table format. That is exactly what I need to do for my current work.

    Unfortunately, I have never worked with Python, so it gets very complicated very fast for me. How I understood it, I simply paste the code you wrote in Python, while having my txt files in the same folder as Python, and it should automatically do the trick. I think I may be oversimplifying it a little! Could you possibly give some advice to send me in the right direction. I would be very grateful!

    Many thanks,
    Dennis Coppens

  2. Jun Gu says:

    Hi Kai,

    Thanks very much for your sharing on codes and experience of data processing. During my PhD study, I also benefited quite a lot from online resources, e.g. WRDS forum, some blogs, perosnal sites from some scholars like Andrew Lo. It is really nice to spot your blog with so many key information on. Thanks again for your site.

  3. garen says:

    Hey Kai! Many thanks in sharing your code. This is the most helpful page!

    Wish you a great day, Garen

  4. Razoo says:

    vDear Chen,

    Thank you very much for the code.

    Could you please post a code for linking between compustat and audit analytics without CRSP and I/B/E/S?

    Thank you very much again,

  5. Won says:

    Hello Chen,

    Thank you very much for your efforts in promoting accounting research transparency.
    It is impressive!

  6. Sabrina says:

    Hi Kai

    It is nice to see you post and it is very helpful. Can you please post a python code to directly read IBES from WRDS and compute some popular variables, such as monthly revisions of each stock, etc? Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *