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

the compid is:130669
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
5576116 5576116 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2024-06-28 2024-06-28 2024-07-15 2024-06-13 0 2024-06-13 ? 0 0006932560 20240613.ifs 2024-06-13 2024-06-14
5514752 5514752 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2024-03-27 2024-03-28 2024-04-15 2024-02-21 0 2024-03-11 ? 0 0006888907 20240311.ifs 2024-03-11 2024-03-12
5444797 5444797 DIVIDEND ADD 44107P104 0 0 1 9 .25 03 2023-12-28 2023-12-29 2024-01-16 2023-12-15 0 2023-12-15 ? 1 0006833189 20231215.ifs 2023-12-15 2023-12-16
5444798 5444798 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2023-12-28 2023-12-29 2024-01-16 2023-12-15 0 2023-12-15 ? 0 0006833188 20231215.ifs 2023-12-15 2023-12-16
5373241 5373241 DIVIDEND ADD 44107P104 0 0 1 0 .18 00 2023-09-28 2023-09-30 2023-10-16 2023-09-14 0 2023-09-14 ? 0 0006783027 20230914.ifs 2023-09-14 2023-09-15
5311132 5311132 DIVIDEND ADD 44107P104 0 0 1 0 .15 00 2023-06-29 2023-06-30 2023-07-17 2023-06-14 0 2023-06-14 ? 0 0006738766 20230614.ifs 2023-06-14 2023-06-15
5230867 5230867 DIVIDEND ADD 44107P104 0 0 1 0 .12 00 2023-03-30 2023-03-31 2023-04-17 2023-02-15 0 2023-02-15 ? 0 0006682841 20230215.ifs 2023-02-15 2023-02-16
5171209 5171209 DIVIDEND ADD 44107P104 0 0 1 9 .2 03 2022-12-29 2022-12-30 2023-01-17 2022-12-15 0 2022-12-15 ? 1 0006634949 20221215.ifs 2022-12-15 2022-12-16
5171210 5171210 DIVIDEND ADD 44107P104 0 0 1 0 .12 00 2022-12-29 2022-12-30 2023-01-17 2022-12-15 0 2022-12-15 ? 0 0006634903 20221215.ifs 2022-12-15 2022-12-16
5074925 5074925 DIVIDEND ADD 44107P104 0 0 1 0 .12 00 2022-09-29 2022-09-30 2022-10-17 2022-08-04 0 2022-08-04 ? 0 0006568100 20220804.ifs 2022-08-04 2022-08-05
5007982 5007982 DIVIDEND ADD 44107P104 0 0 1 0 .06 00 2022-06-29 2022-06-30 2022-07-15 2022-05-04 0 2022-05-04 ? 0 0006521777 20220504.ifs 2022-05-04 2022-05-05
4954380 4954380 DIVIDEND ADD 44107P104 0 0 1 0 .03 00 2022-03-30 2022-03-31 2022-04-15 2022-02-16 0 2022-02-16 ? 0 0006481730 20220216.ifs 2022-02-16 2022-02-17
4518136 4518136 DIVIDEND CHANGE 44107P104 0 0 E 0 0 58 ? ? 2020-07-15 2020-06-19 0 2020-06-19 ? 0 0006115403 20201130.ifs 2020-11-30 2020-12-01
4518137 4518136 DIVIDEND CHANGE 44107P104 0 0 E 0 0 58 ? ? 2020-07-15 2020-06-19 1 2020-06-19 2020-11-30 0 0006115403 20201130.ifs 2020-11-30 2020-12-01
4497120 4497120 CORPACTION ADD 44107P104 01 X 2020-11-02 44107P104 60 ? 20201102.ifs 2020-11-02 2020-11-03
4497121 4497121 EXCHANGE ADD 44107P104 60 2020-11-02 2020-11-02 HST 0 0 2020-11-02 ? 20201102.ifs 2020-11-02 2020-11-03
4497122 4497122 EQUITY CHANGE 44107P104 COM 0 0 1998-12-04 ? 4 yes yes no 2001-12-06 1999-11-26 ? 20201102.ifs 2020-11-02 2020-11-03
4497123 4497122 EQUITY CHANGE 44107P104 COM 0 0 1998-12-04 ? 4 yes yes yes 2001-12-06 2020-11-02 ? 20201102.ifs 2020-11-02 2020-11-03
4396020 4396020 DIVIDEND ADD 44107P104 0 0 E 0 0 58 ? ? 2020-07-15 2020-06-19 0 2020-06-19 ? 0 0006115403 20200619.ifs 2020-06-19 2020-06-20
4209577 4209577 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2020-03-30 2020-03-31 2020-04-15 2020-02-19 0 2020-02-19 ? 0 0006056541 20200219.ifs 2020-02-19 2020-02-20
4209634 4209634 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2020-03-30 2020-03-31 2020-04-15 2020-02-19 0 2020-02-19 ? 0 0006056541 20200219.ifs 2020-02-19 2020-02-20
4068362 4068362 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2019-12-30 2019-12-31 2020-01-15 2019-12-13 0 2019-12-13 ? 1 0005999505 20191213.ifs 2019-12-13 2019-12-14
4068364 4068364 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-12-30 2019-12-31 2020-01-15 2019-12-13 0 2019-12-13 ? 0 0005999494 20191213.ifs 2019-12-13 2019-12-14
4068436 4068436 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2019-12-30 2019-12-31 2020-01-15 2019-12-13 0 2019-12-13 ? 1 0005999505 20191213.ifs 2019-12-13 2019-12-14
4068438 4068438 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-12-30 2019-12-31 2020-01-15 2019-12-13 0 2019-12-13 ? 0 0005999494 20191213.ifs 2019-12-13 2019-12-14
3923260 3923260 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-09-27 2019-09-30 2019-10-15 2019-09-13 0 2019-09-13 ? 0 0005945207 20190913.ifs 2019-09-13 2019-09-14
3923261 3923261 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-09-27 2019-09-30 2019-10-15 2019-09-13 0 2019-09-13 ? 0 0005945207 20190913.ifs 2019-09-13 2019-09-14
3781331 3781331 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-06-27 2019-06-28 2019-07-15 2019-06-14 0 2019-06-14 ? 0 0005897750 20190614.ifs 2019-06-14 2019-06-15
3781348 3781348 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-06-27 2019-06-28 2019-07-15 2019-06-14 0 2019-06-14 ? 0 0005897750 20190614.ifs 2019-06-14 2019-06-15
3589630 3589630 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-03-28 2019-03-29 2019-04-15 2019-02-19 0 2019-02-21 ? 0 0005840535 20190221.ifs 2019-02-21 2019-02-22
3589631 3589631 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2019-03-28 2019-03-29 2019-04-15 2019-02-19 0 2019-02-21 ? 0 0005840535 20190221.ifs 2019-02-21 2019-02-22
3443123 3443123 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2018-12-28 2018-12-31 2019-01-15 2018-12-14 0 2018-12-14 ? 1 0005778737 20181214.ifs 2018-12-14 2018-12-15
3443125 3443125 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-12-28 2018-12-31 2019-01-15 2018-12-14 0 2018-12-14 ? 0 0005778736 20181214.ifs 2018-12-14 2018-12-15
3443952 3443952 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2018-12-28 2018-12-31 2019-01-15 2018-12-14 0 2018-12-14 ? 1 0005778737 20181214.ifs 2018-12-14 2018-12-15
3443954 3443954 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-12-28 2018-12-31 2019-01-15 2018-12-14 0 2018-12-14 ? 0 0005778736 20181214.ifs 2018-12-14 2018-12-15
3284344 3284344 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-09-27 2018-09-28 2018-10-15 2018-09-14 0 2018-09-14 ? 0 0005724057 20180914.ifs 2018-09-14 2018-09-15
3284345 3284345 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-09-27 2018-09-28 2018-10-15 2018-09-14 0 2018-09-14 ? 0 0005724057 20180914.ifs 2018-09-14 2018-09-15
3139476 3139476 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-06-28 2018-06-29 2018-07-16 2018-06-14 0 2018-06-14 ? 0 0005674343 20180614.ifs 2018-06-14 2018-06-15
3139517 3139517 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-06-28 2018-06-29 2018-07-16 2018-06-14 0 2018-06-14 ? 0 0005674343 20180614.ifs 2018-06-14 2018-06-15
2961292 2961292 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-03-28 2018-03-29 2018-04-16 2018-02-21 0 2018-02-22 ? 0 0005617285 20180222.ifs 2018-02-22 2018-02-23
2961295 2961295 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2018-03-28 2018-03-29 2018-04-16 2018-02-21 0 2018-02-22 ? 0 0005617285 20180222.ifs 2018-02-22 2018-02-23
2905059 2905059 DIVIDEND DELETE 44107P104 0 0 1 9 .05 03 2017-12-28 2017-12-29 2018-01-15 2017-12-14 0 2017-12-14 ? 1 0005554096 20180102.ifs 2018-01-02 2018-01-03
2905061 2905061 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2017-12-28 2017-12-29 2018-01-16 2017-12-14 1 2017-12-14 2018-01-02 1 0005554096 20180102.ifs 2018-01-02 2018-01-03
2905063 2905063 DIVIDEND DELETE 44107P104 0 0 1 0 .2 00 2017-12-28 2017-12-29 2018-01-15 2017-12-14 0 2017-12-14 ? 0 0005554093 20180102.ifs 2018-01-02 2018-01-03
2905065 2905065 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2017-12-28 2017-12-29 2018-01-16 2017-12-14 1 2017-12-14 2018-01-02 0 0005554093 20180102.ifs 2018-01-02 2018-01-03
2905247 2905247 DIVIDEND DELETE 44107P104 0 0 1 9 .05 03 2017-12-28 2017-12-29 2018-01-15 2017-12-14 0 2017-12-14 ? 1 0005554096 20180102.ifs 2018-01-02 2018-01-03
2905249 2905249 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2017-12-28 2017-12-29 2018-01-16 2017-12-14 1 2017-12-14 2018-01-02 1 0005554096 20180102.ifs 2018-01-02 2018-01-03
2905251 2905251 DIVIDEND DELETE 44107P104 0 0 1 0 .2 00 2017-12-28 2017-12-29 2018-01-15 2017-12-14 0 2017-12-14 ? 0 0005554093 20180102.ifs 2018-01-02 2018-01-03
2905253 2905253 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2017-12-28 2017-12-29 2018-01-16 2017-12-14 1 2017-12-14 2018-01-02 0 0005554093 20180102.ifs 2018-01-02 2018-01-03
2676318 2676318 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2017-09-28 2017-09-29 2017-10-16 2017-09-18 0 2017-09-18 ? 0 0005498716 20170918.ifs 2017-09-18 2017-09-19
2676353 2676353 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2017-09-28 2017-09-29 2017-10-16 2017-09-18 0 2017-09-18 ? 0 0005498716 20170918.ifs 2017-09-18 2017-09-19
2592396 2592396 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2017-06-28 2017-06-30 2017-07-17 2017-06-15 0 2017-06-15 ? 0 0005449015 20170615.ifs 2017-06-15 2017-06-16
2493640 2493640 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2017-03-29 2017-03-31 2017-04-17 2017-02-21 0 2017-02-22 ? 0 0005390234 20170222.ifs 2017-02-22 2017-02-23
2439518 2439518 EQUITY CHANGE 44107P104 COM 0 0 1998-12-04 ? 8 yes yes no 2001-12-06 1999-11-26 ? 20170123.ifs 2017-01-23 2017-01-24
2439519 2439518 EQUITY CHANGE 44107P104 COM 0 0 1998-12-04 ? 4 yes yes no 2001-12-06 1999-11-26 ? 20170123.ifs 2017-01-23 2017-01-24
2377124 2377124 DIVIDEND ADD 44107P104 0 0 1 9 .05 03 2016-12-28 2016-12-30 2017-01-17 2016-12-15 0 2016-12-15 ? 1 0005334242 20161215.ifs 2016-12-15 2016-12-16
2377125 2377125 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2016-12-28 2016-12-30 2017-01-17 2016-12-15 0 2016-12-15 ? 0 0005334241 20161215.ifs 2016-12-15 2016-12-16
2294630 2294630 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2016-09-28 2016-09-30 2016-10-17 2016-09-15 0 2016-09-15 ? 0 0005280100 20160915.ifs 2016-09-15 2016-09-16
2221229 2221229 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2016-06-28 2016-06-30 2016-07-15 2016-06-15 0 2016-06-15 ? 0 0005232303 20160615.ifs 2016-06-15 2016-06-16
2114093 2114093 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2016-03-29 2016-03-31 2016-04-15 2016-02-16 0 2016-02-17 ? 0 0005173181 20160217.ifs 2016-02-17 2016-02-18
2040745 2040745 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2015-12-29 2015-12-31 2016-01-15 2015-12-15 0 2015-12-15 ? 0 0005116488 20151215.ifs 2015-12-15 2015-12-16
1965099 1965099 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2015-09-28 2015-09-30 2015-10-15 2015-09-14 0 2015-09-14 ? 0 0005061912 20150914.ifs 2015-09-14 2015-09-15
1884928 1884928 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2015-06-26 2015-06-30 2015-07-15 2015-06-11 0 2015-06-11 ? 0 0005013065 20150611.ifs 2015-06-11 2015-06-12
1699781 1699781 DIVIDEND ADD 44107P104 0 0 1 9 .06 03 2014-12-29 2014-12-31 2015-01-15 2014-12-04 0 2014-12-04 ? 1 0004884466 20141204.ifs 2014-12-04 2014-12-05
1699782 1699782 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2014-12-29 2014-12-31 2015-01-15 2014-12-04 0 2014-12-04 ? 0 0004884465 20141204.ifs 2014-12-04 2014-12-05
1592673 1592673 DIVIDEND ADD 44107P104 0 0 1 0 .2 00 2014-09-26 2014-09-30 2014-10-15 2014-07-31 0 2014-07-31 ? 0 0004819322 20140731.ifs 2014-07-31 2014-08-01
1446180 1446180 DIVIDEND ADD 44107P104 0 0 1 0 .14 00 2014-03-27 2014-03-31 2014-04-15 2014-02-18 0 2014-02-19 ? 0 0004737597 20140219.ifs 2014-02-19 2014-02-20
1377289 1377289 DIVIDEND ADD 44107P104 0 0 1 0 .13 00 2013-12-27 2013-12-31 2014-01-15 2013-12-17 0 2013-12-17 ? 0 0004686727 20131217.ifs 2013-12-17 2013-12-18
1288535 1288535 DIVIDEND ADD 44107P104 0 0 1 0 .12 00 2013-09-26 2013-09-30 2013-10-15 2013-09-16 0 2013-09-16 ? 0 0004629305 20130916.ifs 2013-09-16 2013-09-17
1211068 1211068 DIVIDEND ADD 44107P104 0 0 1 0 .11 00 2013-06-26 2013-06-28 2013-07-15 2013-06-17 0 2013-06-17 ? 0 0004584412 20130617.ifs 2013-06-17 2013-06-18
1114891 1114891 DIVIDEND ADD 44107P104 0 0 1 0 .1 00 2013-03-26 2013-03-28 2013-04-15 2013-02-20 0 2013-02-20 ? 0 0004529410 20130220.ifs 2013-02-20 2013-02-21
1018323 1018323 DIVIDEND ADD 44107P104 0 0 1 0 .09 00 2012-12-27 2012-12-31 2013-01-15 2012-11-29 0 2012-11-29 ? 0 0004461921 20121129.ifs 2012-11-29 2012-11-30
957672 957672 DIVIDEND ADD 44107P104 0 0 1 0 .08 00 2012-09-26 2012-09-28 2012-10-15 2012-09-17 0 2012-09-17 ? 0 0004429680 20120917.ifs 2012-09-17 2012-09-18
887526 887526 DIVIDEND ADD 44107P104 0 0 1 0 .07 00 2012-06-27 2012-06-29 2012-07-16 2012-06-18 0 2012-06-18 ? 0 0004387293 20120618.ifs 2012-06-18 2012-06-19
799289 799289 DIVIDEND ADD 44107P104 0 0 1 0 .06 00 2012-03-28 2012-03-30 2012-04-16 2012-03-08 0 2012-03-08 ? 0 0004344270 20120308.ifs 2012-03-08 2012-03-09
721796 721796 DIVIDEND ADD 44107P104 0 0 1 0 .05 00 2011-12-28 2011-12-30 2012-01-17 2011-12-14 0 2011-12-14 ? 0 0004287416 20111214.ifs 2011-12-14 2011-12-15
647049 647049 DIVIDEND ADD 44107P104 0 0 1 0 .04 00 2011-09-28 2011-09-30 2011-10-17 2011-09-19 0 2011-09-19 ? 0 0004243595 20110919.ifs 2011-09-19 2011-09-20
560313 560313 DIVIDEND ADD 44107P104 0 0 1 0 .03 00 2011-06-28 2011-06-30 2011-07-15 2011-06-15 0 2011-06-15 ? 0 0004200769 20110615.ifs 2011-06-15 2011-06-16
473826 473826 DIVIDEND ADD 44107P104 0 0 1 0 .02 00 2011-03-29 2011-03-31 2011-04-15 2011-03-17 0 2011-03-17 ? 0 0004160258 20110317.ifs 2011-03-17 2011-03-18
383394 383394 DIVIDEND ADD 44107P104 0 0 1 0 .01 00 2010-12-29 2010-12-31 2011-01-18 2010-12-17 0 2010-12-17 ? 0 0004107822 20101217.ifs 2010-12-17 2010-12-18
308757 308757 DIVIDEND ADD 44107P104 0 0 1 0 .01 00 2010-09-28 2010-09-30 2010-10-15 2010-09-16 0 2010-09-16 ? 0 0004060463 20100916.ifs 2010-09-16 2010-09-17
222907 222907 DIVIDEND ADD 44107P104 0 0 1 0 .01 00 2010-06-28 2010-06-30 2010-07-15 2010-06-18 0 2010-06-18 ? 0 0004019639 20100618.ifs 2010-06-18 2010-06-19
133396 133396 DIVIDEND ADD 44107P104 0 0 1 0 .01 00 2010-03-29 2010-03-31 2010-04-15 2010-03-16 0 2010-03-16 ? 0 0003978061 20100316.ifs 2010-03-16 2010-04-07
54533 54533 DIVIDEND DELETE 44107P104 optional 0 0 1 9 .25 0 03 2009-11-04 2009-11-06 2009-12-18 2009-09-14 0 ? 2009-10-15 0 0003881602 20091218.ifs 2009-12-18 2010-04-07
54534 54534 DIVIDEND ADD 44107P104 optional 0 0 4 9 .25 0 04 2009-11-04 2009-11-06 2009-12-18 2009-09-14 0 ? 2009-12-18 0 0003881602 20091218.ifs 2009-12-18 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 = 130669
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