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:148492 |
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 | ||
3826842 | 3826842 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2018-10-30 | 1 | no | no | no | 2006-10-26 | 2018-10-30 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826843 | 3826843 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2018-10-30 | 1 | no | no | no | 2006-10-26 | 2018-10-30 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826844 | 3826843 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2019-07-03 | 1 | no | no | no | 2006-10-26 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826845 | 3826844 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2019-07-03 | 1 | no | no | no | 2006-10-26 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826864 | 3826864 | CORPACTION | DELETE | Y38472224 | 66 | D | 2018-10-30 | 2018-10-30 | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||||||||||
3826865 | 3826865 | CORPACTION | DELETE | Y38472224 | 66 | D | 2018-10-30 | 2018-10-30 | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||||||||||
3826866 | 3826866 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2019-07-03 | 1 | no | no | no | 2006-10-26 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826867 | 3826867 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2019-07-03 | 1 | no | no | no | 2006-10-26 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826868 | 3826867 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 1 | no | no | no | 2006-10-26 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3826869 | 3826868 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 1 | no | no | no | 2006-10-26 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | ||||||||||
3779721 | 3779721 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-06-30 | ? | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898302 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3779787 | 3779787 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2019-06-30 | ? | 2019-06-14 | 0 | 2019-06-14 | ? | 0 | 0005898302 | 20190614.ifs | 2019-06-14 | 2019-06-15 | |||||||
3691106 | 3691106 | DIVIDEND | DELETE | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778699 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691107 | 3691107 | DIVIDEND | DELETE | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778699 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691108 | 3691108 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 3100 | 53 | ? | 2018-12-31 | 2019-04-19 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-23 | 0 | 0005778699 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3691109 | 3691109 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 3100 | 53 | ? | 2018-12-31 | 2019-04-19 | 2018-12-14 | 1 | 2018-12-14 | 2019-04-23 | 0 | 0005778699 | 20190423.ifs | 2019-04-23 | 2019-04-24 | |||||||
3437970 | 3437970 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778699 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3438849 | 3438849 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-12-31 | ? | 2018-12-14 | 0 | 2018-12-14 | ? | 0 | 0005778699 | 20181214.ifs | 2018-12-14 | 2018-12-15 | |||||||
3343341 | 3343341 | EXCHANGE | CHANGE | Y38472224 | 66 | 2006-10-26 | 2017-10-26 | HYMOF | 0 | 1 | 2006-10-26 | ? | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||||||
3343343 | 3343342 | EXCHANGE | CHANGE | Y38472224 | 66 | 2006-10-26 | 2018-10-29 | HYMOF | 0 | 1 | 2006-10-26 | 2018-10-30 | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||||||
3343345 | 3343345 | CORPACTION | ADD | Y38472224 | 66 | D | 2018-10-30 | 2018-10-30 | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||||||||||
3343347 | 3343347 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 1 | no | no | no | 2006-10-26 | 2012-12-05 | ? | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||
3343349 | 3343348 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2018-10-30 | 1 | no | no | no | 2006-10-26 | 2018-10-30 | ? | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||
3343381 | 3343381 | EXCHANGE | CHANGE | Y38472224 | 66 | 2006-10-26 | 2017-10-26 | HYMOF | 0 | 1 | 2006-10-26 | ? | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||||||
3343383 | 3343382 | EXCHANGE | CHANGE | Y38472224 | 66 | 2006-10-26 | 2018-10-29 | HYMOF | 0 | 1 | 2006-10-26 | 2018-10-30 | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||||||
3343385 | 3343385 | CORPACTION | ADD | Y38472224 | 66 | D | 2018-10-30 | 2018-10-30 | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||||||||||
3343387 | 3343387 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 1 | no | no | no | 2006-10-26 | 2012-12-05 | ? | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||
3343389 | 3343388 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | D | 1 | 2006-10-26 | 2018-10-30 | 1 | no | no | no | 2006-10-26 | 2018-10-30 | ? | 20181030.ifs | 2018-10-30 | 2018-10-31 | ||||||||||
3148254 | 3148254 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-06-30 | ? | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005677895 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148256 | 3148256 | DIVIDEND | CHANGE | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2017-12-29 | 2018-04-13 | 2018-04-16 | 0 | 2018-04-16 | ? | 0 | 0005647257 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148258 | 3148257 | DIVIDEND | CHANGE | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2017-12-29 | 2018-04-13 | 2018-04-16 | 1 | 2018-04-16 | 2018-06-20 | 0 | 0005647257 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148259 | 3148259 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2018-06-30 | ? | 2018-06-20 | 0 | 2018-06-20 | ? | 0 | 0005677895 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148261 | 3148261 | DIVIDEND | CHANGE | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2017-12-29 | 2018-04-13 | 2018-04-16 | 0 | 2018-04-16 | ? | 0 | 0005647257 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3148263 | 3148262 | DIVIDEND | CHANGE | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2017-12-29 | 2018-04-13 | 2018-04-16 | 1 | 2018-04-16 | 2018-06-20 | 0 | 0005647257 | 20180620.ifs | 2018-06-20 | 2018-06-21 | |||||||
3039490 | 3039490 | DIVIDEND | ADD | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2017-12-29 | 2018-04-13 | 2018-04-16 | 0 | 2018-04-16 | ? | 0 | 0005647257 | 20180416.ifs | 2018-04-16 | 2018-04-17 | |||||||
3039491 | 3039491 | DIVIDEND | ADD | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2017-12-29 | 2018-04-13 | 2018-04-16 | 0 | 2018-04-16 | ? | 0 | 0005647257 | 20180416.ifs | 2018-04-16 | 2018-04-17 | |||||||
2649185 | 2649185 | DIVIDEND | DELETE | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2017-06-30 | ? | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005453903 | 20170814.ifs | 2017-08-14 | 2017-08-15 | |||||||
2649186 | 2649186 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 1000 | 53 | ? | 2017-06-30 | 2017-08-14 | 2017-06-23 | 1 | 2017-06-23 | 2017-08-14 | 0 | 0005453903 | 20170814.ifs | 2017-08-14 | 2017-08-15 | |||||||
2599798 | 2599798 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2017-06-30 | ? | 2017-06-23 | 0 | 2017-06-23 | ? | 0 | 0005453903 | 20170623.ifs | 2017-06-23 | 2017-06-24 | |||||||
2544013 | 2544013 | DIVIDEND | ADD | Y38472224 | A | 1 | 3 | 0 | 3100 | 53 | ? | 2016-12-30 | 2017-04-14 | 2017-04-19 | 0 | 2017-04-19 | ? | 1 | 0005421916 | 20170419.ifs | 2017-04-19 | 2017-04-20 | |||||||
2544014 | 2544014 | DIVIDEND | DELETE | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2016-06-30 | ? | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235310 | 20170419.ifs | 2017-04-19 | 2017-04-20 | |||||||
2544015 | 2544015 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 1000 | 53 | ? | 2016-06-30 | 2016-08-12 | 2016-06-20 | 1 | 2016-06-20 | 2017-04-19 | 0 | 0005235310 | 20170419.ifs | 2017-04-19 | 2017-04-20 | |||||||
2473051 | 2473051 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 0 | no | no | no | 2006-10-26 | 2012-12-05 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2473052 | 2473051 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 1 | no | no | no | 2006-10-26 | 2012-12-05 | ? | 20170126.ifs | 2017-01-26 | 2017-01-27 | ||||||||||
2224955 | 2224955 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2016-06-30 | ? | 2016-06-20 | 0 | 2016-06-20 | ? | 0 | 0005235310 | 20160620.ifs | 2016-06-20 | 2016-06-21 | |||||||
2163108 | 2163108 | DIVIDEND | ADD | Y38472224 | 0 | 1 | 3 | 6 | 0 | 08 | ? | 2015-12-31 | 2016-04-08 | 2016-04-12 | 0 | 2016-04-12 | ? | 0 | 0005204986 | 20160412.ifs | 2016-04-12 | 2016-04-13 | |||||||
1915572 | 1915572 | DIVIDEND | DELETE | Y38472224 | A | 3 | 0 | 3000 | 53 | ? | 2014-12-31 | 2015-04-10 | ? | 0 | 2015-04-15 | ? | 0 | 0004911312 | 20150714.ifs | 2015-07-14 | 2015-07-15 | ||||||||
1915573 | 1915573 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 3000 | 0 | 53 | ? | 2014-12-31 | 2015-04-10 | 2014-12-19 | 0 | ? | 2015-07-14 | 0 | 0004911312 | 20150714.ifs | 2015-07-14 | 2015-07-15 | ||||||
1840522 | 1840522 | DIVIDEND | ADD | Y38472224 | A | 3 | 0 | 3000 | 53 | ? | 2014-12-31 | 2015-04-10 | ? | 0 | 2015-04-15 | ? | 0 | 0004911312 | 20150415.ifs | 2015-04-15 | 2015-04-16 | ||||||||
1498047 | 1498047 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 2000 | 53 | ? | 2013-12-31 | 2014-04-18 | 2013-12-19 | 0 | ? | 2014-04-21 | 0 | 0004693660 | 20140421.ifs | 2014-04-21 | 2014-04-22 | |||||||
1162744 | 1162744 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 1950 | 53 | ? | 2012-12-31 | 2013-04-12 | 2012-12-17 | 0 | ? | 2013-04-19 | 0 | 0004483756 | 20130419.ifs | 2013-04-19 | 2013-04-20 | |||||||
1028012 | 1028012 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | 2012-09-25 | 0 | no | no | no | 2006-10-26 | 2012-09-25 | ? | 20121205.ifs | 2012-12-05 | 2012-12-06 | ||||||||||
1028013 | 1028012 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | ? | 0 | no | no | no | 2006-10-26 | 2012-12-05 | ? | 20121205.ifs | 2012-12-05 | 2012-12-06 | ||||||||||
963841 | 963841 | EQUITY | CHANGE | Y38472224 | COM | D | 0 | 2006-10-26 | 2009-08-03 | 0 | no | no | no | 2006-10-26 | 2009-09-18 | ? | 20120925.ifs | 2012-09-25 | 2012-09-26 | ||||||||||
963842 | 963841 | EQUITY | CHANGE | Y38472224 | COM | D | 0 | 2006-10-26 | 2012-09-25 | 0 | no | no | no | 2006-10-26 | 2012-09-25 | ? | 20120925.ifs | 2012-09-25 | 2012-09-26 | ||||||||||
963934 | 963934 | CORPACTION | DELETE | Y38472224 | 66 | D | 2009-08-03 | ? | 20120925.ifs | 2012-09-25 | 2012-09-26 | ||||||||||||||||||
963941 | 963941 | EQUITY | CHANGE | Y38472224 | COM | D | 0 | 2006-10-26 | 2012-09-25 | 0 | no | no | no | 2006-10-26 | 2012-09-25 | ? | 20120925.ifs | 2012-09-25 | 2012-09-26 | ||||||||||
963942 | 963941 | EQUITY | CHANGE | Y38472224 | PFD SHS ISSUED 1999 | 0 | 1 | 2006-10-26 | 2012-09-25 | 0 | no | no | no | 2006-10-26 | 2012-09-25 | ? | 20120925.ifs | 2012-09-25 | 2012-09-26 | ||||||||||
854295 | 854295 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 1800 | 53 | ? | 2011-12-31 | 2012-04-16 | 2011-12-15 | 0 | ? | 2012-05-03 | 0 | 0004288290 | 20120503.ifs | 2012-05-03 | 2012-05-04 | |||||||
500519 | 500519 | DIVIDEND | DELETE | Y38472224 | A | 3 | 0 | 1500 | 53 | ? | 2010-12-31 | 2011-04-11 | ? | 0 | 2011-04-11 | ? | 0 | 0004105204 | 20110412.ifs | 2011-04-12 | 2011-04-13 | ||||||||
500520 | 500520 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 1500 | 0 | 53 | ? | 2010-12-31 | 2011-04-11 | 2010-12-15 | 0 | ? | 2011-04-12 | 0 | 0004105204 | 20110412.ifs | 2011-04-12 | 2011-04-13 | ||||||
500251 | 500251 | DIVIDEND | ADD | Y38472224 | A | 3 | 0 | 1500 | 53 | ? | 2010-12-31 | 2011-04-11 | ? | 0 | 2011-04-11 | ? | 0 | 0004105204 | 20110411.ifs | 2011-04-11 | 2011-04-12 | ||||||||
379129 | 379129 | DIVIDEND | DELETE | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2010-12-31 | ? | 2010-12-15 | 0 | 2010-12-15 | ? | 0 | 0004105204 | 20101216.ifs | 2010-12-16 | 2010-12-17 | |||||||
377841 | 377841 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | ? | 2010-12-31 | ? | 2010-12-15 | 0 | 2010-12-15 | ? | 0 | 0004105204 | 20101215.ifs | 2010-12-15 | 2010-12-16 | |||||||
159421 | 159421 | DIVIDEND | DELETE | Y38472224 | A | 3 | 0 | 1250 | 53 | 2009-12-29 | 2009-12-31 | 2010-04-12 | ? | 0 | 2010-04-14 | ? | 0 | 0003930307 | 20100415.ifs | 2010-04-15 | 2010-04-16 | ||||||||
159422 | 159422 | DIVIDEND | ADD | Y38472224 | A | 0 | 3 | 0 | 1250 | 0 | 53 | 2009-12-29 | 2009-12-31 | 2010-04-12 | 2009-12-17 | 0 | ? | 2010-04-15 | 0 | 0003930307 | 20100415.ifs | 2010-04-15 | 2010-04-16 | ||||||
159106 | 159106 | DIVIDEND | ADD | Y38472224 | A | 3 | 0 | 1250 | 53 | 2009-12-29 | 2009-12-31 | 2010-04-12 | ? | 0 | 2010-04-14 | ? | 0 | 0003930307 | 20100414.ifs | 2010-04-14 | 2010-04-15 | ||||||||
58038 | 58038 | DIVIDEND | DELETE | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | 2009-12-29 | 2009-12-31 | ? | 2009-12-18 | 0 | 2009-12-18 | ? | 0 | 0003930307 | 20091221.ifs | 2009-12-21 | 2010-04-07 | |||||||
55334 | 55334 | DIVIDEND | ADD | Y38472224 | 0 | 0 | 3 | 6 | 0 | 08 | 2009-12-29 | 2009-12-31 | ? | 2009-12-18 | 0 | 2009-12-18 | ? | 0 | 0003930307 | 20091218.ifs | 2009-12-18 | 2010-04-07 |
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 = 148492
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