Categories
 Data (7)
 Learning Resources (8)
 Python (7)
 SAS (11)
 Stata (14)
 Uncategorized (2)

Recent Posts
 The calculation of average credit rating using ratings from three rating agencies
 Stata commands to test equality of mean and median
 Handy Stata command to display combined Pearson and Spearman correlation matrix
 Stata command to convert string GVKEY to numerical GVKEY or vice versa
 Stata command to calculate the area under ROC curve
Recent Comments
 Won on About Me
 joe on Use Python to extract URLs to HTMLformat SEC filings on EDGAR
 Kai Chen on EDGAR index files in Stata dataset (from 1993 Q1 to March 2, 2017)
 Emma on EDGAR index files in Stata dataset (from 1993 Q1 to March 2, 2017)
 Yannick B on Use Python to download TXTformat SEC filings on EDGAR (Part I)
Archives
Meta
Monthly Archives: September 2015
The impact of WRDS transition to the new WRDS Cloud server
WRDS has quietly started the transition from the old server to the new Cloud server. This move makes a lot of support documentation on the WRDS website outdated and misleading. That is why I think WRDS should direct its resources on continuously … Continue reading
Posted in Learning Resources, SAS
1 Comment
Rollingwindow computation in SAS and Stata
SASers often find proc expand plus transformout very useful for rollingwindow (or movingwindow) computation. Stataers may wonder if there is a counter party in Stata. The answer is “yes”. The command in Stata is rolling. See the manual below: http://www.stata.com/manuals13/tsrolling.pdf The … Continue reading
Posted in Learning Resources, SAS, Stata
Leave a comment
SAS macro for event study and beta
There are two macros on the List of WRDS Research Macros: EVTSTUDY and BETA, which may be often used. I like the first one, written by Denys Glushkov. Denys’ codes are always elegant. I don’t like the second one because … Continue reading
Pipeline
These are some topics in my mind. I will write up when I have time. Use Python to remove boilerplate paragraph in firminitiated press releases Calculate earnings surprises Chow test and Vuong test Access to WRDS Propensity score matching macros … Continue reading
Posted in Uncategorized
Leave a comment
Use Python to calculate the tone of financial texts
I find two internet resources for this task (thank both authors): https://iangow.wordpress.com/2014/07/22/gettonefromcorporatedisclosurespostgresqlpythonandr/ http://conjugateprior.org/software/cainpython/ The first solution is way more efficient than the second, but the second is more straightforward. The first needs extra knowledge of PostgreSQL and R besides Python. I … Continue reading
Posted in Python
7 Comments