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 AVNDF Charts Yahoo AVNDF Profile
  Run AVNDF Institutional Summary Yahoo AVNDF Key Statisics
  J3 Open AVNDF Pricing Yahoo AVNDF Pricing
  J3 AVNDF Insider   J3 AVNDF Insitutions Yahoo AVNDF Holders
     
  Open up Sector/Exchange Map Fidelity AVNDF Lookup
  Open up sec.gov For Market Ca MSN AVNDF 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
05356Q200 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:145536
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
1155311 1155311 CORPACTION ADD 05355T114 66 M 2013-04-04 69374D104 66 ? 20130404.ifs 2013-04-04 2013-04-05
1155312 1155312 EQUITY CHANGE 05355T114 COM 0 0 2011-01-07 ? 0 no no no 2011-01-07 2013-04-03 ? 20130404.ifs 2013-04-04 2013-04-05
1155313 1155312 EQUITY CHANGE 05355T114 COM M 0 2011-01-07 2013-04-04 0 no no 69374D104 no 2011-01-07 2013-04-04 ? 20130404.ifs 2013-04-04 2013-04-05
1153847 1153847 EQUITY CHANGE 05355T114 COM 0 0 2011-01-07 ? 0 no no no 2011-01-07 ? ? 20130403.ifs 2013-04-03 2013-04-04
1153848 1153847 EQUITY CHANGE 05355T114 COM M 0 2011-01-07 2013-04-03 0 no no 69374D104 no 2011-01-07 2013-04-03 ? 20130403.ifs 2013-04-03 2013-04-04
1153943 1153943 EQUITY CHANGE 05355T114 COM M 0 2011-01-07 2013-04-03 0 no no 69374D104 no 2011-01-07 2013-04-03 ? 20130403.ifs 2013-04-03 2013-04-04
1153944 1153943 EQUITY CHANGE 05355T114 COM 0 0 2011-01-07 ? 0 no no no 2011-01-07 2013-04-03 ? 20130403.ifs 2013-04-03 2013-04-04
1151595 1151595 DIVIDEND CHANGE 05355T114 A 0 2 0 .035 15 2013-03-25 2013-03-27 2013-04-15 2013-03-18 0 2013-03-19 ? 0 0004542624 20130401.ifs 2013-04-01 2013-04-02
1151596 1151595 DIVIDEND CHANGE 05355T114 A 0 2 0 .035 15 2013-03-25 2013-03-27 2013-04-15 2013-03-18 1 2013-03-19 2013-04-01 0 0004542624 20130401.ifs 2013-04-01 2013-04-02
1136677 1136677 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2013-03-25 2013-03-27 2013-04-15 2013-03-18 0 2013-03-19 ? 0 0004542624 20130319.ifs 2013-03-19 2013-03-20
1115103 1115103 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2013-02-26 2013-02-28 2013-03-15 2013-02-19 0 2013-02-20 ? 0 0004529209 20130220.ifs 2013-02-20 2013-02-21
1091969 1091969 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2013-01-29 2013-01-31 2013-02-15 2013-01-17 0 2013-01-17 ? 0 0004515848 20130117.ifs 2013-01-17 2013-01-18
1042868 1042868 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-12-27 2012-12-31 2013-01-15 2012-12-14 0 2012-12-14 ? 0 0004480412 20121214.ifs 2012-12-14 2012-12-15
1014300 1014300 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-11-28 2012-11-30 2012-12-17 2012-11-20 0 2012-11-21 ? 0 0004460161 20121121.ifs 2012-11-21 2012-11-22
988428 988428 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-10-29 2012-10-31 2012-11-15 2012-10-17 0 2012-10-18 ? 0 0004446030 20121018.ifs 2012-10-18 2012-10-19
957836 957836 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-09-26 2012-09-28 2012-10-15 2012-09-17 0 2012-09-17 ? 0 0004429845 20120917.ifs 2012-09-17 2012-09-18
934364 934364 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-08-29 2012-08-31 2012-09-17 2012-08-16 0 2012-08-16 ? 0 0004416701 20120816.ifs 2012-08-16 2012-08-17
913524 913524 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-07-27 2012-07-31 2012-08-15 2012-07-17 0 2012-07-17 ? 0 0004403112 20120717.ifs 2012-07-17 2012-07-18
888781 888781 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-06-27 2012-06-29 2012-07-16 2012-06-18 0 2012-06-19 ? 0 0004387690 20120619.ifs 2012-06-19 2012-06-20
863321 863321 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-05-29 2012-05-31 2012-06-15 2012-05-17 0 2012-05-17 ? 0 0004375086 20120517.ifs 2012-05-17 2012-05-18
829307 829307 DIVIDEND ADD 05355T114 A 0 2 0 .035 15 2012-04-26 2012-04-30 2012-05-15 2012-04-03 0 2012-04-03 ? 0 0004358183 20120403.ifs 2012-04-03 2012-04-04
803374 803374 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2012-03-28 2012-03-30 2012-04-16 2012-03-15 0 2012-03-15 ? 0 0004346113 20120315.ifs 2012-03-15 2012-03-16
780122 780122 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2012-02-27 2012-02-29 2012-03-15 2012-02-15 0 2012-02-15 ? 0 0004333169 20120215.ifs 2012-02-15 2012-02-16
757707 757707 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2012-01-27 2012-01-31 2012-02-15 2012-01-17 0 2012-01-17 ? 0 0004321107 20120117.ifs 2012-01-17 2012-01-18
725096 725096 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-12-28 2011-12-30 2012-01-16 2011-12-15 0 2011-12-15 ? 0 0004289783 20111215.ifs 2011-12-15 2011-12-16
696540 696540 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-11-28 2011-11-30 2011-12-15 2011-11-17 0 2011-11-17 ? 0 0004270691 20111117.ifs 2011-11-17 2011-11-18
674644 674644 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-10-27 2011-10-31 2011-11-15 2011-10-18 0 2011-10-18 ? 0 0004257987 20111018.ifs 2011-10-18 2011-10-19
644500 644500 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-09-28 2011-09-30 2011-10-17 2011-09-15 0 2011-09-15 ? 0 0004242989 20110915.ifs 2011-09-15 2011-09-16
621248 621248 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-08-29 2011-08-31 2011-09-15 2011-08-17 0 2011-08-17 ? 0 0004230069 20110817.ifs 2011-08-17 2011-08-18
589007 589007 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-07-27 2011-07-29 2011-08-15 2011-07-15 0 2011-07-15 ? 0 0004217114 20110715.ifs 2011-07-15 2011-07-16
564837 564837 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-06-28 2011-06-30 2011-07-15 2011-06-20 0 2011-06-20 ? 0 0004203127 20110620.ifs 2011-06-20 2011-06-21
526272 526272 DIVIDEND DELETE 05355T114 A 0 2 0 .045 15 2011-05-27 2011-05-31 2011-06-15 2011-05-13 0 2011-05-13 ? 0 0004188098 20110516.ifs 2011-05-16 2011-05-17
526273 526273 DIVIDEND ADD 05355T114 TSX ex-date: 5-27-2011 A 0 2 0 .045 0 15 2011-05-26 2011-05-31 2011-06-15 2011-05-13 0 ? 2011-05-16 0 0004188098 20110516.ifs 2011-05-16 2011-05-17
526210 526210 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-05-27 2011-05-31 2011-06-15 2011-05-13 0 2011-05-13 ? 0 0004188098 20110513.ifs 2011-05-13 2011-05-14
504891 504891 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-04-27 2011-04-29 2011-05-16 2011-04-19 0 2011-04-19 ? 0 0004176530 20110419.ifs 2011-04-19 2011-04-20
476430 476430 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-03-29 2011-03-31 2011-04-15 2011-03-21 0 2011-03-21 ? 0 0004161659 20110321.ifs 2011-03-21 2011-03-22
444943 444943 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-02-24 2011-02-28 2011-03-15 2011-02-16 0 2011-02-17 ? 0 0004147559 20110217.ifs 2011-02-17 2011-02-18
420795 420795 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-01-27 2011-01-31 2011-02-15 2011-01-19 0 2011-01-19 ? 0 0004135570 20110119.ifs 2011-01-19 2011-01-20
415308 415308 EQUITY ADD 05355T114 COM N 0 2011-01-07 ? 0 no no no 2011-01-07 ? ? 20110107.ifs 2011-01-07 2011-01-08
415312 415312 EXCHANGE ADD 05355T114 66 2011-01-07 2011-01-07 AVNDF 0 0 2011-01-07 ? 20110107.ifs 2011-01-07 2011-01-08
415818 415818 DIVIDEND ADD 05355T114 A 0 2 0 .045 15 2011-01-17 2011-01-19 2011-01-21 2011-01-07 0 2011-01-07 ? 0 0004133878 20110107.ifs 2011-01-07 2011-01-08
415825 415825 EQUITY CHANGE 05355T114 COM N 0 2011-01-07 ? 0 no no no 2011-01-07 ? ? 20110107.ifs 2011-01-07 2011-01-08
415826 415825 EQUITY CHANGE 05355T114 COM 0 0 2011-01-07 ? 0 no no no 2011-01-07 ? ? 20110107.ifs 2011-01-07 2011-01-08


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
415307 415307 CORPACTION ADD 05356Q200 66 Q 2011-01-07 05355T114 66 ? 20110107.ifs 2011-01-07 2011-01-08
415309 415309 EQUITY CHANGE 05356Q200 TR UNIT NEW 0 4 2004-06-14 ? 0 no no no 2005-02-22 2005-10-04 ? 20110107.ifs 2011-01-07 2011-01-08
415310 415309 EQUITY CHANGE 05356Q200 TR UNIT NEW Q 4 2004-06-14 2011-01-07 0 no no 05355T114 no 2005-02-22 2011-01-07 ? 20110107.ifs 2011-01-07 2011-01-08
356999 356999 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-11-26 2010-11-30 2010-12-15 2010-11-17 0 2010-11-17 ? 0 0004088238 20101117.ifs 2010-11-17 2010-11-18
336922 336922 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-10-27 2010-10-29 2010-11-15 2010-10-18 0 2010-10-18 ? 0 0004075259 20101018.ifs 2010-10-18 2010-10-19
308898 308898 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-09-28 2010-09-30 2010-10-15 2010-09-16 0 2010-09-16 ? 0 0004060319 20100916.ifs 2010-09-16 2010-09-17
280268 280268 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-08-27 2010-08-31 2010-09-15 2010-08-17 0 2010-08-17 ? 0 0004047761 20100817.ifs 2010-08-17 2010-08-18
255710 255710 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-07-28 2010-07-30 2010-08-16 2010-07-20 0 2010-07-20 ? 0 0004035004 20100720.ifs 2010-07-20 2010-07-21
224447 224447 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-06-28 2010-06-30 2010-07-15 2010-06-21 0 2010-06-21 ? 0 0004020631 20100621.ifs 2010-06-21 2010-06-22
194491 194491 DIVIDEND DELETE 05356Q200 A 0 2 0 .06 15 2010-05-27 2010-05-31 2010-06-15 2010-05-18 0 2010-05-18 ? 0 0004006702 20100519.ifs 2010-05-19 2010-05-20
194492 194492 DIVIDEND ADD 05356Q200 TSX ex-date: 5-27-2010 A 0 2 0 .06 0 15 2010-05-26 2010-05-31 2010-06-15 2010-05-18 0 ? 2010-05-19 0 0004006702 20100519.ifs 2010-05-19 2010-05-20
194313 194313 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-05-27 2010-05-31 2010-06-15 2010-05-18 0 2010-05-18 ? 0 0004006702 20100518.ifs 2010-05-18 2010-05-19
133468 133468 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-03-29 2010-03-31 2010-04-15 2010-03-16 0 2010-03-16 ? 0 0003978158 20100316.ifs 2010-03-16 2010-04-07
111907 111907 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-02-24 2010-02-26 2010-03-15 2010-02-17 0 2010-02-17 ? 0 0003965870 20100217.ifs 2010-02-17 2010-04-07
90125 90125 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2010-01-27 2010-01-31 2010-02-15 2010-01-18 0 2010-01-19 ? 0 0003954090 20100119.ifs 2010-01-19 2010-04-07
50429 50429 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2009-12-29 2009-12-31 2010-01-15 2009-12-15 0 2009-12-15 ? 0 0003926506 20091215.ifs 2009-12-15 2010-04-07
26832 26832 DIVIDEND DELETE 05356Q200 A 0 2 0 .06 15 2009-11-26 2009-11-30 2009-12-15 2009-11-19 0 2009-11-19 ? 0 0003909405 20091120.ifs 2009-11-20 2010-04-07
26833 26833 DIVIDEND ADD 05356Q200 TSX ex-date: 11-26-2009 A 0 2 0 .06 0 15 2009-11-25 2009-11-30 2009-12-15 2009-11-19 0 ? 2009-11-20 0 0003909405 20091120.ifs 2009-11-20 2010-04-07
26792 26792 DIVIDEND ADD 05356Q200 A 0 2 0 .06 15 2009-11-26 2009-11-30 2009-12-15 2009-11-19 0 2009-11-19 ? 0 0003909405 20091119.ifs 2009-11-19 2010-04-07


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