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

the compid is:134482
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
5557426 5557426 DIVIDEND ADD 404251100 0 0 1 0 .33 00 2024-05-23 2024-05-24 2024-06-12 2024-05-13 0 2024-05-13 ? 0 0006919590 20240513.ifs 2024-05-13 2024-05-14
5498764 5498764 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2024-02-23 2024-02-26 2024-03-06 2024-02-13 0 2024-02-14 ? 0 0006876534 20240214.ifs 2024-02-14 2024-02-15
5412301 5412301 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2023-11-17 2023-11-20 2023-12-01 2023-11-08 0 2023-11-08 ? 0 0006810881 20231108.ifs 2023-11-08 2023-11-09
5354197 5354197 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2023-08-24 2023-08-25 2023-09-08 2023-08-15 0 2023-08-15 ? 0 0006769380 20230815.ifs 2023-08-15 2023-08-16
5291469 5291469 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2023-06-08 2023-06-09 2023-06-23 2023-05-15 0 2023-05-15 ? 0 0006725971 20230515.ifs 2023-05-15 2023-05-16
5230357 5230357 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2023-02-24 2023-02-27 2023-03-08 2023-02-14 0 2023-02-14 ? 0 0006682567 20230214.ifs 2023-02-14 2023-02-15
5138115 5138115 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2022-11-18 2022-11-21 2022-12-01 2022-11-09 0 2022-11-09 ? 0 0006611975 20221109.ifs 2022-11-09 2022-11-10
5078860 5078860 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2022-08-25 2022-08-26 2022-09-08 2022-08-16 0 2022-08-16 ? 0 0006570003 20220816.ifs 2022-08-16 2022-08-17
5012609 5012609 DIVIDEND ADD 404251100 0 0 1 0 .32 00 2022-05-26 2022-05-27 2022-06-08 2022-05-16 0 2022-05-16 ? 0 0006524548 20220516.ifs 2022-05-16 2022-05-17
4953824 4953824 DIVIDEND ADD 404251100 0 0 1 0 .31 00 2022-02-25 2022-02-28 2022-03-07 2022-02-15 0 2022-02-15 ? 0 0006481258 20220215.ifs 2022-02-15 2022-02-16
4847017 4847017 DIVIDEND ADD 404251100 0 0 1 0 .31 00 2021-11-19 2021-11-22 2021-12-01 2021-11-11 0 2021-11-11 ? 0 0006396128 20211111.ifs 2021-11-11 2021-11-12
4779957 4779957 DIVIDEND ADD 404251100 0 0 1 0 .31 00 2021-08-19 2021-08-20 2021-09-01 2021-08-10 0 2021-08-10 ? 0 0006353062 20210810.ifs 2021-08-10 2021-08-11
4702928 4702928 DIVIDEND ADD 404251100 0 0 1 0 .31 00 2021-05-20 2021-05-21 2021-06-01 2021-05-10 0 2021-05-10 ? 0 0006307160 20210510.ifs 2021-05-10 2021-05-11
4630223 4630223 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2021-02-26 2021-03-01 2021-03-08 2021-02-16 0 2021-02-16 ? 0 0006264561 20210216.ifs 2021-02-16 2021-02-17
4502691 4502691 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2020-11-13 2020-11-16 2020-12-01 2020-11-04 0 2020-11-04 ? 0 0006186714 20201104.ifs 2020-11-04 2020-11-05
4432666 4432666 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2020-08-13 2020-08-14 2020-09-01 2020-08-03 0 2020-08-03 ? 0 0006140900 20200803.ifs 2020-08-03 2020-08-04
4324485 4324485 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2020-05-14 2020-05-15 2020-06-01 2020-05-05 0 2020-05-05 ? 0 0006096548 20200505.ifs 2020-05-05 2020-05-06
4324657 4324657 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2020-05-14 2020-05-15 2020-06-01 2020-05-05 0 2020-05-05 ? 0 0006096548 20200505.ifs 2020-05-05 2020-05-06
4204079 4204079 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2020-02-21 2020-02-24 2020-03-02 2020-02-12 0 2020-02-12 ? 0 0006054868 20200212.ifs 2020-02-12 2020-02-13
4204196 4204196 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2020-02-21 2020-02-24 2020-03-02 2020-02-12 0 2020-02-12 ? 0 0006054868 20200212.ifs 2020-02-12 2020-02-13
4009233 4009233 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2019-11-15 2019-11-18 2019-12-02 2019-11-07 0 2019-11-07 ? 0 0005974181 20191107.ifs 2019-11-07 2019-11-08
4009413 4009413 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2019-11-15 2019-11-18 2019-12-02 2019-11-07 0 2019-11-07 ? 0 0005974181 20191107.ifs 2019-11-07 2019-11-08
3872830 3872830 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2019-08-15 2019-08-16 2019-09-03 2019-08-06 0 2019-08-06 ? 0 0005928742 20190806.ifs 2019-08-06 2019-08-07
3872831 3872831 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2019-08-15 2019-08-16 2019-09-03 2019-08-06 0 2019-08-06 ? 0 0005928742 20190806.ifs 2019-08-06 2019-08-07
3719287 3719287 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2019-05-16 2019-05-17 2019-06-03 2019-05-07 0 2019-05-07 ? 0 0005882065 20190507.ifs 2019-05-07 2019-05-08
3719307 3719307 DIVIDEND ADD 404251100 0 0 1 0 .305 00 2019-05-16 2019-05-17 2019-06-03 2019-05-07 0 2019-05-07 ? 0 0005882065 20190507.ifs 2019-05-07 2019-05-08
3582329 3582329 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2019-02-22 2019-02-25 2019-03-04 2019-02-13 0 2019-02-13 ? 0 0005837996 20190213.ifs 2019-02-13 2019-02-14
3582330 3582330 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2019-02-22 2019-02-25 2019-03-04 2019-02-13 0 2019-02-13 ? 0 0005837996 20190213.ifs 2019-02-13 2019-02-14
3366030 3366030 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2018-11-16 2018-11-19 2018-12-03 2018-11-07 0 2018-11-07 ? 0 0005753413 20181107.ifs 2018-11-07 2018-11-08
3366031 3366031 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2018-11-16 2018-11-19 2018-12-03 2018-11-07 0 2018-11-07 ? 0 0005753413 20181107.ifs 2018-11-07 2018-11-08
3232370 3232370 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2018-08-16 2018-08-17 2018-09-04 2018-08-07 0 2018-08-07 ? 0 0005706530 20180807.ifs 2018-08-07 2018-08-08
3232371 3232371 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2018-08-16 2018-08-17 2018-09-04 2018-08-07 0 2018-08-07 ? 0 0005706530 20180807.ifs 2018-08-07 2018-08-08
3083909 3083909 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2018-05-17 2018-05-18 2018-06-01 2018-05-08 0 2018-05-08 ? 0 0005659534 20180508.ifs 2018-05-08 2018-05-09
3084146 3084146 DIVIDEND ADD 404251100 0 0 1 0 .295 00 2018-05-17 2018-05-18 2018-06-01 2018-05-08 0 2018-05-08 ? 0 0005659534 20180508.ifs 2018-05-08 2018-05-09
2953116 2953116 DIVIDEND ADD 404251100 0 0 1 0 .285 00 2018-02-23 2018-02-26 2018-03-05 2018-02-14 0 2018-02-14 ? 0 0005614965 20180214.ifs 2018-02-14 2018-02-15
2953126 2953126 DIVIDEND ADD 404251100 0 0 1 0 .285 00 2018-02-23 2018-02-26 2018-03-05 2018-02-14 0 2018-02-14 ? 0 0005614965 20180214.ifs 2018-02-14 2018-02-15
2761559 2761559 DIVIDEND ADD 404251100 0 0 1 0 .285 00 2017-11-17 2017-11-20 2017-12-01 2017-11-09 0 2017-11-09 ? 0 0005528697 20171109.ifs 2017-11-09 2017-11-10
2761969 2761969 DIVIDEND ADD 404251100 0 0 1 0 .285 00 2017-11-17 2017-11-20 2017-12-01 2017-11-09 0 2017-11-09 ? 0 0005528697 20171109.ifs 2017-11-09 2017-11-10
2646094 2646094 DIVIDEND ADD 404251100 0 0 1 0 .285 00 2017-08-16 2017-08-18 2017-09-01 2017-08-08 0 2017-08-08 ? 0 0005481812 20170808.ifs 2017-08-08 2017-08-09
2564425 2564425 DIVIDEND ADD 404251100 0 0 1 0 .285 00 2017-05-17 2017-05-19 2017-06-01 2017-05-09 0 2017-05-09 ? 0 0005434076 20170509.ifs 2017-05-09 2017-05-10
2490769 2490769 DIVIDEND ADD 404251100 0 0 1 0 .275 00 2017-02-23 2017-02-27 2017-03-06 2017-02-15 0 2017-02-15 ? 0 0005388512 20170215.ifs 2017-02-15 2017-02-16
2439164 2439164 EQUITY CHANGE 404251100 COM 0 0 2004-04-30 ? 0 yes yes no 2004-05-06 2004-05-06 ? 20170123.ifs 2017-01-23 2017-01-24
2439165 2439164 EQUITY CHANGE 404251100 COM 0 0 2004-04-30 ? 4 yes yes no 2004-05-06 2004-05-06 ? 20170123.ifs 2017-01-23 2017-01-24
2342057 2342057 DIVIDEND ADD 404251100 0 0 1 0 .275 00 2016-11-17 2016-11-21 2016-12-01 2016-11-10 0 2016-11-10 ? 0 0005310715 20161110.ifs 2016-11-10 2016-11-11
2268459 2268459 DIVIDEND ADD 404251100 0 0 1 0 .275 00 2016-08-17 2016-08-19 2016-09-01 2016-08-09 0 2016-08-09 ? 0 0005264545 20160809.ifs 2016-08-09 2016-08-10
2193994 2193994 DIVIDEND ADD 404251100 0 0 1 0 .275 00 2016-05-18 2016-05-20 2016-06-01 2016-05-10 0 2016-05-10 ? 0 0005217922 20160510.ifs 2016-05-10 2016-05-11
2114104 2114104 DIVIDEND ADD 404251100 0 0 1 0 .265 00 2016-02-25 2016-02-29 2016-03-07 2016-02-17 0 2016-02-17 ? 0 0005173153 20160217.ifs 2016-02-17 2016-02-18
2008084 2008084 DIVIDEND ADD 404251100 0 0 1 0 .265 00 2015-11-19 2015-11-23 2015-12-01 2015-11-12 0 2015-11-12 ? 0 0005092957 20151112.ifs 2015-11-12 2015-11-13
1935936 1935936 DIVIDEND ADD 404251100 0 0 1 0 .265 00 2015-08-12 2015-08-14 2015-09-01 2015-08-04 0 2015-08-04 ? 0 0005043866 20150804.ifs 2015-08-04 2015-08-05
1792530 1792530 DIVIDEND ADD 404251100 0 0 1 0 .25 00 2015-02-26 2015-03-02 2015-03-09 2015-02-18 0 2015-02-18 ? 0 0004955409 20150218.ifs 2015-02-18 2015-02-19
1677111 1677111 DIVIDEND ADD 404251100 0 0 1 0 .25 00 2014-11-13 2014-11-17 2014-12-01 2014-11-06 0 2014-11-06 ? 0 0004871288 20141106.ifs 2014-11-06 2014-11-07
1600064 1600064 DIVIDEND ADD 404251100 0 0 1 0 .25 00 2014-08-13 2014-08-15 2014-08-29 2014-08-05 0 2014-08-05 ? 0 0004826724 20140805.ifs 2014-08-05 2014-08-06
1520867 1520867 DIVIDEND CHANGE 404251100 0 0 1 0 .25 00 2014-05-14 2014-05-16 2014-05-30 2014-05-06 0 2014-05-06 ? 0 0004780740 20140507.ifs 2014-05-07 2014-05-08
1520868 1520867 DIVIDEND CHANGE 404251100 0 0 1 0 .25 00 2014-05-14 2014-05-16 2014-05-30 2014-05-06 1 2014-05-06 2014-05-07 0 0004780740 20140507.ifs 2014-05-07 2014-05-08
1520016 1520016 DIVIDEND ADD 404251100 0 0 1 0 .25 00 2014-05-14 2014-05-16 2014-05-30 2014-05-06 0 2014-05-06 ? 0 0004780740 20140506.ifs 2014-05-06 2014-05-07
1442798 1442798 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2014-02-20 2014-02-24 2014-03-03 2014-02-12 0 2014-02-12 ? 0 0004736026 20140212.ifs 2014-02-12 2014-02-13
1337072 1337072 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2013-11-14 2013-11-18 2013-12-02 2013-11-07 0 2013-11-07 ? 0 0004656851 20131107.ifs 2013-11-07 2013-11-08
1260436 1260436 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2013-08-14 2013-08-16 2013-08-30 2013-08-06 0 2013-08-06 ? 0 0004613552 20130806.ifs 2013-08-06 2013-08-07
1181446 1181446 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2013-05-15 2013-05-17 2013-05-31 2013-05-07 0 2013-05-07 ? 0 0004569773 20130507.ifs 2013-05-07 2013-05-08
1111957 1111957 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2013-02-21 2013-02-25 2013-03-04 2013-02-13 0 2013-02-13 ? 0 0004527667 20130213.ifs 2013-02-13 2013-02-14
1007680 1007680 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2012-11-15 2012-11-19 2012-11-30 2012-11-08 0 2012-11-08 ? 0 0004457058 20121108.ifs 2012-11-08 2012-11-09
929041 929041 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2012-08-15 2012-08-17 2012-08-31 2012-08-07 0 2012-08-07 ? 0 0004414142 20120807.ifs 2012-08-07 2012-08-08
857138 857138 DIVIDEND ADD 404251100 0 0 1 0 .24 00 2012-05-16 2012-05-18 2012-06-01 2012-05-08 0 2012-05-08 ? 0 0004372925 20120508.ifs 2012-05-08 2012-05-09
780007 780007 DIVIDEND ADD 404251100 0 0 1 0 .23 00 2012-02-24 2012-02-28 2012-03-06 2012-02-15 0 2012-02-15 ? 0 0004333014 20120215.ifs 2012-02-15 2012-02-16
693238 693238 DIVIDEND ADD 404251100 0 0 1 0 .23 00 2011-11-17 2011-11-21 2011-12-01 2011-11-10 0 2011-11-10 ? 0 0004269188 20111110.ifs 2011-11-10 2011-11-11
609765 609765 DIVIDEND ADD 404251100 0 0 1 0 .23 00 2011-08-17 2011-08-19 2011-09-01 2011-08-09 0 2011-08-09 ? 0 0004228529 20110809.ifs 2011-08-09 2011-08-10
523655 523655 DIVIDEND ADD 404251100 0 0 1 0 .23 00 2011-05-18 2011-05-20 2011-06-01 2011-05-10 0 2011-05-10 ? 0 0004187212 20110510.ifs 2011-05-10 2011-05-11
444212 444212 DIVIDEND ADD 404251100 0 0 1 0 .23 00 2011-02-24 2011-02-28 2011-03-07 2011-02-16 0 2011-02-16 ? 0 0004147374 20110216.ifs 2011-02-16 2011-02-17
353761 353761 DIVIDEND ADD 404251100 0 0 1 0 .215 00 2010-11-18 2010-11-22 2010-12-01 2010-11-11 0 2010-11-11 ? 0 0004086681 20101111.ifs 2010-11-11 2010-11-12
276754 276754 DIVIDEND ADD 404251100 0 0 1 0 .215 00 2010-08-18 2010-08-20 2010-09-01 2010-08-10 0 2010-08-10 ? 0 0004046299 20100810.ifs 2010-08-10 2010-08-11
189999 189999 DIVIDEND ADD 404251100 0 0 1 0 .215 00 2010-05-19 2010-05-21 2010-06-01 2010-05-11 0 2010-05-11 ? 0 0004005206 20100511.ifs 2010-05-11 2010-05-12
111773 111773 DIVIDEND ADD 404251100 0 0 1 0 .215 00 2010-02-25 2010-03-01 2010-03-08 2010-02-17 0 2010-02-17 ? 0 0003965708 20100217.ifs 2010-02-17 2010-04-07
25780 25780 DIVIDEND ADD 404251100 0 0 1 0 .215 00 2009-11-25 2009-11-30 2009-12-07 2009-11-18 0 2009-11-18 ? 0 0003908880 20091118.ifs 2009-11-18 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 = 134482
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