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 AAIAF Charts Yahoo AAIAF Profile
  Run AAIAF Institutional Summary Yahoo AAIAF Key Statisics
  J3 Open AAIAF Pricing Yahoo AAIAF Pricing
  J3 AAIAF Insider   J3 AAIAF Insitutions Yahoo AAIAF Holders
     
  Open up Sector/Exchange Map Fidelity AAIAF Lookup
  Open up sec.gov For Market Ca MSN AAIAF 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
046346201 DELETE RUN
 

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 0   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:145348
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
1237261 1237261 CORPACTION ADD 046346201 66 A 2013-07-09 05534B109 01 ? 20130709.ifs 2013-07-09 2013-07-10
1237262 1237262 EQUITY CHANGE 046346201 CL A 0 0 1993-11-04 ? 2 yes no no 2001-07-03 2013-07-08 ? 20130709.ifs 2013-07-09 2013-07-10
1237263 1237262 EQUITY CHANGE 046346201 CL A A 0 1993-11-04 2013-07-09 2 yes no 05534B109 no 2001-07-03 2013-07-09 ? 20130709.ifs 2013-07-09 2013-07-10
1236713 1236713 EQUITY CHANGE 046346201 CL A 0 0 1993-11-04 ? 2 yes no no 2001-07-03 2004-11-03 ? 20130708.ifs 2013-07-08 2013-07-09
1236714 1236713 EQUITY CHANGE 046346201 CL A A 0 1993-11-04 2013-07-08 2 yes no 05534B109 no 2001-07-03 2013-07-08 ? 20130708.ifs 2013-07-08 2013-07-09
1236740 1236740 EQUITY CHANGE 046346201 CL A A 0 1993-11-04 2013-07-08 2 yes no 05534B109 no 2001-07-03 2013-07-08 ? 20130708.ifs 2013-07-08 2013-07-09
1236741 1236740 EQUITY CHANGE 046346201 CL A 0 0 1993-11-04 ? 2 yes no no 2001-07-03 2013-07-08 ? 20130708.ifs 2013-07-08 2013-07-09
1012174 1012174 DIVIDEND ADD 046346201 A 0 2 0 .5 15 2013-01-11 2013-01-15 2013-02-01 2012-11-19 0 2012-11-19 ? 0 0004459152 20121119.ifs 2012-11-19 2012-11-20
870139 870139 DIVIDEND CHANGE 046346201 0 0 E 0 0 58 ? ? 2012-07-29 2012-05-29 0 2012-05-29 ? 0 0004377236 20120531.ifs 2012-05-31 2012-06-01
870140 870139 DIVIDEND CHANGE 046346201 0 0 E 0 0 58 ? ? 2012-07-29 2012-05-29 0 2012-05-29 ? 0 0004377236 20120531.ifs 2012-05-31 2012-06-01
722273 722273 DIVIDEND ADD 046346201 A 0 2 0 .5 15 2012-02-08 2012-02-10 2012-02-24 2011-12-13 0 2011-12-14 ? 0 0004288135 20111214.ifs 2011-12-14 2011-12-15
510046 510046 DIVIDEND ADD 046346201 A 0 2 0 .375 15 2011-07-12 2011-07-14 2011-07-29 2011-04-27 0 2011-04-27 ? 0 0004178234 20110427.ifs 2011-04-27 2011-04-28
381626 381626 DIVIDEND DELETE 046346201 TSX Ex-date: 1-17-2011 A 0 2 0 .375 0 15 2011-01-17 2011-01-19 2011-02-02 2010-12-14 0 2010-12-14 2010-12-17 0 0004104005 20101217.ifs 2010-12-17 2010-12-18
381627 381627 DIVIDEND ADD 046346201 TSX Ex-date: 1-17-2011 A 0 2 0 .375 0 15 2011-01-14 2011-01-19 2011-02-02 2010-12-14 0 ? 2010-12-17 0 0004104005 20101217.ifs 2010-12-17 2010-12-18
381669 381669 DIVIDEND DELETE 046346201 TSX Ex-date: 1-17-2011 A 0 2 0 .375 0 15 2011-01-14 2011-01-19 2011-02-02 2010-12-14 0 ? 2010-12-17 0 0004104005 20101217.ifs 2010-12-17 2010-12-18
381670 381670 DIVIDEND ADD 046346201 TSX Ex-date: 1-17-2011 A 0 2 0 .375 0 15 2011-01-14 2011-01-19 2011-02-02 2010-12-09 0 ? 2010-12-17 0 0004104005 20101217.ifs 2010-12-17 2010-12-18
381671 381671 DIVIDEND DELETE 046346201 A 0 2 0 .25 15 2010-07-12 2010-07-14 2010-07-30 2010-05-10 0 2010-05-10 ? 0 0004004972 20101217.ifs 2010-12-17 2010-12-18
381672 381672 DIVIDEND ADD 046346201 A 0 2 0 .25 0 15 2010-07-12 2010-07-14 2010-07-30 2010-05-06 0 ? 2010-12-17 0 0004004972 20101217.ifs 2010-12-17 2010-12-18
381673 381673 DIVIDEND DELETE 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-15 0 0003924289 20101217.ifs 2010-12-17 2010-12-18
381674 381674 DIVIDEND ADD 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2010-12-09 0 ? 2010-12-17 0 0003924289 20101217.ifs 2010-12-17 2010-12-18
377192 377192 DIVIDEND ADD 046346201 A 0 2 0 .375 15 2011-01-17 2011-01-19 2011-02-02 2010-12-14 0 2010-12-14 ? 0 0004104005 20101214.ifs 2010-12-14 2010-12-15
189543 189543 DIVIDEND ADD 046346201 A 0 2 0 .25 15 2010-07-12 2010-07-14 2010-07-30 2010-05-10 0 2010-05-10 ? 0 0004004972 20100510.ifs 2010-05-10 2010-05-11
48731 48731 DIVIDEND DELETE 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-15 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-14 0 0003924289 20091215.ifs 2009-12-15 2010-04-07
48732 48732 DIVIDEND ADD 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-15 0 0003924289 20091215.ifs 2009-12-15 2010-04-07
48699 48699 DIVIDEND DELETE 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-11 0 0003924289 20091214.ifs 2009-12-14 2010-04-07
48700 48700 DIVIDEND ADD 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-15 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-14 0 0003924289 20091214.ifs 2009-12-14 2010-04-07
47696 47696 DIVIDEND DELETE 046346201 A 0 2 0 .25 15 2010-01-15 2010-01-19 2010-02-02 2009-12-10 0 2009-12-10 ? 0 0003924289 20091211.ifs 2009-12-11 2010-04-07
47697 47697 DIVIDEND ADD 046346201 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-11 0 0003924289 20091211.ifs 2009-12-11 2010-04-07
47698 47698 DIVIDEND CHANGE 046346201 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-11 0 0003924289 20091211.ifs 2009-12-11 2010-04-07
47699 47698 DIVIDEND CHANGE 046346201 TSX Ex-date 1-15-2010 A 0 2 0 .25 0 15 2010-01-14 2010-01-19 2010-02-02 2009-12-10 0 ? 2009-12-11 0 0003924289 20091211.ifs 2009-12-11 2010-04-07
47611 47611 DIVIDEND ADD 046346201 A 0 2 0 .25 15 2010-01-15 2010-01-19 2010-02-02 2009-12-10 0 2009-12-10 ? 0 0003924289 20091210.ifs 2009-12-10 2010-04-07


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