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 AADR Charts Yahoo AADR Profile
  Run AADR Institutional Summary Yahoo AADR Key Statisics
  J3 Open AADR Pricing Yahoo AADR Pricing
  J3 AADR Insider   J3 AADR Insitutions Yahoo AADR Holders
     
  Open up Sector/Exchange Map Fidelity AADR Lookup
  Open up sec.gov For Market Ca MSN AADR 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
00768Y206 DELETE RUN
 

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 : 17 17   Update Insititution By Cusips
% Owned by Insititutions: 9.33 % 7.75 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:159573
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
5581080 5581080 DIVIDEND ADD 00768Y206 0 0 1 0 .52714 00 2024-06-24 2024-06-24 2024-06-28 2024-06-21 0 2024-06-21 ? 0 0006936397 20240621.ifs 2024-06-21 2024-06-22
5520258 5520258 DIVIDEND ADD 00768Y206 0 0 1 0 .01553 00 2024-03-21 2024-03-22 2024-03-28 2024-03-20 0 2024-03-20 ? 0 0006892858 20240320.ifs 2024-03-20 2024-03-21
5460713 5460713 DIVIDEND ADD 00768Y206 0 0 1 0 .16323 00 2023-12-26 2023-12-27 2023-12-29 2023-12-22 0 2023-12-22 ? 0 0006848721 20231222.ifs 2023-12-22 2023-12-23
5379555 5379555 DIVIDEND ADD 00768Y206 0 0 1 0 .12666 00 2023-09-25 2023-09-26 2023-09-29 2023-09-22 0 2023-09-22 ? 0 0006786979 20230922.ifs 2023-09-22 2023-09-23
5315861 5315861 DIVIDEND ADD 00768Y206 0 0 1 0 .1275 00 2023-06-22 2023-06-23 2023-06-30 2023-06-21 0 2023-06-21 ? 0 0006741934 20230621.ifs 2023-06-21 2023-06-22
5251563 5251563 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2023-03-30 2023-03-20 0 2023-03-20 ? 0 0006697720 20230320.ifs 2023-03-20 2023-03-21
5187723 5187723 DIVIDEND ADD 00768Y206 0 0 1 0 .54004 00 2022-12-23 2022-12-27 2022-12-30 2022-12-22 0 2022-12-22 ? 0 0006651039 20221222.ifs 2022-12-22 2022-12-23
5103998 5103998 DIVIDEND ADD 00768Y206 0 0 1 0 .45259 00 2022-09-26 2022-09-27 2022-09-30 2022-09-23 0 2022-09-23 ? 0 0006587956 20220923.ifs 2022-09-23 2022-09-24
5037915 5037915 DIVIDEND ADD 00768Y206 0 0 1 0 .75159 00 2022-06-22 2022-06-23 2022-06-30 2022-06-21 0 2022-06-21 ? 0 0006541551 20220621.ifs 2022-06-21 2022-06-22
4974848 4974848 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2022-03-31 2022-03-21 0 2022-03-21 ? 0 0006496928 20220321.ifs 2022-03-21 2022-03-22
4910150 4910150 DIVIDEND ADD 00768Y206 0 0 1 0 .23705 00 2021-12-23 2021-12-27 2021-12-31 2021-12-22 0 2021-12-22 ? 0 0006446259 20211222.ifs 2021-12-22 2021-12-23
4808964 4808964 DIVIDEND ADD 00768Y206 0 0 1 0 .20965 00 2021-09-24 2021-09-27 2021-09-30 2021-09-23 0 2021-09-23 ? 0 0006371753 20210923.ifs 2021-09-23 2021-09-24
4736863 4736863 DIVIDEND ADD 00768Y206 0 0 1 0 .14195 00 2021-06-24 2021-06-25 2021-06-30 2021-06-23 0 2021-06-23 ? 0 0006326373 20210623.ifs 2021-06-23 2021-06-24
4721601 4721601 CORPACTION ADD 00768Y206 04 X 2021-06-03 00768Y206 60 ? 20210603.ifs 2021-06-03 2021-06-04
4721602 4721602 EXCHANGE ADD 00768Y206 60 2021-06-03 2021-06-03 AADR 0 A 2021-06-03 ? 20210603.ifs 2021-06-03 2021-06-04
4721603 4721603 EQUITY CHANGE 00768Y206 ADVISORSHARES DORSEY WRIGHT ADR ETF 0 A 2010-07-21 ? 4 no no no 2010-07-21 2016-09-01 ? 20210603.ifs 2021-06-03 2021-06-04
4721604 4721603 EQUITY CHANGE 00768Y206 ADVISORSHARES DORSEY WRIGHT ADR ETF 0 A 2010-07-21 ? 4 no no yes 2010-07-21 2021-06-03 ? 20210603.ifs 2021-06-03 2021-06-04
4662582 4662582 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2021-03-31 2021-03-25 0 2021-03-25 ? 0 0006282163 20210325.ifs 2021-03-25 2021-03-26
4573594 4573594 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2020-12-31 2020-12-23 0 2020-12-23 ? 0 0006232684 20201223.ifs 2020-12-23 2020-12-24
4468718 4468718 DIVIDEND ADD 00768Y206 0 0 1 0 .06671 00 2020-09-24 2020-09-25 2020-09-30 2020-09-23 0 2020-09-23 ? 0 0006162733 20200923.ifs 2020-09-23 2020-09-24
4398579 4398579 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2020-06-30 2020-06-23 0 2020-06-23 ? 0 0006116982 20200623.ifs 2020-06-23 2020-06-24
4256149 4256149 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2020-03-31 2020-03-25 0 2020-03-25 ? 0 0006073739 20200325.ifs 2020-03-25 2020-03-26
4256154 4256154 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2020-03-31 2020-03-25 0 2020-03-25 ? 0 0006073739 20200325.ifs 2020-03-25 2020-03-26
4123506 4123506 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2019-12-31 2019-12-26 0 2019-12-26 ? 0 0006024282 20191226.ifs 2019-12-26 2019-12-27
4123524 4123524 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2019-12-31 2019-12-26 0 2019-12-26 ? 0 0006024282 20191226.ifs 2019-12-26 2019-12-27
3937358 3937358 DIVIDEND ADD 00768Y206 0 0 1 0 .00849 00 2019-09-25 2019-09-26 2019-09-30 2019-09-24 0 2019-09-24 ? 0 0005949724 20190924.ifs 2019-09-24 2019-09-25
3937448 3937448 DIVIDEND ADD 00768Y206 0 0 1 0 .00849 00 2019-09-25 2019-09-26 2019-09-30 2019-09-24 0 2019-09-24 ? 0 0005949724 20190924.ifs 2019-09-24 2019-09-25
3798002 3798002 DIVIDEND ADD 00768Y206 0 0 1 0 .30609 00 2019-06-25 2019-06-26 2019-06-28 2019-06-24 0 2019-06-24 ? 0 0005903611 20190624.ifs 2019-06-24 2019-06-25
3798003 3798003 DIVIDEND ADD 00768Y206 0 0 1 0 .30609 00 2019-06-25 2019-06-26 2019-06-28 2019-06-24 0 2019-06-24 ? 0 0005903611 20190624.ifs 2019-06-24 2019-06-25
3647273 3647273 DIVIDEND ADD 00768Y206 0 0 1 0 .00055 00 2019-03-26 2019-03-27 2019-03-29 2019-03-25 0 2019-03-25 ? 0 0005857617 20190325.ifs 2019-03-25 2019-03-26
3647348 3647348 DIVIDEND ADD 00768Y206 0 0 1 0 .00055 00 2019-03-26 2019-03-27 2019-03-29 2019-03-25 0 2019-03-25 ? 0 0005857617 20190325.ifs 2019-03-25 2019-03-26
3498965 3498965 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2018-12-31 2018-12-26 0 2018-12-26 ? 0 0005805815 20181226.ifs 2018-12-26 2018-12-27
3498982 3498982 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2018-12-31 2018-12-26 0 2018-12-26 ? 0 0005805815 20181226.ifs 2018-12-26 2018-12-27
3300040 3300040 DIVIDEND ADD 00768Y206 0 0 1 0 .00074 00 2018-09-26 2018-09-27 2018-09-28 2018-09-25 0 2018-09-25 ? 0 0005728570 20180925.ifs 2018-09-25 2018-09-26
3300116 3300116 DIVIDEND ADD 00768Y206 0 0 1 0 .00074 00 2018-09-26 2018-09-27 2018-09-28 2018-09-25 0 2018-09-25 ? 0 0005728570 20180925.ifs 2018-09-25 2018-09-26
3006157 3006157 DIVIDEND ADD 00768Y206 0 0 1 0 .01442 00 2018-03-26 2018-03-27 2018-03-29 2018-03-23 0 2018-03-23 ? 0 0005634034 20180323.ifs 2018-03-23 2018-03-24
3006158 3006158 DIVIDEND ADD 00768Y206 0 0 1 0 .01442 00 2018-03-26 2018-03-27 2018-03-29 2018-03-23 0 2018-03-23 ? 0 0005634034 20180323.ifs 2018-03-23 2018-03-24
2870806 2870806 DIVIDEND ADD 00768Y206 0 0 1 0 .13034 00 2017-12-27 2017-12-28 2017-12-29 2017-12-26 0 2017-12-26 ? 0 0005580762 20171226.ifs 2017-12-26 2017-12-27
2687325 2687325 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005501828 20170925.ifs 2017-09-25 2017-09-26
2687369 2687369 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005501828 20170925.ifs 2017-09-25 2017-09-26
2600459 2600459 DIVIDEND ADD 00768Y206 0 0 1 0 .30343 00 2017-06-26 2017-06-28 2017-06-30 2017-06-23 0 2017-06-23 ? 0 0005454270 20170623.ifs 2017-06-23 2017-06-24
2395728 2395728 DIVIDEND ADD 00768Y206 0 0 1 0 .02994 00 2016-12-23 2016-12-28 2016-12-30 2016-12-22 0 2016-12-22 ? 0 0005352582 20161222.ifs 2016-12-22 2016-12-23
2301488 2301488 DIVIDEND ADD 00768Y206 0 0 1 0 .11831 00 2016-09-26 2016-09-28 2016-09-30 2016-09-23 0 2016-09-23 ? 0 0005284936 20160923.ifs 2016-09-23 2016-09-24
2283529 2283529 CORPACTION ADD 00768Y206 04 # 2016-09-01 00768Y206 04 ? 20160901.ifs 2016-09-01 2016-09-02
2283530 2283530 CORPACTIONAUX ADD 00768Y206 04 2016-09-01 AADR ADVISORSHARES TR ADVISORSHARES T AADR ADVISORSHARES TR ADVISORSHARES D 2016-09-01 ? 20160901.ifs 2016-09-01 2016-09-02
2283531 2283531 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ADR ETF 0 A 2010-07-21 ? 4 no no no 2010-07-21 2011-03-25 ? 20160901.ifs 2016-09-01 2016-09-02
2283532 2283531 EQUITY CHANGE 00768Y206 ADVISORSHARES DORSEY WRIGHT ADR ETF 0 A 2010-07-21 ? 4 no no no 2010-07-21 2016-09-01 ? 20160901.ifs 2016-09-01 2016-09-02
2229471 2229471 DIVIDEND ADD 00768Y206 0 0 1 0 .06004 00 2016-06-24 2016-06-28 2016-06-30 2016-06-23 0 2016-06-23 ? 0 0005237900 20160623.ifs 2016-06-23 2016-06-24
2141947 2141947 DIVIDEND ADD 00768Y206 0 0 1 0 .02428 00 2016-03-24 2016-03-29 2016-03-31 2016-03-23 0 2016-03-23 ? 0 0005191367 20160323.ifs 2016-03-23 2016-03-24
2064525 2064525 DIVIDEND ADD 00768Y206 0 0 1 0 .00608 00 2015-12-24 2015-12-29 2015-12-31 2015-12-23 0 2015-12-23 ? 0 0005138650 20151223.ifs 2015-12-23 2015-12-24
1971524 1971524 DIVIDEND ADD 00768Y206 0 0 1 0 .1054 00 2015-09-24 2015-09-28 2015-09-30 2015-09-23 0 2015-09-23 ? 0 0005066483 20150923.ifs 2015-09-23 2015-09-24
1819860 1819860 DIVIDEND ADD 00768Y206 0 0 1 0 .123 00 2015-03-25 2015-03-27 2015-03-31 2015-03-24 0 2015-03-24 ? 0 0004972875 20150324.ifs 2015-03-24 2015-03-25
1741699 1741699 DIVIDEND ADD 00768Y206 0 0 1 0 .01084 00 2014-12-24 2014-12-29 2014-12-31 2014-12-23 0 2014-12-23 ? 0 0004919135 20141223.ifs 2014-12-23 2014-12-24
1636885 1636885 DIVIDEND ADD 00768Y206 0 0 1 0 .02085 00 2014-09-24 2014-09-26 2014-09-30 2014-09-23 0 2014-09-23 ? 0 0004846714 20140923.ifs 2014-09-23 2014-09-24
1557838 1557838 DIVIDEND ADD 00768Y206 0 0 1 0 .11532 00 2014-06-24 2014-06-26 2014-06-30 2014-06-23 0 2014-06-23 ? 0 0004800627 20140623.ifs 2014-06-23 2014-06-24
1475153 1475153 DIVIDEND ADD 00768Y206 0 0 1 0 .03598 00 2014-03-25 2014-03-27 2014-03-31 2014-03-24 0 2014-03-24 ? 0 0004754609 20140324.ifs 2014-03-24 2014-03-25
1394222 1394222 DIVIDEND ADD 00768Y206 0 0 1 0 .00941 00 2013-12-24 2013-12-27 2013-12-31 2013-12-23 0 2013-12-23 ? 0 0004702638 20131223.ifs 2013-12-23 2013-12-24
1294606 1294606 DIVIDEND ADD 00768Y206 0 0 1 0 .0139 00 2013-09-24 2013-09-26 2013-09-30 2013-09-23 0 2013-09-23 ? 0 0004632611 20130923.ifs 2013-09-23 2013-09-24
1215178 1215178 DIVIDEND ADD 00768Y206 0 0 1 0 .10222 00 2013-06-24 2013-06-26 2013-06-28 2013-06-21 0 2013-06-21 ? 0 0004587570 20130621.ifs 2013-06-21 2013-06-22
1139171 1139171 DIVIDEND ADD 00768Y206 0 0 1 0 .00252 00 2013-03-22 2013-03-26 2013-03-28 2013-03-21 0 2013-03-21 ? 0 0004544270 20130321.ifs 2013-03-21 2013-03-22
1058153 1058153 DIVIDEND ADD 00768Y206 0 0 1 0 .05583 00 2012-12-24 2012-12-27 2012-12-31 2012-12-21 0 2012-12-21 ? 0 0004492601 20121221.ifs 2012-12-21 2012-12-22
962207 962207 DIVIDEND ADD 00768Y206 0 0 1 0 .00821 00 2012-09-24 2012-09-26 2012-09-28 2012-09-21 0 2012-09-21 ? 0 0004432621 20120921.ifs 2012-09-21 2012-09-22
892331 892331 DIVIDEND ADD 00768Y206 0 0 1 0 .03871 00 2012-06-25 2012-06-27 2012-06-29 2012-06-22 0 2012-06-22 ? 0 0004390585 20120622.ifs 2012-06-22 2012-06-23
809893 809893 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2012-03-30 2012-03-23 0 2012-03-23 ? 0 0004349486 20120323.ifs 2012-03-23 2012-03-24
652418 652418 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2011-09-30 2011-09-23 0 2011-09-23 ? 0 0004246293 20110923.ifs 2011-09-23 2011-09-24
568658 568658 DIVIDEND ADD 00768Y206 0 0 1 0 .01899 00 2011-06-24 2011-06-28 2011-06-30 2011-06-23 0 2011-06-23 ? 0 0004205035 20110623.ifs 2011-06-23 2011-06-24
480193 480193 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ADR ETF 0 A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-23 ? 20110325.ifs 2011-03-25 2011-03-26
480194 480193 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ADR ETF 0 A 2010-07-21 ? 4 no no no 2010-07-21 2011-03-25 ? 20110325.ifs 2011-03-25 2011-03-26
480062 480062 DIVIDEND ADD 00768Y206 0 0 E 0 0 58 ? ? 2011-03-31 2011-03-24 0 2011-03-24 ? 0 0004163746 20110324.ifs 2011-03-24 2011-03-25
392581 392581 DIVIDEND ADD 00768Y206 0 0 1 4 .06949 00 2010-12-23 2010-12-28 2010-12-31 2010-12-22 0 2010-12-22 ? 0 0004116222 20101222.ifs 2010-12-22 2010-12-23
258200 258200 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ARD ETF 0 A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-21 ? 20100723.ifs 2010-07-23 2010-07-24
258201 258200 EQUITY CHANGE 00768Y206 WCM BNY MELLON FOCUSED GROWTH ARD ETF 0 A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-23 ? 20100723.ifs 2010-07-23 2010-07-24
258202 258202 EQUITY CHANGE 00768Y206 WCM BNY MELLON FOCUSED GROWTH ARD ETF 0 A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-23 ? 20100723.ifs 2010-07-23 2010-07-24
258203 258202 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ADR ETF 0 A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-23 ? 20100723.ifs 2010-07-23 2010-07-24
255963 255963 EQUITY ADD 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ARD ETF N 7 2010-07-21 ? 0 no no no 2010-07-21 ? ? 20100721.ifs 2010-07-21 2010-07-22
255964 255964 EXCHANGE ADD 00768Y206 04 2010-07-21 2010-07-21 AADR 0 A 2010-07-21 ? 20100721.ifs 2010-07-21 2010-07-22
256149 256149 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ARD ETF N 7 2010-07-21 ? 0 no no no 2010-07-21 ? ? 20100721.ifs 2010-07-21 2010-07-22
256150 256149 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ARD ETF N A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-21 ? 20100721.ifs 2010-07-21 2010-07-22
256871 256871 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ARD ETF N A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-21 ? 20100721.ifs 2010-07-21 2010-07-22
256872 256871 EQUITY CHANGE 00768Y206 WCM/BNY MELLON FOCUSED GROWTH ARD ETF 0 A 2010-07-21 ? 0 no no no 2010-07-21 2010-07-21 ? 20100721.ifs 2010-07-21 2010-07-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 = 159573
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