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

the compid is:130814
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
5553263 5553263 CORPACTION ADD 723787107 01 M 2024-05-03 30231G102 01 ? 20240503.ifs 2024-05-03 2024-05-04
5553264 5553264 EQUITY CHANGE 723787107 COM 0 0 1997-08-08 ? 4 yes no no 1999-04-07 2020-11-13 ? 20240503.ifs 2024-05-03 2024-05-04
5553265 5553264 EQUITY CHANGE 723787107 COM M 0 1997-08-08 2024-05-03 4 yes no 30231G102 no 1999-04-07 2024-05-03 ? 20240503.ifs 2024-05-03 2024-05-04
5501733 5501733 DIVIDEND ADD 723787107 0 0 1 0 2.56 00 2024-03-01 2024-03-04 2024-03-22 2024-02-22 0 2024-02-22 ? 0 0006878551 20240222.ifs 2024-02-22 2024-02-23
5410020 5410020 DIVIDEND ADD 723787107 0 0 1 0 3.2 00 2023-11-29 2023-11-30 2023-12-22 2023-11-02 0 2023-11-02 ? 0 0006809779 20231102.ifs 2023-11-02 2023-11-03
5345993 5345993 DIVIDEND ADD 723787107 0 0 1 0 1.84 00 2023-09-05 2023-09-06 2023-09-21 2023-08-01 0 2023-08-01 ? 0 0006765561 20230801.ifs 2023-08-01 2023-08-02
5290247 5290247 DIVIDEND DELETE 723787107 0 0 1 9 3.34 03 2023-05-31 2023-06-01 2023-06-21 2023-04-26 0 2023-04-26 ? 0 0006715602 20230512.ifs 2023-05-12 2023-05-13
5290248 5290248 DIVIDEND ADD 723787107 0 0 1 0 3.34 0 00 2023-05-31 2023-06-01 2023-06-21 2023-04-26 0 ? 2023-05-12 0 0006715602 20230512.ifs 2023-05-12 2023-05-13
5290249 5290249 DIVIDEND DELETE 723787107 0 0 1 9 5.58 03 2023-03-03 2023-03-06 2023-03-17 2023-02-22 0 2023-02-22 ? 0 0006684599 20230512.ifs 2023-05-12 2023-05-13
5290250 5290250 DIVIDEND ADD 723787107 0 0 1 0 5.58 0 00 2023-03-03 2023-03-06 2023-03-17 2023-02-22 0 ? 2023-05-12 0 0006684599 20230512.ifs 2023-05-12 2023-05-13
5290251 5290251 DIVIDEND DELETE 723787107 0 0 1 9 5.71 03 2022-11-29 2022-11-30 2022-12-15 2022-10-27 0 2022-10-27 ? 0 0006603220 20230512.ifs 2023-05-12 2023-05-13
5290252 5290252 DIVIDEND ADD 723787107 0 0 1 0 5.71 0 00 2022-11-29 2022-11-30 2022-12-15 2022-10-27 0 ? 2023-05-12 0 0006603220 20230512.ifs 2023-05-12 2023-05-13
5290253 5290253 DIVIDEND DELETE 723787107 0 0 1 9 8.57 03 2022-09-02 2022-09-06 2022-09-16 2022-08-02 0 2022-08-02 ? 0 0006566728 20230512.ifs 2023-05-12 2023-05-13
5290254 5290254 DIVIDEND ADD 723787107 0 0 1 0 8.57 0 00 2022-09-02 2022-09-06 2022-09-16 2022-08-02 0 ? 2023-05-12 0 0006566728 20230512.ifs 2023-05-12 2023-05-13
5290255 5290255 DIVIDEND CHANGE 723787107 0 0 1 9 7.38 03 2022-05-27 2022-05-31 2022-06-14 2022-05-04 0 2022-05-04 ? 0 0006521825 20230512.ifs 2023-05-12 2023-05-13
5290256 5290255 DIVIDEND CHANGE 723787107 0 0 1 0 7.38 0 03 2022-05-27 2022-05-31 2022-06-14 2022-05-04 0 2022-05-04 2023-05-12 0 0006521825 20230512.ifs 2023-05-12 2023-05-13
5290257 5290257 DIVIDEND DELETE 723787107 0 0 1 0 7.38 0 03 2022-05-27 2022-05-31 2022-06-14 2022-05-04 0 2022-05-04 2023-05-12 0 0006521825 20230512.ifs 2023-05-12 2023-05-13
5290258 5290258 DIVIDEND ADD 723787107 0 0 1 0 7.38 0 00 2022-05-27 2022-05-31 2022-06-14 2022-05-04 0 ? 2023-05-12 0 0006521825 20230512.ifs 2023-05-12 2023-05-13
5290259 5290259 DIVIDEND CHANGE 723787107 0 0 1 9 3.78 03 2022-02-25 2022-02-28 2022-03-14 2022-02-16 0 2022-02-16 ? 0 0006481734 20230512.ifs 2023-05-12 2023-05-13
5290260 5290259 DIVIDEND CHANGE 723787107 0 0 1 9 3 0 03 2022-02-25 2022-02-28 2022-03-14 2022-02-16 0 2022-02-16 2023-05-12 0 0006481734 20230512.ifs 2023-05-12 2023-05-13
5290261 5290261 DIVIDEND ADD 723787107 0 0 1 0 .78 00 2022-02-25 2022-02-28 2022-03-14 2022-02-16 0 ? 2023-05-12 0 20230512.ifs 2023-05-12 2023-05-13
5290262 5290262 DIVIDEND CHANGE 723787107 0 0 1 0 .78 00 2022-02-25 2022-02-28 2022-03-14 2022-02-16 0 ? 2023-05-12 0 20230512.ifs 2023-05-12 2023-05-13
5290263 5290262 DIVIDEND CHANGE 723787107 0 0 1 0 .78 00 2022-02-25 2022-02-28 2022-03-14 2022-02-16 0 ? 2023-05-12 0 0006725293 20230512.ifs 2023-05-12 2023-05-13
5290349 5290349 DIVIDEND CHANGE 723787107 0 0 1 0 3.34 0 00 2023-05-31 2023-06-01 2023-06-21 2023-04-26 0 ? 2023-05-12 0 0006715602 20230512.ifs 2023-05-12 2023-05-13
5290350 5290349 DIVIDEND CHANGE 723787107 0 0 1 0 3.34 0 00 2023-05-31 2023-06-01 2023-06-21 2023-04-26 0 ? 2023-05-12 0 0006715602 20230512.ifs 2023-05-12 2023-05-13
5277445 5277445 DIVIDEND ADD 723787107 0 0 1 9 3.34 03 2023-05-31 2023-06-01 2023-06-21 2023-04-26 0 2023-04-26 ? 0 0006715602 20230426.ifs 2023-04-26 2023-04-27
5233428 5233428 DIVIDEND ADD 723787107 0 0 1 9 5.58 03 2023-03-03 2023-03-06 2023-03-17 2023-02-22 0 2023-02-22 ? 0 0006684599 20230222.ifs 2023-02-22 2023-02-23
5126594 5126594 DIVIDEND ADD 723787107 0 0 1 9 5.71 03 2022-11-29 2022-11-30 2022-12-15 2022-10-27 0 2022-10-27 ? 0 0006603220 20221027.ifs 2022-10-27 2022-10-28
5072819 5072819 DIVIDEND ADD 723787107 0 0 1 9 8.57 03 2022-09-02 2022-09-06 2022-09-16 2022-08-02 0 2022-08-02 ? 0 0006566728 20220802.ifs 2022-08-02 2022-08-03
5007871 5007871 DIVIDEND ADD 723787107 0 0 1 9 7.38 03 2022-05-27 2022-05-31 2022-06-14 2022-05-04 0 2022-05-04 ? 0 0006521825 20220504.ifs 2022-05-04 2022-05-05
4954326 4954326 DIVIDEND ADD 723787107 0 0 1 9 3.78 03 2022-02-25 2022-02-28 2022-03-14 2022-02-16 0 2022-02-16 ? 0 0006481734 20220216.ifs 2022-02-16 2022-02-17
4843197 4843197 DIVIDEND ADD 723787107 0 0 1 9 3.02 03 2021-11-29 2021-11-30 2021-12-14 2021-11-03 0 2021-11-03 ? 0 0006394858 20211103.ifs 2021-11-03 2021-11-04
4843198 4843198 DIVIDEND ADD 723787107 0 0 1 0 .62 00 2021-12-30 2021-12-31 2022-01-14 2021-11-03 0 2021-11-03 ? 0 0006394734 20211103.ifs 2021-11-03 2021-11-04
4787671 4787671 DIVIDEND ADD 723787107 0 0 1 0 .56 00 2021-09-29 2021-09-30 2021-10-14 2021-08-26 0 2021-08-26 ? 0 0006356499 20210826.ifs 2021-08-26 2021-08-27
4771674 4771674 DIVIDEND ADD 723787107 0 0 1 0 1.51 00 2021-09-02 2021-09-03 2021-09-17 2021-08-02 0 2021-08-02 ? 0 0006349532 20210802.ifs 2021-08-02 2021-08-03
4712766 4712766 DIVIDEND ADD 723787107 0 0 1 0 .56 00 2021-06-29 2021-06-30 2021-07-14 2021-05-27 0 2021-05-27 ? 0 0006311489 20210527.ifs 2021-05-27 2021-05-28
4624348 4624348 DIVIDEND ADD 723787107 0 0 1 0 .56 00 2021-03-30 2021-03-31 2021-04-14 2021-02-04 0 2021-02-04 ? 0 0006262112 20210204.ifs 2021-02-04 2021-02-05
4509858 4509858 DIVIDEND ADD 723787107 0 0 1 0 .55 00 2020-12-30 2020-12-31 2021-01-14 2020-11-19 0 2020-11-19 ? 0 0006189568 20201119.ifs 2020-11-19 2020-11-20
4506284 4506284 EQUITY CHANGE 723787107 COM 0 0 1997-08-08 ? 2 yes yes no 1999-04-07 2000-03-24 ? 20201113.ifs 2020-11-13 2020-11-14
4506285 4506284 EQUITY CHANGE 723787107 COM 0 0 1997-08-08 ? 4 yes no no 1999-04-07 2020-11-13 ? 20201113.ifs 2020-11-13 2020-11-14
4443376 4443376 DIVIDEND ADD 723787107 0 0 1 0 .55 00 2020-09-29 2020-09-30 2020-10-14 2020-08-20 0 2020-08-20 ? 0 0006145604 20200820.ifs 2020-08-20 2020-08-21
4344913 4344913 DIVIDEND ADD 723787107 0 0 1 0 .55 00 2020-06-29 2020-06-30 2020-07-14 2020-05-20 0 2020-05-21 ? 0 0006100979 20200521.ifs 2020-05-21 2020-05-22
4344914 4344914 DIVIDEND ADD 723787107 0 0 1 0 .55 00 2020-06-29 2020-06-30 2020-07-14 2020-05-20 0 2020-05-21 ? 0 0006100979 20200521.ifs 2020-05-21 2020-05-22
4209452 4209452 DIVIDEND ADD 723787107 0 0 1 0 .55 00 2020-03-30 2020-03-31 2020-04-14 2020-02-19 0 2020-02-19 ? 0 0006056507 20200219.ifs 2020-02-19 2020-02-20
4209509 4209509 DIVIDEND ADD 723787107 0 0 1 0 .55 00 2020-03-30 2020-03-31 2020-04-14 2020-02-19 0 2020-02-19 ? 0 0006056507 20200219.ifs 2020-02-19 2020-02-20
4012183 4012183 DIVIDEND DELETE 723787107 0 0 1 0 .44 00 2019-12-30 2019-12-31 2019-01-14 2019-11-04 0 2019-11-04 ? 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012184 4012184 DIVIDEND ADD 723787107 0 0 1 0 .44 0 00 2019-12-30 2019-12-31 2020-01-14 2019-11-04 0 ? 2019-11-13 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012200 4012200 DIVIDEND DELETE 723787107 0 0 1 0 .44 00 2019-12-30 2019-12-31 2019-01-14 2019-11-04 0 2019-11-04 ? 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012202 4012202 DIVIDEND ADD 723787107 0 0 1 0 .44 0 00 2019-12-30 2019-12-31 2020-01-14 2019-11-04 0 ? 2019-11-13 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012883 4012883 DIVIDEND CHANGE 723787107 0 0 1 0 .44 0 00 2019-12-30 2019-12-31 2020-01-14 2019-11-04 0 ? 2019-11-13 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012885 4012884 DIVIDEND CHANGE 723787107 0 0 1 0 .44 0 00 2019-12-30 2019-12-31 2020-01-14 2019-11-04 0 ? 2019-11-13 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012890 4012890 DIVIDEND CHANGE 723787107 0 0 1 0 .44 0 00 2019-12-30 2019-12-31 2020-01-14 2019-11-04 0 ? 2019-11-13 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4012891 4012890 DIVIDEND CHANGE 723787107 0 0 1 0 .44 0 00 2019-12-30 2019-12-31 2020-01-14 2019-11-04 0 ? 2019-11-13 2 0005973254 20191113.ifs 2019-11-13 2019-11-14
4005149 4005149 DIVIDEND CHANGE 723787107 0 0 1 0 .44 00 2019-09-26 2019-09-27 2019-10-10 2019-08-06 0 2019-08-06 ? 0 0005928910 20191104.ifs 2019-11-04 2019-11-05
4005151 4005150 DIVIDEND CHANGE 723787107 0 0 1 0 .44 00 2019-09-26 2019-09-27 2019-10-10 2019-08-06 1 2019-08-06 2019-11-04 0 0005928910 20191104.ifs 2019-11-04 2019-11-05
4005153 4005153 DIVIDEND ADD 723787107 0 0 1 0 .44 00 2019-12-30 2019-12-31 2019-01-14 2019-11-04 0 2019-11-04 ? 2 0005973254 20191104.ifs 2019-11-04 2019-11-05
4005228 4005228 DIVIDEND CHANGE 723787107 0 0 1 0 .44 00 2019-09-26 2019-09-27 2019-10-10 2019-08-06 0 2019-08-06 ? 0 0005928910 20191104.ifs 2019-11-04 2019-11-05
4005230 4005229 DIVIDEND CHANGE 723787107 0 0 1 0 .44 00 2019-09-26 2019-09-27 2019-10-10 2019-08-06 1 2019-08-06 2019-11-04 0 0005928910 20191104.ifs 2019-11-04 2019-11-05
4005232 4005232 DIVIDEND ADD 723787107 0 0 1 0 .44 00 2019-12-30 2019-12-31 2019-01-14 2019-11-04 0 2019-11-04 ? 2 0005973254 20191104.ifs 2019-11-04 2019-11-05
3872664 3872664 DIVIDEND ADD 723787107 0 0 1 0 .44 00 2019-09-26 2019-09-27 2019-10-10 2019-08-06 0 2019-08-06 ? 0 0005928910 20190806.ifs 2019-08-06 2019-08-07
3872665 3872665 DIVIDEND ADD 723787107 0 0 1 0 .44 00 2019-09-26 2019-09-27 2019-10-10 2019-08-06 0 2019-08-06 ? 0 0005928910 20190806.ifs 2019-08-06 2019-08-07
3582189 3582189 DIVIDEND ADD 723787107 0 0 1 0 .32 00 2019-03-28 2019-03-29 2019-04-12 2019-02-13 0 2019-02-13 ? 0 0005838091 20190213.ifs 2019-02-13 2019-02-14
3582190 3582190 DIVIDEND ADD 723787107 0 0 1 0 .32 00 2019-03-28 2019-03-29 2019-04-12 2019-02-13 0 2019-02-13 ? 0 0005838091 20190213.ifs 2019-02-13 2019-02-14
3253899 3253899 DIVIDEND ADD 723787107 0 0 1 0 .16 00 2018-09-27 2018-09-28 2018-10-12 2018-08-30 0 2018-08-30 ? 0 0005712987 20180830.ifs 2018-08-30 2018-08-31
3253902 3253902 DIVIDEND ADD 723787107 0 0 1 0 .16 00 2018-09-27 2018-09-28 2018-10-12 2018-08-30 0 2018-08-30 ? 0 0005712987 20180830.ifs 2018-08-30 2018-08-31
2946622 2946622 DIVIDEND ADD 723787107 0 0 1 0 .16 00 2018-03-28 2018-03-29 2018-04-12 2018-02-06 0 2018-02-06 ? 0 0005613518 20180206.ifs 2018-02-06 2018-02-07
2946625 2946625 DIVIDEND ADD 723787107 0 0 1 0 .16 00 2018-03-28 2018-03-29 2018-04-12 2018-02-06 0 2018-02-06 ? 0 0005613518 20180206.ifs 2018-02-06 2018-02-07
2653963 2653963 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2017-09-28 2017-09-29 2017-10-12 2017-08-24 0 2017-08-24 ? 0 0005485529 20170824.ifs 2017-08-24 2017-08-25
2498776 2498776 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2017-03-29 2017-03-31 2017-04-12 2017-02-28 0 2017-02-28 ? 0 0005393093 20170228.ifs 2017-02-28 2017-03-01
2452140 2452140 EQUITY CHANGE 723787107 COM 0 0 1997-08-08 ? 8 yes yes no 1999-04-07 2000-03-24 ? 20170124.ifs 2017-01-24 2017-01-25
2452141 2452140 EQUITY CHANGE 723787107 COM 0 0 1997-08-08 ? 2 yes yes no 1999-04-07 2000-03-24 ? 20170124.ifs 2017-01-24 2017-01-25
2276639 2276639 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2016-09-28 2016-09-30 2016-10-12 2016-08-25 0 2016-08-25 ? 0 0005269333 20160825.ifs 2016-08-25 2016-08-26
2129350 2129350 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2016-03-29 2016-03-31 2016-04-12 2016-03-02 0 2016-03-02 ? 0 0005184107 20160302.ifs 2016-03-02 2016-03-03
1948339 1948339 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2015-09-28 2015-09-30 2015-10-09 2015-08-27 0 2015-08-27 ? 0 0005051393 20150827.ifs 2015-08-27 2015-08-28
1805721 1805721 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2015-03-27 2015-03-31 2015-04-09 2015-03-04 0 2015-03-04 ? 0 0004966042 20150304.ifs 2015-03-04 2015-03-05
1610107 1610107 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2014-09-26 2014-09-30 2014-10-10 2014-08-20 0 2014-08-20 ? 0 0004830287 20140820.ifs 2014-08-20 2014-08-21
1446124 1446124 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2014-03-27 2014-03-31 2014-04-11 2014-02-19 0 2014-02-19 ? 0 0004737839 20140219.ifs 2014-02-19 2014-02-20
1266836 1266836 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2013-09-26 2013-09-30 2013-10-11 2013-08-19 0 2013-08-19 ? 0 0004616333 20130819.ifs 2013-08-19 2013-08-20
1115582 1115582 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2013-03-26 2013-03-28 2013-04-11 2013-02-21 0 2013-02-21 ? 0 0004529849 20130221.ifs 2013-02-21 2013-02-22
938048 938048 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2012-09-26 2012-09-28 2012-10-12 2012-08-23 0 2012-08-23 ? 0 0004418231 20120823.ifs 2012-08-23 2012-08-24
783952 783952 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2012-03-28 2012-03-30 2012-04-12 2012-02-23 0 2012-02-23 ? 0 0004335167 20120223.ifs 2012-02-23 2012-02-24
627176 627176 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2011-09-28 2011-09-30 2011-10-14 2011-08-26 0 2011-08-26 ? 0 0004232320 20110826.ifs 2011-08-26 2011-08-27
444763 444763 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2011-03-29 2011-03-31 2011-04-14 2011-02-17 0 2011-02-17 ? 0 0004147561 20110217.ifs 2011-02-17 2011-02-18
290803 290803 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2010-09-28 2010-09-30 2010-10-14 2010-08-30 0 2010-08-30 ? 0 0004051178 20100830.ifs 2010-08-30 2010-08-31
111715 111715 DIVIDEND ADD 723787107 0 0 1 0 .04 00 2010-03-29 2010-03-31 2010-04-14 2010-02-17 0 2010-02-17 ? 0 0003965946 20100217.ifs 2010-02-17 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 = 130814
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