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

the compid is:135759
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
2011171 2011171 DIVIDEND ADD 500692108 0 0 E 0 0 58 ? ? 2015-04-15 2015-11-18 0 2015-11-18 ? 0 0005094261 20151118.ifs 2015-11-18 2015-11-19
1777152 1777152 DIVIDEND ADD 500692108 0 0 E 0 0 58 ? ? 2015-01-15 2015-01-29 0 2015-01-29 ? 0 0004945565 20150129.ifs 2015-01-29 2015-01-30
1677489 1677489 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no no 2001-07-27 2014-11-06 ? 20141107.ifs 2014-11-07 2014-11-08
1677490 1677489 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no yes 2001-07-27 2014-11-07 ? 20141107.ifs 2014-11-07 2014-11-08
1677491 1677491 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no yes 2001-07-27 2014-11-07 ? 20141107.ifs 2014-11-07 2014-11-08
1677492 1677491 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no no 2001-07-27 2014-11-07 ? 20141107.ifs 2014-11-07 2014-11-08
1676890 1676890 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no yes 2001-07-27 2010-01-12 ? 20141106.ifs 2014-11-06 2014-11-07
1676891 1676890 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no no 2001-07-27 2014-11-06 ? 20141106.ifs 2014-11-06 2014-11-07
1662147 1662147 DIVIDEND ADD 500692108 0 0 E 0 0 58 ? ? 2014-10-15 2014-10-23 0 2014-10-23 ? 0 0004861614 20141023.ifs 2014-10-23 2014-10-24
1443464 1443464 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2014-03-27 2014-03-31 2014-04-15 2014-02-13 0 2014-02-13 ? 0 0004736520 20140213.ifs 2014-02-13 2014-02-14
1323250 1323250 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2013-12-26 2013-12-30 2014-01-15 2013-10-25 0 2013-10-25 ? 0 0004647726 20131025.ifs 2013-10-25 2013-10-26
1261021 1261021 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2013-09-26 2013-09-30 2013-10-15 2013-08-06 0 2013-08-07 ? 0 0004614192 20130807.ifs 2013-08-07 2013-08-08
1168625 1168625 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2013-06-26 2013-06-28 2013-07-15 2013-04-25 0 2013-04-26 ? 0 0004561053 20130426.ifs 2013-04-26 2013-04-27
1098059 1098059 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2013-03-26 2013-03-29 2013-04-15 2013-01-29 0 2013-01-29 ? 0 0004518490 20130129.ifs 2013-01-29 2013-01-30
991903 991903 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2012-12-12 2012-12-14 2012-12-28 2012-10-24 0 2012-10-24 ? 0 0004447764 20121024.ifs 2012-10-24 2012-10-25
938078 938078 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2012-09-26 2012-09-28 2012-10-15 2012-08-23 0 2012-08-23 ? 0 0004418283 20120823.ifs 2012-08-23 2012-08-24
843865 843865 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2012-06-27 2012-06-29 2012-07-16 2012-04-26 0 2012-04-26 ? 0 0004364641 20120426.ifs 2012-04-26 2012-04-27
763266 763266 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2012-03-28 2012-03-30 2012-04-16 2012-01-26 0 2012-01-26 ? 0 0004323424 20120126.ifs 2012-01-26 2012-01-27
628262 628262 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2011-09-28 2011-09-30 2011-10-14 2011-08-30 0 2011-08-30 ? 0 0004233622 20110830.ifs 2011-08-30 2011-08-31
560292 560292 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2011-06-28 2011-06-30 2011-07-15 2011-06-15 0 2011-06-15 ? 0 0004200829 20110615.ifs 2011-06-15 2011-06-16
421372 421372 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2011-03-29 2011-03-31 2011-04-15 2011-01-20 0 2011-01-20 ? 0 0004135965 20110120.ifs 2011-01-20 2011-01-21
378494 378494 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2010-12-29 2010-12-31 2011-01-14 2010-12-15 0 2010-12-15 ? 0 0004105066 20101215.ifs 2010-12-15 2010-12-16
281372 281372 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2010-09-28 2010-09-30 2010-10-15 2010-08-19 0 2010-08-19 ? 0 0004048298 20100819.ifs 2010-08-19 2010-08-20
193401 193401 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2010-06-28 2010-06-30 2010-07-15 2010-05-17 0 2010-05-17 ? 0 0004006403 20100517.ifs 2010-05-17 2010-05-18
116819 116819 DIVIDEND ADD 500692108 0 0 1 0 .06 00 2010-03-29 2010-03-31 2010-04-15 2010-02-25 0 2010-02-25 ? 0 0003968588 20100225.ifs 2010-02-25 2010-04-07
86617 86617 CORPACTION DELETE 500692108 60 S 2009-12-22 2009-12-31 20100112.ifs 2010-01-12 2010-04-07
86619 86619 EQUITY CHANGE 500692108 COM S 0 1972-01-03 2009-12-22 8 yes no yes 2001-07-27 2009-12-31 ? 20100112.ifs 2010-01-12 2010-04-07
86620 86619 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no yes 2001-07-27 2010-01-12 ? 20100112.ifs 2010-01-12 2010-04-07
73418 73418 CORPACTION ADD 500692108 60 S 2009-12-22 2009-12-31 20091231.ifs 2009-12-31 2010-04-07
73419 73419 EQUITY CHANGE 500692108 COM 0 0 1972-01-03 ? 8 yes no yes 2001-07-27 1997-10-29 ? 20091231.ifs 2009-12-31 2010-04-07
73420 73419 EQUITY CHANGE 500692108 COM S 0 1972-01-03 2009-12-22 8 yes no yes 2001-07-27 2009-12-31 ? 20091231.ifs 2009-12-31 2010-04-07
73421 73421 EXCHANGE CHANGE 500692108 60 1986-03-26 2009-12-30 KOSS 0 0 ? 2001-02-02 20091231.ifs 2009-12-31 2010-04-07
73422 73421 EXCHANGE CHANGE 500692108 60 1986-03-26 2009-12-21 KOSS 0 0 ? 2009-12-31 20091231.ifs 2009-12-31 2010-04-07
51483 51483 DIVIDEND ADD 500692108 0 0 1 1 .06 06 2009-12-29 2009-12-31 2010-01-15 2009-12-15 0 2009-12-16 ? 0 0003927569 20091216.ifs 2009-12-16 2010-04-07
21308 21308 DIVIDEND ADD 500692108 0 0 6 0 1 11 2009-12-02 2009-11-20 2009-12-01 2009-10-07 0 2009-11-10 ? 0 0003907482 20091110.ifs 2009-11-10 2010-04-07
21309 21309 SPLIT ADD 500692108 .5 2009-12-02 11 2009-11-10 ? 20091110.ifs 2009-11-10 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 = 135759
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