INSITITUIONS | Dynamic | newInstitTable | Changed the Cusip/Sector/Shs Out? |
|
|||||||
Total Insititutions : | N/A | Update Insititution By Cusips | |||||||||
% Owned by Insititutions: | N/A % | % | |||||||||
pricingQuarterAdminPageOn:
|
2024-03-31 | New % | |||||||||
|
|||||||||||
the compid is:151549 |
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 | ||
1735245 | 1735245 | CORPACTION | ADD | 260537105 | 01 | M | 2014-12-22 | 67075F105 | 01 | ? | 20141222.ifs | 2014-12-22 | 2014-12-23 | ||||||||||||||||
1735246 | 1735246 | EQUITY | CHANGE | 260537105 | COM | 0 | 7 | 2007-05-25 | ? | 0 | no | no | no | 2007-05-25 | 2014-12-16 | ? | 20141222.ifs | 2014-12-22 | 2014-12-23 | ||||||||||
1735247 | 1735246 | EQUITY | CHANGE | 260537105 | COM | M | 7 | 2007-05-25 | 2014-12-22 | 0 | no | no | 67075F105 | no | 2007-05-25 | 2014-12-22 | ? | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||||
1737834 | 1737834 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 3 | 2014-12-01 | 2014-12-19 | 0 | 0004882708 | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||
1737835 | 1737834 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 4 | 2014-12-01 | 2014-12-22 | 0 | 0004882708 | 20141222.ifs | 2014-12-22 | 2014-12-23 | |||||||
1734101 | 1734101 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 2 | 2014-12-01 | 2014-12-11 | 0 | 0004882708 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1734102 | 1734101 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 3 | 2014-12-01 | 2014-12-19 | 0 | 0004882708 | 20141219.ifs | 2014-12-19 | 2014-12-20 | |||||||
1717853 | 1717853 | CORPACTION | DELETE | 260537105 | 01 | M | 2014-12-15 | 2014-12-15 | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||||||||||||||
1717854 | 1717854 | EQUITY | CHANGE | 260537105 | COM | M | 7 | 2007-05-25 | 2014-12-15 | 0 | no | no | no | 2007-05-25 | 2014-12-15 | ? | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||||||
1717855 | 1717854 | EQUITY | CHANGE | 260537105 | COM | 0 | 7 | 2007-05-25 | 2014-12-15 | 0 | no | no | no | 2007-05-25 | 2014-12-16 | ? | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||||||
1717856 | 1717856 | EQUITY | CHANGE | 260537105 | COM | 0 | 7 | 2007-05-25 | 2014-12-15 | 0 | no | no | no | 2007-05-25 | 2014-12-16 | ? | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||||||
1717857 | 1717856 | EQUITY | CHANGE | 260537105 | COM | 0 | 7 | 2007-05-25 | ? | 0 | no | no | no | 2007-05-25 | 2014-12-16 | ? | 20141216.ifs | 2014-12-16 | 2014-12-17 | ||||||||||
1715431 | 1715431 | CORPACTION | ADD | 260537105 | 01 | M | 2014-12-15 | 2014-12-15 | 20141215.ifs | 2014-12-15 | 2014-12-16 | ||||||||||||||||||
1715432 | 1715432 | EQUITY | CHANGE | 260537105 | COM | 0 | 7 | 2007-05-25 | ? | 0 | no | no | no | 2007-05-25 | 2009-06-01 | ? | 20141215.ifs | 2014-12-15 | 2014-12-16 | ||||||||||
1715433 | 1715432 | EQUITY | CHANGE | 260537105 | COM | M | 7 | 2007-05-25 | 2014-12-15 | 0 | no | no | no | 2007-05-25 | 2014-12-15 | ? | 20141215.ifs | 2014-12-15 | 2014-12-16 | ||||||||||
1709747 | 1709747 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 1 | 2014-12-01 | 2014-12-08 | 0 | 0004882708 | 20141211.ifs | 2014-12-11 | 2014-12-12 | |||||||
1709748 | 1709747 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 2 | 2014-12-01 | 2014-12-11 | 0 | 0004882708 | 20141211.ifs | 2014-12-11 | 2014-12-12 | |||||||
1703316 | 1703316 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 0 | 2014-12-01 | ? | 0 | 0004882708 | 20141208.ifs | 2014-12-08 | 2014-12-09 | |||||||
1703317 | 1703316 | DIVIDEND | CHANGE | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 1 | 2014-12-01 | 2014-12-08 | 0 | 0004882708 | 20141208.ifs | 2014-12-08 | 2014-12-09 | |||||||
1695578 | 1695578 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2014-12-10 | 2014-12-12 | 2014-12-31 | 2014-12-01 | 0 | 2014-12-01 | ? | 0 | 0004882708 | 20141201.ifs | 2014-12-01 | 2014-12-02 | |||||||
1621744 | 1621744 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2014-09-11 | 2014-09-15 | 2014-10-01 | 2014-09-02 | 0 | 2014-09-02 | ? | 0 | 0004838351 | 20140902.ifs | 2014-09-02 | 2014-09-03 | |||||||
1540172 | 1540172 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2014-06-11 | 2014-06-13 | 2014-07-01 | 2014-06-02 | 0 | 2014-06-02 | ? | 0 | 0004792544 | 20140602.ifs | 2014-06-02 | 2014-06-03 | |||||||
1458761 | 1458761 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2014-03-12 | 2014-03-14 | 2014-04-01 | 2014-03-03 | 0 | 2014-03-03 | ? | 0 | 0004746990 | 20140303.ifs | 2014-03-03 | 2014-03-04 | |||||||
1355544 | 1355544 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2013-12-11 | 2013-12-13 | 2013-12-31 | 2013-12-02 | 0 | 2013-12-02 | ? | 0 | 0004669169 | 20131202.ifs | 2013-12-02 | 2013-12-03 | |||||||
1280471 | 1280471 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2013-09-11 | 2013-09-13 | 2013-10-01 | 2013-09-03 | 0 | 2013-09-03 | ? | 0 | 0004625427 | 20130903.ifs | 2013-09-03 | 2013-09-04 | |||||||
1202803 | 1202803 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2013-06-12 | 2013-06-14 | 2013-07-01 | 2013-06-03 | 0 | 2013-06-03 | ? | 0 | 0004580604 | 20130603.ifs | 2013-06-03 | 2013-06-04 | |||||||
1126454 | 1126454 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2013-03-13 | 2013-03-15 | 2013-04-01 | 2013-03-01 | 0 | 2013-03-01 | ? | 0 | 0004537554 | 20130301.ifs | 2013-03-01 | 2013-03-02 | |||||||
1025594 | 1025594 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2012-12-12 | 2012-12-14 | 2012-12-31 | 2012-12-03 | 0 | 2012-12-03 | ? | 0 | 0004468665 | 20121203.ifs | 2012-12-03 | 2012-12-04 | |||||||
948533 | 948533 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2012-09-12 | 2012-09-14 | 2012-10-01 | 2012-09-04 | 0 | 2012-09-04 | ? | 0 | 0004425188 | 20120904.ifs | 2012-09-04 | 2012-09-05 | |||||||
877141 | 877141 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2012-06-13 | 2012-06-15 | 2012-07-02 | 2012-06-01 | 0 | 2012-06-01 | ? | 0 | 0004383773 | 20120601.ifs | 2012-06-01 | 2012-06-02 | |||||||
794647 | 794647 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2012-03-13 | 2012-03-15 | 2012-04-02 | 2012-03-01 | 0 | 2012-03-01 | ? | 0 | 0004342446 | 20120301.ifs | 2012-03-01 | 2012-03-02 | |||||||
709588 | 709588 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .218 | 00 | 2011-12-13 | 2011-12-15 | 2011-12-30 | 2011-12-01 | 0 | 2011-12-01 | ? | 0 | 0004279625 | 20111201.ifs | 2011-12-01 | 2011-12-02 | |||||||
634891 | 634891 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .23 | 00 | 2011-09-13 | 2011-09-15 | 2011-10-03 | 2011-09-01 | 0 | 2011-09-01 | ? | 0 | 0004239319 | 20110901.ifs | 2011-09-01 | 2011-09-02 | |||||||
544549 | 544549 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .255 | 00 | 2011-06-13 | 2011-06-15 | 2011-07-01 | 2011-06-01 | 0 | 2011-06-01 | ? | 0 | 0004197456 | 20110601.ifs | 2011-06-01 | 2011-06-02 | |||||||
410874 | 410874 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .255 | 00 | 2011-03-11 | 2011-03-15 | 2011-04-01 | 2011-01-03 | 0 | 2011-01-03 | ? | 0 | 0004131417 | 20110103.ifs | 2011-01-03 | 2011-01-04 | |||||||
348377 | 348377 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-11-10 | 2010-11-15 | 2010-12-01 | 2010-11-01 | 0 | 2010-11-02 | ? | 0 | 0004084140 | 20101102.ifs | 2010-11-02 | 2010-11-03 | |||||||
332957 | 332957 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-10-20 | 2010-10-22 | 2010-10-29 | 2010-10-08 | 0 | 2010-10-11 | ? | 0 | 0004074388 | 20101011.ifs | 2010-10-11 | 2010-10-12 | |||||||
305020 | 305020 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-09-20 | 2010-09-22 | 2010-09-30 | 2010-09-10 | 0 | 2010-09-10 | ? | 0 | 0004059395 | 20100910.ifs | 2010-09-10 | 2010-09-11 | |||||||
276789 | 276789 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-08-18 | 2010-08-20 | 2010-08-31 | 2010-08-10 | 0 | 2010-08-10 | ? | 0 | 0004046430 | 20100810.ifs | 2010-08-10 | 2010-08-11 | |||||||
245978 | 245978 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-07-20 | 2010-07-22 | 2010-07-30 | 2010-07-09 | 0 | 2010-07-09 | ? | 0 | 0004032993 | 20100709.ifs | 2010-07-09 | 2010-07-10 | |||||||
216932 | 216932 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-06-18 | 2010-06-22 | 2010-06-30 | 2010-06-10 | 0 | 2010-06-10 | ? | 0 | 0004017900 | 20100610.ifs | 2010-06-10 | 2010-06-11 | |||||||
189481 | 189481 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-05-18 | 2010-05-20 | 2010-05-28 | 2010-05-10 | 0 | 2010-05-10 | ? | 0 | 0004005154 | 20100510.ifs | 2010-05-10 | 2010-05-11 | |||||||
157169 | 157169 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-04-20 | 2010-04-22 | 2010-04-30 | 2010-04-09 | 0 | 2010-04-09 | ? | 0 | 0003992673 | 20100409.ifs | 2010-04-09 | 2010-04-10 | |||||||
130286 | 130286 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-03-18 | 2010-03-22 | 2010-03-31 | 2010-03-10 | 0 | 2010-03-10 | ? | 0 | 0003977100 | 20100310.ifs | 2010-03-10 | 2010-04-07 | |||||||
107875 | 107875 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-02-17 | 2010-02-19 | 2010-02-26 | 2010-02-09 | 0 | 2010-02-09 | ? | 0 | 0003964513 | 20100209.ifs | 2010-02-09 | 2010-04-07 | |||||||
67906 | 67906 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .085 | 00 | 2010-01-20 | 2010-01-22 | 2010-01-29 | 2009-12-28 | 0 | 2009-12-28 | ? | 0 | 0003939615 | 20091228.ifs | 2009-12-28 | 2010-04-07 | |||||||
44019 | 44019 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .16667 | 00 | 2009-12-16 | 2009-12-18 | 2009-12-31 | 2009-12-08 | 0 | 2009-12-08 | ? | 0 | 0003921606 | 20091208.ifs | 2009-12-08 | 2010-04-07 | |||||||
21356 | 21356 | DIVIDEND | ADD | 260537105 | 0 | 0 | 1 | 0 | .16667 | 00 | 2009-11-18 | 2009-11-20 | 2009-11-30 | 2009-11-10 | 0 | 2009-11-10 | ? | 0 | 0003907558 | 20091110.ifs | 2009-11-10 | 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 = 151549
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