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 JFTTL Charts Yahoo JFTTL Profile
  Run JFTTL Institutional Summary Yahoo JFTTL Key Statisics
  J3 Open JFTTL Pricing Yahoo JFTTL Pricing
  J3 JFTTL Insider   J3 JFTTL Insitutions Yahoo JFTTL Holders
     
  Open up Sector/Exchange Map Fidelity JFTTL Lookup
  Open up sec.gov For Market Ca MSN JFTTL 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
46625HHA1 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:159783
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
5098042 5098042 DIVIDEND ADD 46625HHA1 0 0 1 0 16.387 00 ? 2022-09-30 2022-10-30 2022-09-15 0 2022-09-15 ? 0 0006583872 20220915.ifs 2022-09-15 2022-09-16
5033340 5033340 DIVIDEND ADD 46625HHA1 0 0 1 0 11.903 00 ? 2022-06-30 2022-07-30 2022-06-15 0 2022-06-15 ? 0 0006538566 20220615.ifs 2022-06-15 2022-06-16
4888582 4888582 DIVIDEND ADD 46625HHA1 0 0 1 0 9.396 00 ? 2021-12-31 2022-01-31 2021-12-15 0 2021-12-15 ? 0 0006424648 20211215.ifs 2021-12-15 2021-12-16
4802288 4802288 DIVIDEND ADD 46625HHA1 0 0 1 0 9.096 00 ? 2021-09-30 2021-10-30 2021-09-15 0 2021-09-15 ? 0 0006367708 20210915.ifs 2021-09-15 2021-09-16
4729878 4729878 DIVIDEND ADD 46625HHA1 0 0 1 0 9.24 00 ? 2021-06-30 2021-07-30 2021-06-15 0 2021-06-15 ? 0 0006322323 20210615.ifs 2021-06-15 2021-06-16
4462373 4462373 DIVIDEND ADD 46625HHA1 0 0 1 0 9.553 00 ? 2020-09-30 2020-10-30 2020-09-15 0 2020-09-15 ? 0 0006159000 20200915.ifs 2020-09-15 2020-09-16
4391970 4391970 DIVIDEND ADD 46625HHA1 0 0 1 0 10.693 00 ? 2020-06-30 2020-07-30 2020-06-15 0 2020-06-15 ? 0 0006112682 20200615.ifs 2020-06-15 2020-06-16
4240011 4240011 DIVIDEND ADD 46625HHA1 0 0 1 0 13.244 00 ? 2020-03-31 2020-04-30 2020-03-13 0 2020-03-13 ? 0 0006068766 20200313.ifs 2020-03-13 2020-03-14
4240012 4240012 DIVIDEND ADD 46625HHA1 0 0 1 0 13.244 00 ? 2020-03-31 2020-04-30 2020-03-13 0 2020-03-13 ? 0 0006068766 20200313.ifs 2020-03-13 2020-03-14
3923200 3923200 DIVIDEND ADD 46625HHA1 0 0 1 0 14.658 00 ? 2019-09-30 2019-10-30 2019-09-13 0 2019-09-13 ? 2 0005945600 20190913.ifs 2019-09-13 2019-09-14
3923201 3923201 DIVIDEND ADD 46625HHA1 0 0 1 0 14.658 00 ? 2019-09-30 2019-10-30 2019-09-13 0 2019-09-13 ? 2 0005945600 20190913.ifs 2019-09-13 2019-09-14
3923202 3923202 DIVIDEND ADD 46625HHA1 0 0 1 0 15.551 00 ? 2019-04-01 2019-04-30 2019-03-15 0 2019-09-13 ? 1 0005945599 20190913.ifs 2019-09-13 2019-09-14
3923203 3923203 DIVIDEND ADD 46625HHA1 0 0 1 0 15.551 00 ? 2019-04-01 2019-04-30 2019-03-15 0 2019-09-13 ? 1 0005945599 20190913.ifs 2019-09-13 2019-09-14
3923204 3923204 DIVIDEND ADD 46625HHA1 0 0 1 0 14.845 00 ? 2018-10-01 2018-10-30 2018-09-14 0 2019-09-13 ? 0 0005945598 20190913.ifs 2019-09-13 2019-09-14
3923205 3923205 DIVIDEND ADD 46625HHA1 0 0 1 0 14.845 00 ? 2018-10-01 2018-10-30 2018-09-14 0 2019-09-13 ? 0 0005945598 20190913.ifs 2019-09-13 2019-09-14
2993330 2993330 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2018-04-02 2018-04-30 2018-03-15 0 2018-03-15 ? 0 0005629534 20180315.ifs 2018-03-15 2018-03-16
2993444 2993444 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2018-04-02 2018-04-30 2018-03-15 0 2018-03-15 ? 0 0005629534 20180315.ifs 2018-03-15 2018-03-16
2673845 2673845 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2017-10-02 2017-10-30 2017-09-15 0 2017-09-15 ? 0 0005498059 20170915.ifs 2017-09-15 2017-09-16
2674510 2674510 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2017-10-02 2017-10-30 2017-09-15 0 2017-09-15 ? 0 0005498059 20170915.ifs 2017-09-15 2017-09-16
2512931 2512931 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2017-03-31 2017-05-01 2017-03-15 0 2017-03-15 ? 0 0005402613 20170315.ifs 2017-03-15 2017-03-16
2294512 2294512 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2016-09-30 2016-10-30 2016-09-15 0 2016-09-15 ? 0 0005280769 20160915.ifs 2016-09-15 2016-09-16
2135544 2135544 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2016-03-31 2016-04-30 2016-03-15 0 2016-03-15 ? 0 0005187093 20160315.ifs 2016-03-15 2016-03-16
1965092 1965092 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2015-09-30 2015-10-30 2015-09-14 0 2015-09-14 ? 0 0005062086 20150914.ifs 2015-09-14 2015-09-15
1813357 1813357 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2015-03-31 2015-04-30 2015-03-13 0 2015-03-16 ? 0 0004968664 20150316.ifs 2015-03-16 2015-03-17
1629247 1629247 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2014-09-30 2014-10-30 2014-09-12 0 2014-09-12 ? 0 0004842573 20140912.ifs 2014-09-12 2014-09-13
1550820 1550820 CORPACTION ADD 46625HHA1 66 D 2014-06-16 2014-06-17 20140617.ifs 2014-06-17 2014-06-18
1467024 1467024 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2014-03-31 2014-04-30 2014-03-14 0 2014-03-14 ? 0 0004750304 20140314.ifs 2014-03-14 2014-03-15
1428985 1428985 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 6 2009-09-16 ? 0 no no no ? 2012-08-23 ? 20140129.ifs 2014-01-29 2014-01-30
1428986 1428985 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 1 2009-09-16 ? 0 no no no ? 2014-01-29 ? 20140129.ifs 2014-01-29 2014-01-30
1428987 1428987 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 1 2009-09-16 ? 0 no no no ? 2014-01-29 ? 20140129.ifs 2014-01-29 2014-01-30
1428988 1428987 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 6 2009-09-16 ? 0 no no no ? 2014-01-29 ? 20140129.ifs 2014-01-29 2014-01-30
1287243 1287243 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2013-09-30 2013-10-30 2013-09-13 0 2013-09-13 ? 0 0004629277 20130913.ifs 2013-09-13 2013-09-14
1134152 1134152 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2013-04-01 2013-04-30 2013-03-15 0 2013-03-15 ? 0 0004541668 20130315.ifs 2013-03-15 2013-03-16
956758 956758 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2012-09-30 2012-10-30 2012-09-14 0 2012-09-14 ? 0 0004429455 20120914.ifs 2012-09-14 2012-09-15
937607 937607 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 1 2009-09-16 ? 0 no no no ? 2011-11-10 ? 20120823.ifs 2012-08-23 2012-08-24
937608 937607 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 6 2009-09-16 ? 0 no no no ? 2012-08-23 ? 20120823.ifs 2012-08-23 2012-08-24
833500 833500 EXCHANGE CHANGE 46625HHA1 66 2011-11-03 2012-04-09 JFTTP 0 1 ? 2011-11-10 20120411.ifs 2012-04-11 2012-04-12
833501 833500 EXCHANGE CHANGE 46625HHA1 66 2011-11-03 2012-04-09 JFTTL 0 1 ? 2012-04-11 20120411.ifs 2012-04-11 2012-04-12
833502 833502 CORPACTION ADD 46625HHA1 66 # 2012-04-11 46625HHA1 66 2012-04-11 20120411.ifs 2012-04-11 2012-04-12
833503 833503 CORPACTIONAUX ADD 46625HHA1 66 2012-04-11 JFTTP JPMORGAN CHASE & CO DEP SHS REPSTG JFTTL JPMORGAN CHASE & CO DEP SHS REPSTG ? 2012-04-11 20120411.ifs 2012-04-11 2012-04-12
833504 833504 EXCHANGE CHANGE 46625HHA1 66 2011-11-03 2012-04-09 JFTTL 0 1 ? 2012-04-11 20120411.ifs 2012-04-11 2012-04-12
833505 833504 EXCHANGE CHANGE 46625HHA1 66 2011-11-03 2012-04-09 JFTTL 0 1 ? 2012-04-11 20120411.ifs 2012-04-11 2012-04-12
803178 803178 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2012-03-31 2012-04-30 2012-03-15 0 2012-03-15 ? 0 0004345556 20120315.ifs 2012-03-15 2012-03-16
692839 692839 EXCHANGE ADD 46625HHA1 66 2011-11-03 2011-11-09 JFTTP 0 1 ? 2011-11-10 20111110.ifs 2011-11-10 2011-11-11
692840 692840 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I N 1 2009-09-16 ? 0 no no no ? ? ? 20111110.ifs 2011-11-10 2011-11-11
692841 692840 EQUITY CHANGE 46625HHA1 DEP SHS REPSTG 1/10TH PFD SER I 0 1 2009-09-16 ? 0 no no no ? 2011-11-10 ? 20111110.ifs 2011-11-10 2011-11-11
644222 644222 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2011-09-30 2011-10-30 2011-09-15 0 2011-09-15 ? 0 0004242316 20110915.ifs 2011-09-15 2011-09-16
472055 472055 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2011-03-31 2011-04-30 2011-03-15 0 2011-03-15 ? 0 0004159301 20110315.ifs 2011-03-15 2011-03-16
307524 307524 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2010-09-30 2010-10-30 2010-09-15 0 2010-09-15 ? 0 0004059855 20100915.ifs 2010-09-15 2010-09-16
133369 133369 DIVIDEND ADD 46625HHA1 0 0 1 0 39.5 00 ? 2010-03-31 2010-04-30 2010-03-16 0 2010-03-16 ? 0 0003978237 20100316.ifs 2010-03-16 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 = 159783
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