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
5442338	5442338	DIVIDEND	DELETE	15126Q208		B	0	1	5	.493276		39	2023-11-22	2023-11-24	2023-12-19	2023-11-09		0	2023-11-09	?	0	0006811003			20231214.ifs	2023-12-14	2023-12-15
5442339	5442339	DIVIDEND	ADD	15126Q208		B	0	1	0	.493547		02	2023-11-22	2023-11-24	2023-12-19	2023-11-09		1	2023-11-09	2023-12-14	0	0006811003			20231214.ifs	2023-12-14	2023-12-15
5412900	5412900	DIVIDEND	ADD	15126Q208		B	0	1	5	.493276		39	2023-11-22	2023-11-24	2023-12-19	2023-11-09		0	2023-11-09	?	0	0006811003			20231109.ifs	2023-11-09	2023-11-10
5162886	5162886	DIVIDEND	DELETE	15126Q208		B	0	1	5	.480809		39	2022-11-16	2022-11-17	2022-12-15	2022-10-14		1	2022-10-14	2022-12-08	0	0006600013			20221212.ifs	2022-12-12	2022-12-13
5162887	5162887	DIVIDEND	ADD	15126Q208		B	0	1	0	.494933		02	2022-11-16	2022-11-17	2022-12-15	2022-10-14		2	2022-10-14	2022-12-12	0	0006600013			20221212.ifs	2022-12-12	2022-12-13
5158733	5158733	DIVIDEND	DELETE	15126Q208		B	0	1	5	.480809		39	2022-11-16	2022-11-17	2022-12-12	2022-10-14		0	2022-10-14	?	0	0006600013			20221208.ifs	2022-12-08	2022-12-09
5158734	5158734	DIVIDEND	ADD	15126Q208		B	0	1	5	.480809		39	2022-11-16	2022-11-17	2022-12-15	2022-10-14		1	2022-10-14	2022-12-08	0	0006600013			20221208.ifs	2022-12-08	2022-12-09
5121029	5121029	DIVIDEND	ADD	15126Q208		B	0	1	5	.480809		39	2022-11-16	2022-11-17	2022-12-12	2022-10-14		0	2022-10-14	?	0	0006600013			20221014.ifs	2022-10-14	2022-10-15
4754923	4754923	DIVIDEND	DELETE	15126Q208		B	0	1	5	.977709		39	2021-06-21	2021-06-22	2021-07-13	2021-05-20		0	2021-05-20	?	0	0006309802			20210708.ifs	2021-07-08	2021-07-09
4754924	4754924	DIVIDEND	ADD	15126Q208		B	0	1	0	.920328		02	2021-06-21	2021-06-22	2021-07-13	2021-05-20		1	2021-05-20	2021-07-08	0	0006309802			20210708.ifs	2021-07-08	2021-07-09
4709095	4709095	DIVIDEND	ADD	15126Q208		B	0	1	5	.977709		39	2021-06-21	2021-06-22	2021-07-13	2021-05-20		0	2021-05-20	?	0	0006309802			20210520.ifs	2021-05-20	2021-05-21
4564545	4564545	DIVIDEND	DELETE	15126Q208		B	0	1	5	.297921		39	2020-12-04	2020-12-07	2020-12-28	2020-11-19		0	2020-11-19	?	0	0006189649			20201221.ifs	2020-12-21	2020-12-22
4564546	4564546	DIVIDEND	ADD	15126Q208		B	0	1	0	.297318		02	2020-12-04	2020-12-07	2020-12-28	2020-11-19		1	2020-11-19	2020-12-21	0	0006189649			20201221.ifs	2020-12-21	2020-12-22
4564547	4564547	EQUITY	CHANGE	15126Q208	SPONSORED ADR NEW	0	0	2017-03-03	?	0	no	no		no		2017-03-03	2017-03-06	?							20201221.ifs	2020-12-21	2020-12-22
4564548	4564547	EQUITY	CHANGE	15126Q208	SPONSORED ADR NEW	0	0	2017-03-03	?	1	no	no		no		2017-03-03	2017-03-06	?							20201221.ifs	2020-12-21	2020-12-22
4510194	4510194	DIVIDEND	ADD	15126Q208		B	0	1	5	.297921		39	2020-12-04	2020-12-07	2020-12-28	2020-11-19		0	2020-11-19	?	0	0006189649			20201119.ifs	2020-11-19	2020-11-20
4099372	4099372	DIVIDEND	DELETE	15126Q208		B	0	1	5	.481172		39	2019-12-06	2019-12-09	2019-12-26	2019-11-26		0	2019-11-26	?	0	0005979053			20191219.ifs	2019-12-19	2019-12-20
4099374	4099374	DIVIDEND	ADD	15126Q208		B	0	1	0	.488138		02	2019-12-06	2019-12-09	2019-12-26	2019-11-26		1	2019-11-26	2019-12-19	0	0005979053			20191219.ifs	2019-12-19	2019-12-20
4100036	4100036	DIVIDEND	DELETE	15126Q208		B	0	1	5	.481172		39	2019-12-06	2019-12-09	2019-12-26	2019-11-26		0	2019-11-26	?	0	0005979053			20191219.ifs	2019-12-19	2019-12-20
4100038	4100038	DIVIDEND	ADD	15126Q208		B	0	1	0	.488138		02	2019-12-06	2019-12-09	2019-12-26	2019-11-26		1	2019-11-26	2019-12-19	0	0005979053			20191219.ifs	2019-12-19	2019-12-20
4029166	4029166	DIVIDEND	ADD	15126Q208		B	0	1	5	.481172		39	2019-12-06	2019-12-09	2019-12-26	2019-11-26		0	2019-11-26	?	0	0005979053			20191126.ifs	2019-11-26	2019-11-27
4029167	4029167	DIVIDEND	ADD	15126Q208		B	0	1	5	.481172		39	2019-12-06	2019-12-09	2019-12-26	2019-11-26		0	2019-11-26	?	0	0005979053			20191126.ifs	2019-11-26	2019-11-27
3392223	3392223	DIVIDEND	DELETE	15126Q208		B	0	1	5	.527892		39	2018-11-08	2018-11-09	2018-12-06	2018-09-28		0	2018-09-28	?	0	0005731981			20181130.ifs	2018-11-30	2018-12-01
3392225	3392225	DIVIDEND	ADD	15126Q208		B	0	1	0	.513549		02	2018-11-08	2018-11-09	2018-12-06	2018-09-28		1	2018-09-28	2018-11-30	0	0005731981			20181130.ifs	2018-11-30	2018-12-01
3392288	3392288	DIVIDEND	DELETE	15126Q208		B	0	1	5	.527892		39	2018-11-08	2018-11-09	2018-12-06	2018-09-28		0	2018-09-28	?	0	0005731981			20181130.ifs	2018-11-30	2018-12-01
3392290	3392290	DIVIDEND	ADD	15126Q208		B	0	1	0	.513549		02	2018-11-08	2018-11-09	2018-12-06	2018-09-28		1	2018-09-28	2018-11-30	0	0005731981			20181130.ifs	2018-11-30	2018-12-01
3309756	3309756	DIVIDEND	ADD	15126Q208		B	0	1	5	.527892		39	2018-11-08	2018-11-09	2018-12-06	2018-09-28		0	2018-09-28	?	0	0005731981			20180928.ifs	2018-09-28	2018-09-29
3309768	3309768	DIVIDEND	ADD	15126Q208		B	0	1	5	.527892		39	2018-11-08	2018-11-09	2018-12-06	2018-09-28		0	2018-09-28	?	0	0005731981			20180928.ifs	2018-09-28	2018-09-29
2794594	2794594	DIVIDEND	DELETE	15126Q208		B	0	1	4	.496942		39	2017-11-14	2017-11-15	2017-12-07	2017-11-03		0	2017-11-03	?	0	0005527545			20171204.ifs	2017-12-04	2017-12-05
2794596	2794596	DIVIDEND	ADD	15126Q208		B	0	1	4	.49817		02	2017-11-14	2017-11-15	2017-12-07	2017-11-03		1	2017-11-03	2017-12-01	0	0005527545			20171204.ifs	2017-12-04	2017-12-05
2794649	2794649	DIVIDEND	DELETE	15126Q208		B	0	1	4	.496942		39	2017-11-14	2017-11-15	2017-12-07	2017-11-03		0	2017-11-03	?	0	0005527545			20171204.ifs	2017-12-04	2017-12-05
2794651	2794651	DIVIDEND	ADD	15126Q208		B	0	1	4	.49817		02	2017-11-14	2017-11-15	2017-12-07	2017-11-03		1	2017-11-03	2017-12-01	0	0005527545			20171204.ifs	2017-12-04	2017-12-05
2756786	2756786	DIVIDEND	ADD	15126Q208		B	0	1	4	.496942		39	2017-11-14	2017-11-15	2017-12-07	2017-11-03		0	2017-11-03	?	0	0005527545			20171103.ifs	2017-11-03	2017-11-04
2756787	2756787	DIVIDEND	ADD	15126Q208		B	0	1	4	.496942		39	2017-11-14	2017-11-15	2017-12-07	2017-11-03		0	2017-11-03	?	0	0005527545			20171103.ifs	2017-11-03	2017-11-04
2507745	2507745	EQUITY	CHANGE	15126Q208	SPONSORED ADR NEW	N	0	2017-03-03	?	0	no	no		no		2017-03-03	?	?							20170306.ifs	2017-03-06	2017-03-07
2507746	2507745	EQUITY	CHANGE	15126Q208	SPONSORED ADR NEW	0	0	2017-03-03	?	0	no	no		no		2017-03-03	2017-03-06	?							20170306.ifs	2017-03-06	2017-03-07
2507101	2507101	EQUITY	ADD	15126Q208	SPONSORED ADR NEW	N	0	2017-03-03	?	0	no	no		no		2017-03-03	?	?							20170303.ifs	2017-03-03	2017-03-04
2507102	2507102	EXCHANGE	ADD	15126Q208	01	2017-03-03	2017-03-03	CPAC	0	0	2017-03-03	?													20170303.ifs	2017-03-03	2017-03-04

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
2506898	2506898	DIVIDEND	DELETE	15126Q109	Ex-date to be determined by NYS. 0.2024475 shs of Fossal S.A.A A	0	0	7	0	.20245	0	20	?	?	?	2017-02-22	34988L108	0	2017-02-22	2017-02-23	0	0005390351			20170303.ifs	2017-03-03	2017-03-04
2507184	2507184	CORPACTION	ADD	15126Q109	01	V	2017-03-03	15126Q208	01	?															20170303.ifs	2017-03-03	2017-03-04
2507185	2507185	EQUITY	CHANGE	15126Q109	ADR	0	0	2012-02-08	?	1	no	no		no		2012-02-08	?	?							20170303.ifs	2017-03-03	2017-03-04
2507186	2507185	EQUITY	CHANGE	15126Q109	ADR	V	0	2012-02-08	2017-03-03	1	no	no	15126Q208	no		2012-02-08	2017-03-03	?							20170303.ifs	2017-03-03	2017-03-04
2493913	2493913	DIVIDEND	ADD	15126Q109		0	0	7	0	.20245		20	?	?	?	2017-02-22	34988L108	0	2017-02-22	?	0	0005390351			20170222.ifs	2017-02-22	2017-02-23
2457685	2457685	EQUITY	CHANGE	15126Q109	ADR	0	0	2012-02-08	?	0	no	no		no		2012-02-08	?	?							20170126.ifs	2017-01-26	2017-01-27
2457686	2457685	EQUITY	CHANGE	15126Q109	ADR	0	0	2012-02-08	?	1	no	no		no		2012-02-08	?	?							20170126.ifs	2017-01-26	2017-01-27
2346788	2346788	DIVIDEND	DELETE	15126Q109		B	0	1	5	.386537		39	2016-09-07	2016-09-09	2016-11-22	2016-08-24		1	2016-08-24	2016-08-25	0	0005268510			20161121.ifs	2016-11-21	2016-11-22
2346789	2346789	DIVIDEND	ADD	15126Q109		B	0	1	0	.379817		02	2016-09-07	2016-09-09	2016-11-22	2016-08-24		2	2016-08-24	2016-11-21	0	0005268510			20161121.ifs	2016-11-21	2016-11-22
2277213	2277213	DIVIDEND	CHANGE	15126Q109		B	0	1	5	.375091		39	2016-09-07	2016-09-09	2016-11-22	2016-08-24		0	2016-08-24	?	0	0005268510			20160825.ifs	2016-08-25	2016-08-26
2277214	2277213	DIVIDEND	CHANGE	15126Q109		B	0	1	5	.386537		39	2016-09-07	2016-09-09	2016-11-22	2016-08-24		1	2016-08-24	2016-08-25	0	0005268510			20160825.ifs	2016-08-25	2016-08-26
2276043	2276043	DIVIDEND	ADD	15126Q109		B	0	1	5	.375091		39	2016-09-07	2016-09-09	2016-11-22	2016-08-24		0	2016-08-24	?	0	0005268510			20160824.ifs	2016-08-24	2016-08-25
1994670	1994670	DIVIDEND	CHANGE	15126Q109		B	0	1	0	.391588	0	02	2015-10-01	2015-10-05	2015-10-26	2015-09-08		1	2015-09-08	2015-10-21	0	0005060238			20151022.ifs	2015-10-22	2015-10-23
1994671	1994670	DIVIDEND	CHANGE	15126Q109	Ex-date corresponds with foreign ex-date.	B	0	1	0	.391588	0	02	2015-10-01	2015-10-05	2015-10-26	2015-09-08		1	2015-09-08	2015-10-22	0	0005060238			20151022.ifs	2015-10-22	2015-10-23
1994476	1994476	DIVIDEND	DELETE	15126Q109	Ex-date corresponds with foreign ex-date.	B	0	1	5	.396272	0	39	2015-10-01	2015-10-05	2015-10-26	2015-09-08		0	2015-09-08	2015-09-09	0	0005060238			20151021.ifs	2015-10-21	2015-10-22
1994477	1994477	DIVIDEND	ADD	15126Q109		B	0	1	0	.391588	0	02	2015-10-01	2015-10-05	2015-10-26	2015-09-08		1	2015-09-08	2015-10-21	0	0005060238			20151021.ifs	2015-10-21	2015-10-22
1961309	1961309	DIVIDEND	ADD	15126Q109		B	0	1	5	.396272		39	2015-10-01	2015-10-05	2015-10-26	2015-09-08		0	2015-09-08	?	0	0005060238			20150908.ifs	2015-09-08	2015-09-09
1695646	1695646	DIVIDEND	DELETE	15126Q109		B	0	1	5	.315725		39	2014-11-10	2014-11-13	2014-12-05	2014-10-24		0	2014-10-24	?	0	0004862169			20141201.ifs	2014-12-01	2014-12-02
1695647	1695647	DIVIDEND	ADD	15126Q109		B	0	1	0	.307247		02	2014-11-10	2014-11-13	2014-12-05	2014-10-24		1	2014-10-24	2014-12-01	0	0004862169			20141201.ifs	2014-12-01	2014-12-02
1663017	1663017	DIVIDEND	ADD	15126Q109		B	0	1	5	.315725		39	2014-11-10	2014-11-13	2014-12-05	2014-10-24		0	2014-10-24	?	0	0004862169			20141024.ifs	2014-10-24	2014-10-25
1356222	1356222	DIVIDEND	CHANGE	15126Q109		B	0	1	0	.151127	0	02	2013-11-14	2013-11-18	2013-12-06	2013-10-31		1	2013-10-31	2013-12-02	0	0004649429			20131203.ifs	2013-12-03	2013-12-04
1356223	1356222	DIVIDEND	CHANGE	15126Q109	Ex-date corresponds to foreign ex-date.	B	0	1	0	.151127	0	02	2013-11-14	2013-11-18	2013-12-06	2013-10-31		1	2013-10-31	2013-12-03	0	0004649429			20131203.ifs	2013-12-03	2013-12-04
1355619	1355619	DIVIDEND	DELETE	15126Q109	Ex-date corresponds to foreign ex-date.	B	0	1	5	.153914	0	39	2013-11-14	2013-11-18	2013-12-06	2013-10-31		0	2013-10-31	2013-11-01	0	0004649429			20131202.ifs	2013-12-02	2013-12-03
1355620	1355620	DIVIDEND	ADD	15126Q109		B	0	1	0	.151127	0	02	2013-11-14	2013-11-18	2013-12-06	2013-10-31		1	2013-10-31	2013-12-02	0	0004649429			20131202.ifs	2013-12-02	2013-12-03
1329005	1329005	DIVIDEND	ADD	15126Q109		B	0	1	5	.153914		39	2013-11-14	2013-11-18	2013-12-06	2013-10-31		0	2013-10-31	?	0	0004649429			20131031.ifs	2013-10-31	2013-11-01
1017496	1017496	DIVIDEND	DELETE	15126Q109		6	0	1	4	.152909	0	26	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-27	0	0004453940			20121128.ifs	2012-11-28	2012-11-29
1017497	1017497	DIVIDEND	ADD	15126Q109		B	0	1	4	.145231	0	02	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-28	0	0004453940			20121128.ifs	2012-11-28	2012-11-29
1016541	1016541	DIVIDEND	CHANGE	15126Q109		6	0	1	4	.152909	0	26	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-02	0	0004453940			20121127.ifs	2012-11-27	2012-11-28
1016542	1016541	DIVIDEND	CHANGE	15126Q109		6	0	1	4	.152909	0	26	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-27	0	0004453940			20121127.ifs	2012-11-27	2012-11-28
1003125	1003125	DIVIDEND	DELETE	15126Q109		6	0	1	4	.152909		26	?	2012-11-13	2012-12-04	2012-11-01		0	2012-11-01	?	0	0004453940			20121102.ifs	2012-11-02	2012-11-03
1003126	1003126	DIVIDEND	ADD	15126Q109		6	0	1	4	.152909	0	26	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-02	0	0004453940			20121102.ifs	2012-11-02	2012-11-03
1004426	1004426	DIVIDEND	CHANGE	15126Q109		6	0	1	4	.152909	0	26	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-02	0	0004453940			20121102.ifs	2012-11-02	2012-11-03
1004427	1004426	DIVIDEND	CHANGE	15126Q109		6	0	1	4	.152909	0	26	2012-11-08	2012-11-13	2012-12-04	2012-11-01		0	?	2012-11-02	0	0004453940			20121102.ifs	2012-11-02	2012-11-03
1002590	1002590	DIVIDEND	ADD	15126Q109		6	0	1	4	.152909		26	?	2012-11-13	2012-12-04	2012-11-01		0	2012-11-01	?	0	0004453940			20121101.ifs	2012-11-01	2012-11-02
776091	776091	EQUITY	ADD	15126Q109	ADR	N	0	2012-02-08	?	0	no	no		no		2012-02-08	?	?							20120208.ifs	2012-02-08	2012-02-09
776092	776092	EXCHANGE	ADD	15126Q109	01	2012-02-08	2012-02-08	CPAC	0	0	2012-02-08	?													20120208.ifs	2012-02-08	2012-02-09
776511	776511	EQUITY	CHANGE	15126Q109	ADR	N	0	2012-02-08	?	0	no	no		no		2012-02-08	?	?							20120208.ifs	2012-02-08	2012-02-09
776512	776511	EQUITY	CHANGE	15126Q109	ADR	0	0	2012-02-08	?	0	no	no		no		2012-02-08	?	?							20120208.ifs	2012-02-08	2012-02-09

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