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 AALQL Charts Yahoo AALQL Profile
  Run AALQL Institutional Summary Yahoo AALQL Key Statisics
  J3 Open AALQL Pricing Yahoo AALQL Pricing
  J3 AALQL Insider   J3 AALQL Insitutions Yahoo AALQL Holders
     
  Open up Sector/Exchange Map Fidelity AALQL Lookup
  Open up sec.gov For Market Ca MSN AALQL 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   Update Insititution By Cusips
% Owned by Insititutions: N/A % %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:145350
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
1842759 1842759 CORPACTION ADD 01643R408 66 D 2015-04-20 ? 20150420.ifs 2015-04-20 2015-04-21
1842760 1842760 EQUITY CHANGE 01643R408 GDR UNIT 144A 0 4 2005-03-03 ? 0 no no no 2005-04-01 2008-05-23 ? 20150420.ifs 2015-04-20 2015-04-21
1842761 1842760 EQUITY CHANGE 01643R408 GDR UNIT 144A D 4 2005-03-03 2015-04-20 0 no no no 2005-04-01 2015-04-20 ? 20150420.ifs 2015-04-20 2015-04-21
1842848 1842848 EXCHANGE CHANGE 01643R408 66 2005-03-29 2006-07-07 AALQL 0 4 2005-04-01 2008-02-06 20150420.ifs 2015-04-20 2015-04-21
1842849 1842848 EXCHANGE CHANGE 01643R408 66 2005-03-29 2015-04-17 AALQL 0 4 2005-04-01 2015-04-20 20150420.ifs 2015-04-20 2015-04-21
1547260 1547260 DIVIDEND DELETE 01643R408 6 0 1 5 .001985 0 26 2014-04-11 2014-04-15 ? 2014-04-04 0 ? 2014-04-07 0 0004766500 20140611.ifs 2014-06-11 2014-06-12
1547261 1547261 DIVIDEND ADD 01643R408 6 0 1 0 .002023 0 05 2014-04-11 2014-04-15 2014-06-19 2014-04-04 0 ? 2014-06-11 0 0004766500 20140611.ifs 2014-06-11 2014-06-12
1492201 1492201 DIVIDEND DELETE 01643R408 6 0 1 5 .001985 26 ? 2014-04-15 ? 2014-04-04 0 2014-04-04 ? 0 0004766500 20140407.ifs 2014-04-07 2014-04-08
1492202 1492202 DIVIDEND ADD 01643R408 6 0 1 5 .001985 0 26 2014-04-11 2014-04-15 ? 2014-04-04 0 ? 2014-04-07 0 0004766500 20140407.ifs 2014-04-07 2014-04-08
1492788 1492788 DIVIDEND CHANGE 01643R408 6 0 1 5 .001985 0 26 2014-04-11 2014-04-15 ? 2014-04-04 0 ? 2014-04-07 0 0004766500 20140407.ifs 2014-04-07 2014-04-08
1492789 1492788 DIVIDEND CHANGE 01643R408 6 0 1 5 .001985 0 26 2014-04-11 2014-04-15 ? 2014-04-04 0 ? 2014-04-07 0 0004766500 20140407.ifs 2014-04-07 2014-04-08
1492099 1492099 DIVIDEND ADD 01643R408 6 0 1 5 .001985 26 ? 2014-04-15 ? 2014-04-04 0 2014-04-04 ? 0 0004766500 20140404.ifs 2014-04-04 2014-04-05
1211205 1211205 DIVIDEND DELETE 01643R408 6 0 1 5 .036253 26 2013-04-26 2013-04-29 ? 2013-04-18 0 2013-04-18 ? 0 0004558619 20130617.ifs 2013-06-17 2013-06-18
1211206 1211206 DIVIDEND ADD 01643R408 6 0 1 0 .034539 05 2013-04-26 2013-04-29 2013-06-24 2013-04-18 1 2013-04-18 2013-06-17 0 0004558619 20130617.ifs 2013-06-17 2013-06-18
1162696 1162696 DIVIDEND ADD 01643R408 6 0 1 5 .036253 26 2013-04-26 2013-04-29 ? 2013-04-18 0 2013-04-18 ? 0 0004558619 20130418.ifs 2013-04-18 2013-04-19
897426 897426 DIVIDEND DELETE 01643R408 6 0 1 5 .040644 26 2012-05-01 2012-05-03 ? 2012-04-20 1 2012-04-20 2012-04-23 0 0004362918 20120628.ifs 2012-06-28 2012-06-29
897427 897427 DIVIDEND ADD 01643R408 6 0 1 0 .036074 05 2012-05-01 2012-05-03 2012-07-06 2012-04-20 2 2012-04-20 2012-06-28 0 0004362918 20120628.ifs 2012-06-28 2012-06-29
841092 841092 DIVIDEND DELETE 01643R408 6 0 1 5 .040644 26 ? 2012-05-03 ? 2012-04-20 0 2012-04-20 ? 0 0004362918 20120423.ifs 2012-04-23 2012-04-24
841093 841093 DIVIDEND ADD 01643R408 6 0 1 5 .040644 26 2012-05-01 2012-05-03 ? 2012-04-20 1 2012-04-20 2012-04-23 0 0004362918 20120423.ifs 2012-04-23 2012-04-24
840129 840129 DIVIDEND ADD 01643R408 6 0 1 5 .040644 26 ? 2012-05-03 ? 2012-04-20 0 2012-04-20 ? 0 0004362918 20120420.ifs 2012-04-20 2012-04-21
577031 577031 DIVIDEND DELETE 01643R408 6 0 1 5 .046066 26 2011-05-06 2011-05-10 ? 2011-04-25 0 2011-04-25 ? 0 0004177342 20110630.ifs 2011-06-30 2011-07-01
577032 577032 DIVIDEND ADD 01643R408 6 0 1 0 .046428 05 2011-05-06 2011-05-10 2011-07-11 2011-04-25 1 2011-04-25 2011-06-30 0 0004177342 20110630.ifs 2011-06-30 2011-07-01
508510 508510 DIVIDEND ADD 01643R408 6 0 1 5 .046066 26 2011-05-06 2011-05-10 ? 2011-04-25 0 2011-04-25 ? 0 0004177342 20110425.ifs 2011-04-25 2011-04-26
236115 236115 DIVIDEND DELETE 01643R408 6 0 1 5 .00495 26 2010-05-03 2010-05-05 ? 2010-04-23 1 2010-04-23 2010-04-26 0 0003995533 20100630.ifs 2010-06-30 2010-07-01
236116 236116 DIVIDEND ADD 01643R408 6 0 1 0 .00478 05 2010-05-03 2010-05-05 2010-07-09 2010-04-23 2 2010-04-23 2010-06-30 0 0003995533 20100630.ifs 2010-06-30 2010-07-01
167308 167308 DIVIDEND DELETE 01643R408 6 0 1 5 .00495 26 ? 2010-05-05 ? 2010-04-23 0 2010-04-23 ? 0 0003995533 20100426.ifs 2010-04-26 2010-04-27
167309 167309 DIVIDEND ADD 01643R408 6 0 1 5 .00495 26 2010-05-03 2010-05-05 ? 2010-04-23 1 2010-04-23 2010-04-26 0 0003995533 20100426.ifs 2010-04-26 2010-04-27
165925 165925 DIVIDEND ADD 01643R408 6 0 1 5 .00495 26 ? 2010-05-05 ? 2010-04-23 0 2010-04-23 ? 0 0003995533 20100423.ifs 2010-04-23 2010-04-24


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