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:159833 |
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 | ||
2145831 | 2145831 | DIVIDEND | DELETE | 714270105 | 0 | 0 | 6 | 0 | .04 | 54 | 2016-03-30 | 2016-03-30 | 2016-03-30 | 2016-03-28 | 0 | 2016-03-28 | ? | 0 | 0005192534 | 20160330.ifs | 2016-03-30 | 2016-03-31 | |||||||
2145832 | 2145832 | DIVIDEND | ADD | 714270105 | 0 | 0 | 6 | 0 | .04 | 0 | 54 | 2016-03-30 | 2016-03-30 | 2016-03-30 | 2016-03-30 | 0 | ? | 2016-03-30 | 0 | 0005192534 | 20160330.ifs | 2016-03-30 | 2016-03-31 | ||||||
2145837 | 2145837 | CORPACTION | ADD | 714270105 | 66 | Q | 2016-03-30 | 714270121 | 66 | 2016-03-30 | 20160330.ifs | 2016-03-30 | 2016-03-31 | ||||||||||||||||
2145838 | 2145838 | EQUITY | CHANGE | 714270105 | COM | 0 | 0 | 2010-07-06 | ? | 0 | no | no | no | 2010-07-06 | 2010-07-06 | ? | 20160330.ifs | 2016-03-30 | 2016-03-31 | ||||||||||
2145839 | 2145838 | EQUITY | CHANGE | 714270105 | COM | Q | 0 | 2010-07-06 | 2016-03-30 | 0 | no | no | 714270121 | no | 2010-07-06 | 2016-03-30 | ? | 20160330.ifs | 2016-03-30 | 2016-03-31 | |||||||||
2145840 | 2145840 | SPLIT | DELETE | 714270105 | 25 | 2016-03-30 | 54 | 2016-03-28 | ? | 20160330.ifs | 2016-03-30 | 2016-03-31 | |||||||||||||||||
2145842 | 2145842 | DIVIDEND | DELETE | 714270105 | 0 | 0 | 6 | 0 | .04 | 0 | 54 | 2016-03-30 | 2016-03-30 | 2016-03-30 | 2016-03-30 | 0 | ? | 2016-03-30 | 0 | 0005192534 | 20160330.ifs | 2016-03-30 | 2016-03-31 | ||||||
2143613 | 2143613 | DIVIDEND | ADD | 714270105 | 0 | 0 | 6 | 0 | .04 | 54 | 2016-03-30 | 2016-03-30 | 2016-03-30 | 2016-03-28 | 0 | 2016-03-28 | ? | 0 | 0005192534 | 20160328.ifs | 2016-03-28 | 2016-03-29 | |||||||
2143614 | 2143614 | SPLIT | ADD | 714270105 | 25 | 2016-03-30 | 54 | 2016-03-28 | ? | 20160328.ifs | 2016-03-28 | 2016-03-29 | |||||||||||||||||
675929 | 675929 | DIVIDEND | ADD | 714270105 | 0 | 0 | E | 0 | 0 | 58 | ? | ? | 2011-11-17 | 2011-10-20 | 0 | 2011-10-20 | ? | 0 | 0004258443 | 20111020.ifs | 2011-10-20 | 2011-10-21 | |||||||
646889 | 646889 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .015 | 15 | 2011-09-28 | 2011-09-30 | 2011-10-17 | 2011-09-19 | 0 | 2011-09-19 | ? | 0 | 0004243904 | 20110919.ifs | 2011-09-19 | 2011-09-20 | |||||||
612401 | 612401 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .015 | 15 | 2011-08-29 | 2011-08-31 | 2011-09-15 | 2011-08-09 | 0 | 2011-08-10 | ? | 0 | 0004228733 | 20110810.ifs | 2011-08-10 | 2011-08-11 | |||||||
587452 | 587452 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .015 | 15 | 2011-07-27 | 2011-07-29 | 2011-08-15 | 2011-07-14 | 0 | 2011-07-14 | ? | 0 | 0004216503 | 20110714.ifs | 2011-07-14 | 2011-07-15 | |||||||
563011 | 563011 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .015 | 15 | 2011-06-28 | 2011-06-30 | 2011-07-15 | 2011-06-16 | 0 | 2011-06-17 | ? | 0 | 0004202053 | 20110617.ifs | 2011-06-17 | 2011-06-18 | |||||||
529180 | 529180 | DIVIDEND | DELETE | 714270105 | A | 0 | 2 | 0 | .015 | 15 | 2011-05-27 | 2011-05-31 | 2011-06-15 | 2011-05-17 | 0 | 2011-05-18 | ? | 0 | 0004188638 | 20110519.ifs | 2011-05-19 | 2011-05-20 | |||||||
529181 | 529181 | DIVIDEND | ADD | 714270105 | TSX ex-date: 5-27-2011 | A | 0 | 2 | 0 | .015 | 0 | 15 | 2011-05-26 | 2011-05-31 | 2011-06-15 | 2011-05-17 | 0 | ? | 2011-05-19 | 0 | 0004188638 | 20110519.ifs | 2011-05-19 | 2011-05-20 | |||||
528581 | 528581 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .015 | 15 | 2011-05-27 | 2011-05-31 | 2011-06-15 | 2011-05-17 | 0 | 2011-05-18 | ? | 0 | 0004188638 | 20110518.ifs | 2011-05-18 | 2011-05-19 | |||||||
500931 | 500931 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .03 | 15 | 2011-04-20 | 2011-04-25 | 2011-05-16 | 2011-04-11 | 0 | 2011-04-12 | ? | 0 | 0004174837 | 20110412.ifs | 2011-04-12 | 2011-04-13 | |||||||
467659 | 467659 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .03 | 15 | 2011-03-18 | 2011-03-22 | 2011-04-15 | 2011-03-07 | 0 | 2011-03-08 | ? | 0 | 0004158078 | 20110308.ifs | 2011-03-08 | 2011-03-09 | |||||||
440129 | 440129 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .03 | 15 | 2011-02-18 | 2011-02-23 | 2011-03-15 | 2011-02-08 | 0 | 2011-02-09 | ? | 0 | 0004145757 | 20110209.ifs | 2011-02-09 | 2011-02-10 | |||||||
417699 | 417699 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .03 | 15 | 2011-01-20 | 2011-01-24 | 2011-02-15 | 2011-01-11 | 0 | 2011-01-12 | ? | 0 | 0004134344 | 20110112.ifs | 2011-01-12 | 2011-01-13 | |||||||
376710 | 376710 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .03 | 15 | 2010-12-29 | 2010-12-31 | 2011-01-17 | 2010-12-14 | 0 | 2010-12-14 | ? | 0 | 0004104009 | 20101214.ifs | 2010-12-14 | 2010-12-15 | |||||||
352478 | 352478 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .03 | 15 | 2010-11-18 | 2010-11-22 | 2010-12-15 | 2010-11-08 | 0 | 2010-11-09 | ? | 0 | 0004086098 | 20101109.ifs | 2010-11-09 | 2010-11-10 | |||||||
334375 | 334375 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .05 | 15 | 2010-10-20 | 2010-10-22 | 2010-11-15 | 2010-10-12 | 0 | 2010-10-13 | ? | 0 | 0004074501 | 20101013.ifs | 2010-10-13 | 2010-10-14 | |||||||
304955 | 304955 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .05 | 15 | 2010-09-20 | 2010-09-22 | 2010-10-15 | 2010-09-10 | 0 | 2010-09-10 | ? | 0 | 0004059317 | 20100910.ifs | 2010-09-10 | 2010-09-11 | |||||||
276713 | 276713 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .05 | 15 | 2010-08-19 | 2010-08-23 | 2010-09-15 | 2010-08-10 | 0 | 2010-08-10 | ? | 0 | 0004046443 | 20100810.ifs | 2010-08-10 | 2010-08-11 | |||||||
247962 | 247962 | DIVIDEND | CHANGE | 714270105 | A | 0 | 2 | 0 | .05 | 15 | 2010-07-20 | 2010-07-22 | 2010-08-16 | 2010-07-12 | 0 | 2010-07-12 | ? | 0 | 0004033282 | 20100713.ifs | 2010-07-13 | 2010-07-14 | |||||||
247963 | 247962 | DIVIDEND | CHANGE | 714270105 | A | 0 | 2 | 4 | .05 | 0 | 15 | 2010-07-20 | 2010-07-22 | 2010-08-16 | 2010-07-12 | 0 | 2010-07-12 | 2010-07-13 | 0 | 0004033282 | 20100713.ifs | 2010-07-13 | 2010-07-14 | ||||||
247657 | 247657 | DIVIDEND | ADD | 714270105 | A | 0 | 2 | 0 | .05 | 15 | 2010-07-20 | 2010-07-22 | 2010-08-16 | 2010-07-12 | 0 | 2010-07-12 | ? | 0 | 0004033282 | 20100712.ifs | 2010-07-12 | 2010-07-13 | |||||||
242744 | 242744 | EQUITY | ADD | 714270105 | COM | N | 0 | 2010-07-06 | ? | 0 | no | no | no | 2010-07-06 | ? | ? | 20100706.ifs | 2010-07-06 | 2010-07-07 | ||||||||||
242748 | 242748 | EXCHANGE | ADD | 714270105 | 66 | 2010-07-06 | 2010-07-06 | PMGYF | 0 | 0 | 2010-07-06 | ? | 20100706.ifs | 2010-07-06 | 2010-07-07 | ||||||||||||||
242898 | 242898 | EQUITY | CHANGE | 714270105 | COM | N | 0 | 2010-07-06 | ? | 0 | no | no | no | 2010-07-06 | ? | ? | 20100706.ifs | 2010-07-06 | 2010-07-07 | ||||||||||
242899 | 242898 | EQUITY | CHANGE | 714270105 | COM | 0 | 0 | 2010-07-06 | ? | 0 | no | no | no | 2010-07-06 | 2010-07-06 | ? | 20100706.ifs | 2010-07-06 | 2010-07-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 = 159833
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