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
2275573	2275573	CORPACTION	ADD	46429B382	60	L	2016-08-24			?															20160824.ifs	2016-08-24	2016-08-25
2275574	2275574	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER ETF	0	A	2012-01-19	?	0	no	no		yes		2012-01-19	2013-07-01	?							20160824.ifs	2016-08-24	2016-08-25
2275575	2275574	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER ETF	L	A	2012-01-19	2016-08-24	0	no	no		yes		2012-01-19	2016-08-24	?							20160824.ifs	2016-08-24	2016-08-25
2275193	2275193	DIVIDEND	CHANGE	46429B382		0	0	1	0	.27353		00	2016-06-22	2016-06-24	2016-06-28	2016-06-21		0	2016-06-21	?	0	0005236500			20160823.ifs	2016-08-23	2016-08-24
2275194	2275193	DIVIDEND	CHANGE	46429B382		0	0	1	0	.27353		00	2016-06-22	2016-06-24	2016-06-28	2016-06-21		1	2016-06-21	2016-08-23	0	0005236500			20160823.ifs	2016-08-23	2016-08-24
2226646	2226646	DIVIDEND	ADD	46429B382		0	0	1	0	.27353		00	2016-06-22	2016-06-24	2016-06-28	2016-06-21		0	2016-06-21	?	0	0005236500			20160621.ifs	2016-06-21	2016-06-22
2066719	2066719	DIVIDEND	ADD	46429B382		0	0	1	9	.06762		03	2015-12-29	2015-12-31	2016-01-05	2015-12-28		0	2015-12-28	?	0	0005141257			20151228.ifs	2015-12-28	2015-12-29
2052958	2052958	DIVIDEND	ADD	46429B382		0	0	1	0	.285427		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005130261			20151218.ifs	2015-12-18	2015-12-19
1743900	1743900	DIVIDEND	DELETE	46429B382		0	0	1	6	0		08	2014-12-29	2014-12-31	2015-01-05	2014-01-02		1	2014-01-02	2014-12-16	1	0004718199			20141226.ifs	2014-12-26	2014-12-27
1719542	1719542	DIVIDEND	CHANGE	46429B382		0	0	1	6	0		08	2014-12-29	2014-12-31	2015-01-05	2014-01-02		0	2014-01-02	?	2	0004718199			20141216.ifs	2014-12-16	2014-12-17
1719543	1719542	DIVIDEND	CHANGE	46429B382		0	0	1	6	0		08	2014-12-29	2014-12-31	2015-01-05	2014-01-02		1	2014-01-02	2014-12-16	1	0004718199			20141216.ifs	2014-12-16	2014-12-17
1719544	1719544	DIVIDEND	DELETE	46429B382		0	0	1	6	0		08	2014-12-17	2014-12-19	2014-12-24	2014-01-02		0	2014-01-02	?	1	0004718197			20141216.ifs	2014-12-16	2014-12-17
1719545	1719545	DIVIDEND	ADD	46429B382		0	0	1	0	.387727		00	2014-12-17	2014-12-19	2014-12-24	2014-12-16		1	2014-01-02	2014-12-16	0	0004718197			20141216.ifs	2014-12-16	2014-12-17
1558928	1558928	DIVIDEND	DELETE	46429B382		0	0	1	6	0		08	2014-06-25	2014-06-27	2014-07-02	2014-01-02		0	2014-01-02	?	0	0004718196			20140624.ifs	2014-06-24	2014-06-25
1558929	1558929	DIVIDEND	ADD	46429B382		0	0	1	0	.608717		00	2014-06-25	2014-06-27	2014-07-02	2014-06-24		1	2014-01-02	2014-06-24	0	0004718196			20140624.ifs	2014-06-24	2014-06-25
1413932	1413932	DIVIDEND	ADD	46429B382		0	0	1	6	0		08	2014-12-29	2014-12-31	2015-01-05	2014-01-02		0	2014-01-02	?	2	0004718199			20140102.ifs	2014-01-02	2014-01-03
1413933	1413933	DIVIDEND	ADD	46429B382		0	0	1	6	0		08	2014-12-17	2014-12-19	2014-12-24	2014-01-02		0	2014-01-02	?	1	0004718197			20140102.ifs	2014-01-02	2014-01-03
1413934	1413934	DIVIDEND	ADD	46429B382		0	0	1	6	0		08	2014-06-25	2014-06-27	2014-07-02	2014-01-02		0	2014-01-02	?	0	0004718196			20140102.ifs	2014-01-02	2014-01-03
1396946	1396946	DIVIDEND	DELETE	46429B382		0	0	1	6	0		08	2013-12-27	2013-12-31	2014-01-03	2013-01-09		1	2013-01-09	2013-12-17	1	0004513415			20131226.ifs	2013-12-26	2013-12-27
1376881	1376881	DIVIDEND	CHANGE	46429B382		0	0	1	6	0		08	2013-12-27	2013-12-31	2014-01-03	2013-01-09		0	2013-01-09	?	2	0004513415			20131217.ifs	2013-12-17	2013-12-18
1376882	1376881	DIVIDEND	CHANGE	46429B382		0	0	1	6	0		08	2013-12-27	2013-12-31	2014-01-03	2013-01-09		1	2013-01-09	2013-12-17	1	0004513415			20131217.ifs	2013-12-17	2013-12-18
1376883	1376883	DIVIDEND	DELETE	46429B382		0	0	1	6	0		08	2013-12-18	2013-12-20	2013-12-30	2013-01-09		0	2013-01-09	?	1	0004513412			20131217.ifs	2013-12-17	2013-12-18
1376884	1376884	DIVIDEND	ADD	46429B382		0	0	1	0	.504753		00	2013-12-18	2013-12-20	2013-12-30	2013-12-17		1	2013-01-09	2013-12-17	0	0004513412			20131217.ifs	2013-12-17	2013-12-18
1226815	1226815	CORPACTION	ADD	46429B382	60	#	2013-07-01	46429B382	60	?															20130701.ifs	2013-07-01	2013-07-02
1226816	1226816	CORPACTIONAUX	ADD	46429B382	60	2013-07-01	EEML	ISHARES TR	MSCI EMERGING M	EEML	ISHARES TR	ISHARES MSCI EM	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1226817	1226817	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	0	A	2012-01-19	?	0	no	no		yes		2012-01-19	2012-01-19	?							20130701.ifs	2013-07-01	2013-07-02
1226818	1226817	EQUITY	CHANGE	46429B382	ISHARES MSCI EMERGING MARKETS LATIN AMERICA ETF	0	A	2012-01-19	?	0	no	no		yes		2012-01-19	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1228035	1228035	EQUITY	CHANGE	46429B382	ISHARES MSCI EMERGING MARKETS LATIN AMERICA ETF	0	A	2012-01-19	?	0	no	no		yes		2012-01-19	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1228036	1228035	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER ETF	0	A	2012-01-19	?	0	no	no		yes		2012-01-19	2013-07-01	?							20130701.ifs	2013-07-01	2013-07-02
1228038	1228037	EQUITY	CHANGE	46429B382	60	#	2013-07-01	46429B382	60	?															20130701.ifs	2013-07-01	2013-07-02
1228039	1228038	EQUITY	CHANGE	46429B382	60	#	2013-07-01	46429B382	60	2013-07-01															20130701.ifs	2013-07-01	2013-07-02
1228041	1228040	EQUITY	CHANGE	46429B382	60	2013-07-01	EEML	ISHARES TR	MSCI EMERGING M	EEML	ISHARES TR	ISHARES MSCI EM	2013-07-01	?											20130701.ifs	2013-07-01	2013-07-02
1228042	1228041	EQUITY	CHANGE	46429B382	60	2013-07-01	EEML	ISHARES TR	MSCI EMERGING M	EEML	ISHARES TR	MSCI EMERGING M	2013-07-01	2013-07-01											20130701.ifs	2013-07-01	2013-07-02
1218983	1218983	DIVIDEND	DELETE	46429B382		0	0	1	6	0		08	2013-06-27	2013-07-01	2013-07-05	2013-01-09		0	2013-01-09	?	0	0004513408			20130626.ifs	2013-06-26	2013-06-27
1218984	1218984	DIVIDEND	ADD	46429B382		0	0	1	0	.671049		00	2013-06-27	2013-07-01	2013-07-05	2013-06-26		1	2013-01-09	2013-06-26	0	0004513408			20130626.ifs	2013-06-26	2013-06-27
1086953	1086953	DIVIDEND	ADD	46429B382		0	0	1	6	0		08	2013-12-27	2013-12-31	2014-01-03	2013-01-09		0	2013-01-09	?	2	0004513415			20130109.ifs	2013-01-09	2013-01-10
1086954	1086954	DIVIDEND	ADD	46429B382		0	0	1	6	0		08	2013-12-18	2013-12-20	2013-12-30	2013-01-09		0	2013-01-09	?	1	0004513412			20130109.ifs	2013-01-09	2013-01-10
1086955	1086955	DIVIDEND	ADD	46429B382		0	0	1	6	0		08	2013-06-27	2013-07-01	2013-07-05	2013-01-09		0	2013-01-09	?	0	0004513408			20130109.ifs	2013-01-09	2013-01-10
1044703	1044703	DIVIDEND	ADD	46429B382		0	0	1	0	.42708		00	2012-12-18	2012-12-20	2012-12-27	2012-12-17		0	2012-12-17	?	0	0004483199			20121217.ifs	2012-12-17	2012-12-18
889576	889576	DIVIDEND	ADD	46429B382		0	0	1	4	.762777		00	2012-06-21	2012-06-25	2012-06-28	2012-06-20		0	2012-06-20	?	0	0004389210			20120620.ifs	2012-06-20	2012-06-21
758850	758850	EQUITY	ADD	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	N	7	2012-01-19	?	0	no	no		no		2012-01-19	?	?							20120119.ifs	2012-01-19	2012-01-20
758851	758851	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	N	7	2012-01-19	?	0	no	no		no		2012-01-19	?	?							20120119.ifs	2012-01-19	2012-01-20
758852	758851	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	N	7	2012-01-19	?	0	no	no		yes		2012-01-19	2012-01-19	?							20120119.ifs	2012-01-19	2012-01-20
758853	758853	EXCHANGE	ADD	46429B382	60	2012-01-19	2012-01-19	EEML	0	A	2012-01-19	?													20120119.ifs	2012-01-19	2012-01-20
759063	759063	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	N	7	2012-01-19	?	0	no	no		yes		2012-01-19	2012-01-19	?							20120119.ifs	2012-01-19	2012-01-20
759064	759063	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	N	A	2012-01-19	?	0	no	no		yes		2012-01-19	2012-01-19	?							20120119.ifs	2012-01-19	2012-01-20
759531	759531	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	N	A	2012-01-19	?	0	no	no		yes		2012-01-19	2012-01-19	?							20120119.ifs	2012-01-19	2012-01-20
759532	759531	EQUITY	CHANGE	46429B382	MSCI EMERGING MARKETS LATIN AMER INDEX FD	0	A	2012-01-19	?	0	no	no		yes		2012-01-19	2012-01-19	?							20120119.ifs	2012-01-19	2012-01-20

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 = 160360
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