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 FNY Charts Yahoo FNY Profile
  Run FNY Institutional Summary Yahoo FNY Key Statisics
  J3 Open FNY Pricing Yahoo FNY Pricing
  J3 FNY Insider   J3 FNY Insitutions Yahoo FNY Holders
     
  Open up Sector/Exchange Map Fidelity FNY Lookup
  Open up sec.gov For Market Ca MSN FNY 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
33737M102 DELETE RUN
 

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 : 90 85   Update Insititution By Cusips
% Owned by Insititutions: 42.88 % 40.54 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:159727
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
5584238 5584238 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2024-06-28 2024-06-26 0 2024-06-26 ? 0 0006938846 20240626.ifs 2024-06-26 2024-06-27
5519826 5519826 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2024-03-28 2024-03-20 0 2024-03-20 ? 0 0006892824 20240320.ifs 2024-03-20 2024-03-21
5457235 5457235 DIVIDEND ADD 33737M102 0 0 1 0 .0619 00 2023-12-22 2023-12-26 2023-12-29 2023-12-21 0 2023-12-21 ? 0 0006846842 20231221.ifs 2023-12-21 2023-12-22
5378377 5378377 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2023-09-29 2023-09-21 0 2023-09-21 ? 0 0006786298 20230921.ifs 2023-09-21 2023-09-22
5318803 5318803 DIVIDEND ADD 33737M102 0 0 1 0 .0218 00 2023-06-27 2023-06-28 2023-06-30 2023-06-26 0 2023-06-26 ? 0 0006744184 20230626.ifs 2023-06-26 2023-06-27
5254069 5254069 DIVIDEND ADD 33737M102 0 0 1 0 .083 00 2023-03-24 2023-03-27 2023-03-31 2023-03-23 0 2023-03-23 ? 0 0006699589 20230323.ifs 2023-03-23 2023-03-24
5186780 5186780 DIVIDEND ADD 33737M102 0 0 1 0 .1112 00 2022-12-23 2022-12-27 2022-12-30 2022-12-22 0 2022-12-22 ? 0 0006651123 20221222.ifs 2022-12-22 2022-12-23
5102624 5102624 DIVIDEND ADD 33737M102 0 0 1 0 .0225 00 2022-09-23 2022-09-26 2022-09-30 2022-09-22 0 2022-09-22 ? 0 0006587272 20220922.ifs 2022-09-22 2022-09-23
5040103 5040103 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2022-06-30 2022-06-23 0 2022-06-23 ? 0 0006543174 20220623.ifs 2022-06-23 2022-06-24
4977245 4977245 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2022-03-31 2022-03-24 0 2022-03-24 ? 0 0006499033 20220324.ifs 2022-03-24 2022-03-25
4909119 4909119 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2021-12-31 2021-12-22 0 2021-12-22 ? 0 0006445403 20211222.ifs 2021-12-22 2021-12-23
4807598 4807598 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2021-09-30 2021-09-22 0 2021-09-22 ? 0 0006370862 20210922.ifs 2021-09-22 2021-09-23
4736445 4736445 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2021-06-30 2021-06-23 0 2021-06-23 ? 0 0006326309 20210623.ifs 2021-06-23 2021-06-24
4661246 4661246 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2021-03-31 2021-03-24 0 2021-03-24 ? 0 0006281259 20210324.ifs 2021-03-24 2021-03-25
4572303 4572303 DIVIDEND ADD 33737M102 0 0 1 0 .0697 00 2020-12-24 2020-12-28 2020-12-31 2020-12-23 0 2020-12-23 ? 0 0006232334 20201223.ifs 2020-12-23 2020-12-24
4468480 4468480 DIVIDEND ADD 33737M102 0 0 1 0 .0897 00 2020-09-24 2020-09-25 2020-09-30 2020-09-23 0 2020-09-23 ? 0 0006162606 20200923.ifs 2020-09-23 2020-09-24
4399514 4399514 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2020-06-30 2020-06-24 0 2020-06-24 ? 0 0006117783 20200624.ifs 2020-06-24 2020-06-25
4255727 4255727 DIVIDEND ADD 33737M102 0 0 1 0 .0039 00 2020-03-26 2020-03-27 2020-03-31 2020-03-25 0 2020-03-25 ? 0 0006073702 20200325.ifs 2020-03-25 2020-03-26
4255728 4255728 DIVIDEND ADD 33737M102 0 0 1 0 .0039 00 2020-03-26 2020-03-27 2020-03-31 2020-03-25 0 2020-03-25 ? 0 0006073702 20200325.ifs 2020-03-25 2020-03-26
4062581 4062581 DIVIDEND ADD 33737M102 0 0 1 0 .1074 00 2019-12-13 2019-12-16 2019-12-31 2019-12-12 0 2019-12-12 ? 0 0005996536 20191212.ifs 2019-12-12 2019-12-13
4062680 4062680 DIVIDEND ADD 33737M102 0 0 1 0 .1074 00 2019-12-13 2019-12-16 2019-12-31 2019-12-12 0 2019-12-12 ? 0 0005996536 20191212.ifs 2019-12-12 2019-12-13
3936943 3936943 DIVIDEND ADD 33737M102 0 0 1 0 .0247 00 2019-09-25 2019-09-26 2019-09-30 2019-09-24 0 2019-09-24 ? 0 0005949781 20190924.ifs 2019-09-24 2019-09-25
3937070 3937070 DIVIDEND ADD 33737M102 0 0 1 0 .0247 00 2019-09-25 2019-09-26 2019-09-30 2019-09-24 0 2019-09-24 ? 0 0005949781 20190924.ifs 2019-09-24 2019-09-25
3778432 3778432 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2019-06-28 2019-06-13 0 2019-06-13 ? 0 0005897678 20190613.ifs 2019-06-13 2019-06-14
3778433 3778433 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2019-06-28 2019-06-13 0 2019-06-13 ? 0 0005897678 20190613.ifs 2019-06-13 2019-06-14
3640360 3640360 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2019-03-29 2019-03-20 0 2019-03-20 ? 0 0005855765 20190320.ifs 2019-03-20 2019-03-21
3640361 3640361 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2019-03-29 2019-03-20 0 2019-03-20 ? 0 0005855765 20190320.ifs 2019-03-20 2019-03-21
3454391 3454391 DIVIDEND ADD 33737M102 0 0 1 0 .0207 00 2018-12-18 2018-12-19 2018-12-31 2018-12-17 0 2018-12-17 ? 0 0005784798 20181217.ifs 2018-12-17 2018-12-18
3454557 3454557 DIVIDEND ADD 33737M102 0 0 1 0 .0207 00 2018-12-18 2018-12-19 2018-12-31 2018-12-17 0 2018-12-17 ? 0 0005784798 20181217.ifs 2018-12-17 2018-12-18
3281834 3281834 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2018-09-28 2018-09-13 0 2018-09-13 ? 0 0005723035 20180913.ifs 2018-09-13 2018-09-14
3281904 3281904 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2018-09-28 2018-09-13 0 2018-09-13 ? 0 0005723035 20180913.ifs 2018-09-13 2018-09-14
3149423 3149423 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2018-06-29 2018-06-20 0 2018-06-20 ? 0 0005678313 20180620.ifs 2018-06-20 2018-06-21
3149442 3149442 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2018-06-29 2018-06-20 0 2018-06-20 ? 0 0005678313 20180620.ifs 2018-06-20 2018-06-21
3001104 3001104 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2018-03-29 2018-03-21 0 2018-03-21 ? 0 0005632671 20180321.ifs 2018-03-21 2018-03-22
3001127 3001127 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2018-03-29 2018-03-21 0 2018-03-21 ? 0 0005632671 20180321.ifs 2018-03-21 2018-03-22
2852933 2852933 DIVIDEND ADD 33737M102 0 0 1 0 .0458 00 2017-12-21 2017-12-22 2017-12-29 2017-12-20 0 2017-12-20 ? 0 0005570423 20171220.ifs 2017-12-20 2017-12-21
2856381 2856381 DIVIDEND ADD 33737M102 0 0 1 0 .0458 00 2017-12-21 2017-12-22 2017-12-29 2017-12-20 0 2017-12-20 ? 0 0005570423 20171220.ifs 2017-12-20 2017-12-21
2680337 2680337 DIVIDEND ADD 33737M102 0 0 1 0 .0072 00 2017-09-21 2017-09-22 2017-09-29 2017-09-20 0 2017-09-20 ? 0 0005500148 20170920.ifs 2017-09-20 2017-09-21
2680368 2680368 DIVIDEND ADD 33737M102 0 0 1 0 .0072 00 2017-09-21 2017-09-22 2017-09-29 2017-09-20 0 2017-09-20 ? 0 0005500148 20170920.ifs 2017-09-20 2017-09-21
2597574 2597574 DIVIDEND ADD 33737M102 0 0 1 0 .029 00 2017-06-22 2017-06-26 2017-06-30 2017-06-21 0 2017-06-21 ? 0 0005452852 20170621.ifs 2017-06-21 2017-06-22
2438242 2438242 EQUITY CHANGE 33737M102 MID CAP GROWTH ALPHADEX FD N A 2011-04-19 ? 0 no no yes 2011-04-19 2016-04-07 ? 20170123.ifs 2017-01-23 2017-01-24
2438243 2438242 EQUITY CHANGE 33737M102 MID CAP GROWTH ALPHADEX FD N A 2011-04-19 ? 4 no no yes 2011-04-19 2016-04-07 ? 20170123.ifs 2017-01-23 2017-01-24
2388723 2388723 DIVIDEND ADD 33737M102 0 0 1 0 .1151 00 2016-12-21 2016-12-23 2016-12-30 2016-12-20 0 2016-12-20 ? 0 0005346913 20161220.ifs 2016-12-20 2016-12-21
2297938 2297938 DIVIDEND ADD 33737M102 0 0 1 0 .0269 00 2016-09-21 2016-09-23 2016-09-30 2016-09-20 0 2016-09-20 ? 0 0005283174 20160920.ifs 2016-09-20 2016-09-21
2226810 2226810 DIVIDEND ADD 33737M102 0 0 1 0 .0276 00 2016-06-22 2016-06-24 2016-06-30 2016-06-21 0 2016-06-21 ? 0 0005236401 20160621.ifs 2016-06-21 2016-06-22
2161208 2161208 CORPACTION ADD 33737M102 04 X 2016-04-08 33737M102 60 ? 20160408.ifs 2016-04-08 2016-04-09
2161209 2161209 EXCHANGE ADD 33737M102 60 2016-04-08 2016-04-08 FNY 0 A 2016-04-08 ? 20160408.ifs 2016-04-08 2016-04-09
2160227 2160227 EQUITY CHANGE 33737M102 MID CAP GROWTH ALPHADEX FD N A 2011-04-19 ? 0 no no no 2011-04-19 2011-04-19 ? 20160407.ifs 2016-04-07 2016-04-08
2160228 2160227 EQUITY CHANGE 33737M102 MID CAP GROWTH ALPHADEX FD N A 2011-04-19 ? 0 no no yes 2011-04-19 2016-04-07 ? 20160407.ifs 2016-04-07 2016-04-08
2140734 2140734 DIVIDEND ADD 33737M102 0 0 1 0 .0175 00 2016-03-23 2016-03-28 2016-03-31 2016-03-22 0 2016-03-22 ? 0 0005190676 20160322.ifs 2016-03-22 2016-03-23
2060118 2060118 DIVIDEND ADD 33737M102 0 0 1 0 .0364 00 2015-12-23 2015-12-28 2015-12-31 2015-12-22 0 2015-12-22 ? 0 0005135692 20151222.ifs 2015-12-22 2015-12-23
1819406 1819406 DIVIDEND ADD 33737M102 0 0 1 0 .0724 00 2015-03-25 2015-03-27 2015-03-31 2015-03-24 0 2015-03-24 ? 0 0004972637 20150324.ifs 2015-03-24 2015-03-25
1737671 1737671 DIVIDEND ADD 33737M102 0 0 1 0 .0299 00 2014-12-23 2014-12-26 2014-12-31 2014-12-22 0 2014-12-22 ? 0 0004916111 20141222.ifs 2014-12-22 2014-12-23
1635535 1635535 DIVIDEND ADD 33737M102 0 0 1 0 .0185 00 2014-09-23 2014-09-25 2014-09-30 2014-09-22 0 2014-09-22 ? 0 0004846070 20140922.ifs 2014-09-22 2014-09-23
1557392 1557392 DIVIDEND ADD 33737M102 0 0 1 0 .0134 00 2014-06-24 2014-06-26 2014-06-30 2014-06-23 0 2014-06-23 ? 0 0004800526 20140623.ifs 2014-06-23 2014-06-24
1474698 1474698 DIVIDEND ADD 33737M102 0 0 1 0 .0015 00 2014-03-25 2014-03-27 2014-03-31 2014-03-24 0 2014-03-24 ? 0 0004754588 20140324.ifs 2014-03-24 2014-03-25
1377377 1377377 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2013-12-31 2013-12-17 0 2013-12-17 ? 0 0004688854 20131217.ifs 2013-12-17 2013-12-18
1291573 1291573 DIVIDEND ADD 33737M102 0 0 1 0 .0651 00 2013-09-20 2013-09-24 2013-09-30 2013-09-19 0 2013-09-19 ? 0 0004630866 20130919.ifs 2013-09-19 2013-09-20
1213702 1213702 DIVIDEND ADD 33737M102 0 0 1 0 .0345 00 2013-06-21 2013-06-25 2013-06-28 2013-06-20 0 2013-06-20 ? 0 0004586678 20130620.ifs 2013-06-20 2013-06-21
1137745 1137745 DIVIDEND ADD 33737M102 0 0 E 0 0 58 ? ? 2013-03-28 2013-03-20 0 2013-03-20 ? 0 0004543635 20130320.ifs 2013-03-20 2013-03-21
1056891 1056891 DIVIDEND CHANGE 33737M102 0 0 1 0 .2648 00 2012-12-21 2012-12-26 2012-12-31 2012-12-20 0 2012-12-20 ? 0 0004489679 20121221.ifs 2012-12-21 2012-12-22
1056892 1056891 DIVIDEND CHANGE 33737M102 0 0 1 0 .0983 00 2012-12-21 2012-12-26 2012-12-31 2012-12-20 1 2012-12-20 2012-12-21 0 0004489679 20121221.ifs 2012-12-21 2012-12-22
1053315 1053315 DIVIDEND ADD 33737M102 0 0 1 0 .2648 00 2012-12-21 2012-12-26 2012-12-31 2012-12-20 0 2012-12-20 ? 0 0004489679 20121220.ifs 2012-12-20 2012-12-21
889855 889855 DIVIDEND ADD 33737M102 0 0 1 0 .0056 00 2012-06-21 2012-06-25 2012-06-29 2012-06-20 0 2012-06-20 ? 0 0004389092 20120620.ifs 2012-06-20 2012-06-21
733329 733329 DIVIDEND ADD 33737M102 0 0 1 4 .004 00 2011-12-21 2011-12-23 2011-12-30 2011-12-20 0 2011-12-20 ? 0 0004296792 20111220.ifs 2011-12-20 2011-12-21
504348 504348 EQUITY ADD 33737M102 MID CAP GROWTH ALPHADEX FD N 7 2011-04-19 ? 0 no no no 2011-04-19 ? ? 20110419.ifs 2011-04-19 2011-04-20
504349 504349 EXCHANGE ADD 33737M102 04 2011-04-19 ? FNY 0 A 2011-04-19 ? 20110419.ifs 2011-04-19 2011-04-20
504403 504403 EQUITY CHANGE 33737M102 MID CAP GROWTH ALPHADEX FD N 7 2011-04-19 ? 0 no no no 2011-04-19 ? ? 20110419.ifs 2011-04-19 2011-04-20
504404 504403 EQUITY CHANGE 33737M102 MID CAP GROWTH ALPHADEX FD N A 2011-04-19 ? 0 no no no 2011-04-19 2011-04-19 ? 20110419.ifs 2011-04-19 2011-04-20


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