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 USB.PM Charts Yahoo USB.PM Profile
  Run USB.PM Institutional Summary Yahoo USB.PM Key Statisics
  J3 Open USB.PM Pricing Yahoo USB.PM Pricing
  J3 USB.PM Insider   J3 USB.PM Insitutions Yahoo USB.PM Holders
     
  Open up Sector/Exchange Map Fidelity USB.PM Lookup
  Open up sec.gov For Market Ca MSN USB.PM 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
 

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:160388
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
4935490 4935490 CORPACTION ADD 902973833 01 C 2022-01-18 2022-01-18 20220118.ifs 2022-01-18 2022-01-19
4935491 4935491 EQUITY CHANGE 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F 0 1 2012-01-19 ? 4 no no no 2012-01-19 ? ? 20220118.ifs 2022-01-18 2022-01-19
4935492 4935491 EQUITY CHANGE 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F C 1 2012-01-19 2022-01-18 4 no no no 2012-01-19 2022-01-18 ? 20220118.ifs 2022-01-18 2022-01-19
4902522 4902522 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2021-12-30 2021-12-31 2022-01-18 2021-12-21 0 2021-12-21 ? 0 0006439145 20211221.ifs 2021-12-21 2021-12-22
4896862 4896862 DIVIDEND ADD 902973833 0 0 C 0 25 12 ? ? 2022-01-15 2021-12-17 0 ? 2021-12-17 0 20211217.ifs 2021-12-17 2021-12-18
4891826 4891826 DIVIDEND CHANGE 902973833 0 0 1 0 .40625 00 2021-09-29 2021-09-30 2021-10-15 2021-09-14 0 2021-09-14 ? 0 0006367288 20211216.ifs 2021-12-16 2021-12-17
4891827 4891826 DIVIDEND CHANGE 902973833 0 0 1 0 .40625 00 2021-09-29 2021-09-30 2021-10-15 2021-09-14 1 2021-09-14 2021-12-16 0 0006367288 20211216.ifs 2021-12-16 2021-12-17
4801396 4801396 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2021-09-29 2021-09-30 2021-10-15 2021-09-14 0 2021-09-14 ? 0 0006367288 20210914.ifs 2021-09-14 2021-09-15
4729592 4729592 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2021-06-29 2021-06-30 2021-07-15 2021-06-15 0 2021-06-15 ? 0 0006322291 20210615.ifs 2021-06-15 2021-06-16
4653931 4653931 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2021-03-30 2021-03-31 2021-04-15 2021-03-16 0 2021-03-16 ? 0 0006277925 20210316.ifs 2021-03-16 2021-03-17
4530710 4530710 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2020-12-30 2020-12-31 2021-01-15 2020-12-08 0 2020-12-08 ? 0 0006202693 20201208.ifs 2020-12-08 2020-12-09
4462143 4462143 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2020-09-29 2020-09-30 2020-10-15 2020-09-15 0 2020-09-15 ? 0 0006159111 20200915.ifs 2020-09-15 2020-09-16
4392689 4392689 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2020-06-29 2020-06-30 2020-07-15 2020-06-16 0 2020-06-16 ? 0 0006113313 20200616.ifs 2020-06-16 2020-06-17
4080119 4080119 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-12-30 2019-12-31 2020-01-15 2019-12-17 0 2019-12-17 ? 0 0006004614 20191217.ifs 2019-12-17 2019-12-18
4080354 4080354 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-12-30 2019-12-31 2020-01-15 2019-12-17 0 2019-12-17 ? 0 0006004614 20191217.ifs 2019-12-17 2019-12-18
3924678 3924678 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-09-27 2019-09-30 2019-10-15 2019-09-17 0 2019-09-17 ? 0 0005946004 20190917.ifs 2019-09-17 2019-09-18
3924683 3924683 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-09-27 2019-09-30 2019-10-15 2019-09-17 0 2019-09-17 ? 0 0005946004 20190917.ifs 2019-09-17 2019-09-18
3785348 3785348 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-06-27 2019-06-28 2019-07-15 2019-06-18 0 2019-06-18 ? 0 0005899620 20190618.ifs 2019-06-18 2019-06-19
3785358 3785358 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-06-27 2019-06-28 2019-07-15 2019-06-18 0 2019-06-18 ? 0 0005899620 20190618.ifs 2019-06-18 2019-06-19
3637093 3637093 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-03-28 2019-03-29 2019-04-15 2019-03-19 0 2019-03-19 ? 0 0005854075 20190319.ifs 2019-03-19 2019-03-20
3637096 3637096 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2019-03-28 2019-03-29 2019-04-15 2019-03-19 0 2019-03-19 ? 0 0005854075 20190319.ifs 2019-03-19 2019-03-20
3457115 3457115 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-12-28 2018-12-31 2019-01-15 2018-12-18 0 2018-12-18 ? 0 0005786935 20181218.ifs 2018-12-18 2018-12-19
3457116 3457116 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-12-28 2018-12-31 2019-01-15 2018-12-18 0 2018-12-18 ? 0 0005786935 20181218.ifs 2018-12-18 2018-12-19
3287872 3287872 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-09-27 2018-09-28 2018-10-15 2018-09-18 0 2018-09-18 ? 0 0005724748 20180918.ifs 2018-09-18 2018-09-19
3287873 3287873 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-09-27 2018-09-28 2018-10-15 2018-09-18 0 2018-09-18 ? 0 0005724748 20180918.ifs 2018-09-18 2018-09-19
3145482 3145482 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-06-28 2018-06-29 2018-07-16 2018-06-19 0 2018-06-19 ? 0 0005676741 20180619.ifs 2018-06-19 2018-06-20
3145515 3145515 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-06-28 2018-06-29 2018-07-16 2018-06-19 0 2018-06-19 ? 0 0005676741 20180619.ifs 2018-06-19 2018-06-20
2996556 2996556 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-03-28 2018-03-29 2018-04-16 2018-03-19 0 2018-03-19 ? 0 0005630725 20180319.ifs 2018-03-19 2018-03-20
2996563 2996563 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2018-03-28 2018-03-29 2018-04-16 2018-03-19 0 2018-03-19 ? 0 0005630725 20180319.ifs 2018-03-19 2018-03-20
2841734 2841734 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2017-12-28 2017-12-29 2018-01-16 2017-12-19 0 2017-12-19 ? 0 0005564759 20171219.ifs 2017-12-19 2017-12-20
2841854 2841854 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2017-12-28 2017-12-29 2018-01-16 2017-12-19 0 2017-12-19 ? 0 0005564759 20171219.ifs 2017-12-19 2017-12-20
2677130 2677130 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2017-09-28 2017-09-29 2017-10-16 2017-09-19 0 2017-09-19 ? 0 0005499004 20170919.ifs 2017-09-19 2017-09-20
2677642 2677642 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2017-09-28 2017-09-29 2017-10-16 2017-09-19 0 2017-09-19 ? 0 0005499004 20170919.ifs 2017-09-19 2017-09-20
2595688 2595688 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2017-06-28 2017-06-30 2017-07-17 2017-06-20 0 2017-06-20 ? 0 0005451521 20170620.ifs 2017-06-20 2017-06-21
2517104 2517104 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2017-03-29 2017-03-31 2017-04-17 2017-03-21 0 2017-03-21 ? 0 0005404904 20170321.ifs 2017-03-21 2017-03-22
2446588 2446588 EQUITY CHANGE 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F 0 1 2012-01-19 ? 0 no no no 2012-01-19 ? ? 20170123.ifs 2017-01-23 2017-01-24
2446589 2446588 EQUITY CHANGE 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F 0 1 2012-01-19 ? 4 no no no 2012-01-19 ? ? 20170123.ifs 2017-01-23 2017-01-24
2383222 2383222 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2016-12-28 2016-12-30 2017-01-17 2016-12-19 0 2016-12-19 ? 0 0005341495 20161219.ifs 2016-12-19 2016-12-20
2296896 2296896 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2016-09-28 2016-09-30 2016-10-17 2016-09-19 0 2016-09-19 ? 0 0005282339 20160919.ifs 2016-09-19 2016-09-20
2220907 2220907 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2016-06-28 2016-06-30 2016-07-15 2016-06-15 0 2016-06-15 ? 0 0005232651 20160615.ifs 2016-06-15 2016-06-16
2135211 2135211 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2016-03-29 2016-03-31 2016-04-15 2016-03-15 0 2016-03-15 ? 0 0005186747 20160315.ifs 2016-03-15 2016-03-16
2039249 2039249 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2015-12-29 2015-12-31 2016-01-15 2015-12-15 0 2015-12-15 ? 0 0005118058 20151215.ifs 2015-12-15 2015-12-16
1965739 1965739 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2015-09-28 2015-09-30 2015-10-15 2015-09-15 0 2015-09-15 ? 0 0005062420 20150915.ifs 2015-09-15 2015-09-16
1887146 1887146 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2015-06-26 2015-06-30 2015-07-15 2015-06-16 0 2015-06-16 ? 0 0005014010 20150616.ifs 2015-06-16 2015-06-17
1803961 1803961 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2015-03-27 2015-03-31 2015-04-15 2015-03-03 0 2015-03-03 ? 0 0004965311 20150303.ifs 2015-03-03 2015-03-04
1703970 1703970 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2014-12-29 2014-12-31 2015-01-15 2014-12-09 0 2014-12-09 ? 0 0004887879 20141209.ifs 2014-12-09 2014-12-10
1630963 1630963 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2014-09-26 2014-09-30 2014-10-15 2014-09-16 0 2014-09-16 ? 0 0004843311 20140916.ifs 2014-09-16 2014-09-17
1551308 1551308 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2014-06-26 2014-06-30 2014-07-15 2014-06-17 0 2014-06-17 ? 0 0004797113 20140617.ifs 2014-06-17 2014-06-18
1464815 1464815 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2014-03-27 2014-03-31 2014-04-15 2014-03-12 0 2014-03-12 ? 0 0004749731 20140312.ifs 2014-03-12 2014-03-13
1361737 1361737 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2013-12-27 2013-12-31 2014-01-15 2013-12-10 0 2013-12-10 ? 0 0004674856 20131210.ifs 2013-12-10 2013-12-11
1289149 1289149 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2013-09-26 2013-09-30 2013-10-15 2013-09-17 0 2013-09-17 ? 0 0004629735 20130917.ifs 2013-09-17 2013-09-18
1211654 1211654 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2013-06-26 2013-06-28 2013-07-15 2013-06-18 0 2013-06-18 ? 0 0004584817 20130618.ifs 2013-06-18 2013-06-19
1132903 1132903 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2013-03-26 2013-03-28 2013-04-15 2013-03-14 0 2013-03-14 ? 0 0004541465 20130314.ifs 2013-03-14 2013-03-15
1035232 1035232 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2012-12-27 2012-12-31 2013-01-15 2012-12-11 0 2012-12-11 ? 0 0004474832 20121211.ifs 2012-12-11 2012-12-12
958247 958247 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2012-09-26 2012-09-28 2012-10-15 2012-09-18 0 2012-09-18 ? 0 0004430157 20120918.ifs 2012-09-18 2012-09-19
888127 888127 DIVIDEND ADD 902973833 0 0 1 0 .40625 00 2012-06-27 2012-06-29 2012-07-16 2012-06-19 0 2012-06-19 ? 0 0004387801 20120619.ifs 2012-06-19 2012-06-20
802002 802002 DIVIDEND ADD 902973833 0 0 1 4 .37014 00 2012-03-28 2012-03-30 2012-04-16 2012-03-13 0 2012-03-14 ? 0 0004345469 20120314.ifs 2012-03-14 2012-03-15
763685 763685 CORPACTION ADD 902973833 66 X 2012-01-27 902973833 01 ? 20120127.ifs 2012-01-27 2012-01-28
763686 763686 EXCHANGE ADD 902973833 01 2012-01-27 2012-01-27 USB_PM 0 1 2012-01-27 ? 20120127.ifs 2012-01-27 2012-01-28
758832 758832 EQUITY ADD 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F N 1 2012-01-19 ? 0 no no no 2012-01-19 ? ? 20120119.ifs 2012-01-19 2012-01-20
758833 758833 EXCHANGE ADD 902973833 66 2012-01-19 2012-01-19 USBPP 0 1 2012-01-19 ? 20120119.ifs 2012-01-19 2012-01-20
759541 759541 EQUITY CHANGE 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F N 1 2012-01-19 ? 0 no no no 2012-01-19 ? ? 20120119.ifs 2012-01-19 2012-01-20
759542 759541 EQUITY CHANGE 902973833 DEPOSITARY SHS REPSTG 1/1000TH NON CUM PERP PFD SER F 0 1 2012-01-19 ? 0 no no no 2012-01-19 ? ? 20120119.ifs 2012-01-19 2012-01-20


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