INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | 0 | Update Insititution By Cusips | ||||||||
% Owned by Insititutions: | N/A % | 0 % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:163982 |
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 | ||
5414429 | 5414429 | CORPACTION | ADD | 172967341 | 01 | C | 2023-11-15 | ? | 20231115.ifs | 2023-11-15 | 2023-11-16 | ||||||||||||||||||
5414430 | 5414430 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K 6.875% | 0 | 1 | 2013-10-28 | ? | 4 | no | no | no | 2013-10-28 | 2013-10-30 | ? | 20231115.ifs | 2023-11-15 | 2023-11-16 | ||||||||||
5414431 | 5414430 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K 6.875% | C | 1 | 2013-10-28 | 2023-11-15 | 4 | no | no | no | 2013-10-28 | 2023-11-15 | ? | 20231115.ifs | 2023-11-15 | 2023-11-16 | ||||||||||
5397564 | 5397564 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2023-11-02 | 2023-11-03 | 2023-11-15 | 2023-10-19 | 0 | 2023-10-19 | ? | 0 | 0006799810 | 20231019.ifs | 2023-10-19 | 2023-10-20 | |||||||
5337601 | 5337601 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2023-08-03 | 2023-08-04 | 2023-08-15 | 2023-07-20 | 0 | 2023-07-20 | ? | 0 | 0006757512 | 20230720.ifs | 2023-07-20 | 2023-07-21 | |||||||
5266305 | 5266305 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2023-05-04 | 2023-05-05 | 2023-05-15 | 2023-04-03 | 0 | 2023-04-03 | ? | 0 | 0006708815 | 20230403.ifs | 2023-04-03 | 2023-04-04 | |||||||
5211223 | 5211223 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2023-02-02 | 2023-02-03 | 2023-02-15 | 2023-01-11 | 0 | 2023-01-11 | ? | 0 | 0006669740 | 20230111.ifs | 2023-01-11 | 2023-01-12 | |||||||
5123318 | 5123318 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2022-11-03 | 2022-11-04 | 2022-11-15 | 2022-10-20 | 0 | 2022-10-20 | ? | 0 | 0006601047 | 20221020.ifs | 2022-10-20 | 2022-10-21 | |||||||
5061979 | 5061979 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2022-08-04 | 2022-08-05 | 2022-08-15 | 2022-07-21 | 0 | 2022-07-21 | ? | 0 | 0006558012 | 20220721.ifs | 2022-07-21 | 2022-07-22 | |||||||
4987932 | 4987932 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2022-05-05 | 2022-05-06 | 2022-05-16 | 2022-04-01 | 0 | 2022-04-01 | ? | 0 | 0006507604 | 20220401.ifs | 2022-04-01 | 2022-04-02 | |||||||
4933745 | 4933745 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2022-02-03 | 2022-02-04 | 2022-02-15 | 2022-01-12 | 0 | 2022-01-12 | ? | 0 | 0006467956 | 20220112.ifs | 2022-01-12 | 2022-01-13 | |||||||
4830138 | 4830138 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2021-11-04 | 2021-11-05 | 2021-11-15 | 2021-10-21 | 0 | 2021-10-21 | ? | 0 | 0006385351 | 20211021.ifs | 2021-10-21 | 2021-10-22 | |||||||
4758438 | 4758438 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2021-08-05 | 2021-08-06 | 2021-08-16 | 2021-07-15 | 0 | 2021-07-15 | ? | 0 | 0006340000 | 20210715.ifs | 2021-07-15 | 2021-07-16 | |||||||
4674659 | 4674659 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2021-05-06 | 2021-05-07 | 2021-05-17 | 2021-04-01 | 0 | 2021-04-01 | ? | 0 | 0006290758 | 20210401.ifs | 2021-04-01 | 2021-04-02 | |||||||
4609621 | 4609621 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2021-02-04 | 2021-02-05 | 2021-02-16 | 2021-01-21 | 0 | 2021-01-21 | ? | 0 | 0006253345 | 20210121.ifs | 2021-01-21 | 2021-01-22 | |||||||
4489626 | 4489626 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2020-11-05 | 2020-11-06 | 2020-11-16 | 2020-10-22 | 0 | 2020-10-22 | ? | 0 | 0006177012 | 20201022.ifs | 2020-10-22 | 2020-10-23 | |||||||
4419499 | 4419499 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2020-08-06 | 2020-08-07 | 2020-08-17 | 2020-07-15 | 0 | 2020-07-15 | ? | 0 | 0006130709 | 20200715.ifs | 2020-07-15 | 2020-07-16 | |||||||
4297299 | 4297299 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2020-05-04 | 2020-05-05 | 2020-05-15 | 2020-04-21 | 0 | 2020-04-21 | ? | 0 | 0006086976 | 20200421.ifs | 2020-04-21 | 2020-04-22 | |||||||
4297300 | 4297300 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2020-05-04 | 2020-05-05 | 2020-05-15 | 2020-04-21 | 0 | 2020-04-21 | ? | 0 | 0006086976 | 20200421.ifs | 2020-04-21 | 2020-04-22 | |||||||
4169901 | 4169901 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2020-02-06 | 2020-02-07 | 2020-02-18 | 2020-01-15 | 0 | 2020-01-15 | ? | 0 | 0006042916 | 20200115.ifs | 2020-01-15 | 2020-01-16 | |||||||
4170138 | 4170138 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2020-02-06 | 2020-02-07 | 2020-02-18 | 2020-01-15 | 0 | 2020-01-15 | ? | 0 | 0006042916 | 20200115.ifs | 2020-01-15 | 2020-01-16 | |||||||
3981861 | 3981861 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-15 | 2019-10-22 | 0 | 2019-10-23 | ? | 0 | 0005964272 | 20191023.ifs | 2019-10-23 | 2019-10-24 | |||||||
3981864 | 3981864 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-10-31 | 2019-11-01 | 2019-11-15 | 2019-10-22 | 0 | 2019-10-23 | ? | 0 | 0005964272 | 20191023.ifs | 2019-10-23 | 2019-10-24 | |||||||
3840380 | 3840380 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-08-01 | 2019-08-02 | 2019-08-15 | 2019-07-17 | 0 | 2019-07-18 | ? | 0 | 0005917201 | 20190718.ifs | 2019-07-18 | 2019-07-19 | |||||||
3840381 | 3840381 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-08-01 | 2019-08-02 | 2019-08-15 | 2019-07-17 | 0 | 2019-07-18 | ? | 0 | 0005917201 | 20190718.ifs | 2019-07-18 | 2019-07-19 | |||||||
3687503 | 3687503 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-05-02 | 2019-05-03 | 2019-05-15 | 2019-04-17 | 0 | 2019-04-17 | ? | 0 | 0005871303 | 20190417.ifs | 2019-04-17 | 2019-04-18 | |||||||
3687506 | 3687506 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-05-02 | 2019-05-03 | 2019-05-15 | 2019-04-17 | 0 | 2019-04-17 | ? | 0 | 0005871303 | 20190417.ifs | 2019-04-17 | 2019-04-18 | |||||||
3550891 | 3550891 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-15 | 2019-01-15 | 0 | 2019-01-15 | ? | 0 | 0005826159 | 20190115.ifs | 2019-01-15 | 2019-01-16 | |||||||
3550896 | 3550896 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2019-01-31 | 2019-02-01 | 2019-02-15 | 2019-01-15 | 0 | 2019-01-15 | ? | 0 | 0005826159 | 20190115.ifs | 2019-01-15 | 2019-01-16 | |||||||
3318393 | 3318393 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-11-01 | 2018-11-02 | 2018-11-15 | 2018-10-01 | 0 | 2018-10-01 | ? | 0 | 0005736442 | 20181001.ifs | 2018-10-01 | 2018-10-02 | |||||||
3318467 | 3318467 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-11-01 | 2018-11-02 | 2018-11-15 | 2018-10-01 | 0 | 2018-10-01 | ? | 0 | 0005736442 | 20181001.ifs | 2018-10-01 | 2018-10-02 | |||||||
3178873 | 3178873 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-08-02 | 2018-08-03 | 2018-08-15 | 2018-07-02 | 0 | 2018-07-02 | ? | 0 | 0005689160 | 20180702.ifs | 2018-07-02 | 2018-07-03 | |||||||
3180001 | 3180001 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-08-02 | 2018-08-03 | 2018-08-15 | 2018-07-02 | 0 | 2018-07-02 | ? | 0 | 0005689160 | 20180702.ifs | 2018-07-02 | 2018-07-03 | |||||||
3020636 | 3020636 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-05-03 | 2018-05-04 | 2018-05-15 | 2018-04-02 | 0 | 2018-04-02 | ? | 0 | 0005643289 | 20180402.ifs | 2018-04-02 | 2018-04-03 | |||||||
3025106 | 3025106 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-05-03 | 2018-05-04 | 2018-05-15 | 2018-04-02 | 0 | 2018-04-02 | ? | 0 | 0005643289 | 20180402.ifs | 2018-04-02 | 2018-04-03 | |||||||
2906463 | 2906463 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-02-01 | 2018-02-02 | 2018-02-15 | 2018-01-02 | 0 | 2018-01-02 | ? | 0 | 0005598144 | 20180102.ifs | 2018-01-02 | 2018-01-03 | |||||||
2906648 | 2906648 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2018-02-01 | 2018-02-02 | 2018-02-15 | 2018-01-02 | 0 | 2018-01-02 | ? | 0 | 0005598144 | 20180102.ifs | 2018-01-02 | 2018-01-03 | |||||||
2714481 | 2714481 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2017-11-02 | 2017-11-03 | 2017-11-15 | 2017-10-02 | 0 | 2017-10-03 | ? | 0 | 0005512280 | 20171003.ifs | 2017-10-03 | 2017-10-04 | |||||||
2714542 | 2714542 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2017-11-02 | 2017-11-03 | 2017-11-15 | 2017-10-02 | 0 | 2017-10-03 | ? | 0 | 0005512280 | 20171003.ifs | 2017-10-03 | 2017-10-04 | |||||||
2614407 | 2614407 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2017-08-02 | 2017-08-04 | 2017-08-15 | 2017-07-03 | 0 | 2017-07-03 | ? | 0 | 0005465396 | 20170703.ifs | 2017-07-03 | 2017-07-04 | |||||||
2534168 | 2534168 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2017-05-03 | 2017-05-05 | 2017-05-15 | 2017-04-03 | 0 | 2017-04-03 | ? | 0 | 0005417129 | 20170403.ifs | 2017-04-03 | 2017-04-04 | |||||||
2436018 | 2436018 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K 6.875% | 0 | 1 | 2013-10-28 | ? | 0 | no | no | no | 2013-10-28 | 2013-10-30 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2436019 | 2436018 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K 6.875% | 0 | 1 | 2013-10-28 | ? | 4 | no | no | no | 2013-10-28 | 2013-10-30 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2417568 | 2417568 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2017-02-01 | 2017-02-03 | 2017-02-15 | 2017-01-03 | 0 | 2017-01-03 | ? | 0 | 0005371604 | 20170103.ifs | 2017-01-03 | 2017-01-04 | |||||||
2314824 | 2314824 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2016-11-02 | 2016-11-04 | 2016-11-15 | 2016-10-03 | 0 | 2016-10-03 | ? | 0 | 0005294566 | 20161003.ifs | 2016-10-03 | 2016-10-04 | |||||||
2244198 | 2244198 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2016-08-03 | 2016-08-05 | 2016-08-15 | 2016-07-01 | 0 | 2016-07-01 | ? | 0 | 0005248536 | 20160701.ifs | 2016-07-01 | 2016-07-02 | |||||||
2157828 | 2157828 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2016-05-03 | 2016-05-05 | 2016-05-16 | 2016-04-01 | 0 | 2016-04-04 | ? | 0 | 0005202947 | 20160404.ifs | 2016-04-04 | 2016-04-05 | |||||||
2086148 | 2086148 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2016-02-03 | 2016-02-05 | 2016-02-16 | 2016-01-02 | 0 | 2016-01-04 | ? | 0 | 0005153802 | 20160104.ifs | 2016-01-04 | 2016-01-05 | |||||||
1983921 | 1983921 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2015-11-03 | 2015-11-05 | 2015-11-16 | 2015-10-01 | 0 | 2015-10-01 | ? | 0 | 0005076240 | 20151001.ifs | 2015-10-01 | 2015-10-02 | |||||||
1908561 | 1908561 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2015-08-03 | 2015-08-05 | 2015-08-17 | 2015-07-01 | 0 | 2015-07-01 | ? | 0 | 0005028993 | 20150701.ifs | 2015-07-01 | 2015-07-02 | |||||||
1834986 | 1834986 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2015-05-01 | 2015-05-05 | 2015-05-15 | 2015-04-01 | 0 | 2015-04-02 | ? | 0 | 0004983603 | 20150402.ifs | 2015-04-02 | 2015-04-03 | |||||||
1762044 | 1762044 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2015-02-03 | 2015-02-05 | 2015-02-17 | 2015-01-02 | 0 | 2015-01-02 | ? | 0 | 0004937651 | 20150102.ifs | 2015-01-02 | 2015-01-03 | |||||||
1651539 | 1651539 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2014-11-03 | 2014-11-05 | 2014-11-17 | 2014-10-01 | 0 | 2014-10-02 | ? | 0 | 0004857255 | 20141002.ifs | 2014-10-02 | 2014-10-03 | |||||||
1573558 | 1573558 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2014-08-01 | 2014-08-05 | 2014-08-15 | 2014-07-01 | 0 | 2014-07-01 | ? | 0 | 0004811293 | 20140701.ifs | 2014-07-01 | 2014-07-02 | |||||||
1491255 | 1491255 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 0 | .429688 | 00 | 2014-05-01 | 2014-05-05 | 2014-05-15 | 2014-04-01 | 0 | 2014-04-03 | ? | 0 | 0004766183 | 20140403.ifs | 2014-04-03 | 2014-04-04 | |||||||
1416973 | 1416973 | DIVIDEND | ADD | 172967341 | 0 | 0 | 1 | 4 | .501302 | 00 | 2014-02-03 | 2014-02-05 | 2014-02-18 | 2014-01-02 | 0 | 2014-01-03 | ? | 0 | 0004721096 | 20140103.ifs | 2014-01-03 | 2014-01-04 | |||||||
1336013 | 1336013 | CORPACTION | ADD | 172967341 | 66 | X | 2013-11-06 | 172967341 | 01 | ? | 20131106.ifs | 2013-11-06 | 2013-11-07 | ||||||||||||||||
1336014 | 1336014 | EXCHANGE | ADD | 172967341 | 01 | 2013-11-06 | 2013-11-06 | C___PK | 0 | 1 | 2013-11-06 | ? | 20131106.ifs | 2013-11-06 | 2013-11-07 | ||||||||||||||
1325238 | 1325238 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K | N | 1 | 2013-10-28 | ? | 0 | no | no | no | 2013-10-28 | ? | ? | 20131030.ifs | 2013-10-30 | 2013-10-31 | ||||||||||
1325239 | 1325238 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K | 0 | 1 | 2013-10-28 | ? | 0 | no | no | no | 2013-10-28 | 2013-10-30 | ? | 20131030.ifs | 2013-10-30 | 2013-10-31 | ||||||||||
1325252 | 1325252 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K | 0 | 1 | 2013-10-28 | ? | 0 | no | no | no | 2013-10-28 | 2013-10-30 | ? | 20131030.ifs | 2013-10-30 | 2013-10-31 | ||||||||||
1325253 | 1325252 | EQUITY | CHANGE | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K 6.875% | 0 | 1 | 2013-10-28 | ? | 0 | no | no | no | 2013-10-28 | 2013-10-30 | ? | 20131030.ifs | 2013-10-30 | 2013-10-31 | ||||||||||
1323807 | 1323807 | EQUITY | ADD | 172967341 | DEP SHS REPSTG 1/1000TH PFD SER K | N | 1 | 2013-10-28 | ? | 0 | no | no | no | 2013-10-28 | ? | ? | 20131028.ifs | 2013-10-28 | 2013-10-29 | ||||||||||
1323808 | 1323808 | EXCHANGE | ADD | 172967341 | 66 | 2013-10-28 | 2013-10-28 | CTRGL | 0 | 1 | 2013-10-28 | ? | 20131028.ifs | 2013-10-28 | 2013-10-29 |
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 = 163982
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