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:145521 |
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 | ||
3521153 | 3521153 | CORPACTION | ADD | 051918506 | 66 | Q | 2018-12-31 | 051918803 | 66 | 2018-12-31 | 20181231.ifs | 2018-12-31 | 2019-01-01 | ||||||||||||||||
3521155 | 3521155 | EQUITY | CHANGE | 051918506 | COM NO PAR | 0 | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | 2013-05-02 | ? | 20181231.ifs | 2018-12-31 | 2019-01-01 | ||||||||||
3521156 | 3521155 | EQUITY | CHANGE | 051918506 | COM NO PAR | Q | 0 | 2013-04-30 | 2018-12-31 | 0 | no | no | 051918803 | no | ? | 2018-12-31 | ? | 20181231.ifs | 2018-12-31 | 2019-01-01 | |||||||||
3521158 | 3521158 | SPLIT | DELETE | 051918506 | 5 | 2018-12-31 | 54 | 2018-12-27 | ? | 20181231.ifs | 2018-12-31 | 2019-01-01 | |||||||||||||||||
3521162 | 3521162 | DIVIDEND | DELETE | 051918506 | 0 | 0 | 6 | 0 | .2 | 0 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 0 | ? | 2018-12-28 | 0 | 0005809194 | 20181231.ifs | 2018-12-31 | 2019-01-01 | ||||||
3521167 | 3521167 | CORPACTION | ADD | 051918506 | 66 | Q | 2018-12-31 | 051918803 | 66 | 2018-12-31 | 20181231.ifs | 2018-12-31 | 2019-01-01 | ||||||||||||||||
3521169 | 3521169 | EQUITY | CHANGE | 051918506 | COM NO PAR | 0 | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | 2013-05-02 | ? | 20181231.ifs | 2018-12-31 | 2019-01-01 | ||||||||||
3521171 | 3521170 | EQUITY | CHANGE | 051918506 | COM NO PAR | Q | 0 | 2013-04-30 | 2018-12-31 | 0 | no | no | 051918803 | no | ? | 2018-12-31 | ? | 20181231.ifs | 2018-12-31 | 2019-01-01 | |||||||||
3521173 | 3521173 | SPLIT | DELETE | 051918506 | 5 | 2018-12-31 | 54 | 2018-12-27 | ? | 20181231.ifs | 2018-12-31 | 2019-01-01 | |||||||||||||||||
3521177 | 3521177 | DIVIDEND | DELETE | 051918506 | 0 | 0 | 6 | 0 | .2 | 0 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 0 | ? | 2018-12-28 | 0 | 0005809194 | 20181231.ifs | 2018-12-31 | 2019-01-01 | ||||||
3511039 | 3511039 | DIVIDEND | DELETE | 051918506 | 0 | 0 | 6 | 0 | .2 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005809194 | 20181228.ifs | 2018-12-28 | 2018-12-29 | |||||||
3511040 | 3511040 | DIVIDEND | ADD | 051918506 | 0 | 0 | 6 | 0 | .2 | 0 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 0 | ? | 2018-12-28 | 0 | 0005809194 | 20181228.ifs | 2018-12-28 | 2018-12-29 | ||||||
3511241 | 3511241 | DIVIDEND | DELETE | 051918506 | 0 | 0 | 6 | 0 | .2 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005809194 | 20181228.ifs | 2018-12-28 | 2018-12-29 | |||||||
3511243 | 3511243 | DIVIDEND | ADD | 051918506 | 0 | 0 | 6 | 0 | .2 | 0 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 0 | ? | 2018-12-28 | 0 | 0005809194 | 20181228.ifs | 2018-12-28 | 2018-12-29 | ||||||
3507376 | 3507376 | DIVIDEND | ADD | 051918506 | 0 | 0 | 6 | 0 | .2 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005809194 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3507378 | 3507378 | SPLIT | ADD | 051918506 | 5 | 2018-12-31 | 54 | 2018-12-27 | ? | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||||||||||||
3509135 | 3509135 | DIVIDEND | ADD | 051918506 | 0 | 0 | 6 | 0 | .2 | 54 | 2018-12-31 | 2018-12-31 | 2018-12-31 | 2018-12-27 | 0 | 2018-12-27 | ? | 0 | 0005809194 | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||
3509137 | 3509137 | SPLIT | ADD | 051918506 | 5 | 2018-12-31 | 54 | 2018-12-27 | ? | 20181227.ifs | 2018-12-27 | 2018-12-28 | |||||||||||||||||
1193193 | 1193193 | CORPACTION | ADD | 051918506 | 66 | # | 2013-05-28 | 051918506 | 66 | ? | 20130528.ifs | 2013-05-28 | 2013-05-29 | ||||||||||||||||
1193194 | 1193194 | CORPACTIONAUX | ADD | 051918506 | 66 | 2013-05-28 | AUNFD | AURCANA CORP | COM NO PAR | AUNFF | AURCANA CORP | COM NO PAR | 2013-05-28 | ? | 20130528.ifs | 2013-05-28 | 2013-05-29 | ||||||||||||
1193195 | 1193195 | EXCHANGE | CHANGE | 051918506 | 66 | 2013-04-30 | 2013-05-24 | AUNFD | 0 | 0 | ? | 2013-04-30 | 20130528.ifs | 2013-05-28 | 2013-05-29 | ||||||||||||||
1193196 | 1193195 | EXCHANGE | CHANGE | 051918506 | 66 | 2013-04-30 | 2013-05-24 | AUNFF | 0 | 0 | ? | 2013-05-28 | 20130528.ifs | 2013-05-28 | 2013-05-29 | ||||||||||||||
1178077 | 1178077 | EQUITY | CHANGE | 051918506 | COM NO PAR | N | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | 2013-04-30 | ? | 20130502.ifs | 2013-05-02 | 2013-05-03 | ||||||||||
1178078 | 1178077 | EQUITY | CHANGE | 051918506 | COM NO PAR | 0 | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | 2013-05-02 | ? | 20130502.ifs | 2013-05-02 | 2013-05-03 | ||||||||||
1170027 | 1170027 | EQUITY | ADD | 051918506 | NEW ISSUE | 0 | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | ? | ? | 20130430.ifs | 2013-04-30 | 2013-05-01 | ||||||||||
1170028 | 1170028 | EQUITY | CHANGE | 051918506 | NEW ISSUE | 0 | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | ? | ? | 20130430.ifs | 2013-04-30 | 2013-05-01 | ||||||||||
1170029 | 1170028 | EQUITY | CHANGE | 051918506 | COM NO PAR | N | 0 | 2013-04-30 | ? | 0 | no | no | no | ? | 2013-04-30 | ? | 20130430.ifs | 2013-04-30 | 2013-05-01 | ||||||||||
1170030 | 1170030 | EXCHANGE | ADD | 051918506 | 66 | 2013-04-30 | 2013-04-30 | AUNWD | 0 | 0 | ? | 2013-04-30 | 20130430.ifs | 2013-04-30 | 2013-05-01 | ||||||||||||||
1170035 | 1170035 | EXCHANGE | CHANGE | 051918506 | 66 | 2013-04-30 | 2013-04-30 | AUNWD | 0 | 0 | ? | 2013-04-30 | 20130430.ifs | 2013-04-30 | 2013-05-01 | ||||||||||||||
1170036 | 1170035 | EXCHANGE | CHANGE | 051918506 | 66 | 2013-04-30 | 2013-04-30 | AUNFD | 0 | 0 | ? | 2013-04-30 | 20130430.ifs | 2013-04-30 | 2013-05-01 | ||||||||||||||
1170041 | 1170041 | SPLIT | ADD | 051918506 | 8 | 2013-04-30 | 54 | ? | 2013-04-30 | 20130430.ifs | 2013-04-30 | 2013-05-01 | |||||||||||||||||
1170043 | 1170043 | DIVIDEND | ADD | 051918506 | 0 | 0 | 6 | 0 | .125 | 0 | 54 | 2013-04-30 | 2013-04-30 | 2013-04-30 | 2013-04-30 | 0 | ? | 2013-04-30 | 0 | 0004527657 | 20130430.ifs | 2013-04-30 | 2013-05-01 |
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 = 145521
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