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:130809 |
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 | ||
3828304 | 3828304 | DIVIDEND | DELETE | 053304200 | 0 | 0 | 6 | 0 | .0002 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-03 | 0 | 2019-07-03 | ? | 0 | 0005914625 | 20190705.ifs | 2019-07-05 | 2019-07-06 | |||||||
3828306 | 3828306 | DIVIDEND | ADD | 053304200 | 0 | 0 | 6 | 0 | .0002 | 0 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 0 | ? | 2019-07-05 | 0 | 0005914625 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||
3828308 | 3828308 | EXCHANGE | CHANGE | 053304200 | 66 | 2013-01-04 | 2019-06-25 | ARNH | 0 | 0 | 2013-01-04 | 2013-01-31 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||||||
3828309 | 3828309 | DIVIDEND | DELETE | 053304200 | 0 | 0 | 6 | 0 | .0002 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-03 | 0 | 2019-07-03 | ? | 0 | 0005914625 | 20190705.ifs | 2019-07-05 | 2019-07-06 | |||||||
3828310 | 3828309 | EXCHANGE | CHANGE | 053304200 | 66 | 2013-01-04 | 2019-07-03 | ARNH | 0 | 0 | 2013-01-04 | 2019-07-05 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||||||
3828311 | 3828311 | DIVIDEND | ADD | 053304200 | 0 | 0 | 6 | 0 | .0002 | 0 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 0 | ? | 2019-07-05 | 0 | 0005914625 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||
3828313 | 3828313 | EXCHANGE | CHANGE | 053304200 | 66 | 2013-01-04 | 2019-06-25 | ARNH | 0 | 0 | 2013-01-04 | 2013-01-31 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||||||
3828314 | 3828313 | EXCHANGE | CHANGE | 053304200 | 66 | 2013-01-04 | 2019-07-03 | ARNH | 0 | 0 | 2013-01-04 | 2019-07-05 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||||||
3828323 | 3828323 | CORPACTION | ADD | 053304200 | 66 | Q | 2019-07-05 | 988808101 | 66 | 2019-07-05 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||||||||
3828325 | 3828325 | EQUITY | CHANGE | 053304200 | COM NEW | N | 0 | 2013-01-04 | ? | 0 | no | no | no | 2013-01-04 | 2013-01-04 | ? | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||
3828326 | 3828326 | CORPACTION | ADD | 053304200 | 66 | Q | 2019-07-05 | 988808101 | 66 | 2019-07-05 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||||||||
3828327 | 3828326 | EQUITY | CHANGE | 053304200 | COM NEW | Q | 0 | 2013-01-04 | 2019-07-05 | 0 | no | no | 988808101 | no | 2013-01-04 | 2019-07-05 | ? | 20190705.ifs | 2019-07-05 | 2019-07-06 | |||||||||
3828328 | 3828328 | EQUITY | CHANGE | 053304200 | COM NEW | N | 0 | 2013-01-04 | ? | 0 | no | no | no | 2013-01-04 | 2013-01-04 | ? | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||||||
3828329 | 3828329 | SPLIT | DELETE | 053304200 | 5000 | 2019-07-05 | 54 | 2019-07-03 | ? | 20190705.ifs | 2019-07-05 | 2019-07-06 | |||||||||||||||||
3828330 | 3828329 | EQUITY | CHANGE | 053304200 | COM NEW | Q | 0 | 2013-01-04 | 2019-07-05 | 0 | no | no | 988808101 | no | 2013-01-04 | 2019-07-05 | ? | 20190705.ifs | 2019-07-05 | 2019-07-06 | |||||||||
3828332 | 3828332 | SPLIT | DELETE | 053304200 | 5000 | 2019-07-05 | 54 | 2019-07-03 | ? | 20190705.ifs | 2019-07-05 | 2019-07-06 | |||||||||||||||||
3828333 | 3828333 | DIVIDEND | DELETE | 053304200 | 0 | 0 | 6 | 0 | .0002 | 0 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 0 | ? | 2019-07-05 | 0 | 0005914625 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||
3828336 | 3828336 | DIVIDEND | DELETE | 053304200 | 0 | 0 | 6 | 0 | .0002 | 0 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 0 | ? | 2019-07-05 | 0 | 0005914625 | 20190705.ifs | 2019-07-05 | 2019-07-06 | ||||||
3828087 | 3828087 | DIVIDEND | ADD | 053304200 | 0 | 0 | 6 | 0 | .0002 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-03 | 0 | 2019-07-03 | ? | 0 | 0005914625 | 20190703.ifs | 2019-07-03 | 2019-07-04 | |||||||
3828089 | 3828089 | SPLIT | ADD | 053304200 | 5000 | 2019-07-05 | 54 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | |||||||||||||||||
3828098 | 3828098 | DIVIDEND | ADD | 053304200 | 0 | 0 | 6 | 0 | .0002 | 54 | 2019-07-05 | 2019-07-05 | 2019-07-05 | 2019-07-03 | 0 | 2019-07-03 | ? | 0 | 0005914625 | 20190703.ifs | 2019-07-03 | 2019-07-04 | |||||||
3828100 | 3828100 | SPLIT | ADD | 053304200 | 5000 | 2019-07-05 | 54 | 2019-07-03 | ? | 20190703.ifs | 2019-07-03 | 2019-07-04 | |||||||||||||||||
1099517 | 1099517 | CORPACTION | ADD | 053304200 | 66 | # | 2013-01-31 | 053304200 | 66 | ? | 20130131.ifs | 2013-01-31 | 2013-02-01 | ||||||||||||||||
1099518 | 1099518 | CORPACTIONAUX | ADD | 053304200 | 66 | 2013-01-31 | ARNHD | AUTOMOTIVE RESOURCE NETWORK HL | COM NEW | ARNH | AUTOMOTIVE RESOURCE NETWORK HL | COM NEW | 2013-01-31 | ? | 20130131.ifs | 2013-01-31 | 2013-02-01 | ||||||||||||
1099519 | 1099519 | EXCHANGE | CHANGE | 053304200 | 66 | 2013-01-04 | ? | ARNHD | 0 | 0 | 2013-01-04 | ? | 20130131.ifs | 2013-01-31 | 2013-02-01 | ||||||||||||||
1099520 | 1099519 | EXCHANGE | CHANGE | 053304200 | 66 | 2013-01-04 | ? | ARNH | 0 | 0 | 2013-01-04 | 2013-01-31 | 20130131.ifs | 2013-01-31 | 2013-02-01 | ||||||||||||||
1083438 | 1083438 | EQUITY | ADD | 053304200 | N | 0 | 2013-01-04 | ? | 0 | no | no | no | 2013-01-04 | ? | ? | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||||||
1083441 | 1083441 | EXCHANGE | ADD | 053304200 | 66 | 2013-01-04 | ? | ARNHD | 0 | 0 | 2013-01-04 | ? | 20130104.ifs | 2013-01-04 | 2013-01-05 | ||||||||||||||
1083443 | 1083443 | SPLIT | ADD | 053304200 | 2500 | 2013-01-04 | 54 | 2012-01-03 | 2013-01-04 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||||||||||||
1083445 | 1083445 | DIVIDEND | ADD | 053304200 | 0 | 0 | 6 | 0 | .0004 | 54 | 2013-01-04 | 2013-01-04 | 2013-01-04 | 2013-01-03 | 0 | 2013-01-03 | 2013-01-04 | 0 | 0004510683 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1083559 | 1083559 | DIVIDEND | DELETE | 053304200 | 0 | 0 | 6 | 0 | .0004 | 54 | 2013-01-04 | 2013-01-04 | 2013-01-04 | 2013-01-03 | 0 | 2013-01-03 | 2013-01-04 | 0 | 0004510683 | 20130104.ifs | 2013-01-04 | 2013-01-05 | |||||||
1083560 | 1083560 | DIVIDEND | ADD | 053304200 | 0 | 0 | 6 | 0 | .0004 | 0 | 54 | 2013-01-04 | 2013-01-04 | 2013-01-04 | 2013-01-04 | 0 | ? | 2013-01-04 | 0 | 0004510683 | 20130104.ifs | 2013-01-04 | 2013-01-05 |
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 = 130809
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