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 EJ Charts Yahoo EJ Profile
  Run EJ Institutional Summary Yahoo EJ Key Statisics
  J3 Open EJ Pricing Yahoo EJ Pricing
  J3 EJ Insider   J3 EJ Insitutions Yahoo EJ Holders
     
  Open up Sector/Exchange Map Fidelity EJ Lookup
  Open up sec.gov For Market Ca MSN EJ 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 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:151960
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
2270832 2270832 CORPACTION ADD 26852W103 01 A 2016-08-15 2016-08-15 20160815.ifs 2016-08-15 2016-08-16
2270833 2270833 EQUITY CHANGE 26852W103 ADR 0 0 2007-08-08 ? 0 no no no 2007-08-08 2016-08-12 ? 20160815.ifs 2016-08-15 2016-08-16
2270834 2270833 EQUITY CHANGE 26852W103 ADR A 0 2007-08-08 2016-08-15 0 no no no 2007-08-08 2016-08-15 ? 20160815.ifs 2016-08-15 2016-08-16
2270052 2270052 CORPACTION ADD 26852W103 01 A 2016-08-12 ? 20160812.ifs 2016-08-12 2016-08-13
2270053 2270053 EQUITY CHANGE 26852W103 ADR 0 0 2007-08-08 ? 0 no no no 2007-08-08 ? ? 20160812.ifs 2016-08-12 2016-08-13
2270054 2270053 EQUITY CHANGE 26852W103 ADR A 0 2007-08-08 2016-08-12 0 no no no 2007-08-08 2016-08-12 ? 20160812.ifs 2016-08-12 2016-08-13
2270098 2270098 CORPACTION DELETE 26852W103 01 A 2016-08-12 ? 20160812.ifs 2016-08-12 2016-08-13
2270099 2270099 EQUITY CHANGE 26852W103 ADR A 0 2007-08-08 2016-08-12 0 no no no 2007-08-08 2016-08-12 ? 20160812.ifs 2016-08-12 2016-08-13
2270100 2270099 EQUITY CHANGE 26852W103 ADR 0 0 2007-08-08 ? 0 no no no 2007-08-08 2016-08-12 ? 20160812.ifs 2016-08-12 2016-08-13
2265771 2265771 DIVIDEND CHANGE 26852W103 6 0 1 0 .135 05 2015-04-08 2015-04-10 2015-05-15 2015-03-30 0 2015-03-30 ? 0 0004975248 20160803.ifs 2016-08-03 2016-08-04
2265772 2265771 DIVIDEND CHANGE 26852W103 6 0 1 0 .135 05 2015-04-08 2015-04-10 2015-05-15 2015-03-30 1 2015-03-30 2016-08-03 0 0004975248 20160803.ifs 2016-08-03 2016-08-04
1824577 1824577 DIVIDEND ADD 26852W103 6 0 1 0 .135 05 2015-04-08 2015-04-10 2015-05-15 2015-03-30 0 2015-03-30 ? 0 0004975248 20150330.ifs 2015-03-30 2015-03-31
1770549 1770549 DIVIDEND DELETE 26852W103 0 0 7 0 .05 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 2 2014-11-20 2015-01-14 0 0004874519 20150116.ifs 2015-01-16 2015-01-17
1770550 1770550 DIVIDEND ADD 26852W103 0 0 7 0 .05 0 20 2014-12-01 2014-12-03 2015-01-26 2014-11-20 50187J108 3 2014-11-20 2015-01-16 0 0004874519 20150116.ifs 2015-01-16 2015-01-17
1768519 1768519 DIVIDEND CHANGE 26852W103 0.05 sh. of Leju ADRs for each ADR held. 0 0 7 0 .5 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 1 2014-11-20 2014-11-25 1 0004874519 20150114.ifs 2015-01-14 2015-01-15
1768520 1768519 DIVIDEND CHANGE 26852W103 0.05 sh. of Leju ADRs for each ADR held. 0 0 7 0 .05 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 1 2014-11-20 2015-01-14 1 0004874519 20150114.ifs 2015-01-14 2015-01-15
1768521 1768521 SPLIT CHANGE 26852W103 .3115789474 2014-12-01 20 ? 2014-12-01 20150114.ifs 2015-01-14 2015-01-15
1768522 1768521 SPLIT CHANGE 26852W103 .9311578947 2014-12-01 20 ? 2015-01-14 20150114.ifs 2015-01-14 2015-01-15
1768799 1768799 DIVIDEND CHANGE 26852W103 0.05 sh. of Leju ADRs for each ADR held. 0 0 7 0 .05 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 1 2014-11-20 2015-01-14 1 0004874519 20150114.ifs 2015-01-14 2015-01-15
1768800 1768799 DIVIDEND CHANGE 26852W103 0 0 7 0 .05 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 2 2014-11-20 2015-01-14 0 0004874519 20150114.ifs 2015-01-14 2015-01-15
1757000 1757000 DIVIDEND DELETE 26852W103 6 0 1 5 .19 26 2014-12-01 2014-12-03 ? 2014-11-20 0 2014-11-20 ? 0 0004874529 20141231.ifs 2014-12-31 2015-01-01
1757001 1757001 DIVIDEND ADD 26852W103 6 0 1 0 .19 05 2014-12-01 2014-12-03 2015-01-08 2014-11-20 1 2014-11-20 2014-12-31 0 0004874529 20141231.ifs 2014-12-31 2015-01-01
1692762 1692762 SPLIT ADD 26852W103 .3115789474 2014-12-01 20 ? 2014-12-01 20141201.ifs 2014-12-01 2014-12-02
1687365 1687365 DIVIDEND CHANGE 26852W103 0 0 7 0 .5 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 1 2014-11-20 2014-11-24 1 0004874519 20141125.ifs 2014-11-25 2014-11-26
1687366 1687365 DIVIDEND CHANGE 26852W103 0.05 sh. of Leju ADRs for each ADR held. 0 0 7 0 .5 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 1 2014-11-20 2014-11-25 1 0004874519 20141125.ifs 2014-11-25 2014-11-26
1687103 1687103 DIVIDEND DELETE 26852W103 0.05 sh. of Leju ADRs for each ADR held. 0 0 7 0 .5 0 20 ? 2014-12-03 ? 2014-11-20 50187J108 0 2014-11-20 2014-11-21 1 0004874519 20141124.ifs 2014-11-24 2014-11-25
1687104 1687104 DIVIDEND ADD 26852W103 0 0 7 0 .5 0 20 2014-12-01 2014-12-03 ? 2014-11-20 50187J108 1 2014-11-20 2014-11-24 1 0004874519 20141124.ifs 2014-11-24 2014-11-25
1684952 1684952 DIVIDEND ADD 26852W103 6 0 1 5 .19 26 2014-12-01 2014-12-03 ? 2014-11-20 0 2014-11-20 ? 0 0004874529 20141120.ifs 2014-11-20 2014-11-21
1684953 1684953 DIVIDEND ADD 26852W103 0 0 7 0 .5 20 ? 2014-12-03 ? 2014-11-20 50187J108 0 2014-11-20 ? 1 0004874519 20141120.ifs 2014-11-20 2014-11-21
1495342 1495342 DIVIDEND CHANGE 26852W103 Ex-date corresponds with foreign ex-date. 6 0 1 0 .18 0 05 2014-04-30 2014-05-02 2014-05-30 2014-04-11 0 2014-04-11 2014-04-14 0 0004767770 20140414.ifs 2014-04-14 2014-04-15
1495343 1495342 DIVIDEND CHANGE 26852W103 Ex-date corresponds with foreign ex-date. 6 0 1 0 .18 0 05 2014-04-30 2014-05-02 2014-05-30 2014-04-11 0 2014-04-11 2014-04-14 0 0004767770 20140414.ifs 2014-04-14 2014-04-15
1495265 1495265 DIVIDEND ADD 26852W103 6 0 1 0 .18 05 2014-04-30 2014-05-02 2014-05-30 2014-04-11 0 2014-04-11 ? 0 0004767770 20140411.ifs 2014-04-11 2014-04-12
1136576 1136576 DIVIDEND ADD 26852W103 6 0 1 0 .135 05 2013-04-08 2013-04-10 2013-05-30 2013-03-19 0 2013-03-19 ? 0 0004542756 20130319.ifs 2013-03-19 2013-03-20
801563 801563 DIVIDEND ADD 26852W103 6 0 1 0 .135 05 2012-04-03 2012-04-05 2012-04-25 2012-03-13 0 2012-03-13 ? 0 0004345097 20120313.ifs 2012-03-13 2012-03-14
510209 510209 DIVIDEND CHANGE 26852W103 Ex-date corresponds with foreign ex-date. 6 0 1 0 .23 0 05 2011-04-04 2011-04-06 2011-04-25 2011-03-23 0 2011-03-23 2011-03-24 1 0004162796 20110428.ifs 2011-04-28 2011-04-29
510210 510209 DIVIDEND CHANGE 26852W103 Ex-date corresponds with foreign ex-date. 6 0 1 0 .235 0 05 2011-04-04 2011-04-06 2011-04-25 2011-03-23 0 2011-03-23 2011-04-28 1 0004162796 20110428.ifs 2011-04-28 2011-04-29
478853 478853 DIVIDEND CHANGE 26852W103 6 0 1 0 .23 0 05 2010-04-07 2010-04-09 2010-05-25 2010-03-26 1 2010-03-26 2011-03-23 0 0003982883 20110324.ifs 2011-03-24 2011-03-25
478854 478853 DIVIDEND CHANGE 26852W103 Ex-date corresponds with foreign ex-date. 6 0 1 0 .23 0 05 2010-04-07 2010-04-09 2010-05-25 2010-03-26 1 2010-03-26 2011-03-24 0 0003982883 20110324.ifs 2011-03-24 2011-03-25
478631 478631 DIVIDEND ADD 26852W103 6 0 1 0 .23 05 2011-04-04 2011-04-06 2011-04-25 2011-03-23 0 2011-03-23 ? 1 0004162796 20110323.ifs 2011-03-23 2011-03-24
478632 478632 DIVIDEND DELETE 26852W103 Ex-date corresponds with foreign ex-date. 6 0 1 4 .23 0 26 2010-04-07 2010-04-09 2010-05-25 2010-03-26 0 2010-03-26 2010-03-29 0 0003982883 20110323.ifs 2011-03-23 2011-03-24
478633 478633 DIVIDEND ADD 26852W103 6 0 1 0 .23 0 05 2010-04-07 2010-04-09 2010-05-25 2010-03-26 1 2010-03-26 2011-03-23 0 0003982883 20110323.ifs 2011-03-23 2011-03-24
142184 142184 DIVIDEND ADD 26852W103 6 0 1 4 .23 26 2010-04-07 2010-04-09 2010-05-25 2010-03-26 0 2010-03-26 ? 0 0003982883 20100326.ifs 2010-03-26 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 = 151960
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