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

the compid is:130703
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
2958727 2958727 CORPACTION DELETE 247850100 01 M 2018-02-20 737630103 60 2018-02-20 20180221.ifs 2018-02-21 2018-02-22
2958728 2958728 EQUITY CHANGE 247850100 COM M 0 1996-11-12 2018-02-20 4 yes no 737630103 no 1997-01-22 2018-02-20 ? 20180221.ifs 2018-02-21 2018-02-22
2958729 2958728 EQUITY CHANGE 247850100 COM 0 0 1996-11-12 ? 4 yes no no 1997-01-22 2018-02-20 ? 20180221.ifs 2018-02-21 2018-02-22
2958733 2958733 CORPACTION DELETE 247850100 01 M 2018-02-20 737630103 60 2018-02-20 20180221.ifs 2018-02-21 2018-02-22
2958735 2958735 EQUITY CHANGE 247850100 COM M 0 1996-11-12 2018-02-20 4 yes no 737630103 no 1997-01-22 2018-02-20 ? 20180221.ifs 2018-02-21 2018-02-22
2958737 2958736 EQUITY CHANGE 247850100 COM 0 0 1996-11-12 ? 4 yes no no 1997-01-22 2018-02-20 ? 20180221.ifs 2018-02-21 2018-02-22
2959116 2959116 CORPACTION ADD 247850100 01 M 2018-02-21 737630103 60 2018-02-21 20180221.ifs 2018-02-21 2018-02-22
2959118 2959118 EQUITY CHANGE 247850100 COM 0 0 1996-11-12 ? 4 yes no no 1997-01-22 2018-02-20 ? 20180221.ifs 2018-02-21 2018-02-22
2959120 2959119 EQUITY CHANGE 247850100 COM M 0 1996-11-12 2018-02-21 4 yes no 737630103 no 1997-01-22 2018-02-21 ? 20180221.ifs 2018-02-21 2018-02-22
2959143 2959143 CORPACTION ADD 247850100 01 M 2018-02-21 737630103 60 2018-02-21 20180221.ifs 2018-02-21 2018-02-22
2959144 2959144 EQUITY CHANGE 247850100 COM 0 0 1996-11-12 ? 4 yes no no 1997-01-22 2018-02-20 ? 20180221.ifs 2018-02-21 2018-02-22
2959146 2959145 EQUITY CHANGE 247850100 COM M 0 1996-11-12 2018-02-21 4 yes no 737630103 no 1997-01-22 2018-02-21 ? 20180221.ifs 2018-02-21 2018-02-22
2957784 2957784 CORPACTION ADD 247850100 01 M 2018-02-20 737630103 60 ? 20180220.ifs 2018-02-20 2018-02-21
2957786 2957786 EQUITY CHANGE 247850100 COM 0 0 1996-11-12 ? 4 yes no no 1997-01-22 2001-01-19 ? 20180220.ifs 2018-02-20 2018-02-21
2957788 2957787 EQUITY CHANGE 247850100 COM M 0 1996-11-12 2018-02-20 4 yes no 737630103 no 1997-01-22 2018-02-20 ? 20180220.ifs 2018-02-20 2018-02-21
2957807 2957807 CORPACTION ADD 247850100 01 M 2018-02-20 737630103 60 ? 20180220.ifs 2018-02-20 2018-02-21
2957809 2957809 EQUITY CHANGE 247850100 COM 0 0 1996-11-12 ? 4 yes no no 1997-01-22 2001-01-19 ? 20180220.ifs 2018-02-20 2018-02-21
2957810 2957809 EQUITY CHANGE 247850100 COM M 0 1996-11-12 2018-02-20 4 yes no 737630103 no 1997-01-22 2018-02-20 ? 20180220.ifs 2018-02-20 2018-02-21
2957839 2957839 CORPACTION DELETE 247850100 01 M 2018-02-20 737630103 60 ? 20180220.ifs 2018-02-20 2018-02-21
2957843 2957843 CORPACTION ADD 247850100 01 M 2018-02-20 737630103 60 2018-02-20 20180220.ifs 2018-02-20 2018-02-21
2957859 2957859 CORPACTION DELETE 247850100 01 M 2018-02-20 737630103 60 ? 20180220.ifs 2018-02-20 2018-02-21
2957863 2957863 CORPACTION ADD 247850100 01 M 2018-02-20 737630103 60 2018-02-20 20180220.ifs 2018-02-20 2018-02-21
2952291 2952291 DIVIDEND CHANGE 247850100 0 0 1 0 .1 00 2017-12-01 2017-12-04 2017-12-18 2017-10-05 0 2017-10-05 ? 0 0005513191 20180213.ifs 2018-02-13 2018-02-14
2952292 2952292 DIVIDEND CHANGE 247850100 0 0 1 0 .1 00 2017-12-01 2017-12-04 2017-12-18 2017-10-05 0 2017-10-05 ? 0 0005513191 20180213.ifs 2018-02-13 2018-02-14
2952293 2952292 DIVIDEND CHANGE 247850100 0 0 1 0 .1 00 2017-12-01 2017-12-04 2017-12-18 2017-10-05 1 2017-10-05 2018-02-13 0 0005513191 20180213.ifs 2018-02-13 2018-02-14
2952294 2952293 DIVIDEND CHANGE 247850100 0 0 1 0 .1 00 2017-12-01 2017-12-04 2017-12-18 2017-10-05 1 2017-10-05 2018-02-13 0 0005513191 20180213.ifs 2018-02-13 2018-02-14
2716784 2716784 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2017-12-01 2017-12-04 2017-12-18 2017-10-05 0 2017-10-05 ? 0 0005513191 20171005.ifs 2017-10-05 2017-10-06
2592567 2592567 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2017-08-31 2017-09-05 2017-09-19 2017-06-15 0 2017-06-15 ? 0 0005449792 20170615.ifs 2017-06-15 2017-06-16
2549641 2549641 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2017-06-01 2017-06-05 2017-06-19 2017-04-27 0 2017-04-27 ? 0 0005424999 20170427.ifs 2017-04-27 2017-04-28
2491591 2491591 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2017-03-02 2017-03-06 2017-03-20 2017-02-16 0 2017-02-16 ? 0 0005389030 20170216.ifs 2017-02-16 2017-02-17
2299928 2299928 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2016-11-29 2016-12-01 2016-12-15 2016-09-22 0 2016-09-22 ? 0 0005283913 20160922.ifs 2016-09-22 2016-09-23
2223061 2223061 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2016-08-30 2016-09-01 2016-09-15 2016-06-16 0 2016-06-16 ? 0 0005233135 20160616.ifs 2016-06-16 2016-06-17
2181468 2181468 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2016-05-27 2016-06-01 2016-06-15 2016-04-28 0 2016-04-28 ? 0 0005209144 20160428.ifs 2016-04-28 2016-04-29
2115094 2115094 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2016-03-03 2016-03-07 2016-03-21 2016-02-18 0 2016-02-18 ? 0 0005173505 20160218.ifs 2016-02-18 2016-02-19
1889836 1889836 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2015-08-28 2015-09-01 2015-09-15 2015-06-18 0 2015-06-18 ? 0 0005014968 20150618.ifs 2015-06-18 2015-06-19
1846221 1846221 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2015-05-28 2015-06-01 2015-06-15 2015-04-23 0 2015-04-23 ? 0 0004988563 20150423.ifs 2015-04-23 2015-04-24
1638901 1638901 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2014-11-26 2014-12-01 2014-12-15 2014-09-25 0 2014-09-25 ? 0 0004847482 20140925.ifs 2014-09-25 2014-09-26
1554015 1554015 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2014-08-28 2014-09-02 2014-09-16 2014-06-19 0 2014-06-19 ? 0 0004798279 20140619.ifs 2014-06-19 2014-06-20
1501663 1501663 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2014-05-29 2014-06-02 2014-06-16 2014-04-24 0 2014-04-24 ? 0 0004770700 20140424.ifs 2014-04-24 2014-04-25
1447082 1447082 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2014-02-27 2014-03-03 2014-03-17 2014-02-20 0 2014-02-20 ? 0 0004738048 20140220.ifs 2014-02-20 2014-02-21
1291708 1291708 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2013-11-27 2013-12-02 2013-12-16 2013-09-19 0 2013-09-19 ? 0 0004630419 20130919.ifs 2013-09-19 2013-09-20
1213830 1213830 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2013-08-29 2013-09-03 2013-09-17 2013-06-20 0 2013-06-20 ? 0 0004585817 20130620.ifs 2013-06-20 2013-06-21
1167433 1167433 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2013-05-30 2013-06-03 2013-06-17 2013-04-25 0 2013-04-25 ? 0 0004560562 20130425.ifs 2013-04-25 2013-04-26
1115758 1115758 DIVIDEND ADD 247850100 0 0 1 0 .1 00 2013-02-28 2013-03-04 2013-03-15 2013-02-21 0 2013-02-21 ? 0 0004529631 20130221.ifs 2013-02-21 2013-02-22
961000 961000 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2012-11-29 2012-12-03 2012-12-17 2012-09-20 0 2012-09-20 ? 0 0004431173 20120920.ifs 2012-09-20 2012-09-21
891264 891264 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2012-08-30 2012-09-04 2012-09-18 2012-06-21 0 2012-06-21 ? 0 0004389715 20120621.ifs 2012-06-21 2012-06-22
843992 843992 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2012-05-30 2012-06-01 2012-06-15 2012-04-26 0 2012-04-26 ? 0 0004364471 20120426.ifs 2012-04-26 2012-04-27
780759 780759 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2012-02-28 2012-03-01 2012-03-15 2011-02-16 0 2012-02-16 ? 0 0004333317 20120216.ifs 2012-02-16 2012-02-17
644440 644440 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2011-11-29 2011-12-01 2011-12-15 2011-09-15 0 2011-09-15 ? 0 0004242344 20110915.ifs 2011-09-15 2011-09-16
562117 562117 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2011-08-30 2011-09-01 2011-09-15 2011-06-16 0 2011-06-16 ? 0 0004201287 20110616.ifs 2011-06-16 2011-06-17
511030 511030 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2011-05-27 2011-06-01 2011-06-15 2011-04-28 0 2011-04-28 ? 0 0004178737 20110428.ifs 2011-04-28 2011-04-29
444894 444894 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2011-02-25 2011-03-01 2011-03-15 2011-02-17 0 2011-02-17 ? 0 0004147619 20110217.ifs 2011-02-17 2011-02-18
308819 308819 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2010-11-29 2010-12-01 2010-12-15 2010-09-16 0 2010-09-16 ? 0 0004060239 20100916.ifs 2010-09-16 2010-09-17
221477 221477 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2010-08-30 2010-09-01 2010-09-15 2010-06-17 0 2010-06-17 ? 0 0004019020 20100617.ifs 2010-06-17 2010-06-18
166072 166072 DIVIDEND ADD 247850100 0 0 1 4 .075 00 2010-05-27 2010-06-01 2010-06-15 2010-04-22 0 ? 2010-04-26 0 0003995160 20100426.ifs 2010-04-26 2010-04-27
112521 112521 DIVIDEND ADD 247850100 0 0 1 0 .075 00 2010-02-25 2010-03-01 2010-03-15 2010-02-18 0 2010-02-18 ? 0 0003966126 20100218.ifs 2010-02-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 = 130703
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