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

the compid is:136289
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
3903167 3903167 DIVIDEND ADD 868168105 0 0 E 0 0 58 ? ? 2019-10-18 2019-09-03 0 2019-09-03 ? 0 0005940118 20190903.ifs 2019-09-03 2019-09-04
3903182 3903182 DIVIDEND ADD 868168105 0 0 E 0 0 58 ? ? 2019-10-18 2019-09-03 0 2019-09-03 ? 0 0005940118 20190903.ifs 2019-09-03 2019-09-04
3765046 3765046 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2019-07-03 2019-07-05 2019-07-19 2019-06-04 0 2019-06-04 ? 0 0005894211 20190604.ifs 2019-06-04 2019-06-05
3765071 3765071 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2019-07-03 2019-07-05 2019-07-19 2019-06-04 0 2019-06-04 ? 0 0005894211 20190604.ifs 2019-06-04 2019-06-05
3613474 3613474 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2019-04-03 2019-04-04 2019-04-18 2019-03-04 0 2019-03-04 ? 0 0005849342 20190304.ifs 2019-03-04 2019-03-05
3613499 3613499 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2019-04-03 2019-04-04 2019-04-18 2019-03-04 0 2019-03-04 ? 0 0005849342 20190304.ifs 2019-03-04 2019-03-05
3402312 3402312 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2019-01-03 2019-01-04 2019-01-18 2018-12-04 0 2018-12-04 ? 0 0005765347 20181204.ifs 2018-12-04 2018-12-05
3402350 3402350 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2019-01-03 2019-01-04 2019-01-18 2018-12-04 0 2018-12-04 ? 0 0005765347 20181204.ifs 2018-12-04 2018-12-05
3269266 3269266 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2018-10-04 2018-10-05 2018-10-19 2018-09-05 0 2018-09-05 ? 0 0005719172 20180905.ifs 2018-09-05 2018-09-06
3269445 3269445 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2018-10-04 2018-10-05 2018-10-19 2018-09-05 0 2018-09-05 ? 0 0005719172 20180905.ifs 2018-09-05 2018-09-06
2981791 2981791 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2018-04-04 2018-04-05 2018-04-19 2018-03-05 0 2018-03-05 ? 0 0005626751 20180305.ifs 2018-03-05 2018-03-06
2982412 2982412 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2018-04-04 2018-04-05 2018-04-19 2018-03-05 0 2018-03-05 ? 0 0005626751 20180305.ifs 2018-03-05 2018-03-06
2802522 2802522 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2018-01-03 2018-01-04 2018-01-19 2017-12-05 0 2017-12-05 ? 0 0005542583 20171205.ifs 2017-12-05 2017-12-06
2805946 2805946 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2018-01-03 2018-01-04 2018-01-19 2017-12-05 0 2017-12-05 ? 0 0005542583 20171205.ifs 2017-12-05 2017-12-06
2666453 2666453 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2017-10-04 2017-10-05 2017-10-19 2017-09-06 0 2017-09-06 ? 0 0005494326 20170906.ifs 2017-09-06 2017-09-07
2584341 2584341 DIVIDEND ADD 868168105 0 0 1 0 .09 00 2017-06-30 2017-07-05 2017-07-19 2017-06-02 0 2017-06-02 ? 0 0005445869 20170602.ifs 2017-06-02 2017-06-03
2507325 2507325 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2017-03-31 2017-04-04 2017-04-18 2017-03-03 0 2017-03-03 ? 0 0005399770 20170303.ifs 2017-03-03 2017-03-04
2361150 2361150 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2017-01-03 2017-01-05 2017-01-19 2016-12-05 0 2016-12-05 ? 0 0005323516 20161205.ifs 2016-12-05 2016-12-06
2288824 2288824 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2016-10-03 2016-10-05 2016-10-19 2016-09-06 0 2016-09-06 ? 0 0005277934 20160906.ifs 2016-09-06 2016-09-07
2214869 2214869 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2016-06-30 2016-07-05 2016-07-19 2016-06-03 0 2016-06-03 ? 0 0005230049 20160603.ifs 2016-06-03 2016-06-04
2130581 2130581 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2016-03-30 2016-04-03 2016-04-17 2016-03-04 0 2016-03-04 ? 0 0005184942 20160304.ifs 2016-03-04 2016-03-05
2023468 2023468 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2015-12-30 2016-01-04 2016-01-18 2015-12-03 0 2015-12-03 ? 0 0005104976 20151203.ifs 2015-12-03 2015-12-04
1959444 1959444 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2015-10-01 2015-10-05 2015-10-19 2015-09-03 0 2015-09-03 ? 0 0005059280 20150903.ifs 2015-09-03 2015-09-04
1881339 1881339 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2015-07-01 2015-07-06 2015-07-20 2015-06-03 0 2015-06-03 ? 0 0005011518 20150603.ifs 2015-06-03 2015-06-04
1809211 1809211 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2015-03-31 2015-04-03 2015-04-17 2015-03-09 0 2015-03-10 ? 0 0004966946 20150310.ifs 2015-03-10 2015-03-11
1698528 1698528 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2014-12-30 2015-01-02 2015-01-16 2014-12-02 0 2014-12-03 ? 0 0004884281 20141203.ifs 2014-12-03 2014-12-04
1622600 1622600 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2014-10-01 2014-10-03 2014-10-17 2014-09-03 0 2014-09-03 ? 0 0004839839 20140903.ifs 2014-09-03 2014-09-04
1541180 1541180 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2014-07-01 2014-07-03 2014-07-18 2014-06-03 0 2014-06-03 ? 0 0004792871 20140603.ifs 2014-06-03 2014-06-04
1469433 1469433 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2014-04-10 2014-04-14 2014-04-28 2014-03-18 0 2014-03-18 ? 0 0004751252 20140318.ifs 2014-03-18 2014-03-19
1360825 1360825 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2013-12-31 2014-01-03 2014-01-17 2013-12-09 0 2013-12-09 ? 0 0004673831 20131209.ifs 2013-12-09 2013-12-10
1296148 1296148 DIVIDEND CHANGE 868168105 0 0 1 0 .02 00 2013-09-25 2013-09-27 2013-10-18 2013-08-26 1 2013-08-26 2013-09-24 0 0004617852 20130925.ifs 2013-09-25 2013-09-26
1296149 1296148 DIVIDEND CHANGE 868168105 Represents $0.02 increase on previously declared 3rd quarter div 0 0 1 0 .02 0 00 2013-09-25 2013-09-27 2013-10-18 2013-08-26 1 2013-08-26 2013-09-25 0 0004617852 20130925.ifs 2013-09-25 2013-09-26
1295573 1295573 DIVIDEND CHANGE 868168105 0 0 1 0 .18 00 2013-09-25 2013-09-27 2013-10-18 2013-08-26 0 2013-08-26 ? 0 0004617852 20130924.ifs 2013-09-24 2013-09-25
1295574 1295573 DIVIDEND CHANGE 868168105 0 0 1 0 .02 00 2013-09-25 2013-09-27 2013-10-18 2013-08-26 1 2013-08-26 2013-09-24 0 0004617852 20130924.ifs 2013-09-24 2013-09-25
1271062 1271062 DIVIDEND ADD 868168105 0 0 1 0 .18 00 2013-09-25 2013-09-27 2013-10-18 2013-08-26 0 2013-08-26 ? 0 0004617852 20130826.ifs 2013-08-26 2013-08-27
1035254 1035254 DIVIDEND ADD 868168105 0 0 1 0 .64 00 2012-12-19 2012-12-21 2012-12-28 2012-12-11 0 2012-12-11 ? 0 0004474907 20121211.ifs 2012-12-11 2012-12-12
934894 934894 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2012-09-26 2012-09-28 2012-10-12 2012-08-17 0 2012-08-17 ? 0 0004416919 20120817.ifs 2012-08-17 2012-08-18
864909 864909 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2012-06-20 2012-06-22 2012-07-06 2012-05-18 0 2012-05-21 ? 0 0004375473 20120521.ifs 2012-05-21 2012-05-22
817241 817241 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2012-04-04 2012-04-09 2012-04-20 2012-03-30 0 2012-03-30 ? 0 0004352883 20120330.ifs 2012-03-30 2012-03-31
693630 693630 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2012-01-04 2012-01-06 2012-01-20 2011-11-11 0 2011-11-11 ? 0 0004269592 20111111.ifs 2011-11-11 2011-11-12
622641 622641 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2011-09-28 2011-09-30 2011-10-14 2011-08-19 0 2011-08-19 ? 0 0004230792 20110819.ifs 2011-08-19 2011-08-20
531076 531076 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2011-06-22 2011-06-24 2011-07-08 2011-05-20 0 2011-05-20 ? 0 0004189791 20110520.ifs 2011-05-20 2011-05-21
474641 474641 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2011-04-06 2011-04-08 2011-04-22 2011-03-18 0 2011-03-18 ? 0 0004160941 20110318.ifs 2011-03-18 2011-03-19
354180 354180 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2010-12-30 2011-01-03 2011-01-18 2010-11-12 0 2010-11-12 ? 0 0004087094 20101112.ifs 2010-11-12 2010-11-13
282075 282075 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2010-09-29 2010-10-01 2010-10-15 2010-08-20 0 2010-08-20 ? 0 0004048573 20100820.ifs 2010-08-20 2010-08-21
197923 197923 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2010-06-23 2010-06-25 2010-07-09 2010-05-21 0 2010-05-24 ? 0 0004008108 20100524.ifs 2010-05-24 2010-05-25
135772 135772 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2010-04-07 2010-04-09 2010-04-23 2010-03-19 0 2010-03-19 ? 0 0003979848 20100319.ifs 2010-03-19 2010-04-07
23175 23175 DIVIDEND ADD 868168105 0 0 1 0 .16 00 2009-12-30 2010-01-04 2010-01-15 2009-11-13 0 2009-11-13 ? 0 0003908296 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 = 136289
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