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

the compid is:152114
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
5573843 5573843 DIVIDEND ADD 464288851 0 0 1 0 .505014 00 2024-06-11 2024-06-11 2024-06-17 2024-06-10 0 2024-06-10 ? 0 0006931212 20240610.ifs 2024-06-10 2024-06-11
5519547 5519547 DIVIDEND ADD 464288851 0 0 1 0 .594297 00 2024-03-21 2024-03-22 2024-03-27 2024-03-20 0 2024-03-20 ? 0 0006892826 20240320.ifs 2024-03-20 2024-03-21
5450354 5450354 DIVIDEND ADD 464288851 0 0 1 0 .96786 00 2023-12-20 2023-12-21 2023-12-27 2023-12-19 0 2023-12-19 ? 0 0006840893 20231219.ifs 2023-12-19 2023-12-20
5380075 5380075 DIVIDEND ADD 464288851 0 0 1 0 .499183 00 2023-09-26 2023-09-27 2023-10-02 2023-09-25 0 2023-09-25 ? 0 0006787375 20230925.ifs 2023-09-25 2023-09-26
5307587 5307587 DIVIDEND ADD 464288851 0 0 1 0 .54681 00 2023-06-07 2023-06-08 2023-06-13 2023-06-06 0 2023-06-06 ? 0 0006737187 20230606.ifs 2023-06-06 2023-06-07
5253835 5253835 DIVIDEND ADD 464288851 0 0 1 0 .785189 00 2023-03-23 2023-03-24 2023-03-29 2023-03-22 0 2023-03-23 ? 0 0006698975 20230323.ifs 2023-03-23 2023-03-24
5162420 5162420 DIVIDEND ADD 464288851 0 0 1 0 1.136398 00 2022-12-13 2022-12-14 2022-12-19 2022-12-12 0 2022-12-12 ? 0 0006629702 20221212.ifs 2022-12-12 2022-12-13
5103561 5103561 DIVIDEND ADD 464288851 0 0 1 0 1.223231 00 2022-09-26 2022-09-27 2022-09-30 2022-09-23 0 2022-09-23 ? 0 0006588026 20220923.ifs 2022-09-23 2022-09-24
5030139 5030139 DIVIDEND ADD 464288851 0 0 1 0 .575448 00 2022-06-09 2022-06-10 2022-06-15 2022-06-08 0 2022-06-08 ? 0 0006536934 20220608.ifs 2022-06-08 2022-06-09
4976127 4976127 DIVIDEND ADD 464288851 0 0 1 0 .570048 00 2022-03-24 2022-03-25 2022-03-30 2022-03-23 0 2022-03-23 ? 0 0006498241 20220323.ifs 2022-03-23 2022-03-24
4877089 4877089 DIVIDEND ADD 464288851 0 0 1 0 .566144 00 2021-12-13 2021-12-14 2021-12-17 2021-12-10 0 2021-12-10 ? 0 0006417735 20211210.ifs 2021-12-10 2021-12-11
4808642 4808642 DIVIDEND ADD 464288851 0 0 1 0 .565735 00 2021-09-24 2021-09-27 2021-09-30 2021-09-23 0 2021-09-23 ? 0 0006371815 20210923.ifs 2021-09-23 2021-09-24
4725916 4725916 DIVIDEND ADD 464288851 0 0 1 0 .210691 00 2021-06-10 2021-06-11 2021-06-16 2021-06-09 0 2021-06-09 ? 0 0006320561 20210609.ifs 2021-06-09 2021-06-10
4660993 4660993 DIVIDEND ADD 464288851 0 0 1 0 .260116 00 2021-03-25 2021-03-26 2021-03-31 2021-03-24 0 2021-03-24 ? 0 0006281493 20210324.ifs 2021-03-24 2021-03-25
4539137 4539137 DIVIDEND ADD 464288851 0 0 1 0 .221311 00 2020-12-14 2020-12-15 2020-12-18 2020-12-11 0 2020-12-11 ? 0 0006209413 20201211.ifs 2020-12-11 2020-12-12
4467360 4467360 DIVIDEND ADD 464288851 0 0 1 0 .426312 00 2020-09-23 2020-09-24 2020-09-29 2020-09-22 0 2020-09-22 ? 0 0006162000 20200922.ifs 2020-09-22 2020-09-23
4391017 4391017 DIVIDEND ADD 464288851 0 0 1 0 .190617 00 2020-06-15 2020-06-16 2020-06-19 2020-06-12 0 2020-06-12 ? 0 0006112213 20200612.ifs 2020-06-12 2020-06-13
4252399 4252399 DIVIDEND ADD 464288851 0 0 1 0 .299614 00 2020-03-25 2020-03-26 2020-03-31 2020-03-24 0 2020-03-24 ? 0 0006072881 20200324.ifs 2020-03-24 2020-03-25
4252621 4252621 DIVIDEND ADD 464288851 0 0 1 0 .299614 00 2020-03-25 2020-03-26 2020-03-31 2020-03-24 0 2020-03-24 ? 0 0006072881 20200324.ifs 2020-03-24 2020-03-25
4067945 4067945 DIVIDEND ADD 464288851 0 0 1 0 .306515 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000248 20191213.ifs 2019-12-13 2019-12-14
4068024 4068024 DIVIDEND ADD 464288851 0 0 1 0 .306515 00 2019-12-16 2019-12-17 2019-12-20 2019-12-13 0 2019-12-13 ? 0 0006000248 20191213.ifs 2019-12-13 2019-12-14
3933958 3933958 DIVIDEND ADD 464288851 0 0 1 0 .253283 00 2019-09-24 2019-09-25 2019-09-30 2019-09-23 0 2019-09-23 ? 0 0005949142 20190923.ifs 2019-09-23 2019-09-24
3933959 3933959 DIVIDEND ADD 464288851 0 0 1 0 .253283 00 2019-09-24 2019-09-25 2019-09-30 2019-09-23 0 2019-09-23 ? 0 0005949142 20190923.ifs 2019-09-23 2019-09-24
3780965 3780965 DIVIDEND ADD 464288851 0 0 1 0 .237799 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898868 20190614.ifs 2019-06-14 2019-06-15
3780988 3780988 DIVIDEND ADD 464288851 0 0 1 0 .237799 00 2019-06-17 2019-06-18 2019-06-21 2019-06-14 0 2019-06-14 ? 0 0005898868 20190614.ifs 2019-06-14 2019-06-15
3638059 3638059 DIVIDEND ADD 464288851 0 0 1 0 .228635 00 2019-03-20 2019-03-21 2019-03-26 2019-03-19 0 2019-03-19 ? 0 0005855004 20190319.ifs 2019-03-19 2019-03-20
3638062 3638062 DIVIDEND ADD 464288851 0 0 1 0 .228635 00 2019-03-20 2019-03-21 2019-03-26 2019-03-19 0 2019-03-19 ? 0 0005855004 20190319.ifs 2019-03-19 2019-03-20
3442933 3442933 DIVIDEND ADD 464288851 0 0 1 0 .339539 00 2018-12-17 2018-12-18 2018-12-21 2018-12-14 0 2018-12-14 ? 0 0005781553 20181214.ifs 2018-12-14 2018-12-15
3443763 3443763 DIVIDEND ADD 464288851 0 0 1 0 .339539 00 2018-12-17 2018-12-18 2018-12-21 2018-12-14 0 2018-12-14 ? 0 0005781553 20181214.ifs 2018-12-14 2018-12-15
3299125 3299125 DIVIDEND ADD 464288851 0 0 1 0 .172831 00 2018-09-26 2018-09-27 2018-10-02 2018-09-25 0 2018-09-25 ? 0 0005728840 20180925.ifs 2018-09-25 2018-09-26
3299232 3299232 DIVIDEND ADD 464288851 0 0 1 0 .172831 00 2018-09-26 2018-09-27 2018-10-02 2018-09-25 0 2018-09-25 ? 0 0005728840 20180925.ifs 2018-09-25 2018-09-26
3000777 3000777 DIVIDEND ADD 464288851 0 0 1 0 .179825 00 2018-03-22 2018-03-23 2018-03-28 2018-03-21 0 2018-03-21 ? 0 0005632769 20180321.ifs 2018-03-21 2018-03-22
3000798 3000798 DIVIDEND ADD 464288851 0 0 1 0 .179825 00 2018-03-22 2018-03-23 2018-03-28 2018-03-21 0 2018-03-21 ? 0 0005632769 20180321.ifs 2018-03-21 2018-03-22
2839558 2839558 DIVIDEND ADD 464288851 0 0 1 0 .158252 00 2017-12-19 2017-12-20 2017-12-26 2017-12-18 0 2017-12-18 ? 0 0005564372 20171218.ifs 2017-12-18 2017-12-19
2686729 2686729 DIVIDEND ADD 464288851 0 0 1 0 .153647 00 2017-09-26 2017-09-27 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005502057 20170925.ifs 2017-09-25 2017-09-26
2686776 2686776 DIVIDEND ADD 464288851 0 0 1 0 .153647 00 2017-09-26 2017-09-27 2017-09-29 2017-09-25 0 2017-09-25 ? 0 0005502057 20170925.ifs 2017-09-25 2017-09-26
2642246 2642246 CORPACTION ADD 464288851 04 X 2017-08-02 464288851 12 2017-08-02 20170802.ifs 2017-08-02 2017-08-03
2601179 2601179 DIVIDEND ADD 464288851 0 0 1 0 .171774 00 2017-06-27 2017-06-29 2017-06-30 2017-06-26 0 2017-06-26 ? 0 0005454916 20170626.ifs 2017-06-26 2017-06-27
2518846 2518846 DIVIDEND ADD 464288851 0 0 1 0 .12918 00 2017-03-24 2017-03-28 2017-03-30 2017-03-23 0 2017-03-23 ? 0 0005406965 20170323.ifs 2017-03-23 2017-03-24
2439878 2439878 EQUITY CHANGE 464288851 ISHARES U.S. OIL & GAS EXPLORATION & PRODUCTION ETF 0 A 2006-05-05 ? 0 no no no 2006-05-08 2013-07-01 ? 20170123.ifs 2017-01-23 2017-01-24
2439879 2439878 EQUITY CHANGE 464288851 ISHARES U.S. OIL & GAS EXPLORATION & PRODUCTION ETF 0 A 2006-05-05 ? 4 no no no 2006-05-08 2013-07-01 ? 20170123.ifs 2017-01-23 2017-01-24
2388199 2388199 DIVIDEND ADD 464288851 0 0 1 0 .136985 00 2016-12-21 2016-12-23 2016-12-28 2016-12-20 0 2016-12-20 ? 0 0005346382 20161220.ifs 2016-12-20 2016-12-21
2301168 2301168 DIVIDEND ADD 464288851 0 0 1 0 .156089 00 2016-09-26 2016-09-28 2016-09-30 2016-09-23 0 2016-09-23 ? 0 0005285133 20160923.ifs 2016-09-23 2016-09-24
2225288 2225288 DIVIDEND ADD 464288851 0 0 1 0 .173283 00 2016-06-21 2016-06-23 2016-06-27 2016-06-20 0 2016-06-20 ? 0 0005235513 20160620.ifs 2016-06-20 2016-06-21
2140459 2140459 DIVIDEND ADD 464288851 0 0 1 0 .177992 00 2016-03-23 2016-03-28 2016-03-30 2016-03-22 0 2016-03-22 ? 0 0005190709 20160322.ifs 2016-03-22 2016-03-23
2063464 2063464 DIVIDEND ADD 464288851 0 0 1 0 .251239 00 2015-12-24 2015-12-29 2015-12-31 2015-12-23 0 2015-12-23 ? 0 0005138811 20151223.ifs 2015-12-23 2015-12-24
1972233 1972233 DIVIDEND ADD 464288851 0 0 1 0 .286835 00 2015-09-25 2015-09-29 2015-10-01 2015-09-24 0 2015-09-24 ? 0 0005067358 20150924.ifs 2015-09-24 2015-09-25
1893614 1893614 DIVIDEND ADD 464288851 0 0 1 0 .277394 00 2015-06-24 2015-06-26 2015-06-30 2015-06-23 0 2015-06-23 ? 0 0005018444 20150623.ifs 2015-06-23 2015-06-24
1819275 1819275 DIVIDEND ADD 464288851 0 0 1 0 .260881 00 2015-03-25 2015-03-27 2015-03-31 2015-03-24 0 2015-03-24 ? 0 0004972935 20150324.ifs 2015-03-24 2015-03-25
1740529 1740529 DIVIDEND ADD 464288851 0 0 1 0 .262473 00 2014-12-24 2014-12-29 2014-12-31 2014-12-23 0 2014-12-23 ? 0 0004919706 20141223.ifs 2014-12-23 2014-12-24
1636504 1636504 DIVIDEND ADD 464288851 0 0 1 0 .235844 00 2014-09-24 2014-09-26 2014-09-30 2014-09-23 0 2014-09-23 ? 0 0004846729 20140923.ifs 2014-09-23 2014-09-24
1557030 1557030 DIVIDEND ADD 464288851 0 0 1 0 .213608 00 2014-06-24 2014-06-26 2014-06-30 2014-06-23 0 2014-06-23 ? 0 0004800697 20140623.ifs 2014-06-23 2014-06-24
1474525 1474525 DIVIDEND ADD 464288851 0 0 1 0 .215131 00 2014-03-25 2014-03-27 2014-03-31 2014-03-24 0 2014-03-24 ? 0 0004754631 20140324.ifs 2014-03-24 2014-03-25
1389353 1389353 DIVIDEND ADD 464288851 0 0 1 0 .191164 00 2013-12-23 2013-12-26 2013-12-30 2013-12-20 0 2013-12-20 ? 0 0004698568 20131220.ifs 2013-12-20 2013-12-21
1294243 1294243 DIVIDEND ADD 464288851 0 0 1 0 .155228 00 2013-09-24 2013-09-26 2013-09-30 2013-09-23 0 2013-09-23 ? 0 0004632698 20130923.ifs 2013-09-23 2013-09-24
1226885 1226885 CORPACTION ADD 464288851 04 # 2013-07-01 464288851 04 ? 20130701.ifs 2013-07-01 2013-07-02
1226886 1226886 CORPACTIONAUX ADD 464288851 04 2013-07-01 IEO ISHARES TR ISHARES TRUST - IEO ISHARES TR ISHARES U.S. OI 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1226887 1226887 EQUITY CHANGE 464288851 DJ US OIL&GAS EXPL&PRODCTN INDEX FD 0 A 2006-05-05 ? 0 no no no 2006-05-08 2008-03-14 ? 20130701.ifs 2013-07-01 2013-07-02
1226888 1226887 EQUITY CHANGE 464288851 ISHARES U.S. OIL & GAS EXPLORATION & PRODUCTION ETF 0 A 2006-05-05 ? 0 no no no 2006-05-08 2013-07-01 ? 20130701.ifs 2013-07-01 2013-07-02
1217513 1217513 DIVIDEND ADD 464288851 0 0 1 0 .21304 00 2013-06-26 2013-06-28 2013-07-02 2013-06-25 0 2013-06-25 ? 0 0004588944 20130625.ifs 2013-06-25 2013-06-26
1140182 1140182 DIVIDEND ADD 464288851 0 0 1 0 .162918 00 2013-03-25 2013-03-27 2013-04-01 2013-03-22 0 2013-03-22 ? 0 0004545076 20130322.ifs 2013-03-22 2013-03-23
1047860 1047860 DIVIDEND ADD 464288851 0 0 1 0 .147513 00 2012-12-19 2012-12-21 2012-12-26 2012-12-18 0 2012-12-18 ? 0 0004485661 20121218.ifs 2012-12-18 2012-12-19
963405 963405 DIVIDEND ADD 464288851 0 0 1 0 .12966 00 2012-09-25 2012-09-27 2012-10-01 2012-09-24 0 2012-09-24 ? 0 0004433157 20120924.ifs 2012-09-24 2012-09-25
887460 887460 DIVIDEND ADD 464288851 0 0 1 0 .116849 00 2012-06-19 2012-06-21 2012-06-25 2012-06-18 0 2012-06-18 ? 0 0004387636 20120618.ifs 2012-06-18 2012-06-19
809518 809518 DIVIDEND ADD 464288851 0 0 1 0 .098705 00 2012-03-26 2012-03-28 2012-03-30 2012-03-23 0 2012-03-23 ? 0 0004349496 20120323.ifs 2012-03-23 2012-03-24
650804 650804 DIVIDEND ADD 464288851 0 0 1 0 .065473 00 2011-09-23 2011-09-27 2011-09-29 2011-09-22 0 2011-09-22 ? 0 0004245762 20110922.ifs 2011-09-22 2011-09-23
568270 568270 DIVIDEND ADD 464288851 0 0 1 0 .052293 00 2011-06-24 2011-06-28 2011-06-30 2011-06-23 0 2011-06-23 ? 0 0004205162 20110623.ifs 2011-06-23 2011-06-24
479641 479641 DIVIDEND ADD 464288851 0 0 1 0 .150236 00 2011-03-25 2011-03-29 2011-03-31 2011-03-24 0 2011-03-24 ? 0 0004163796 20110324.ifs 2011-03-24 2011-03-25
396702 396702 DIVIDEND ADD 464288851 0 0 1 9 .00688 03 2010-12-29 2010-12-31 2011-01-05 2010-12-28 0 2010-12-28 ? 0 0004119742 20101228.ifs 2010-12-28 2010-12-29
389306 389306 DIVIDEND ADD 464288851 0 0 1 0 .042145 00 2010-12-22 2010-12-27 2010-12-29 2010-12-21 0 2010-12-21 ? 0 0004114320 20101221.ifs 2010-12-21 2010-12-22
302834 302834 DIVIDEND ADD 464288851 0 0 1 6 0 08 2010-09-23 2010-09-27 2010-09-29 2010-09-07 0 2010-09-07 ? 0 0004058573 20100907.ifs 2010-09-07 2010-09-08
226796 226796 DIVIDEND DELETE 464288851 0 0 1 6 0 08 2010-06-24 2010-06-28 2010-06-30 2010-06-03 0 2010-06-03 ? 0 0004016457 20100623.ifs 2010-06-23 2010-06-24
226797 226797 DIVIDEND ADD 464288851 0 0 1 0 .0467 00 2010-06-24 2010-06-28 2010-06-30 2010-06-03 1 2010-06-03 2010-06-23 0 0004016457 20100623.ifs 2010-06-23 2010-06-24
213127 213127 DIVIDEND ADD 464288851 0 0 1 6 0 08 2010-06-24 2010-06-28 2010-06-30 2010-06-03 0 2010-06-03 ? 0 0004016457 20100603.ifs 2010-06-03 2010-06-04
139596 139596 DIVIDEND DELETE 464288851 0 0 1 6 0 08 2010-03-25 2010-03-29 2010-03-31 2010-03-18 0 2010-03-18 ? 0 0003978837 20100324.ifs 2010-03-24 2010-04-07
139597 139597 DIVIDEND ADD 464288851 0 0 1 0 .03584 00 2010-03-25 2010-03-29 2010-03-31 2010-03-18 1 2010-03-18 2010-03-24 0 0003978837 20100324.ifs 2010-03-24 2010-04-07
134904 134904 DIVIDEND ADD 464288851 0 0 1 6 0 08 2010-03-25 2010-03-29 2010-03-31 2010-03-18 0 2010-03-18 ? 0 0003978837 20100318.ifs 2010-03-18 2010-04-07
62773 62773 DIVIDEND ADD 464288851 0 0 1 0 .06622 00 2009-12-23 2009-12-28 2009-12-30 2009-12-22 0 2009-12-22 ? 0 0003936256 20091222.ifs 2009-12-22 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 = 152114
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