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:145633 |
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 | ||
2114518 | 2114518 | CORPACTION | ADD | G1245Z108 | 66 | D | 2016-02-18 | ? | 20160218.ifs | 2016-02-18 | 2016-02-19 | ||||||||||||||||||
2114519 | 2114519 | EQUITY | CHANGE | G1245Z108 | COM | 0 | 0 | 2000-01-20 | ? | 0 | no | no | no | 2000-01-28 | 2000-01-21 | ? | 20160218.ifs | 2016-02-18 | 2016-02-19 | ||||||||||
2114520 | 2114519 | EQUITY | CHANGE | G1245Z108 | COM | D | 0 | 2000-01-20 | 2016-02-18 | 0 | no | no | no | 2000-01-28 | 2016-02-18 | ? | 20160218.ifs | 2016-02-18 | 2016-02-19 | ||||||||||
1934887 | 1934887 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .1438 | 28 | 2015-08-13 | 2015-08-14 | 2015-09-11 | 2015-08-03 | 0 | 2015-08-03 | ? | 0 | 0005043317 | 20150804.ifs | 2015-08-04 | 2015-08-05 | |||||||
1934888 | 1934887 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .1438 | 28 | 2015-08-13 | 2015-08-14 | 2015-09-11 | 2015-08-03 | 1 | 2015-08-03 | 2015-08-04 | 0 | 0005043317 | 20150804.ifs | 2015-08-04 | 2015-08-05 | |||||||
1931264 | 1931264 | DIVIDEND | ADD | G1245Z108 | 6 | 0 | 3 | 0 | .1438 | 28 | 2015-08-13 | 2015-08-14 | 2015-09-11 | 2015-08-03 | 0 | 2015-08-03 | ? | 0 | 0005043317 | 20150803.ifs | 2015-08-03 | 2015-08-04 | |||||||
1839220 | 1839220 | DIVIDEND | ADD | G1245Z108 | 6 | 0 | 3 | 0 | .1437 | 28 | 2015-04-23 | 2015-04-24 | 2015-05-22 | 2015-04-13 | 0 | 2015-04-13 | ? | 0 | 0004985759 | 20150413.ifs | 2015-04-13 | 2015-04-14 | |||||||
1288254 | 1288254 | DIVIDEND | ADD | G1245Z108 | 6 | 1 | 3 | 0 | .1426 | 28 | ? | 2013-04-19 | 2013-05-31 | 2013-09-16 | 0 | 2013-09-16 | ? | 0 | 0004629428 | 20130916.ifs | 2013-09-16 | 2013-09-17 | |||||||
1288255 | 1288255 | DIVIDEND | ADD | G1245Z108 | 6 | 1 | 3 | 0 | .1307 | 28 | ? | 2013-08-09 | 2013-09-06 | 2013-09-16 | 0 | 2013-09-16 | ? | 1 | 0004629425 | 20130916.ifs | 2013-09-16 | 2013-09-17 | |||||||
951142 | 951142 | DIVIDEND | ADD | G1245Z108 | 0 | 1 | 3 | 6 | 0 | 08 | ? | 2012-08-03 | ? | 2012-09-06 | 0 | 2012-09-06 | ? | 0 | 0004426854 | 20120906.ifs | 2012-09-06 | 2012-09-07 | |||||||
909109 | 909109 | DIVIDEND | ADD | G1245Z108 | 6 | 1 | 3 | 0 | .1296 | 28 | ? | 2012-04-13 | 2012-05-25 | 2012-07-06 | 0 | 2012-07-06 | ? | 0 | 0004401516 | 20120706.ifs | 2012-07-06 | 2012-07-07 | |||||||
595678 | 595678 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .0663 | 28 | 2011-08-03 | 2011-08-05 | 2011-09-08 | 2011-07-27 | 1 | 2011-07-27 | 2011-07-28 | 0 | 0004219890 | 20110729.ifs | 2011-07-29 | 2011-07-30 | |||||||
595679 | 595678 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .108 | 0 | 28 | 2011-08-03 | 2011-08-05 | 2011-09-08 | 2011-07-27 | 1 | 2011-07-27 | 2011-07-29 | 0 | 0004219890 | 20110729.ifs | 2011-07-29 | 2011-07-30 | ||||||
594822 | 594822 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .0663 | 28 | 2011-08-03 | 2011-08-05 | 2011-09-08 | 2011-07-27 | 0 | 2011-07-27 | ? | 0 | 0004219890 | 20110728.ifs | 2011-07-28 | 2011-07-29 | |||||||
594823 | 594822 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .0663 | 28 | 2011-08-03 | 2011-08-05 | 2011-09-08 | 2011-07-27 | 1 | 2011-07-27 | 2011-07-28 | 0 | 0004219890 | 20110728.ifs | 2011-07-28 | 2011-07-29 | |||||||
593933 | 593933 | DIVIDEND | ADD | G1245Z108 | 6 | 0 | 3 | 0 | .0663 | 28 | 2011-08-03 | 2011-08-05 | 2011-09-08 | 2011-07-27 | 0 | 2011-07-27 | ? | 0 | 0004219890 | 20110727.ifs | 2011-07-27 | 2011-07-28 | |||||||
494389 | 494389 | DIVIDEND | ADD | G1245Z108 | 6 | 0 | 3 | 0 | .1178 | 28 | 2011-04-13 | 2011-04-15 | 2011-05-20 | 2011-04-04 | 0 | 2011-04-04 | ? | 0 | 0004173260 | 20110404.ifs | 2011-04-04 | 2011-04-05 | |||||||
300801 | 300801 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .06 | 28 | 2010-08-04 | 2010-08-06 | 2010-09-10 | 2010-07-30 | 0 | 2010-07-30 | ? | 0 | 0004038864 | 20100903.ifs | 2010-09-03 | 2010-09-04 | |||||||
300802 | 300801 | DIVIDEND | CHANGE | G1245Z108 | 6 | 0 | 3 | 0 | .0982 | 0 | 28 | 2010-08-04 | 2010-08-06 | 2010-09-10 | 2010-07-30 | 0 | 2010-07-30 | 2010-09-03 | 0 | 0004038864 | 20100903.ifs | 2010-09-03 | 2010-09-04 | ||||||
263822 | 263822 | DIVIDEND | ADD | G1245Z108 | 6 | 0 | 3 | 0 | .06 | 28 | 2010-08-04 | 2010-08-06 | 2010-09-10 | 2010-07-30 | 0 | 2010-07-30 | ? | 0 | 0004038864 | 20100730.ifs | 2010-07-30 | 2010-07-31 | |||||||
105905 | 105905 | DIVIDEND | ADD | G1245Z108 | 6 | 0 | 3 | 0 | .0673 | 28 | 2010-04-14 | 2010-04-16 | 2010-05-21 | 2010-02-05 | 0 | 2010-02-05 | ? | 0 | 0003963806 | 20100205.ifs | 2010-02-05 | 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 = 145633
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