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:139847 |
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 | ||
3374599 | 3374599 | CORPACTION | ADD | 184691103 | 01 | M | 2018-11-19 | 18469P100 | 01 | ? | 20181119.ifs | 2018-11-19 | 2018-11-20 | ||||||||||||||||
3374601 | 3374601 | EQUITY | CHANGE | 184691103 | COM | 0 | 0 | 2013-06-26 | ? | 4 | no | no | no | 2013-06-26 | 2017-01-27 | ? | 20181119.ifs | 2018-11-19 | 2018-11-20 | ||||||||||
3374603 | 3374602 | EQUITY | CHANGE | 184691103 | COM | M | 0 | 2013-06-26 | 2018-11-19 | 4 | no | no | 18469P100 | no | 2013-06-26 | 2018-11-19 | ? | 20181119.ifs | 2018-11-19 | 2018-11-20 | |||||||||
3374604 | 3374604 | CORPACTION | ADD | 184691103 | 01 | M | 2018-11-19 | 18469P100 | 01 | ? | 20181119.ifs | 2018-11-19 | 2018-11-20 | ||||||||||||||||
3374606 | 3374606 | EQUITY | CHANGE | 184691103 | COM | 0 | 0 | 2013-06-26 | ? | 4 | no | no | no | 2013-06-26 | 2017-01-27 | ? | 20181119.ifs | 2018-11-19 | 2018-11-20 | ||||||||||
3374608 | 3374607 | EQUITY | CHANGE | 184691103 | COM | M | 0 | 2013-06-26 | 2018-11-19 | 4 | no | no | 18469P100 | no | 2013-06-26 | 2018-11-19 | ? | 20181119.ifs | 2018-11-19 | 2018-11-20 | |||||||||
3375329 | 3375329 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 2 | 2018-08-16 | 2018-11-16 | 0 | 0005708532 | 20181119.ifs | 2018-11-19 | 2018-11-20 | |||||||
3375330 | 3375330 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 2 | 2018-08-16 | 2018-11-16 | 0 | 0005708532 | 20181119.ifs | 2018-11-19 | 2018-11-20 | |||||||
3375331 | 3375330 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 3 | 2018-08-16 | 2018-11-19 | 0 | 0005708532 | 20181119.ifs | 2018-11-19 | 2018-11-20 | |||||||
3375332 | 3375331 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 3 | 2018-08-16 | 2018-11-19 | 0 | 0005708532 | 20181119.ifs | 2018-11-19 | 2018-11-20 | |||||||
3373998 | 3373998 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 1 | 2018-08-16 | 2018-11-09 | 0 | 0005708532 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3374000 | 3373999 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 2 | 2018-08-16 | 2018-11-16 | 0 | 0005708532 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3374013 | 3374013 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 1 | 2018-08-16 | 2018-11-09 | 0 | 0005708532 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3374015 | 3374014 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 2 | 2018-08-16 | 2018-11-16 | 0 | 0005708532 | 20181116.ifs | 2018-11-16 | 2018-11-17 | |||||||
3368091 | 3368091 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 0 | 2018-08-16 | ? | 0 | 0005708532 | 20181109.ifs | 2018-11-09 | 2018-11-10 | |||||||
3368093 | 3368092 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 1 | 2018-08-16 | 2018-11-09 | 0 | 0005708532 | 20181109.ifs | 2018-11-09 | 2018-11-10 | |||||||
3368118 | 3368118 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 0 | 2018-08-16 | ? | 0 | 0005708532 | 20181109.ifs | 2018-11-09 | 2018-11-10 | |||||||
3368120 | 3368119 | DIVIDEND | CHANGE | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 1 | 2018-08-16 | 2018-11-09 | 0 | 0005708532 | 20181109.ifs | 2018-11-09 | 2018-11-10 | |||||||
3241562 | 3241562 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 0 | 2018-08-16 | ? | 0 | 0005708532 | 20180816.ifs | 2018-08-16 | 2018-08-17 | |||||||
3241603 | 3241603 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-08-23 | 2018-08-24 | 2018-08-31 | 2018-08-16 | 0 | 2018-08-16 | ? | 0 | 0005708532 | 20180816.ifs | 2018-08-16 | 2018-08-17 | |||||||
3089985 | 3089985 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-05-23 | 2018-05-24 | 2018-05-31 | 2018-05-14 | 0 | 2018-05-14 | ? | 0 | 0005661235 | 20180514.ifs | 2018-05-14 | 2018-05-15 | |||||||
3090064 | 3090064 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-05-23 | 2018-05-24 | 2018-05-31 | 2018-05-14 | 0 | 2018-05-14 | ? | 0 | 0005661235 | 20180514.ifs | 2018-05-14 | 2018-05-15 | |||||||
2924831 | 2924831 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-02-15 | 2018-02-16 | 2018-03-01 | 2018-01-22 | 0 | 2018-01-22 | ? | 0 | 0005602928 | 20180122.ifs | 2018-01-22 | 2018-01-23 | |||||||
2924832 | 2924832 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2018-02-15 | 2018-02-16 | 2018-03-01 | 2018-01-22 | 0 | 2018-01-22 | ? | 0 | 0005602928 | 20180122.ifs | 2018-01-22 | 2018-01-23 | |||||||
2763817 | 2763817 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2017-11-22 | 2017-11-24 | 2017-11-30 | 2017-11-13 | 0 | 2017-11-13 | ? | 0 | 0005529241 | 20171113.ifs | 2017-11-13 | 2017-11-14 | |||||||
2764323 | 2764323 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2017-11-22 | 2017-11-24 | 2017-11-30 | 2017-11-13 | 0 | 2017-11-13 | ? | 0 | 0005529241 | 20171113.ifs | 2017-11-13 | 2017-11-14 | |||||||
2649428 | 2649428 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2017-08-23 | 2017-08-25 | 2017-09-01 | 2017-08-14 | 0 | 2017-08-14 | ? | 0 | 0005482668 | 20170814.ifs | 2017-08-14 | 2017-08-15 | |||||||
2565997 | 2565997 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2017-05-17 | 2017-05-19 | 2017-06-01 | 2017-05-11 | 0 | 2017-05-11 | ? | 0 | 0005434508 | 20170511.ifs | 2017-05-11 | 2017-05-12 | |||||||
2473829 | 2473829 | EQUITY | CHANGE | 184691103 | COM | N | 0 | 2013-06-26 | ? | 4 | no | no | no | 2013-06-26 | ? | ? | 20170127.ifs | 2017-01-27 | 2017-01-28 | ||||||||||
2473830 | 2473829 | EQUITY | CHANGE | 184691103 | COM | 0 | 0 | 2013-06-26 | ? | 4 | no | no | no | 2013-06-26 | 2017-01-27 | ? | 20170127.ifs | 2017-01-27 | 2017-01-28 | ||||||||||
2473708 | 2473708 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2017-02-15 | 2017-02-17 | 2017-02-24 | 2017-01-26 | 0 | 2017-01-26 | ? | 0 | 0005377876 | 20170126.ifs | 2017-01-26 | 2017-01-27 | |||||||
2436078 | 2436078 | EQUITY | CHANGE | 184691103 | COM | N | 0 | 2013-06-26 | ? | 0 | no | no | no | 2013-06-26 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2436079 | 2436078 | EQUITY | CHANGE | 184691103 | COM | N | 0 | 2013-06-26 | ? | 4 | no | no | no | 2013-06-26 | ? | ? | 20170123.ifs | 2017-01-23 | 2017-01-24 | ||||||||||
2325691 | 2325691 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2016-11-16 | 2016-11-18 | 2016-11-25 | 2016-10-24 | 0 | 2016-10-24 | ? | 0 | 0005300131 | 20161024.ifs | 2016-10-24 | 2016-10-25 | |||||||
2254959 | 2254959 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2016-08-17 | 2016-08-19 | 2016-08-26 | 2016-07-21 | 0 | 2016-07-21 | ? | 0 | 0005252974 | 20160721.ifs | 2016-07-21 | 2016-07-22 | |||||||
2172820 | 2172820 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2016-05-18 | 2016-05-20 | 2016-05-27 | 2016-04-25 | 0 | 2016-04-25 | ? | 0 | 0005207579 | 20160425.ifs | 2016-04-25 | 2016-04-26 | |||||||
2106709 | 2106709 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .2 | 00 | 2016-02-17 | 2016-02-19 | 2016-02-26 | 2016-02-01 | 0 | 2016-02-01 | ? | 0 | 0005166470 | 20160201.ifs | 2016-02-01 | 2016-02-02 | |||||||
1995164 | 1995164 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .305 | 00 | 2015-11-18 | 2015-11-20 | 2015-11-27 | 2015-10-22 | 0 | 2015-10-22 | ? | 0 | 0005081315 | 20151022.ifs | 2015-10-22 | 2015-10-23 | |||||||
1922875 | 1922875 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .305 | 00 | 2015-08-19 | 2015-08-21 | 2015-08-28 | 2015-07-24 | 0 | 2015-07-24 | ? | 0 | 0005035372 | 20150724.ifs | 2015-07-24 | 2015-07-25 | |||||||
1843316 | 1843316 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .305 | 00 | 2015-05-20 | 2015-05-22 | 2015-05-29 | 2015-04-20 | 0 | 2015-04-20 | ? | 0 | 0004987024 | 20150420.ifs | 2015-04-20 | 2015-04-21 | |||||||
1774887 | 1774887 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .305 | 00 | 2015-02-18 | 2015-02-20 | 2015-02-27 | 2015-01-26 | 0 | 2015-01-26 | ? | 0 | 0004943794 | 20150126.ifs | 2015-01-26 | 2015-01-27 | |||||||
1660022 | 1660022 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .305 | 00 | 2014-11-19 | 2014-11-21 | 2014-11-28 | 2014-10-20 | 0 | 2014-10-20 | ? | 0 | 0004860463 | 20141020.ifs | 2014-10-20 | 2014-10-21 | |||||||
1586251 | 1586251 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-08-20 | 2014-08-22 | 2014-08-29 | 2014-07-24 | 0 | 2014-07-24 | ? | 0 | 0004817207 | 20140724.ifs | 2014-07-24 | 2014-07-25 | |||||||
1498980 | 1498980 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-05-21 | 2014-05-23 | 2014-05-30 | 2014-04-21 | 0 | 2014-04-21 | ? | 0 | 0004769118 | 20140421.ifs | 2014-04-21 | 2014-04-22 | |||||||
1428138 | 1428138 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .3 | 00 | 2014-02-19 | 2014-02-21 | 2014-02-28 | 2014-01-27 | 0 | 2014-01-27 | ? | 0 | 0004726110 | 20140127.ifs | 2014-01-27 | 2014-01-28 | |||||||
1319612 | 1319612 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 0 | .3 | 00 | 2013-11-20 | 2013-11-22 | 2013-11-29 | 2013-10-21 | 0 | 2013-10-21 | ? | 0 | 0004646299 | 20131021.ifs | 2013-10-21 | 2013-10-22 | |||||||
1259614 | 1259614 | DIVIDEND | ADD | 184691103 | 0 | 0 | 1 | 4 | .3 | 00 | 2013-08-14 | 2013-08-16 | 2013-08-23 | 2013-08-05 | 0 | 2013-08-05 | ? | 0 | 0004613368 | 20130805.ifs | 2013-08-05 | 2013-08-06 | |||||||
1218161 | 1218161 | EQUITY | ADD | 184691103 | COM | N | 0 | 2013-06-26 | ? | 0 | no | no | no | 2013-06-26 | ? | ? | 20130626.ifs | 2013-06-26 | 2013-06-27 | ||||||||||
1218162 | 1218162 | EXCHANGE | ADD | 184691103 | 01 | 2013-06-26 | 2013-06-26 | CBA | 0 | 0 | 2013-06-26 | ? | 20130626.ifs | 2013-06-26 | 2013-06-27 |
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 = 139847
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