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 IAT Charts Yahoo IAT Profile
  Run IAT Institutional Summary Yahoo IAT Key Statisics
  J3 Open IAT Pricing Yahoo IAT Pricing
  J3 IAT Insider   J3 IAT Insitutions Yahoo IAT Holders
     
  Open up Sector/Exchange Map Fidelity IAT Lookup
  Open up sec.gov For Market Ca MSN IAT 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 : 180 174   Update Insititution By Cusips
% Owned by Insititutions: 26.31 % 29.49 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:152112
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
5573851 5573851 DIVIDEND ADD 464288778 0 0 1 0 .33964 00 2024-06-11 2024-06-11 2024-06-17 2024-06-10 0 2024-06-10 ? 0 0006931037 20240610.ifs 2024-06-10 2024-06-11
5519555 5519555 DIVIDEND ADD 464288778 0 0 1 0 .30376 00 2024-03-21 2024-03-22 2024-03-27 2024-03-20 0 2024-03-20 ? 0 0006892633 20240320.ifs 2024-03-20 2024-03-21
5450362 5450362 DIVIDEND ADD 464288778 0 0 1 0 .481558 00 2023-12-20 2023-12-21 2023-12-27 2023-12-19 0 2023-12-19 ? 0 0006840552 20231219.ifs 2023-12-19 2023-12-20
5380083 5380083 DIVIDEND ADD 464288778 0 0 1 0 .498787 00 2023-09-26 2023-09-27 2023-10-02 2023-09-25 0 2023-09-25 ? 0 0006787311 20230925.ifs 2023-09-25 2023-09-26
5307595 5307595 DIVIDEND ADD 464288778 0 0 1 0 .310132 00 2023-06-07 2023-06-08 2023-06-13 2023-06-06 0 2023-06-06 ? 0 0006737004 20230606.ifs 2023-06-06 2023-06-07
5252900 5252900 DIVIDEND ADD 464288778 0 0 1 0 .198082 00 2023-03-23 2023-03-24 2023-03-29 2023-03-22 0 2023-03-22 ? 0 0006698863 20230322.ifs 2023-03-22 2023-03-23
5162428 5162428 DIVIDEND ADD 464288778 0 0 1 0 .464892 00 2022-12-13 2022-12-14 2022-12-19 2022-12-12 0 2022-12-12 ? 0 0006629501 20221212.ifs 2022-12-12 2022-12-13
5103569 5103569 DIVIDEND ADD 464288778 0 0 1 0 .430175 00 2022-09-26 2022-09-27 2022-09-30 2022-09-23 0 2022-09-23 ? 0 0006587986 20220923.ifs 2022-09-23 2022-09-24
5030147 5030147 DIVIDEND ADD 464288778 0 0 1 0 .340699 00 2022-06-09 2022-06-10 2022-06-15 2022-06-08 0 2022-06-08 ? 0 0006536791 20220608.ifs 2022-06-08 2022-06-09
4976135 4976135 DIVIDEND ADD 464288778 0 0 1 0 .250542 00 2022-03-24 2022-03-25 2022-03-30 2022-03-23 0 2022-03-23 ? 0 0006498172 20220323.ifs 2022-03-23 2022-03-24
4877097 4877097 DIVIDEND ADD 464288778 0 0 1 0 .39812 00 2021-12-13 2021-12-14 2021-12-17 2021-12-10 0 2021-12-10 ? 0 0006417592 20211210.ifs 2021-12-10 2021-12-11
4808650 4808650 DIVIDEND ADD 464288778 0 0 1 0 .329555 00 2021-09-24 2021-09-27 2021-09-30 2021-09-23 0 2021-09-23 ? 0 0006371658 20210923.ifs 2021-09-23 2021-09-24
4725924 4725924 DIVIDEND ADD 464288778 0 0 1 0 .248998 00 2021-06-10 2021-06-11 2021-06-16 2021-06-09 0 2021-06-09 ? 0 0006320417 20210609.ifs 2021-06-09 2021-06-10
4661001 4661001 DIVIDEND ADD 464288778 0 0 1 0 .184754 00 2021-03-25 2021-03-26 2021-03-31 2021-03-24 0 2021-03-24 ? 0 0006281429 20210324.ifs 2021-03-24 2021-03-25
4539145 4539145 DIVIDEND ADD 464288778 0 0 1 0 .38229 00 2020-12-14 2020-12-15 2020-12-18 2020-12-11 0 2020-12-11 ? 0 0006209251 20201211.ifs 2020-12-11 2020-12-12
4467368 4467368 DIVIDEND ADD 464288778 0 0 1 0 .373492 00 2020-09-23 2020-09-24 2020-09-29 2020-09-22 0 2020-09-22 ? 0 0006161957 20200922.ifs 2020-09-22 2020-09-23
4391025 4391025 DIVIDEND ADD 464288778 0 0 1 0 .277124 00 2020-06-15 2020-06-16 2020-06-19 2020-06-12 0 2020-06-12 ? 0 0006112124 20200612.ifs 2020-06-12 2020-06-13
4252414 4252414 DIVIDEND ADD 464288778 0 0 1 0 .270098 00 2020-03-25 2020-03-26 2020-03-31 2020-03-24 0 2020-03-24 ? 0 0006072821 20200324.ifs 2020-03-24 2020-03-25
4252638 4252638 DIVIDEND ADD 464288778 0 0 1 0 .270098 00 2020-03-25 2020-03-26 2020-03-31 2020-03-24 0 2020-03-24 ? 0 0006072821 20200324.ifs 2020-03-24 2020-03-25
4067961 4067961 DIVIDEND ADD 464288778 0 0 1 0 .40554 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000072 20191213.ifs 2019-12-13 2019-12-14
4068040 4068040 DIVIDEND ADD 464288778 0 0 1 0 .40554 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000072 20191213.ifs 2019-12-13 2019-12-14
3933974 3933974 DIVIDEND ADD 464288778 0 0 1 0 .353435 00 2019-09-24 2019-09-25 2019-09-30 2019-09-23 0 2019-09-23 ? 0 0005949066 20190923.ifs 2019-09-23 2019-09-24
3933975 3933975 DIVIDEND ADD 464288778 0 0 1 0 .353435 00 2019-09-24 2019-09-25 2019-09-30 2019-09-23 0 2019-09-23 ? 0 0005949066 20190923.ifs 2019-09-23 2019-09-24
3780981 3780981 DIVIDEND ADD 464288778 0 0 1 0 .294216 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898632 20190614.ifs 2019-06-14 2019-06-15
3781004 3781004 DIVIDEND ADD 464288778 0 0 1 0 .294216 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898632 20190614.ifs 2019-06-14 2019-06-15
3638075 3638075 DIVIDEND ADD 464288778 0 0 1 0 .21424 00 2019-03-20 2019-03-21 2019-03-26 2019-03-19 0 2019-03-19 ? 0 0005854893 20190319.ifs 2019-03-19 2019-03-20
3638078 3638078 DIVIDEND ADD 464288778 0 0 1 0 .21424 00 2019-03-20 2019-03-21 2019-03-26 2019-03-19 0 2019-03-19 ? 0 0005854893 20190319.ifs 2019-03-19 2019-03-20
3442949 3442949 DIVIDEND ADD 464288778 0 0 1 0 .360839 00 2018-12-17 2018-12-18 2018-12-21 2018-12-14 0 2018-12-14 ? 0 0005781484 20181214.ifs 2018-12-14 2018-12-15
3443779 3443779 DIVIDEND ADD 464288778 0 0 1 0 .360839 00 2018-12-17 2018-12-18 2018-12-21 2018-12-14 0 2018-12-14 ? 0 0005781484 20181214.ifs 2018-12-14 2018-12-15
3299141 3299141 DIVIDEND ADD 464288778 0 0 1 0 .255574 00 2018-09-26 2018-09-27 2018-10-02 2018-09-25 0 2018-09-25 ? 0 0005728802 20180925.ifs 2018-09-25 2018-09-26
3299248 3299248 DIVIDEND ADD 464288778 0 0 1 0 .255574 00 2018-09-26 2018-09-27 2018-10-02 2018-09-25 0 2018-09-25 ? 0 0005728802 20180925.ifs 2018-09-25 2018-09-26
3000793 3000793 DIVIDEND ADD 464288778 0 0 1 0 .14933 00 2018-03-22 2018-03-23 2018-03-28 2018-03-21 0 2018-03-21 ? 0 0005632749 20180321.ifs 2018-03-21 2018-03-22
3000814 3000814 DIVIDEND ADD 464288778 0 0 1 0 .14933 00 2018-03-22 2018-03-23 2018-03-28 2018-03-21 0 2018-03-21 ? 0 0005632749 20180321.ifs 2018-03-21 2018-03-22
2839566 2839566 DIVIDEND ADD 464288778 0 0 1 0 .261601 00 2017-12-19 2017-12-20 2017-12-26 2017-12-18 0 2017-12-18 ? 0 0005564356 20171218.ifs 2017-12-18 2017-12-19
2686745 2686745 DIVIDEND ADD 464288778 0 0 1 0 .20504 00 2017-09-26 2017-09-27 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005502008 20170925.ifs 2017-09-25 2017-09-26
2686792 2686792 DIVIDEND ADD 464288778 0 0 1 0 .20504 00 2017-09-26 2017-09-27 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005502008 20170925.ifs 2017-09-25 2017-09-26
2601187 2601187 DIVIDEND ADD 464288778 0 0 1 0 .182649 00 2017-06-27 2017-06-29 2017-06-30 2017-06-26 0 2017-06-26 ? 0 0005454920 20170626.ifs 2017-06-26 2017-06-27
2518854 2518854 DIVIDEND ADD 464288778 0 0 1 0 .116571 00 2017-03-24 2017-03-28 2017-03-30 2017-03-23 0 2017-03-23 ? 0 0005406969 20170323.ifs 2017-03-23 2017-03-24
2439862 2439862 EQUITY CHANGE 464288778 ISHARES U.S. REGIONAL BANKS ETF 0 A 2006-05-05 ? 0 no no no 2006-05-08 2013-07-01 ? 20170123.ifs 2017-01-23 2017-01-24
2439863 2439862 EQUITY CHANGE 464288778 ISHARES U.S. REGIONAL BANKS ETF 0 A 2006-05-05 ? 4 no no no 2006-05-08 2013-07-01 ? 20170123.ifs 2017-01-23 2017-01-24
2388207 2388207 DIVIDEND ADD 464288778 0 0 1 0 .172905 00 2016-12-21 2016-12-23 2016-12-28 2016-12-20 0 2016-12-20 ? 0 0005346378 20161220.ifs 2016-12-20 2016-12-21
2301176 2301176 DIVIDEND ADD 464288778 0 0 1 0 .194966 00 2016-09-26 2016-09-28 2016-09-30 2016-09-23 0 2016-09-23 ? 0 0005285137 20160923.ifs 2016-09-23 2016-09-24
2225298 2225298 DIVIDEND ADD 464288778 0 0 1 0 .178342 00 2016-06-21 2016-06-23 2016-06-27 2016-06-20 0 2016-06-20 ? 0 0005235506 20160620.ifs 2016-06-20 2016-06-21
2140467 2140467 DIVIDEND ADD 464288778 0 0 1 0 .143024 00 2016-03-23 2016-03-28 2016-03-30 2016-03-22 0 2016-03-22 ? 0 0005190704 20160322.ifs 2016-03-22 2016-03-23
2063473 2063473 DIVIDEND ADD 464288778 0 0 1 0 .188883 00 2015-12-24 2015-12-29 2015-12-31 2015-12-23 0 2015-12-23 ? 0 0005138781 20151223.ifs 2015-12-23 2015-12-24
1972241 1972241 DIVIDEND ADD 464288778 0 0 1 0 .134947 00 2015-09-25 2015-09-29 2015-10-01 2015-09-24 0 2015-09-24 ? 0 0005067362 20150924.ifs 2015-09-24 2015-09-25
1893622 1893622 DIVIDEND ADD 464288778 0 0 1 0 .200078 00 2015-06-24 2015-06-26 2015-06-30 2015-06-23 0 2015-06-23 ? 0 0005018437 20150623.ifs 2015-06-23 2015-06-24
1819283 1819283 DIVIDEND ADD 464288778 0 0 1 0 .099533 00 2015-03-25 2015-03-27 2015-03-31 2015-03-24 0 2015-03-24 ? 0 0004972930 20150324.ifs 2015-03-24 2015-03-25
1740537 1740537 DIVIDEND ADD 464288778 0 0 1 0 .20513 00 2014-12-24 2014-12-29 2014-12-31 2014-12-23 0 2014-12-23 ? 0 0004919684 20141223.ifs 2014-12-23 2014-12-24
1636512 1636512 DIVIDEND ADD 464288778 0 0 1 0 .151602 00 2014-09-24 2014-09-26 2014-09-30 2014-09-23 0 2014-09-23 ? 0 0004846725 20140923.ifs 2014-09-23 2014-09-24
1557038 1557038 DIVIDEND ADD 464288778 0 0 1 0 .141215 00 2014-06-24 2014-06-26 2014-06-30 2014-06-23 0 2014-06-23 ? 0 0004800694 20140623.ifs 2014-06-23 2014-06-24
1474533 1474533 DIVIDEND ADD 464288778 0 0 1 0 .08933 00 2014-03-25 2014-03-27 2014-03-31 2014-03-24 0 2014-03-24 ? 0 0004754626 20140324.ifs 2014-03-24 2014-03-25
1389361 1389361 DIVIDEND ADD 464288778 0 0 1 0 .193523 00 2013-12-23 2013-12-26 2013-12-30 2013-12-20 0 2013-12-20 ? 0 0004698572 20131220.ifs 2013-12-20 2013-12-21
1294251 1294251 DIVIDEND ADD 464288778 0 0 1 0 .119208 00 2013-09-24 2013-09-26 2013-09-30 2013-09-23 0 2013-09-23 ? 0 0004632702 20130923.ifs 2013-09-23 2013-09-24
1227061 1227061 CORPACTION ADD 464288778 04 # 2013-07-01 464288778 04 ? 20130701.ifs 2013-07-01 2013-07-02
1227062 1227062 CORPACTIONAUX ADD 464288778 04 2013-07-01 IAT ISHARES TR ISHARES TRUST - IAT ISHARES TR ISHARES U.S. RE 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1227063 1227063 EQUITY CHANGE 464288778 DJ US REGNL BKS INDEX FD 0 A 2006-05-05 ? 0 no no no 2006-05-08 2008-03-13 ? 20130701.ifs 2013-07-01 2013-07-02
1227064 1227063 EQUITY CHANGE 464288778 ISHARES U.S. REGIONAL BANKS ETF 0 A 2006-05-05 ? 0 no no no 2006-05-08 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1217521 1217521 DIVIDEND ADD 464288778 0 0 1 0 .124951 00 2013-06-26 2013-06-28 2013-07-02 2013-06-25 0 2013-06-25 ? 0 0004588948 20130625.ifs 2013-06-25 2013-06-26
1140190 1140190 DIVIDEND ADD 464288778 0 0 1 0 .078 00 2013-03-25 2013-03-27 2013-04-01 2013-03-22 0 2013-03-22 ? 0 0004545080 20130322.ifs 2013-03-22 2013-03-23
1060967 1060967 DIVIDEND ADD 464288778 0 0 1 9 .012303 03 2012-12-27 2012-12-31 2013-01-03 2012-12-26 0 2012-12-26 ? 0 0004496066 20121226.ifs 2012-12-26 2012-12-27
1047868 1047868 DIVIDEND ADD 464288778 0 0 1 0 .170579 00 2012-12-19 2012-12-21 2012-12-26 2012-12-18 0 2012-12-18 ? 0 0004485665 20121218.ifs 2012-12-18 2012-12-19
963413 963413 DIVIDEND ADD 464288778 0 0 1 0 .101048 00 2012-09-25 2012-09-27 2012-10-01 2012-09-24 0 2012-09-24 ? 0 0004433161 20120924.ifs 2012-09-24 2012-09-25
887468 887468 DIVIDEND ADD 464288778 0 0 1 0 .129139 00 2012-06-19 2012-06-21 2012-06-25 2012-06-18 0 2012-06-18 ? 0 0004387640 20120618.ifs 2012-06-18 2012-06-19
809526 809526 DIVIDEND ADD 464288778 0 0 1 0 .066971 00 2012-03-26 2012-03-28 2012-03-30 2012-03-23 0 2012-03-23 ? 0 0004349518 20120323.ifs 2012-03-23 2012-03-24
650812 650812 DIVIDEND ADD 464288778 0 0 1 0 .113204 00 2011-09-23 2011-09-27 2011-09-29 2011-09-22 0 2011-09-22 ? 0 0004245766 20110922.ifs 2011-09-22 2011-09-23
568278 568278 DIVIDEND ADD 464288778 0 0 1 0 .099316 00 2011-06-24 2011-06-28 2011-06-30 2011-06-23 0 2011-06-23 ? 0 0004205166 20110623.ifs 2011-06-23 2011-06-24
479649 479649 DIVIDEND ADD 464288778 0 0 1 0 .061038 00 2011-03-25 2011-03-29 2011-03-31 2011-03-24 0 2011-03-24 ? 0 0004163800 20110324.ifs 2011-03-24 2011-03-25
389314 389314 DIVIDEND ADD 464288778 0 0 1 0 .081174 00 2010-12-22 2010-12-27 2010-12-29 2010-12-21 0 2010-12-21 ? 0 0004114324 20101221.ifs 2010-12-21 2010-12-22
302841 302841 DIVIDEND ADD 464288778 0 0 1 6 0 08 2010-09-23 2010-09-27 2010-09-29 2010-09-07 0 2010-09-07 ? 0 0004058551 20100907.ifs 2010-09-07 2010-09-08
226810 226810 DIVIDEND DELETE 464288778 0 0 1 6 0 08 2010-06-24 2010-06-28 2010-06-30 2010-06-03 0 2010-06-03 ? 0 0004016440 20100623.ifs 2010-06-23 2010-06-24
226811 226811 DIVIDEND ADD 464288778 0 0 1 0 .06587 00 2010-06-24 2010-06-28 2010-06-30 2010-06-03 1 2010-06-03 2010-06-23 0 0004016440 20100623.ifs 2010-06-23 2010-06-24
213134 213134 DIVIDEND ADD 464288778 0 0 1 6 0 08 2010-06-24 2010-06-28 2010-06-30 2010-06-03 0 2010-06-03 ? 0 0004016440 20100603.ifs 2010-06-03 2010-06-04
139610 139610 DIVIDEND DELETE 464288778 0 0 1 6 0 08 2010-03-25 2010-03-29 2010-03-31 2010-03-18 0 2010-03-18 ? 0 0003978841 20100324.ifs 2010-03-24 2010-04-07
139611 139611 DIVIDEND ADD 464288778 0 0 1 0 .05069 00 2010-03-25 2010-03-29 2010-03-31 2010-03-18 1 2010-03-18 2010-03-24 0 0003978841 20100324.ifs 2010-03-24 2010-04-07
134911 134911 DIVIDEND ADD 464288778 0 0 1 6 0 08 2010-03-25 2010-03-29 2010-03-31 2010-03-18 0 2010-03-18 ? 0 0003978841 20100318.ifs 2010-03-18 2010-04-07
62780 62780 DIVIDEND ADD 464288778 0 0 1 0 .08577 00 2009-12-23 2009-12-28 2009-12-30 2009-12-22 0 2009-12-22 ? 0 0003936254 20091222.ifs 2009-12-22 2010-04-07


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