Monday, July 28, 2014

Data Modification (3)

06DEC2010

Patriot National Insurance

06DEC2010
Patriot Underwriters Inc

母公司是Patroit Risk Management,但是个Private 公司


 https://www.google.com/finance?q=Patriot+Risk+Management&ei=r-7WU-CGHZGu8gb04YGIDA


http://www.prnewswire.com/news-releases/patriot-risk-management-announces-spin-off-of-patriot-underwriters-and-guarantee-insurance-company-111377054.html
=================================================================
11SEP2003
Bresagen-Protein Pharm Div

Bresagen是一个澳大利亚的公司,直到2004年Abbott把Hospira给spin off,而2006年Hospira才收购Bresagen。不太可能2003年Bresagen有一次spin off.


 http://media.corporate-ir.net/media_files/irol/17/175550/2007_Hospira_Annual_Report_LR.pdf


http://www.sec.gov/Archives/edgar/data/1132541/000091142003000182/d904300v3.txt


=================================================================
15APR2001
Network Design Tools Inc

母公司是Private.


http://www.lightwaveonline.com/articles/2001/11/rsoft-and-network-design-tools-inc-agree-to-merge-53476672.html


https://www.google.com/finance?q=Telcordia+Technologies%2C+Inc.&ei=WLHXU7C5O4G58gbBuIGABw

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

05FEB2004

Fortis Inc

母公司是Dutch公司。
子公司Permno 90038。


http://en.wikipedia.org/wiki/Assurant

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

31DEC2011

WPX Energy Inc

CRSP显示日期是03JAN2012.本来的日子是个周日。



=================================================================
01OCT2013

Ceridian Corp-Payments Bus

母公司Ceridian现在是private。但它以前是个public firm.


https://www.moodys.com/research/Moodys-rates-new-Ceridian-debt-at-Caa3-CFR-at-B3--PR_267940


https://www.google.com/finance?q=Ceridian&ei=wuzXU5BOh6vyBue7gKAG

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

01JAN1989

Illinois Central Trans Co

母公司Permno 38973, GVKEY 5824.
子公司没有Permno,但是搜索找到GVKEY 5876.
http://articles.chicagotribune.com/1988-11-19/business/8802180118_1_common-stock-five-shares-ic-industries

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

26MAY1989

Mercom Inc(Michigan Energy)

母公司Permno 40782,但是spinoff后,就结束了。因为Michigan Energy被UtiliCorp并购了,所以New Parent Permno就是26606.

另外,26MAY1989因为在重组,所以没有RET。
http://articles.chicagotribune.com/1989-05-30/business/8902050214_1_utilicorp-united-common-stock-michigan-energy



spinoff sample from http://www.docstoc.com/docs/161285334/Spinoff-sample

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

17OCT1996
Advanced Digital Information


母公司InterPoint,但是公司CRSP至于16OCT1996. Permno 44389.
但后来InterPoint 就被卖给Crane了。




http://community.seattletimes.nwsource.com/archive/?date=19960702&slug=2337433


=================================================================
16MAR1984

Kaydon Corp

母公司Bairnco Corporation. Permno 62797.
子公司Kaydon Corp, Permno 47205.


http://hsprod.investis.com/site/irwizard/kdn/ir.jsp?page=sec_item_new&ipage=1363841&DSEQ=1&SEQ=9&SQDESC=SECTION_PAGE&exp=&subsid=41



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

01NOV2008

Bear Stearns Merchant Banking

01NOV2008 是周六。我们可以用03NOV2008。
母公司JPmorgan没有提到这一次的spin off。
子公司后来是private。


http://en.wikipedia.org/wiki/Irving_Place_Capital


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

31DEC1988

Burlington Resources Inc

31DEC1988是周六。我们用03JAN1989好了。CRSP也用了这个日子。
老奇怪的,子公司先IPO,半年后再spin off。






http://www.nytimes.com/1988/06/03/business/burlington-northern-s-spinoff-plan.html

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

26APR1984
MHP Machines Inc

母公司MOOG,Permno 61807.
子公司没有GVKEY,linktable找不到。Permno 50471.


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

09JAN1984

Flagg Industries Inc

年代太过久远,找不到这次spin off.
但是Flagg看上去是母公司,不是子公司。
Flagg1971年就有IPO了,不应该是子公司。



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


20AUG1993

Malrite Commun-Non Radio Ops

Malrite Communication本来是上市公司,一直到1989年。后来被Raycom收购。Raycom是private.



http://en.wikipedia.org/wiki/Raycom_Media

https://www.google.com/finance?q=Raycom+Media%2C+Inc.&ei=uwjYU6jFKo-08gbcroHIBQ

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







Sunday, July 27, 2014

Data Modification (2)


22JUN1983
Diamond Intl-Calmar Division
DIAMOND GARDNER CORP

有点复杂。Calmar是Diamond  International的一个事业部,1983年6月22日正式IPO。但是Diamond international在1982年已经被恶意收购(hostile takeover)了。收购人是一个经济学人家,Sir James Goldsmith。这人随后卖掉了大部门Diamond International的资产,只留了timberland。(我估计Calmar就是在这种情形下spin off的,但这时Diamond international已经不是上市公司了。)




http://www.nytimes.com/1983/05/05/business/briefs-145969.html


http://www.nytimes.com/1982/11/02/business/diamond-accepts-goldsmith-merger.html


https://www.facebook.com/permalink.php?story_fbid=528285477183693&id=433551036657138

=================================================================
16MAY1984
Avery Inc

AVERY INC

纽约时报说,Avery Inc IPO是在1984年5月16日。CRSP里有很多Avery,如果是Avery Inc.,CRSP提供的IPO却从1984年8月29日起始。

找不到他是被spin off,或者其它新闻。CRSP linktable应该都不对,那些都是不同于Avery Inc.只是名称雷同的公司。

找不到母公司。



http://www.nytimes.com/1984/09/13/business/avery-inc-reports-earnings-for-qtr-to-july-29.html



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

31DEC1986
Alleghany Finl(Alleghany Corp)
ALLEGHANY CORP MD

CRSP搜索ALLEGHANY有好多个,但其实是一个公司。从早期(Permno 17400)的那个能看出来,新的permno就是后头那个71271。Distribution code 2161是liquidation.

Q:所以这个不是spin off吧???







http://www.fundinguniverse.com/company-histories/alleghany-corporation-history/ =================================================================
01JUL1987
Cyclops Industries Inc

ALLEGHANY CORP MD

又是很复杂的重组,要把Cyclops卖给另一个子公司,然后把那个子公司spin off,再改回Cyclops的名字。母公司就是ALLEGHANY CORP DE,post Permno 71271。per Permno应该还是17400。参考上一条。


http://www.nytimes.com/1987/02/18/business/company-news-big-british-retailer-to-acquire-cyclops.html


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

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

01SEP1997
Solutia Inc

MONSANTO CO

可行的方式是,把Effective Date改成1997, 9, 3.








The company was formed on September 1, 1997, as a divestiture of the Monsanto Company chemical business. 
http://en.wikipedia.org/wiki/Solutia =================================================================



02OCT1997
Rockwell Automotive

31DEC1998
Conexant Systems Inc

29JUN2001
Rockwell Collins Inc

所以他们的母公司,都应该用Permno 84381,因为三个spinoffs都发生在1996年以后。即使公司名字和Permn有变,GVKEY始终没变。









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

10MAR1981
Richardson-Merrell Inc

Richardson_Merrell存在很久了,先是与Dow的一个子公司merge,等把OTC(非处方药,和金融术语没关系)一些部门转以后,剩下的Richardson_Merrell就被spin off了。

我觉得比较合理的Ultimate母公司,应该是Dow,Permno 20626。

子公司,后来名称不能算是Richardson-Merrell,而应该是Richardson-Vicks。

Q:这样的parent Permno到底怎么算???如果算Richardson-Merrell Inc是母公司,spinoff之后,就没有母公司了?






http://caselaw.findlaw.com/il-court-of-appeals/1178026.html

Merrell Dow Pharmaceuticals[edit]

Dow Chemical acquired controlling interest of the Merrill pharmaceutical division of Richardson-Merrell company in 1980 and it became Merrell Dow Pharmaceuticals.[7] ( The former Richardson Merrell became Richardson Vicks. In 1985, Richardson Vicks was acquired by The Procter & Gamble Co. )
http://en.wikipedia.org/wiki/Marion_Merrell_Dow
=================================================================
29OCT2000
Triarc Cos-Beverage Division
TRIARC COMPANIES INC


29OCT2000是周日。看样子,Triarc先把soft drink部门给spinoff,然后把股份卖给了别人。

这样也可以算spin off吗?




Saying good-bye to "The Best Stuff on Earth"

Triarc was the No. 6 soft drink company in the United States in 1999. Nevertheless, the company decided to spin off its beverage division, and sell shares of the new company, Snapple Beverage Group, to the public. The plan was approved by Triarc's board in June 2000; it is not clear when the spin off will take place.
http://www1.iwon.com/home/careers/company_profile/0,15623,1337,00.html

http://www.fundinguniverse.com/company-histories/stewart-s-beverages-history/



http://www.sec.gov/Archives/edgar/data/30697/000095011701000685/0000950117-01-000685-0001.txt


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


24AUG2009
Seahawk Drilling Inc
HAWKS INDUSTRIES INC

参见前面。

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


26JUL1993
Pittston Minerals Group

PITTSBURGH STL CO

是一个tracking stock.母公司是Pittston Company, Permno 18649.
尽管如此,CRSP也认为这是spinoff,但日期是27JUL1993.


http://www.referenceforbusiness.com/history2/8/The-Pittston-Company.html






http://news.google.com/newspapers?nid=1454&dat=19960617&id=NbFOAAAAIBAJ&sjid=NBUEAAAAIBAJ&pg=6425,508605




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

15JUL2008
Arasor-Consumer Optics Bus

ARISTAR INC

母公司应该就是Arasor。是一家澳大利亚公司,所以海外上市,pass!


http://www.asx.com.au/asxpdf/20080731/pdf/31bgn93t4jrnhn.pdf



http://www.topstocks.com.au/stock_discussion_forum.php?action=searchgo&searchtype=fid&fid=2162

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

30JUN2001
Cendant-Membership Svcs

CENDANT CORP

母公司是Cendant没错,但30JUN2001是周六,01JUL2001是周日。但是Cendant前后都没有显示spin off in CRSP!

Q: 或者我们用02JUL2001???


http://www.newsday.com/business/technology/queens-inc-cendant-ends-spin-off-starts-management-unit-1.800768




http://www.hospitalitynet.org/news/4006261.html

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

08APR1983
Compucom Development Corp

COMPUCOM DEVELOPMENT CORP

CRSP显示日期,应该是19830218.


ID PARENT PERMNO CUSIP EXDATE PARENT (1) OR SUB (0)
120 Compucom Development Corp 25655 20477910 7/11/1983 0
120 Indy Water/IWC Resources 43984 45071210 2/25/1983 1
from http://www.docstoc.com/docs/161285334/Spinoff-sample




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

12DEC1996
Newport News Shipbuilding
TENNECO INC

母公司Tenneco也变了Permno。GVKEY不变10443, Permno前后有变,26542 or 84375. 日期,合理推算,还是用11DEC1996。


http://en.wikipedia.org/wiki/Newport_News_Shipbuilding


linktable




dsenames



CRSP


CRSP (New Permno)


http://fas.org/man/company/shipyard/newport_news.htm
=================================================================
23DEC1988
NL Petroleum Svcs(NL Inds Inc)
CONTRAN CORP


母公司是NL Industries,GVKEY 007658, Permno 13303.
子公司是BAROID Corp, Permno 75382. Gvkey信息要从1990年后才有。

dsenames




Linktable - Parent


CRSP - Sub


Linktable - Sub
=================================================================

09DEC2003

Kronos Worldwide Inc

母公司同上,NL industries. GVKEY 007658, Permno 13303.
子公司Permno 89960.


http://www1.nyse.com/press/1070623411958.html


CRSP - Sub


CRSP - dsenames

SEC filing里面有提到,comparability的问题,要找很久。
http://www.sec.gov/Archives/edgar/data/72162/000007216204000004/nl10k03.txt



=================================================================
29DEC1990
Pinelands Inc(MCA Inc)

M C A INC

就是日期和CRSP不一样。29DEC1990是周六。所以我们还是用1991.1.4吧?



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

30AUG2002
Majestic Safe-T-Products Inc
COOPERBIOMEDICAL INC

母公司应该是Majestic Companies LTD。Edgar提供了CIK,是0001083931。



from SEC


http://www.otcbb.com/asp/dailylist_search.asp?DirectSymbol=MJXX&OTCBB=True =================================================================


02JAN2007
Duke Energy Corp-Natural Gas
DUKE ENERGY CORP

CRSP 显示日期为03JAN2007啦。

CRSP



http://en.wikipedia.org/wiki/Spectra_Energy
=================================================================

13OCT1993
Commercial Assets Inc

AMERICAN BUSINESS SYS INC

母公司是Asset Investors Corp(Ticker AIC)。母公司改名过,spinoff的时候还叫Asset Investors,显著叫American Land Lease Inc. Permno 70818. GVKEY 13776.

CRSP能找到这次spinoff。


http://www.thefreelibrary.com/COMMERCIAL+ASSETS+REGISTRATION+STATEMENT+DECLARED+EFFECTIVE+OCTOBER...-a013276093




CRSP - Parent


Sub - Permno 79755
=================================================================

28MAY2008
PuraMed BioScience Inc

DOTRONIX INC

母公司在Compustat里叫WIND ENERGY AMERICA INC, GVKEY 4051,在CRSP叫DOTRONIX INC, Permno 30577。但是信息停止于1999年。母公司后来就从主板去了OTC。另外spinoff正确时间应为12APR2007。



http://www.sec.gov/Archives/edgar/data/351809/000101629508000087/frm10qsb-31mar2008.htm


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


Comp - Parent


Wind - Linktable



CRSP - Parent


http://www.otcbb.com/asp/dailylist_search.asp?DirectSymbol=DOTX&OTCBB=True
=================================================================

17OCT2003
ADA-ES LLC

EARTH SCIENCES INC

母公司 1999年后,也从主板变成了OTC。正式Spin off时间应为29AUG2003。


http://www.sec.gov/Archives/edgar/data/1223112/000105050204000153/adaes1203.txt


http://www.otcbb.com/asp/dailylist_search.asp?DirectSymbol=ESCI&OTCBB=True
=================================================================

31OCT2005
Amber Capital LP
GENERAL ELECTRIC LTD

母公司是SOCIETE GENERALE GROUP,GVKEY 15784, 但它是OTC。


http://investing.businessweek.com/research/stocks/private/snapshot.asp?privcapId=24584312


https://www.google.com/finance?cid=664071
=================================================================


06DEC2010

TCW Energy & Infrastructure

母公司应该是The TCW Group, Inc.,但这是个Private firm。


https://www.google.com/finance?q=The+TCW+Group%2C+Inc.&ei=2Z3WU5CyM4e28wb_0YGADA


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


28DEC1983
Energas Co

Energas Permno 32986, IPO在1983年12月28日。母公司是Pioneer Corporation, Compustat Names文件里有好多Pioneer开始的公司。我觉得应该是Pioneer Corporation -Texas,GVKEY 8592。这个和Pioneer Corporation - OLD都一点出入,但他们共用同样的Permno 48370。




http://en.wikipedia.org/wiki/Atmos_Energy



=================================================================
31DEC1986 TW Services(Transworld Corp)
Q:不如把日期变成
30DEC1986吧???
母公司Permno 19617。

子公司Permno 72792。

(1) TW services是被TWA spin off的。

这个故事很多版本

http://www.corporatetrivia.com/archive/usa/28.html

(2)1980年中期,TW spinoff TWA



http://www.fundinguniverse.com/company-histories/advantica-restaurant-group-inc-history/

(3) TW后来改名叫TW Services



CRSP - TWA
值得注意的是# of shares outstanding在1986.12.31突然变化了。


CRSP - transworld corp
ticker从TW变化到TWT,1986.12.31,没有return。

=================================================================
18JUL2001
Extreme Media

母公司是pink sheet.
tic: PABN
http://www.thefreelibrary.com/PanAmerican+BanCorp.%2FPABN+-+PanAmerican+Announces+Spin-off+of+Extreme...-a076453940


http://www.otcmarkets.com/stock/PABN/quote=================================================================

23APR1993
AptarGroup Inc
PITTWAY CORP

母公司是PITTWAY CORP没错。但PITTWAY CORP在1989年重组过一次。之后的Permno应为75946。GVKEY 10006。

Aptargroup是上市公司,SDC信息没错。



http://investors.aptar.com/phoenix.zhtml?c=109617&p=irol-faq_pf#30727


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



d