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

the compid is:159967
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
5481201 5481201 CORPACTION ADD 21988T207 66 D 2024-01-17 ? 20240117.ifs 2024-01-17 2024-01-18
5481202 5481202 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 0 0 2007-02-16 ? 2 no no no 2007-02-16 2020-06-25 ? 20240117.ifs 2024-01-17 2024-01-18
5481203 5481202 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2024-01-17 2 no no no 2007-02-16 2024-01-17 ? 20240117.ifs 2024-01-17 2024-01-18
4399994 4399994 CORPACTION DELETE 21988T207 01 D 2020-05-19 2020-05-20 20200625.ifs 2020-06-25 2020-06-26
4399995 4399995 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-06-18 2 no no no 2007-02-16 2020-06-18 ? 20200625.ifs 2020-06-25 2020-06-26
4399996 4399995 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 0 0 2007-02-16 ? 2 no no no 2007-02-16 2020-06-25 ? 20200625.ifs 2020-06-25 2020-06-26
4393933 4393933 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-06-03 2 no no no 2007-02-16 2020-06-03 ? 20200618.ifs 2020-06-18 2020-06-19
4393934 4393933 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-06-18 2 no no no 2007-02-16 2020-06-18 ? 20200618.ifs 2020-06-18 2020-06-19
4393935 4393935 CORPACTION ADD 21988T207 01 X 2020-06-18 21988T207 66 ? 20200618.ifs 2020-06-18 2020-06-19
4393936 4393936 EXCHANGE ADD 21988T207 66 2020-06-18 ? CBTRP 0 0 2020-06-18 ? 20200618.ifs 2020-06-18 2020-06-19
4385348 4385348 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200603.ifs 2020-06-03 2020-06-04
4385349 4385348 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-06-03 2 no no no 2007-02-16 2020-06-03 ? 20200603.ifs 2020-06-03 2020-06-04
4385845 4385845 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200603.ifs 2020-06-03 2020-06-04
4385846 4385845 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-06-03 2 no no no 2007-02-16 2020-06-03 ? 20200603.ifs 2020-06-03 2020-06-04
4341691 4341691 CORPACTION ADD 21988T207 01 S 2020-05-20 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341692 4341692 CORPACTION ADD 21988T207 01 S 2020-05-20 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341693 4341693 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 0 0 2007-02-16 ? 2 no no no 2007-02-16 ? ? 20200520.ifs 2020-05-20 2020-05-21
4341694 4341693 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-20 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341695 4341695 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 0 0 2007-02-16 ? 2 no no no 2007-02-16 ? ? 20200520.ifs 2020-05-20 2020-05-21
4341697 4341696 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-20 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341702 4341702 CORPACTION DELETE 21988T207 01 S 2020-05-20 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341704 4341704 CORPACTION ADD 21988T207 01 S 2020-05-19 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341705 4341705 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-20 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341706 4341706 CORPACTION DELETE 21988T207 01 S 2020-05-20 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341707 4341706 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341708 4341708 CORPACTION ADD 21988T207 01 S 2020-05-19 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341710 4341710 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-20 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341712 4341711 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341911 4341911 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341913 4341912 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341950 4341950 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 S 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4341952 4341951 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 D 0 2007-02-16 2020-05-19 2 no no no 2007-02-16 2020-05-20 ? 20200520.ifs 2020-05-20 2020-05-21
4342134 4342133 EXCHANGE ADD 21988T207 01 S 2020-05-19 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4342135 4342134 EXCHANGE ADD 21988T207 01 D 2020-05-19 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4342216 4342215 EXCHANGE ADD 21988T207 01 S 2020-05-19 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4342218 4342217 EXCHANGE ADD 21988T207 01 D 2020-05-19 2020-05-20 20200520.ifs 2020-05-20 2020-05-21
4341252 4341252 DIVIDEND DELETE 21988T207 0 0 1 0 .875 00 2020-08-28 2020-08-31 2020-09-01 2020-01-21 0 2020-01-21 ? 1 0006043877 20200519.ifs 2020-05-19 2020-05-20
4341269 4341269 DIVIDEND DELETE 21988T207 0 0 1 0 .875 00 2020-08-28 2020-08-31 2020-09-01 2020-01-21 0 2020-01-21 ? 1 0006043877 20200519.ifs 2020-05-19 2020-05-20
4173843 4173843 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2020-08-28 2020-08-31 2020-09-01 2020-01-21 0 2020-01-21 ? 1 0006043877 20200121.ifs 2020-01-21 2020-01-22
4173845 4173845 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2020-02-27 2020-02-28 2020-03-01 2020-01-21 0 2020-01-21 ? 0 0006043873 20200121.ifs 2020-01-21 2020-01-22
4173848 4173848 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2020-08-28 2020-08-31 2020-09-01 2020-01-21 0 2020-01-21 ? 1 0006043877 20200121.ifs 2020-01-21 2020-01-22
4173850 4173850 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2020-02-27 2020-02-28 2020-03-01 2020-01-21 0 2020-01-21 ? 0 0006043873 20200121.ifs 2020-01-21 2020-01-22
3547408 3547408 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2019-08-29 2019-08-30 2019-09-01 2019-01-10 0 2019-01-10 ? 1 0005825321 20190110.ifs 2019-01-10 2019-01-11
3547410 3547410 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2019-02-27 2019-02-28 2019-03-01 2019-01-10 0 2019-01-10 ? 0 0005825320 20190110.ifs 2019-01-10 2019-01-11
3547777 3547777 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2019-08-29 2019-08-30 2019-09-01 2019-01-10 0 2019-01-10 ? 1 0005825321 20190110.ifs 2019-01-10 2019-01-11
3547778 3547778 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2019-02-27 2019-02-28 2019-03-01 2019-01-10 0 2019-01-10 ? 0 0005825320 20190110.ifs 2019-01-10 2019-01-11
2915967 2915967 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2018-08-30 2018-08-31 2018-09-04 2018-01-09 0 2018-01-09 ? 1 0005601209 20180109.ifs 2018-01-09 2018-01-10
2915969 2915969 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2018-02-27 2018-02-28 2018-03-01 2018-01-09 0 2018-01-09 ? 0 0005601208 20180109.ifs 2018-01-09 2018-01-10
2915980 2915980 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2018-08-30 2018-08-31 2018-09-04 2018-01-09 0 2018-01-09 ? 1 0005601209 20180109.ifs 2018-01-09 2018-01-10
2915982 2915982 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2018-02-27 2018-02-28 2018-03-01 2018-01-09 0 2018-01-09 ? 0 0005601208 20180109.ifs 2018-01-09 2018-01-10
2449820 2449820 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 0 0 2007-02-16 ? 0 no no no 2007-02-16 ? ? 20170124.ifs 2017-01-24 2017-01-25
2449821 2449820 EQUITY CHANGE 21988T207 JC PENNEY DEB BKD 2007 1 CTF CL A-1 0 0 2007-02-16 ? 2 no no no 2007-02-16 ? ? 20170124.ifs 2017-01-24 2017-01-25
2423796 2423796 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2017-08-29 2017-08-31 2017-09-01 2017-01-09 0 2017-01-10 ? 0 0005374095 20170110.ifs 2017-01-10 2017-01-11
2303190 2303190 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2017-02-24 2017-02-28 2017-03-01 2016-09-27 0 2016-09-27 ? 0 0005285860 20160927.ifs 2016-09-27 2016-09-28
2268087 2268087 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2016-08-29 2016-08-31 2016-09-01 2016-08-08 0 2016-08-08 ? 0 0005264354 20160808.ifs 2016-08-08 2016-08-09
2110811 2110811 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2016-02-25 2016-02-29 2016-03-01 2016-02-08 0 2016-02-08 ? 0 0005171334 20160208.ifs 2016-02-08 2016-02-09
1821821 1821821 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2015-08-27 2015-08-31 2015-09-01 2015-03-25 0 2015-03-26 ? 0 0004973734 20150326.ifs 2015-03-26 2015-03-27
1786551 1786551 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2015-02-25 2015-02-27 2015-03-02 2015-02-04 0 2015-02-04 ? 0 0004952801 20150204.ifs 2015-02-04 2015-02-05
1526103 1526103 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2014-08-27 2014-08-29 2014-09-01 2014-05-19 0 2014-05-19 ? 0 0004783209 20140519.ifs 2014-05-19 2014-05-20
1441846 1441846 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2014-02-26 2014-02-28 2014-03-03 2014-02-07 0 2014-02-10 ? 0 0004735503 20140210.ifs 2014-02-10 2014-02-11
1248844 1248844 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2013-08-28 2013-08-30 2013-09-03 2013-07-29 0 2013-07-29 ? 0 0004605038 20130729.ifs 2013-07-29 2013-07-30
1110903 1110903 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2013-02-26 2013-02-28 2013-03-01 2013-02-11 0 2013-02-11 ? 0 0004527401 20130211.ifs 2013-02-11 2013-02-12
1080992 1080992 DIVIDEND DELETE 21988T207 0 1 1 0 .875 14 2012-02-27 2012-02-29 2012-03-01 2013-01-03 0 2013-01-03 ? 0 0004315135 20130104.ifs 2013-01-04 2013-01-05
1077982 1077982 DIVIDEND ADD 21988T207 0 1 1 0 .875 14 2012-02-27 2012-02-29 2012-03-01 2013-01-03 0 2013-01-03 ? 0 0004315135 20130103.ifs 2013-01-03 2013-01-04
926120 926120 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2012-08-29 2012-08-31 2012-09-01 2012-08-03 0 2012-08-03 ? 0 0004413876 20120803.ifs 2012-08-03 2012-08-04
748422 748422 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2012-02-27 2012-02-29 2012-03-01 2012-01-03 0 2012-01-03 ? 0 0004315135 20120103.ifs 2012-01-03 2012-01-04
612536 612536 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2011-08-29 2011-08-31 2011-09-01 2011-08-10 0 2011-08-10 ? 0 0004228967 20110810.ifs 2011-08-10 2011-08-11
443450 443450 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2011-02-24 2011-02-28 2011-03-01 2011-02-15 0 2011-02-15 ? 0 0004147199 20110215.ifs 2011-02-15 2011-02-16
277331 277331 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2010-08-27 2010-08-31 2010-09-01 2010-08-11 0 2010-08-11 ? 0 0004046664 20100811.ifs 2010-08-11 2010-08-12
111842 111842 DIVIDEND ADD 21988T207 0 0 1 0 .875 00 2010-02-24 2010-02-26 2010-03-01 2010-02-17 0 2010-02-17 ? 0 0003966031 20100217.ifs 2010-02-17 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 = 159967
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