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

the compid is:159753
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
5582620 5582620 DIVIDEND ADD 74347X294 0 0 1 0 .43494 00 2024-06-26 2024-06-26 2024-07-03 2024-06-25 0 2024-06-25 ? 0 0006937551 20240625.ifs 2024-06-25 2024-06-26
5518768 5518768 DIVIDEND ADD 74347X294 0 0 1 0 .36281 00 2024-03-20 2024-03-21 2024-03-27 2024-03-19 0 2024-03-19 ? 0 0006891822 20240319.ifs 2024-03-19 2024-03-20
5449342 5449342 DIVIDEND ADD 74347X294 0 0 1 0 .515467 00 2023-12-20 2023-12-21 2023-12-28 2023-12-19 0 2023-12-19 ? 0 0006840410 20231219.ifs 2023-12-19 2023-12-20
5375879 5375879 DIVIDEND ADD 74347X294 0 0 1 0 .604411 00 2023-09-20 2023-09-21 2023-09-27 2023-09-19 0 2023-09-19 ? 0 0006784821 20230919.ifs 2023-09-19 2023-09-20
5314345 5314345 DIVIDEND ADD 74347X294 0 0 1 0 .31534 00 2023-06-21 2023-06-22 2023-06-28 2023-06-20 0 2023-06-20 ? 0 0006741233 20230620.ifs 2023-06-20 2023-06-21
5252017 5252017 DIVIDEND ADD 74347X294 0 0 1 0 .256961 00 2023-03-22 2023-03-23 2023-03-29 2023-03-21 0 2023-03-21 ? 0 0006698144 20230321.ifs 2023-03-21 2023-03-22
5182784 5182784 DIVIDEND ADD 74347X294 0 0 1 0 .184812 00 2022-12-22 2022-12-23 2022-12-30 2022-12-21 0 2022-12-21 ? 0 0006648301 20221221.ifs 2022-12-21 2022-12-22
5100347 5100347 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2022-09-28 2022-09-20 0 2022-09-20 ? 0 0006585686 20220920.ifs 2022-09-20 2022-09-21
5037098 5037098 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2022-06-29 2022-06-21 0 2022-06-21 ? 0 0006541480 20220621.ifs 2022-06-21 2022-06-22
4975222 4975222 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2022-03-30 2022-03-22 0 2022-03-22 ? 0 0006497670 20220322.ifs 2022-03-22 2022-03-23
4907733 4907733 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2021-12-31 2021-12-22 0 2021-12-22 ? 0 0006445944 20211222.ifs 2021-12-22 2021-12-23
4806428 4806428 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2021-09-29 2021-09-21 0 2021-09-21 ? 0 0006370434 20210921.ifs 2021-09-21 2021-09-22
4733941 4733941 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2021-06-29 2021-06-21 0 2021-06-21 ? 0 0006324969 20210621.ifs 2021-06-21 2021-06-22
4658683 4658683 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2021-03-30 2021-03-22 0 2021-03-22 ? 0 0006280187 20210322.ifs 2021-03-22 2021-03-23
4567384 4567384 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2020-12-31 2020-12-22 0 2020-12-22 ? 0 0006230243 20201222.ifs 2020-12-22 2020-12-23
4467215 4467215 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2020-09-30 2020-09-22 0 2020-09-22 ? 0 0006161898 20200922.ifs 2020-09-22 2020-09-23
4398116 4398116 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2020-07-01 2020-06-23 0 2020-06-23 ? 0 0006116795 20200623.ifs 2020-06-23 2020-06-24
4252115 4252115 DIVIDEND ADD 74347X294 0 0 1 0 .042077 00 2020-03-25 2020-03-26 2020-04-01 2020-03-24 0 2020-03-24 ? 0 0006072633 20200324.ifs 2020-03-24 2020-03-25
4252283 4252283 DIVIDEND ADD 74347X294 0 0 1 0 .042077 00 2020-03-25 2020-03-26 2020-04-01 2020-03-24 0 2020-03-24 ? 0 0006072633 20200324.ifs 2020-03-24 2020-03-25
4115489 4115489 DIVIDEND ADD 74347X294 0 0 1 0 .092563 00 2019-12-24 2019-12-26 2020-01-02 2019-12-23 0 2019-12-23 ? 0 0006021437 20191223.ifs 2019-12-23 2019-12-24
4115504 4115504 DIVIDEND ADD 74347X294 0 0 1 0 .092563 00 2019-12-24 2019-12-26 2020-01-02 2019-12-23 0 2019-12-23 ? 0 0006021437 20191223.ifs 2019-12-23 2019-12-24
3936221 3936221 DIVIDEND ADD 74347X294 0 0 1 0 .12532 00 2019-09-25 2019-09-26 2019-10-02 2019-09-24 0 2019-09-24 ? 0 0005949554 20190924.ifs 2019-09-24 2019-09-25
3936351 3936351 DIVIDEND ADD 74347X294 0 0 1 0 .12532 00 2019-09-25 2019-09-26 2019-10-02 2019-09-24 0 2019-09-24 ? 0 0005949554 20190924.ifs 2019-09-24 2019-09-25
3796611 3796611 DIVIDEND ADD 74347X294 0 0 1 0 .149741 00 2019-06-25 2019-06-26 2019-07-02 2019-06-24 0 2019-06-24 ? 0 0005903351 20190624.ifs 2019-06-24 2019-06-25
3796618 3796618 DIVIDEND ADD 74347X294 0 0 1 0 .149741 00 2019-06-25 2019-06-26 2019-07-02 2019-06-24 0 2019-06-24 ? 0 0005903351 20190624.ifs 2019-06-24 2019-06-25
3637471 3637471 DIVIDEND ADD 74347X294 0 0 1 0 .138859 00 2019-03-20 2019-03-21 2019-03-27 2019-03-19 0 2019-03-19 ? 0 0005854729 20190319.ifs 2019-03-19 2019-03-20
3637474 3637474 DIVIDEND ADD 74347X294 0 0 1 0 .138859 00 2019-03-20 2019-03-21 2019-03-27 2019-03-19 0 2019-03-19 ? 0 0005854729 20190319.ifs 2019-03-19 2019-03-20
3630386 3630386 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF 0 A 2011-07-14 ? 0 no no no 2011-07-14 2011-07-14 ? 20190315.ifs 2019-03-15 2019-03-16
3630388 3630387 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF 0 A 2011-07-14 ? 4 no no no 2011-07-14 2011-07-14 ? 20190315.ifs 2019-03-15 2019-03-16
3630391 3630391 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF 0 A 2011-07-14 ? 0 no no no 2011-07-14 2011-07-14 ? 20190315.ifs 2019-03-15 2019-03-16
3630393 3630392 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF 0 A 2011-07-14 ? 4 no no no 2011-07-14 2011-07-14 ? 20190315.ifs 2019-03-15 2019-03-16
3494790 3494790 DIVIDEND ADD 74347X294 0 0 1 0 .079968 00 2018-12-26 2018-12-27 2019-01-03 2018-12-24 0 2018-12-24 ? 0 0005804374 20181224.ifs 2018-12-24 2018-12-25
3298684 3298684 DIVIDEND ADD 74347X294 0 0 1 0 .080882 00 2018-09-26 2018-09-27 2018-10-03 2018-09-25 0 2018-09-25 ? 0 0005728655 20180925.ifs 2018-09-25 2018-09-26
3298796 3298796 DIVIDEND ADD 74347X294 0 0 1 0 .080882 00 2018-09-26 2018-09-27 2018-10-03 2018-09-25 0 2018-09-25 ? 0 0005728655 20180925.ifs 2018-09-25 2018-09-26
3145647 3145647 DIVIDEND ADD 74347X294 0 0 1 0 .05657 00 2018-06-20 2018-06-21 2018-06-27 2018-06-19 0 2018-06-19 ? 0 0005677402 20180619.ifs 2018-06-19 2018-06-20
3145678 3145678 DIVIDEND ADD 74347X294 0 0 1 0 .05657 00 2018-06-20 2018-06-21 2018-06-27 2018-06-19 0 2018-06-19 ? 0 0005677402 20180619.ifs 2018-06-19 2018-06-20
2998147 2998147 DIVIDEND ADD 74347X294 0 0 1 0 .004219 00 2018-03-21 2018-03-22 2018-03-28 2018-03-20 0 2018-03-20 ? 0 0005631966 20180320.ifs 2018-03-20 2018-03-21
2998292 2998292 DIVIDEND ADD 74347X294 0 0 1 0 .004219 00 2018-03-21 2018-03-22 2018-03-28 2018-03-20 0 2018-03-20 ? 0 0005631966 20180320.ifs 2018-03-20 2018-03-21
2864743 2864743 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2018-01-04 2017-12-22 0 2017-12-22 ? 0 0005579333 20171222.ifs 2017-12-22 2017-12-23
2864807 2864807 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2018-01-04 2017-12-22 0 2017-12-22 ? 0 0005579333 20171222.ifs 2017-12-22 2017-12-23
2687895 2687895 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2017-10-05 2017-09-26 0 2017-09-26 ? 0 0005502614 20170926.ifs 2017-09-26 2017-09-27
2595772 2595772 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2017-06-29 2017-06-20 0 2017-06-20 ? 0 0005452186 20170620.ifs 2017-06-20 2017-06-21
2517177 2517177 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2017-03-30 2017-03-21 0 2017-03-21 ? 0 0005405496 20170321.ifs 2017-03-21 2017-03-22
2386635 2386635 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2016-12-30 2016-12-20 0 2016-12-20 ? 0 0005346093 20161220.ifs 2016-12-20 2016-12-21
2297713 2297713 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2016-09-29 2016-09-20 0 2016-09-20 ? 0 0005283336 20160920.ifs 2016-09-20 2016-09-21
2226421 2226421 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2016-06-30 2016-06-21 0 2016-06-21 ? 0 0005236581 20160621.ifs 2016-06-21 2016-06-22
2140347 2140347 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2016-04-01 2016-03-22 0 2016-03-22 ? 0 0005190846 20160322.ifs 2016-03-22 2016-03-23
2055826 2055826 DIVIDEND ADD 74347X294 0 0 1 0 .00032 00 2015-12-22 2015-12-24 2015-12-31 2015-12-21 0 2015-12-21 ? 0 0005132808 20151221.ifs 2015-12-21 2015-12-22
2055827 2055827 DIVIDEND CHANGE 74347X294 0 0 E 0 0 58 ? ? 2013-12-31 2013-12-23 0 2013-12-23 ? 0 0004702622 20151221.ifs 2015-12-21 2015-12-22
2055828 2055827 DIVIDEND CHANGE 74347X294 0 0 E 0 0 58 ? ? 2013-12-31 2013-12-23 1 2013-12-23 2015-12-21 0 0004702622 20151221.ifs 2015-12-21 2015-12-22
1392680 1392680 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2013-12-31 2013-12-23 0 2013-12-23 ? 0 0004702622 20131223.ifs 2013-12-23 2013-12-24
1295619 1295619 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2013-10-01 2013-09-24 0 2013-09-24 ? 0 0004633149 20130924.ifs 2013-09-24 2013-09-25
1217227 1217227 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2013-07-02 2013-06-25 0 2013-06-25 ? 0 0004588894 20130625.ifs 2013-06-25 2013-06-26
1136232 1136232 DIVIDEND ADD 74347X294 0 0 E 0 0 58 ? ? 2013-03-26 2013-03-19 0 2013-03-19 ? 0 0004543115 20130319.ifs 2013-03-19 2013-03-20
1059074 1059074 DIVIDEND ADD 74347X294 0 0 1 4 .053002 00 2012-12-26 2012-12-28 2013-01-03 2012-12-24 0 2012-12-24 ? 0 0004494467 20121224.ifs 2012-12-24 2012-12-25
587812 587812 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF N A 2011-07-14 ? 0 no no no 2011-07-14 2011-07-14 ? 20110715.ifs 2011-07-15 2011-07-16
587813 587812 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF 0 A 2011-07-14 ? 0 no no no 2011-07-14 2011-07-14 ? 20110715.ifs 2011-07-15 2011-07-16
587067 587067 EQUITY ADD 74347X294 HEDGE REPLICATION ETF N 7 2011-07-14 ? 0 no no no 2011-07-14 ? ? 20110714.ifs 2011-07-14 2011-07-15
587068 587068 EXCHANGE ADD 74347X294 04 2011-07-14 2011-07-14 HDG 0 A 2011-07-14 ? 20110714.ifs 2011-07-14 2011-07-15
587245 587245 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF N 7 2011-07-14 ? 0 no no no 2011-07-14 ? ? 20110714.ifs 2011-07-14 2011-07-15
587246 587245 EQUITY CHANGE 74347X294 HEDGE REPLICATION ETF N A 2011-07-14 ? 0 no no no 2011-07-14 2011-07-14 ? 20110714.ifs 2011-07-14 2011-07-15


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