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 HCBC Charts Yahoo HCBC Profile
  Run HCBC Institutional Summary Yahoo HCBC Key Statisics
  J3 Open HCBC Pricing Yahoo HCBC Pricing
  J3 HCBC Insider   J3 HCBC Insitutions Yahoo HCBC Holders
     
  Open up Sector/Exchange Map Fidelity HCBC Lookup
  Open up sec.gov For Market Ca MSN HCBC 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:130864
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
5543442 5543442 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2024-05-03 2024-05-06 2024-05-20 2024-04-25 0 2024-04-25 ? 0 0006909194 20240425.ifs 2024-04-25 2024-04-26
5543443 5543443 EQUITY CHANGE 42965Q107 COM 0 0 1997-12-10 ? 2 no no no 1998-11-03 2000-09-14 ? 20240425.ifs 2024-04-25 2024-04-26
5543444 5543443 EQUITY CHANGE 42965Q107 COM 0 0 1997-12-10 ? 4 no no no 1998-11-03 2000-09-14 ? 20240425.ifs 2024-04-25 2024-04-26
5482585 5482585 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2024-02-01 2024-02-02 2024-02-19 2024-01-18 0 2024-01-19 ? 0 0006865353 20240119.ifs 2024-01-19 2024-01-20
5398080 5398080 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2023-10-31 2023-11-01 2023-11-13 2023-10-19 0 2023-10-20 ? 0 0006799977 20231020.ifs 2023-10-20 2023-10-21
5347216 5347216 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2023-08-10 2023-08-11 2023-08-25 2023-07-31 0 2023-08-01 ? 0 0006764851 20230801.ifs 2023-08-01 2023-08-02
5280464 5280464 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2023-05-05 2023-05-08 2023-05-22 2023-04-27 0 2023-04-28 ? 0 0006716419 20230428.ifs 2023-04-28 2023-04-29
5217776 5217776 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2023-02-03 2023-02-06 2023-02-20 2023-01-27 0 2023-01-27 ? 0 0006672818 20230127.ifs 2023-01-27 2023-01-28
5125980 5125980 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2022-11-04 2022-11-07 2022-11-21 2022-10-25 0 2022-10-26 ? 0 0006602408 20221026.ifs 2022-10-26 2022-10-27
5062356 5062356 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2022-08-04 2022-08-05 2022-08-19 2022-07-21 0 2022-07-22 ? 0 0006558187 20220722.ifs 2022-07-22 2022-07-23
4997662 4997662 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2022-05-05 2022-05-06 2022-05-20 2022-04-21 0 2022-04-25 ? 0 0006513128 20220425.ifs 2022-04-25 2022-04-26
4937792 4937792 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2022-02-03 2022-02-04 2022-02-18 2022-01-20 0 2022-01-21 ? 0 0006469885 20220121.ifs 2022-01-21 2022-01-22
4830020 4830020 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2021-11-04 2021-11-05 2021-11-15 2021-10-21 0 2021-10-21 ? 0 0006385361 20211021.ifs 2021-10-21 2021-10-22
4766343 4766343 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2021-08-06 2021-08-09 2021-08-23 2021-07-27 0 2021-07-28 ? 0 0006342811 20210728.ifs 2021-07-28 2021-07-29
4686506 4686506 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2021-04-30 2021-05-03 2021-05-17 2021-04-22 0 2021-04-22 ? 0 0006296648 20210422.ifs 2021-04-22 2021-04-23
4610309 4610309 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2021-01-29 2021-02-01 2021-02-15 2021-01-21 0 2021-01-22 ? 0 0006253413 20210122.ifs 2021-01-22 2021-01-23
4487357 4487357 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2020-10-26 2020-10-27 2020-11-10 2020-10-16 0 2020-10-16 ? 0 0006175855 20201016.ifs 2020-10-16 2020-10-17
4422047 4422047 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2020-07-30 2020-07-31 2020-08-14 2020-07-21 0 2020-07-21 ? 0 0006131987 20200721.ifs 2020-07-21 2020-07-22
4346945 4346945 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2020-05-29 2020-06-01 2020-06-15 2020-05-21 0 2020-05-22 ? 0 0006101259 20200522.ifs 2020-05-22 2020-05-23
4346946 4346946 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2020-05-29 2020-06-01 2020-06-15 2020-05-21 0 2020-05-22 ? 0 0006101259 20200522.ifs 2020-05-22 2020-05-23
3982863 3982863 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2019-11-07 2019-11-08 2019-11-22 2019-10-22 0 2019-10-24 ? 0 0005964656 20191024.ifs 2019-10-24 2019-10-25
3982966 3982966 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2019-11-07 2019-11-08 2019-11-22 2019-10-22 0 2019-10-24 ? 0 0005964656 20191024.ifs 2019-10-24 2019-10-25
3698823 3698823 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2019-05-09 2019-05-10 2019-05-24 2019-04-23 0 2019-04-29 ? 0 0005874379 20190429.ifs 2019-04-29 2019-04-30
3698878 3698878 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2019-05-09 2019-05-10 2019-05-24 2019-04-23 0 2019-04-29 ? 0 0005874379 20190429.ifs 2019-04-29 2019-04-30
3348516 3348516 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2018-11-08 2018-11-09 2018-11-21 2018-10-30 0 2018-10-31 ? 0 0005745428 20181031.ifs 2018-10-31 2018-11-01
3348565 3348565 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2018-11-08 2018-11-09 2018-11-21 2018-10-30 0 2018-10-31 ? 0 0005745428 20181031.ifs 2018-10-31 2018-11-01
3055276 3055276 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2018-05-17 2018-05-18 2018-05-31 2018-04-19 0 2018-04-26 ? 0 0005650741 20180426.ifs 2018-04-26 2018-04-27
3055277 3055277 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2018-05-17 2018-05-18 2018-05-31 2018-04-19 0 2018-04-26 ? 0 0005650741 20180426.ifs 2018-04-26 2018-04-27
2756328 2756328 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2017-11-10 2017-11-13 2017-11-24 2017-10-31 0 2017-11-03 ? 0 0005527554 20171103.ifs 2017-11-03 2017-11-04
2756329 2756329 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2017-11-10 2017-11-13 2017-11-24 2017-10-31 0 2017-11-03 ? 0 0005527554 20171103.ifs 2017-11-03 2017-11-04
2545088 2545088 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2017-05-05 2017-05-09 2017-05-19 2017-04-19 0 2017-04-20 ? 0 0005422478 20170420.ifs 2017-04-20 2017-04-21
2329133 2329133 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2016-11-03 2016-11-07 2016-11-18 2016-10-27 0 2016-10-28 ? 0 0005301994 20161028.ifs 2016-10-28 2016-10-29
2172653 2172653 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2016-05-06 2016-05-10 2016-05-20 2016-04-21 0 2016-04-25 ? 0 0005207712 20160425.ifs 2016-04-25 2016-04-26
1849062 1849062 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2015-05-01 2015-05-05 2015-05-15 2015-04-23 0 2015-04-28 ? 0 0004989871 20150428.ifs 2015-04-28 2015-04-29
1672777 1672777 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2014-11-06 2014-11-10 2014-11-24 2014-10-29 0 2014-11-03 ? 0 0004868539 20141103.ifs 2014-11-03 2014-11-04
1506504 1506504 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2014-05-07 2014-05-09 2014-05-23 2014-04-24 0 2014-04-30 ? 0 0004772789 20140430.ifs 2014-04-30 2014-05-01
1323323 1323323 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2013-11-06 2013-11-11 2013-11-26 2013-10-17 0 2013-10-25 ? 0 0004647787 20131025.ifs 2013-10-25 2013-10-26
1323324 1323324 DIVIDEND CHANGE 42965Q107 0 0 1 0 1 00 2013-05-08 2013-05-10 2013-05-20 2013-04-24 0 2013-04-30 ? 0 0004561994 20131025.ifs 2013-10-25 2013-10-26
1323325 1323324 DIVIDEND CHANGE 42965Q107 0 0 1 0 1 00 2013-05-08 2013-05-10 2013-05-20 2013-04-24 1 2013-04-30 2013-10-25 0 0004561994 20131025.ifs 2013-10-25 2013-10-26
1172424 1172424 DIVIDEND ADD 42965Q107 0 0 1 0 1 00 2013-05-08 2013-05-10 2013-05-20 2013-04-24 0 2013-04-30 ? 0 0004561994 20130430.ifs 2013-04-30 2013-05-01
989350 989350 DIVIDEND ADD 42965Q107 0 0 1 0 .7 00 2012-11-07 2012-11-09 2012-11-19 2012-10-18 0 2012-10-19 ? 0 0004446469 20121019.ifs 2012-10-19 2012-10-20
851597 851597 DIVIDEND ADD 42965Q107 0 0 1 0 .55 00 2012-05-08 2012-05-10 2012-05-21 2012-04-26 0 2012-05-01 ? 0 0004370004 20120501.ifs 2012-05-01 2012-05-02
690534 690534 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2011-11-08 2011-11-10 2011-11-21 2011-10-27 0 2011-11-04 ? 0 0004268313 20111104.ifs 2011-11-04 2011-11-05
521820 521820 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2011-05-12 2011-05-16 2011-05-26 2011-04-21 0 2011-05-06 ? 0 0004186760 20110506.ifs 2011-05-06 2011-05-07
349278 349278 DIVIDEND ADD 42965Q107 0 0 1 0 .5 00 2010-11-10 2010-11-15 2010-11-25 2010-11-03 0 2010-11-03 ? 0 0004084996 20101103.ifs 2010-11-03 2010-11-04
185257 185257 DIVIDEND ADD 42965Q107 0 0 1 0 .4 00 2010-05-12 2010-05-14 2010-05-25 2010-04-22 0 2010-05-05 ? 0 0004003994 20100505.ifs 2010-05-05 2010-05-06
21892 21892 DIVIDEND ADD 42965Q107 0 0 1 0 .3 00 2009-11-12 2009-11-16 2009-11-26 2009-11-11 0 2009-11-11 ? 0 0003907666 20091111.ifs 2009-11-11 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 = 130864
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