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 PEB.PB Charts Yahoo PEB.PB Profile
  Run PEB.PB Institutional Summary Yahoo PEB.PB Key Statisics
  J3 Open PEB.PB Pricing Yahoo PEB.PB Pricing
  J3 PEB.PB Insider   J3 PEB.PB Insitutions Yahoo PEB.PB Holders
     
  Open up Sector/Exchange Map Fidelity PEB.PB Lookup
  Open up sec.gov For Market Ca MSN PEB.PB 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
70509V308 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:159603
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
2325753 2325753 DIVIDEND CHANGE 70509V308 0 0 1 6 0 08 ? ? 2016-09-21 2016-08-12 0 2016-08-12 ? 0 0005265399 20161025.ifs 2016-10-25 2016-10-26
2325754 2325753 DIVIDEND CHANGE 70509V308 0 0 1 0 .37778 0 08 ? ? 2016-09-21 2016-08-12 0 2016-08-12 2016-10-25 0 0005265399 20161025.ifs 2016-10-25 2016-10-26
2326045 2326045 DIVIDEND DELETE 70509V308 0 0 1 0 .37778 0 08 ? ? 2016-09-21 2016-08-12 0 2016-08-12 2016-10-25 0 0005265399 20161025.ifs 2016-10-25 2016-10-26
2326046 2326046 DIVIDEND ADD 70509V308 0 0 1 0 .37778 0 00 ? ? 2016-09-21 2016-08-12 1 2016-08-12 2016-10-25 0 0005265399 20161025.ifs 2016-10-25 2016-10-26
2298694 2298694 CORPACTION ADD 70509V308 01 C 2016-09-21 ? 20160921.ifs 2016-09-21 2016-09-22
2298695 2298695 EQUITY CHANGE 70509V308 PFD SER B 8% 0 1 2011-09-16 ? 0 no no no 2011-09-16 2011-09-23 ? 20160921.ifs 2016-09-21 2016-09-22
2298696 2298695 EQUITY CHANGE 70509V308 PFD SER B 8% C 1 2011-09-16 2016-09-21 0 no no no 2011-09-16 2016-09-21 ? 20160921.ifs 2016-09-21 2016-09-22
2270512 2270512 DIVIDEND ADD 70509V308 0 0 C 0 25 12 ? ? 2016-09-21 2016-08-12 0 ? 2016-08-15 0 20160815.ifs 2016-08-15 2016-08-16
2270244 2270244 DIVIDEND ADD 70509V308 0 0 1 6 0 08 ? ? 2016-09-21 2016-08-12 0 2016-08-12 ? 0 0005265399 20160812.ifs 2016-08-12 2016-08-13
2221098 2221098 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2016-06-28 2016-06-30 2016-07-15 2016-06-15 0 2016-06-15 ? 0 0005232297 20160615.ifs 2016-06-15 2016-06-16
2135376 2135376 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2016-03-29 2016-03-31 2016-04-15 2016-03-15 0 2016-03-15 ? 0 0005186724 20160315.ifs 2016-03-15 2016-03-16
2039591 2039591 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2015-12-29 2015-12-31 2016-01-15 2015-12-15 0 2015-12-15 ? 0 0005116496 20151215.ifs 2015-12-15 2015-12-16
1965913 1965913 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2015-09-28 2015-09-30 2015-10-15 2015-09-09 0 2015-09-15 ? 0 0005062214 20150915.ifs 2015-09-15 2015-09-16
1884135 1884135 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2015-06-26 2015-06-30 2015-07-15 2015-06-10 0 2015-06-10 ? 0 0005012707 20150610.ifs 2015-06-10 2015-06-11
1813170 1813170 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2015-03-27 2015-03-31 2015-04-15 2015-03-16 0 2015-03-16 ? 0 0004968662 20150316.ifs 2015-03-16 2015-03-17
1715884 1715884 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2014-12-29 2014-12-31 2015-01-15 2014-12-15 0 2014-12-15 ? 0 0004897218 20141215.ifs 2014-12-15 2014-12-16
1630236 1630236 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2014-09-26 2014-09-30 2014-10-15 2014-09-15 0 2014-09-15 ? 0 0004842809 20140915.ifs 2014-09-15 2014-09-16
1550306 1550306 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2014-06-26 2014-06-30 2014-07-15 2014-06-16 0 2014-06-16 ? 0 0004796443 20140616.ifs 2014-06-16 2014-06-17
1466683 1466683 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2014-03-27 2014-03-31 2014-04-15 2014-03-14 0 2014-03-14 ? 0 0004750280 20140314.ifs 2014-03-14 2014-03-15
1369251 1369251 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2013-12-27 2013-12-31 2014-01-15 2013-12-13 0 2013-12-13 ? 0 0004680430 20131213.ifs 2013-12-13 2013-12-14
1287165 1287165 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2013-09-26 2013-09-30 2013-10-15 2013-09-13 0 2013-09-13 ? 0 0004628607 20130913.ifs 2013-09-13 2013-09-14
1209925 1209925 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2013-06-27 2013-07-01 2013-07-15 2013-06-14 0 2013-06-14 ? 0 0004583966 20130614.ifs 2013-06-14 2013-06-15
1134045 1134045 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2013-03-27 2013-04-01 2013-04-15 2013-03-15 0 2013-03-15 ? 0 0004541512 20130315.ifs 2013-03-15 2013-03-16
1041273 1041273 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2012-12-27 2012-12-31 2013-01-15 2012-12-14 0 2012-12-14 ? 0 0004479152 20121214.ifs 2012-12-14 2012-12-15
956710 956710 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2012-09-26 2012-09-28 2012-10-15 2012-09-14 0 2012-09-14 ? 0 0004429284 20120914.ifs 2012-09-14 2012-09-15
886256 886256 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2012-06-27 2012-06-29 2012-07-16 2012-06-15 0 2012-06-15 ? 0 0004386538 20120615.ifs 2012-06-15 2012-06-16
803088 803088 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2012-03-28 2012-03-30 2012-04-16 2012-03-15 0 2012-03-15 ? 0 0004346093 20120315.ifs 2012-03-15 2012-03-16
723814 723814 DIVIDEND ADD 70509V308 0 0 1 0 .5 00 2011-12-28 2011-12-31 2012-01-16 2011-12-15 0 2011-12-15 ? 0 0004288216 20111215.ifs 2011-12-15 2011-12-16
651456 651456 CORPACTION ADD 70509V308 66 X 2011-09-23 70509V308 01 ? 20110923.ifs 2011-09-23 2011-09-24
651457 651457 EXCHANGE ADD 70509V308 01 2011-09-23 2011-09-23 PEB_PB 0 1 2011-09-23 ? 20110923.ifs 2011-09-23 2011-09-24
651566 651566 EXCHANGE DELETE 70509V308 01 2011-09-22 2011-09-23 PEB_PB 0 1 ? 2011-09-22 20110923.ifs 2011-09-23 2011-09-24
651567 651567 CORPACTION DELETE 70509V308 66 X 2011-09-22 70509V308 01 2011-09-22 20110923.ifs 2011-09-23 2011-09-24
651568 651568 EXCHANGE CHANGE 70509V308 66 2011-09-16 2011-09-21 PEBHP 0 1 2011-09-16 ? 20110923.ifs 2011-09-23 2011-09-24
651569 651568 EXCHANGE CHANGE 70509V308 66 2011-09-16 2011-09-22 PEBHP 0 1 2011-09-16 2011-09-23 20110923.ifs 2011-09-23 2011-09-24
651570 651570 EQUITY CHANGE 70509V308 PFD SER B 8% N 1 2011-09-16 ? 0 no no no 2011-09-16 2011-09-19 ? 20110923.ifs 2011-09-23 2011-09-24
651571 651570 EQUITY CHANGE 70509V308 PFD SER B 8% 0 1 2011-09-16 ? 0 no no no 2011-09-16 2011-09-23 ? 20110923.ifs 2011-09-23 2011-09-24
651876 651876 DIVIDEND ADD 70509V308 0 0 1 4 .13333 00 2011-09-28 2011-09-30 2011-10-17 2011-09-22 0 2011-09-23 ? 0 0004245835 20110923.ifs 2011-09-23 2011-09-24
650311 650311 EXCHANGE ADD 70509V308 01 2011-09-22 ? PEB_PB 0 1 ? 2011-09-22 20110922.ifs 2011-09-22 2011-09-23
650312 650312 CORPACTION ADD 70509V308 66 X 2011-09-22 70509V308 01 2011-09-22 20110922.ifs 2011-09-22 2011-09-23
646151 646151 EQUITY CHANGE 70509V308 PFD SER B N 1 2011-09-16 ? 0 no no no 2011-09-16 ? ? 20110919.ifs 2011-09-19 2011-09-20
646152 646151 EQUITY CHANGE 70509V308 PFD SER B 8% N 1 2011-09-16 ? 0 no no no 2011-09-16 2011-09-19 ? 20110919.ifs 2011-09-19 2011-09-20
645110 645110 EQUITY ADD 70509V308 PFD SER B N 1 2011-09-16 ? 0 no no no 2011-09-16 ? ? 20110916.ifs 2011-09-16 2011-09-17
645111 645111 EXCHANGE ADD 70509V308 66 2011-09-16 ? PEBHP 0 1 2011-09-16 ? 20110916.ifs 2011-09-16 2011-09-17


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