INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | 817 | 726 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | 94.39 % | 93.82 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:158503 |
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 | ||
4707118 | 4707118 | DIVIDEND | ADD | G6095L109 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2020-05-19 | 2021-05-18 | 0 | 2021-05-18 | ? | 0 | 0006309206 | 20210518.ifs | 2021-05-18 | 2021-05-19 | |||||||
4175771 | 4175771 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2020-02-04 | 2020-02-05 | 2020-02-19 | 2020-01-23 | 0 | 2020-01-23 | ? | 0 | 0006044557 | 20200123.ifs | 2020-01-23 | 2020-01-24 | |||||||
4175772 | 4175772 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2020-02-04 | 2020-02-05 | 2020-02-19 | 2020-01-23 | 0 | 2020-01-23 | ? | 0 | 0006044557 | 20200123.ifs | 2020-01-23 | 2020-01-24 | |||||||
3982494 | 3982494 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-11-05 | 2019-11-06 | 2019-11-20 | 2019-10-24 | 0 | 2019-10-24 | ? | 0 | 0005964955 | 20191024.ifs | 2019-10-24 | 2019-10-25 | |||||||
3982544 | 3982544 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-11-05 | 2019-11-06 | 2019-11-20 | 2019-10-24 | 0 | 2019-10-24 | ? | 0 | 0005964955 | 20191024.ifs | 2019-10-24 | 2019-10-25 | |||||||
3847690 | 3847690 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-08-06 | 2019-08-07 | 2019-08-21 | 2019-07-25 | 0 | 2019-07-25 | ? | 0 | 0005919640 | 20190725.ifs | 2019-07-25 | 2019-07-26 | |||||||
3847691 | 3847691 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-08-06 | 2019-08-07 | 2019-08-21 | 2019-07-25 | 0 | 2019-07-25 | ? | 0 | 0005919640 | 20190725.ifs | 2019-07-25 | 2019-07-26 | |||||||
3693794 | 3693794 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-05-07 | 2019-05-08 | 2019-05-22 | 2019-04-25 | 0 | 2019-04-25 | ? | 0 | 0005873330 | 20190425.ifs | 2019-04-25 | 2019-04-26 | |||||||
3693795 | 3693795 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-05-07 | 2019-05-08 | 2019-05-22 | 2019-04-25 | 0 | 2019-04-25 | ? | 0 | 0005873330 | 20190425.ifs | 2019-04-25 | 2019-04-26 | |||||||
3630974 | 3630974 | EQUITY | CHANGE | G6095L109 | ORD | 0 | 0 | 2017-12-03 | ? | 0 | no | no | no | 2017-12-04 | ? | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3630976 | 3630975 | EQUITY | CHANGE | G6095L109 | ORD | 0 | 0 | 2017-12-03 | ? | 4 | no | no | no | 2017-12-04 | ? | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3630979 | 3630979 | EQUITY | CHANGE | G6095L109 | ORD | 0 | 0 | 2017-12-03 | ? | 0 | no | no | no | 2017-12-04 | ? | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3630981 | 3630980 | EQUITY | CHANGE | G6095L109 | ORD | 0 | 0 | 2017-12-03 | ? | 4 | no | no | no | 2017-12-04 | ? | ? | 20190315.ifs | 2019-03-15 | 2019-03-16 | ||||||||||
3560517 | 3560517 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-02-05 | 2019-02-06 | 2019-02-20 | 2019-01-24 | 0 | 2019-01-24 | ? | 0 | 0005828347 | 20190124.ifs | 2019-01-24 | 2019-01-25 | |||||||
3560518 | 3560518 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2019-02-05 | 2019-02-06 | 2019-02-20 | 2019-01-24 | 0 | 2019-01-24 | ? | 0 | 0005828347 | 20190124.ifs | 2019-01-24 | 2019-01-25 | |||||||
3338919 | 3338919 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-11-06 | 2018-11-07 | 2018-11-21 | 2018-10-25 | 0 | 2018-10-25 | ? | 0 | 0005743883 | 20181025.ifs | 2018-10-25 | 2018-10-26 | |||||||
3339062 | 3339062 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-11-06 | 2018-11-07 | 2018-11-21 | 2018-10-25 | 0 | 2018-10-25 | ? | 0 | 0005743883 | 20181025.ifs | 2018-10-25 | 2018-10-26 | |||||||
3204671 | 3204671 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-08-07 | 2018-08-08 | 2018-08-22 | 2018-07-25 | 0 | 2018-07-25 | ? | 0 | 0005697079 | 20180725.ifs | 2018-07-25 | 2018-07-26 | |||||||
3204686 | 3204686 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-08-07 | 2018-08-08 | 2018-08-22 | 2018-07-25 | 0 | 2018-07-25 | ? | 0 | 0005697079 | 20180725.ifs | 2018-07-25 | 2018-07-26 | |||||||
3054348 | 3054348 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-05-08 | 2018-05-09 | 2018-05-23 | 2018-04-26 | 0 | 2018-04-26 | ? | 0 | 0005650871 | 20180426.ifs | 2018-04-26 | 2018-04-27 | |||||||
3054349 | 3054349 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 0 | .22 | 00 | 2018-05-08 | 2018-05-09 | 2018-05-23 | 2018-04-26 | 0 | 2018-04-26 | ? | 0 | 0005650871 | 20180426.ifs | 2018-04-26 | 2018-04-27 | |||||||
2813841 | 2813841 | EXCHANGE | DELETE | G6095L109 | 01 | 2017-12-04 | 2017-12-07 | APTV | 0 | 0 | 2017-12-05 | 2017-12-05 | 20171208.ifs | 2017-12-08 | 2017-12-09 | ||||||||||||||
2813843 | 2813843 | EXCHANGE | ADD | G6095L109 | 01 | 2017-12-05 | 2017-12-07 | APTV | 0 | 0 | ? | 2017-12-08 | 20171208.ifs | 2017-12-08 | 2017-12-09 | ||||||||||||||
2813873 | 2813873 | EXCHANGE | DELETE | G6095L109 | 01 | 2017-12-04 | 2017-12-07 | APTV | 0 | 0 | 2017-12-05 | 2017-12-05 | 20171208.ifs | 2017-12-08 | 2017-12-09 | ||||||||||||||
2813875 | 2813875 | EXCHANGE | ADD | G6095L109 | 01 | 2017-12-05 | 2017-12-07 | APTV | 0 | 0 | ? | 2017-12-08 | 20171208.ifs | 2017-12-08 | 2017-12-09 | ||||||||||||||
2811278 | 2811278 | CORPACTION | DELETE | G6095L109 | 01 | # | 2017-12-05 | G6095L109 | 01 | ? | 20171207.ifs | 2017-12-07 | 2017-12-08 | ||||||||||||||||
2811281 | 2811280 | CORPACTION | DELETE | G6095L109 | 01 | 2017-12-05 | APTV_I | APTIV PLC | ORD | APTV | APTIV PLC | ORD | 2017-12-05 | ? | 20171207.ifs | 2017-12-07 | 2017-12-08 | ||||||||||||
2811307 | 2811307 | CORPACTION | DELETE | G6095L109 | 01 | # | 2017-12-05 | G6095L109 | 01 | ? | 20171207.ifs | 2017-12-07 | 2017-12-08 | ||||||||||||||||
2811310 | 2811309 | CORPACTION | DELETE | G6095L109 | 01 | 2017-12-05 | APTV_I | APTIV PLC | ORD | APTV | APTIV PLC | ORD | 2017-12-05 | ? | 20171207.ifs | 2017-12-07 | 2017-12-08 | ||||||||||||
2811692 | 2811692 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 1 | .22 | 06 | 2018-02-02 | 2018-02-05 | 2018-02-14 | 2017-12-07 | 0 | 2017-12-07 | ? | 0 | 0005545368 | 20171207.ifs | 2017-12-07 | 2017-12-08 | |||||||
2811740 | 2811740 | DIVIDEND | ADD | G6095L109 | 0 | 0 | 1 | 1 | .22 | 06 | 2018-02-02 | 2018-02-05 | 2018-02-14 | 2017-12-07 | 0 | 2017-12-07 | ? | 0 | 0005545368 | 20171207.ifs | 2017-12-07 | 2017-12-08 | |||||||
2802067 | 2802067 | EXCHANGE | ADD | G6095L109 | 01 | 2017-12-04 | 2017-12-05 | APTV_I | 0 | 0 | 2017-12-05 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||
2802068 | 2802068 | CORPACTION | ADD | G6095L109 | 01 | # | 2017-12-05 | G6095L109 | 01 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||||
2802069 | 2802069 | CORPACTIONAUX | ADD | G6095L109 | 01 | 2017-12-05 | APTV_I | APTIV PLC | ORD | APTV | APTIV PLC | ORD | 2017-12-05 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||
2802070 | 2802070 | EXCHANGE | CHANGE | G6095L109 | 01 | 2017-12-04 | 2017-12-05 | APTV_I | 0 | 0 | 2017-12-05 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||
2802071 | 2802070 | EXCHANGE | CHANGE | G6095L109 | 01 | 2017-12-04 | 2017-12-05 | APTV | 0 | 0 | 2017-12-05 | 2017-12-05 | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||
2802104 | 2802104 | SPLIT | ADD | G6095L109 | .8375838926 | 2017-12-05 | 20 | ? | 2017-12-05 | 20171205.ifs | 2017-12-05 | 2017-12-06 | |||||||||||||||||
2802106 | 2802106 | DIVIDEND | ADD | G6095L109 | 1 sh. of Delphi Technologies PLC Ord. for every 3 shs. held. | 0 | 0 | 7 | 0 | .333333 | 0 | 20 | 2017-12-05 | 2017-11-22 | 2017-12-04 | 2017-11-13 | G2709G107 | 1 | 2017-11-15 | 2017-12-05 | 0 | 0005530405 | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||
2805625 | 2805625 | EXCHANGE | ADD | G6095L109 | 01 | 2017-12-04 | 2017-12-05 | APTV_I | 0 | 0 | 2017-12-05 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||
2805626 | 2805626 | CORPACTION | ADD | G6095L109 | 01 | # | 2017-12-05 | G6095L109 | 01 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||||
2805627 | 2805627 | CORPACTIONAUX | ADD | G6095L109 | 01 | 2017-12-05 | APTV_I | APTIV PLC | ORD | APTV | APTIV PLC | ORD | 2017-12-05 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||
2805628 | 2805628 | EXCHANGE | CHANGE | G6095L109 | 01 | 2017-12-04 | 2017-12-05 | APTV_I | 0 | 0 | 2017-12-05 | ? | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||
2805629 | 2805628 | EXCHANGE | CHANGE | G6095L109 | 01 | 2017-12-04 | 2017-12-05 | APTV | 0 | 0 | 2017-12-05 | 2017-12-05 | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||||||||||||
2805662 | 2805662 | SPLIT | ADD | G6095L109 | .8375838926 | 2017-12-05 | 20 | ? | 2017-12-05 | 20171205.ifs | 2017-12-05 | 2017-12-06 | |||||||||||||||||
2805664 | 2805664 | DIVIDEND | ADD | G6095L109 | 1 sh. of Delphi Technologies PLC Ord. for every 3 shs. held. | 0 | 0 | 7 | 0 | .333333 | 0 | 20 | 2017-12-05 | 2017-11-22 | 2017-12-04 | 2017-11-13 | G2709G107 | 1 | 2017-11-15 | 2017-12-05 | 0 | 0005530405 | 20171205.ifs | 2017-12-05 | 2017-12-06 | ||||
2796408 | 2796408 | EQUITY | ADD | G6095L109 | ORD | 0 | 0 | 2017-12-03 | ? | 0 | no | no | no | 2017-12-04 | ? | ? | 20171204.ifs | 2017-12-04 | 2017-12-05 | ||||||||||
2796522 | 2796522 | EQUITY | ADD | G6095L109 | ORD | 0 | 0 | 2017-12-03 | ? | 0 | no | no | no | 2017-12-04 | ? | ? | 20171204.ifs | 2017-12-04 | 2017-12-05 |
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 = 158503
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