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 PSA.PQ Charts Yahoo PSA.PQ Profile
  Run PSA.PQ Institutional Summary Yahoo PSA.PQ Key Statisics
  J3 Open PSA.PQ Pricing Yahoo PSA.PQ Pricing
  J3 PSA.PQ Insider   J3 PSA.PQ Insitutions Yahoo PSA.PQ Holders
     
  Open up Sector/Exchange Map Fidelity PSA.PQ Lookup
  Open up sec.gov For Market Ca MSN PSA.PQ 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
74460D141 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:159611
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
2202820 2202820 DIVIDEND DELETE 74460D141 0 0 1 6 0 08 ? ? 2016-04-15 2016-03-15 0 2016-03-15 ? 0 0005187097 20160525.ifs 2016-05-25 2016-05-26
2202821 2202821 DIVIDEND ADD 74460D141 0 0 1 0 .063194 00 ? ? 2016-04-15 2016-03-15 1 2016-03-15 2016-05-25 0 0005187097 20160525.ifs 2016-05-25 2016-05-26
2165049 2165049 CORPACTION ADD 74460D141 01 C 2016-04-15 ? 20160415.ifs 2016-04-15 2016-04-16
2165050 2165050 EQUITY CHANGE 74460D141 DEPOSITARY SHS REPSTG 1/1000TH PFD SHS BEN INT SER Q 0 1 2011-04-07 ? 0 no no no 2011-04-07 2011-04-07 ? 20160415.ifs 2016-04-15 2016-04-16
2165051 2165050 EQUITY CHANGE 74460D141 DEPOSITARY SHS REPSTG 1/1000TH PFD SHS BEN INT SER Q C 1 2011-04-07 2016-04-15 0 no no no 2011-04-07 2016-04-15 ? 20160415.ifs 2016-04-15 2016-04-16
2135874 2135874 DIVIDEND ADD 74460D141 0 0 C 0 25 12 ? ? 2016-04-15 2016-03-15 0 ? 2016-03-16 0 20160316.ifs 2016-03-16 2016-03-17
2135361 2135361 DIVIDEND ADD 74460D141 0 0 1 6 0 08 ? ? 2016-04-15 2016-03-15 0 2016-03-15 ? 0 0005187097 20160315.ifs 2016-03-15 2016-03-16
2114014 2114014 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2016-03-14 2016-03-16 2016-03-31 2016-02-15 0 2016-02-17 ? 0 0005173137 20160217.ifs 2016-02-17 2016-02-18
1999023 1999023 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2015-12-11 2015-12-15 2015-12-30 2015-10-28 0 2015-10-29 ? 0 0005083265 20151029.ifs 2015-10-29 2015-10-30
1935618 1935618 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2015-09-11 2015-09-15 2015-09-30 2015-07-29 0 2015-08-04 ? 0 0005045031 20150804.ifs 2015-08-04 2015-08-05
1851525 1851525 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2015-06-11 2015-06-15 2015-06-30 2015-04-29 0 2015-04-30 ? 0 0004991987 20150430.ifs 2015-04-30 2015-05-01
1793118 1793118 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2015-03-12 2015-03-16 2015-03-31 2015-02-19 0 2015-02-20 ? 0 0004956246 20150220.ifs 2015-02-20 2015-02-21
1676059 1676059 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2014-12-11 2014-12-15 2014-12-30 2014-10-30 0 2014-11-05 ? 0 0004871105 20141105.ifs 2014-11-05 2014-11-06
1595446 1595446 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2014-09-11 2014-09-15 2014-09-30 2014-08-01 0 2014-08-01 ? 0 0004824465 20140801.ifs 2014-08-01 2014-08-02
1516403 1516403 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2014-06-11 2014-06-13 2014-06-30 2014-05-01 0 2014-05-02 ? 0 0004779780 20140502.ifs 2014-05-02 2014-05-03
1449240 1449240 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2014-03-12 2014-03-14 2014-03-31 2014-02-24 0 2014-02-25 ? 0 0004739181 20140225.ifs 2014-02-25 2014-02-26
1330952 1330952 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2013-12-11 2013-12-13 2013-12-30 2013-10-31 0 2013-11-01 ? 0 0004654369 20131101.ifs 2013-11-01 2013-11-02
1258594 1258594 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2013-09-11 2013-09-13 2013-09-30 2013-08-01 0 2013-08-02 ? 0 0004613142 20130802.ifs 2013-08-02 2013-08-03
1187002 1187002 DIVIDEND DELETE 74460D141 0 0 1 6 0 08 2013-06-10 2013-06-12 2013-06-27 2013-05-09 0 2013-05-09 ? 0 0004570456 20130516.ifs 2013-05-16 2013-05-17
1187003 1187003 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2013-06-10 2013-06-12 2013-06-27 2013-05-09 1 2013-05-09 2013-05-16 0 0004570456 20130516.ifs 2013-05-16 2013-05-17
1183106 1183106 DIVIDEND ADD 74460D141 0 0 1 6 0 08 2013-06-10 2013-06-12 2013-06-27 2013-05-09 0 2013-05-09 ? 0 0004570456 20130509.ifs 2013-05-09 2013-05-10
1116430 1116430 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2013-03-11 2013-03-13 2013-03-28 2013-02-21 0 2013-02-22 ? 0 0004530149 20130222.ifs 2013-02-22 2013-02-23
1017166 1017166 DIVIDEND DELETE 74460D141 0 0 1 6 0 08 2012-12-10 2012-12-12 2012-12-27 2012-11-16 0 2012-11-16 ? 0 0004458540 20121128.ifs 2012-11-28 2012-11-29
1017167 1017167 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2012-12-10 2012-12-12 2012-12-27 2012-11-08 1 2012-11-16 2012-11-28 0 0004458540 20121128.ifs 2012-11-28 2012-11-29
1011239 1011239 DIVIDEND ADD 74460D141 0 0 1 6 0 08 2012-12-10 2012-12-12 2012-12-27 2012-11-16 0 2012-11-16 ? 0 0004458540 20121116.ifs 2012-11-16 2012-11-17
926585 926585 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2012-09-10 2012-09-12 2012-09-27 2012-08-02 0 2012-08-06 ? 0 0004414104 20120806.ifs 2012-08-06 2012-08-07
879134 879134 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2012-06-11 2012-06-13 2012-06-28 2012-05-03 0 2012-06-04 ? 0 0004384585 20120604.ifs 2012-06-04 2012-06-05
856065 856065 DIVIDEND CHANGE 74460D141 0 0 1 4 .347569 00 2011-06-13 2011-06-15 2011-06-30 2011-05-05 0 2011-05-09 2012-05-07 0 0004187177 20120507.ifs 2012-05-07 2012-05-08
856066 856065 DIVIDEND CHANGE 74460D141 0 0 1 4 .347569 00 2011-06-13 2011-06-15 2011-06-30 2011-05-05 0 2011-05-09 2012-05-07 0 0004187177 20120507.ifs 2012-05-07 2012-05-08
856067 856067 DIVIDEND CHANGE 74460D141 0 0 1 0 .40625 00 2011-09-12 2011-09-14 2011-09-29 2011-08-04 0 2011-08-09 2012-05-07 0 0004228587 20120507.ifs 2012-05-07 2012-05-08
856068 856067 DIVIDEND CHANGE 74460D141 0 0 1 0 .40625 00 2011-09-12 2011-09-14 2011-09-29 2011-08-04 0 2011-08-09 2012-05-07 0 0004228587 20120507.ifs 2012-05-07 2012-05-08
856069 856069 DIVIDEND CHANGE 74460D141 0 0 1 0 .40625 00 2011-12-12 2011-12-14 2011-12-29 2011-11-03 0 2011-11-03 2012-05-07 0 0004268183 20120507.ifs 2012-05-07 2012-05-08
856070 856069 DIVIDEND CHANGE 74460D141 0 0 1 0 .40625 00 2011-12-12 2011-12-14 2011-12-29 2011-11-03 0 2011-11-03 2012-05-07 0 0004268183 20120507.ifs 2012-05-07 2012-05-08
785871 785871 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2012-03-12 2012-03-14 2012-03-29 2012-02-23 0 2012-02-27 ? 0 0004335769 20120227.ifs 2012-02-27 2012-02-28
689829 689829 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2011-12-12 2011-12-14 2011-12-29 2011-11-03 0 2011-11-03 ? 0 0004268183 20111103.ifs 2011-11-03 2011-11-04
609709 609709 DIVIDEND ADD 74460D141 0 0 1 0 .40625 00 2011-09-12 2011-09-14 2011-09-29 2011-08-04 0 2011-08-09 ? 0 0004228587 20110809.ifs 2011-08-09 2011-08-10
522998 522998 DIVIDEND ADD 74460D141 0 0 1 4 .347569 00 2011-06-13 2011-06-15 2011-06-30 2011-05-05 0 2011-05-09 ? 0 0004187177 20110509.ifs 2011-05-09 2011-05-10
501929 501929 CORPACTION ADD 74460D141 66 X 2011-04-14 74460D141 01 ? 20110414.ifs 2011-04-14 2011-04-15
501930 501930 EXCHANGE ADD 74460D141 01 2011-04-14 2011-04-14 PSA_PQ 0 1 2011-04-14 ? 20110414.ifs 2011-04-14 2011-04-15


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