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

the compid is:130528
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
5550320 5550320 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2024-05-31 2024-05-31 2024-06-17 2024-04-30 0 2024-05-01 ? 0 0006913275 20240501.ifs 2024-05-01 2024-05-02
5494918 5494918 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2024-02-28 2024-02-29 2024-03-15 2024-02-05 0 2024-02-05 ? 0 0006874763 20240205.ifs 2024-02-05 2024-02-06
5407773 5407773 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2023-11-29 2023-11-30 2023-12-15 2023-11-01 0 2023-11-01 ? 0 0006805638 20231101.ifs 2023-11-01 2023-11-02
5355640 5355640 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2023-08-30 2023-08-31 2023-09-15 2023-08-18 0 2023-08-18 ? 0 0006770040 20230818.ifs 2023-08-18 2023-08-19
5286677 5286677 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2023-05-30 2023-05-31 2023-06-15 2023-05-03 0 2023-05-03 ? 0 0006723179 20230503.ifs 2023-05-03 2023-05-04
5225855 5225855 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2023-02-27 2023-02-28 2023-03-15 2023-02-02 0 2023-02-02 ? 0 0006679691 20230202.ifs 2023-02-02 2023-02-03
5134626 5134626 DIVIDEND ADD 518439104 0 0 1 0 .66 00 2022-11-29 2022-11-30 2022-12-15 2022-11-02 0 2022-11-02 ? 0 0006609982 20221102.ifs 2022-11-02 2022-11-03
5079499 5079499 DIVIDEND ADD 518439104 0 0 1 0 .6 00 2022-08-30 2022-08-31 2022-09-15 2022-08-18 0 2022-08-18 ? 0 0006570283 20220818.ifs 2022-08-18 2022-08-19
5006929 5006929 DIVIDEND ADD 518439104 0 0 1 0 .6 00 2022-05-27 2022-05-31 2022-06-15 2022-05-03 0 2022-05-03 ? 0 0006520361 20220503.ifs 2022-05-03 2022-05-04
4948303 4948303 DIVIDEND ADD 518439104 0 0 1 0 .6 00 2022-02-25 2022-02-28 2022-03-15 2022-02-03 0 2022-02-03 ? 0 0006477741 20220203.ifs 2022-02-03 2022-02-04
4842283 4842283 DIVIDEND ADD 518439104 0 0 1 0 .6 00 2021-11-29 2021-11-30 2021-12-15 2021-11-02 0 2021-11-02 ? 0 0006393759 20211102.ifs 2021-11-02 2021-11-03
4783926 4783926 DIVIDEND ADD 518439104 0 0 1 0 .53 00 2021-08-30 2021-08-31 2021-09-15 2021-08-19 0 2021-08-19 ? 0 0006354373 20210819.ifs 2021-08-19 2021-08-20
4696835 4696835 DIVIDEND ADD 518439104 0 0 1 0 .53 00 2021-05-27 2021-05-28 2021-06-15 2021-05-03 0 2021-05-03 ? 0 0006301209 20210503.ifs 2021-05-03 2021-05-04
4625377 4625377 DIVIDEND ADD 518439104 0 0 1 0 .53 00 2021-02-25 2021-02-26 2021-03-15 2021-02-05 0 2021-02-05 ? 0 0006262173 20210205.ifs 2021-02-05 2021-02-06
4499278 4499278 DIVIDEND ADD 518439104 0 0 1 0 .53 00 2020-11-27 2020-11-30 2020-12-15 2020-11-02 0 2020-11-02 ? 0 0006181672 20201102.ifs 2020-11-02 2020-11-03
4443487 4443487 DIVIDEND ADD 518439104 0 0 1 0 .48 00 2020-08-28 2020-08-31 2020-09-15 2020-08-20 0 2020-08-20 ? 0 0006145309 20200820.ifs 2020-08-20 2020-08-21
4289045 4289045 DIVIDEND ADD 518439104 0 0 E 0 0 58 ? ? 2020-06-15 2020-04-15 0 2020-04-15 ? 0 0006085328 20200415.ifs 2020-04-15 2020-04-16
4289046 4289046 DIVIDEND ADD 518439104 0 0 E 0 0 58 ? ? 2020-06-15 2020-04-15 0 2020-04-15 ? 0 0006085328 20200415.ifs 2020-04-15 2020-04-16
4200112 4200112 DIVIDEND ADD 518439104 0 0 1 0 .48 00 2020-02-27 2020-02-28 2020-03-16 2020-02-06 0 2020-02-06 ? 0 0006053515 20200206.ifs 2020-02-06 2020-02-07
4200159 4200159 DIVIDEND ADD 518439104 0 0 1 0 .48 00 2020-02-27 2020-02-28 2020-03-16 2020-02-06 0 2020-02-06 ? 0 0006053515 20200206.ifs 2020-02-06 2020-02-07
3993211 3993211 DIVIDEND ADD 518439104 0 0 1 0 .48 00 2019-11-27 2019-11-29 2019-12-16 2019-10-31 0 2019-10-31 ? 0 0005966823 20191031.ifs 2019-10-31 2019-11-01
3993254 3993254 DIVIDEND ADD 518439104 0 0 1 0 .48 00 2019-11-27 2019-11-29 2019-12-16 2019-10-31 0 2019-10-31 ? 0 0005966823 20191031.ifs 2019-10-31 2019-11-01
3882615 3882615 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2019-08-29 2019-08-30 2019-09-16 2019-08-19 0 2019-08-19 ? 0 0005931059 20190819.ifs 2019-08-19 2019-08-20
3882622 3882622 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2019-08-29 2019-08-30 2019-09-16 2019-08-19 0 2019-08-19 ? 0 0005931059 20190819.ifs 2019-08-19 2019-08-20
3710195 3710195 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2019-05-30 2019-05-31 2019-06-17 2019-05-01 0 2019-05-01 ? 0 0005877198 20190501.ifs 2019-05-01 2019-05-02
3710202 3710202 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2019-05-30 2019-05-31 2019-06-17 2019-05-01 0 2019-05-01 ? 0 0005877198 20190501.ifs 2019-05-01 2019-05-02
3575579 3575579 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2019-02-27 2019-02-28 2019-03-15 2019-02-04 0 2019-02-05 ? 0 0005836419 20190205.ifs 2019-02-05 2019-02-06
3575580 3575580 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2019-02-27 2019-02-28 2019-03-15 2019-02-04 0 2019-02-05 ? 0 0005836419 20190205.ifs 2019-02-05 2019-02-06
3347965 3347965 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2018-11-29 2018-11-30 2018-12-17 2018-10-31 0 2018-10-31 ? 0 0005745267 20181031.ifs 2018-10-31 2018-11-01
3348012 3348012 DIVIDEND ADD 518439104 0 0 1 0 .43 00 2018-11-29 2018-11-30 2018-12-17 2018-10-31 0 2018-10-31 ? 0 0005745267 20181031.ifs 2018-10-31 2018-11-01
3243662 3243662 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2018-08-30 2018-08-31 2018-09-17 2018-08-20 0 2018-08-20 ? 0 0005709069 20180820.ifs 2018-08-20 2018-08-21
3243663 3243663 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2018-08-30 2018-08-31 2018-09-17 2018-08-20 0 2018-08-20 ? 0 0005709069 20180820.ifs 2018-08-20 2018-08-21
3075763 3075763 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2018-05-30 2018-05-31 2018-06-15 2018-05-02 0 2018-05-02 ? 0 0005658039 20180502.ifs 2018-05-02 2018-05-03
3075770 3075770 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2018-05-30 2018-05-31 2018-06-15 2018-05-02 0 2018-05-02 ? 0 0005658039 20180502.ifs 2018-05-02 2018-05-03
2943723 2943723 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2018-02-27 2018-02-28 2018-03-15 2018-02-02 0 2018-02-02 ? 0 0005612242 20180202.ifs 2018-02-02 2018-02-03
2943798 2943798 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2018-02-27 2018-02-28 2018-03-15 2018-02-02 0 2018-02-02 ? 0 0005612242 20180202.ifs 2018-02-02 2018-02-03
2751102 2751102 DIVIDEND ADD 518439104 0 0 1 0 .38 00 2017-11-29 2017-11-30 2017-12-15 2017-11-01 0 2017-11-01 ? 0 0005522713 20171101.ifs 2017-11-01 2017-11-02
2651602 2651602 DIVIDEND ADD 518439104 0 0 1 0 .34 00 2017-08-29 2017-08-31 2017-09-15 2017-08-18 0 2017-08-18 ? 0 0005483617 20170818.ifs 2017-08-18 2017-08-19
2561038 2561038 DIVIDEND ADD 518439104 0 0 1 0 .34 00 2017-05-26 2017-05-31 2017-06-15 2017-05-03 0 2017-05-03 ? 0 0005432412 20170503.ifs 2017-05-03 2017-05-04
2484213 2484213 DIVIDEND ADD 518439104 0 0 1 0 .34 00 2017-02-24 2017-02-28 2017-03-15 2017-02-02 0 2017-02-02 ? 0 0005385509 20170202.ifs 2017-02-02 2017-02-03
2441060 2441060 EQUITY CHANGE 518439104 CL A 0 0 1995-11-17 ? 1 yes yes no 2002-10-31 2006-01-09 ? 20170123.ifs 2017-01-23 2017-01-24
2441061 2441060 EQUITY CHANGE 518439104 CL A 0 0 1995-11-17 ? 4 yes yes no 2002-10-31 2006-01-09 ? 20170123.ifs 2017-01-23 2017-01-24
2337600 2337600 DIVIDEND ADD 518439104 0 0 1 0 .34 00 2016-11-28 2016-11-30 2016-12-15 2016-11-02 0 2016-11-02 ? 0 0005308737 20161102.ifs 2016-11-02 2016-11-03
2273475 2273475 DIVIDEND ADD 518439104 0 0 1 0 .3 00 2016-08-29 2016-08-31 2016-09-15 2016-08-19 0 2016-08-19 ? 0 0005266740 20160819.ifs 2016-08-19 2016-08-20
2189994 2189994 DIVIDEND ADD 518439104 0 0 1 0 .3 00 2016-05-26 2016-05-31 2016-06-15 2016-05-03 0 2016-05-03 ? 0 0005215614 20160503.ifs 2016-05-03 2016-05-04
2110164 2110164 DIVIDEND ADD 518439104 0 0 1 0 .3 00 2016-02-25 2016-02-29 2016-03-15 2016-02-05 0 2016-02-05 ? 0 0005170921 20160205.ifs 2016-02-05 2016-02-06
1942194 1942194 DIVIDEND ADD 518439104 0 0 1 0 .24 00 2015-08-27 2015-08-31 2015-09-15 2015-08-17 0 2015-08-17 ? 0 0005047508 20150817.ifs 2015-08-17 2015-08-18
1787202 1787202 DIVIDEND ADD 518439104 0 0 1 0 .24 00 2015-02-25 2015-02-27 2015-03-16 2015-02-05 0 2015-02-05 ? 0 0004952982 20150205.ifs 2015-02-05 2015-02-06
1674882 1674882 DIVIDEND ADD 518439104 0 0 1 0 .24 00 2014-11-25 2014-11-28 2014-12-15 2014-11-04 0 2014-11-04 ? 0 0004870224 20141104.ifs 2014-11-04 2014-11-05
1607779 1607779 DIVIDEND ADD 518439104 0 0 1 0 .2 00 2014-08-27 2014-08-29 2014-09-15 2014-08-15 0 2014-08-15 ? 0 0004829091 20140815.ifs 2014-08-15 2014-08-16
1516458 1516458 DIVIDEND ADD 518439104 0 0 1 0 .2 00 2014-05-28 2014-05-30 2014-06-16 2014-05-02 0 2014-05-02 ? 0 0004779412 20140502.ifs 2014-05-02 2014-05-03
1439569 1439569 DIVIDEND ADD 518439104 0 0 1 0 .2 00 2014-02-26 2014-02-28 2014-03-17 2014-02-05 0 2014-02-05 ? 0 0004734633 20140205.ifs 2014-02-05 2014-02-06
1327796 1327796 DIVIDEND ADD 518439104 0 0 1 0 .2 00 2013-11-26 2013-11-29 2013-12-16 2013-10-31 0 2013-10-31 ? 0 0004649197 20131031.ifs 2013-10-31 2013-11-01
1265568 1265568 DIVIDEND ADD 518439104 0 0 1 0 .18 00 2013-08-28 2013-08-30 2013-09-16 2013-08-15 0 2013-08-15 ? 0 0004615572 20130815.ifs 2013-08-15 2013-08-16
1178920 1178920 DIVIDEND ADD 518439104 0 0 1 0 .18 00 2013-05-29 2013-05-31 2013-06-17 2013-05-02 0 2013-05-02 ? 0 0004568497 20130502.ifs 2013-05-02 2013-05-03
1108376 1108376 DIVIDEND ADD 518439104 0 0 1 0 .18 00 2013-02-26 2013-02-28 2013-03-15 2013-02-05 0 2013-02-05 ? 0 0004526140 20130205.ifs 2013-02-05 2013-02-06
1003153 1003153 DIVIDEND DELETE 518439104 0 0 1 1 .72 06 2013-11-26 2013-11-30 2012-12-17 2012-11-01 0 2012-11-01 ? 0 0004451669 20121102.ifs 2012-11-02 2012-11-03
1003154 1003154 DIVIDEND ADD 518439104 0 0 1 1 .72 0 06 2012-11-26 2012-11-30 2012-12-17 2012-11-01 0 ? 2012-11-02 0 0004451669 20121102.ifs 2012-11-02 2012-11-03
1004035 1004035 DIVIDEND DELETE 518439104 0 0 1 1 .72 0 06 2012-11-26 2012-11-30 2012-12-17 2012-11-01 0 ? 2012-11-02 0 0004451669 20121102.ifs 2012-11-02 2012-11-03
1004036 1004036 DIVIDEND ADD 518439104 0 0 1 1 .72 0 06 2012-11-28 2012-11-30 2012-12-17 2012-11-01 0 ? 2012-11-02 0 0004451669 20121102.ifs 2012-11-02 2012-11-03
1001521 1001521 DIVIDEND ADD 518439104 0 0 1 1 .72 06 2013-11-26 2013-11-30 2012-12-17 2012-11-01 0 2012-11-01 ? 0 0004451669 20121101.ifs 2012-11-01 2012-11-02
689884 689884 DIVIDEND ADD 518439104 0 0 5 0 1 10 2012-01-23 2012-01-04 2012-01-20 2011-11-03 0 2011-11-03 ? 1 0004267995 20111103.ifs 2011-11-03 2011-11-04
689885 689885 SPLIT ADD 518439104 .5 2012-01-23 10 2011-11-03 ? 20111103.ifs 2011-11-03 2011-11-04
689886 689886 DIVIDEND ADD 518439104 0 0 1 0 1.05 00 2011-11-23 2011-11-28 2011-12-14 2011-11-03 0 2011-11-03 ? 0 0004267994 20111103.ifs 2011-11-03 2011-11-04
352502 352502 DIVIDEND ADD 518439104 0 0 1 0 .75 00 2010-11-24 2010-11-29 2010-12-15 2010-11-09 0 2010-11-09 ? 0 0004086093 20101109.ifs 2010-11-09 2010-11-10
23263 23263 DIVIDEND ADD 518439104 0 0 1 0 .55 00 2009-11-25 2009-11-30 2009-12-16 2009-11-13 0 2009-11-13 ? 0 0003908101 20091113.ifs 2009-11-13 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 = 130528
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