1. 用pcl function merge firm name 效果不好,那些公司cusip找不到,应该就是没有mf.
2. 粗略结果。sp公司的mf频率变化不大,control group的频率明显增高。
Thursday, January 15, 2015
Wednesday, January 14, 2015
Dairy 20150114
早汇报三件事,关于律所的报告。
1. No shareholder meetings needed
2. Filings include:
Form 10 for parents
S-1 or 8-A for IPO subsidiaries
3. Debt offering - Cash transactions
Example:
Abbott $50 billion spin off
$14 billion debt offering
力力的问题,
10-K怎么显示俩公司的负债情况?
老克的问题,
generally speaking, stock dividend, splits-off, spin-offs, carve-outs在美国都是谁起头的?MGMT or shareholders? 查Delaware州法律即可。
1. No shareholder meetings needed
2. Filings include:
Form 10 for parents
S-1 or 8-A for IPO subsidiaries
3. Debt offering - Cash transactions
Example:
Abbott $50 billion spin off
$14 billion debt offering
力力的问题,
10-K怎么显示俩公司的负债情况?
老克的问题,
generally speaking, stock dividend, splits-off, spin-offs, carve-outs在美国都是谁起头的?MGMT or shareholders? 查Delaware州法律即可。
Tuesday, January 13, 2015
20150113 Lunch Room Presentation
1. What are the rules for spinoff shareholder meetings?
Do they need a meeting? Kris said in Sweden 必须有那么一个会议。
美国的规定不一样,那么多少$以上,或者占公司比重多少的spinoff,需要那样的会议?
2. Management forecasts始于何时?time series中怎样变化?
3. Analysts forecasts始于何时?time series中怎样变化?
To-do-list
2015.1.13
1. Control Group
2. Expand time to 1998 (IBES)
3. SDC Plantinum, user initial?
4. BUPC email list
5. Bed Frame (Walmart)
6. Credit Card - Holland America?
7. Credit Card Receipt - $500?
8. Register 1 credit in Srping
9. Campus Pre-School Material
10. Rocky 10:30AM Appointment
11. SIC in CRSP?
12. Lunch room presentation Qs
老克的建议
(1) 不要用Information asymmetry这样的字眼,我们不知道管理层到底是不是知道。用Value!!!因为市场低估了Value。
(2) 找control group过程中
条件: a. 两位SIC相同
b. 10%以内的total assets
c. 最接近的MB ratio
如果条件二不满足,把第一条限制去掉。
=====================================
想起小马跟我讲的。debt的原因。
律所的这篇文章,讲起spin off其实也经常牵涉"钱"的问题。比如子公司被spun off前,借了笔钱,然后把现金都给了母公司,在spun off以后,把债务带走。
http://www.wlrk.com/files/2014/SpinOffGuide.pdf
Wachtell, Lipton, Rosen & Katz
Spin-Off Guide
spin off的CAR是最高的,比carve-out和卖部门的CAR都高。如果和钱有关,与debt有关的spin off应该CAR较低。
和力力谈谈这个alternative explanation.
https://books.google.com/books?id=t2qrbAo0fs4C&printsec=frontcover#v=onepage&q&f=false
Do they need a meeting? Kris said in Sweden 必须有那么一个会议。
美国的规定不一样,那么多少$以上,或者占公司比重多少的spinoff,需要那样的会议?
2. Management forecasts始于何时?time series中怎样变化?
3. Analysts forecasts始于何时?time series中怎样变化?
To-do-list
2015.1.13
1. Control Group
2. Expand time to 1998 (IBES)
3. SDC Plantinum, user initial?
4. BUPC email list
5. Bed Frame (Walmart)
6. Credit Card - Holland America?
7. Credit Card Receipt - $500?
8. Register 1 credit in Srping
9. Campus Pre-School Material
10. Rocky 10:30AM Appointment
11. SIC in CRSP?
12. Lunch room presentation Qs
老克的建议
(1) 不要用Information asymmetry这样的字眼,我们不知道管理层到底是不是知道。用Value!!!因为市场低估了Value。
(2) 找control group过程中
条件: a. 两位SIC相同
b. 10%以内的total assets
c. 最接近的MB ratio
如果条件二不满足,把第一条限制去掉。
=====================================
想起小马跟我讲的。debt的原因。
律所的这篇文章,讲起spin off其实也经常牵涉"钱"的问题。比如子公司被spun off前,借了笔钱,然后把现金都给了母公司,在spun off以后,把债务带走。
http://www.wlrk.com/files/2014/SpinOffGuide.pdf
Wachtell, Lipton, Rosen & Katz
Spin-Off Guide
spin off的CAR是最高的,比carve-out和卖部门的CAR都高。如果和钱有关,与debt有关的spin off应该CAR较低。
和力力谈谈这个alternative explanation.
https://books.google.com/books?id=t2qrbAo0fs4C&printsec=frontcover#v=onepage&q&f=false
Monday, January 12, 2015
* 20 parent firms do not have AT in the current year;
* 20 parent firms do not have AT in the current year;
* Airborne Inc-Air Operations, AIRBORNE INC acquired by DHL;
* US Bancorp Piper Jaffray Inc, Parent New GVKEY 4723(1963-2013), Old gvkey 4682;
* Tronox Inc, KERR-MCGEE CORP, parent acquired by Anadarko;
* Fidelity National Title Group, merge after spinoff;
http://www.investor.fnf.com/releasedetail.cfm?ReleaseID=201868
* CPEX Pharmaceuticals Inc, Bentley Pharmaceuticals & Teva Pharmaceutical Industries Ltd. Merger;
* Airborne Inc-Air Operations, AIRBORNE INC acquired by DHL;
* US Bancorp Piper Jaffray Inc, Parent New GVKEY 4723(1963-2013), Old gvkey 4682;
* Tronox Inc, KERR-MCGEE CORP, parent acquired by Anadarko;
http://www.anadarko.com/Investor/Pages/NewsReleases/NewsReleases.aspx?release-id=894918
https://www.quanex.com/News-Room/News-Releases/Investors/Quanex-Corporation-Announces-Plan-to-Separate-Its.aspx
* Suncoke Energy Inc, Energy Transfer Partners, L.P. Acquisition of Sunoco, Inc.;
file:///C:/Users/qzhang25/Downloads/ETP%20to%20Acquie%20SUN%20Investor%20Presentation%20(1).pdf
http://en.wikipedia.org/wiki/Sunoco
* Adelphia Business Solutions, ADELPHIA COMMUN -CL A, two missing years of AT in Compustat;
* Comverse Inc, parent COMVERSE TECHNOLOGY INC merger with VRNT;
http://www.spinoffresearch.com/Stock-Spin-Off-Research-Report-blog/bid/161470/CMVT-Spin-Off-Comverse-Technology-Comverse-Inc-When-Issued-Trading
* Fidelity National Title Group, merge after spinoff;
http://www.investor.fnf.com/releasedetail.cfm?ReleaseID=201868
* CPEX Pharmaceuticals Inc, Bentley Pharmaceuticals & Teva Pharmaceutical Industries Ltd. Merger;
http://www.drugs.com/news/bentley-pharmaceuticals-amp-teva-pharmaceutical-industries-ltd-merger-consideration-established-14-8367.html
* SurgiCount Medical Inc, Compustat doesn't record any AT in any year;
* BioVeris Corp, ROCHE TO ACQUIRE IGEN, parent;
http://www.sec.gov/Archives/edgar/data/916304/000095015703000463/form8-k.txt
* Cohesant Inc, merger & spinoff;
http://www.businesswire.com/news/home/20080227006151/en/Cohesant-Technologies-Completes-Sale-Glascraft-Graco-Completes#.VLQreSvF8UN
* Straight Path Communications, IDT CORP 62396, full info in AT, cannot UNDERSTAND!!!;
* Marlborough Software, merge & spinoff;
http://www.sec.gov/Archives/edgar/data/818813/000119312511307245/d255179dex991.htm
* 8 parent firms do not have AT in the next year;
SAS Pro\Spinoff
New20150112.SAS
* 8 parent firms do not have AT in the next year;
* Cadbury Schweppes Americas, Cadbury, Demerger of Cadbury Schweppes plc, cease trading on NYSE in 2008;
* Flamemaster Aerospace Corp, FLAMEMASTER CORP, reorganize;
* Monsanto Co, PHARMACIA CORP, stopped trading in 2002;
* Post Foods LLC, RALCORP HOLDINGS INC, ConAgra Foods agreed to acquire Ralcorp on November 26, 2012;
* PPD Inc-Furiex Pharm Inc, delist from NASDAQ;
New20150112.SAS
* 8 parent firms do not have AT in the next year;
* Cadbury Schweppes Americas, Cadbury, Demerger of Cadbury Schweppes plc, cease trading on NYSE in 2008;
* Flamemaster Aerospace Corp, FLAMEMASTER CORP, reorganize;
* Monsanto Co, PHARMACIA CORP, stopped trading in 2002;
* Post Foods LLC, RALCORP HOLDINGS INC, ConAgra Foods agreed to acquire Ralcorp on November 26, 2012;
* PPD Inc-Furiex Pharm Inc, delist from NASDAQ;
http://www.getfilings.com/sec-filings/111205/PHARMACEUTICAL-PRODUCT-DEVELOPMENT-INC_8-K/
* Strategos Inc, INNOVARO INC, delist from NYSE;
http://www.businesswire.com/news/home/20121205006638/en/Innovaro-Receives-Delisting-Notification-NYSE-MKT#.VLQZbyvF8UM
* Abraxis Pharmaceutical, APP PHARMACEUTICALS INC, remove from NASDAQ;
http://services.corporate-ir.net/SEC.Enhanced/SecCapsule.aspx?c=130431&fid=5307510
Unique ID in Compustat
Topic: Unique Identifier
Q: How to find unique obs in Compustat?
A: DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D
web:
https://cobweb.business.nd.edu/Portals/0/MendozaIT/Research/Shared%20Documents/CCM/Data%20Guides/CRSP-Compustat%20Merged%20Database%20Guide.pdf
page 11
问了力力,他说,看似是对的。就是keyset=0的那一行。找一个WRDS的sample program来看看。
我找了以下的。应该是对的。
http://wrds-web.wharton.upenn.edu/wrds/support/Data/_003Sample%20Programs/Compustat/compna_funda1.cfm
Q: How to find unique obs in Compustat?
A: DATAFMT = STD INDFMT = INDL CONSOL = C POPSRC = D
web:
https://cobweb.business.nd.edu/Portals/0/MendozaIT/Research/Shared%20Documents/CCM/Data%20Guides/CRSP-Compustat%20Merged%20Database%20Guide.pdf
page 11
问了力力,他说,看似是对的。就是keyset=0的那一行。找一个WRDS的sample program来看看。
我找了以下的。应该是对的。
http://wrds-web.wharton.upenn.edu/wrds/support/Data/_003Sample%20Programs/Compustat/compna_funda1.cfm
Tuesday, December 2, 2014
Progress
1. 和小马谈了谈,他问,可不可能是因为creditor要求的呢?因为公司变小了,Collateral这些都不好说了,所以需要MF。建议和Tony聊聊。
2. 力力说,MF如果不是为了降低information asymmetry,那么CEO的fixed effects呢?
2014/12/16
今天Present对于IBES的了解。
1. 所有发现的问题,在SAS里做备注,提供简单的数字描述,以及解决方案。从今往后,即使重新下载数据,同样的问题,可以直接用编程解决。
e.g. IBES的Cusip问题。写粗来!!!
2. Activation date在Announcement Date之前,之后,是什么情况?有多少是pre-announcement date? 比较一下!!!
3. 以上问题如果离谱,怎么解决???!!!comments & 解决方案,要在SAS备注!!!
4. Key在数据库里的独特意义,是Unique identifier!IBES的key,pdf有详述。那么Compustat或CRSP的key在哪儿?
5. 在datetime16.的格式中,要获得正常年月日,可以用datepart()function
再用year(datepart())就能得到年份了。
6. 发MF的公司有什么样的特性?发不同measure,比如EPS,Earnings,或者CPX的公司,各自什么特性?(找paper)
7. p/s and earnings,公司一般同时宣布,还是有些公司亲睐ps,有些公司亲睐earnings?
8. annual / quarterly compustat的difference???
2. 力力说,MF如果不是为了降低information asymmetry,那么CEO的fixed effects呢?
2014/12/16
今天Present对于IBES的了解。
1. 所有发现的问题,在SAS里做备注,提供简单的数字描述,以及解决方案。从今往后,即使重新下载数据,同样的问题,可以直接用编程解决。
e.g. IBES的Cusip问题。写粗来!!!
2. Activation date在Announcement Date之前,之后,是什么情况?有多少是pre-announcement date? 比较一下!!!
3. 以上问题如果离谱,怎么解决???!!!comments & 解决方案,要在SAS备注!!!
4. Key在数据库里的独特意义,是Unique identifier!IBES的key,pdf有详述。那么Compustat或CRSP的key在哪儿?
5. 在datetime16.的格式中,要获得正常年月日,可以用datepart()function
再用year(datepart())就能得到年份了。
6. 发MF的公司有什么样的特性?发不同measure,比如EPS,Earnings,或者CPX的公司,各自什么特性?(找paper)
7. p/s and earnings,公司一般同时宣布,还是有些公司亲睐ps,有些公司亲睐earnings?
8. annual / quarterly compustat的difference???
Subscribe to:
Posts (Atom)
