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

the compid is:151984
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
5295179 5295179 CORPACTION ADD 55315J102 66 D 2023-05-23 ? 20230523.ifs 2023-05-23 2023-05-24
5295180 5295180 EQUITY CHANGE 55315J102 SPONSORED ADR 0 0 2015-09-21 ? 1 no no no 2015-09-21 ? ? 20230523.ifs 2023-05-23 2023-05-24
5295181 5295180 EQUITY CHANGE 55315J102 SPONSORED ADR D 0 2015-09-21 2023-05-23 1 no no no 2015-09-21 2023-05-23 ? 20230523.ifs 2023-05-23 2023-05-24
5111297 5111297 DIVIDEND ADD 55315J102 0 0 1 0 0 00 ? 2022-06-14 ? 2022-06-03 0 ? 2022-10-03 0 0006535236 20221003.ifs 2022-10-03 2022-10-04
4940604 4940604 DIVIDEND ADD 55315J102 0 0 1 0 1.931619 00 2022-01-13 2022-01-14 2022-02-03 2021-11-24 0 ? 2022-01-28 0 0006398995 20220128.ifs 2022-01-28 2022-01-29
4729857 4729857 DIVIDEND DELETE 55315J102 0 0 1 5 1.372611 19 2021-05-28 2021-06-01 ? 2021-05-12 1 2021-05-12 2021-06-01 0 0006307493 20210615.ifs 2021-06-15 2021-06-16
4729858 4729858 DIVIDEND ADD 55315J102 0 0 1 0 1.419515 00 2021-05-28 2021-06-01 2021-06-22 2021-05-12 2 2021-05-12 2021-06-15 0 0006307493 20210615.ifs 2021-06-15 2021-06-16
4717755 4717755 DIVIDEND CHANGE 55315J102 0 0 1 5 1.372611 19 2021-05-28 2021-06-01 ? 2021-05-12 0 2021-05-12 ? 0 0006307493 20210601.ifs 2021-06-01 2021-06-02
4717756 4717755 DIVIDEND CHANGE 55315J102 0 0 1 5 1.372611 19 2021-05-28 2021-06-01 ? 2021-05-12 1 2021-05-12 2021-06-01 0 0006307493 20210601.ifs 2021-06-01 2021-06-02
4704136 4704136 DIVIDEND ADD 55315J102 0 0 1 5 1.372611 19 2021-05-28 2021-06-01 ? 2021-05-12 0 2021-05-12 ? 0 0006307493 20210512.ifs 2021-05-12 2021-05-13
4605790 4605790 DIVIDEND DELETE 55315J102 B 0 1 5 .679458 39 2020-12-23 2020-12-24 ? 2020-11-24 1 2020-11-24 2020-12-31 0 0006190502 20210113.ifs 2021-01-13 2021-01-14
4605791 4605791 DIVIDEND ADD 55315J102 B 0 1 0 .69453 02 2020-12-23 2020-12-24 2021-01-20 2020-11-24 2 2020-11-24 2021-01-13 0 0006190502 20210113.ifs 2021-01-13 2021-01-14
4592377 4592377 DIVIDEND DELETE 55315J102 0 0 1 5 .822892 19 2020-12-23 2020-12-24 ? 2020-11-24 0 2020-11-24 ? 0 0006190502 20201231.ifs 2020-12-31 2021-01-01
4592378 4592378 DIVIDEND ADD 55315J102 B 0 1 5 .679458 39 2020-12-23 2020-12-24 ? 2020-11-24 1 2020-11-24 2020-12-31 0 0006190502 20201231.ifs 2020-12-31 2021-01-01
4513037 4513037 DIVIDEND ADD 55315J102 0 0 1 5 .822892 19 2020-12-23 2020-12-24 ? 2020-11-24 0 2020-11-24 ? 0 0006190502 20201124.ifs 2020-11-24 2020-11-25
4390166 4390166 DIVIDEND ADD 55315J102 0 1 0 .809165 00 2020-05-21 2020-05-22 2020-06-18 ? 0 2020-06-11 ? 0 0006097043 20200611.ifs 2020-06-11 2020-06-12
4290220 4290220 DIVIDEND CHANGE 55315J102 0 0 1 0 .975792 00 2019-12-26 2019-12-27 2020-01-30 2019-11-22 1 2019-11-22 2020-01-24 0 0005977876 20200416.ifs 2020-04-16 2020-04-17
4290222 4290221 DIVIDEND CHANGE 55315J102 0 0 1 0 .975792 00 2019-12-26 2019-12-27 2020-01-30 2019-11-22 2 2019-11-22 2020-04-16 0 0005977876 20200416.ifs 2020-04-16 2020-04-17
4290531 4290531 DIVIDEND CHANGE 55315J102 0 0 1 0 .975792 00 2019-12-26 2019-12-27 2020-01-30 2019-11-22 1 2019-11-22 2020-01-24 0 0005977876 20200416.ifs 2020-04-16 2020-04-17
4290533 4290532 DIVIDEND CHANGE 55315J102 0 0 1 0 .975792 00 2019-12-26 2019-12-27 2020-01-30 2019-11-22 2 2019-11-22 2020-04-16 0 0005977876 20200416.ifs 2020-04-16 2020-04-17
4177502 4177502 DIVIDEND DELETE 55315J102 0 0 1 5 .94574 19 2019-12-26 2019-12-27 ? 2019-11-22 0 2019-11-22 ? 0 0005977876 20200124.ifs 2020-01-24 2020-01-25
4177504 4177504 DIVIDEND ADD 55315J102 0 0 1 0 .975792 00 2019-12-26 2019-12-27 2020-01-30 2019-11-22 1 2019-11-22 2020-01-24 0 0005977876 20200124.ifs 2020-01-24 2020-01-25
4177505 4177505 DIVIDEND DELETE 55315J102 0 0 1 5 .94574 19 2019-12-26 2019-12-27 ? 2019-11-22 0 2019-11-22 ? 0 0005977876 20200124.ifs 2020-01-24 2020-01-25
4177507 4177507 DIVIDEND ADD 55315J102 0 0 1 0 .975792 00 2019-12-26 2019-12-27 2020-01-30 2019-11-22 1 2019-11-22 2020-01-24 0 0005977876 20200124.ifs 2020-01-24 2020-01-25
4024742 4024742 DIVIDEND ADD 55315J102 0 0 1 5 .94574 19 2019-12-26 2019-12-27 ? 2019-11-22 0 2019-11-22 ? 0 0005977876 20191122.ifs 2019-11-22 2019-11-23
4024776 4024776 DIVIDEND ADD 55315J102 0 0 1 5 .94574 19 2019-12-26 2019-12-27 ? 2019-11-22 0 2019-11-22 ? 0 0005977876 20191122.ifs 2019-11-22 2019-11-23
3834087 3834087 DIVIDEND DELETE 55315J102 0 1 0 1.247029 00 2019-06-20 2019-06-21 2019-07-18 ? 0 2019-07-11 ? 0 0005886683 20190712.ifs 2019-07-12 2019-07-13
3834089 3834089 DIVIDEND ADD 55315J102 0 0 1 0 1.247029 0 00 2019-06-20 2019-06-21 2019-07-18 2019-05-24 0 ? 2019-07-12 0 0005886683 20190712.ifs 2019-07-12 2019-07-13
3834099 3834099 DIVIDEND DELETE 55315J102 0 1 0 1.247029 00 2019-06-20 2019-06-21 2019-07-18 ? 0 2019-07-11 ? 0 0005886683 20190712.ifs 2019-07-12 2019-07-13
3834101 3834101 DIVIDEND ADD 55315J102 0 0 1 0 1.247029 0 00 2019-06-20 2019-06-21 2019-07-18 2019-05-24 0 ? 2019-07-12 0 0005886683 20190712.ifs 2019-07-12 2019-07-13
3833161 3833161 DIVIDEND ADD 55315J102 0 1 0 1.247029 00 2019-06-20 2019-06-21 2019-07-18 ? 0 2019-07-11 ? 0 0005886683 20190711.ifs 2019-07-11 2019-07-12
3833300 3833300 DIVIDEND ADD 55315J102 0 1 0 1.247029 00 2019-06-20 2019-06-21 2019-07-18 ? 0 2019-07-11 ? 0 0005886683 20190711.ifs 2019-07-11 2019-07-12
3332339 3332339 DIVIDEND DELETE 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20181018.ifs 2018-10-18 2018-10-19
3332341 3332341 DIVIDEND ADD 55315J102 0 0 1 0 1.183382 0 00 2018-09-28 2018-10-01 2018-10-26 2018-08-17 0 ? 2018-10-18 0 0005709054 20181018.ifs 2018-10-18 2018-10-19
3333081 3333081 DIVIDEND DELETE 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20181018.ifs 2018-10-18 2018-10-19
3333082 3333082 DIVIDEND ADD 55315J102 0 0 1 0 1.183382 0 00 2018-09-28 2018-10-01 2018-10-26 2018-08-17 0 ? 2018-10-18 0 0005709054 20181018.ifs 2018-10-18 2018-10-19
3242988 3242988 DIVIDEND DELETE 55315J102 0 0 1 5 1.15055 19 ? 2018-10-01 ? 2018-08-17 0 2018-08-17 ? 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3242989 3242989 DIVIDEND DELETE 55315J102 0 0 1 5 1.15055 19 ? 2018-10-01 ? 2018-08-17 0 2018-08-17 ? 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3242990 3242990 DIVIDEND ADD 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3242991 3242991 DIVIDEND ADD 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3243650 3243650 DIVIDEND CHANGE 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3243651 3243651 DIVIDEND CHANGE 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3243652 3243651 DIVIDEND CHANGE 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3243653 3243652 DIVIDEND CHANGE 55315J102 0 0 1 5 1.15055 0 19 2018-09-28 2018-10-01 ? 2018-08-17 0 ? 2018-08-20 0 0005709054 20180820.ifs 2018-08-20 2018-08-21
3242528 3242528 DIVIDEND ADD 55315J102 0 0 1 5 1.15055 19 ? 2018-10-01 ? 2018-08-17 0 2018-08-17 ? 0 0005709054 20180817.ifs 2018-08-17 2018-08-18
3242529 3242529 DIVIDEND ADD 55315J102 0 0 1 5 1.15055 19 ? 2018-10-01 ? 2018-08-17 0 2018-08-17 ? 0 0005709054 20180817.ifs 2018-08-17 2018-08-18
3235004 3235004 DIVIDEND DELETE 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 1 2018-06-12 2018-06-18 0 0005673436 20180809.ifs 2018-08-09 2018-08-10
3235005 3235005 DIVIDEND DELETE 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 1 2018-06-12 2018-06-18 0 0005673436 20180809.ifs 2018-08-09 2018-08-10
3235006 3235006 DIVIDEND ADD 55315J102 0 0 1 0 .942825 00 2018-07-16 2018-07-17 2018-08-16 2018-06-12 2 2018-06-12 2018-08-09 0 0005673436 20180809.ifs 2018-08-09 2018-08-10
3235007 3235007 DIVIDEND ADD 55315J102 0 0 1 0 .942825 00 2018-07-16 2018-07-17 2018-08-16 2018-06-12 2 2018-06-12 2018-08-09 0 0005673436 20180809.ifs 2018-08-09 2018-08-10
3143926 3143926 DIVIDEND CHANGE 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 0 2018-06-12 ? 0 0005673436 20180618.ifs 2018-06-18 2018-06-19
3143927 3143927 DIVIDEND CHANGE 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 0 2018-06-12 ? 0 0005673436 20180618.ifs 2018-06-18 2018-06-19
3143928 3143927 DIVIDEND CHANGE 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 1 2018-06-12 2018-06-18 0 0005673436 20180618.ifs 2018-06-18 2018-06-19
3143929 3143928 DIVIDEND CHANGE 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 1 2018-06-12 2018-06-18 0 0005673436 20180618.ifs 2018-06-18 2018-06-19
3135177 3135177 DIVIDEND ADD 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 0 2018-06-12 ? 0 0005673436 20180612.ifs 2018-06-12 2018-06-13
3135297 3135297 DIVIDEND ADD 55315J102 0 0 1 5 .973616 19 2018-07-16 2018-07-17 ? 2018-06-12 0 2018-06-12 ? 0 0005673436 20180612.ifs 2018-06-12 2018-06-13
2761500 2761500 DIVIDEND DELETE 55315J102 0 0 1 5 .392043 19 2017-10-18 2017-10-19 ? 2017-09-08 0 2017-09-08 ? 0 0005495276 20171109.ifs 2017-11-09 2017-11-10
2761502 2761502 DIVIDEND ADD 55315J102 0 0 1 0 .379903 00 2017-10-18 2017-10-19 2017-11-14 2017-09-08 1 2017-09-08 2017-11-09 0 0005495276 20171109.ifs 2017-11-09 2017-11-10
2761940 2761940 DIVIDEND DELETE 55315J102 0 0 1 5 .392043 19 2017-10-18 2017-10-19 ? 2017-09-08 0 2017-09-08 ? 0 0005495276 20171109.ifs 2017-11-09 2017-11-10
2761941 2761941 DIVIDEND ADD 55315J102 0 0 1 0 .379903 00 2017-10-18 2017-10-19 2017-11-14 2017-09-08 1 2017-09-08 2017-11-09 0 0005495276 20171109.ifs 2017-11-09 2017-11-10
2668071 2668071 DIVIDEND ADD 55315J102 0 0 1 5 .392043 19 2017-10-18 2017-10-19 ? 2017-09-08 0 2017-09-08 ? 0 0005495276 20170908.ifs 2017-09-08 2017-09-09
2619638 2619638 DIVIDEND CHANGE 55315J102 0 0 1 0 .734669 00 2017-06-22 2017-06-23 2017-07-17 2017-05-08 2 2017-05-08 2017-07-11 0 0005433959 20170712.ifs 2017-07-12 2017-07-13
2619639 2619638 DIVIDEND CHANGE 55315J102 Special ex-date set by NMS. 0 0 1 0 .734669 0 00 2017-06-22 2017-06-23 2017-07-17 2017-05-08 2 2017-05-08 2017-07-12 0 0005433959 20170712.ifs 2017-07-12 2017-07-13
2619328 2619328 DIVIDEND DELETE 55315J102 0 0 1 5 .765928 19 2017-06-22 2017-06-23 ? 2017-05-08 1 2017-05-08 2017-05-09 0 0005433959 20170711.ifs 2017-07-11 2017-07-12
2619329 2619329 DIVIDEND ADD 55315J102 0 0 1 0 .734669 00 2017-06-22 2017-06-23 2017-07-17 2017-05-08 2 2017-05-08 2017-07-11 0 0005433959 20170711.ifs 2017-07-11 2017-07-12
2564392 2564392 DIVIDEND DELETE 55315J102 0 0 1 5 .765928 19 2017-06-21 2017-06-23 ? 2017-05-08 0 2017-05-08 ? 0 0005433959 20170509.ifs 2017-05-09 2017-05-10
2564393 2564393 DIVIDEND ADD 55315J102 0 0 1 5 .765928 19 2017-06-22 2017-06-23 ? 2017-05-08 1 2017-05-08 2017-05-09 0 0005433959 20170509.ifs 2017-05-09 2017-05-10
2563712 2563712 DIVIDEND ADD 55315J102 0 0 1 5 .765928 19 2017-06-21 2017-06-23 ? 2017-05-08 0 2017-05-08 ? 0 0005433959 20170508.ifs 2017-05-08 2017-05-09
2463999 2463999 EQUITY CHANGE 55315J102 SPONSORED ADR 0 0 2015-09-21 ? 0 no no no 2015-09-21 ? ? 20170126.ifs 2017-01-26 2017-01-27
2464000 2463999 EQUITY CHANGE 55315J102 SPONSORED ADR 0 0 2015-09-21 ? 1 no no no 2015-09-21 ? ? 20170126.ifs 2017-01-26 2017-01-27
2427786 2427786 DIVIDEND DELETE 55315J102 0 0 1 5 .687474 19 2016-12-23 2016-12-28 ? 2016-11-16 0 2016-11-16 ? 0 0005311833 20170118.ifs 2017-01-18 2017-01-19
2427787 2427787 DIVIDEND ADD 55315J102 0 0 1 0 .747595 00 2016-12-23 2016-12-28 2017-01-24 2016-11-16 1 2016-11-16 2017-01-18 0 0005311833 20170118.ifs 2017-01-18 2017-01-19
2344286 2344286 DIVIDEND ADD 55315J102 0 0 1 5 .687474 19 2016-12-23 2016-12-28 ? 2016-11-16 0 2016-11-16 ? 0 0005311833 20161116.ifs 2016-11-16 2016-11-17
2251232 2251232 DIVIDEND DELETE 55315J102 0 0 1 5 .351138 19 2016-06-20 2016-06-21 ? 2016-05-09 1 2016-05-09 2016-05-10 0 0005217767 20160714.ifs 2016-07-14 2016-07-15
2251233 2251233 DIVIDEND ADD 55315J102 0 0 1 0 .36048 00 2016-06-20 2016-06-21 2016-07-18 2016-05-09 2 2016-05-09 2016-07-14 0 0005217767 20160714.ifs 2016-07-14 2016-07-15
2193963 2193963 DIVIDEND DELETE 55315J102 0 0 1 5 .351138 19 ? 2016-06-21 ? 2016-05-09 0 2016-05-09 ? 0 0005217767 20160510.ifs 2016-05-10 2016-05-11
2193964 2193964 DIVIDEND ADD 55315J102 0 0 1 5 .351138 19 2016-06-20 2016-06-21 ? 2016-05-09 1 2016-05-09 2016-05-10 0 0005217767 20160510.ifs 2016-05-10 2016-05-11
2193120 2193120 DIVIDEND ADD 55315J102 0 0 1 5 .351138 19 ? 2016-06-21 ? 2016-05-09 0 2016-05-09 ? 0 0005217767 20160509.ifs 2016-05-09 2016-05-10
2096281 2096281 DIVIDEND DELETE 55315J102 0 0 1 5 .496768 19 2015-12-29 2015-12-30 ? 2015-11-20 1 2015-11-20 2015-11-23 0 0005095312 20160121.ifs 2016-01-21 2016-01-22
2096282 2096282 DIVIDEND ADD 55315J102 0 0 1 0 .380713 00 2015-12-29 2015-12-30 2016-01-27 2015-11-20 2 2015-11-20 2016-01-21 0 0005095312 20160121.ifs 2016-01-21 2016-01-22
2014105 2014105 DIVIDEND DELETE 55315J102 0 0 1 5 .496768 19 ? 2015-12-30 ? 2015-11-20 0 2015-11-20 ? 0 0005095312 20151123.ifs 2015-11-23 2015-11-24
2014106 2014106 DIVIDEND ADD 55315J102 0 0 1 5 .496768 19 2015-12-29 2015-12-30 ? 2015-11-20 1 2015-11-20 2015-11-23 0 0005095312 20151123.ifs 2015-11-23 2015-11-24
2013026 2013026 DIVIDEND ADD 55315J102 0 0 1 5 .496768 19 ? 2015-12-30 ? 2015-11-20 0 2015-11-20 ? 0 0005095312 20151120.ifs 2015-11-20 2015-11-21
1969931 1969931 EQUITY ADD 55315J102 SPONSORED ADR N 0 2015-09-21 ? 0 no no no 2015-09-21 ? ? 20150921.ifs 2015-09-21 2015-09-22
1969935 1969935 EXCHANGE ADD 55315J102 66 2015-09-21 2015-09-21 NILSY 0 0 2015-09-21 ? 20150921.ifs 2015-09-21 2015-09-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 = 151984
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