Saturday, July 26, 2014

Data Modification

__Date__Effective
24-Jul-13

Target_Name
Microlog Corp of Maryland

parent_COMNAM

MICROLOG CORP

Pinksheet
母公司粉单市场,难怪没COMPUSTAT没信息。




http://www.marketwired.com/press-release/microlog-announces-closing-of-acquisition-of-nutrabev-holdings-international-inc-pinksheets-mlog-1814031.htm

03年delist 552,所以drop了。

=================================================================

31DEC1986
Alleghany Finl(Alleghany Corp)
01JUL1987
Cyclops Industries Inc

以上两个公司的母公司是:
17400
ALLEGHANY CORP MD

该公司于1986.12.31liquidate,随后又成立了新的ALLEGHANY CORP MD。新的permno是


71271

对于
31DEC1986
Alleghany Finl(Alleghany Corp)

的return,应该用delist return.

对于
01JUL1987
Cyclops Industries Inc

我觉得应该用新permno(71271)的当日ret。

好在GVKEY一直没变

1274

http://www.fundinguniverse.com/company-histories/alleghany-corporation-history/
=================================================================

__Date__Effective
6-Apr-87
21-Dec-87
31-Dec-88

Target_Name
Fisher Scientific Grp(Henley)
Henley Manufacturing Corp
Wheelabrator Technologies Inc

parent_COMNAM
HENLEY GROUP INC
HENLEY GROUP INC
HENLEY GROUP INC

1988年,
Wheelabrator Technologies Inc是reverse-spinoff,这个子公司拿走了很重要的Henley的资产,然后把其余的丢给了Henley。换句话说,等于母公司换了个名字变成Wheelabrator Technologies Inc,而Henley其实是空壳。

把日期要改成19881230,因为没有31日这一天。



http://www.fundinguniverse.com/company-histories/the-henley-group-inc-history/
http://www.wheelabratortechnologies.com/about-us/company-history/

=================================================================

21OCT1999
US Neurosurgical Inc

母公司:G H S INC

SEC显示的effective spinoff date和SDC不符。

但是,CRSP里面GHS的讯息至于1997年。EDGAR显示,GHS后来更名为EOS,10-K一直持续发布到2003年,但仍然不知道何为1997后GHS就没有CRSP信息了。应该是GHS卖给了HMS,就没有存在的必要了(或者说没有成为上市公司的必要了)。




http://www.sec.gov/Archives/edgar/data/1089815/000100547702001375/d02-36812.txt


http://www.sec.gov/Archives/edgar/data/791398/0000932799-97-000112.txt


https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000791398&type=10-K&dateb=&owner=exclude&count=40


OTC =================================================================

01JUL1986
Florida Rock & Tank Line Inc

母公司:F R P PROPERTIES INC

match = b1 时间段不对,虽然只有一个match.
母公司名称压根就不对,应该叫Florida Rock industries。SDC给出的ticker,FRPP,也似乎不对。CRSP Code Lookup搜索,得到ticker应该是FRK,Permno应为56784.

但可疑的是,CRSP event并没有提到这一次的spinoff.


Florida Rock & Tank Line Inc后来改名叫Patroit Transportation Holding Inc. Permno 10443.


http://www.floridarockandtanklines.com/company-history




=================================================================

28FEB1992
Cellular Commun of Puerto Rico
母公司:CELLULAR COMMUNICATIONS INC

在91年7月31日后,母公司换了Permno和Ticker.所以改成Permno 88884,就能找到啦应该!好在Gvkey(linktable)里是一样的,都是GVKEY=12437.




=================================================================

20DEC1997
Epitope Inc-Agricultural
母公司:EPITOPE INC

没有1997.12.20这一天,这天是个周六,拜托!正确时间是1998.1.8




http://www.prnewswire.com/news-releases/record-date-set-for-agritope-spin-off-77961102.html




http://www.sec.gov/Archives/edgar/containers/fix020/801555/0000892917-97-000122.txt
=================================================================

06SEP1997
InvestorsBancorp,Pewaukee,WI
BANDO MCGLOCKLIN CAP CORP

Again,没有1997.9.6这一天,是个双休日。应该是1997.9.3。另外,BMCC后来在Edgar换名字了。子公司还是Private状态。




http://www.sec.gov/Archives/edgar/data/723209/0000897069-97-000462.txt






http://www.otcmarkets.com/stock/FTDL/profile


https://www.google.com/finance?q=Investors%20Bancorp%2C%20Inc.&ei=-qvXU6CtJY-08gbcroHIBQ
=================================================================

21APR1983
Eureka Co
ELECTROLUX AB

ELECTROLUX AB是一个Sweden的公司,1987-1989才在美国go public,所以1983的spin off,美国市场,没有effective date相关的回报率信息,等等。


http://cobrands.hoovers.com/company/AB_Electrolux/crkkxi-1-1njhxk.html

=================================================================
26JUN2009
Red Branch Technologies Inc
CHASE MEDICAL GROUP INC

Chase Medical 在1987-1989期间,CRSP有记录,这当中还变过一次SIC,不过Permno一样。2007.5.23 Chase Medical收购Red Branch,然后reverse split,再然后更名成为Red Branch (Delaware).被spinoff的子公司其实是Red Branch(Nevada). Red Branch在businessweek的网站是OTC,所以可以忽略。


https://www.otciq.com/otciq/ajax/showFinancialReportById.pdf?id=30836

http://investing.businessweek.com/research/stocks/snapshot/snapshot.asp?ticker=RBTI

=================================================================

31JUL2011
Valet Waste Inc

WASTE MANAGEMENT INC DEL

31JUL2011是个周六.Waste Management在相关日期附近并没有任何spin off.事实是,Valet的Immediate Parent Firm叫Oakleaf Global Holdings,这公司之前被New Mountain买了,然后又被卖给Waste Management。但是New Mountain觉得Valet Waste有前途,所以spinoff and retain Valet。因此,Valet被spinoff前的母公司,并不是Waste management.

CRSP搜索不到Oakleaf,但是有New Mountain。Permno是12747.




http://www.newmountaincapital.com/portfolio_companies.php?lv=valetwaste_desc




奇怪的是,CRSP里的New Mountain在July 31, 2011附近并没有spinoff的痕迹,而且#  of shares outstanding, stock price, vol均没有什么变化。所以母公司到底应该用New Mountain吗?

http://www.newmountaincapital.com/downloads/Exhibit_A_Waste_Management_Buys_Oakleaf.pdf
=================================================================

13FEB2001
Primal Solutions Inc
ATLANTIC EXPRESS INC

Primal的母公司应该是Avery,而且是一个OTC的公司,所以忽略。


http://www.thefreelibrary.com/Primal+Solutions,+Inc.+Completes+Spin-off+from+Parent+Company,+Avery...-a070425627
=================================================================


14JUN2010
ante5 Inc
VOYAGER OIL & GAS INC

一切都没错,但是VORAGER当时还是个OTC。2011年才上了主板。
http://www.prnewswire.com/news-releases/spin-off-of-ante5-inc-from-voyager-oil--gas-inc-is-completed-trading-to-commence-in-ante5-inc-common-stock-96362154.html



=================================================================

26JAN1984
American Ecology Corp
AMERICAN ECOLOGY CORP

Google显示母公司应该是Teledyne。CRSP搜索后,得到Permno,43123。但是CRSP当天也没有显示spin off 信息,可能CRSP信息不全。


http://www.answers.com/topic/american-ecology-corp



=================================================================

30DEC2011
Orchard Supply Hardware Stores

ORCHARD SUPPLY HRDWRE STORES CP

母公司应该是Sears.,Permno 89757。CRSP没有显示spin off。OSH是orchard被spioff以后的ticker,所以SDC错了。




http://searsholdings.mediaroom.com/index.php?s=16310&item=101481

=================================================================

06FEB2012

Post Foods LLC

SDC信息完全不对。母公司Ralcorp(NYSE:RAH),Permno 84584.
子公司Permno 13188.
http://www.bizjournals.com/stlouis/news/2012/02/06/ralcorp-completes-post-spinoff.html




http://www.bizjournals.com/stlouis/news/2012/02/06/ralcorp-completes-post-spinoff.html




=================================================================
01MAY2013
CST Brands Inc
C S T BRANDS INC

母公司应该是Valero(VLO)。permno 85269。这次CRSP看到这个spin off了。新的Permno 13831,正是CST的permno.


http://www.valero.com/investorrelations/pages/investorfaqs.aspx







=================================================================

24AUG2009
Seahawk Drilling Inc

BLACKHAWK NETWORK HOLDINGS INC

母公司应该是Pride International, Permno 12074.Seahawk被spinoff后,子公司的permno是93006.


http://primezone.com/newsroom/news.html?d=171944







=================================================================


31MAR2012
Atlas Energy-Natural Gas Asset
CHEVRON CORP NEW

情况比较复杂。

Atlas Energy在2011年2月被CHEVRON CORP NEW收购了。但Atlas Energy 本身就是上市公司。

Atlas Energy在2012年3月5日,spinoff了Atlas Resource Partners, LP.后者把Natural Gas Asset这些部门给带走了。所以Atlas Resource Partners应该是Target Name in SDC. Permno 13204.

Atlas Energy Inc在2011年2月17日后,改名叫Atlas Energy LP.

Youtube新闻显示的spin off日期是2012.3.14
https://www.youtube.com/watch?v=J1ybnLKGorI

Atlas Energy LP在CRSP这一天的记录中,有分发cash dividend(distribution code: 1232).

母公司还是选择Atlas Energy LP吗???Permno 91376.


http://www.atlasresourcepartners.com/company/history/









mm





No comments:

Post a Comment