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 IPFF Charts Yahoo IPFF Profile
  Run IPFF Institutional Summary Yahoo IPFF Key Statisics
  J3 Open IPFF Pricing Yahoo IPFF Pricing
  J3 IPFF Insider   J3 IPFF Insitutions Yahoo IPFF Holders
     
  Open up Sector/Exchange Map Fidelity IPFF Lookup
  Open up sec.gov For Market Ca MSN IPFF 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:160371
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
4825610 4825610 EQUITY CHANGE 46429B135 ISHARES INTERNATIONAL PREFERRED STOCK ETF 0 A 2011-11-17 ? 5 no no no 2011-11-17 2013-07-01 ? 20211012.ifs 2021-10-12 2021-10-13
4825611 4825610 EQUITY CHANGE 46429B135 ISHARES INTERNATIONAL PREFERRED STOCK ETF L A 2011-11-17 2021-08-24 5 no no no 2011-11-17 2021-10-12 ? 20211012.ifs 2021-10-12 2021-10-13
4769451 4769451 DIVIDEND ADD 46429B135 0 0 1 0 .053882 00 2021-08-02 2021-08-03 2021-08-06 2021-07-30 0 2021-07-30 ? 0 0006345578 20210730.ifs 2021-07-30 2021-07-31
4744685 4744685 DIVIDEND ADD 46429B135 0 0 1 0 .045153 00 2021-07-01 2021-07-02 2021-07-08 2021-06-30 0 2021-06-30 ? 0 0006331651 20210630.ifs 2021-06-30 2021-07-01
4715037 4715037 DIVIDEND ADD 46429B135 0 0 1 0 .050033 00 2021-06-01 2021-06-02 2021-06-07 2021-05-28 0 2021-05-28 ? 0 0006312742 20210528.ifs 2021-05-28 2021-05-29
4693269 4693269 DIVIDEND ADD 46429B135 0 0 1 0 .03603 00 2021-05-03 2021-05-04 2021-05-07 2021-04-30 0 2021-04-30 ? 0 0006300058 20210430.ifs 2021-04-30 2021-05-01
4669468 4669468 DIVIDEND ADD 46429B135 0 0 1 0 .039129 00 2021-04-01 2021-04-05 2021-04-08 2021-03-31 0 2021-03-31 ? 0 0006286539 20210331.ifs 2021-03-31 2021-04-01
4639406 4639406 DIVIDEND ADD 46429B135 0 0 1 0 .04673 00 2021-03-01 2021-03-02 2021-03-05 2021-02-26 0 2021-02-26 ? 0 0006269043 20210226.ifs 2021-02-26 2021-02-27
4616366 4616366 DIVIDEND ADD 46429B135 0 0 1 0 .048425 00 2021-02-01 2021-02-02 2021-02-05 2021-01-29 0 2021-01-29 ? 0 0006256166 20210129.ifs 2021-01-29 2021-01-30
4547912 4547912 DIVIDEND ADD 46429B135 0 0 1 0 .033581 00 2020-12-17 2020-12-18 2020-12-23 2020-12-16 0 2020-12-16 ? 0 0006216774 20201216.ifs 2020-12-16 2020-12-17
4518066 4518066 DIVIDEND ADD 46429B135 0 0 1 0 .047841 00 2020-12-01 2020-12-02 2020-12-07 2020-11-30 0 2020-11-30 ? 0 0006193399 20201130.ifs 2020-11-30 2020-12-01
4496040 4496040 DIVIDEND ADD 46429B135 0 0 1 0 .047941 00 2020-11-02 2020-11-03 2020-11-06 2020-10-30 0 2020-10-30 ? 0 0006180503 20201030.ifs 2020-10-30 2020-10-31
4474797 4474797 DIVIDEND ADD 46429B135 0 0 1 0 .044719 00 2020-10-01 2020-10-02 2020-10-07 2020-09-30 0 2020-09-30 ? 0 0006167659 20200930.ifs 2020-09-30 2020-10-01
4449699 4449699 DIVIDEND ADD 46429B135 0 0 1 0 .045319 00 2020-09-01 2020-09-02 2020-09-08 2020-08-31 0 2020-08-31 ? 0 0006149594 20200831.ifs 2020-08-31 2020-09-01
4429484 4429484 DIVIDEND ADD 46429B135 0 0 1 0 .05035 00 2020-08-03 2020-08-04 2020-08-07 2020-07-31 0 2020-07-31 ? 0 0006135939 20200731.ifs 2020-07-31 2020-08-01
4407092 4407092 DIVIDEND ADD 46429B135 0 0 1 0 .060038 00 2020-07-01 2020-07-02 2020-07-08 2020-06-30 0 2020-06-30 ? 0 0006122505 20200630.ifs 2020-06-30 2020-07-01
4355430 4355430 DIVIDEND ADD 46429B135 0 0 1 0 .060038 00 2020-06-01 2020-06-02 2020-06-05 2020-05-29 0 2020-05-29 ? 0 0006103868 20200529.ifs 2020-05-29 2020-05-30
4355625 4355625 DIVIDEND ADD 46429B135 0 0 1 0 .060038 00 2020-06-01 2020-06-02 2020-06-05 2020-05-29 0 2020-05-29 ? 0 0006103868 20200529.ifs 2020-05-29 2020-05-30
4310023 4310023 DIVIDEND ADD 46429B135 0 0 1 0 .060038 00 2020-05-01 2020-05-04 2020-05-07 2020-04-30 0 2020-04-30 ? 0 0006090942 20200430.ifs 2020-04-30 2020-05-01
4310024 4310024 DIVIDEND ADD 46429B135 0 0 1 0 .060038 00 2020-05-01 2020-05-04 2020-05-07 2020-04-30 0 2020-04-30 ? 0 0006090942 20200430.ifs 2020-04-30 2020-05-01
4267213 4267213 DIVIDEND ADD 46429B135 0 0 1 0 .063899 00 2020-04-01 2020-04-02 2020-04-07 2020-03-31 0 2020-03-31 ? 0 0006077724 20200331.ifs 2020-03-31 2020-04-01
4267422 4267422 DIVIDEND ADD 46429B135 0 0 1 0 .063899 00 2020-04-01 2020-04-02 2020-04-07 2020-03-31 0 2020-03-31 ? 0 0006077724 20200331.ifs 2020-03-31 2020-04-01
4222956 4222956 DIVIDEND ADD 46429B135 0 0 1 0 .058385 00 2020-03-02 2020-03-03 2020-03-06 2020-02-28 0 2020-02-28 ? 0 0006060448 20200228.ifs 2020-02-28 2020-02-29
4222959 4222959 DIVIDEND ADD 46429B135 0 0 1 0 .058385 00 2020-03-02 2020-03-03 2020-03-06 2020-02-28 0 2020-02-28 ? 0 0006060448 20200228.ifs 2020-02-28 2020-02-29
4186564 4186564 DIVIDEND ADD 46429B135 0 0 1 0 .053385 00 2020-02-03 2020-02-04 2020-02-07 2020-01-31 0 2020-01-31 ? 0 0006047456 20200131.ifs 2020-01-31 2020-02-01
4186647 4186647 DIVIDEND ADD 46429B135 0 0 1 0 .053385 00 2020-02-03 2020-02-04 2020-02-07 2020-01-31 0 2020-01-31 ? 0 0006047456 20200131.ifs 2020-01-31 2020-02-01
4088695 4088695 DIVIDEND ADD 46429B135 0 0 1 0 .03322 00 2019-12-19 2019-12-20 2019-12-26 2019-12-18 0 2019-12-18 ? 0 0006009309 20191218.ifs 2019-12-18 2019-12-19
4088714 4088714 DIVIDEND ADD 46429B135 0 0 1 0 .03322 00 2019-12-19 2019-12-20 2019-12-26 2019-12-18 0 2019-12-18 ? 0 0006009309 20191218.ifs 2019-12-18 2019-12-19
3993609 3993609 DIVIDEND ADD 46429B135 0 0 1 0 .048715 00 2019-11-01 2019-11-04 2019-11-07 2019-10-31 0 2019-10-31 ? 0 0005967768 20191031.ifs 2019-10-31 2019-11-01
3993657 3993657 DIVIDEND ADD 46429B135 0 0 1 0 .048715 00 2019-11-01 2019-11-04 2019-11-07 2019-10-31 0 2019-10-31 ? 0 0005967768 20191031.ifs 2019-10-31 2019-11-01
3950688 3950688 DIVIDEND ADD 46429B135 0 0 1 0 .058441 00 2019-10-01 2019-10-02 2019-10-07 2019-09-30 0 2019-09-30 ? 0 0005954429 20190930.ifs 2019-09-30 2019-10-01
3950693 3950693 DIVIDEND ADD 46429B135 0 0 1 0 .058441 00 2019-10-01 2019-10-02 2019-10-07 2019-09-30 0 2019-09-30 ? 0 0005954429 20190930.ifs 2019-09-30 2019-10-01
3899395 3899395 DIVIDEND ADD 46429B135 0 0 1 0 .05646 00 2019-09-03 2019-09-04 2019-09-09 2019-08-30 0 2019-08-30 ? 0 0005936062 20190830.ifs 2019-08-30 2019-08-31
3899552 3899552 DIVIDEND ADD 46429B135 0 0 1 0 .05646 00 2019-09-03 2019-09-04 2019-09-09 2019-08-30 0 2019-08-30 ? 0 0005936062 20190830.ifs 2019-08-30 2019-08-31
3857391 3857391 DIVIDEND ADD 46429B135 0 0 1 0 .05646 00 2019-08-01 2019-08-02 2019-08-07 2019-07-31 0 2019-07-31 ? 0 0005921921 20190731.ifs 2019-07-31 2019-08-01
3857418 3857418 DIVIDEND ADD 46429B135 0 0 1 0 .05646 00 2019-08-01 2019-08-02 2019-08-07 2019-07-31 0 2019-07-31 ? 0 0005921921 20190731.ifs 2019-07-31 2019-08-01
3820425 3820425 DIVIDEND ADD 46429B135 0 0 1 0 .0572 00 2019-07-02 2019-07-03 2019-07-09 2019-07-01 0 2019-07-01 ? 0 0005913142 20190701.ifs 2019-07-01 2019-07-02
3820546 3820546 DIVIDEND ADD 46429B135 0 0 1 0 .0572 00 2019-07-02 2019-07-03 2019-07-09 2019-07-01 0 2019-07-01 ? 0 0005913142 20190701.ifs 2019-07-01 2019-07-02
3750379 3750379 DIVIDEND ADD 46429B135 0 0 1 0 .06037 00 2019-06-03 2019-06-04 2019-06-07 2019-05-31 0 2019-05-31 ? 0 0005889188 20190531.ifs 2019-05-31 2019-06-01
3750399 3750399 DIVIDEND ADD 46429B135 0 0 1 0 .06037 00 2019-06-03 2019-06-04 2019-06-07 2019-05-31 0 2019-05-31 ? 0 0005889188 20190531.ifs 2019-05-31 2019-06-01
3710246 3710246 DIVIDEND ADD 46429B135 0 0 1 0 .06337 00 2019-05-02 2019-05-03 2019-05-08 2019-05-01 0 2019-05-01 ? 0 0005879623 20190501.ifs 2019-05-01 2019-05-02
3710255 3710255 DIVIDEND ADD 46429B135 0 0 1 0 .06337 00 2019-05-02 2019-05-03 2019-05-08 2019-05-01 0 2019-05-01 ? 0 0005879623 20190501.ifs 2019-05-01 2019-05-02
3660445 3660445 DIVIDEND ADD 46429B135 0 0 1 0 .069683 00 2019-04-01 2019-04-02 2019-04-05 2019-03-29 0 2019-03-29 ? 0 0005862341 20190329.ifs 2019-03-29 2019-03-30
3660484 3660484 DIVIDEND ADD 46429B135 0 0 1 0 .069683 00 2019-04-01 2019-04-02 2019-04-05 2019-03-29 0 2019-03-29 ? 0 0005862341 20190329.ifs 2019-03-29 2019-03-30
3601486 3601486 DIVIDEND ADD 46429B135 0 0 1 0 .066447 00 2019-03-01 2019-03-04 2019-03-07 2019-02-28 0 2019-02-28 ? 0 0005844130 20190228.ifs 2019-02-28 2019-03-01
3601932 3601932 DIVIDEND ADD 46429B135 0 0 1 0 .066447 00 2019-03-01 2019-03-04 2019-03-07 2019-02-28 0 2019-02-28 ? 0 0005844130 20190228.ifs 2019-02-28 2019-03-01
3570057 3570057 DIVIDEND ADD 46429B135 0 0 1 0 .060447 00 2019-02-01 2019-02-04 2019-02-07 2019-01-31 0 2019-01-31 ? 0 0005831160 20190131.ifs 2019-01-31 2019-02-01
3570062 3570062 DIVIDEND ADD 46429B135 0 0 1 0 .060447 00 2019-02-01 2019-02-04 2019-02-07 2019-01-31 0 2019-01-31 ? 0 0005831160 20190131.ifs 2019-01-31 2019-02-01
3452348 3452348 DIVIDEND ADD 46429B135 0 0 1 0 .028772 00 2018-12-18 2018-12-19 2018-12-24 2018-12-17 0 2018-12-17 ? 0 0005785747 20181217.ifs 2018-12-17 2018-12-18
3452507 3452507 DIVIDEND ADD 46429B135 0 0 1 0 .028772 00 2018-12-18 2018-12-19 2018-12-24 2018-12-17 0 2018-12-17 ? 0 0005785747 20181217.ifs 2018-12-17 2018-12-18
3390604 3390604 DIVIDEND ADD 46429B135 0 0 1 0 .059777 00 2018-12-03 2018-12-04 2018-12-07 2018-11-30 0 2018-11-30 ? 0 0005760617 20181130.ifs 2018-11-30 2018-12-01
3390663 3390663 DIVIDEND ADD 46429B135 0 0 1 0 .059777 00 2018-12-03 2018-12-04 2018-12-07 2018-11-30 0 2018-11-30 ? 0 0005760617 20181130.ifs 2018-11-30 2018-12-01
3348358 3348358 DIVIDEND ADD 46429B135 0 0 1 0 .062178 00 2018-11-01 2018-11-02 2018-11-07 2018-10-31 0 2018-10-31 ? 0 0005746560 20181031.ifs 2018-10-31 2018-11-01
3348407 3348407 DIVIDEND ADD 46429B135 0 0 1 0 .062178 00 2018-11-01 2018-11-02 2018-11-07 2018-10-31 0 2018-10-31 ? 0 0005746560 20181031.ifs 2018-10-31 2018-11-01
3307863 3307863 DIVIDEND ADD 46429B135 0 0 1 0 .072896 00 2018-10-01 2018-10-02 2018-10-05 2018-09-28 0 2018-09-28 ? 1 0005732712 20180928.ifs 2018-09-28 2018-09-29
3307878 3307878 DIVIDEND ADD 46429B135 0 0 1 0 .072896 00 2018-10-01 2018-10-02 2018-10-05 2018-09-28 0 2018-09-28 ? 1 0005732712 20180928.ifs 2018-09-28 2018-09-29
3257766 3257766 DIVIDEND ADD 46429B135 0 0 1 0 .074743 00 2018-09-04 2018-09-05 2018-09-10 2018-08-31 0 2018-08-31 ? 0 0005713970 20180831.ifs 2018-08-31 2018-09-01
3257819 3257819 DIVIDEND ADD 46429B135 0 0 1 0 .074743 00 2018-09-04 2018-09-05 2018-09-10 2018-08-31 0 2018-08-31 ? 0 0005713970 20180831.ifs 2018-08-31 2018-09-01
3214656 3214656 DIVIDEND ADD 46429B135 0 0 1 0 .072827 00 2018-08-01 2018-08-02 2018-08-07 2018-07-31 0 2018-07-31 ? 0 0005699655 20180731.ifs 2018-07-31 2018-08-01
3215113 3215113 DIVIDEND ADD 46429B135 0 0 1 0 .072827 00 2018-08-01 2018-08-02 2018-08-07 2018-07-31 0 2018-07-31 ? 0 0005699655 20180731.ifs 2018-07-31 2018-08-01
3194244 3194244 DIVIDEND DELETE 46429B135 0 0 1 0 .067785 00 2018-07-03 2018-07-05 2018-07-10 2018-06-30 0 2018-07-02 ? 0 0005690095 20180713.ifs 2018-07-13 2018-07-14
3194246 3194246 DIVIDEND ADD 46429B135 0 0 1 0 .067785 00 2018-07-03 2018-07-05 2018-07-10 2018-07-02 1 2018-07-02 2018-07-13 0 0005690095 20180713.ifs 2018-07-13 2018-07-14
3194249 3194249 DIVIDEND DELETE 46429B135 0 0 1 0 .067785 00 2018-07-03 2018-07-05 2018-07-10 2018-06-30 0 2018-07-02 ? 0 0005690095 20180713.ifs 2018-07-13 2018-07-14
3194251 3194251 DIVIDEND ADD 46429B135 0 0 1 0 .067785 00 2018-07-03 2018-07-05 2018-07-10 2018-07-02 1 2018-07-02 2018-07-13 0 0005690095 20180713.ifs 2018-07-13 2018-07-14
3176405 3176405 DIVIDEND ADD 46429B135 0 0 1 0 .067785 00 2018-07-03 2018-07-05 2018-07-10 2018-06-30 0 2018-07-02 ? 0 0005690095 20180702.ifs 2018-07-02 2018-07-03
3177593 3177593 DIVIDEND ADD 46429B135 0 0 1 0 .067785 00 2018-07-03 2018-07-05 2018-07-10 2018-06-30 0 2018-07-02 ? 0 0005690095 20180702.ifs 2018-07-02 2018-07-03
3111368 3111368 DIVIDEND ADD 46429B135 0 0 1 0 .062843 00 2018-06-01 2018-06-04 2018-06-07 2018-05-31 0 2018-05-31 ? 0 0005667294 20180531.ifs 2018-05-31 2018-06-01
3111858 3111858 DIVIDEND ADD 46429B135 0 0 1 0 .062843 00 2018-06-01 2018-06-04 2018-06-07 2018-05-31 0 2018-05-31 ? 0 0005667294 20180531.ifs 2018-05-31 2018-06-01
3062692 3062692 DIVIDEND ADD 46429B135 0 0 1 0 .06056 00 2018-05-01 2018-05-02 2018-05-07 2018-04-30 0 2018-04-30 ? 0 0005652934 20180430.ifs 2018-04-30 2018-05-01
3062697 3062697 DIVIDEND ADD 46429B135 0 0 1 0 .06056 00 2018-05-01 2018-05-02 2018-05-07 2018-04-30 0 2018-04-30 ? 0 0005652934 20180430.ifs 2018-04-30 2018-05-01
3015421 3015421 DIVIDEND ADD 46429B135 0 0 1 0 .055775 00 2018-04-02 2018-04-03 2018-04-06 2018-03-29 0 2018-03-29 ? 0 0005639259 20180329.ifs 2018-03-29 2018-03-30
2969721 2969721 DIVIDEND ADD 46429B135 0 0 1 0 .053079 00 2018-03-01 2018-03-02 2018-03-07 2018-02-28 0 2018-02-28 ? 0 0005620629 20180228.ifs 2018-02-28 2018-03-01
2937145 2937145 DIVIDEND ADD 46429B135 0 0 1 0 .044498 00 2018-02-01 2018-02-02 2018-02-07 2018-01-31 0 2018-01-31 ? 0 0005607477 20180131.ifs 2018-01-31 2018-02-01
2852032 2852032 DIVIDEND ADD 46429B135 0 0 1 0 .044595 00 2017-12-21 2017-12-22 2017-12-28 2017-12-20 0 2017-12-20 ? 0 0005571918 20171220.ifs 2017-12-20 2017-12-21
2855931 2855931 DIVIDEND ADD 46429B135 0 0 1 0 .044595 00 2017-12-21 2017-12-22 2017-12-28 2017-12-20 0 2017-12-20 ? 0 0005571918 20171220.ifs 2017-12-20 2017-12-21
2783980 2783980 DIVIDEND ADD 46429B135 0 0 1 0 .049356 00 2017-12-01 2017-12-04 2017-12-07 2017-11-30 0 2017-11-30 ? 0 0005535807 20171204.ifs 2017-12-04 2017-12-05
2784039 2784039 DIVIDEND ADD 46429B135 0 0 1 0 .049356 00 2017-12-01 2017-12-04 2017-12-07 2017-11-30 0 2017-11-30 ? 0 0005535807 20171204.ifs 2017-12-04 2017-12-05
2744131 2744131 DIVIDEND ADD 46429B135 0 0 1 0 .048347 00 2017-11-01 2017-11-02 2017-11-07 2017-10-31 0 2017-10-31 ? 0 0005521095 20171031.ifs 2017-10-31 2017-11-01
2744714 2744714 DIVIDEND ADD 46429B135 0 0 1 0 .048347 00 2017-11-01 2017-11-02 2017-11-07 2017-10-31 0 2017-10-31 ? 0 0005521095 20171031.ifs 2017-10-31 2017-11-01
2698525 2698525 DIVIDEND ADD 46429B135 0 0 1 0 .044983 00 2017-10-02 2017-10-03 2017-10-06 2017-09-29 0 2017-09-29 ? 0 0005506897 20170929.ifs 2017-09-29 2017-09-30
2698870 2698870 DIVIDEND ADD 46429B135 0 0 1 0 .044983 00 2017-10-02 2017-10-03 2017-10-06 2017-09-29 0 2017-09-29 ? 0 0005506897 20170929.ifs 2017-09-29 2017-09-30
2659597 2659597 DIVIDEND ADD 46429B135 0 0 1 0 .050153 00 2017-09-01 2017-09-06 2017-09-08 2017-08-31 0 2017-08-31 ? 0 0005488527 20170831.ifs 2017-08-31 2017-09-01
2642253 2642253 CORPACTION ADD 46429B135 04 X 2017-08-02 46429B135 12 2017-08-02 20170802.ifs 2017-08-02 2017-08-03
2635764 2635764 DIVIDEND ADD 46429B135 0 0 1 0 .049481 00 2017-08-01 2017-08-03 2017-08-07 2017-07-31 0 2017-07-31 ? 0 0005474079 20170731.ifs 2017-07-31 2017-08-01
2615693 2615693 DIVIDEND ADD 46429B135 0 0 1 0 .053949 00 2017-07-06 2017-07-10 2017-07-12 2017-07-05 0 2017-07-05 ? 0 0005466359 20170705.ifs 2017-07-05 2017-07-06
2578224 2578224 DIVIDEND ADD 46429B135 0 0 1 0 .059522 00 2017-06-01 2017-06-05 2017-06-07 2017-05-31 0 2017-05-31 ? 0 0005440221 20170531.ifs 2017-05-31 2017-06-01
2556490 2556490 DIVIDEND ADD 46429B135 0 0 1 0 .066022 00 2017-05-02 2017-05-04 2017-05-08 2017-05-01 0 2017-05-01 ? 0 0005431218 20170501.ifs 2017-05-01 2017-05-02
2527958 2527958 DIVIDEND ADD 46429B135 0 0 1 0 .073236 00 2017-04-03 2017-04-05 2017-04-07 2017-03-31 0 2017-03-31 ? 0 0005412452 20170331.ifs 2017-03-31 2017-04-01
2499516 2499516 DIVIDEND ADD 46429B135 0 0 1 0 .073236 00 2017-03-01 2017-03-03 2017-03-07 2017-02-28 0 2017-02-28 ? 0 0005393518 20170228.ifs 2017-02-28 2017-03-01
2477905 2477905 DIVIDEND ADD 46429B135 0 0 1 0 .071374 00 2017-02-01 2017-02-03 2017-02-07 2017-01-31 0 2017-01-31 ? 0 0005380372 20170131.ifs 2017-01-31 2017-02-01
2391634 2391634 DIVIDEND ADD 46429B135 0 0 1 0 .052545 00 2016-12-22 2016-12-27 2016-12-29 2016-12-21 0 2016-12-21 ? 0 0005349862 20161221.ifs 2016-12-21 2016-12-22
2352955 2352955 DIVIDEND ADD 46429B135 0 0 1 0 .068241 00 2016-12-01 2016-12-05 2016-12-07 2016-11-30 0 2016-11-30 ? 0 0005316825 20161130.ifs 2016-11-30 2016-12-01
2331251 2331251 DIVIDEND ADD 46429B135 0 0 1 0 .073841 00 2016-11-01 2016-11-03 2016-11-07 2016-10-31 0 2016-10-31 ? 0 0005303453 20161031.ifs 2016-10-31 2016-11-01
2308955 2308955 DIVIDEND ADD 46429B135 0 0 1 0 .081532 00 2016-10-03 2016-10-05 2016-10-07 2016-09-30 0 2016-09-30 ? 0 0005290204 20160930.ifs 2016-09-30 2016-10-01
2281873 2281873 DIVIDEND ADD 46429B135 0 0 1 0 .089992 00 2016-09-01 2016-09-06 2016-09-08 2016-08-31 0 2016-08-31 ? 0 0005271917 20160831.ifs 2016-08-31 2016-09-01
2245709 2245709 DIVIDEND ADD 46429B135 0 0 1 0 .03329 00 2016-07-06 2016-07-08 2016-07-12 2016-07-05 0 2016-07-05 ? 0 0005249843 20160705.ifs 2016-07-05 2016-07-06
2206938 2206938 DIVIDEND ADD 46429B135 0 0 1 0 .033603 00 2016-06-01 2016-06-03 2016-06-07 2016-05-31 0 2016-05-31 ? 0 0005223842 20160531.ifs 2016-05-31 2016-06-01
2183330 2183330 DIVIDEND ADD 46429B135 0 0 1 0 .015359 00 2016-05-02 2016-05-04 2016-05-06 2016-04-29 0 2016-04-29 ? 0 0005210789 20160429.ifs 2016-04-29 2016-04-30
2150207 2150207 DIVIDEND ADD 46429B135 0 0 1 0 .08647 00 2016-04-01 2016-04-05 2016-04-07 2016-03-31 0 2016-03-31 ? 0 0005196420 20160331.ifs 2016-03-31 2016-04-01
2122805 2122805 DIVIDEND ADD 46429B135 0 0 1 0 .08647 00 2016-03-01 2016-03-03 2016-03-07 2016-02-29 0 2016-02-29 ? 0 0005178481 20160229.ifs 2016-02-29 2016-03-01
2102240 2102240 DIVIDEND ADD 46429B135 0 0 1 0 .07884 00 2016-02-01 2016-02-03 2016-02-05 2016-01-29 0 2016-01-29 ? 0 0005165674 20160129.ifs 2016-01-29 2016-01-30
2063455 2063455 DIVIDEND ADD 46429B135 0 0 1 0 .22062 00 2015-12-24 2015-12-29 2015-12-31 2015-12-23 0 2015-12-23 ? 0 0005138827 20151223.ifs 2015-12-23 2015-12-24
2001343 2001343 DIVIDEND ADD 46429B135 0 0 1 0 .076212 00 2015-11-02 2015-11-04 2015-11-06 2015-10-30 0 2015-10-30 ? 0 0005084950 20151030.ifs 2015-10-30 2015-10-31
1978123 1978123 DIVIDEND ADD 46429B135 0 0 1 0 .076212 00 2015-10-01 2015-10-05 2015-10-07 2015-09-30 0 2015-09-30 ? 0 0005071647 20150930.ifs 2015-09-30 2015-10-01
1952319 1952319 DIVIDEND ADD 46429B135 0 0 1 0 .0701 00 2015-09-01 2015-09-03 2015-09-08 2015-08-31 0 2015-08-31 ? 0 0005053689 20150831.ifs 2015-08-31 2015-09-01
1933211 1933211 DIVIDEND ADD 46429B135 0 0 1 0 .060784 00 2015-08-04 2015-08-06 2015-08-10 2015-08-03 0 2015-08-03 ? 0 0005043476 20150803.ifs 2015-08-03 2015-08-04
1907228 1907228 DIVIDEND ADD 46429B135 0 0 1 0 .035308 00 2015-07-02 2015-07-07 2015-07-09 2015-07-01 0 2015-07-01 ? 0 0005029518 20150701.ifs 2015-07-01 2015-07-02
1874181 1874181 DIVIDEND ADD 46429B135 0 0 1 0 .043448 00 2015-06-01 2015-06-03 2015-06-05 2015-05-29 0 2015-05-29 ? 0 0005006148 20150529.ifs 2015-05-29 2015-05-30
1852288 1852288 DIVIDEND ADD 46429B135 0 0 1 0 .069897 00 2015-05-01 2015-05-05 2015-05-07 2015-04-30 0 2015-04-30 ? 0 0004991993 20150430.ifs 2015-04-30 2015-05-01
1827655 1827655 DIVIDEND ADD 46429B135 0 0 1 0 .077337 00 2015-04-01 2015-04-06 2015-04-08 2015-03-31 0 2015-03-31 ? 0 0004977813 20150331.ifs 2015-03-31 2015-04-01
1798426 1798426 DIVIDEND ADD 46429B135 0 0 1 0 .069337 00 2015-03-02 2015-03-04 2015-03-06 2015-02-27 0 2015-02-27 ? 0 0004959766 20150227.ifs 2015-02-27 2015-02-28
1779473 1779473 DIVIDEND ADD 46429B135 0 0 1 0 .069999 00 2015-02-02 2015-02-04 2015-02-06 2015-01-30 0 2015-01-30 ? 0 0004946680 20150130.ifs 2015-01-30 2015-01-31
1740519 1740519 DIVIDEND ADD 46429B135 0 0 1 0 .061653 00 2014-12-24 2014-12-29 2014-12-31 2014-12-23 0 2014-12-23 ? 0 0004919649 20141223.ifs 2014-12-23 2014-12-24
1691118 1691118 DIVIDEND ADD 46429B135 0 0 1 0 .065883 00 2014-12-01 2014-12-03 2014-12-05 2014-11-28 0 2014-11-28 ? 0 0004878029 20141128.ifs 2014-11-28 2014-11-29
1668564 1668564 DIVIDEND ADD 46429B135 0 0 1 0 .059919 00 2014-11-03 2014-11-05 2014-11-07 2014-10-31 0 2014-10-31 ? 0 0004865023 20141031.ifs 2014-10-31 2014-11-01
1644905 1644905 DIVIDEND ADD 46429B135 0 0 1 0 .06011 00 2014-10-01 2014-10-03 2014-10-07 2014-09-30 0 2014-09-30 ? 0 0004852012 20140930.ifs 2014-09-30 2014-10-01
1617523 1617523 DIVIDEND ADD 46429B135 0 0 1 0 .06001 00 2014-09-02 2014-09-04 2014-09-08 2014-08-29 0 2014-08-29 ? 0 0004834334 20140829.ifs 2014-08-29 2014-08-30
1592616 1592616 DIVIDEND ADD 46429B135 0 0 1 0 .079158 00 2014-08-01 2014-08-05 2014-08-07 2014-07-31 0 2014-07-31 ? 0 0004820450 20140731.ifs 2014-07-31 2014-08-01
1567494 1567494 DIVIDEND ADD 46429B135 0 0 1 0 .076767 00 2014-07-01 2014-07-03 2014-07-08 2014-06-30 0 2014-06-30 ? 0 0004806907 20140630.ifs 2014-06-30 2014-07-01
1535143 1535143 DIVIDEND ADD 46429B135 0 0 1 0 .079509 00 2014-06-02 2014-06-04 2014-06-06 2014-05-30 0 2014-05-30 ? 0 0004787705 20140530.ifs 2014-05-30 2014-05-31
1506433 1506433 DIVIDEND ADD 46429B135 0 0 1 0 .089051 00 2014-05-01 2014-05-05 2014-05-07 2014-04-30 0 2014-04-30 ? 0 0004773939 20140430.ifs 2014-04-30 2014-05-01
1482681 1482681 DIVIDEND ADD 46429B135 0 0 1 0 .127384 00 2014-04-01 2014-04-03 2014-04-07 2014-03-31 0 2014-03-31 ? 0 0004759608 20140331.ifs 2014-03-31 2014-04-01
1453604 1453604 DIVIDEND ADD 46429B135 0 0 1 0 .118968 00 2014-03-03 2014-03-05 2014-03-07 2014-02-28 0 2014-02-28 ? 0 0004741981 20140228.ifs 2014-02-28 2014-03-01
1432807 1432807 DIVIDEND ADD 46429B135 0 0 1 0 .075844 00 2014-02-03 2014-02-05 2014-02-07 2014-01-31 0 2014-01-31 ? 0 0004728649 20140131.ifs 2014-01-31 2014-02-01
1395357 1395357 DIVIDEND ADD 46429B135 0 0 1 0 .3005 00 2013-12-26 2013-12-30 2014-01-02 2013-12-24 0 2013-12-24 ? 0 0004703495 20131224.ifs 2013-12-24 2013-12-25
1349802 1349802 DIVIDEND ADD 46429B135 8 0 1 9 .095923 95 2013-12-02 2013-12-04 2013-12-06 2013-11-29 0 2013-11-29 ? 1 0004663544 20131129.ifs 2013-11-29 2013-11-30
1349803 1349803 DIVIDEND ADD 46429B135 0 0 1 0 .158099 00 2013-12-02 2013-12-04 2013-12-06 2013-11-29 0 2013-11-29 ? 0 0004663542 20131129.ifs 2013-11-29 2013-11-30
1328127 1328127 DIVIDEND ADD 46429B135 0 0 1 0 .031593 00 2013-11-01 2013-11-05 2013-11-07 2013-10-31 0 2013-10-31 ? 0 0004650306 20131031.ifs 2013-10-31 2013-11-01
1302961 1302961 DIVIDEND ADD 46429B135 0 0 1 0 .097435 00 2013-10-01 2013-10-03 2013-10-07 2013-09-30 0 2013-09-30 ? 0 0004637334 20130930.ifs 2013-09-30 2013-10-01
1275272 1275272 DIVIDEND ADD 46429B135 0 0 1 0 .111844 00 2013-09-03 2013-09-05 2013-09-09 2013-08-30 0 2013-08-30 ? 0 0004620933 20130830.ifs 2013-08-30 2013-08-31
1251963 1251963 DIVIDEND ADD 46429B135 0 0 1 0 .045253 00 2013-08-01 2013-08-05 2013-08-07 2013-07-31 0 2013-07-31 ? 0 0004607037 20130731.ifs 2013-07-31 2013-08-01
1227517 1227517 CORPACTION ADD 46429B135 04 # 2013-07-01 46429B135 04 ? 20130701.ifs 2013-07-01 2013-07-02
1227518 1227518 CORPACTIONAUX ADD 46429B135 04 2013-07-01 IPFF ISHARES TR S&P INTERNATION IPFF ISHARES TR ISHARES INTERNA 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1227519 1227519 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD 0 A 2011-11-17 ? 0 no no no 2011-11-17 2012-03-29 ? 20130701.ifs 2013-07-01 2013-07-02
1227520 1227519 EQUITY CHANGE 46429B135 ISHARES INTERNATIONAL PREFERRED STOCK ETF 0 A 2011-11-17 ? 0 no no no 2011-11-17 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1230253 1230253 DIVIDEND ADD 46429B135 0 0 1 0 .070381 00 2013-07-02 2013-07-05 2013-07-09 2013-07-01 0 2013-07-01 ? 0 0004597651 20130701.ifs 2013-07-01 2013-07-02
1198001 1198001 DIVIDEND ADD 46429B135 0 0 1 0 .179934 00 2013-06-03 2013-06-05 2013-06-07 2013-05-31 0 2013-05-31 ? 0 0004575963 20130531.ifs 2013-05-31 2013-06-01
1172345 1172345 DIVIDEND ADD 46429B135 0 0 1 0 .0328 00 2013-05-01 2013-05-03 2013-05-07 2013-04-30 0 2013-04-30 ? 0 0004563047 20130430.ifs 2013-04-30 2013-05-01
1145658 1145658 DIVIDEND ADD 46429B135 0 0 1 0 .174549 00 2013-04-01 2013-04-03 2013-04-05 2013-03-28 0 2013-03-28 ? 0 0004549280 20130328.ifs 2013-03-28 2013-03-29
1121380 1121380 DIVIDEND ADD 46429B135 0 0 1 0 .064307 00 2013-03-01 2013-03-05 2013-03-07 2013-02-28 0 2013-02-28 ? 0 0004532877 20130228.ifs 2013-02-28 2013-03-01
1101194 1101194 DIVIDEND ADD 46429B135 0 0 1 0 .039663 00 2013-02-01 2013-02-05 2013-02-07 2013-01-31 0 2013-01-31 ? 0 0004520580 20130131.ifs 2013-01-31 2013-02-01
1059302 1059302 DIVIDEND ADD 46429B135 0 0 1 0 .07973 00 2012-12-26 2012-12-28 2013-01-02 2012-12-24 0 2012-12-24 ? 0 0004494363 20121224.ifs 2012-12-24 2012-12-25
1020327 1020327 DIVIDEND ADD 46429B135 0 0 1 0 .166529 00 2012-12-03 2012-12-05 2012-12-07 2012-11-30 0 2012-11-30 ? 0 0004463937 20121130.ifs 2012-11-30 2012-12-01
997554 997554 DIVIDEND ADD 46429B135 0 0 1 0 .050109 00 2012-11-01 2012-11-05 2012-11-07 2012-10-31 0 2012-10-31 ? 0 0004449954 20121031.ifs 2012-10-31 2012-11-01
969927 969927 DIVIDEND ADD 46429B135 0 0 1 0 .091231 00 2012-10-01 2012-10-03 2012-10-05 2012-09-28 0 2012-09-28 ? 0 0004436856 20120928.ifs 2012-09-28 2012-09-29
944219 944219 DIVIDEND ADD 46429B135 0 0 1 0 .118444 00 2012-09-04 2012-09-06 2012-09-10 2012-08-31 0 2012-08-31 ? 0 0004420810 20120831.ifs 2012-08-31 2012-09-01
900162 900162 DIVIDEND ADD 46429B135 0 0 1 0 .063221 00 2012-07-02 2012-07-05 2012-07-09 2012-06-29 0 2012-06-29 ? 0 0004394757 20120629.ifs 2012-06-29 2012-06-30
872293 872293 DIVIDEND ADD 46429B135 0 0 1 0 .122855 00 2012-06-01 2012-06-05 2012-06-07 2012-05-31 0 2012-05-31 ? 0 0004379020 20120531.ifs 2012-05-31 2012-06-01
847408 847408 DIVIDEND ADD 46429B135 0 0 1 0 .062625 00 2012-05-01 2012-05-03 2012-05-07 2012-04-30 0 2012-04-30 ? 0 0004366301 20120430.ifs 2012-04-30 2012-05-01
819024 819024 DIVIDEND ADD 46429B135 0 0 1 0 .182795 00 2012-04-02 2012-04-04 2012-04-09 2012-03-30 0 2012-03-30 ? 0 0004353466 20120330.ifs 2012-03-30 2012-03-31
812494 812494 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD 0 A 2011-11-17 ? 0 no no no 2011-11-17 2011-11-17 ? 20120329.ifs 2012-03-29 2012-03-30
812495 812494 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD 0 A 2011-11-17 ? 0 no no no 2011-11-17 2012-03-29 ? 20120329.ifs 2012-03-29 2012-03-30
812496 812496 DIVIDEND CHANGE 46429B135 0 0 1 0 .095592 00 2011-12-27 2011-12-29 2012-01-04 2011-12-23 1 2011-12-23 2012-01-31 0 0004303139 20120329.ifs 2012-03-29 2012-03-30
812497 812496 DIVIDEND CHANGE 46429B135 0 0 1 0 .095592 00 2011-12-27 2011-12-29 2012-01-04 2011-12-23 1 2011-12-23 2012-03-29 0 0004303139 20120329.ifs 2012-03-29 2012-03-30
812498 812498 EXCHANGE CHANGE 46429B135 04 2011-11-17 2012-03-28 IPFF 0 A 2011-11-17 2012-03-29 20120329.ifs 2012-03-29 2012-03-30
812499 812498 EXCHANGE CHANGE 46429B135 04 2011-11-17 2012-03-28 IPFF 0 A 2011-11-17 2012-03-29 20120329.ifs 2012-03-29 2012-03-30
812500 812500 EXCHANGE CHANGE 46429B135 04 2011-11-17 2012-03-28 IPFF 0 A 2011-11-17 2012-03-29 20120329.ifs 2012-03-29 2012-03-30
812501 812500 EXCHANGE CHANGE 46429B135 04 2011-11-17 2012-03-28 IPFF 0 A 2011-11-17 2012-03-29 20120329.ifs 2012-03-29 2012-03-30
789953 789953 DIVIDEND ADD 46429B135 0 0 1 0 .080195 00 2012-03-01 2012-03-05 2012-03-07 2012-02-29 0 2012-02-29 ? 0 0004337644 20120229.ifs 2012-02-29 2012-03-01
767149 767149 DIVIDEND ADD 46429B135 0 0 1 0 .035682 00 2012-02-01 2012-02-03 2012-02-07 2012-01-31 0 2012-01-31 ? 0 0004325399 20120131.ifs 2012-01-31 2012-02-01
767150 767150 DIVIDEND CHANGE 46429B135 0 0 1 4 .095592 00 2011-12-27 2011-12-29 2012-01-04 2011-12-23 0 2011-12-23 ? 0 0004303139 20120131.ifs 2012-01-31 2012-02-01
767151 767150 DIVIDEND CHANGE 46429B135 0 0 1 0 .095592 00 2011-12-27 2011-12-29 2012-01-04 2011-12-23 1 2011-12-23 2012-01-31 0 0004303139 20120131.ifs 2012-01-31 2012-02-01
736805 736805 DIVIDEND ADD 46429B135 0 0 1 4 .095592 00 2011-12-27 2011-12-29 2012-01-04 2011-12-23 0 2011-12-23 ? 0 0004303139 20111223.ifs 2011-12-23 2011-12-24
696127 696127 EQUITY ADD 46429B135 S&P INTL PFD STK INDEX FD N 7 2011-11-17 ? 0 no no no 2011-11-17 ? ? 20111117.ifs 2011-11-17 2011-11-18
696128 696128 EXCHANGE ADD 46429B135 04 2011-11-17 2011-11-17 IPFF 0 A 2011-11-17 ? 20111117.ifs 2011-11-17 2011-11-18
696227 696227 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD N 7 2011-11-17 ? 0 no no no 2011-11-17 ? ? 20111117.ifs 2011-11-17 2011-11-18
696228 696227 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD N A 2011-11-17 ? 0 no no no 2011-11-17 2011-11-17 ? 20111117.ifs 2011-11-17 2011-11-18
696603 696603 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD N A 2011-11-17 ? 0 no no no 2011-11-17 2011-11-17 ? 20111117.ifs 2011-11-17 2011-11-18
696604 696603 EQUITY CHANGE 46429B135 S&P INTL PFD STK INDEX FD 0 A 2011-11-17 ? 0 no no no 2011-11-17 2011-11-17 ? 20111117.ifs 2011-11-17 2011-11-18


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