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

the compid is:151493
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
5593329 5593329 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-07-15 2024-07-15 2024-07-31 2024-07-01 0 2024-07-01 ? 0 0006946632 20240701.ifs 2024-07-01 2024-07-02
5570132 5570132 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-06-14 2024-06-14 2024-06-28 2024-06-03 0 2024-06-03 ? 0 0006928260 20240603.ifs 2024-06-03 2024-06-04
5551673 5551673 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-05-14 2024-05-15 2024-05-31 2024-05-01 0 2024-05-01 ? 0 0006916302 20240501.ifs 2024-05-01 2024-05-02
5533136 5533136 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-04-12 2024-04-15 2024-04-30 2024-04-01 0 2024-04-01 ? 0 0006902784 20240401.ifs 2024-04-01 2024-04-02
5512539 5512539 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-03-14 2024-03-15 2024-03-28 2024-03-01 0 2024-03-04 ? 0 0006886966 20240304.ifs 2024-03-04 2024-03-05
5492990 5492990 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-02-14 2024-02-15 2024-02-29 2024-02-01 0 2024-02-01 ? 0 0006872798 20240201.ifs 2024-02-01 2024-02-02
5475952 5475952 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2024-01-11 2024-01-12 2024-01-31 2024-01-02 0 2024-01-02 ? 0 0006862488 20240102.ifs 2024-01-02 2024-01-03
5430177 5430177 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-12-14 2023-12-15 2023-12-20 2023-12-05 0 2023-12-05 ? 0 0006822969 20231205.ifs 2023-12-05 2023-12-06
5410377 5410377 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-11-14 2023-11-15 2023-11-30 2023-11-01 0 2023-11-02 ? 0 0006809421 20231102.ifs 2023-11-02 2023-11-03
5392310 5392310 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-10-13 2023-10-16 2023-10-31 2023-10-02 0 2023-10-03 ? 0 0006796211 20231003.ifs 2023-10-03 2023-10-04
5367287 5367287 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-09-14 2023-09-15 2023-09-29 2023-09-01 0 2023-09-01 ? 0 0006778686 20230901.ifs 2023-09-01 2023-09-02
5348315 5348315 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-08-14 2023-08-15 2023-08-31 2023-08-01 0 2023-08-01 ? 0 0006765631 20230801.ifs 2023-08-01 2023-08-02
5330107 5330107 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-07-13 2023-07-14 2023-07-31 2023-07-03 0 2023-07-03 ? 0 0006753363 20230703.ifs 2023-07-03 2023-07-04
5304967 5304967 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-06-14 2023-06-15 2023-06-30 2023-06-01 0 2023-06-01 ? 0 0006734671 20230601.ifs 2023-06-01 2023-06-02
5285042 5285042 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-05-12 2023-05-15 2023-05-31 2023-05-01 0 2023-05-01 ? 0 0006721648 20230501.ifs 2023-05-01 2023-05-02
5266553 5266553 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-04-13 2023-04-14 2023-04-28 2023-04-03 0 2023-04-03 ? 0 0006709302 20230403.ifs 2023-04-03 2023-04-04
5242999 5242999 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-03-14 2023-03-15 2023-03-31 2023-03-01 0 2023-03-01 ? 0 0006692570 20230301.ifs 2023-03-01 2023-03-02
5224864 5224864 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-02-14 2023-02-15 2023-02-28 2023-02-01 0 2023-02-01 ? 0 0006679410 20230201.ifs 2023-02-01 2023-02-02
5206307 5206307 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2023-01-12 2023-01-13 2023-01-31 2023-01-03 0 2023-01-03 ? 0 0006666631 20230103.ifs 2023-01-03 2023-01-04
5155779 5155779 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-12-15 2022-12-16 2022-12-30 2022-12-06 0 2022-12-06 ? 0 0006624072 20221206.ifs 2022-12-06 2022-12-07
5133497 5133497 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-11-14 2022-11-15 2022-11-30 2022-11-01 0 2022-11-01 ? 0 0006609143 20221101.ifs 2022-11-01 2022-11-02
5116468 5116468 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-10-13 2022-10-14 2022-10-31 2022-10-03 0 2022-10-04 ? 0 0006597228 20221004.ifs 2022-10-04 2022-10-05
5091362 5091362 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-09-14 2022-09-15 2022-09-30 2022-09-01 0 2022-09-01 ? 0 0006579795 20220901.ifs 2022-09-01 2022-09-02
5071558 5071558 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-08-12 2022-08-15 2022-08-31 2022-08-01 0 2022-08-01 ? 0 0006565382 20220801.ifs 2022-08-01 2022-08-02
5054338 5054338 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-07-14 2022-07-15 2022-07-29 2022-07-01 0 2022-07-05 ? 0 0006553225 20220705.ifs 2022-07-05 2022-07-06
5025163 5025163 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-06-14 2022-06-15 2022-06-30 2022-06-01 0 2022-06-01 ? 0 0006532915 20220601.ifs 2022-06-01 2022-06-02
5005849 5005849 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-05-13 2022-05-16 2022-05-31 2022-05-02 0 2022-05-02 ? 0 0006519653 20220502.ifs 2022-05-02 2022-05-03
4988137 4988137 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-04-13 2022-04-14 2022-04-29 2022-04-01 0 2022-04-01 ? 0 0006507657 20220401.ifs 2022-04-01 2022-04-02
4963981 4963981 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-03-14 2022-03-15 2022-03-31 2022-03-01 0 2022-03-01 ? 0 0006488854 20220301.ifs 2022-03-01 2022-03-02
4946432 4946432 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-02-14 2022-02-15 2022-02-28 2022-02-01 0 2022-02-01 ? 0 0006476656 20220201.ifs 2022-02-01 2022-02-02
4929331 4929331 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2022-01-13 2022-01-14 2022-01-31 2022-01-03 0 2022-01-03 ? 0 0006465408 20220103.ifs 2022-01-03 2022-01-04
4867146 4867146 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-12-16 2021-12-17 2021-12-31 2021-12-06 0 2021-12-06 ? 0 0006409950 20211206.ifs 2021-12-06 2021-12-07
4841047 4841047 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-11-12 2021-11-15 2021-11-30 2021-11-01 0 2021-11-01 ? 0 0006393592 20211101.ifs 2021-11-01 2021-11-02
4821162 4821162 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-10-14 2021-10-15 2021-10-29 2021-10-01 0 2021-10-01 ? 0 0006381272 20211001.ifs 2021-10-01 2021-10-02
4795152 4795152 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-09-14 2021-09-15 2021-09-30 2021-09-01 0 2021-09-01 ? 0 0006363515 20210901.ifs 2021-09-01 2021-09-02
4773847 4773847 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-08-13 2021-08-16 2021-08-31 2021-08-02 0 2021-08-02 ? 0 0006349897 20210802.ifs 2021-08-02 2021-08-03
4750643 4750643 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-07-14 2021-07-15 2021-07-30 2021-07-01 0 2021-07-01 ? 0 0006336605 20210701.ifs 2021-07-01 2021-07-02
4719782 4719782 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-06-14 2021-06-15 2021-06-30 2021-06-01 0 2021-06-01 ? 0 0006317901 20210601.ifs 2021-06-01 2021-06-02
4698154 4698154 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-05-13 2021-05-14 2021-05-28 2021-05-03 0 2021-05-03 ? 0 0006304437 20210503.ifs 2021-05-03 2021-05-04
4674913 4674913 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-04-14 2021-04-15 2021-04-30 2021-04-01 0 2021-04-01 ? 0 0006291565 20210401.ifs 2021-04-01 2021-04-02
4644514 4644514 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-03-12 2021-03-15 2021-03-31 2021-03-01 0 2021-03-01 ? 0 0006273879 20210301.ifs 2021-03-01 2021-03-02
4621538 4621538 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-02-12 2021-02-16 2021-02-26 2021-02-01 0 2021-02-01 ? 0 0006260946 20210201.ifs 2021-02-01 2021-02-02
4599274 4599274 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2021-01-14 2021-01-15 2021-01-29 2021-01-04 0 2021-01-04 ? 0 0006249741 20210104.ifs 2021-01-04 2021-01-05
4527956 4527956 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-12-14 2020-12-15 2020-12-31 2020-12-04 0 2020-12-04 ? 0 0006201008 20201204.ifs 2020-12-04 2020-12-05
4500690 4500690 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-11-13 2020-11-16 2020-11-30 2020-11-02 0 2020-11-02 ? 0 0006185164 20201102.ifs 2020-11-02 2020-11-03
4479962 4479962 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-10-14 2020-10-15 2020-10-30 2020-10-01 0 2020-10-01 ? 0 0006172477 20201001.ifs 2020-10-01 2020-10-02
4454393 4454393 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-09-14 2020-09-15 2020-09-30 2020-09-01 0 2020-09-01 ? 0 0006154298 20200901.ifs 2020-09-01 2020-09-02
4433848 4433848 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-08-13 2020-08-14 2020-08-31 2020-08-03 0 2020-08-03 ? 0 0006140266 20200803.ifs 2020-08-03 2020-08-04
4412345 4412345 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-07-14 2020-07-15 2020-07-31 2020-07-01 0 2020-07-01 ? 0 0006127747 20200701.ifs 2020-07-01 2020-07-02
4360993 4360993 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-06-12 2020-06-15 2020-06-30 2020-06-01 0 2020-06-01 ? 0 0006108526 20200601.ifs 2020-06-01 2020-06-02
4365387 4365387 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-06-12 2020-06-15 2020-06-30 2020-06-01 0 2020-06-01 ? 0 0006108526 20200601.ifs 2020-06-01 2020-06-02
4369781 4369781 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-06-12 2020-06-15 2020-06-30 2020-06-01 0 2020-06-01 ? 0 0006108526 20200601.ifs 2020-06-01 2020-06-02
4374175 4374175 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-06-12 2020-06-15 2020-06-30 2020-06-01 0 2020-06-01 ? 0 0006108526 20200601.ifs 2020-06-01 2020-06-02
4378569 4378569 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-06-12 2020-06-15 2020-06-30 2020-06-01 0 2020-06-01 ? 0 0006108526 20200601.ifs 2020-06-01 2020-06-02
4382963 4382963 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-06-12 2020-06-15 2020-06-30 2020-06-01 0 2020-06-01 ? 0 0006108526 20200601.ifs 2020-06-01 2020-06-02
4319153 4319153 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-05-14 2020-05-15 2020-05-29 2020-05-01 0 2020-05-01 ? 0 0006095467 20200501.ifs 2020-05-01 2020-05-02
4319194 4319194 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-05-14 2020-05-15 2020-05-29 2020-05-01 0 2020-05-01 ? 0 0006095467 20200501.ifs 2020-05-01 2020-05-02
4276237 4276237 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-04-14 2020-04-15 2020-04-30 2020-04-01 0 2020-04-01 ? 0 0006082437 20200401.ifs 2020-04-01 2020-04-02
4276696 4276696 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-04-14 2020-04-15 2020-04-30 2020-04-01 0 2020-04-01 ? 0 0006082437 20200401.ifs 2020-04-01 2020-04-02
4228015 4228015 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-03-13 2020-03-16 2020-03-31 2020-03-02 0 2020-03-02 ? 0 0006064955 20200302.ifs 2020-03-02 2020-03-03
4228036 4228036 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-03-13 2020-03-16 2020-03-31 2020-03-02 0 2020-03-02 ? 0 0006064955 20200302.ifs 2020-03-02 2020-03-03
4195590 4195590 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-02-13 2020-02-14 2020-02-28 2020-02-03 0 2020-02-03 ? 0 0006052187 20200203.ifs 2020-02-03 2020-02-04
4196092 4196092 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-02-13 2020-02-14 2020-02-28 2020-02-03 0 2020-02-03 ? 0 0006052187 20200203.ifs 2020-02-03 2020-02-04
4158822 4158822 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-01-14 2020-01-15 2020-01-31 2020-01-02 0 2020-01-02 ? 0 0006040482 20200102.ifs 2020-01-02 2020-01-03
4158875 4158875 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2020-01-14 2020-01-15 2020-01-31 2020-01-02 0 2020-01-02 ? 0 0006040482 20200102.ifs 2020-01-02 2020-01-03
4048204 4048204 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-12-13 2019-12-16 2019-12-31 2019-12-06 0 2019-12-06 ? 0 0005989984 20191206.ifs 2019-12-06 2019-12-07
4048306 4048306 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-12-13 2019-12-16 2019-12-31 2019-12-06 0 2019-12-06 ? 0 0005989984 20191206.ifs 2019-12-06 2019-12-07
4002922 4002922 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-11-14 2019-11-15 2019-11-29 2019-11-01 0 2019-11-01 ? 0 0005972253 20191101.ifs 2019-11-01 2019-11-02
4002923 4002923 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-11-14 2019-11-15 2019-11-29 2019-11-01 0 2019-11-01 ? 0 0005972253 20191101.ifs 2019-11-01 2019-11-02
3960261 3960261 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-10-11 2019-10-15 2019-10-31 2019-10-01 0 2019-10-01 ? 0 0005958941 20191001.ifs 2019-10-01 2019-10-02
3960272 3960272 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-10-11 2019-10-15 2019-10-31 2019-10-01 0 2019-10-01 ? 0 0005958941 20191001.ifs 2019-10-01 2019-10-02
3908071 3908071 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-09-13 2019-09-16 2019-09-30 2019-09-03 0 2019-09-03 ? 0 0005940589 20190903.ifs 2019-09-03 2019-09-04
3908086 3908086 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-09-13 2019-09-16 2019-09-30 2019-09-03 0 2019-09-03 ? 0 0005940589 20190903.ifs 2019-09-03 2019-09-04
3866644 3866644 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-08-14 2019-08-15 2019-08-30 2019-08-01 0 2019-08-01 ? 0 0005926811 20190801.ifs 2019-08-01 2019-08-02
3866680 3866680 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-08-14 2019-08-15 2019-08-30 2019-08-01 0 2019-08-01 ? 0 0005926811 20190801.ifs 2019-08-01 2019-08-02
3822704 3822704 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-07-12 2019-07-15 2019-07-31 2019-07-01 0 2019-07-01 ? 0 0005913265 20190701.ifs 2019-07-01 2019-07-02
3822810 3822810 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-07-12 2019-07-15 2019-07-31 2019-07-01 0 2019-07-01 ? 0 0005913265 20190701.ifs 2019-07-01 2019-07-02
3762764 3762764 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-06-13 2019-06-14 2019-06-28 2019-06-03 0 2019-06-03 ? 0 0005894134 20190603.ifs 2019-06-03 2019-06-04
3762990 3762990 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-06-13 2019-06-14 2019-06-28 2019-06-03 0 2019-06-03 ? 0 0005894134 20190603.ifs 2019-06-03 2019-06-04
3713001 3713001 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-05-14 2019-05-15 2019-05-31 2019-05-01 0 2019-05-01 ? 0 0005879615 20190501.ifs 2019-05-01 2019-05-02
3713028 3713028 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-05-14 2019-05-15 2019-05-31 2019-05-01 0 2019-05-01 ? 0 0005879615 20190501.ifs 2019-05-01 2019-05-02
3671039 3671039 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-04-12 2019-04-15 2019-04-30 2019-04-01 0 2019-04-01 ? 0 0005866763 20190401.ifs 2019-04-01 2019-04-02
3671110 3671110 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-04-12 2019-04-15 2019-04-30 2019-04-01 0 2019-04-01 ? 0 0005866763 20190401.ifs 2019-04-01 2019-04-02
3612065 3612065 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-03-14 2019-03-15 2019-03-29 2019-03-01 0 2019-03-01 ? 0 0005848684 20190301.ifs 2019-03-01 2019-03-02
3612309 3612309 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-03-14 2019-03-15 2019-03-29 2019-03-01 0 2019-03-01 ? 0 0005848684 20190301.ifs 2019-03-01 2019-03-02
3536298 3536298 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-01-14 2019-01-15 2019-01-31 2019-01-02 0 2019-01-02 ? 0 0005822531 20190102.ifs 2019-01-02 2019-01-03
3536301 3536301 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2019-01-14 2019-01-15 2019-01-31 2019-01-02 0 2019-01-02 ? 0 0005822531 20190102.ifs 2019-01-02 2019-01-03
3415347 3415347 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2018-12-14 2018-12-17 2018-12-31 2018-12-07 0 2018-12-07 ? 0 0005769498 20181207.ifs 2018-12-07 2018-12-08
3415587 3415587 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2018-12-14 2018-12-17 2018-12-31 2018-12-07 0 2018-12-07 ? 0 0005769498 20181207.ifs 2018-12-07 2018-12-08
3358943 3358943 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2018-11-14 2018-11-15 2018-11-30 2018-11-01 0 2018-11-01 ? 0 0005750857 20181101.ifs 2018-11-01 2018-11-02
3359046 3359046 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2018-11-14 2018-11-15 2018-11-30 2018-11-01 0 2018-11-01 ? 0 0005750857 20181101.ifs 2018-11-01 2018-11-02
3318712 3318712 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2018-10-12 2018-10-15 2018-10-31 2018-10-01 0 2018-10-01 ? 0 0005737081 20181001.ifs 2018-10-01 2018-10-02
3318781 3318781 DIVIDEND ADD 092524107 0 0 1 0 .0338 00 2018-10-12 2018-10-15 2018-10-31 2018-10-01 0 2018-10-01 ? 0 0005737081 20181001.ifs 2018-10-01 2018-10-02
3267516 3267516 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-09-13 2018-09-14 2018-09-28 2018-09-04 0 2018-09-04 ? 0 0005719112 20180904.ifs 2018-09-04 2018-09-05
3267852 3267852 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-09-13 2018-09-14 2018-09-28 2018-09-04 0 2018-09-04 ? 0 0005719112 20180904.ifs 2018-09-04 2018-09-05
3228207 3228207 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-08-14 2018-08-15 2018-08-31 2018-08-01 0 2018-08-02 ? 0 0005704981 20180802.ifs 2018-08-02 2018-08-03
3228226 3228226 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-08-14 2018-08-15 2018-08-31 2018-08-01 0 2018-08-02 ? 0 0005704981 20180802.ifs 2018-08-02 2018-08-03
3179126 3179126 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-07-13 2018-07-16 2018-07-31 2018-07-02 0 2018-07-02 ? 0 0005690001 20180702.ifs 2018-07-02 2018-07-03
3180137 3180137 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-07-13 2018-07-16 2018-07-31 2018-07-02 0 2018-07-02 ? 0 0005690001 20180702.ifs 2018-07-02 2018-07-03
3122137 3122137 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-06-14 2018-06-15 2018-06-29 2018-06-01 0 2018-06-01 ? 0 0005671624 20180601.ifs 2018-06-01 2018-06-02
3122150 3122150 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-06-14 2018-06-15 2018-06-29 2018-06-01 0 2018-06-01 ? 0 0005671624 20180601.ifs 2018-06-01 2018-06-02
3073394 3073394 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-05-14 2018-05-15 2018-05-31 2018-05-01 0 2018-05-01 ? 0 0005657553 20180501.ifs 2018-05-01 2018-05-02
3073427 3073427 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-05-14 2018-05-15 2018-05-31 2018-05-01 0 2018-05-01 ? 0 0005657553 20180501.ifs 2018-05-01 2018-05-02
3020798 3020798 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-04-13 2018-04-16 2018-04-30 2018-04-02 0 2018-04-02 ? 0 0005644361 20180402.ifs 2018-04-02 2018-04-03
3025268 3025268 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-04-13 2018-04-16 2018-04-30 2018-04-02 0 2018-04-02 ? 0 0005644361 20180402.ifs 2018-04-02 2018-04-03
2976929 2976929 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-03-14 2018-03-15 2018-03-29 2018-03-01 0 2018-03-01 ? 0 0005625667 20180301.ifs 2018-03-01 2018-03-02
2978733 2978733 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-03-14 2018-03-15 2018-03-29 2018-03-01 0 2018-03-01 ? 0 0005625667 20180301.ifs 2018-03-01 2018-03-02
2941920 2941920 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-02-14 2018-02-15 2018-02-28 2018-02-01 0 2018-02-01 ? 0 0005611975 20180201.ifs 2018-02-01 2018-02-02
2906629 2906629 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-01-12 2018-01-16 2018-01-31 2018-01-02 0 2018-01-02 ? 0 0005599058 20180102.ifs 2018-01-02 2018-01-03
2906815 2906815 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2018-01-12 2018-01-16 2018-01-31 2018-01-02 0 2018-01-02 ? 0 0005599058 20180102.ifs 2018-01-02 2018-01-03
2821415 2821415 DIVIDEND DELETE 092524107 0 0 1 0 .038 00 2017-12-14 2017-12-15 2017-12-29 2017-12-08 0 2017-12-08 ? 0 0005546716 20171211.ifs 2017-12-11 2017-12-12
2821416 2821416 DIVIDEND DELETE 092524107 0 0 1 0 .038 00 2017-12-14 2017-12-15 2017-12-29 2017-12-08 0 2017-12-08 ? 0 0005546716 20171211.ifs 2017-12-11 2017-12-12
2821417 2821417 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-12-15 2017-12-18 2017-12-29 2017-12-08 1 2017-12-08 2017-12-11 0 0005546716 20171211.ifs 2017-12-11 2017-12-12
2821418 2821418 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-12-15 2017-12-18 2017-12-29 2017-12-08 1 2017-12-08 2017-12-11 0 0005546716 20171211.ifs 2017-12-11 2017-12-12
2818263 2818263 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-12-14 2017-12-15 2017-12-29 2017-12-08 0 2017-12-08 ? 0 0005546716 20171208.ifs 2017-12-08 2017-12-09
2818359 2818359 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-12-14 2017-12-15 2017-12-29 2017-12-08 0 2017-12-08 ? 0 0005546716 20171208.ifs 2017-12-08 2017-12-09
2752132 2752132 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-11-14 2017-11-15 2017-11-30 2017-11-01 0 2017-11-01 ? 0 0005525522 20171101.ifs 2017-11-01 2017-11-02
2711071 2711071 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-10-13 2017-10-16 2017-10-31 2017-10-02 0 2017-10-02 ? 0 0005511397 20171002.ifs 2017-10-02 2017-10-03
2711140 2711140 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-10-13 2017-10-16 2017-10-31 2017-10-02 0 2017-10-02 ? 0 0005511397 20171002.ifs 2017-10-02 2017-10-03
2664696 2664696 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-09-14 2017-09-15 2017-09-29 2017-09-01 0 2017-09-01 ? 0 0005493310 20170901.ifs 2017-09-01 2017-09-02
2641388 2641388 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-08-11 2017-08-15 2017-08-31 2017-08-01 0 2017-08-01 ? 0 0005479084 20170801.ifs 2017-08-01 2017-08-02
2614539 2614539 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-07-12 2017-07-14 2017-07-31 2017-07-03 0 2017-07-03 ? 0 0005464383 20170703.ifs 2017-07-03 2017-07-04
2588486 2588486 CORPACTION ADD 092524107 01 # 2017-06-12 092524107 01 2017-06-12 20170612.ifs 2017-06-12 2017-06-13
2588487 2588487 CORPACTIONAUX ADD 092524107 01 2017-06-12 BGY BLACKROCK INTL GROWTH & INCOME COM BGY BLACKROCK ENHANCED INTL DIVIDE COM ? 2017-06-12 20170612.ifs 2017-06-12 2017-06-13
2588488 2588488 EXCHANGE CHANGE 092524107 01 2007-05-25 2017-06-09 BGY 0 7 2007-05-25 2007-05-29 20170612.ifs 2017-06-12 2017-06-13
2588489 2588488 EXCHANGE CHANGE 092524107 01 2007-05-25 2017-06-09 BGY 0 7 2007-05-25 2017-06-12 20170612.ifs 2017-06-12 2017-06-13
2583587 2583587 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-06-13 2017-06-15 2017-06-30 2017-06-01 0 2017-06-01 ? 0 0005445784 20170601.ifs 2017-06-01 2017-06-02
2557453 2557453 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-05-11 2017-05-15 2017-05-31 2017-05-01 0 2017-05-01 ? 0 0005431109 20170501.ifs 2017-05-01 2017-05-02
2534275 2534275 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-04-11 2017-04-13 2017-04-28 2017-04-03 0 2017-04-03 ? 0 0005418262 20170403.ifs 2017-04-03 2017-04-04
2505256 2505256 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-03-13 2017-03-15 2017-03-31 2017-03-01 0 2017-03-01 ? 0 0005398558 20170301.ifs 2017-03-01 2017-03-02
2483239 2483239 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-02-13 2017-02-15 2017-02-28 2017-02-01 0 2017-02-01 ? 0 0005385449 20170201.ifs 2017-02-01 2017-02-02
2430396 2430396 EQUITY CHANGE 092524107 COM 0 7 2007-05-25 ? 0 no no no 2007-05-25 2009-06-01 ? 20170120.ifs 2017-01-20 2017-01-21
2430397 2430396 EQUITY CHANGE 092524107 COM 0 7 2007-05-25 ? 5 no no no 2007-05-25 2009-06-01 ? 20170120.ifs 2017-01-20 2017-01-21
2417648 2417648 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2017-01-11 2017-01-13 2017-01-31 2017-01-03 0 2017-01-03 ? 0 0005371779 20170103.ifs 2017-01-03 2017-01-04
2364593 2364593 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2016-12-15 2016-12-19 2016-12-30 2016-12-07 0 2016-12-07 ? 0 0005326044 20161207.ifs 2016-12-07 2016-12-08
2336344 2336344 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2016-11-10 2016-11-15 2016-11-30 2016-11-01 0 2016-11-01 ? 0 0005308367 20161101.ifs 2016-11-01 2016-11-02
2314952 2314952 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2016-10-12 2016-10-14 2016-10-31 2016-10-03 0 2016-10-03 ? 0 0005295010 20161003.ifs 2016-10-03 2016-10-04
2286931 2286931 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2016-09-13 2016-09-15 2016-09-30 2016-09-01 0 2016-09-01 ? 0 0005276680 20160901.ifs 2016-09-01 2016-09-02
2244312 2244312 DIVIDEND ADD 092524107 0 0 1 0 .038 00 2016-07-13 2016-07-15 2016-07-29 2016-07-01 0 2016-07-01 ? 0 0005248527 20160701.ifs 2016-07-01 2016-07-02
2212581 2212581 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-06-13 2016-06-15 2016-06-30 2016-06-01 0 2016-06-01 ? 0 0005228938 20160601.ifs 2016-06-01 2016-06-02
2193262 2193262 DIVIDEND DELETE 092524107 0 0 1 0 .049 00 2016-05-12 2016-05-16 2016-06-01 2016-05-02 0 2016-05-02 ? 0 0005215565 20160509.ifs 2016-05-09 2016-05-10
2193263 2193263 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-05-12 2016-05-16 2016-05-31 2016-05-02 1 2016-05-02 2016-05-09 0 0005215565 20160509.ifs 2016-05-09 2016-05-10
2188795 2188795 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-05-12 2016-05-16 2016-06-01 2016-05-02 0 2016-05-02 ? 0 0005215565 20160502.ifs 2016-05-02 2016-05-03
2156217 2156217 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-04-13 2016-04-15 2016-04-29 2016-04-01 0 2016-04-01 ? 0 0005202022 20160401.ifs 2016-04-01 2016-04-02
2128356 2128356 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-03-11 2016-03-15 2016-03-31 2016-03-01 0 2016-03-01 ? 0 0005182971 20160301.ifs 2016-03-01 2016-03-02
2106859 2106859 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-02-11 2016-02-16 2016-02-29 2016-02-01 0 2016-02-01 ? 0 0005168940 20160201.ifs 2016-02-01 2016-02-02
2086282 2086282 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2016-01-13 2016-01-15 2016-01-29 2016-01-04 0 2016-01-04 ? 0 0005156847 20160104.ifs 2016-01-04 2016-01-05
2027162 2027162 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-12-16 2015-12-18 2015-12-31 2015-12-07 0 2015-12-07 ? 0 0005107135 20151207.ifs 2015-12-07 2015-12-08
1984044 1984044 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-10-13 2015-10-15 2015-10-30 2015-10-01 0 2015-10-01 ? 0 0005076559 20151001.ifs 2015-10-01 2015-10-02
1957245 1957245 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-09-11 2015-09-15 2015-09-30 2015-09-01 0 2015-09-01 ? 0 0005057943 20150901.ifs 2015-09-01 2015-09-02
1934200 1934200 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-08-12 2015-08-14 2015-08-31 2015-08-03 0 2015-08-03 ? 0 0005043519 20150803.ifs 2015-08-03 2015-08-04
1908699 1908699 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-07-13 2015-07-15 2015-07-31 2015-07-01 0 2015-07-01 ? 0 0005029384 20150701.ifs 2015-07-01 2015-07-02
1878733 1878733 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-06-11 2015-06-15 2015-06-30 2015-06-01 0 2015-06-01 ? 0 0005009946 20150601.ifs 2015-06-01 2015-06-02
1857580 1857580 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-05-13 2015-05-15 2015-05-29 2015-05-01 0 2015-05-01 ? 0 0004996809 20150501.ifs 2015-05-01 2015-05-02
1833332 1833332 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-04-13 2015-04-15 2015-04-30 2015-04-01 0 2015-04-01 ? 0 0004983256 20150401.ifs 2015-04-01 2015-04-02
1803177 1803177 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-03-11 2015-03-13 2015-03-31 2015-03-02 0 2015-03-02 ? 0 0004964462 20150302.ifs 2015-03-02 2015-03-03
1784052 1784052 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-02-11 2015-02-13 2015-02-27 2015-02-02 0 2015-02-02 ? 0 0004951131 20150202.ifs 2015-02-02 2015-02-03
1762167 1762167 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2015-01-13 2015-01-15 2015-01-30 2015-01-02 0 2015-01-02 ? 0 0004937997 20150102.ifs 2015-01-02 2015-01-03
1704830 1704830 DIVIDEND ADD 092524107 0 0 1 0 .049 00 2014-12-18 2014-12-22 2014-12-31 2014-12-08 0 2014-12-09 ? 0 0004887520 20141209.ifs 2014-12-09 2014-12-10
1673720 1673720 DIVIDEND ADD 092524107 0 0 1 0 .056 00 2014-11-12 2014-11-14 2014-11-28 2014-11-03 0 2014-11-03 ? 0 0004870142 20141103.ifs 2014-11-03 2014-11-04
1649994 1649994 DIVIDEND ADD 092524107 0 0 1 9 .112 03 2014-10-10 2014-10-15 2014-10-31 2014-10-01 0 2014-10-01 ? 1 0004856590 20141001.ifs 2014-10-01 2014-10-02
1649995 1649995 DIVIDEND ADD 092524107 0 0 1 0 .056 00 2014-10-10 2014-10-15 2014-10-31 2014-10-01 0 2014-10-01 ? 0 0004856522 20141001.ifs 2014-10-01 2014-10-02
1625979 1625979 DIVIDEND CHANGE 092524107 0 0 1 0 .056 00 2014-09-11 2014-09-15 2014-09-30 2014-09-02 0 2014-09-03 ? 0 0004838984 20140908.ifs 2014-09-08 2014-09-09
1625980 1625979 DIVIDEND CHANGE 092524107 0 0 1 0 .056 00 2014-09-11 2014-09-15 2014-09-30 2014-09-02 1 2014-09-03 2014-09-08 0 0004838984 20140908.ifs 2014-09-08 2014-09-09
1623915 1623915 DIVIDEND ADD 092524107 0 0 1 0 .056 00 2014-09-11 2014-09-15 2014-09-30 2014-09-02 0 2014-09-03 ? 0 0004838984 20140903.ifs 2014-09-03 2014-09-04
1540462 1540462 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2014-06-12 2014-06-16 2014-06-30 2014-06-02 0 2014-06-02 ? 0 0004792670 20140602.ifs 2014-06-02 2014-06-03
1458995 1458995 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2014-03-12 2014-03-14 2014-03-31 2014-03-03 0 2014-03-03 ? 0 0004746889 20140303.ifs 2014-03-03 2014-03-04
1361315 1361315 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2013-12-18 2013-12-20 2013-12-31 2013-12-09 0 2013-12-09 ? 0 0004674583 20131209.ifs 2013-12-09 2013-12-10
1280729 1280729 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2013-09-12 2013-09-16 2013-09-30 2013-09-03 0 2013-09-03 ? 0 0004625140 20130903.ifs 2013-09-03 2013-09-04
1203056 1203056 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2013-06-12 2013-06-14 2013-06-28 2013-06-03 0 2013-06-03 ? 0 0004580779 20130603.ifs 2013-06-03 2013-06-04
1126698 1126698 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2013-03-13 2013-03-15 2013-03-28 2013-03-01 0 2013-03-01 ? 0 0004537436 20130301.ifs 2013-03-01 2013-03-02
1034712 1034712 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2012-12-19 2012-12-21 2012-12-31 2012-12-10 0 2012-12-10 ? 0 0004474499 20121210.ifs 2012-12-10 2012-12-11
948827 948827 DIVIDEND ADD 092524107 0 0 1 0 .16785 00 2012-09-12 2012-09-14 2012-09-28 2012-09-04 0 2012-09-04 ? 0 0004425514 20120904.ifs 2012-09-04 2012-09-05
877452 877452 DIVIDEND ADD 092524107 0 0 1 0 .22 00 2012-06-13 2012-06-15 2012-06-29 2012-06-01 0 2012-06-01 ? 0 0004384168 20120601.ifs 2012-06-01 2012-06-02
795102 795102 DIVIDEND ADD 092524107 0 0 1 0 .22 00 2012-03-13 2012-03-15 2012-03-30 2012-03-01 0 2012-03-01 ? 0 0004342782 20120301.ifs 2012-03-01 2012-03-02
717933 717933 DIVIDEND ADD 092524107 0 0 1 0 .34 00 2011-12-16 2011-12-20 2011-12-30 2011-12-09 0 2011-12-09 ? 0 0004285337 20111209.ifs 2011-12-09 2011-12-10
635267 635267 DIVIDEND ADD 092524107 0 0 1 0 .34 00 2011-09-13 2011-09-15 2011-09-30 2011-09-01 0 2011-09-01 ? 0 0004239381 20110901.ifs 2011-09-01 2011-09-02
544886 544886 DIVIDEND ADD 092524107 0 0 1 0 .34 00 2011-06-13 2011-06-15 2011-06-30 2011-06-01 0 2011-06-01 ? 0 0004197622 20110601.ifs 2011-06-01 2011-06-02
461132 461132 DIVIDEND ADD 092524107 0 0 1 0 .34 00 2011-03-11 2011-03-15 2011-03-31 2011-03-01 0 2011-03-01 ? 0 0004156111 20110301.ifs 2011-03-01 2011-03-02
300444 300444 DIVIDEND ADD 092524107 0 0 1 0 .34 00 2010-09-13 2010-09-15 2010-09-30 2010-09-01 0 2010-09-02 ? 0 0004057420 20100902.ifs 2010-09-02 2010-09-03
211902 211902 DIVIDEND ADD 092524107 0 0 1 0 .34 00 2010-06-11 2010-06-15 2010-06-30 2010-06-01 0 2010-06-02 ? 0 0004015297 20100602.ifs 2010-06-02 2010-06-03
123865 123865 DIVIDEND ADD 092524107 0 0 1 0 .4551 00 2010-03-11 2010-03-15 2010-03-31 2010-03-01 0 2010-03-01 ? 0 0003974399 20100301.ifs 2010-03-01 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 = 151493
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