reportDate

ratio

endQuaterAffected

dayFrom

dayTo

Cusip

entryId	groupId	EQUITY	CHANGE	CUSIP	DESCRIPTION	ISSUE STATUS CODE	ISSUE TYPE CODE	ADD DATE	EXPIRATION DATE	PAYMENT FREQUENCY CODE	MARGIN FLAG	OPTION FLAG	CONVERTED CUSIP	NASDAQ MARKET CODE	INDEX ISSUER	CHANGE DATE	MERGENT CHANGE DATE	MATURE DATE	undefined1	undefined2	undefined3	undefined4	temp1	temp2	fileName	fileDate	processDate
1448965	1448965	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	L	A	2010-12-02	2014-02-19	0	no	no		no		?	2014-02-19	?							20140225.ifs	2014-02-25	2014-02-26
1448966	1448965	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	L	A	2010-12-02	2014-02-25	0	no	no		no		?	2014-02-25	?							20140225.ifs	2014-02-25	2014-02-26
1448967	1448967	CORPACTION	ADD	73936Q785	04	L	2014-02-25			?															20140225.ifs	2014-02-25	2014-02-26
1449069	1449069	CORPACTION	DELETE	73936Q785	04	L	2014-02-25			?															20140225.ifs	2014-02-25	2014-02-26
1449071	1449070	CORPACTION	DELETE	73936Q785	04	L	2014-02-19			2014-02-19															20140225.ifs	2014-02-25	2014-02-26
1449072	1449071	CORPACTION	DELETE	73936Q785	04	L	2014-02-19			2014-02-25															20140225.ifs	2014-02-25	2014-02-26
1449073	1449073	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	L	A	2010-12-02	2014-02-25	0	no	no		no		?	2014-02-25	?							20140225.ifs	2014-02-25	2014-02-26
1449074	1449073	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	L	A	2010-12-02	2014-02-19	0	no	no		no		?	2014-02-25	?							20140225.ifs	2014-02-25	2014-02-26
1445887	1445887	CORPACTION	ADD	73936Q785	04	L	2014-02-19			2014-02-19															20140219.ifs	2014-02-19	2014-02-20
1445888	1445888	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	0	A	2010-12-02	?	0	no	no		no		?	2010-12-02	?							20140219.ifs	2014-02-19	2014-02-20
1445889	1445888	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	L	A	2010-12-02	2014-02-19	0	no	no		no		?	2014-02-19	?							20140219.ifs	2014-02-19	2014-02-20
1443353	1443353	DIVIDEND	CHANGE	73936Q785		0	0	1	0	.32443		00	2013-12-20	2013-12-24	2013-12-31	2013-12-19		0	2013-12-19	?	0	0004694915			20140213.ifs	2014-02-13	2014-02-14
1443354	1443353	DIVIDEND	CHANGE	73936Q785		0	0	1	0	.32443		00	2013-12-20	2013-12-24	2013-12-31	2013-12-19		1	2013-12-19	2014-02-13	0	0004694915			20140213.ifs	2014-02-13	2014-02-14
1384146	1384146	DIVIDEND	ADD	73936Q785		0	0	1	0	.32443		00	2013-12-20	2013-12-24	2013-12-31	2013-12-19		0	2013-12-19	?	0	0004694915			20131219.ifs	2013-12-19	2013-12-20
1291081	1291081	DIVIDEND	ADD	73936Q785		0	0	1	0	.08418		00	2013-09-20	2013-09-24	2013-09-30	2013-09-19		0	2013-09-19	?	0	0004631370			20130919.ifs	2013-09-19	2013-09-20
1213207	1213207	DIVIDEND	ADD	73936Q785		0	0	1	0	.31305		00	2013-06-21	2013-06-25	2013-06-28	2013-06-20		0	2013-06-20	?	0	0004586510			20130620.ifs	2013-06-20	2013-06-21
1133106	1133106	DIVIDEND	ADD	73936Q785		0	0	1	0	.04346		00	2013-03-15	2013-03-19	2013-03-28	2013-03-14		0	2013-03-14	?	0	0004541240			20130314.ifs	2013-03-14	2013-03-15
1052429	1052429	DIVIDEND	ADD	73936Q785		0	0	1	0	.74339		00	2012-12-21	2012-12-26	2012-12-31	2012-12-20		0	2012-12-20	?	0	0004489297			20121220.ifs	2012-12-20	2012-12-21
960357	960357	DIVIDEND	ADD	73936Q785		0	0	1	0	.30234		00	2012-09-21	2012-09-25	2012-09-28	2012-09-20		0	2012-09-20	?	0	0004431692			20120920.ifs	2012-09-20	2012-09-21
885128	885128	DIVIDEND	ADD	73936Q785		0	0	1	0	.10782		00	2012-06-15	2012-06-19	2012-06-29	2012-06-14		0	2012-06-14	?	0	0004386354			20120614.ifs	2012-06-14	2012-06-15
802981	802981	DIVIDEND	ADD	73936Q785		0	0	1	0	.0578		00	2012-03-16	2012-03-20	2012-03-30	2012-03-15		0	2012-03-15	?	0	0004346060			20120315.ifs	2012-03-15	2012-03-16
723739	723739	DIVIDEND	ADD	73936Q785		0	0	1	0	.20808		00	2011-12-16	2011-12-20	2011-12-30	2011-12-15		0	2011-12-15	?	0	0004289611			20111215.ifs	2011-12-15	2011-12-16
643922	643922	DIVIDEND	ADD	73936Q785		0	0	1	0	.05129		00	2011-09-16	2011-09-20	2011-09-30	2011-09-15		0	2011-09-15	?	0	0004242828			20110915.ifs	2011-09-15	2011-09-16
561704	561704	DIVIDEND	ADD	73936Q785		0	0	1	0	.27809		00	2011-06-17	2011-06-21	2011-06-30	2011-06-16		0	2011-06-16	?	0	0004201812			20110616.ifs	2011-06-16	2011-06-17
473550	473550	DIVIDEND	ADD	73936Q785		0	0	1	4	.11499		00	2011-03-18	2011-03-22	2011-03-31	2011-03-17		0	2011-03-17	?	0	0004160301			20110317.ifs	2011-03-17	2011-03-18
367641	367641	EQUITY	ADD	73936Q785	NEW ISSUE	0	0	2010-12-02	?	0	no	no		no		?	?	?							20101202.ifs	2010-12-02	2010-12-03
367642	367642	EQUITY	CHANGE	73936Q785	NEW ISSUE	0	0	2010-12-02	?	0	no	no		no		?	?	?							20101202.ifs	2010-12-02	2010-12-03
367643	367642	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	N	A	2010-12-02	?	0	no	no		no		?	2010-12-02	?							20101202.ifs	2010-12-02	2010-12-03
367644	367644	EXCHANGE	ADD	73936Q785	04	2010-12-02	2010-12-02	KBWX	0	A	?	2010-12-02													20101202.ifs	2010-12-02	2010-12-03
367665	367665	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	N	A	2010-12-02	?	0	no	no		no		?	2010-12-02	?							20101202.ifs	2010-12-02	2010-12-03
367666	367665	EQUITY	CHANGE	73936Q785	KBW GLOBAL EX-US FINL SECTOR PORT	0	A	2010-12-02	?	0	no	no		no		?	2010-12-02	?							20101202.ifs	2010-12-02	2010-12-03

Old Cusip

entryId

groupId

EQUITY

CHANGE

CUSIP

DESCRIPTION

ISSUE STATUS CODE

ISSUE TYPE CODE

ADD DATE

EXPIRATION DATE

PAYMENT FREQUENCY CODE

MARGIN FLAG

OPTION FLAG

CONVERTED CUSIP

NASDAQ MARKET CODE

INDEX ISSUER

CHANGE DATE

MERGENT CHANGE DATE

MATURE DATE

undefined1

undefined2

undefined3

undefined4

temp1

temp2

fileName

fileDate

processDate

BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 159786
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC