INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
||||||||||
Total Insititutions : | 3 | 3 | Update Insititution By Cusips | |||||||||||
% Owned by Insititutions: | 0.65 % | 0.78 % | ||||||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | ||||||||||||
|
||||||||||||||
the compid is:159576 |
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 | ||
5578605 | 5578605 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2024-07-01 | 2024-07-01 | 2024-07-15 | 2024-06-18 | 0 | 2024-06-18 | ? | 0 | 0006933938 | 20240618.ifs | 2024-06-18 | 2024-06-19 | |||||||
5521426 | 5521426 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2024-03-28 | 2024-04-01 | 2024-04-15 | 2024-03-21 | 0 | 2024-03-21 | ? | 0 | 0006893572 | 20240321.ifs | 2024-03-21 | 2024-03-22 | |||||||
5462236 | 5462236 | DIVIDEND | DELETE | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2023-12-29 | 2024-01-01 | 2024-01-15 | 2023-12-20 | 0 | 2023-12-20 | ? | 0 | 0006843734 | 20231226.ifs | 2023-12-26 | 2023-12-27 | |||||||
5462237 | 5462237 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2023-12-28 | 2024-01-01 | 2024-01-15 | 2023-12-20 | 1 | 2023-12-20 | 2023-12-26 | 0 | 0006843734 | 20231226.ifs | 2023-12-26 | 2023-12-27 | |||||||
5454827 | 5454827 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2023-12-29 | 2024-01-01 | 2024-01-15 | 2023-12-20 | 0 | 2023-12-20 | ? | 0 | 0006843734 | 20231220.ifs | 2023-12-20 | 2023-12-21 | |||||||
5378609 | 5378609 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2023-09-28 | 2023-10-01 | 2023-10-15 | 2023-09-21 | 0 | 2023-09-21 | ? | 0 | 0006786078 | 20230921.ifs | 2023-09-21 | 2023-09-22 | |||||||
5314952 | 5314952 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2023-06-29 | 2023-07-01 | 2023-07-15 | 2023-06-20 | 0 | 2023-06-20 | ? | 0 | 0006741100 | 20230620.ifs | 2023-06-20 | 2023-06-21 | |||||||
5253266 | 5253266 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2023-03-30 | 2023-04-01 | 2023-04-15 | 2023-03-22 | 0 | 2023-03-22 | ? | 0 | 0006698528 | 20230322.ifs | 2023-03-22 | 2023-03-23 | |||||||
5187744 | 5187744 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2022-12-29 | 2023-01-01 | 2023-01-15 | 2022-12-22 | 0 | 2022-12-22 | ? | 0 | 0006649955 | 20221222.ifs | 2022-12-22 | 2022-12-23 | |||||||
5101462 | 5101462 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2022-09-29 | 2022-10-01 | 2022-10-15 | 2022-09-21 | 0 | 2022-09-21 | ? | 0 | 0006586029 | 20220921.ifs | 2022-09-21 | 2022-09-22 | |||||||
5037916 | 5037916 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2022-06-30 | 2022-07-01 | 2022-07-15 | 2022-06-21 | 0 | 2022-06-21 | ? | 0 | 0006541482 | 20220621.ifs | 2022-06-21 | 2022-06-22 | |||||||
4972184 | 4972184 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2022-03-31 | 2022-04-01 | 2022-04-15 | 2022-03-16 | 0 | 2022-03-16 | ? | 0 | 0006495051 | 20220316.ifs | 2022-03-16 | 2022-03-17 | |||||||
4906136 | 4906136 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2021-12-30 | 2022-01-01 | 2022-01-15 | 2021-12-21 | 0 | 2021-12-21 | ? | 0 | 0006439119 | 20211221.ifs | 2021-12-21 | 2021-12-22 | |||||||
4804969 | 4804969 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2021-09-30 | 2021-10-01 | 2021-10-15 | 2021-09-17 | 0 | 2021-09-17 | ? | 0 | 0006369059 | 20210917.ifs | 2021-09-17 | 2021-09-18 | |||||||
4733501 | 4733501 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2021-06-30 | 2021-07-01 | 2021-07-15 | 2021-06-18 | 0 | 2021-06-18 | ? | 0 | 0006324181 | 20210618.ifs | 2021-06-18 | 2021-06-19 | |||||||
4655211 | 4655211 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2021-03-31 | 2021-04-01 | 2021-04-15 | 2021-03-17 | 0 | 2021-03-17 | ? | 0 | 0006278286 | 20210317.ifs | 2021-03-17 | 2021-03-18 | |||||||
4548962 | 4548962 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2020-12-30 | 2021-01-01 | 2021-01-15 | 2020-12-16 | 0 | 2020-12-16 | ? | 0 | 0006216911 | 20201216.ifs | 2020-12-16 | 2020-12-17 | |||||||
4464416 | 4464416 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2020-09-30 | 2020-10-01 | 2020-10-15 | 2020-09-17 | 0 | 2020-09-17 | ? | 0 | 0006159650 | 20200917.ifs | 2020-09-17 | 2020-09-18 | |||||||
4394895 | 4394895 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2020-06-30 | 2020-07-01 | 2020-07-15 | 2020-06-18 | 0 | 2020-06-18 | ? | 0 | 0006114065 | 20200618.ifs | 2020-06-18 | 2020-06-19 | |||||||
4085159 | 4085159 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-12-30 | 2020-01-01 | 2020-01-15 | 2019-12-17 | 0 | 2019-12-17 | ? | 0 | 0006004895 | 20191217.ifs | 2019-12-17 | 2019-12-18 | |||||||
4085283 | 4085283 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-12-30 | 2020-01-01 | 2020-01-15 | 2019-12-17 | 0 | 2019-12-17 | ? | 0 | 0006004895 | 20191217.ifs | 2019-12-17 | 2019-12-18 | |||||||
3929252 | 3929252 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-09-30 | 2019-10-01 | 2019-10-15 | 2019-09-19 | 0 | 2019-09-19 | ? | 0 | 0005946950 | 20190919.ifs | 2019-09-19 | 2019-09-20 | |||||||
3929253 | 3929253 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-09-30 | 2019-10-01 | 2019-10-15 | 2019-09-19 | 0 | 2019-09-19 | ? | 0 | 0005946950 | 20190919.ifs | 2019-09-19 | 2019-09-20 | |||||||
3788286 | 3788286 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-06-28 | 2019-07-01 | 2019-07-15 | 2019-06-19 | 0 | 2019-06-19 | ? | 0 | 0005900441 | 20190619.ifs | 2019-06-19 | 2019-06-20 | |||||||
3788291 | 3788291 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-06-28 | 2019-07-01 | 2019-07-15 | 2019-06-19 | 0 | 2019-06-19 | ? | 0 | 0005900441 | 20190619.ifs | 2019-06-19 | 2019-06-20 | |||||||
3639185 | 3639185 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-03-29 | 2019-04-01 | 2019-04-15 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854802 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3639197 | 3639197 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2019-03-29 | 2019-04-01 | 2019-04-15 | 2019-03-19 | 0 | 2019-03-19 | ? | 0 | 0005854802 | 20190319.ifs | 2019-03-19 | 2019-03-20 | |||||||
3455843 | 3455843 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-12-28 | 2019-01-01 | 2019-01-15 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784850 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3455930 | 3455930 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-12-28 | 2019-01-01 | 2019-01-15 | 2018-12-17 | 0 | 2018-12-17 | ? | 0 | 0005784850 | 20181217.ifs | 2018-12-17 | 2018-12-18 | |||||||
3286868 | 3286868 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-09-28 | 2018-10-01 | 2018-10-15 | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724449 | 20180917.ifs | 2018-09-17 | 2018-09-18 | |||||||
3286869 | 3286869 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-09-28 | 2018-10-01 | 2018-10-15 | 2018-09-17 | 0 | 2018-09-17 | ? | 0 | 0005724449 | 20180917.ifs | 2018-09-17 | 2018-09-18 | |||||||
3144582 | 3144582 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-06-28 | 2018-07-01 | 2018-07-15 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676207 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
3144588 | 3144588 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-06-28 | 2018-07-01 | 2018-07-15 | 2018-06-18 | 0 | 2018-06-18 | ? | 0 | 0005676207 | 20180618.ifs | 2018-06-18 | 2018-06-19 | |||||||
2999704 | 2999704 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-03-28 | 2018-04-01 | 2018-04-15 | 2018-03-20 | 0 | 2018-03-20 | ? | 0 | 0005631416 | 20180320.ifs | 2018-03-20 | 2018-03-21 | |||||||
2999796 | 2999796 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2018-03-28 | 2018-04-01 | 2018-04-15 | 2018-03-20 | 0 | 2018-03-20 | ? | 0 | 0005631416 | 20180320.ifs | 2018-03-20 | 2018-03-21 | |||||||
2840893 | 2840893 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2017-12-28 | 2018-01-01 | 2018-01-15 | 2017-12-18 | 0 | 2017-12-18 | ? | 0 | 0005562784 | 20171218.ifs | 2017-12-18 | 2017-12-19 | |||||||
2678665 | 2678665 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2017-09-28 | 2017-10-01 | 2017-10-15 | 2017-09-19 | 0 | 2017-09-19 | ? | 0 | 0005499025 | 20170919.ifs | 2017-09-19 | 2017-09-20 | |||||||
2678952 | 2678952 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2017-09-28 | 2017-10-01 | 2017-10-15 | 2017-09-19 | 0 | 2017-09-19 | ? | 0 | 0005499025 | 20170919.ifs | 2017-09-19 | 2017-09-20 | |||||||
2594535 | 2594535 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2017-06-28 | 2017-07-01 | 2017-07-15 | 2017-06-16 | 0 | 2017-06-16 | ? | 0 | 0005450779 | 20170616.ifs | 2017-06-16 | 2017-06-17 | |||||||
2515821 | 2515821 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2017-03-29 | 2017-04-01 | 2017-04-15 | 2017-03-17 | 0 | 2017-03-17 | ? | 0 | 0005404067 | 20170317.ifs | 2017-03-17 | 2017-03-18 | |||||||
2433398 | 2433398 | EQUITY | CHANGE | 00170F209 | 5.15 CONV TR PFD SECS | 0 | G | 2011-09-14 | ? | 0 | no | no | no | 2011-09-14 | 2016-12-21 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2433399 | 2433398 | EQUITY | CHANGE | 00170F209 | 5.15 CONV TR PFD SECS | 0 | G | 2011-09-14 | ? | 4 | no | no | no | 2011-09-14 | 2016-12-21 | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2389613 | 2389613 | EQUITY | CHANGE | 00170F209 | 5.15 CONV TR PFD SECS | N | G | 2011-09-14 | ? | 0 | no | no | no | 2011-09-14 | ? | ? | 20161221.ifs | 2016-12-21 | 2016-12-22 | ||||||||||
2389614 | 2389613 | EQUITY | CHANGE | 00170F209 | 5.15 CONV TR PFD SECS | 0 | G | 2011-09-14 | ? | 0 | no | no | no | 2011-09-14 | 2016-12-21 | ? | 20161221.ifs | 2016-12-21 | 2016-12-22 | ||||||||||
2389588 | 2389588 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2016-12-28 | 2017-01-01 | 2017-01-15 | 2016-12-20 | 0 | 2016-12-20 | ? | 0 | 0005344126 | 20161220.ifs | 2016-12-20 | 2016-12-21 | |||||||
2296514 | 2296514 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2016-09-28 | 2016-10-01 | 2016-10-15 | 2016-09-16 | 0 | 2016-09-16 | ? | 0 | 0005282205 | 20160916.ifs | 2016-09-16 | 2016-09-17 | |||||||
2227284 | 2227284 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2016-06-29 | 2016-07-01 | 2016-07-15 | 2016-06-21 | 0 | 2016-06-21 | ? | 0 | 0005235868 | 20160621.ifs | 2016-06-21 | 2016-06-22 | |||||||
2137781 | 2137781 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2016-03-30 | 2016-04-01 | 2016-04-15 | 2016-03-17 | 0 | 2016-03-17 | ? | 0 | 0005187808 | 20160317.ifs | 2016-03-17 | 2016-03-18 | |||||||
2044459 | 2044459 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2015-12-29 | 2016-01-01 | 2016-01-15 | 2015-12-16 | 0 | 2015-12-16 | ? | 0 | 0005119444 | 20151216.ifs | 2015-12-16 | 2015-12-17 | |||||||
1968565 | 1968565 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2015-09-29 | 2015-10-01 | 2015-10-15 | 2015-09-17 | 0 | 2015-09-17 | ? | 0 | 0005063105 | 20150917.ifs | 2015-09-17 | 2015-09-18 | |||||||
1888436 | 1888436 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2015-06-29 | 2015-07-01 | 2015-07-15 | 2015-06-17 | 0 | 2015-06-17 | ? | 0 | 0005014437 | 20150617.ifs | 2015-06-17 | 2015-06-18 | |||||||
1816381 | 1816381 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2015-03-30 | 2015-04-01 | 2015-04-15 | 2015-03-19 | 0 | 2015-03-19 | ? | 0 | 0004970173 | 20150319.ifs | 2015-03-19 | 2015-03-20 | |||||||
1729548 | 1729548 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2014-12-29 | 2015-01-01 | 2015-01-15 | 2014-12-18 | 0 | 2014-12-18 | ? | 0 | 0004906702 | 20141218.ifs | 2014-12-18 | 2014-12-19 | |||||||
1631291 | 1631291 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2014-09-29 | 2014-10-01 | 2014-10-15 | 2014-09-16 | 0 | 2014-09-16 | ? | 0 | 0004843319 | 20140916.ifs | 2014-09-16 | 2014-09-17 | |||||||
1552808 | 1552808 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2014-06-26 | 2014-07-01 | 2014-07-15 | 2014-06-18 | 0 | 2014-06-18 | ? | 0 | 0004797679 | 20140618.ifs | 2014-06-18 | 2014-06-19 | |||||||
1471059 | 1471059 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2014-03-28 | 2014-04-01 | 2014-04-15 | 2014-03-19 | 0 | 2014-03-19 | ? | 0 | 0004752064 | 20140319.ifs | 2014-03-19 | 2014-03-20 | |||||||
1397765 | 1397765 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2013-12-27 | 2014-01-01 | 2014-01-15 | 2013-12-26 | 0 | 2013-12-26 | ? | 0 | 0004705025 | 20131226.ifs | 2013-12-26 | 2013-12-27 | |||||||
1290371 | 1290371 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2013-09-27 | 2013-10-01 | 2013-10-15 | 2013-09-18 | 0 | 2013-09-18 | ? | 0 | 0004630192 | 20130918.ifs | 2013-09-18 | 2013-09-19 | |||||||
1215187 | 1215187 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2013-06-27 | 2013-07-01 | 2013-07-15 | 2013-06-21 | 0 | 2013-06-21 | ? | 0 | 0004587220 | 20130621.ifs | 2013-06-21 | 2013-06-22 | |||||||
1138036 | 1138036 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2013-03-27 | 2013-04-01 | 2013-04-15 | 2013-03-20 | 0 | 2013-03-20 | ? | 0 | 0004543362 | 20130320.ifs | 2013-03-20 | 2013-03-21 | |||||||
1058224 | 1058224 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2012-12-27 | 2013-01-01 | 2013-01-15 | 2012-12-21 | 0 | 2012-12-21 | ? | 0 | 0004491179 | 20121221.ifs | 2012-12-21 | 2012-12-22 | |||||||
961277 | 961277 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2012-09-27 | 2012-10-01 | 2012-10-15 | 2012-09-20 | 0 | 2012-09-20 | ? | 0 | 0004432068 | 20120920.ifs | 2012-09-20 | 2012-09-21 | |||||||
892333 | 892333 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2012-06-27 | 2012-07-01 | 2012-07-15 | 2012-06-22 | 0 | 2012-06-22 | ? | 0 | 0004390250 | 20120622.ifs | 2012-06-22 | 2012-06-23 | |||||||
808917 | 808917 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2012-03-28 | 2012-04-01 | 2012-04-15 | 2012-03-22 | 0 | 2012-03-22 | ? | 0 | 0004348513 | 20120322.ifs | 2012-03-22 | 2012-03-23 | |||||||
649793 | 649793 | DIVIDEND | ADD | 00170F209 | 0 | 0 | 1 | 0 | .64375 | 00 | 2011-09-28 | 2011-10-01 | 2011-10-15 | 2011-09-21 | 0 | 2011-09-21 | ? | 0 | 0004244943 | 20110921.ifs | 2011-09-21 | 2011-09-22 | |||||||
645994 | 645994 | DIVIDEND | ADD | 00170F209 | 0 | 1 | 1 | 4 | .64375 | 14 | ? | 2011-07-01 | 2011-07-15 | 2011-09-16 | 0 | 2011-09-16 | ? | 0 | 0004243388 | 20110916.ifs | 2011-09-16 | 2011-09-17 | |||||||
642348 | 642348 | EQUITY | ADD | 00170F209 | 5.15 CONV TR PFD SECS | N | G | 2011-09-14 | ? | 0 | no | no | no | 2011-09-14 | ? | ? | 20110914.ifs | 2011-09-14 | 2011-09-15 | ||||||||||
642349 | 642349 | EXCHANGE | ADD | 00170F209 | 66 | 2011-09-14 | ? | AATRL | 0 | G | 2011-09-14 | ? | 20110914.ifs | 2011-09-14 | 2011-09-15 |
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 = 159576
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