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

the compid is:145376
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
5561122 5561122 DIVIDEND DELETE 00687A107 B 0 1 5 .239374 39 2024-05-17 2024-05-20 2024-05-29 2024-04-10 0 2024-04-10 ? 0 0006905800 20240522.ifs 2024-05-22 2024-05-23
5561123 5561123 DIVIDEND ADD 00687A107 B 0 1 0 .239212 02 2024-05-17 2024-05-20 2024-05-29 2024-04-10 1 2024-04-10 2024-05-22 0 0006905800 20240522.ifs 2024-05-22 2024-05-23
5537737 5537737 DIVIDEND ADD 00687A107 B 0 1 5 .239374 39 2024-05-17 2024-05-20 2024-05-29 2024-04-10 0 2024-04-10 ? 0 0006905800 20240410.ifs 2024-04-10 2024-04-11
5292300 5292300 DIVIDEND DELETE 00687A107 B 0 1 5 .243912 39 2023-05-12 2023-05-15 2023-05-23 2023-05-08 0 2023-05-08 ? 0 0006724251 20230516.ifs 2023-05-16 2023-05-17
5292301 5292301 DIVIDEND ADD 00687A107 B 0 1 0 .24074 02 2023-05-12 2023-05-15 2023-05-23 2023-05-08 1 2023-05-08 2023-05-16 0 0006724251 20230516.ifs 2023-05-16 2023-05-17
5288556 5288556 DIVIDEND ADD 00687A107 B 0 1 5 .243912 39 2023-05-12 2023-05-15 2023-05-23 2023-05-08 0 2023-05-08 ? 0 0006724251 20230508.ifs 2023-05-08 2023-05-09
5013491 5013491 DIVIDEND DELETE 00687A107 B 0 1 5 1.295237 39 2022-05-13 2022-05-16 2022-05-23 2022-03-23 0 2022-03-23 ? 0 0006497794 20220517.ifs 2022-05-17 2022-05-18
5013492 5013492 DIVIDEND ADD 00687A107 B 0 1 0 1.236335 02 2022-05-13 2022-05-16 2022-05-23 2022-03-23 1 2022-03-23 2022-05-17 0 0006497794 20220517.ifs 2022-05-17 2022-05-18
4976544 4976544 DIVIDEND ADD 00687A107 B 0 1 5 1.295237 39 2022-05-13 2022-05-16 2022-05-23 2022-03-23 0 2022-03-23 ? 0 0006497794 20220323.ifs 2022-03-23 2022-03-24
4707518 4707518 DIVIDEND DELETE 00687A107 B 0 1 5 1.262358 39 2021-05-13 2021-05-14 2021-05-25 2021-04-08 0 2021-04-08 ? 0 0006293440 20210518.ifs 2021-05-18 2021-05-19
4707519 4707519 DIVIDEND ADD 00687A107 B 0 1 0 1.303316 02 2021-05-13 2021-05-14 2021-05-25 2021-04-08 1 2021-04-08 2021-05-18 0 0006293440 20210518.ifs 2021-05-18 2021-05-19
4678649 4678649 DIVIDEND ADD 00687A107 B 0 1 5 1.262358 39 2021-05-13 2021-05-14 2021-05-25 2021-04-08 0 2021-04-08 ? 0 0006293440 20210408.ifs 2021-04-08 2021-04-09
3727988 3727988 DIVIDEND DELETE 00687A107 B 0 1 5 1.337652 39 2019-05-10 2019-05-13 2019-05-21 2019-04-08 0 2019-04-08 ? 0 0005869319 20190514.ifs 2019-05-14 2019-05-15
3727990 3727990 DIVIDEND ADD 00687A107 B 0 1 0 1.338248 02 2019-05-10 2019-05-13 2019-05-21 2019-04-08 1 2019-04-08 2019-05-14 0 0005869319 20190514.ifs 2019-05-14 2019-05-15
3728006 3728006 DIVIDEND DELETE 00687A107 B 0 1 5 1.337652 39 2019-05-10 2019-05-13 2019-05-21 2019-04-08 0 2019-04-08 ? 0 0005869319 20190514.ifs 2019-05-14 2019-05-15
3728008 3728008 DIVIDEND ADD 00687A107 B 0 1 0 1.338248 02 2019-05-10 2019-05-13 2019-05-21 2019-04-08 1 2019-04-08 2019-05-14 0 0005869319 20190514.ifs 2019-05-14 2019-05-15
3678981 3678981 DIVIDEND ADD 00687A107 B 0 1 5 1.337652 39 2019-05-10 2019-05-13 2019-05-21 2019-04-08 0 2019-04-08 ? 0 0005869319 20190408.ifs 2019-04-08 2019-04-09
3678996 3678996 DIVIDEND ADD 00687A107 B 0 1 5 1.337652 39 2019-05-10 2019-05-13 2019-05-21 2019-04-08 0 2019-04-08 ? 0 0005869319 20190408.ifs 2019-04-08 2019-04-09
3091481 3091481 DIVIDEND DELETE 00687A107 B 0 1 5 1.168826 39 2018-05-10 2018-05-11 2018-05-22 2018-03-28 0 2018-03-28 ? 0 0005637270 20180515.ifs 2018-05-15 2018-05-16
3091482 3091482 DIVIDEND DELETE 00687A107 B 0 1 5 1.168826 39 2018-05-10 2018-05-11 2018-05-22 2018-03-28 0 2018-03-28 ? 0 0005637270 20180515.ifs 2018-05-15 2018-05-16
3091483 3091483 DIVIDEND ADD 00687A107 B 0 1 0 1.120788 02 2018-05-10 2018-05-11 2018-05-22 2018-03-28 1 2018-03-28 2018-05-15 0 0005637270 20180515.ifs 2018-05-15 2018-05-16
3091484 3091484 DIVIDEND ADD 00687A107 B 0 1 0 1.120788 02 2018-05-10 2018-05-11 2018-05-22 2018-03-28 1 2018-03-28 2018-05-15 0 0005637270 20180515.ifs 2018-05-15 2018-05-16
3013165 3013165 DIVIDEND ADD 00687A107 B 0 1 5 1.168826 39 2018-05-10 2018-05-11 2018-05-22 2018-03-28 0 2018-03-28 ? 0 0005637270 20180328.ifs 2018-03-28 2018-03-29
2568404 2568404 DIVIDEND DELETE 00687A107 B 0 1 5 .773795 39 2017-05-12 2017-05-16 2017-05-23 2017-03-27 0 2017-03-27 ? 0 0005407671 20170516.ifs 2017-05-16 2017-05-17
2568405 2568405 DIVIDEND ADD 00687A107 B 0 1 0 .795956 02 2017-05-12 2017-05-16 2017-05-23 2017-03-27 1 2017-03-27 2017-05-16 0 0005407671 20170516.ifs 2017-05-16 2017-05-17
2521142 2521142 DIVIDEND ADD 00687A107 B 0 1 5 .773795 39 2017-05-12 2017-05-16 2017-05-23 2017-03-27 0 2017-03-27 ? 0 0005407671 20170327.ifs 2017-03-27 2017-03-28
2456347 2456347 EQUITY CHANGE 00687A107 SPONSORED ADR 0 0 2004-12-27 ? 0 no no no 2005-01-26 ? ? 20170126.ifs 2017-01-26 2017-01-27
2456348 2456347 EQUITY CHANGE 00687A107 SPONSORED ADR 0 0 2004-12-27 ? 1 no no no 2005-01-26 ? ? 20170126.ifs 2017-01-26 2017-01-27
2197016 2197016 DIVIDEND DELETE 00687A107 B 1 0 .648397 02 2016-05-10 2016-05-12 2016-05-20 ? 0 2016-05-13 ? 1 0005191101 20160516.ifs 2016-05-16 2016-05-17
2197017 2197017 DIVIDEND ADD 00687A107 B 0 1 0 .648397 0 02 2016-05-10 2016-05-12 2016-05-20 2016-03-23 0 ? 2016-05-16 1 0005191101 20160516.ifs 2016-05-16 2016-05-17
2196995 2196995 DIVIDEND ADD 00687A107 B 1 0 .648397 02 2016-05-10 2016-05-12 2016-05-20 ? 0 2016-05-13 ? 1 0005191101 20160513.ifs 2016-05-13 2016-05-14
1860795 1860795 DIVIDEND DELETE 00687A107 B 0 1 5 .5646 39 2015-05-05 2015-05-07 ? 2015-03-19 0 2015-03-19 ? 0 0004970162 20150508.ifs 2015-05-08 2015-05-09
1860796 1860796 DIVIDEND ADD 00687A107 B 0 1 0 .601 02 2015-05-05 2015-05-07 2015-05-15 2015-03-19 1 2015-03-19 2015-05-08 0 0004970162 20150508.ifs 2015-05-08 2015-05-09
1816380 1816380 DIVIDEND ADD 00687A107 B 0 1 5 .5646 39 2015-05-05 2015-05-07 ? 2015-03-19 0 2015-03-19 ? 0 0004970162 20150319.ifs 2015-03-19 2015-03-20
1183388 1183388 DIVIDEND ADD 00687A107 B 0 1 0 .632 0 02 2013-05-06 2013-05-08 2013-05-16 2013-03-26 0 ? 2013-05-10 0 0004545758 20130510.ifs 2013-05-10 2013-05-11
860999 860999 DIVIDEND ADD 00687A107 B 0 1 0 .4557 02 2012-05-08 2012-05-10 2012-05-18 2012-05-14 0 ? 2012-05-15 0 0004350185 20120515.ifs 2012-05-15 2012-05-16
528055 528055 DIVIDEND DELETE 00687A107 B 1 0 .3993 02 2011-05-10 2011-05-12 2011-05-20 ? 0 2011-05-17 ? 0 0004174771 20110518.ifs 2011-05-18 2011-05-19
528056 528056 DIVIDEND ADD 00687A107 B 0 1 0 .3993 0 02 2011-05-10 2011-05-12 2011-05-20 2011-04-11 0 ? 2011-05-18 0 0004174771 20110518.ifs 2011-05-18 2011-05-19
527995 527995 DIVIDEND ADD 00687A107 B 1 0 .3993 02 2011-05-10 2011-05-12 2011-05-20 ? 0 2011-05-17 ? 0 0004174771 20110517.ifs 2011-05-17 2011-05-18
500533 500533 DIVIDEND DELETE 00687A107 B 0 1 5 .406 39 ? 2011-05-12 2011-05-20 2011-04-11 0 2011-04-11 ? 0 0004174771 20110412.ifs 2011-04-12 2011-04-13
500425 500425 DIVIDEND ADD 00687A107 B 0 1 5 .406 39 ? 2011-05-12 2011-05-20 2011-04-11 0 2011-04-11 ? 0 0004174771 20110411.ifs 2011-04-11 2011-04-12
315086 315086 DIVIDEND DELETE 00687A107 B 1 0 .1481 02 2010-05-04 2010-05-06 2010-05-14 ? 0 2010-05-11 ? 0 0003980251 20100927.ifs 2010-09-27 2010-09-28
315087 315087 DIVIDEND ADD 00687A107 B 0 1 0 .1481 0 02 2010-05-04 2010-05-06 2010-05-14 2010-03-22 0 ? 2010-09-27 0 0003980251 20100927.ifs 2010-09-27 2010-09-28
190086 190086 DIVIDEND ADD 00687A107 B 1 0 .1481 02 2010-05-04 2010-05-06 2010-05-14 ? 0 2010-05-11 ? 0 0003980251 20100511.ifs 2010-05-11 2010-05-12
137462 137462 DIVIDEND DELETE 00687A107 B 0 1 5 .1623 39 ? 2010-05-06 ? 2010-03-22 0 2010-03-22 ? 0 0003980251 20100323.ifs 2010-03-23 2010-04-07
137438 137438 DIVIDEND ADD 00687A107 B 0 1 5 .1623 39 ? 2010-05-06 ? 2010-03-22 0 2010-03-22 ? 0 0003980251 20100322.ifs 2010-03-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 = 145376
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