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

the compid is:145527
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
4686746 4686746 DIVIDEND DELETE 05211M105 6 0 1 5 .2902 26 2021-03-16 2021-03-17 2021-05-03 2021-02-26 0 2021-02-26 ? 0 0006268066 20210422.ifs 2021-04-22 2021-04-23
4686747 4686747 DIVIDEND ADD 05211M105 6 0 1 0 .2884 05 2021-03-16 2021-03-17 2021-05-03 2021-02-26 1 2021-02-26 2021-04-22 0 0006268066 20210422.ifs 2021-04-22 2021-04-23
4640280 4640280 DIVIDEND ADD 05211M105 6 0 1 5 .2902 26 2021-03-16 2021-03-17 2021-05-03 2021-02-26 0 2021-02-26 ? 0 0006268066 20210226.ifs 2021-02-26 2021-02-27
4489653 4489653 DIVIDEND DELETE 05211M105 B 0 1 5 .28498 39 2020-09-04 2020-09-08 2020-11-02 2020-08-24 0 2020-08-24 ? 0 0006146440 20201022.ifs 2020-10-22 2020-10-23
4489654 4489654 DIVIDEND ADD 05211M105 B 0 1 0 .281325 02 2020-09-04 2020-09-08 2020-11-02 2020-08-24 1 2020-08-24 2020-10-22 0 0006146440 20201022.ifs 2020-10-22 2020-10-23
4445159 4445159 DIVIDEND ADD 05211M105 B 0 1 5 .28498 39 2020-09-04 2020-09-08 2020-11-02 2020-08-24 0 2020-08-24 ? 0 0006146440 20200824.ifs 2020-08-24 2020-08-25
4293215 4293215 DIVIDEND DELETE 05211M105 B 0 1 5 .1483 39 2020-03-13 2020-03-16 2020-04-27 2020-02-21 0 2020-02-21 ? 0 0006057302 20200417.ifs 2020-04-17 2020-04-18
4293217 4293217 DIVIDEND ADD 05211M105 B 0 1 0 .14236 02 2020-03-13 2020-03-16 2020-04-27 2020-02-21 1 2020-02-21 2020-04-17 0 0006057302 20200417.ifs 2020-04-17 2020-04-18
4293419 4293419 DIVIDEND DELETE 05211M105 B 0 1 5 .1483 39 2020-03-13 2020-03-16 2020-04-27 2020-02-21 0 2020-02-21 ? 0 0006057302 20200417.ifs 2020-04-17 2020-04-18
4293422 4293422 DIVIDEND ADD 05211M105 B 0 1 0 .14236 02 2020-03-13 2020-03-16 2020-04-27 2020-02-21 1 2020-02-21 2020-04-17 0 0006057302 20200417.ifs 2020-04-17 2020-04-18
4213054 4213054 DIVIDEND ADD 05211M105 B 0 1 5 .1483 39 2020-03-13 2020-03-16 2020-04-27 2020-02-21 0 2020-02-21 ? 0 0006057302 20200221.ifs 2020-02-21 2020-02-22
4213150 4213150 DIVIDEND ADD 05211M105 B 0 1 5 .1483 39 2020-03-13 2020-03-16 2020-04-27 2020-02-21 0 2020-02-21 ? 0 0006057302 20200221.ifs 2020-02-21 2020-02-22
3974116 3974116 DIVIDEND DELETE 05211M105 B 0 1 5 .154802 39 2019-09-19 2019-09-20 2019-10-25 2019-09-10 0 2019-09-10 ? 0 0005943632 20191015.ifs 2019-10-15 2019-10-16
3974117 3974117 DIVIDEND DELETE 05211M105 B 0 1 5 .154802 39 2019-09-19 2019-09-20 2019-10-25 2019-09-10 0 2019-09-10 ? 0 0005943632 20191015.ifs 2019-10-15 2019-10-16
3974118 3974118 DIVIDEND ADD 05211M105 B 0 1 0 .15215 02 2019-09-19 2019-09-20 2019-10-25 2019-09-10 1 2019-09-10 2019-10-15 0 0005943632 20191015.ifs 2019-10-15 2019-10-16
3974119 3974119 DIVIDEND ADD 05211M105 B 0 1 0 .15215 02 2019-09-19 2019-09-20 2019-10-25 2019-09-10 1 2019-09-10 2019-10-15 0 0005943632 20191015.ifs 2019-10-15 2019-10-16
3918296 3918296 DIVIDEND ADD 05211M105 B 0 1 5 .154802 39 2019-09-19 2019-09-20 2019-10-25 2019-09-10 0 2019-09-10 ? 0 0005943632 20190910.ifs 2019-09-10 2019-09-11
3918312 3918312 DIVIDEND ADD 05211M105 B 0 1 5 .154802 39 2019-09-19 2019-09-20 2019-10-25 2019-09-10 0 2019-09-10 ? 0 0005943632 20190910.ifs 2019-09-10 2019-09-11
3687567 3687567 DIVIDEND DELETE 05211M105 B 0 1 5 .160565 39 2019-03-18 2019-03-19 2019-04-29 2019-03-05 0 2019-03-05 ? 0 0005850117 20190417.ifs 2019-04-17 2019-04-18
3687569 3687569 DIVIDEND ADD 05211M105 B 0 1 0 .16286 02 2019-03-18 2019-03-19 2019-04-29 2019-03-05 1 2019-03-05 2019-04-17 0 0005850117 20190417.ifs 2019-04-17 2019-04-18
3687570 3687570 DIVIDEND DELETE 05211M105 B 0 1 5 .160565 39 2019-03-18 2019-03-19 2019-04-29 2019-03-05 0 2019-03-05 ? 0 0005850117 20190417.ifs 2019-04-17 2019-04-18
3687572 3687572 DIVIDEND ADD 05211M105 B 0 1 0 .16286 02 2019-03-18 2019-03-19 2019-04-29 2019-03-05 1 2019-03-05 2019-04-17 0 0005850117 20190417.ifs 2019-04-17 2019-04-18
3616492 3616492 DIVIDEND ADD 05211M105 B 0 1 5 .160565 39 2019-03-18 2019-03-19 2019-04-29 2019-03-05 0 2019-03-05 ? 0 0005850117 20190305.ifs 2019-03-05 2019-03-06
3616493 3616493 DIVIDEND ADD 05211M105 B 0 1 5 .160565 39 2019-03-18 2019-03-19 2019-04-29 2019-03-05 0 2019-03-05 ? 0 0005850117 20190305.ifs 2019-03-05 2019-03-06
3327891 3327891 DIVIDEND DELETE 05211M105 6 0 1 5 .19507 26 2018-09-13 2018-09-14 2018-10-22 2018-09-04 0 2018-09-04 ? 0 0005716609 20181010.ifs 2018-10-10 2018-10-11
3327893 3327893 DIVIDEND ADD 05211M105 6 0 1 0 .160897 05 2018-09-13 2018-09-14 2018-10-22 2018-09-04 1 2018-09-04 2018-10-10 0 0005716609 20181010.ifs 2018-10-10 2018-10-11
3327894 3327894 DIVIDEND DELETE 05211M105 6 0 1 5 .19507 26 2018-09-13 2018-09-14 2018-10-22 2018-09-04 0 2018-09-04 ? 0 0005716609 20181010.ifs 2018-10-10 2018-10-11
3327896 3327896 DIVIDEND ADD 05211M105 6 0 1 0 .160897 05 2018-09-13 2018-09-14 2018-10-22 2018-09-04 1 2018-09-04 2018-10-10 0 0005716609 20181010.ifs 2018-10-10 2018-10-11
3267960 3267960 DIVIDEND ADD 05211M105 6 0 1 5 .19507 26 2018-09-13 2018-09-14 2018-10-22 2018-09-04 0 2018-09-04 ? 0 0005716609 20180904.ifs 2018-09-04 2018-09-05
3268327 3268327 DIVIDEND ADD 05211M105 6 0 1 5 .19507 26 2018-09-13 2018-09-14 2018-10-22 2018-09-04 0 2018-09-04 ? 0 0005716609 20180904.ifs 2018-09-04 2018-09-05
3031882 3031882 EQUITY CHANGE 05211M105 SPONSORED ADR 2 0 2005-01-20 ? 2 no no no 2006-03-28 ? ? 20180409.ifs 2018-04-09 2018-04-10
3031883 3031882 EQUITY CHANGE 05211M105 SPONSORED ADR 0 0 2005-01-20 ? 2 no no no 2006-03-28 2018-04-09 ? 20180409.ifs 2018-04-09 2018-04-10
3031893 3031893 EQUITY CHANGE 05211M105 SPONSORED ADR 2 0 2005-01-20 ? 2 no no no 2006-03-28 ? ? 20180409.ifs 2018-04-09 2018-04-10
3031895 3031894 EQUITY CHANGE 05211M105 SPONSORED ADR 0 0 2005-01-20 ? 2 no no no 2006-03-28 2018-04-09 ? 20180409.ifs 2018-04-09 2018-04-10
3031803 3031803 DIVIDEND DELETE 05211M105 6 0 1 5 .13728 26 2018-03-13 2018-03-14 2018-04-16 2018-02-28 0 2018-02-28 ? 0 0005619894 20180406.ifs 2018-04-06 2018-04-07
3031805 3031805 DIVIDEND ADD 05211M105 B 0 1 0 .114714 02 2018-03-13 2018-03-14 2018-04-16 2018-02-28 1 2018-02-28 2018-04-06 0 0005619894 20180406.ifs 2018-04-06 2018-04-07
3031814 3031814 DIVIDEND DELETE 05211M105 6 0 1 5 .13728 26 2018-03-13 2018-03-14 2018-04-16 2018-02-28 0 2018-02-28 ? 0 0005619894 20180406.ifs 2018-04-06 2018-04-07
3031816 3031816 DIVIDEND ADD 05211M105 B 0 1 0 .114714 02 2018-03-13 2018-03-14 2018-04-16 2018-02-28 1 2018-02-28 2018-04-06 0 0005619894 20180406.ifs 2018-04-06 2018-04-07
2970887 2970887 DIVIDEND ADD 05211M105 6 0 1 5 .13728 26 2018-03-13 2018-03-14 2018-04-16 2018-02-28 0 2018-02-28 ? 0 0005619894 20180228.ifs 2018-02-28 2018-03-01
2720197 2720197 DIVIDEND DELETE 05211M105 6 0 1 5 .139973 26 2017-09-11 2017-09-12 2017-10-16 2017-08-28 0 2017-08-28 ? 0 0005485975 20171010.ifs 2017-10-10 2017-10-11
2720198 2720198 DIVIDEND ADD 05211M105 6 0 1 0 .136295 05 2017-09-11 2017-09-12 2017-10-16 2017-08-28 1 2017-08-28 2017-10-10 0 0005485975 20171010.ifs 2017-10-10 2017-10-11
2655668 2655668 DIVIDEND ADD 05211M105 6 0 1 5 .139973 26 2017-09-11 2017-09-12 2017-10-16 2017-08-28 0 2017-08-28 ? 0 0005485975 20170828.ifs 2017-08-28 2017-08-29
2565271 2565271 DIVIDEND DELETE 05211M105 6 0 1 5 .135292 26 2017-03-10 2017-03-14 ? 2017-02-27 1 2017-02-27 2017-02-28 0 0005392024 20170510.ifs 2017-05-10 2017-05-11
2565272 2565272 DIVIDEND ADD 05211M105 6 0 1 0 .129712 05 2017-03-10 2017-03-14 2017-05-22 2017-02-27 2 2017-02-27 2017-05-10 0 0005392024 20170510.ifs 2017-05-10 2017-05-11
2500778 2500778 DIVIDEND DELETE 05211M105 6 0 1 5 .135292 26 ? 2017-03-14 ? 2017-02-27 0 2017-02-27 ? 0 0005392024 20170228.ifs 2017-02-28 2017-03-01
2500779 2500779 DIVIDEND ADD 05211M105 6 0 1 5 .135292 26 2017-03-10 2017-03-14 ? 2017-02-27 1 2017-02-27 2017-02-28 0 0005392024 20170228.ifs 2017-02-28 2017-03-01
2496958 2496958 DIVIDEND ADD 05211M105 6 0 1 5 .135292 26 ? 2017-03-14 ? 2017-02-27 0 2017-02-27 ? 0 0005392024 20170227.ifs 2017-02-27 2017-02-28
2449332 2449332 EQUITY CHANGE 05211M105 SPONSORED ADR 2 0 2005-01-20 ? 0 no no no 2006-03-28 ? ? 20170124.ifs 2017-01-24 2017-01-25
2449333 2449332 EQUITY CHANGE 05211M105 SPONSORED ADR 2 0 2005-01-20 ? 2 no no no 2006-03-28 ? ? 20170124.ifs 2017-01-24 2017-01-25
2318788 2318788 DIVIDEND DELETE 05211M105 6 0 1 5 .132106 0 26 2016-09-09 2016-09-13 2016-10-17 2016-08-30 0 ? 2016-08-31 0 0005270881 20161007.ifs 2016-10-07 2016-10-08
2318789 2318789 DIVIDEND ADD 05211M105 6 0 1 0 .133391 0 05 2016-09-09 2016-09-13 2016-10-17 2016-08-30 0 ? 2016-10-07 0 0005270881 20161007.ifs 2016-10-07 2016-10-08
2280116 2280116 DIVIDEND DELETE 05211M105 6 0 1 5 .132106 26 ? 2016-09-13 2016-10-17 2016-08-30 0 2016-08-30 ? 0 0005270881 20160831.ifs 2016-08-31 2016-09-01
2280117 2280117 DIVIDEND ADD 05211M105 6 0 1 5 .132106 0 26 2016-09-09 2016-09-13 2016-10-17 2016-08-30 0 ? 2016-08-31 0 0005270881 20160831.ifs 2016-08-31 2016-09-01
2283105 2283105 DIVIDEND CHANGE 05211M105 6 0 1 5 .132106 0 26 2016-09-09 2016-09-13 2016-10-17 2016-08-30 0 ? 2016-08-31 0 0005270881 20160831.ifs 2016-08-31 2016-09-01
2283106 2283105 DIVIDEND CHANGE 05211M105 6 0 1 5 .132106 0 26 2016-09-09 2016-09-13 2016-10-17 2016-08-30 0 ? 2016-08-31 0 0005270881 20160831.ifs 2016-08-31 2016-09-01
2279980 2279980 DIVIDEND ADD 05211M105 6 0 1 5 .132106 26 ? 2016-09-13 2016-10-17 2016-08-30 0 2016-08-30 ? 0 0005270881 20160830.ifs 2016-08-30 2016-08-31
2279981 2279981 DIVIDEND CHANGE 05211M105 6 0 1 0 .134605 0 05 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-03-31 0 0005175085 20160830.ifs 2016-08-30 2016-08-31
2279982 2279981 DIVIDEND CHANGE 05211M105 6 0 1 0 .134605 0 05 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-08-30 0 0005175085 20160830.ifs 2016-08-30 2016-08-31
2279983 2279983 DIVIDEND CHANGE 05211M105 6 0 1 0 .19096 05 2015-09-09 2015-09-11 2015-10-13 2015-08-26 2 2015-08-26 2015-10-01 0 0005050695 20160830.ifs 2016-08-30 2016-08-31
2279984 2279983 DIVIDEND CHANGE 05211M105 6 0 1 0 .19096 05 2015-09-09 2015-09-11 2015-10-13 2015-08-26 3 2015-08-26 2016-08-30 0 0005050695 20160830.ifs 2016-08-30 2016-08-31
2279985 2279985 DIVIDEND CHANGE 05211M105 6 0 1 0 .068737 05 2015-03-12 2015-03-16 2015-04-06 2015-03-04 1 2015-03-04 2015-03-26 0 0004965940 20160830.ifs 2016-08-30 2016-08-31
2279986 2279985 DIVIDEND CHANGE 05211M105 6 0 1 0 .068737 05 2015-03-12 2015-03-16 2015-04-06 2015-03-04 2 2015-03-04 2016-08-30 0 0004965940 20160830.ifs 2016-08-30 2016-08-31
2151648 2151648 DIVIDEND DELETE 05211M105 6 0 1 5 .126509 0 26 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-02-25 0 0005175085 20160331.ifs 2016-03-31 2016-04-01
2151649 2151649 DIVIDEND ADD 05211M105 6 0 1 0 .134605 0 05 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-03-31 0 0005175085 20160331.ifs 2016-03-31 2016-04-01
2118648 2118648 DIVIDEND DELETE 05211M105 6 0 1 5 .126509 26 ? 2016-03-08 2016-04-08 2016-02-24 0 2016-02-24 ? 0 0005175085 20160225.ifs 2016-02-25 2016-02-26
2118649 2118649 DIVIDEND ADD 05211M105 6 0 1 5 .126509 0 26 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-02-25 0 0005175085 20160225.ifs 2016-02-25 2016-02-26
2119586 2119586 DIVIDEND CHANGE 05211M105 6 0 1 5 .126509 0 26 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-02-25 0 0005175085 20160225.ifs 2016-02-25 2016-02-26
2119587 2119586 DIVIDEND CHANGE 05211M105 6 0 1 5 .126509 0 26 2016-03-04 2016-03-08 2016-04-08 2016-02-24 0 ? 2016-02-25 0 0005175085 20160225.ifs 2016-02-25 2016-02-26
2118551 2118551 DIVIDEND ADD 05211M105 6 0 1 5 .126509 26 ? 2016-03-08 2016-04-08 2016-02-24 0 2016-02-24 ? 0 0005175085 20160224.ifs 2016-02-24 2016-02-25
1984101 1984101 DIVIDEND DELETE 05211M105 6 0 1 5 .19501 26 2015-09-09 2015-09-11 2015-10-13 2015-08-26 1 2015-08-26 2015-08-27 0 0005050695 20151001.ifs 2015-10-01 2015-10-02
1984102 1984102 DIVIDEND ADD 05211M105 6 0 1 0 .19096 05 2015-09-09 2015-09-11 2015-10-13 2015-08-26 2 2015-08-26 2015-10-01 0 0005050695 20151001.ifs 2015-10-01 2015-10-02
1948828 1948828 DIVIDEND DELETE 05211M105 6 0 1 5 .19501 26 ? 2015-09-11 2015-10-13 2015-08-26 0 2015-08-26 ? 0 0005050695 20150827.ifs 2015-08-27 2015-08-28
1948829 1948829 DIVIDEND ADD 05211M105 6 0 1 5 .19501 26 2015-09-09 2015-09-11 2015-10-13 2015-08-26 1 2015-08-26 2015-08-27 0 0005050695 20150827.ifs 2015-08-27 2015-08-28
1947917 1947917 DIVIDEND ADD 05211M105 6 0 1 5 .19501 26 ? 2015-09-11 2015-10-13 2015-08-26 0 2015-08-26 ? 0 0005050695 20150826.ifs 2015-08-26 2015-08-27
1821945 1821945 DIVIDEND DELETE 05211M105 6 0 1 5 .06886 26 2015-03-12 2015-03-16 2015-04-06 2015-03-04 0 2015-03-04 ? 0 0004965940 20150326.ifs 2015-03-26 2015-03-27
1821946 1821946 DIVIDEND ADD 05211M105 6 0 1 0 .068737 05 2015-03-12 2015-03-16 2015-04-06 2015-03-04 1 2015-03-04 2015-03-26 0 0004965940 20150326.ifs 2015-03-26 2015-03-27
1805880 1805880 DIVIDEND ADD 05211M105 6 0 1 5 .06886 26 2015-03-12 2015-03-16 2015-04-06 2015-03-04 0 2015-03-04 ? 0 0004965940 20150304.ifs 2015-03-04 2015-03-05
1005716 1005716 DIVIDEND ADD 05211M105 0 0 E 0 0 58 ? ? 2012-10-17 2012-11-05 0 2012-11-05 ? 0 0004456013 20121105.ifs 2012-11-05 2012-11-06
670921 670921 DIVIDEND DELETE 05211M105 6 0 1 5 .62038 26 2011-09-19 2011-09-21 2011-10-17 2011-08-31 0 2011-08-31 ? 0 0004233723 20111011.ifs 2011-10-11 2011-10-12
670922 670922 DIVIDEND ADD 05211M105 6 0 1 0 .5635 05 2011-09-19 2011-09-21 2011-10-17 2011-08-31 1 2011-08-31 2011-10-11 0 0004233723 20111011.ifs 2011-10-11 2011-10-12
631544 631544 DIVIDEND ADD 05211M105 6 0 1 5 .62038 26 2011-09-19 2011-09-21 2011-10-17 2011-08-31 0 2011-08-31 ? 0 0004233723 20110831.ifs 2011-08-31 2011-09-01
332413 332413 DIVIDEND DELETE 05211M105 6 0 1 5 .51088 26 2010-09-20 2010-09-22 2010-10-18 2010-08-25 0 2010-08-25 ? 0 0004049459 20101008.ifs 2010-10-08 2010-10-09
332414 332414 DIVIDEND ADD 05211M105 6 0 1 0 .5668 05 2010-09-20 2010-09-22 2010-10-18 2010-08-25 1 2010-08-25 2010-10-08 0 0004049459 20101008.ifs 2010-10-08 2010-10-09
286283 286283 DIVIDEND ADD 05211M105 6 0 1 5 .51088 26 2010-09-20 2010-09-22 2010-10-18 2010-08-25 0 2010-08-25 ? 0 0004049459 20100825.ifs 2010-08-25 2010-08-26


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 = 145527
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