Democratize Data For Insights

Get Insights into Workplace Environment Through the Lens of Glassdoor

Workflows for Parsing Comprehensive Glassdoor Dataset

Posted by Mengjie Xu Friday, December 1, 2023

Tracing The Origins of EDGAR Downloads

How to distinguish EDGAR downloads from different stakeholders

Posted by Mengjie Xu Monday, July 31, 2023

Gain Insights From Organized Retail Investors in Reddit Wallstreetbets

A systematic approach for analyzing Reddit Wallstreetbets comments

Posted by Mengjie Xu Sunday, July 2, 2023

Replicate Brogaard Stock Volatility Decomposition

Produce the stock information content measures introduced by Brogaard et al. (2022, RFS)

Posted by Mengjie Xu Tuesday, January 10, 2023

Dig into Estimation of VAR Coefficients, IRFs, and Variance Decomposition in Stata

Manually compute all the major outputs of VAR

Posted by Mengjie Xu Monday, January 9, 2023

Estimations of VAR, IRFs, and Variance Decomposition in Stata

Common practice of VAR estimation in Stata

Posted by Mengjie Xu Monday, January 9, 2023

Touch into the Vector Auto Regression Model

The logics of VAR, Impulse Reaction, and Variance Decomposition

Posted by Mengjie Xu Tuesday, November 22, 2022

Theory for the information-based decomposition of stock price

Theoretical techniques in variance decomposition method proposed by Brogaard et al. (2022, RFS)

Posted by Mengjie Xu Monday, November 21, 2022

Seeking Alpha From Market Participants' Information Acquisition Actions

Trace information acquisition actions of both retail and institutional investors

Posted by Mengjie Xu Thursday, September 8, 2022

Collect Daily Level Short Sale Data From FINRA With Low Costs and Low Delay

Affordable and high-quality daily-level short selling data collection

Posted by Mengjie Xu Saturday, May 14, 2022

Utilize Google Search as an Integrated Data Source

A standardized approach for unformatted data collection

Posted by Mengjie Xu Thursday, March 31, 2022

Extract High-frequency Data via PC SAS

Request trade and quotes data from WRDS-TAQ database for intra-day event study

Posted by Mengjie Xu Friday, December 3, 2021

Twitter API: Door To Social Media Analysis I

Introduction to Twitter API v2

Posted by Mengjie Xu Monday, November 1, 2021

Twitter API: Door To Social Media Analysis II

Replicate Tweets Archive Search of Bartov, Faurel, and Mohanram (2018, TAR)

Posted by Mengjie Xu Monday, November 1, 2021

Origins of Papers

Information sources that might have inspired nice economic papers

Posted by Mengjie Xu Wednesday, October 20, 2021

Exploit WRDS Cloud via Python

Make your WRDS data extraction and processing replicable

Posted by Mengjie Xu Tuesday, October 12, 2021

Extract Mass Data Via Bloomberg API

Operation Environment Preparation and Data Extracting

Posted by Mengjie Xu and Qi Zhang Thursday, July 8, 2021

Obtain Searched Results From WSJ Website

A shortcut to get anecdotes for your paper

Posted by Mengjie Xu Wednesday, June 30, 2021

From NOAA ISD Dataset to Panel Data

China stations as an example

Posted by Mengjie Xu Tuesday, June 15, 2021

ABOUT ME

I am an Accounting PhD candidate at Frankfurt School of Finance and Management. I will be on the job market in Fall 2023. Feel free to learn more about me and my research by clicking on my photo above or visiting my Google site at www.mengjiexu.org.