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

the compid is:130591
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
5544984 5544984 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2024-05-08 2024-05-09 2024-05-23 2024-04-29 0 2024-04-29 ? 0 0006909771 20240429.ifs 2024-04-29 2024-04-30
5486769 5486769 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2024-02-08 2024-02-09 2024-02-23 2024-01-30 0 2024-01-30 ? 0 0006867460 20240130.ifs 2024-01-30 2024-01-31
5398734 5398734 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2023-11-01 2023-11-02 2023-11-16 2023-10-23 0 2023-10-23 ? 0 0006800196 20231023.ifs 2023-10-23 2023-10-24
5338856 5338856 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2023-08-02 2023-08-03 2023-08-17 2023-07-24 0 2023-07-24 ? 0 0006758096 20230724.ifs 2023-07-24 2023-07-25
5276784 5276784 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2023-05-03 2023-05-04 2023-05-18 2023-04-24 0 2023-04-25 ? 0 0006714891 20230425.ifs 2023-04-25 2023-04-26
5218487 5218487 DIVIDEND DELETE 43940T109 0 0 1 0 .14 00 2023-02-02 2023-02-03 2023-02-16 2023-01-23 1 2023-01-23 2023-01-27 0 0006671614 20230130.ifs 2023-01-30 2023-01-31
5218488 5218488 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2023-02-01 2023-02-02 2023-02-16 2023-01-23 2 2023-01-23 2023-01-30 0 0006671614 20230130.ifs 2023-01-30 2023-01-31
5217773 5217773 DIVIDEND DELETE 43940T109 0 0 1 0 .14 00 2023-02-01 2023-02-02 2023-02-16 2023-01-23 0 2023-01-23 ? 0 0006671614 20230127.ifs 2023-01-27 2023-01-28
5217774 5217774 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2023-02-02 2023-02-03 2023-02-16 2023-01-23 1 2023-01-23 2023-01-27 0 0006671614 20230127.ifs 2023-01-27 2023-01-28
5215145 5215145 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2023-02-01 2023-02-02 2023-02-16 2023-01-23 0 2023-01-23 ? 0 0006671614 20230123.ifs 2023-01-23 2023-01-24
5124477 5124477 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2022-11-02 2022-11-03 2022-11-17 2022-10-24 0 2022-10-24 ? 0 0006601622 20221024.ifs 2022-10-24 2022-10-25
5060416 5060416 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2022-07-28 2022-07-29 2022-08-12 2022-07-19 0 2022-07-19 ? 0 0006557065 20220719.ifs 2022-07-19 2022-07-20
4994697 4994697 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2022-04-27 2022-04-28 2022-05-12 2022-04-18 0 2022-04-18 ? 0 0006511593 20220418.ifs 2022-04-18 2022-04-19
4938447 4938447 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2022-02-02 2022-02-03 2022-02-17 2022-01-24 0 2022-01-24 ? 0 0006470197 20220124.ifs 2022-01-24 2022-01-25
4831605 4831605 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2021-11-03 2021-11-04 2021-11-18 2021-10-25 0 2021-10-25 ? 0 0006385833 20211025.ifs 2021-10-25 2021-10-26
4761791 4761791 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2021-07-29 2021-07-30 2021-08-13 2021-07-20 0 2021-07-20 ? 0 0006341205 20210720.ifs 2021-07-20 2021-07-21
4689048 4689048 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2021-05-06 2021-05-07 2021-05-21 2021-04-27 0 2021-04-27 ? 0 0006297480 20210427.ifs 2021-04-27 2021-04-28
4611912 4611912 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2021-02-04 2021-02-05 2021-02-19 2021-01-26 0 2021-01-26 ? 0 0006254122 20210126.ifs 2021-01-26 2021-01-27
4488414 4488414 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2020-10-29 2020-10-30 2020-11-13 2020-10-20 0 2020-10-20 ? 0 0006176185 20201020.ifs 2020-10-20 2020-10-21
4427047 4427047 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2020-08-07 2020-08-10 2020-08-24 2020-07-30 0 2020-07-30 ? 0 0006134679 20200730.ifs 2020-07-30 2020-07-31
4304406 4304406 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2020-05-07 2020-05-08 2020-05-22 2020-04-28 0 2020-04-28 ? 0 0006088990 20200428.ifs 2020-04-28 2020-04-29
4304409 4304409 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2020-05-07 2020-05-08 2020-05-22 2020-04-28 0 2020-04-28 ? 0 0006088990 20200428.ifs 2020-04-28 2020-04-29
4174723 4174723 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2020-02-06 2020-02-07 2020-02-21 2020-01-22 0 2020-01-22 ? 0 0006044150 20200122.ifs 2020-01-22 2020-01-23
4174736 4174736 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2020-02-06 2020-02-07 2020-02-21 2020-01-22 0 2020-01-22 ? 0 0006044150 20200122.ifs 2020-01-22 2020-01-23
3973876 3973876 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-10-24 2019-10-25 2019-11-08 2019-10-15 0 2019-10-15 ? 0 0005962573 20191015.ifs 2019-10-15 2019-10-16
3973887 3973887 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-10-24 2019-10-25 2019-11-08 2019-10-15 0 2019-10-15 ? 0 0005962573 20191015.ifs 2019-10-15 2019-10-16
3837248 3837248 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-07-25 2019-07-26 2019-08-09 2019-07-16 0 2019-07-16 ? 0 0005916881 20190716.ifs 2019-07-16 2019-07-17
3837249 3837249 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-07-25 2019-07-26 2019-08-09 2019-07-16 0 2019-07-16 ? 0 0005916881 20190716.ifs 2019-07-16 2019-07-17
3685654 3685654 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-04-25 2019-04-26 2019-05-10 2019-04-16 0 2019-04-16 ? 0 0005870799 20190416.ifs 2019-04-16 2019-04-17
3685655 3685655 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-04-25 2019-04-26 2019-05-10 2019-04-16 0 2019-04-16 ? 0 0005870799 20190416.ifs 2019-04-16 2019-04-17
3556905 3556905 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-01-31 2019-02-01 2019-02-15 2019-01-22 0 2019-01-22 ? 0 0005827578 20190122.ifs 2019-01-22 2019-01-23
3556914 3556914 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2019-01-31 2019-02-01 2019-02-15 2019-01-22 0 2019-01-22 ? 0 0005827578 20190122.ifs 2019-01-22 2019-01-23
3330766 3330766 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2018-10-25 2018-10-26 2018-11-09 2018-10-16 0 2018-10-16 ? 0 0005741195 20181016.ifs 2018-10-16 2018-10-17
3330767 3330767 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2018-10-25 2018-10-26 2018-11-09 2018-10-16 0 2018-10-16 ? 0 0005741195 20181016.ifs 2018-10-16 2018-10-17
3196547 3196547 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2018-07-26 2018-07-27 2018-08-10 2018-07-17 0 2018-07-17 ? 0 0005694501 20180717.ifs 2018-07-17 2018-07-18
3196567 3196567 DIVIDEND ADD 43940T109 0 0 1 0 .14 00 2018-07-26 2018-07-27 2018-08-10 2018-07-17 0 2018-07-17 ? 0 0005694501 20180717.ifs 2018-07-17 2018-07-18
3041051 3041051 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2018-04-26 2018-04-27 2018-05-11 2018-04-17 0 2018-04-17 ? 0 0005647734 20180417.ifs 2018-04-17 2018-04-18
3041078 3041078 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2018-04-26 2018-04-27 2018-05-11 2018-04-17 0 2018-04-17 ? 0 0005647734 20180417.ifs 2018-04-17 2018-04-18
2930715 2930715 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2018-02-02 2018-02-05 2018-02-19 2018-01-26 0 2018-01-26 ? 0 0005604467 20180126.ifs 2018-01-26 2018-01-27
2930735 2930735 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2018-02-02 2018-02-05 2018-02-19 2018-01-26 0 2018-01-26 ? 0 0005604467 20180126.ifs 2018-01-26 2018-01-27
2726502 2726502 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2017-10-30 2017-10-31 2017-11-14 2017-10-17 0 2017-10-17 ? 0 0005515393 20171017.ifs 2017-10-17 2017-10-18
2726952 2726952 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2017-10-30 2017-10-31 2017-11-14 2017-10-17 0 2017-10-17 ? 0 0005515393 20171017.ifs 2017-10-17 2017-10-18
2625304 2625304 DIVIDEND ADD 43940T109 0 0 1 0 .13 00 2017-07-27 2017-07-31 2017-08-14 2017-07-18 0 2017-07-18 ? 0 0005469177 20170718.ifs 2017-07-18 2017-07-19
2543471 2543471 DIVIDEND ADD 43940T109 0 0 1 0 .12 00 2017-04-26 2017-04-28 2017-05-12 2017-04-18 0 2017-04-18 ? 0 0005421429 20170418.ifs 2017-04-18 2017-04-19
2454528 2454528 DIVIDEND ADD 43940T109 0 0 1 0 .12 00 2017-02-01 2017-02-03 2017-02-17 2017-01-24 0 2017-01-24 ? 0 0005377455 20170124.ifs 2017-01-24 2017-01-25
2439482 2439482 EQUITY CHANGE 43940T109 COM 0 0 2015-08-03 ? 0 no no yes 2016-07-29 2016-07-29 ? 20170123.ifs 2017-01-23 2017-01-24
2439483 2439482 EQUITY CHANGE 43940T109 COM 0 0 2015-08-03 ? 4 no no yes 2016-07-29 2016-07-29 ? 20170123.ifs 2017-01-23 2017-01-24
2323085 2323085 DIVIDEND CHANGE 43940T109 0 0 1 0 .11 00 2016-10-26 2016-10-28 2016-11-11 2016-10-18 0 2016-10-18 ? 0 0005298954 20161019.ifs 2016-10-19 2016-10-20
2323086 2323085 DIVIDEND CHANGE 43940T109 0 0 1 0 .12 00 2016-10-26 2016-10-28 2016-11-11 2016-10-18 1 2016-10-18 2016-10-19 0 0005298954 20161019.ifs 2016-10-19 2016-10-20
2322482 2322482 DIVIDEND ADD 43940T109 0 0 1 0 .11 00 2016-10-26 2016-10-28 2016-11-11 2016-10-18 0 2016-10-18 ? 0 0005298954 20161018.ifs 2016-10-18 2016-10-19
2259840 2259840 EQUITY ADD 43940T109 COM N 0 2015-08-03 ? 0 no no no 2016-07-29 ? ? 20160729.ifs 2016-07-29 2016-07-30
2259841 2259841 EQUITY CHANGE 43940T109 COM N 0 2015-08-03 ? 0 no no no 2016-07-29 ? ? 20160729.ifs 2016-07-29 2016-07-30
2259842 2259841 EQUITY CHANGE 43940T109 COM N 0 2015-08-03 ? 0 no no yes 2016-07-29 2016-07-29 ? 20160729.ifs 2016-07-29 2016-07-30


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