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 DFT.PA Charts Yahoo DFT.PA Profile
  Run DFT.PA Institutional Summary Yahoo DFT.PA Key Statisics
  J3 Open DFT.PA Pricing Yahoo DFT.PA Pricing
  J3 DFT.PA Insider   J3 DFT.PA Insitutions Yahoo DFT.PA Holders
     
  Open up Sector/Exchange Map Fidelity DFT.PA Lookup
  Open up sec.gov For Market Ca MSN DFT.PA 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
26613Q205 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:159589
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
2217261 2217261 CORPACTION ADD 26613Q205 01 C 2016-06-09 ? 20160609.ifs 2016-06-09 2016-06-10
2217262 2217262 EQUITY CHANGE 26613Q205 CUMULATIVE RED PERP PFD SER A 7.875% 0 1 2010-10-15 ? 0 no no no ? 2010-10-15 ? 20160609.ifs 2016-06-09 2016-06-10
2217263 2217262 EQUITY CHANGE 26613Q205 CUMULATIVE RED PERP PFD SER A 7.875% C 1 2010-10-15 2016-06-09 0 no no no ? 2016-06-09 ? 20160609.ifs 2016-06-09 2016-06-10
2194214 2194214 DIVIDEND ADD 26613Q205 0 0 C 0 25 12 ? ? 2016-06-09 2016-05-10 0 ? 2016-05-11 0 20160511.ifs 2016-05-11 2016-05-12
2194254 2194254 DIVIDEND ADD 26613Q205 0 0 1 6 0 08 ? ? 2016-06-09 2016-05-10 0 ? 2016-05-11 0 0005218076 20160511.ifs 2016-05-11 2016-05-12
2023862 2023862 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2015-12-28 2015-12-30 2016-01-15 2015-12-03 0 2015-12-03 ? 0 0005105405 20151203.ifs 2015-12-03 2015-12-04
1924357 1924357 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2015-09-30 2015-10-02 2015-10-15 2015-07-28 0 2015-07-28 ? 0 0005035913 20150728.ifs 2015-07-28 2015-07-29
1872187 1872187 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2015-06-30 2015-07-02 2015-07-15 2015-05-28 0 2015-05-28 ? 0 0005003817 20150528.ifs 2015-05-28 2015-05-29
1795330 1795330 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2015-03-31 2015-04-02 2015-04-15 2015-02-25 0 2015-02-25 ? 0 0004957638 20150225.ifs 2015-02-25 2015-02-26
1697473 1697473 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2014-12-26 2014-12-30 2015-01-15 2014-12-02 0 2014-12-02 ? 0 0004883841 20141202.ifs 2014-12-02 2014-12-03
1635663 1635663 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2014-10-01 2014-10-03 2014-10-15 2014-09-22 0 2014-09-22 ? 0 0004845836 20140922.ifs 2014-09-22 2014-09-23
1528796 1528796 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2014-07-01 2014-07-03 2014-07-15 2014-05-22 0 2014-05-22 ? 0 0004784515 20140522.ifs 2014-05-22 2014-05-23
1465061 1465061 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2014-04-02 2014-04-04 2014-04-15 2014-03-12 0 2014-03-12 ? 0 0004749832 20140312.ifs 2014-03-12 2014-03-13
1361020 1361020 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2013-12-24 2013-12-27 2014-01-15 2013-12-09 0 2013-12-09 ? 0 0004674135 20131209.ifs 2013-12-09 2013-12-10
1294377 1294377 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2013-10-02 2013-10-04 2013-10-15 2013-09-23 0 2013-09-23 ? 0 0004632435 20130923.ifs 2013-09-23 2013-09-24
1202788 1202788 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2013-07-02 2013-07-05 2013-07-15 2013-06-03 0 2013-06-03 ? 0 0004578044 20130603.ifs 2013-06-03 2013-06-04
1128171 1128171 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2013-04-03 2013-04-05 2013-04-15 2013-03-04 0 2013-03-04 ? 0 0004538065 20130304.ifs 2013-03-04 2013-03-05
1018496 1018496 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2012-12-26 2012-12-28 2013-01-15 2012-11-29 0 2012-11-29 ? 0 0004462114 20121129.ifs 2012-11-29 2012-11-30
958734 958734 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2012-10-03 2012-10-05 2012-10-15 2012-09-18 0 2012-09-18 ? 0 0004430066 20120918.ifs 2012-09-18 2012-09-19
870305 870305 DIVIDEND CHANGE 26613Q205 0 0 1 0 .492188 00 2012-07-03 2012-07-06 2012-07-16 2012-05-30 0 2012-05-30 ? 0 0004377497 20120531.ifs 2012-05-31 2012-06-01
870306 870305 DIVIDEND CHANGE 26613Q205 0 0 1 0 .492188 00 2012-07-03 2012-07-06 2012-07-16 2012-05-30 0 2012-05-30 ? 0 0004377497 20120531.ifs 2012-05-31 2012-06-01
867636 867636 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2012-07-03 2012-07-06 2012-07-16 2012-05-30 0 2012-05-30 ? 0 0004377497 20120530.ifs 2012-05-30 2012-05-31
797308 797308 DIVIDEND DELETE 26613Q205 0 0 1 0 .492188 00 2012-04-03 2012-04-06 2012-04-16 2012-02-24 0 2012-02-24 ? 0 0004335259 20120305.ifs 2012-03-05 2012-03-06
797309 797309 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2012-04-03 2012-04-05 2012-04-16 2012-02-24 1 2012-02-24 2012-03-05 0 0004335259 20120305.ifs 2012-03-05 2012-03-06
785019 785019 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2012-04-03 2012-04-06 2012-04-16 2012-02-24 0 2012-02-24 ? 0 0004335259 20120224.ifs 2012-02-24 2012-02-25
712661 712661 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2011-12-22 2011-12-27 2012-01-17 2011-12-05 0 2011-12-05 ? 0 0004281102 20111205.ifs 2011-12-05 2011-12-06
644430 644430 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2011-10-05 2011-10-07 2011-10-17 2011-09-15 0 2011-09-15 ? 0 0004242649 20110915.ifs 2011-09-15 2011-09-16
611958 611958 DIVIDEND CHANGE 26613Q205 0 0 1 0 .492188 00 2011-06-24 2011-06-28 2011-07-15 2011-05-31 0 2011-05-31 2011-08-10 0 0004192786 20110810.ifs 2011-08-10 2011-08-11
611959 611958 DIVIDEND CHANGE 26613Q205 0 0 1 0 .492188 00 2011-06-24 2011-06-28 2011-07-15 2011-05-31 0 2011-05-31 2011-08-10 0 0004192786 20110810.ifs 2011-08-10 2011-08-11
540471 540471 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2011-06-24 2011-06-28 2011-07-15 2011-05-31 0 2011-05-31 ? 0 0004192786 20110531.ifs 2011-05-31 2011-06-01
451363 451363 DIVIDEND ADD 26613Q205 0 0 1 0 .492188 00 2011-03-25 2011-03-29 2011-04-15 2011-02-24 0 2011-02-24 ? 0 0004149753 20110224.ifs 2011-02-24 2011-02-25
375426 375426 DIVIDEND ADD 26613Q205 0 0 1 4 .503125 00 2010-12-23 2010-12-28 2011-01-17 2010-12-09 0 2010-12-09 ? 0 0004100993 20101209.ifs 2010-12-09 2010-12-10
338034 338034 CORPACTION ADD 26613Q205 66 X 2010-10-20 26613Q205 01 ? 20101020.ifs 2010-10-20 2010-10-21
338035 338035 EXCHANGE ADD 26613Q205 01 2010-10-20 2010-10-20 DFT_PA 0 1 2010-10-20 ? 20101020.ifs 2010-10-20 2010-10-21
335649 335649 EQUITY ADD 26613Q205 NEW ISSUE 0 0 2010-10-15 ? 0 no no no ? ? ? 20101015.ifs 2010-10-15 2010-10-16
335650 335650 EQUITY CHANGE 26613Q205 NEW ISSUE 0 0 2010-10-15 ? 0 no no no ? ? ? 20101015.ifs 2010-10-15 2010-10-16
335651 335650 EQUITY CHANGE 26613Q205 CUMULATIVE RED PERP PFD SER A 7.875% N 1 2010-10-15 ? 0 no no no ? 2010-10-15 ? 20101015.ifs 2010-10-15 2010-10-16
335652 335652 EXCHANGE ADD 26613Q205 66 2010-10-15 2010-10-15 DFAB 0 1 ? 2010-10-15 20101015.ifs 2010-10-15 2010-10-16
336063 336063 EQUITY CHANGE 26613Q205 CUMULATIVE RED PERP PFD SER A 7.875% N 1 2010-10-15 ? 0 no no no ? 2010-10-15 ? 20101015.ifs 2010-10-15 2010-10-16
336064 336063 EQUITY CHANGE 26613Q205 CUMULATIVE RED PERP PFD SER A 7.875% 0 1 2010-10-15 ? 0 no no no ? 2010-10-15 ? 20101015.ifs 2010-10-15 2010-10-16


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 = 159589
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