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 TUP Charts Yahoo TUP Profile
  Run TUP Institutional Summary Yahoo TUP Key Statisics
  J3 Open TUP Pricing Yahoo TUP Pricing
  J3 TUP Insider   J3 TUP Insitutions Yahoo TUP Holders
     
  Open up Sector/Exchange Map Fidelity TUP Lookup
  Open up sec.gov For Market Ca MSN TUP 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
899896104 DELETE RUN
 

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 : 97 72   Update Insititution By Cusips
% Owned by Insititutions: 23.37 % 23.37 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:130595
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
3873843 3873843 DIVIDEND ADD 899896104 0 0 1 0 .27 00 2019-09-17 2019-09-18 2019-10-04 2019-08-07 0 2019-08-07 ? 0 0005929081 20190807.ifs 2019-08-07 2019-08-08
3873846 3873846 DIVIDEND ADD 899896104 0 0 1 0 .27 00 2019-09-17 2019-09-18 2019-10-04 2019-08-07 0 2019-08-07 ? 0 0005929081 20190807.ifs 2019-08-07 2019-08-08
3735004 3735004 DIVIDEND ADD 899896104 0 0 1 0 .27 00 2019-06-18 2019-06-19 2019-07-08 2019-05-22 0 2019-05-22 ? 0 0005885853 20190522.ifs 2019-05-22 2019-05-23
3735005 3735005 DIVIDEND ADD 899896104 0 0 1 0 .27 00 2019-06-18 2019-06-19 2019-07-08 2019-05-22 0 2019-05-22 ? 0 0005885853 20190522.ifs 2019-05-22 2019-05-23
3565769 3565769 DIVIDEND ADD 899896104 0 0 1 0 .27 00 2019-03-19 2019-03-20 2019-04-05 2019-01-30 0 2019-01-30 ? 0 0005829455 20190130.ifs 2019-01-30 2019-01-31
3565787 3565787 DIVIDEND ADD 899896104 0 0 1 0 .27 00 2019-03-19 2019-03-20 2019-04-05 2019-01-30 0 2019-01-30 ? 0 0005829455 20190130.ifs 2019-01-30 2019-01-31
3352434 3352434 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2018-12-18 2018-12-19 2019-01-04 2018-11-01 0 2018-11-01 ? 0 0005748316 20181101.ifs 2018-11-01 2018-11-02
3352535 3352535 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2018-12-18 2018-12-19 2019-01-04 2018-11-01 0 2018-11-01 ? 0 0005748316 20181101.ifs 2018-11-01 2018-11-02
3084861 3084861 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2018-06-19 2018-06-20 2018-07-06 2018-05-09 0 2018-05-09 ? 0 0005659931 20180509.ifs 2018-05-09 2018-05-10
3084862 3084862 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2018-06-19 2018-06-20 2018-07-06 2018-05-09 0 2018-05-09 ? 0 0005659931 20180509.ifs 2018-05-09 2018-05-10
2936095 2936095 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2018-03-19 2018-03-20 2018-04-05 2018-01-31 0 2018-01-31 ? 0 0005605981 20180131.ifs 2018-01-31 2018-02-01
2753381 2753381 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2017-12-19 2017-12-20 2018-01-05 2017-11-02 0 2017-11-02 ? 0 0005526593 20171102.ifs 2017-11-02 2017-11-03
2753538 2753538 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2017-12-19 2017-12-20 2018-01-05 2017-11-02 0 2017-11-02 ? 0 0005526593 20171102.ifs 2017-11-02 2017-11-03
2649290 2649290 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2017-09-19 2017-09-20 2017-10-05 2017-08-14 0 2017-08-14 ? 0 0005482747 20170814.ifs 2017-08-14 2017-08-15
2573049 2573049 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2017-06-16 2017-06-20 2017-07-06 2017-05-24 0 2017-05-24 ? 0 0005437608 20170524.ifs 2017-05-24 2017-05-25
2480568 2480568 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2017-03-16 2017-03-20 2017-04-06 2017-02-01 0 2017-02-01 ? 0 0005382183 20170201.ifs 2017-02-01 2017-02-02
2345634 2345634 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2016-12-16 2016-12-20 2017-01-06 2016-11-18 0 2016-11-18 ? 0 0005312547 20161118.ifs 2016-11-18 2016-11-19
2202135 2202135 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2016-06-16 2016-06-20 2016-07-06 2016-05-24 0 2016-05-24 ? 0 0005221257 20160524.ifs 2016-05-24 2016-05-25
2098990 2098990 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2016-03-16 2016-03-18 2016-04-04 2016-01-27 0 2016-01-27 ? 0 0005162493 20160127.ifs 2016-01-27 2016-01-28
2008721 2008721 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2015-12-16 2015-12-18 2016-01-04 2015-11-13 0 2015-11-13 ? 0 0005093266 20151113.ifs 2015-11-13 2015-11-14
1941219 1941219 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2015-09-16 2015-09-18 2015-10-05 2015-08-14 0 2015-08-14 ? 0 0005047236 20150814.ifs 2015-08-14 2015-08-15
1860229 1860229 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2015-06-16 2015-06-18 2015-07-06 2015-05-08 0 2015-05-08 ? 0 0004999044 20150508.ifs 2015-05-08 2015-05-09
1775983 1775983 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2015-03-16 2015-03-18 2015-04-03 2015-01-28 0 2015-01-28 ? 0 0004944358 20150128.ifs 2015-01-28 2015-01-29
1676977 1676977 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2014-12-16 2014-12-18 2015-01-05 2014-11-06 0 2014-11-06 ? 0 0004871340 20141106.ifs 2014-11-06 2014-11-07
1606794 1606794 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2014-09-16 2014-09-18 2014-10-06 2014-08-14 0 2014-08-14 ? 0 0004828878 20140814.ifs 2014-08-14 2014-08-15
1522046 1522046 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2014-06-16 2014-06-18 2014-07-07 2014-05-09 0 2014-05-09 ? 0 0004781526 20140509.ifs 2014-05-09 2014-05-10
1429274 1429274 DIVIDEND ADD 899896104 0 0 1 0 .68 00 2014-03-17 2014-03-19 2014-04-04 2014-01-29 0 2014-01-29 ? 0 0004726722 20140129.ifs 2014-01-29 2014-01-30
1336943 1336943 DIVIDEND ADD 899896104 0 0 1 0 .62 00 2013-12-16 2013-12-18 2014-01-06 2013-11-07 0 2013-11-07 ? 0 0004656932 20131107.ifs 2013-11-07 2013-11-08
1265387 1265387 DIVIDEND ADD 899896104 0 0 1 0 .62 00 2013-09-16 2013-09-18 2013-10-04 2013-08-15 0 2013-08-15 ? 0 0004615625 20130815.ifs 2013-08-15 2013-08-16
1192638 1192638 DIVIDEND ADD 899896104 0 0 1 0 .62 00 2013-06-17 2013-06-19 2013-07-08 2013-05-24 0 2013-05-24 ? 0 0004573470 20130524.ifs 2013-05-24 2013-05-25
1097931 1097931 DIVIDEND ADD 899896104 0 0 1 0 .62 00 2013-03-18 2013-03-20 2013-04-05 2013-01-29 0 2013-01-29 ? 0 0004517950 20130129.ifs 2013-01-29 2013-01-30
1007505 1007505 DIVIDEND ADD 899896104 0 0 1 0 .36 00 2012-12-17 2012-12-19 2012-12-31 2012-11-08 0 2012-11-08 ? 0 0004457013 20121108.ifs 2012-11-08 2012-11-09
935746 935746 DIVIDEND ADD 899896104 0 0 1 0 .36 00 2012-09-17 2012-09-19 2012-10-05 2012-08-20 0 2012-08-20 ? 0 0004417039 20120820.ifs 2012-08-20 2012-08-21
865650 865650 DIVIDEND ADD 899896104 0 0 1 0 .36 00 2012-06-18 2012-06-20 2012-07-06 2012-05-22 0 2012-05-22 ? 0 0004375756 20120522.ifs 2012-05-22 2012-05-23
769477 769477 DIVIDEND ADD 899896104 0 0 1 0 .36 00 2012-03-16 2012-03-20 2012-04-06 2012-02-01 0 2012-02-01 ? 0 0004327196 20120201.ifs 2012-02-01 2012-02-02
695673 695673 DIVIDEND ADD 899896104 0 0 1 0 .3 00 2011-12-16 2011-12-20 2012-01-04 2011-11-16 0 2011-11-16 ? 0 0004270192 20111116.ifs 2011-11-16 2011-11-17
606505 606505 DIVIDEND ADD 899896104 0 0 1 0 .3 00 2011-09-16 2011-09-20 2011-10-05 2011-08-05 0 2011-08-05 ? 0 0004227976 20110805.ifs 2011-08-05 2011-08-06
524261 524261 DIVIDEND ADD 899896104 0 0 1 0 .3 00 2011-06-16 2011-06-20 2011-07-06 2011-05-11 0 2011-05-11 ? 0 0004187419 20110511.ifs 2011-05-11 2011-05-12
442166 442166 DIVIDEND ADD 899896104 0 0 1 0 .3 00 2011-03-16 2011-03-18 2011-04-06 2011-02-14 0 2011-02-14 ? 0 0004146734 20110214.ifs 2011-02-14 2011-02-15
350069 350069 DIVIDEND ADD 899896104 0 0 1 0 .3 00 2010-12-15 2010-12-17 2011-01-04 2010-11-04 0 2010-11-04 ? 0 0004085313 20101104.ifs 2010-11-04 2010-11-05
279495 279495 DIVIDEND ADD 899896104 0 0 1 0 .25 00 2010-09-15 2010-09-17 2010-10-04 2010-08-16 0 2010-08-16 ? 0 0004047443 20100816.ifs 2010-08-16 2010-08-17
190537 190537 DIVIDEND ADD 899896104 0 0 1 0 .25 00 2010-06-16 2010-06-18 2010-07-06 2010-05-12 0 2010-05-12 ? 0 0004005429 20100512.ifs 2010-05-12 2010-05-13
112407 112407 DIVIDEND ADD 899896104 0 0 1 0 .25 00 2010-03-16 2010-03-18 2010-04-02 2010-02-18 0 2010-02-18 ? 0 0003966127 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 = 130595
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