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
4387942	4387942	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	S	A	2006-04-07	2020-05-28	4	no	no		no		2006-06-19	2020-05-28	?							20200609.ifs	2020-06-09	2020-06-10
4387943	4387942	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	S	A	2006-04-07	2020-06-09	4	no	no		no		2006-06-19	2020-06-09	?							20200609.ifs	2020-06-09	2020-06-10
4387944	4387944	CORPACTION	ADD	97717W828	04	L	2020-06-09			?															20200609.ifs	2020-06-09	2020-06-10
4387945	4387945	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	S	A	2006-04-07	2020-06-09	4	no	no		no		2006-06-19	2020-06-09	?							20200609.ifs	2020-06-09	2020-06-10
4387946	4387945	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	L	A	2006-04-07	2020-06-09	4	no	no		no		2006-06-19	2020-06-09	?							20200609.ifs	2020-06-09	2020-06-10
4388052	4388052	CORPACTION	DELETE	97717W828	04	S	2020-05-28			2020-05-28															20200609.ifs	2020-06-09	2020-06-10
4350813	4350813	CORPACTION	ADD	97717W828	04	S	2020-05-28			2020-05-28															20200528.ifs	2020-05-28	2020-05-29
4350814	4350814	CORPACTION	ADD	97717W828	04	S	2020-05-28			2020-05-28															20200528.ifs	2020-05-28	2020-05-29
4350815	4350815	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	0	A	2006-04-07	?	4	no	no		no		2006-06-19	2011-06-20	?							20200528.ifs	2020-05-28	2020-05-29
4350816	4350816	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	0	A	2006-04-07	?	4	no	no		no		2006-06-19	2011-06-20	?							20200528.ifs	2020-05-28	2020-05-29
4350817	4350816	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	S	A	2006-04-07	2020-05-28	4	no	no		no		2006-06-19	2020-05-28	?							20200528.ifs	2020-05-28	2020-05-29
4350818	4350817	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	S	A	2006-04-07	2020-05-28	4	no	no		no		2006-06-19	2020-05-28	?							20200528.ifs	2020-05-28	2020-05-29
4292641	4292641	DIVIDEND	CHANGE	97717W828		0	0	1	0	.24		00	2020-03-24	2020-03-25	2020-03-27	2020-03-23		0	2020-03-23	?	0	0006072195			20200417.ifs	2020-04-17	2020-04-18
4292643	4292642	DIVIDEND	CHANGE	97717W828		0	0	1	0	.24		00	2020-03-24	2020-03-25	2020-03-27	2020-03-23		1	2020-03-23	2020-04-17	0	0006072195			20200417.ifs	2020-04-17	2020-04-18
4292759	4292759	DIVIDEND	CHANGE	97717W828		0	0	1	0	.24		00	2020-03-24	2020-03-25	2020-03-27	2020-03-23		0	2020-03-23	?	0	0006072195			20200417.ifs	2020-04-17	2020-04-18
4292761	4292760	DIVIDEND	CHANGE	97717W828		0	0	1	0	.24		00	2020-03-24	2020-03-25	2020-03-27	2020-03-23		1	2020-03-23	2020-04-17	0	0006072195			20200417.ifs	2020-04-17	2020-04-18
4248293	4248293	DIVIDEND	ADD	97717W828		0	0	1	0	.24		00	2020-03-24	2020-03-25	2020-03-27	2020-03-23		0	2020-03-23	?	0	0006072195			20200323.ifs	2020-03-23	2020-03-24
4248362	4248362	DIVIDEND	ADD	97717W828		0	0	1	0	.24		00	2020-03-24	2020-03-25	2020-03-27	2020-03-23		0	2020-03-23	?	0	0006072195			20200323.ifs	2020-03-23	2020-03-24
4101714	4101714	DIVIDEND	ADD	97717W828		0	0	1	0	.36466		00	2019-12-23	2019-12-24	2019-12-27	2019-12-20		0	2019-12-20	?	0	0006018598			20191220.ifs	2019-12-20	2019-12-21
4102631	4102631	DIVIDEND	ADD	97717W828		0	0	1	0	.36466		00	2019-12-23	2019-12-24	2019-12-27	2019-12-20		0	2019-12-20	?	0	0006018598			20191220.ifs	2019-12-20	2019-12-21
3933360	3933360	DIVIDEND	ADD	97717W828		0	0	1	0	1.115		00	2019-09-24	2019-09-25	2019-09-27	2019-09-23		0	2019-09-23	?	0	0005948975			20190923.ifs	2019-09-23	2019-09-24
3933361	3933361	DIVIDEND	ADD	97717W828		0	0	1	0	1.115		00	2019-09-24	2019-09-25	2019-09-27	2019-09-23		0	2019-09-23	?	0	0005948975			20190923.ifs	2019-09-23	2019-09-24
3792190	3792190	DIVIDEND	ADD	97717W828		0	0	1	0	.59		00	2019-06-24	2019-06-25	2019-06-28	2019-06-21		0	2019-06-21	?	0	0005902442			20190621.ifs	2019-06-21	2019-06-22
3792191	3792191	DIVIDEND	ADD	97717W828		0	0	1	0	.59		00	2019-06-24	2019-06-25	2019-06-28	2019-06-21		0	2019-06-21	?	0	0005902442			20190621.ifs	2019-06-21	2019-06-22
3646094	3646094	DIVIDEND	ADD	97717W828		0	0	1	0	.42		00	2019-03-26	2019-03-27	2019-03-29	2019-03-25		0	2019-03-25	?	0	0005857586			20190325.ifs	2019-03-25	2019-03-26
3646119	3646119	DIVIDEND	ADD	97717W828		0	0	1	0	.42		00	2019-03-26	2019-03-27	2019-03-29	2019-03-25		0	2019-03-25	?	0	0005857586			20190325.ifs	2019-03-25	2019-03-26
3485459	3485459	DIVIDEND	ADD	97717W828		0	0	1	0	.36612		00	2018-12-24	2018-12-26	2018-12-28	2018-12-21		0	2018-12-21	?	0	0005802845			20181221.ifs	2018-12-21	2018-12-22
3485460	3485460	DIVIDEND	ADD	97717W828		0	0	1	0	.36612		00	2018-12-24	2018-12-26	2018-12-28	2018-12-21		0	2018-12-21	?	0	0005802845			20181221.ifs	2018-12-21	2018-12-22
3296344	3296344	DIVIDEND	ADD	97717W828		0	0	1	0	1.44546		00	2018-09-25	2018-09-26	2018-09-28	2018-09-24		0	2018-09-24	?	0	0005727848			20180924.ifs	2018-09-24	2018-09-25
3296349	3296349	DIVIDEND	ADD	97717W828		0	0	1	0	1.44546		00	2018-09-25	2018-09-26	2018-09-28	2018-09-24		0	2018-09-24	?	0	0005727848			20180924.ifs	2018-09-24	2018-09-25
3153548	3153548	DIVIDEND	ADD	97717W828		0	0	1	0	.64616		00	2018-06-25	2018-06-26	2018-06-28	2018-06-22		0	2018-06-22	?	0	0005679915			20180622.ifs	2018-06-22	2018-06-23
3153549	3153549	DIVIDEND	ADD	97717W828		0	0	1	0	.64616		00	2018-06-25	2018-06-26	2018-06-28	2018-06-22		0	2018-06-22	?	0	0005679915			20180622.ifs	2018-06-22	2018-06-23
2996471	2996471	DIVIDEND	ADD	97717W828		0	0	1	0	.25385		00	2018-03-20	2018-03-21	2018-03-23	2018-03-19		0	2018-03-19	?	0	0005630991			20180319.ifs	2018-03-19	2018-03-20
2996472	2996472	DIVIDEND	ADD	97717W828		0	0	1	0	.25385		00	2018-03-20	2018-03-21	2018-03-23	2018-03-19		0	2018-03-19	?	0	0005630991			20180319.ifs	2018-03-19	2018-03-20
2863127	2863127	DIVIDEND	ADD	97717W828		0	0	1	0	.25335		00	2017-12-26	2017-12-27	2017-12-29	2017-12-22		0	2017-12-22	?	0	0005579420			20171222.ifs	2017-12-22	2017-12-23
2863200	2863200	DIVIDEND	ADD	97717W828		0	0	1	0	.25335		00	2017-12-26	2017-12-27	2017-12-29	2017-12-22		0	2017-12-22	?	0	0005579420			20171222.ifs	2017-12-22	2017-12-23
2686008	2686008	DIVIDEND	ADD	97717W828		0	0	1	0	1.245		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005501910			20170925.ifs	2017-09-25	2017-09-26
2686057	2686057	DIVIDEND	ADD	97717W828		0	0	1	0	1.245		00	2017-09-26	2017-09-27	2017-09-29	2017-09-25		0	2017-09-25	?	0	0005501910			20170925.ifs	2017-09-25	2017-09-26
2599884	2599884	DIVIDEND	ADD	97717W828		0	0	1	0	.455		00	2017-06-26	2017-06-28	2017-06-30	2017-06-23		0	2017-06-23	?	0	0005454348			20170623.ifs	2017-06-23	2017-06-24
2519340	2519340	DIVIDEND	ADD	97717W828		0	0	1	0	.22		00	2017-03-27	2017-03-29	2017-03-31	2017-03-24		0	2017-03-24	?	0	0005407541			20170324.ifs	2017-03-24	2017-03-25
2447902	2447902	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	0	A	2006-04-07	?	0	no	no		no		2006-06-19	2011-06-20	?							20170123.ifs	2017-01-23	2017-01-24
2447903	2447902	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	0	A	2006-04-07	?	4	no	no		no		2006-06-19	2011-06-20	?							20170123.ifs	2017-01-23	2017-01-24
2392880	2392880	DIVIDEND	ADD	97717W828		0	0	1	0	.30803		00	2016-12-23	2016-12-28	2016-12-30	2016-12-22		0	2016-12-22	?	0	0005352399			20161222.ifs	2016-12-22	2016-12-23
2300844	2300844	DIVIDEND	ADD	97717W828		0	0	1	0	.94		00	2016-09-26	2016-09-28	2016-09-30	2016-09-23		0	2016-09-23	?	0	0005284985			20160923.ifs	2016-09-23	2016-09-24
2223736	2223736	DIVIDEND	ADD	97717W828		0	0	1	0	.46		00	2016-06-20	2016-06-22	2016-06-24	2016-06-17		0	2016-06-17	?	0	0005234893			20160617.ifs	2016-06-17	2016-06-18
2138233	2138233	DIVIDEND	ADD	97717W828		0	0	1	0	.19		00	2016-03-21	2016-03-23	2016-03-28	2016-03-18		0	2016-03-18	?	0	0005189385			20160318.ifs	2016-03-18	2016-03-19
2051037	2051037	DIVIDEND	ADD	97717W828		0	0	1	0	.17874		00	2015-12-21	2015-12-23	2015-12-28	2015-12-18		0	2015-12-18	?	0	0005129980			20151218.ifs	2015-12-18	2015-12-19
1969062	1969062	DIVIDEND	ADD	97717W828		0	0	1	0	1.0775		00	2015-09-21	2015-09-23	2015-09-25	2015-09-18		0	2015-09-18	?	0	0005064645			20150918.ifs	2015-09-18	2015-09-19
1890875	1890875	DIVIDEND	ADD	97717W828		0	0	1	0	.60875		00	2015-06-22	2015-06-24	2015-06-26	2015-06-19		0	2015-06-19	?	0	0005016971			20150619.ifs	2015-06-19	2015-06-20
1816905	1816905	DIVIDEND	ADD	97717W828		0	0	1	0	.023143		00	2015-03-23	2015-03-25	2015-03-27	2015-03-20		0	2015-03-20	?	0	0004971724			20150320.ifs	2015-03-20	2015-03-21
1726059	1726059	DIVIDEND	ADD	97717W828		0	0	1	0	.29643		00	2014-12-19	2014-12-23	2014-12-26	2014-12-18		0	2014-12-18	?	0	0004908822			20141218.ifs	2014-12-18	2014-12-19
1634115	1634115	DIVIDEND	ADD	97717W828		0	0	1	0	1.01429		00	2014-09-22	2014-09-24	2014-09-26	2014-09-19		0	2014-09-19	?	0	0004845667			20140919.ifs	2014-09-19	2014-09-20
1554975	1554975	DIVIDEND	ADD	97717W828		0	0	1	0	.72286		00	2014-06-23	2014-06-25	2014-06-27	2014-06-20		0	2014-06-20	?	0	0004799970			20140620.ifs	2014-06-20	2014-06-21
1473201	1473201	DIVIDEND	ADD	97717W828		0	0	1	0	.31101		00	2014-03-24	2014-03-26	2014-03-28	2014-03-21		0	2014-03-21	?	0	0004753792			20140321.ifs	2014-03-21	2014-03-22
1391727	1391727	DIVIDEND	ADD	97717W828		0	0	1	0	.26271		00	2013-12-24	2013-12-27	2013-12-31	2013-12-23		0	2013-12-23	?	0	0004702248			20131223.ifs	2013-12-23	2013-12-24
1292496	1292496	DIVIDEND	ADD	97717W828		0	0	1	0	.75004		00	2013-09-23	2013-09-25	2013-09-27	2013-09-20		0	2013-09-20	?	0	0004631950			20130920.ifs	2013-09-20	2013-09-21
1214314	1214314	DIVIDEND	ADD	97717W828		0	0	1	0	.89942		00	2013-06-24	2013-06-26	2013-06-28	2013-06-21		0	2013-06-21	?	0	0004587547			20130621.ifs	2013-06-21	2013-06-22
1138311	1138311	DIVIDEND	ADD	97717W828		0	0	1	0	.16914		00	2013-03-22	2013-03-26	2013-03-28	2013-03-21		0	2013-03-21	?	0	0004544336			20130321.ifs	2013-03-21	2013-03-22
1055241	1055241	DIVIDEND	ADD	97717W828		0	0	1	0	.39238		00	2012-12-24	2012-12-27	2012-12-31	2012-12-21		0	2012-12-21	?	0	0004492410			20121221.ifs	2012-12-21	2012-12-22
961707	961707	DIVIDEND	ADD	97717W828		0	0	1	0	.88136		00	2012-09-24	2012-09-26	2012-09-28	2012-09-21		0	2012-09-21	?	0	0004432553			20120921.ifs	2012-09-21	2012-09-22
891836	891836	DIVIDEND	ADD	97717W828		0	0	1	0	.83097		00	2012-06-25	2012-06-27	2012-06-29	2012-06-22		0	2012-06-22	?	0	0004390614			20120622.ifs	2012-06-22	2012-06-23
809302	809302	DIVIDEND	ADD	97717W828		0	0	1	0	.22042		00	2012-03-26	2012-03-28	2012-03-30	2012-03-23		0	2012-03-23	?	0	0004349411			20120323.ifs	2012-03-23	2012-03-24
732403	732403	DIVIDEND	ADD	97717W828		0	0	1	0	.38304		00	2011-12-21	2011-12-23	2011-12-28	2011-12-20		0	2011-12-20	?	0	0004296705			20111220.ifs	2011-12-20	2011-12-21
651675	651675	DIVIDEND	ADD	97717W828		0	0	1	0	.73212		00	2011-09-26	2011-09-28	2011-09-30	2011-09-23		0	2011-09-23	?	0	0004246334			20110923.ifs	2011-09-23	2011-09-24
565408	565408	DIVIDEND	ADD	97717W828		0	0	1	0	.89432		00	2011-06-22	2011-06-24	2011-06-28	2011-06-21		0	2011-06-21	?	0	0004203862			20110621.ifs	2011-06-21	2011-06-22
563825	563825	CORPACTION	ADD	97717W828	04	#	2011-06-20	97717W828	04	?															20110620.ifs	2011-06-20	2011-06-21
563826	563826	CORPACTIONAUX	ADD	97717W828	04	2011-06-20	DND	WISDOMTREE TR	PAC EX-JP TTL D	AXJL	WISDOMTREE TR	PAC EX-JP TTL D	2011-06-20	?											20110620.ifs	2011-06-20	2011-06-21
563827	563827	EXCHANGE	CHANGE	97717W828	04	2007-10-11	2011-06-17	DND	0	A	?	2008-03-25													20110620.ifs	2011-06-20	2011-06-21
563828	563827	EXCHANGE	CHANGE	97717W828	04	2007-10-11	2011-06-17	AXJL	0	A	?	2011-06-20													20110620.ifs	2011-06-20	2011-06-21
564042	564042	EQUITY	CHANGE	97717W828	PAC EX-JP TTL DIVID FD	0	A	2006-04-07	?	0	no	no		no		2006-06-19	2008-03-25	?							20110620.ifs	2011-06-20	2011-06-21
564043	564042	EQUITY	CHANGE	97717W828	ASIA PACIFIC EX JAPAN FD	0	A	2006-04-07	?	0	no	no		no		2006-06-19	2011-06-20	?							20110620.ifs	2011-06-20	2011-06-21
564045	564044	EQUITY	CHANGE	97717W828	04	#	2011-06-20	97717W828	04	?															20110620.ifs	2011-06-20	2011-06-21
564046	564045	EQUITY	CHANGE	97717W828	04	#	2011-06-20	97717W828	04	2011-06-20															20110620.ifs	2011-06-20	2011-06-21
564048	564047	EQUITY	CHANGE	97717W828	04	2011-06-20	DND	WISDOMTREE TR	PAC EX-JP TTL D	AXJL	WISDOMTREE TR	PAC EX-JP TTL D	2011-06-20	?											20110620.ifs	2011-06-20	2011-06-21
564049	564048	EQUITY	CHANGE	97717W828	04	2011-06-20	DND	WISDOMTREE TR	PAC EX-JP TTL D	AXJL	WISDOMTREE TR	ASIA PACIFIC EX	2011-06-20	2011-06-20											20110620.ifs	2011-06-20	2011-06-21
474536	474536	DIVIDEND	ADD	97717W828		0	0	1	0	.50642		00	2011-03-21	2011-03-23	2011-03-25	2011-03-18		0	2011-03-18	?	0	0004161044			20110318.ifs	2011-03-18	2011-03-19
388244	388244	DIVIDEND	ADD	97717W828		0	0	1	0	.57084		00	2010-12-22	2010-12-27	2010-12-29	2010-12-21		0	2010-12-21	?	0	0004114043			20101221.ifs	2010-12-21	2010-12-22
309680	309680	DIVIDEND	ADD	97717W828		0	0	1	0	.78538		00	2010-09-20	2010-09-22	2010-09-24	2010-09-17		0	2010-09-17	?	0	0004061445			20100917.ifs	2010-09-17	2010-09-18
229357	229357	DIVIDEND	ADD	97717W828		0	0	1	0	.64921		00	2010-06-28	2010-06-30	2010-07-02	2010-06-25		0	2010-06-25	?	0	0004023302			20100625.ifs	2010-06-25	2010-06-26
141785	141785	DIVIDEND	ADD	97717W828		0	0	1	0	.35235		00	2010-03-29	2010-03-31	2010-04-05	2010-03-26		0	2010-03-26	?	0	0003983025			20100326.ifs	2010-03-26	2010-04-07
55366	55366	DIVIDEND	ADD	97717W828		0	0	1	0	.3585		00	2009-12-21	2009-12-23	2009-12-28	2009-12-18		0	2009-12-18	?	0	0003932240			20091218.ifs	2009-12-18	2010-04-07

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