Script for manipulation of company data in excel.
Add following data to key value pairs in build_target_firm_data
:
-
sic code -
total asset value (event year) -
net income (pre event year) -
net income in event year, and all following years -
'100 Best' rank in each year of appearance