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
5554424	5554424	DIVIDEND	DELETE	210771200		B	0	1	5	.156841		39	2024-04-29	2024-04-30	2024-05-09	2024-03-15		0	2024-03-15	?	0	0006890581			20240506.ifs	2024-05-06	2024-05-07
5554425	5554425	DIVIDEND	ADD	210771200		B	0	1	0	.153284		02	2024-04-29	2024-04-30	2024-05-09	2024-03-15		1	2024-03-15	2024-05-06	0	0006890581			20240506.ifs	2024-05-06	2024-05-07
5517628	5517628	DIVIDEND	ADD	210771200		B	0	1	5	.156841		39	2024-04-29	2024-04-30	2024-05-09	2024-03-15		0	2024-03-15	?	0	0006890581			20240315.ifs	2024-03-15	2024-03-16
5286866	5286866	DIVIDEND	DELETE	210771200		B	0	1	5	.11194		39	2023-05-01	2023-05-02	2023-05-10	2023-03-21		0	2023-03-21	?	0	0006698007			20230503.ifs	2023-05-03	2023-05-04
5286867	5286867	DIVIDEND	ADD	210771200		B	0	1	0	.115237		02	2023-05-01	2023-05-02	2023-05-10	2023-03-21		1	2023-03-21	2023-05-03	0	0006698007			20230503.ifs	2023-05-03	2023-05-04
5252200	5252200	DIVIDEND	ADD	210771200		B	0	1	5	.11194		39	2023-05-01	2023-05-02	2023-05-10	2023-03-21		0	2023-03-21	?	0	0006698007			20230321.ifs	2023-03-21	2023-03-22
5008089	5008089	DIVIDEND	DELETE	210771200		B	0	1	5	.170238		39	2022-05-02	2022-05-03	2022-05-11	2022-04-01		0	2022-04-01	?	0	0006506863			20220504.ifs	2022-05-04	2022-05-05
5008090	5008090	DIVIDEND	ADD	210771200		B	0	1	0	.161533		02	2022-05-02	2022-05-03	2022-05-11	2022-04-01		1	2022-04-01	2022-05-04	0	0006506863			20220504.ifs	2022-05-04	2022-05-05
4987912	4987912	DIVIDEND	ADD	210771200		B	0	1	5	.170238		39	2022-05-02	2022-05-03	2022-05-11	2022-04-01		0	2022-04-01	?	0	0006506863			20220401.ifs	2022-04-01	2022-04-02
4807022	4807022	SPLIT	ADD	210771200	1	2021-09-22	20	?	2021-09-22																20210922.ifs	2021-09-22	2021-09-23
4805052	4805052	DIVIDEND	CHANGE	210771200		0	0	7	0	.1	0	20	2021-09-22	2021-09-17	2021-09-21	2021-09-13	92853L108	2	2021-09-13	2021-09-17	0	0006366740			20210920.ifs	2021-09-20	2021-09-21
4805053	4805052	DIVIDEND	CHANGE	210771200	1 sh. of Vitesco Technology Group AG for every 10 shs. held.	0	0	7	0	.1	0	20	2021-09-22	2021-09-17	2021-09-21	2021-09-13	92853L108	2	2021-09-13	2021-09-20	0	0006366740			20210920.ifs	2021-09-20	2021-09-21
4804850	4804850	DIVIDEND	DELETE	210771200	1 sh. of Vitesco Technology Group AG for every 10 shs. held.	0	0	7	0	.1	0	20	?	2021-09-17	2021-09-21	2021-09-13	92853L108	1	2021-09-13	2021-09-15	0	0006366740			20210917.ifs	2021-09-17	2021-09-18
4804851	4804851	DIVIDEND	ADD	210771200		0	0	7	0	.1	0	20	2021-09-22	2021-09-17	2021-09-21	2021-09-13	92853L108	2	2021-09-13	2021-09-17	0	0006366740			20210917.ifs	2021-09-17	2021-09-18
4801678	4801678	DIVIDEND	CHANGE	210771200		0	0	7	0	.1	0	20	?	2021-09-17	2021-09-21	2021-09-13	92853L108	1	2021-09-13	2021-09-14	0	0006366740			20210915.ifs	2021-09-15	2021-09-16
4801679	4801678	DIVIDEND	CHANGE	210771200	1 sh. of Vitesco Technology Group AG for every 10 shs. held.	0	0	7	0	.1	0	20	?	2021-09-17	2021-09-21	2021-09-13	92853L108	1	2021-09-13	2021-09-15	0	0006366740			20210915.ifs	2021-09-15	2021-09-16
4801557	4801557	DIVIDEND	DELETE	210771200	1 sh. of Vitesco Technology Group AG for every 10 shs. held. No	0	0	7	0	.1	0	20	?	2021-09-17	2021-09-20	2021-09-13	92853L108	0	2021-09-13	2021-09-14	0	0006366740			20210914.ifs	2021-09-14	2021-09-15
4801558	4801558	DIVIDEND	ADD	210771200		0	0	7	0	.1	0	20	?	2021-09-17	2021-09-21	2021-09-13	92853L108	1	2021-09-13	2021-09-14	0	0006366740			20210914.ifs	2021-09-14	2021-09-15
4800965	4800965	DIVIDEND	ADD	210771200		0	0	7	0	.1		20	?	2021-09-17	2021-09-20	2021-09-13	92853L108	0	2021-09-13	?	0	0006366740			20210913.ifs	2021-09-13	2021-09-14
4420979	4420979	DIVIDEND	DELETE	210771200		B	0	1	5	.234926		39	2020-07-15	2020-07-16	2020-07-24	2020-06-30		0	2020-06-30	?	0	0006122368			20200717.ifs	2020-07-17	2020-07-18
4420980	4420980	DIVIDEND	ADD	210771200		B	0	1	0	.238593		02	2020-07-15	2020-07-16	2020-07-24	2020-06-30		1	2020-06-30	2020-07-17	0	0006122368			20200717.ifs	2020-07-17	2020-07-18
4407381	4407381	DIVIDEND	ADD	210771200		B	0	1	5	.234926		39	2020-07-15	2020-07-16	2020-07-24	2020-06-30		0	2020-06-30	?	0	0006122368			20200630.ifs	2020-06-30	2020-07-01
3717505	3717505	DIVIDEND	CHANGE	210771200		0	0	1	1	.374472		06	2019-04-29	2019-04-30	2019-05-09	2019-03-19		0	2019-03-19	?	0	0005855028			20190503.ifs	2019-05-03	2019-05-04
3717507	3717506	DIVIDEND	CHANGE	210771200		0	0	1	1	.371559		06	2019-04-29	2019-04-30	2019-05-09	2019-03-19		1	2019-03-19	2019-05-03	0	0005855028			20190503.ifs	2019-05-03	2019-05-04
3717520	3717520	DIVIDEND	CHANGE	210771200		0	0	1	1	.374472		06	2019-04-29	2019-04-30	2019-05-09	2019-03-19		0	2019-03-19	?	0	0005855028			20190503.ifs	2019-05-03	2019-05-04
3717522	3717521	DIVIDEND	CHANGE	210771200		0	0	1	1	.371559		06	2019-04-29	2019-04-30	2019-05-09	2019-03-19		1	2019-03-19	2019-05-03	0	0005855028			20190503.ifs	2019-05-03	2019-05-04
3638715	3638715	DIVIDEND	ADD	210771200		0	0	1	1	.374472		06	2019-04-29	2019-04-30	2019-05-09	2019-03-19		0	2019-03-19	?	0	0005855028			20190319.ifs	2019-03-19	2019-03-20
3638722	3638722	DIVIDEND	ADD	210771200		0	0	1	1	.374472		06	2019-04-29	2019-04-30	2019-05-09	2019-03-19		0	2019-03-19	?	0	0005855028			20190319.ifs	2019-03-19	2019-03-20
3332511	3332511	DIVIDEND	ADD	210771200		0	0	5	0	1		10	2018-10-30	2018-10-26	2018-10-29	2018-10-18		0	2018-10-18	?	0	0005741692			20181018.ifs	2018-10-18	2018-10-19
3332513	3332513	SPLIT	ADD	210771200	.5	2018-10-30	10	2018-10-18	?																20181018.ifs	2018-10-18	2018-10-19
3333164	3333164	DIVIDEND	ADD	210771200		0	0	5	0	1		10	2018-10-30	2018-10-26	2018-10-29	2018-10-18		0	2018-10-18	?	0	0005741692			20181018.ifs	2018-10-18	2018-10-19
3333165	3333165	SPLIT	ADD	210771200	.5	2018-10-30	10	2018-10-18	?																20181018.ifs	2018-10-18	2018-10-19
3081274	3081274	DIVIDEND	DELETE	210771200		B	0	1	5	.803033		39	2018-05-01	2018-05-02	2018-05-10	2018-04-06		0	2018-04-06	?	0	0005645616			20180504.ifs	2018-05-04	2018-05-05
3081276	3081276	DIVIDEND	ADD	210771200		B	0	1	0	.773652		02	2018-05-01	2018-05-02	2018-05-10	2018-04-06		1	2018-04-06	2018-05-04	0	0005645616			20180504.ifs	2018-05-04	2018-05-05
3081277	3081277	DIVIDEND	DELETE	210771200		B	0	1	5	.803033		39	2018-05-01	2018-05-02	2018-05-10	2018-04-06		0	2018-04-06	?	0	0005645616			20180504.ifs	2018-05-04	2018-05-05
3081279	3081279	DIVIDEND	ADD	210771200		B	0	1	0	.773652		02	2018-05-01	2018-05-02	2018-05-10	2018-04-06		1	2018-04-06	2018-05-04	0	0005645616			20180504.ifs	2018-05-04	2018-05-05
3031777	3031777	DIVIDEND	ADD	210771200		B	0	1	5	.803033		39	2018-05-01	2018-05-02	2018-05-10	2018-04-06		0	2018-04-06	?	0	0005645616			20180406.ifs	2018-04-06	2018-04-07
3031788	3031788	DIVIDEND	ADD	210771200		B	0	1	5	.803033		39	2018-05-01	2018-05-02	2018-05-10	2018-04-06		0	2018-04-06	?	0	0005645616			20180406.ifs	2018-04-06	2018-04-07
2562783	2562783	DIVIDEND	DELETE	210771200		B	0	1	5	.659651		39	2017-05-01	2017-05-03	2017-05-11	2017-03-30		0	2017-03-30	?	0	0005409556			20170505.ifs	2017-05-05	2017-05-06
2562784	2562784	DIVIDEND	ADD	210771200		B	0	1	0	.666722		02	2017-05-01	2017-05-03	2017-05-11	2017-03-30		1	2017-03-30	2017-05-05	0	0005409556			20170505.ifs	2017-05-05	2017-05-06
2524966	2524966	DIVIDEND	ADD	210771200		B	0	1	5	.659651		39	2017-05-01	2017-05-03	2017-05-11	2017-03-30		0	2017-03-30	?	0	0005409556			20170330.ifs	2017-03-30	2017-03-31
2458109	2458109	EQUITY	CHANGE	210771200	SPONSORED ADR	0	0	1995-11-30	?	8	no	no		no		2000-02-25	2000-04-11	?							20170126.ifs	2017-01-26	2017-01-27
2458110	2458109	EQUITY	CHANGE	210771200	SPONSORED ADR	0	0	1995-11-30	?	1	no	no		no		2000-02-25	2000-04-11	?							20170126.ifs	2017-01-26	2017-01-27
2190541	2190541	DIVIDEND	DELETE	210771200		B	0	1	5	.599085		39	2016-04-27	2016-04-29	?	2016-03-30		0	2016-03-30	?	0	0005193771			20160503.ifs	2016-05-03	2016-05-04
2190542	2190542	DIVIDEND	ADD	210771200		B	0	1	0	.619394		02	2016-04-27	2016-04-29	2016-05-09	2016-03-30		1	2016-03-30	2016-05-03	0	0005193771			20160503.ifs	2016-05-03	2016-05-04
2147336	2147336	DIVIDEND	ADD	210771200		B	0	1	5	.599085		39	2016-04-27	2016-04-29	?	2016-03-30		0	2016-03-30	?	0	0005193771			20160330.ifs	2016-03-30	2016-03-31
1840038	1840038	DIVIDEND	ADD	210771200		B	0	1	5	.4967		39	2015-04-28	2015-04-30	?	2015-04-14		0	2015-04-14	?	0	0004985897			20150414.ifs	2015-04-14	2015-04-15
1508042	1508042	DIVIDEND	ADD	210771200		B	0	1	0	.4998		02	2014-04-23	2014-04-25	2014-05-05	2014-03-11		0	?	2014-05-01	0	0004749367			20140501.ifs	2014-05-01	2014-05-02
1508054	1508054	DIVIDEND	DELETE	210771200		B	0	1	0	.4998		02	2014-04-23	2014-04-25	2014-05-05	2014-03-11		0	?	2014-05-01	0	0004749367			20140501.ifs	2014-05-01	2014-05-02
1508055	1508055	DIVIDEND	ADD	210771200		B	0	1	1	.4998	0	06	2014-04-23	2014-04-25	2014-05-05	2014-03-11		0	?	2014-05-01	0	0004749367			20140501.ifs	2014-05-01	2014-05-02
1362555	1362555	DIVIDEND	ADD	210771200		0	0	5	0	4		10	2013-12-24	2013-12-20	2013-12-23	2013-12-10		0	2013-12-10	?	0	0004674885			20131210.ifs	2013-12-10	2013-12-11
1362556	1362556	SPLIT	ADD	210771200	.2	2013-12-24	10	2013-12-10	?																20131210.ifs	2013-12-10	2013-12-11
1189084	1189084	DIVIDEND	DELETE	210771200		B		1	0	1.4607		02	2012-04-25	2012-04-27	2012-05-07	?		0	2012-05-02	?	0	0004345020			20130521.ifs	2013-05-21	2013-05-22
1189085	1189085	DIVIDEND	ADD	210771200		B	0	1	0	1.4607	0	02	2012-04-25	2012-04-27	2012-05-07	2012-03-13		0	?	2013-05-21	0	0004345020			20130521.ifs	2013-05-21	2013-05-22
1189086	1189086	DIVIDEND	ADD	210771200		B	0	1	0	2.1369		02	2013-05-13	2013-05-15	2013-05-23	2013-04-10		0	?	2013-05-21	0	0004557130			20130521.ifs	2013-05-21	2013-05-22
854096	854096	DIVIDEND	ADD	210771200		B		1	0	1.4607		02	2012-04-25	2012-04-27	2012-05-07	?		0	2012-05-02	?	0	0004345020			20120502.ifs	2012-05-02	2012-05-03
803543	803543	DIVIDEND	ADD	210771200		0	0	1	5	1.4838		40	2012-04-25	2012-04-27	?	2012-03-13		0	?	2012-03-16	0	0004345020			20120316.ifs	2012-03-16	2012-03-17
803544	803544	DIVIDEND	DELETE	210771200		0	0	1	5	1.4838		40	2012-04-25	2012-04-27	?	2012-03-13		0	?	2012-03-16	0	0004345020			20120316.ifs	2012-03-16	2012-03-17
244316	244316	DIVIDEND	ADD	210771200		0	0	E	0	0		58	?	?	2010-05-05	2010-07-07		0	2010-07-07	?	0	0004032242			20100707.ifs	2010-07-07	2010-07-08
93563	93563	DIVIDEND	ADD	210771200		0	0	E	0	0		58	?	?	2009-05-05	2010-01-25		0	2010-01-25	?	0	0003955603			20100125.ifs	2010-01-25	2010-04-07
92853	92853	DIVIDEND	ADD	210771200		6	0	1	9	1.9238		25	2010-01-25	2010-01-27	2010-02-03	2010-01-22		0	2010-01-22	?	0	0003955396			20100122.ifs	2010-01-22	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 = 145900
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