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

the compid is:152117
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
5573846 5573846 DIVIDEND ADD 464288828 0 0 1 0 .027035 00 2024-06-11 2024-06-11 2024-06-17 2024-06-10 0 2024-06-10 ? 0 0006931030 20240610.ifs 2024-06-10 2024-06-11
5519550 5519550 DIVIDEND ADD 464288828 0 0 1 0 .105377 35 2024-03-21 2024-03-22 2024-03-27 2024-03-20 0 2024-03-20 ? 0 0006892626 20240320.ifs 2024-03-20 2024-03-21
5501486 5501486 DIVIDEND CHANGE 464288828 0 0 6 0 4 0 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 1 2023-12-22 2024-02-21 0 0006847469 20240222.ifs 2024-02-22 2024-02-23
5501487 5501486 DIVIDEND CHANGE 464288828 0 0 6 0 5 0 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 1 2023-12-22 2024-02-21 0 0006847469 20240222.ifs 2024-02-22 2024-02-23
5501322 5501322 DIVIDEND CHANGE 464288828 0 0 6 0 5 0 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 0 2023-12-22 ? 0 0006847469 20240221.ifs 2024-02-21 2024-02-22
5501323 5501322 DIVIDEND CHANGE 464288828 0 0 6 0 4 0 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 1 2023-12-22 2024-02-21 0 0006847469 20240221.ifs 2024-02-21 2024-02-22
5460758 5460758 DIVIDEND CHANGE 464288828 0 0 6 0 4 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 0 2023-12-22 ? 0 0006847469 20231226.ifs 2023-12-26 2023-12-27
5460759 5460758 DIVIDEND CHANGE 464288828 0 0 6 0 5 0 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 0 2023-12-22 ? 0 0006847469 20231226.ifs 2023-12-26 2023-12-27
5459598 5459598 DIVIDEND ADD 464288828 0 0 6 0 4 11 2024-03-07 2024-03-04 2024-03-06 2023-12-19 0 2023-12-22 ? 0 0006847469 20231222.ifs 2023-12-22 2023-12-23
5459599 5459599 SPLIT ADD 464288828 .2 2024-03-07 11 2023-12-22 ? 20231222.ifs 2023-12-22 2023-12-23
5450357 5450357 DIVIDEND ADD 464288828 0 0 1 0 .504815 00 2023-12-20 2023-12-21 2023-12-27 2023-12-19 0 2023-12-19 ? 0 0006840545 20231219.ifs 2023-12-19 2023-12-20
5380078 5380078 DIVIDEND ADD 464288828 0 0 1 0 .955631 00 2023-09-26 2023-09-27 2023-10-02 2023-09-25 0 2023-09-25 ? 0 0006787304 20230925.ifs 2023-09-25 2023-09-26
5307590 5307590 DIVIDEND ADD 464288828 0 0 1 0 .120602 00 2023-06-07 2023-06-08 2023-06-13 2023-06-06 0 2023-06-06 ? 0 0006736997 20230606.ifs 2023-06-06 2023-06-07
5252895 5252895 DIVIDEND ADD 464288828 0 0 1 0 .495355 00 2023-03-23 2023-03-24 2023-03-29 2023-03-22 0 2023-03-22 ? 0 0006698856 20230322.ifs 2023-03-22 2023-03-23
5162423 5162423 DIVIDEND ADD 464288828 0 0 1 0 .710886 00 2022-12-13 2022-12-14 2022-12-19 2022-12-12 0 2022-12-12 ? 0 0006629494 20221212.ifs 2022-12-12 2022-12-13
5103564 5103564 DIVIDEND ADD 464288828 0 0 1 0 .667646 00 2022-09-26 2022-09-27 2022-09-30 2022-09-23 0 2022-09-23 ? 0 0006587979 20220923.ifs 2022-09-23 2022-09-24
5030142 5030142 DIVIDEND ADD 464288828 0 0 1 0 .170201 00 2022-06-09 2022-06-10 2022-06-15 2022-06-08 0 2022-06-08 ? 0 0006536786 20220608.ifs 2022-06-08 2022-06-09
4976130 4976130 DIVIDEND ADD 464288828 0 0 1 0 .42687 00 2022-03-24 2022-03-25 2022-03-30 2022-03-23 0 2022-03-23 ? 0 0006498167 20220323.ifs 2022-03-23 2022-03-24
4877092 4877092 DIVIDEND ADD 464288828 0 0 1 0 .359507 00 2021-12-13 2021-12-14 2021-12-17 2021-12-10 0 2021-12-10 ? 0 0006417587 20211210.ifs 2021-12-10 2021-12-11
4808645 4808645 DIVIDEND ADD 464288828 0 0 1 0 .684083 00 2021-09-24 2021-09-27 2021-09-30 2021-09-23 0 2021-09-23 ? 0 0006371653 20210923.ifs 2021-09-23 2021-09-24
4725919 4725919 DIVIDEND ADD 464288828 0 0 1 0 .174456 00 2021-06-10 2021-06-11 2021-06-16 2021-06-09 0 2021-06-09 ? 0 0006320412 20210609.ifs 2021-06-09 2021-06-10
4660996 4660996 DIVIDEND ADD 464288828 0 0 1 0 .420315 00 2021-03-25 2021-03-26 2021-03-31 2021-03-24 0 2021-03-24 ? 0 0006281424 20210324.ifs 2021-03-24 2021-03-25
4539140 4539140 DIVIDEND ADD 464288828 0 0 1 0 .275225 00 2020-12-14 2020-12-15 2020-12-18 2020-12-11 0 2020-12-11 ? 0 0006209246 20201211.ifs 2020-12-11 2020-12-12
4467363 4467363 DIVIDEND ADD 464288828 0 0 1 0 .504201 00 2020-09-23 2020-09-24 2020-09-29 2020-09-22 0 2020-09-22 ? 0 0006161952 20200922.ifs 2020-09-22 2020-09-23
4391020 4391020 DIVIDEND ADD 464288828 0 0 1 0 .173845 00 2020-06-15 2020-06-16 2020-06-19 2020-06-12 0 2020-06-12 ? 0 0006112119 20200612.ifs 2020-06-12 2020-06-13
4252404 4252404 DIVIDEND ADD 464288828 0 0 1 0 .29865 00 2020-03-25 2020-03-26 2020-03-31 2020-03-24 0 2020-03-24 ? 0 0006072816 20200324.ifs 2020-03-24 2020-03-25
4252628 4252628 DIVIDEND ADD 464288828 0 0 1 0 .29865 00 2020-03-25 2020-03-26 2020-03-31 2020-03-24 0 2020-03-24 ? 0 0006072816 20200324.ifs 2020-03-24 2020-03-25
4067951 4067951 DIVIDEND ADD 464288828 0 0 1 0 .415253 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000077 20191213.ifs 2019-12-13 2019-12-14
4068030 4068030 DIVIDEND ADD 464288828 0 0 1 0 .415253 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000077 20191213.ifs 2019-12-13 2019-12-14
3933964 3933964 DIVIDEND ADD 464288828 0 0 1 0 .497595 00 2019-09-24 2019-09-25 2019-09-30 2019-09-23 0 2019-09-23 ? 0 0005949061 20190923.ifs 2019-09-23 2019-09-24
3933965 3933965 DIVIDEND ADD 464288828 0 0 1 0 .497595 00 2019-09-24 2019-09-25 2019-09-30 2019-09-23 0 2019-09-23 ? 0 0005949061 20190923.ifs 2019-09-23 2019-09-24
3780971 3780971 DIVIDEND ADD 464288828 0 0 1 0 .126706 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898627 20190614.ifs 2019-06-14 2019-06-15
3780994 3780994 DIVIDEND ADD 464288828 0 0 1 0 .126706 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898627 20190614.ifs 2019-06-14 2019-06-15
3638065 3638065 DIVIDEND ADD 464288828 0 0 1 0 .125104 00 2019-03-20 2019-03-21 2019-03-26 2019-03-19 0 2019-03-19 ? 0 0005854889 20190319.ifs 2019-03-19 2019-03-20
3638068 3638068 DIVIDEND ADD 464288828 0 0 1 0 .125104 00 2019-03-20 2019-03-21 2019-03-26 2019-03-19 0 2019-03-19 ? 0 0005854889 20190319.ifs 2019-03-19 2019-03-20
3504270 3504270 DIVIDEND ADD 464288828 0 0 1 0 6.212357 00 2018-12-28 2018-12-31 2019-01-04 2018-12-27 0 2018-12-27 ? 0 0005810387 20181227.ifs 2018-12-27 2018-12-28
3506019 3506019 DIVIDEND ADD 464288828 0 0 1 0 6.212357 00 2018-12-28 2018-12-31 2019-01-04 2018-12-27 0 2018-12-27 ? 0 0005810387 20181227.ifs 2018-12-27 2018-12-28
3442939 3442939 DIVIDEND ADD 464288828 0 0 1 0 .094887 00 2018-12-17 2018-12-18 2018-12-21 2018-12-14 0 2018-12-14 ? 0 0005781479 20181214.ifs 2018-12-14 2018-12-15
3443769 3443769 DIVIDEND ADD 464288828 0 0 1 0 .094887 00 2018-12-17 2018-12-18 2018-12-21 2018-12-14 0 2018-12-14 ? 0 0005781479 20181214.ifs 2018-12-14 2018-12-15
3299131 3299131 DIVIDEND ADD 464288828 0 0 1 0 .110338 00 2018-09-26 2018-09-27 2018-10-02 2018-09-25 0 2018-09-25 ? 0 0005728797 20180925.ifs 2018-09-25 2018-09-26
3299238 3299238 DIVIDEND ADD 464288828 0 0 1 0 .110338 00 2018-09-26 2018-09-27 2018-10-02 2018-09-25 0 2018-09-25 ? 0 0005728797 20180925.ifs 2018-09-25 2018-09-26
3000783 3000783 DIVIDEND ADD 464288828 0 0 1 0 .117031 00 2018-03-22 2018-03-23 2018-03-28 2018-03-21 0 2018-03-21 ? 0 0005632743 20180321.ifs 2018-03-21 2018-03-22
3000804 3000804 DIVIDEND ADD 464288828 0 0 1 0 .117031 00 2018-03-22 2018-03-23 2018-03-28 2018-03-21 0 2018-03-21 ? 0 0005632743 20180321.ifs 2018-03-21 2018-03-22
2839561 2839561 DIVIDEND ADD 464288828 0 0 1 0 .095021 00 2017-12-19 2017-12-20 2017-12-26 2017-12-18 0 2017-12-18 ? 0 0005564350 20171218.ifs 2017-12-18 2017-12-19
2686735 2686735 DIVIDEND ADD 464288828 0 0 1 0 .072357 00 2017-09-26 2017-09-27 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005502002 20170925.ifs 2017-09-25 2017-09-26
2686782 2686782 DIVIDEND ADD 464288828 0 0 1 0 .072357 00 2017-09-26 2017-09-27 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005502002 20170925.ifs 2017-09-25 2017-09-26
2601182 2601182 DIVIDEND ADD 464288828 0 0 1 0 .079257 00 2017-06-27 2017-06-29 2017-06-30 2017-06-26 0 2017-06-26 ? 0 0005454911 20170626.ifs 2017-06-26 2017-06-27
2518849 2518849 DIVIDEND ADD 464288828 0 0 1 0 .050699 00 2017-03-24 2017-03-28 2017-03-30 2017-03-23 0 2017-03-23 ? 0 0005406960 20170323.ifs 2017-03-23 2017-03-24
2439872 2439872 EQUITY CHANGE 464288828 ISHARES U.S. HEALTHCARE PROVIDERS ETF 0 A 2006-05-05 ? 0 no no no 2006-05-08 2013-07-01 ? 20170123.ifs 2017-01-23 2017-01-24
2439873 2439872 EQUITY CHANGE 464288828 ISHARES U.S. HEALTHCARE PROVIDERS ETF 0 A 2006-05-05 ? 4 no no no 2006-05-08 2013-07-01 ? 20170123.ifs 2017-01-23 2017-01-24
2388202 2388202 DIVIDEND ADD 464288828 0 0 1 0 .103918 00 2016-12-21 2016-12-23 2016-12-28 2016-12-20 0 2016-12-20 ? 0 0005346391 20161220.ifs 2016-12-20 2016-12-21
2301171 2301171 DIVIDEND ADD 464288828 0 0 1 0 .070888 00 2016-09-26 2016-09-28 2016-09-30 2016-09-23 0 2016-09-23 ? 0 0005285128 20160923.ifs 2016-09-23 2016-09-24
2225291 2225291 DIVIDEND ADD 464288828 0 0 1 0 .087694 00 2016-06-21 2016-06-23 2016-06-27 2016-06-20 0 2016-06-20 ? 0 0005235522 20160620.ifs 2016-06-20 2016-06-21
2140462 2140462 DIVIDEND ADD 464288828 0 0 1 0 .055679 00 2016-03-23 2016-03-28 2016-03-30 2016-03-22 0 2016-03-22 ? 0 0005190717 20160322.ifs 2016-03-22 2016-03-23
2063468 2063468 DIVIDEND ADD 464288828 0 0 1 0 .132518 00 2015-12-24 2015-12-29 2015-12-31 2015-12-23 0 2015-12-23 ? 0 0005138818 20151223.ifs 2015-12-23 2015-12-24
1972236 1972236 DIVIDEND ADD 464288828 0 0 1 0 .032967 00 2015-09-25 2015-09-29 2015-10-01 2015-09-24 0 2015-09-24 ? 0 0005067353 20150924.ifs 2015-09-24 2015-09-25
1893617 1893617 DIVIDEND ADD 464288828 0 0 1 0 .047959 00 2015-06-24 2015-06-26 2015-06-30 2015-06-23 0 2015-06-23 ? 0 0005018454 20150623.ifs 2015-06-23 2015-06-24
1819278 1819278 DIVIDEND ADD 464288828 0 0 1 0 .039325 00 2015-03-25 2015-03-27 2015-03-31 2015-03-24 0 2015-03-24 ? 0 0004972943 20150324.ifs 2015-03-24 2015-03-25
1740532 1740532 DIVIDEND ADD 464288828 0 0 1 0 .075137 00 2014-12-24 2014-12-29 2014-12-31 2014-12-23 0 2014-12-23 ? 0 0004919653 20141223.ifs 2014-12-23 2014-12-24
1636507 1636507 DIVIDEND ADD 464288828 0 0 1 0 .041707 00 2014-09-24 2014-09-26 2014-09-30 2014-09-23 0 2014-09-23 ? 0 0004846737 20140923.ifs 2014-09-23 2014-09-24
1557033 1557033 DIVIDEND ADD 464288828 0 0 1 0 .057467 00 2014-06-24 2014-06-26 2014-06-30 2014-06-23 0 2014-06-23 ? 0 0004800706 20140623.ifs 2014-06-23 2014-06-24
1474528 1474528 DIVIDEND ADD 464288828 0 0 1 0 .042162 00 2014-03-25 2014-03-27 2014-03-31 2014-03-24 0 2014-03-24 ? 0 0004754639 20140324.ifs 2014-03-24 2014-03-25
1389356 1389356 DIVIDEND ADD 464288828 0 0 1 0 .052934 00 2013-12-23 2013-12-26 2013-12-30 2013-12-20 0 2013-12-20 ? 0 0004698562 20131220.ifs 2013-12-20 2013-12-21
1294246 1294246 DIVIDEND ADD 464288828 0 0 1 0 .086554 00 2013-09-24 2013-09-26 2013-09-30 2013-09-23 0 2013-09-23 ? 0 0004632693 20130923.ifs 2013-09-23 2013-09-24
1226933 1226933 CORPACTION ADD 464288828 04 # 2013-07-01 464288828 04 ? 20130701.ifs 2013-07-01 2013-07-02
1226934 1226934 CORPACTIONAUX ADD 464288828 04 2013-07-01 IHF ISHARES TR ISHARES TRUST D IHF ISHARES TR ISHARES U.S. HE 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1226935 1226935 EQUITY CHANGE 464288828 DJ US HLTHCR PROVDRS INDX FD 0 A 2006-05-05 ? 0 no no no 2006-05-08 2008-03-14 ? 20130701.ifs 2013-07-01 2013-07-02
1226936 1226935 EQUITY CHANGE 464288828 ISHARES U.S. HEALTHCARE PROVIDERS ETF 0 A 2006-05-05 ? 0 no no no 2006-05-08 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1217516 1217516 DIVIDEND ADD 464288828 0 0 1 0 .039725 00 2013-06-26 2013-06-28 2013-07-02 2013-06-25 0 2013-06-25 ? 0 0004588938 20130625.ifs 2013-06-25 2013-06-26
1140185 1140185 DIVIDEND ADD 464288828 0 0 1 0 .038724 00 2013-03-25 2013-03-27 2013-04-01 2013-03-22 0 2013-03-22 ? 0 0004545070 20130322.ifs 2013-03-22 2013-03-23
1047863 1047863 DIVIDEND ADD 464288828 0 0 1 0 .417917 00 2012-12-19 2012-12-21 2012-12-26 2012-12-18 0 2012-12-18 ? 0 0004485654 20121218.ifs 2012-12-18 2012-12-19
963408 963408 DIVIDEND ADD 464288828 0 0 1 0 .040381 00 2012-09-25 2012-09-27 2012-10-01 2012-09-24 0 2012-09-24 ? 0 0004433150 20120924.ifs 2012-09-24 2012-09-25
887463 887463 DIVIDEND ADD 464288828 0 0 1 0 .029217 00 2012-06-19 2012-06-21 2012-06-25 2012-06-18 0 2012-06-18 ? 0 0004387629 20120618.ifs 2012-06-18 2012-06-19
809521 809521 DIVIDEND ADD 464288828 0 0 1 0 .135939 00 2012-03-26 2012-03-28 2012-03-30 2012-03-23 0 2012-03-23 ? 0 0004349500 20120323.ifs 2012-03-23 2012-03-24
650807 650807 DIVIDEND ADD 464288828 0 0 1 0 .024509 00 2011-09-23 2011-09-27 2011-09-29 2011-09-22 0 2011-09-22 ? 0 0004245755 20110922.ifs 2011-09-22 2011-09-23
568273 568273 DIVIDEND ADD 464288828 0 0 1 0 .018533 00 2011-06-24 2011-06-28 2011-06-30 2011-06-23 0 2011-06-23 ? 0 0004205156 20110623.ifs 2011-06-23 2011-06-24
479644 479644 DIVIDEND ADD 464288828 0 0 1 0 .002587 00 2011-03-25 2011-03-29 2011-03-31 2011-03-24 0 2011-03-24 ? 0 0004163790 20110324.ifs 2011-03-24 2011-03-25
389309 389309 DIVIDEND ADD 464288828 0 0 1 0 .081062 00 2010-12-22 2010-12-27 2010-12-29 2010-12-21 0 2010-12-21 ? 0 0004114346 20101221.ifs 2010-12-21 2010-12-22


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