Update Company
Name Pricing Date  2024-03-31(LQAP)    
CompId   Stop Date volume LQStart
Ticker Price avevol LQEnd
Cusip Last Trade open LQAve
Sector Country high
   
MktCap CompNum low
yearlylow
Shares Out Type1 prevClose
yearlyhigh
Last_ShsOut    Exchange  
     
  09-30 12-25 sic Code      
Description cik  Updated
  Notes PAGE RESET
  Run COV Charts Yahoo COV Profile
  Run COV Institutional Summary Yahoo COV Key Statisics
  J3 Open COV Pricing Yahoo COV Pricing
  J3 COV Insider   J3 COV Insitutions Yahoo COV Holders
     
  Open up Sector/Exchange Map Fidelity COV Lookup
  Open up sec.gov For Market Ca MSN COV Lookup
     
  2001-01-01 shsout made up date to make % good  
  0009-09-09 sdate Dead Company  
  2010-12-25 shsout Took From Yahoo  
  9000010176 Next Fake CIK to use
   


INSITITUIONS Dynamic newInstitTable Changed the Cusip/Sector/Shs Out?
Old Cusips
 

Fix Cusip issue where all new and deleted Instittuional Holdings
Current Quarter Date: ie: 2012-06-30
Should We Update The database:
BackUp query is below under BACK UP Institutions before committing.

Total Insititutions : N/A 1   Update Insititution By Cusips
% Owned by Insititutions: N/A % 0 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:151572
New Old Cusip
 

Splits :
 reportDate : 
  ratio : 
  endQuaterAffected : 
  dayFrom  :
  dayTo  :
 

reportDate ratio endQuaterAffected dayFrom dayTo

To Upper  



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
1775030 1775030 CORPACTION ADD G2554F113 01 M 2015-01-27 585055106 01 2015-01-27 20150127.ifs 2015-01-27 2015-01-28
1775031 1775031 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no no 2011-03-17 2015-01-26 ? 20150127.ifs 2015-01-27 2015-01-28
1775032 1775031 EQUITY CHANGE G2554F113 ORD M 0 2011-03-16 2015-01-27 0 no no 585055106 no 2011-03-17 2015-01-27 ? 20150127.ifs 2015-01-27 2015-01-28
1775042 1775041 EQUITY CHANGE G2554F113 01 M 2015-01-27 585055106 01 2015-01-27 20150127.ifs 2015-01-27 2015-01-28
1775043 1775042 EQUITY CHANGE G2554F113 01 M 2015-01-27 G5960L103 01 2015-01-27 20150127.ifs 2015-01-27 2015-01-28
1775044 1775044 EQUITY CHANGE G2554F113 ORD M 0 2011-03-16 2015-01-27 0 no no 585055106 no 2011-03-17 2015-01-27 ? 20150127.ifs 2015-01-27 2015-01-28
1775045 1775044 EQUITY CHANGE G2554F113 ORD M 0 2011-03-16 2015-01-27 0 no no G5960L103 no 2011-03-17 2015-01-27 ? 20150127.ifs 2015-01-27 2015-01-28
1774471 1774471 CORPACTION ADD G2554F113 01 M 2015-01-26 G5960L103 01 ? 20150126.ifs 2015-01-26 2015-01-27
1774474 1774474 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no no 2011-03-17 2011-03-21 ? 20150126.ifs 2015-01-26 2015-01-27
1774475 1774474 EQUITY CHANGE G2554F113 ORD M 0 2011-03-16 2015-01-26 0 no no G5960L103 no 2011-03-17 2015-01-26 ? 20150126.ifs 2015-01-26 2015-01-27
1774595 1774595 CORPACTION DELETE G2554F113 01 M 2015-01-26 G5960L103 01 ? 20150126.ifs 2015-01-26 2015-01-27
1774596 1774596 EQUITY CHANGE G2554F113 ORD M 0 2011-03-16 2015-01-26 0 no no G5960L103 no 2011-03-17 2015-01-26 ? 20150126.ifs 2015-01-26 2015-01-27
1774597 1774596 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no G5960L103 no 2011-03-17 2015-01-26 ? 20150126.ifs 2015-01-26 2015-01-27
1774598 1774598 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no G5960L103 no 2011-03-17 2015-01-26 ? 20150126.ifs 2015-01-26 2015-01-27
1774599 1774598 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no no 2011-03-17 2015-01-26 ? 20150126.ifs 2015-01-26 2015-01-27
1774647 1774647 DIVIDEND CHANGE G2554F113 0 0 1 0 .36 00 2014-12-30 2015-01-02 2015-01-16 2014-12-19 1 2014-12-19 2015-01-21 0 0004911647 20150126.ifs 2015-01-26 2015-01-27
1774648 1774647 DIVIDEND CHANGE G2554F113 0 0 1 0 .36 00 2014-12-30 2015-01-02 2015-01-16 2014-12-19 2 2014-12-19 2015-01-26 0 0004911647 20150126.ifs 2015-01-26 2015-01-27
1772276 1772276 DIVIDEND CHANGE G2554F113 0 0 1 0 .36 00 2014-12-30 2015-01-02 2015-01-16 2014-12-19 0 2014-12-19 ? 0 0004911647 20150121.ifs 2015-01-21 2015-01-22
1772277 1772276 DIVIDEND CHANGE G2554F113 0 0 1 0 .36 00 2014-12-30 2015-01-02 2015-01-16 2014-12-19 1 2014-12-19 2015-01-21 0 0004911647 20150121.ifs 2015-01-21 2015-01-22
1730232 1730232 DIVIDEND ADD G2554F113 0 0 1 0 .36 00 2014-12-30 2015-01-02 2015-01-16 2014-12-19 0 2014-12-19 ? 0 0004911647 20141219.ifs 2014-12-19 2014-12-20
1693036 1693036 DIVIDEND CHANGE G2554F113 0 0 1 0 .36 00 2014-10-03 2014-10-07 2014-11-06 2014-09-17 0 2014-09-17 ? 0 0004843767 20141201.ifs 2014-12-01 2014-12-02
1693037 1693036 DIVIDEND CHANGE G2554F113 0 0 1 0 .36 00 2014-10-03 2014-10-07 2014-11-06 2014-09-17 1 2014-09-17 2014-12-01 0 0004843767 20141201.ifs 2014-12-01 2014-12-02
1631769 1631769 DIVIDEND ADD G2554F113 0 0 1 0 .36 00 2014-10-03 2014-10-07 2014-11-06 2014-09-17 0 2014-09-17 ? 0 0004843767 20140917.ifs 2014-09-17 2014-09-18
1580836 1580836 DIVIDEND ADD G2554F113 0 0 1 0 .32 00 2014-07-25 2014-07-29 2014-08-19 2014-07-16 0 2014-07-16 ? 0 0004815483 20140716.ifs 2014-07-16 2014-07-17
1470477 1470477 DIVIDEND ADD G2554F113 0 0 1 0 .32 00 2014-04-03 2014-04-07 2014-05-05 2014-03-19 0 2014-03-19 ? 0 0004752102 20140319.ifs 2014-03-19 2014-03-20
1423374 1423374 DIVIDEND ADD G2554F113 0 0 1 0 .32 00 2014-01-24 2014-01-28 2014-02-20 2014-01-16 0 2014-01-16 ? 0 0004724629 20140116.ifs 2014-01-16 2014-01-17
1290738 1290738 DIVIDEND ADD G2554F113 0 0 1 0 .32 00 2013-10-08 2013-10-10 2013-11-05 2013-09-19 0 2013-09-19 ? 0 0004630350 20130919.ifs 2013-09-19 2013-09-20
1241731 1241731 DIVIDEND ADD G2554F113 0 0 1 0 .26 00 2013-07-26 2013-07-30 2013-08-15 2013-07-17 0 2013-07-17 ? 0 0004602233 20130717.ifs 2013-07-17 2013-07-18
1232186 1232186 SPLIT CHANGE G2554F113 1 2013-07-01 20 ? 2013-07-01 20130702.ifs 2013-07-02 2013-07-03
1232187 1232186 SPLIT CHANGE G2554F113 .91359007 2013-07-01 20 ? 2013-07-02 20130702.ifs 2013-07-02 2013-07-03
1227912 1227912 SPLIT ADD G2554F113 1 2013-07-01 20 ? 2013-07-01 20130701.ifs 2013-07-01 2013-07-02
1210408 1210408 DIVIDEND CHANGE G2554F113 0 0 7 0 .125 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-06-14 0 0004573495 20130617.ifs 2013-06-17 2013-06-18
1210409 1210408 DIVIDEND CHANGE G2554F113 1 sh. of Mallinckrodt plc. Ord (New) for every 8 shs. held. 0 0 7 0 .125 0 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-06-17 0 0004573495 20130617.ifs 2013-06-17 2013-06-18
1209789 1209789 DIVIDEND CHANGE G2554F113 1 sh. of Mallinckrodt plc. Ord (New) for every 8 shs. held. 0 0 7 0 .125 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-05-31 0 0004573495 20130614.ifs 2013-06-14 2013-06-15
1209790 1209789 DIVIDEND CHANGE G2554F113 0 0 7 0 .125 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-06-14 0 0004573495 20130614.ifs 2013-06-14 2013-06-15
1195734 1195734 DIVIDEND ADD G2554F113 0 0 7 0 .125 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-05-31 0 0004573495 20130531.ifs 2013-05-31 2013-06-01
1195735 1195735 DIVIDEND CHANGE G2554F113 0 0 7 0 .125 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-05-31 0 0004573495 20130531.ifs 2013-05-31 2013-06-01
1195736 1195735 DIVIDEND CHANGE G2554F113 1 sh. of Mallinckrodt plc. Ord (New) for every 8 shs. held. 0 0 7 0 .125 20 2013-07-01 2013-06-19 2013-06-28 2013-05-24 0 ? 2013-05-31 0 0004573495 20130531.ifs 2013-05-31 2013-06-01
1138290 1138290 DIVIDEND ADD G2554F113 0 0 1 0 .26 00 2013-04-02 2013-04-04 2013-05-03 2013-03-21 0 2013-03-21 ? 0 0004543772 20130321.ifs 2013-03-21 2013-03-22
1026684 1026684 DIVIDEND ADD G2554F113 0 0 1 0 .26 00 2012-12-12 2012-12-14 2012-12-27 2012-12-04 0 2012-12-04 ? 0 0004469657 20121204.ifs 2012-12-04 2012-12-05
959971 959971 DIVIDEND ADD G2554F113 0 0 1 0 .26 00 2012-10-09 2012-10-11 2012-11-05 2012-09-20 0 2012-09-20 ? 0 0004431576 20120920.ifs 2012-09-20 2012-09-21
913927 913927 DIVIDEND ADD G2554F113 0 0 1 0 .225 00 2012-07-26 2012-07-30 2012-08-16 2012-07-18 0 2012-07-18 ? 0 0004403348 20120718.ifs 2012-07-18 2012-07-19
801987 801987 DIVIDEND ADD G2554F113 0 0 1 0 .225 00 2012-04-02 2012-04-04 2012-05-07 2012-03-14 0 2012-03-14 ? 0 0004345235 20120314.ifs 2012-03-14 2012-03-15
759172 759172 DIVIDEND ADD G2554F113 0 0 1 0 .225 00 2012-01-26 2012-01-30 2012-02-22 2012-01-19 0 2012-01-19 ? 0 0004321636 20120119.ifs 2012-01-19 2012-01-20
650542 650542 DIVIDEND ADD G2554F113 0 0 1 0 .225 00 2011-10-11 2011-10-13 2011-11-04 2011-09-22 0 2011-09-22 ? 0 0004245605 20110922.ifs 2011-09-22 2011-09-23
591233 591233 DIVIDEND ADD G2554F113 0 0 1 0 .2 35 2011-07-28 2011-08-01 2011-08-19 2011-07-20 0 2011-07-20 ? 0 0004218127 20110720.ifs 2011-07-20 2011-07-21
475358 475358 EXCHANGE ADD G2554F113 01 2011-03-21 2011-03-21 COV 0 0 ? 2011-03-21 20110321.ifs 2011-03-21 2011-03-22
475361 475361 EQUITY CHANGE G2554F113 ORD NEW N 0 2011-03-16 ? 0 no no no 2011-03-17 2011-03-18 ? 20110321.ifs 2011-03-21 2011-03-22
475362 475361 EQUITY CHANGE G2554F113 ORD N 0 2011-03-16 ? 0 no no no 2011-03-17 2011-03-21 ? 20110321.ifs 2011-03-21 2011-03-22
475367 475367 SPLIT ADD G2554F113 1 2011-03-21 54 ? 2011-03-21 20110321.ifs 2011-03-21 2011-03-22
475368 475368 DIVIDEND ADD G2554F113 0 0 6 0 .01 54 2011-03-21 2011-03-21 2011-03-21 2011-03-21 0 ? 2011-03-21 0 0004159771 20110321.ifs 2011-03-21 2011-03-22
475369 475369 DIVIDEND ADD G2554F113 0 0 6 0 99 11 2011-03-21 ? ? 2011-03-16 0 ? 2011-03-21 0 0004159772 20110321.ifs 2011-03-21 2011-03-22
475372 475372 DIVIDEND DELETE G2554F113 0 0 1 4 .2 00 2011-04-05 2011-04-07 2011-05-06 2011-03-15 0 2011-03-17 ? 0 0004160023 20110321.ifs 2011-03-21 2011-03-22
476450 476450 EQUITY CHANGE G2554F113 ORD N 0 2011-03-16 ? 0 no no no 2011-03-17 2011-03-21 ? 20110321.ifs 2011-03-21 2011-03-22
476451 476450 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no no 2011-03-17 2011-03-21 ? 20110321.ifs 2011-03-21 2011-03-22
474181 474181 EQUITY CHANGE G2554F113 ORD 0 0 2011-03-16 ? 0 no no no 2011-03-17 ? ? 20110318.ifs 2011-03-18 2011-03-19
474182 474181 EQUITY CHANGE G2554F113 ORD NEW N 0 2011-03-16 ? 0 no no no 2011-03-17 2011-03-18 ? 20110318.ifs 2011-03-18 2011-03-19
473220 473220 EQUITY ADD G2554F113 ORD 0 0 2011-03-16 ? 0 no no no 2011-03-17 ? ? 20110317.ifs 2011-03-17 2011-03-18
473386 473386 DIVIDEND ADD G2554F113 0 0 1 4 .2 00 2011-04-05 2011-04-07 2011-05-06 2011-03-15 0 2011-03-17 ? 0 0004160023 20110317.ifs 2011-03-17 2011-03-18


Old 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


Your Name Click here to open the child window


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 = 151572
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