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

the compid is:132570
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
5559360 5559360 DIVIDEND ADD 929740108 0 0 1 0 .2 00 2024-05-24 2024-05-28 2024-06-11 2024-05-17 0 2024-05-17 ? 0 0006920544 20240517.ifs 2024-05-17 2024-05-18
5498590 5498590 DIVIDEND ADD 929740108 0 0 1 0 .2 00 2024-02-22 2024-02-23 2024-03-08 2024-02-13 0 2024-02-14 ? 0 0006876755 20240214.ifs 2024-02-14 2024-02-15
5397917 5397917 DIVIDEND ADD 929740108 0 0 1 0 .17 00 2023-11-14 2023-11-15 2023-11-29 2023-10-20 0 2023-10-20 ? 0 0006800058 20231020.ifs 2023-10-20 2023-10-21
5337330 5337330 DIVIDEND ADD 929740108 0 0 1 0 .17 00 2023-08-11 2023-08-14 2023-08-28 2023-07-20 0 2023-07-20 ? 0 0006757674 20230720.ifs 2023-07-20 2023-07-21
5292956 5292956 DIVIDEND ADD 929740108 0 0 1 0 .17 00 2023-05-26 2023-05-30 2023-06-09 2023-05-17 0 2023-05-17 ? 0 0006726548 20230517.ifs 2023-05-17 2023-05-18
5230274 5230274 DIVIDEND ADD 929740108 0 0 1 0 .17 00 2023-02-23 2023-02-24 2023-03-10 2023-02-14 0 2023-02-14 ? 0 0006682551 20230214.ifs 2023-02-14 2023-02-15
5123734 5123734 DIVIDEND ADD 929740108 0 0 1 0 .15 00 2022-11-10 2022-11-14 2022-11-28 2022-10-21 0 2022-10-21 ? 0 0006601273 20221021.ifs 2022-10-21 2022-10-22
5062289 5062289 DIVIDEND ADD 929740108 0 0 1 0 .15 00 2022-08-12 2022-08-15 2022-08-29 2022-07-22 0 2022-07-22 ? 0 0006558068 20220722.ifs 2022-07-22 2022-07-23
5010483 5010483 DIVIDEND ADD 929740108 0 0 1 0 .15 00 2022-05-19 2022-05-20 2022-05-27 2022-05-11 0 2022-05-11 ? 0 0006523038 20220511.ifs 2022-05-11 2022-05-12
4958235 4958235 DIVIDEND DELETE 929740108 0 0 1 0 .15 00 2022-02-24 2022-02-25 2022-02-28 2022-02-16 0 2022-02-16 ? 0 0006481476 20220225.ifs 2022-02-25 2022-02-26
4958236 4958236 DIVIDEND ADD 929740108 0 0 1 0 .15 00 2022-02-24 2022-02-25 2022-03-03 2022-02-16 1 2022-02-16 2022-02-25 0 0006481476 20220225.ifs 2022-02-25 2022-02-26
4954225 4954225 DIVIDEND ADD 929740108 0 0 1 0 .15 00 2022-02-24 2022-02-25 2022-02-28 2022-02-16 0 2022-02-16 ? 0 0006481476 20220216.ifs 2022-02-16 2022-02-17
4831896 4831896 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2021-11-12 2021-11-15 2021-11-29 2021-10-26 0 2021-10-26 ? 0 0006385943 20211026.ifs 2021-10-26 2021-10-27
4763052 4763052 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2021-08-12 2021-08-13 2021-08-27 2021-07-22 0 2021-07-22 ? 0 0006341623 20210722.ifs 2021-07-22 2021-07-23
4650613 4650613 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2021-05-06 2021-05-07 2021-05-21 2021-03-10 0 2021-03-10 ? 0 0006276174 20210310.ifs 2021-03-10 2021-03-11
4541008 4541008 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2021-02-11 2021-02-12 2021-02-26 2020-12-14 0 2020-12-14 ? 0 0006210146 20201214.ifs 2020-12-14 2020-12-15
4486292 4486292 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2020-11-12 2020-11-13 2020-11-27 2020-10-15 0 2020-10-15 ? 0 0006175201 20201015.ifs 2020-10-15 2020-10-16
4425892 4425892 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2020-08-13 2020-08-14 2020-08-28 2020-07-29 0 2020-07-29 ? 0 0006134004 20200729.ifs 2020-07-29 2020-07-30
4303723 4303723 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2020-05-07 2020-05-08 2020-05-22 2020-04-28 0 2020-04-28 ? 0 0006088570 20200428.ifs 2020-04-28 2020-04-29
4303724 4303724 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2020-05-07 2020-05-08 2020-05-22 2020-04-28 0 2020-04-28 ? 0 0006088570 20200428.ifs 2020-04-28 2020-04-29
4092388 4092388 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2020-02-06 2020-02-07 2020-02-21 2019-12-19 0 2019-12-19 ? 0 0006010119 20191219.ifs 2019-12-19 2019-12-20
4092765 4092765 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2020-02-06 2020-02-07 2020-02-21 2019-12-19 0 2019-12-19 ? 0 0006010119 20191219.ifs 2019-12-19 2019-12-20
3981360 3981360 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-11-14 2019-11-15 2019-11-29 2019-10-23 0 2019-10-23 ? 0 0005964296 20191023.ifs 2019-10-23 2019-10-24
3981361 3981361 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-11-14 2019-11-15 2019-11-29 2019-10-23 0 2019-10-23 ? 0 0005964296 20191023.ifs 2019-10-23 2019-10-24
3748030 3748030 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-08-08 2019-08-09 2019-08-23 2019-05-31 0 2019-05-31 ? 0 0005888468 20190531.ifs 2019-05-31 2019-06-01
3748039 3748039 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-08-08 2019-08-09 2019-08-23 2019-05-31 0 2019-05-31 ? 0 0005888468 20190531.ifs 2019-05-31 2019-06-01
3680941 3680941 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-05-09 2019-05-10 2019-05-24 2019-04-10 0 2019-04-10 ? 0 0005869658 20190410.ifs 2019-04-10 2019-04-11
3680957 3680957 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-05-09 2019-05-10 2019-05-24 2019-04-10 0 2019-04-10 ? 0 0005869658 20190410.ifs 2019-04-10 2019-04-11
3593762 3593762 CORPACTION ADD 929740108 01 # 2019-02-26 929740108 01 ? 20190226.ifs 2019-02-26 2019-02-27
3593764 3593764 CORPACTIONAUX ADD 929740108 01 2019-02-26 WAB__I WABTEC COM WAB WABTEC COM 2019-02-26 ? 20190226.ifs 2019-02-26 2019-02-27
3593766 3593766 EXCHANGE CHANGE 929740108 01 2000-05-02 2019-02-25 WAB 0 0 2001-01-29 2001-04-12 20190226.ifs 2019-02-26 2019-02-27
3593767 3593766 EXCHANGE CHANGE 929740108 01 2000-05-02 2019-02-25 WAB 0 0 2001-01-29 2019-02-26 20190226.ifs 2019-02-26 2019-02-27
3593768 3593768 CORPACTION ADD 929740108 01 # 2019-02-26 929740108 01 ? 20190226.ifs 2019-02-26 2019-02-27
3593770 3593770 CORPACTIONAUX ADD 929740108 01 2019-02-26 WAB__I WABTEC COM WAB WABTEC COM 2019-02-26 ? 20190226.ifs 2019-02-26 2019-02-27
3593772 3593772 EXCHANGE CHANGE 929740108 01 2000-05-02 2019-02-25 WAB 0 0 2001-01-29 2001-04-12 20190226.ifs 2019-02-26 2019-02-27
3593774 3593773 EXCHANGE CHANGE 929740108 01 2000-05-02 2019-02-25 WAB 0 0 2001-01-29 2019-02-26 20190226.ifs 2019-02-26 2019-02-27
3593881 3593881 CORPACTION DELETE 929740108 01 # 2019-02-26 929740108 01 ? 20190226.ifs 2019-02-26 2019-02-27
3593884 3593883 CORPACTION DELETE 929740108 01 2019-02-26 WAB__I WABTEC COM WAB WABTEC COM 2019-02-26 ? 20190226.ifs 2019-02-26 2019-02-27
3593889 3593889 CORPACTION DELETE 929740108 01 # 2019-02-26 929740108 01 ? 20190226.ifs 2019-02-26 2019-02-27
3593893 3593892 CORPACTION DELETE 929740108 01 2019-02-26 WAB__I WABTEC COM WAB WABTEC COM 2019-02-26 ? 20190226.ifs 2019-02-26 2019-02-27
3548350 3548350 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-02-07 2019-02-08 2019-02-22 2019-01-11 0 2019-01-11 ? 0 0005825478 20190111.ifs 2019-01-11 2019-01-12
3548353 3548353 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2019-02-07 2019-02-08 2019-02-22 2019-01-11 0 2019-01-11 ? 0 0005825478 20190111.ifs 2019-01-11 2019-01-12
3330407 3330407 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-11-15 2018-11-16 2018-11-30 2018-10-16 0 2018-10-16 ? 0 0005741189 20181016.ifs 2018-10-16 2018-10-17
3330410 3330410 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-11-15 2018-11-16 2018-11-30 2018-10-16 0 2018-10-16 ? 0 0005741189 20181016.ifs 2018-10-16 2018-10-17
3191440 3191440 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-08-09 2018-08-10 2018-08-24 2018-05-15 0 2018-07-11 ? 0 0005693248 20180711.ifs 2018-07-11 2018-07-12
3191441 3191441 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-08-09 2018-08-10 2018-08-24 2018-05-15 0 2018-07-11 ? 0 0005693248 20180711.ifs 2018-07-11 2018-07-12
3043544 3043544 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-05-10 2018-05-11 2018-05-25 2018-04-19 0 2018-04-19 ? 0 0005648179 20180419.ifs 2018-04-19 2018-04-20
3043553 3043553 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-05-10 2018-05-11 2018-05-25 2018-04-19 0 2018-04-19 ? 0 0005648179 20180419.ifs 2018-04-19 2018-04-20
2932187 2932187 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-02-08 2018-02-09 2018-02-23 2018-01-29 0 2018-01-29 ? 0 0005604936 20180129.ifs 2018-01-29 2018-01-30
2932306 2932306 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2018-02-08 2018-02-09 2018-02-23 2018-01-29 0 2018-01-29 ? 0 0005604936 20180129.ifs 2018-01-29 2018-01-30
2741771 2741771 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2017-11-10 2017-11-13 2017-11-27 2017-10-31 0 2017-10-31 ? 0 0005520024 20171031.ifs 2017-10-31 2017-11-01
2742419 2742419 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2017-11-10 2017-11-13 2017-11-27 2017-10-31 0 2017-10-31 ? 0 0005520024 20171031.ifs 2017-10-31 2017-11-01
2565022 2565022 DIVIDEND ADD 929740108 0 0 1 0 .12 00 2017-08-10 2017-08-14 2017-08-28 2017-05-10 0 2017-05-10 ? 0 0005434263 20170510.ifs 2017-05-10 2017-05-11
2541279 2541279 DIVIDEND ADD 929740108 0 0 1 0 .1 00 2017-05-10 2017-05-12 2017-05-26 2017-04-12 0 2017-04-12 ? 0 0005420633 20170412.ifs 2017-04-12 2017-04-13
2455119 2455119 DIVIDEND ADD 929740108 0 0 1 0 .1 00 2017-02-08 2017-02-10 2017-02-24 2017-01-25 0 2017-01-25 ? 0 0005377577 20170125.ifs 2017-01-25 2017-01-26
2327534 2327534 DIVIDEND ADD 929740108 0 0 1 0 .1 00 2016-11-09 2016-11-14 2016-11-28 2016-10-27 0 2016-10-27 ? 0 0005301226 20161027.ifs 2016-10-27 2016-10-28
2194536 2194536 DIVIDEND ADD 929740108 0 0 1 0 .1 00 2016-08-11 2016-08-15 2016-08-29 2016-05-11 0 2016-05-11 ? 0 0005218250 20160511.ifs 2016-05-11 2016-05-12
2166855 2166855 DIVIDEND ADD 929740108 0 0 1 0 .08 00 2016-05-11 2016-05-13 2016-05-27 2016-04-19 0 2016-04-19 ? 0 0005206202 20160419.ifs 2016-04-19 2016-04-20
2098333 2098333 DIVIDEND ADD 929740108 0 0 1 0 .08 00 2016-02-10 2016-02-12 2016-02-26 2016-01-26 0 2016-01-26 ? 0 0005162225 20160126.ifs 2016-01-26 2016-01-27
1996783 1996783 DIVIDEND ADD 929740108 0 0 1 0 .08 00 2015-11-12 2015-11-16 2015-11-30 2015-10-27 0 2015-10-27 ? 0 0005082292 20151027.ifs 2015-10-27 2015-10-28
1862686 1862686 DIVIDEND ADD 929740108 0 0 1 0 .08 00 2015-08-13 2015-08-17 2015-08-31 2015-05-13 0 2015-05-13 ? 0 0005000050 20150513.ifs 2015-05-13 2015-05-14
1848694 1848694 DIVIDEND ADD 929740108 0 0 1 0 .06 00 2015-05-13 2015-05-15 2015-05-29 2015-04-28 0 2015-04-28 ? 0 0004989750 20150428.ifs 2015-04-28 2015-04-29
1784708 1784708 DIVIDEND ADD 929740108 0 0 1 0 .06 00 2015-02-11 2015-02-13 2015-02-27 2015-02-03 0 2015-02-03 ? 0 0004951350 20150203.ifs 2015-02-03 2015-02-04
1657515 1657515 DIVIDEND ADD 929740108 0 0 1 0 .06 00 2014-11-12 2014-11-14 2014-11-28 2014-09-30 0 2014-10-15 ? 0 0004859600 20141015.ifs 2014-10-15 2014-10-16
1505065 1505065 DIVIDEND ADD 929740108 0 0 1 0 .04 00 2014-05-14 2014-05-16 2014-05-30 2014-04-30 0 2014-04-30 ? 0 0004772655 20140430.ifs 2014-04-30 2014-05-01
1429973 1429973 DIVIDEND ADD 929740108 0 0 1 0 .04 00 2014-02-12 2014-02-14 2014-02-28 2014-01-30 0 2014-01-30 ? 0 0004726988 20140130.ifs 2014-01-30 2014-01-31
1322282 1322282 DIVIDEND ADD 929740108 0 0 1 0 .04 00 2013-11-13 2013-11-15 2013-11-29 2013-10-24 0 2013-10-24 ? 0 0004647384 20131024.ifs 2013-10-24 2013-10-25
1263440 1263440 DIVIDEND CHANGE 929740108 0 0 1 1 .4 06 2013-08-14 2013-08-16 2013-08-30 2013-05-14 1 2013-05-14 2013-05-15 1 0004571162 20130813.ifs 2013-08-13 2013-08-14
1263441 1263440 DIVIDEND CHANGE 929740108 0 0 1 1 .04 06 2013-08-14 2013-08-16 2013-08-30 2013-05-14 2 2013-05-14 2013-08-13 1 0004571162 20130813.ifs 2013-08-13 2013-08-14
1185936 1185936 DIVIDEND CHANGE 929740108 0 0 1 1 .4 06 2013-08-14 2013-08-16 2013-08-30 2013-05-14 0 2013-05-14 ? 1 0004571162 20130515.ifs 2013-05-15 2013-05-16
1185937 1185936 DIVIDEND CHANGE 929740108 0 0 1 1 .4 06 2013-08-14 2013-08-16 2013-08-30 2013-05-14 1 2013-05-14 2013-05-15 1 0004571162 20130515.ifs 2013-05-15 2013-05-16
1185938 1185938 DIVIDEND DELETE 929740108 0 0 5 0 1 10 ? 2013-06-03 2013-06-11 2013-05-14 0 2013-05-14 ? 0 0004571159 20130515.ifs 2013-05-15 2013-05-16
1185939 1185939 DIVIDEND ADD 929740108 0 0 5 0 1 10 2013-06-12 2013-06-03 2013-06-11 2013-05-14 1 2013-05-14 2013-05-15 0 0004571159 20130515.ifs 2013-05-15 2013-05-16
1185940 1185940 SPLIT ADD 929740108 .5 2013-06-12 10 2013-05-15 ? 20130515.ifs 2013-05-15 2013-05-16
1185179 1185179 DIVIDEND ADD 929740108 0 0 1 1 .4 06 2013-08-14 2013-08-16 2013-08-30 2013-05-14 0 2013-05-14 ? 1 0004571162 20130514.ifs 2013-05-14 2013-05-15
1185180 1185180 DIVIDEND ADD 929740108 0 0 5 0 1 10 ? 2013-06-03 2013-06-11 2013-05-14 0 2013-05-14 ? 0 0004571159 20130514.ifs 2013-05-14 2013-05-15
1174686 1174686 DIVIDEND ADD 929740108 0 0 1 0 .05 00 2013-05-15 2013-05-17 2013-05-31 2013-05-01 0 2013-05-01 ? 0 0004565233 20130501.ifs 2013-05-01 2013-05-02
1097093 1097093 DIVIDEND ADD 929740108 0 0 1 0 .05 00 2013-02-13 2013-02-15 2013-03-01 2013-01-28 0 2013-01-28 ? 0 0004517573 20130128.ifs 2013-01-28 2013-01-29
999693 999693 DIVIDEND ADD 929740108 0 0 1 0 .05 00 2012-11-14 2012-11-16 2012-11-30 2012-11-01 0 2012-11-01 ? 0 0004451423 20121101.ifs 2012-11-01 2012-11-02
862289 862289 DIVIDEND ADD 929740108 0 0 1 0 .05 00 2012-08-15 2012-08-17 2012-08-31 2012-05-16 0 2012-05-16 ? 0 0004374740 20120516.ifs 2012-05-16 2012-05-17
843616 843616 DIVIDEND ADD 929740108 0 0 1 0 .03 00 2012-05-15 2012-05-17 2012-05-31 2012-04-26 0 2012-04-26 ? 0 0004364337 20120426.ifs 2012-04-26 2012-04-27
760044 760044 DIVIDEND ADD 929740108 0 0 1 0 .03 00 2012-02-13 2012-02-15 2012-02-29 2012-01-20 0 2012-01-20 ? 0 0004321796 20120120.ifs 2012-01-20 2012-01-21
677940 677940 DIVIDEND ADD 929740108 0 0 1 0 .03 00 2011-11-14 2011-11-16 2011-11-30 2011-10-25 0 2011-10-25 ? 0 0004259926 20111025.ifs 2011-10-25 2011-10-26
524253 524253 DIVIDEND ADD 929740108 0 0 1 0 .03 00 2011-08-15 2011-08-17 2011-08-31 2011-05-11 0 2011-05-11 ? 0 0004187613 20110511.ifs 2011-05-11 2011-05-12
504498 504498 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2011-05-13 2011-05-17 2011-05-31 2011-04-19 0 2011-04-19 ? 0 0004176187 20110419.ifs 2011-04-19 2011-04-20
428485 428485 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2011-02-10 2011-02-14 2011-02-28 2011-01-31 0 2011-01-31 ? 0 0004138250 20110131.ifs 2011-01-31 2011-02-01
343776 343776 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2010-11-12 2010-11-16 2010-11-30 2010-10-28 0 2010-10-28 ? 0 0004077893 20101028.ifs 2010-10-28 2010-10-29
261039 261039 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2010-08-13 2010-08-17 2010-08-31 2010-07-28 0 2010-07-28 ? 0 0004037548 20100728.ifs 2010-07-28 2010-07-29
179070 179070 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2010-05-13 2010-05-17 2010-05-31 2010-05-03 0 2010-05-03 ? 0 0004002519 20100503.ifs 2010-05-03 2010-05-04
104384 104384 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2010-02-10 2010-02-15 2010-02-28 2010-02-03 0 2010-02-03 ? 0 0003963269 20100203.ifs 2010-02-03 2010-04-07
10859 10859 DIVIDEND ADD 929740108 0 0 1 0 .01 00 2009-11-12 2009-11-16 2009-11-30 2009-10-30 0 2009-10-30 ? 0 0003900203 20091030.ifs 2009-10-30 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 = 132570
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