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 KNL Charts Yahoo KNL Profile
  Run KNL Institutional Summary Yahoo KNL Key Statisics
  J3 Open KNL Pricing Yahoo KNL Pricing
  J3 KNL Insider   J3 KNL Insitutions Yahoo KNL Holders
     
  Open up Sector/Exchange Map Fidelity KNL Lookup
  Open up sec.gov For Market Ca MSN KNL 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:138922
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
4761517 4761517 CORPACTION ADD 498904200 01 M 2021-07-20 2021-07-20 20210720.ifs 2021-07-20 2021-07-21
4761518 4761518 EQUITY CHANGE 498904200 COM NEW 0 0 2004-12-14 ? 4 yes no no 2005-04-06 2021-07-19 ? 20210720.ifs 2021-07-20 2021-07-21
4761519 4761518 EQUITY CHANGE 498904200 COM NEW M 0 2004-12-14 2021-07-20 4 yes no no 2005-04-06 2021-07-20 ? 20210720.ifs 2021-07-20 2021-07-21
4760946 4760946 CORPACTION ADD 498904200 01 M 2021-07-19 600544100 60 ? 20210719.ifs 2021-07-19 2021-07-20
4760947 4760947 EQUITY CHANGE 498904200 COM NEW 0 0 2004-12-14 ? 4 yes no no 2005-04-06 2004-12-14 ? 20210719.ifs 2021-07-19 2021-07-20
4760948 4760947 EQUITY CHANGE 498904200 COM NEW M 0 2004-12-14 2021-07-19 4 yes no 600544100 no 2005-04-06 2021-07-19 ? 20210719.ifs 2021-07-19 2021-07-20
4760987 4760987 CORPACTION DELETE 498904200 01 M 2021-07-19 600544100 60 ? 20210719.ifs 2021-07-19 2021-07-20
4760988 4760988 EQUITY CHANGE 498904200 COM NEW M 0 2004-12-14 2021-07-19 4 yes no 600544100 no 2005-04-06 2021-07-19 ? 20210719.ifs 2021-07-19 2021-07-20
4760989 4760988 EQUITY CHANGE 498904200 COM NEW 0 0 2004-12-14 ? 4 yes no no 2005-04-06 2021-07-19 ? 20210719.ifs 2021-07-19 2021-07-20
4761140 4761140 DIVIDEND CHANGE 498904200 0 0 1 0 .06 00 2021-06-14 2021-06-15 2021-06-30 2021-05-13 1 2021-05-13 2021-07-09 0 0006308001 20210719.ifs 2021-07-19 2021-07-20
4761141 4761140 DIVIDEND CHANGE 498904200 0 0 1 0 .06 00 2021-06-14 2021-06-15 2021-06-30 2021-05-13 2 2021-05-13 2021-07-19 0 0006308001 20210719.ifs 2021-07-19 2021-07-20
4755611 4755611 DIVIDEND CHANGE 498904200 0 0 1 0 .06 00 2021-06-14 2021-06-15 2021-06-30 2021-05-13 0 2021-05-13 ? 0 0006308001 20210709.ifs 2021-07-09 2021-07-10
4755612 4755611 DIVIDEND CHANGE 498904200 0 0 1 0 .06 00 2021-06-14 2021-06-15 2021-06-30 2021-05-13 1 2021-05-13 2021-07-09 0 0006308001 20210709.ifs 2021-07-09 2021-07-10
4704964 4704964 DIVIDEND ADD 498904200 0 0 1 0 .06 00 2021-06-14 2021-06-15 2021-06-30 2021-05-13 0 2021-05-13 ? 0 0006308001 20210513.ifs 2021-05-13 2021-05-14
4624389 4624389 DIVIDEND ADD 498904200 0 0 1 0 .06 00 2021-03-12 2021-03-15 2021-03-31 2021-02-04 0 2021-02-04 ? 0 0006262162 20210204.ifs 2021-02-04 2021-02-05
4524732 4524732 DIVIDEND ADD 498904200 0 0 1 0 .06 00 2020-12-14 2020-12-15 2020-12-31 2020-12-02 0 2020-12-02 ? 0 0006198828 20201202.ifs 2020-12-02 2020-12-03
4435375 4435375 DIVIDEND ADD 498904200 0 0 1 0 .06 00 2020-09-14 2020-09-15 2020-09-30 2020-08-04 0 2020-08-04 ? 0 0006141946 20200804.ifs 2020-08-04 2020-08-05
4302879 4302879 DIVIDEND ADD 498904200 0 0 1 0 .04 00 2020-06-12 2020-06-15 2020-06-30 2020-04-27 0 2020-04-27 ? 0 0006088509 20200427.ifs 2020-04-27 2020-04-28
4302880 4302880 DIVIDEND ADD 498904200 0 0 1 0 .04 00 2020-06-12 2020-06-15 2020-06-30 2020-04-27 0 2020-04-27 ? 0 0006088509 20200427.ifs 2020-04-27 2020-04-28
4200118 4200118 DIVIDEND ADD 498904200 0 0 1 0 .17 00 2020-03-13 2020-03-16 2020-03-31 2020-02-06 0 2020-02-06 ? 0 0006053637 20200206.ifs 2020-02-06 2020-02-07
4200165 4200165 DIVIDEND ADD 498904200 0 0 1 0 .17 00 2020-03-13 2020-03-16 2020-03-31 2020-02-06 0 2020-02-06 ? 0 0006053637 20200206.ifs 2020-02-06 2020-02-07
3874078 3874078 DIVIDEND ADD 498904200 0 0 1 0 .17 00 2019-09-13 2019-09-16 2019-09-30 2019-08-07 0 2019-08-07 ? 0 0005929169 20190807.ifs 2019-08-07 2019-08-08
3874079 3874079 DIVIDEND ADD 498904200 0 0 1 0 .17 00 2019-09-13 2019-09-16 2019-09-30 2019-08-07 0 2019-08-07 ? 0 0005929169 20190807.ifs 2019-08-07 2019-08-08
3719236 3719236 DIVIDEND ADD 498904200 0 0 1 0 .17 00 2019-06-13 2019-06-14 2019-06-28 2019-05-07 0 2019-05-07 ? 0 0005882166 20190507.ifs 2019-05-07 2019-05-08
3719254 3719254 DIVIDEND ADD 498904200 0 0 1 0 .17 00 2019-06-13 2019-06-14 2019-06-28 2019-05-07 0 2019-05-07 ? 0 0005882166 20190507.ifs 2019-05-07 2019-05-08
3575581 3575581 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2019-03-14 2019-03-15 2019-03-29 2019-02-05 0 2019-02-05 ? 0 0005836557 20190205.ifs 2019-02-05 2019-02-06
3575582 3575582 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2019-03-14 2019-03-15 2019-03-29 2019-02-05 0 2019-02-05 ? 0 0005836557 20190205.ifs 2019-02-05 2019-02-06
3403088 3403088 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-12-13 2018-12-14 2018-12-31 2018-12-04 0 2018-12-04 ? 0 0005766187 20181204.ifs 2018-12-04 2018-12-05
3403123 3403123 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-12-13 2018-12-14 2018-12-31 2018-12-04 0 2018-12-04 ? 0 0005766187 20181204.ifs 2018-12-04 2018-12-05
3233719 3233719 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-09-13 2018-09-14 2018-09-28 2018-08-08 0 2018-08-08 ? 0 0005707090 20180808.ifs 2018-08-08 2018-08-09
3233742 3233742 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-09-13 2018-09-14 2018-09-28 2018-08-08 0 2018-08-08 ? 0 0005707090 20180808.ifs 2018-08-08 2018-08-09
3083834 3083834 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-06-14 2018-06-15 2018-06-29 2018-05-08 0 2018-05-08 ? 0 0005659710 20180508.ifs 2018-05-08 2018-05-09
3084076 3084076 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-06-14 2018-06-15 2018-06-29 2018-05-08 0 2018-05-08 ? 0 0005659710 20180508.ifs 2018-05-08 2018-05-09
2946662 2946662 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-03-14 2018-03-15 2018-03-30 2018-02-06 0 2018-02-06 ? 0 0005613546 20180206.ifs 2018-02-06 2018-02-07
2946665 2946665 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2018-03-14 2018-03-15 2018-03-30 2018-02-06 0 2018-02-06 ? 0 0005613546 20180206.ifs 2018-02-06 2018-02-07
2797968 2797968 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2017-12-14 2017-12-15 2017-12-29 2017-12-04 0 2017-12-04 ? 0 0005542041 20171204.ifs 2017-12-04 2017-12-05
2798092 2798092 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2017-12-14 2017-12-15 2017-12-29 2017-12-04 0 2017-12-04 ? 0 0005542041 20171204.ifs 2017-12-04 2017-12-05
2646669 2646669 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2017-09-14 2017-09-15 2017-09-29 2017-08-09 0 2017-08-09 ? 0 0005482072 20170809.ifs 2017-08-09 2017-08-10
2564402 2564402 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2017-06-13 2017-06-15 2017-06-30 2017-05-09 0 2017-05-09 ? 0 0005434159 20170509.ifs 2017-05-09 2017-05-10
2486570 2486570 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2017-03-13 2017-03-15 2017-03-31 2017-02-07 0 2017-02-07 ? 0 0005386819 20170207.ifs 2017-02-07 2017-02-08
2440990 2440990 EQUITY CHANGE 498904200 COM NEW 0 0 2004-12-14 ? 0 yes no no 2005-04-06 2004-12-14 ? 20170123.ifs 2017-01-23 2017-01-24
2440991 2440990 EQUITY CHANGE 498904200 COM NEW 0 0 2004-12-14 ? 4 yes no no 2005-04-06 2004-12-14 ? 20170123.ifs 2017-01-23 2017-01-24
2362338 2362338 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2016-12-14 2016-12-16 2016-12-30 2016-12-06 0 2016-12-06 ? 0 0005324607 20161206.ifs 2016-12-06 2016-12-07
2265647 2265647 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2016-09-13 2016-09-15 2016-09-30 2016-08-03 0 2016-08-03 ? 0 0005263284 20160803.ifs 2016-08-03 2016-08-04
2191235 2191235 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2016-06-13 2016-06-15 2016-06-30 2016-05-04 0 2016-05-04 ? 0 0005216958 20160504.ifs 2016-05-04 2016-05-05
2111280 2111280 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2016-03-11 2016-03-15 2016-03-31 2016-02-09 0 2016-02-09 ? 0 0005171523 20160209.ifs 2016-02-09 2016-02-10
2023666 2023666 DIVIDEND ADD 498904200 0 0 1 0 .15 00 2015-12-11 2015-12-15 2015-12-31 2015-12-03 0 2015-12-03 ? 0 0005105382 20151203.ifs 2015-12-03 2015-12-04
1935781 1935781 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2015-09-11 2015-09-15 2015-09-30 2015-08-04 0 2015-08-04 ? 0 0005045051 20150804.ifs 2015-08-04 2015-08-05
1861257 1861257 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2015-06-11 2015-06-15 2015-06-30 2015-05-11 0 2015-05-11 ? 0 0004999634 20150511.ifs 2015-05-11 2015-05-12
1785059 1785059 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2015-03-11 2015-03-13 2015-03-31 2015-02-03 0 2015-02-03 ? 0 0004952273 20150203.ifs 2015-02-03 2015-02-04
1699750 1699750 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2014-12-11 2014-12-15 2014-12-31 2014-12-04 0 2014-12-04 ? 0 0004884848 20141204.ifs 2014-12-04 2014-12-05
1601385 1601385 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2014-09-11 2014-09-15 2014-09-30 2014-08-07 0 2014-08-07 ? 0 0004827464 20140807.ifs 2014-08-07 2014-08-08
1521608 1521608 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2014-06-12 2014-06-16 2014-06-30 2014-05-08 0 2014-05-08 ? 0 0004781388 20140508.ifs 2014-05-08 2014-05-09
1438704 1438704 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2014-03-12 2014-03-14 2014-03-31 2014-02-04 0 2014-02-04 ? 0 0004734569 20140204.ifs 2014-02-04 2014-02-05
1359236 1359236 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2013-12-12 2013-12-16 2013-12-31 2013-12-05 0 2013-12-05 ? 0 0004671708 20131205.ifs 2013-12-05 2013-12-06
1261023 1261023 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2013-09-12 2013-09-16 2013-09-30 2013-08-07 0 2013-08-07 ? 0 0004614270 20130807.ifs 2013-08-07 2013-08-08
1181401 1181401 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2013-06-12 2013-06-14 2013-06-28 2013-05-07 0 2013-05-07 ? 0 0004569902 20130507.ifs 2013-05-07 2013-05-08
1108997 1108997 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2013-03-13 2013-03-15 2013-03-28 2013-02-06 0 2013-02-06 ? 0 0004526524 20130206.ifs 2013-02-06 2013-02-07
1030253 1030253 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2012-12-13 2012-12-17 2012-12-31 2012-12-06 0 2012-12-06 ? 0 0004471511 20121206.ifs 2012-12-06 2012-12-07
928777 928777 DIVIDEND ADD 498904200 0 0 1 0 .12 00 2012-09-12 2012-09-14 2012-09-28 2012-08-07 0 2012-08-07 ? 0 0004414451 20120807.ifs 2012-08-07 2012-08-08
858535 858535 DIVIDEND ADD 498904200 0 0 1 0 .1 00 2012-06-13 2012-06-15 2012-06-29 2012-05-09 0 2012-05-09 ? 0 0004373279 20120509.ifs 2012-05-09 2012-05-10
773355 773355 DIVIDEND ADD 498904200 0 0 1 0 .1 00 2012-03-13 2012-03-15 2012-03-30 2012-02-02 0 2012-02-02 ? 0 0004330652 20120202.ifs 2012-02-02 2012-02-03
708569 708569 DIVIDEND ADD 498904200 0 0 1 0 .1 00 2011-12-13 2011-12-15 2011-12-30 2011-12-01 0 2011-12-01 ? 0 0004279373 20111201.ifs 2011-12-01 2011-12-02
612468 612468 DIVIDEND ADD 498904200 0 0 1 0 .1 00 2011-09-13 2011-09-15 2011-09-30 2011-08-10 0 2011-08-10 ? 0 0004228928 20110810.ifs 2011-08-10 2011-08-11
520992 520992 DIVIDEND ADD 498904200 0 0 1 0 .1 00 2011-06-13 2011-06-15 2011-06-30 2011-05-05 0 2011-05-05 ? 0 0004186584 20110505.ifs 2011-05-05 2011-05-06
438297 438297 DIVIDEND ADD 498904200 0 0 1 0 .06 00 2011-03-11 2011-03-15 2011-03-31 2011-02-03 0 2011-02-04 ? 0 0004145136 20110204.ifs 2011-02-04 2011-02-05
277285 277285 DIVIDEND ADD 498904200 0 0 1 0 .02 00 2010-09-13 2010-09-15 2010-09-30 2010-08-11 0 2010-08-11 ? 0 0004046699 20100811.ifs 2010-08-11 2010-08-12
185239 185239 DIVIDEND ADD 498904200 0 0 1 0 .02 00 2010-06-11 2010-06-15 2010-06-30 2010-05-05 0 2010-05-05 ? 0 0004004063 20100505.ifs 2010-05-05 2010-05-06
105413 105413 DIVIDEND ADD 498904200 0 0 1 0 .02 00 2010-03-11 2010-03-15 2010-03-31 2010-02-03 0 2010-02-04 ? 0 0003963456 20100204.ifs 2010-02-04 2010-04-07
37120 37120 DIVIDEND ADD 498904200 0 0 1 0 .02 00 2009-12-11 2009-12-15 2009-12-31 2009-12-01 0 2009-12-01 ? 0 0003917218 20091202.ifs 2009-12-02 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 = 138922
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