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

the compid is:130762
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
2965043 2965043 DIVIDEND ADD 402307102 0 0 E 0 0 58 ? ? 2018-02-26 2018-02-26 0 2018-02-26 ? 0 0005618568 20180226.ifs 2018-02-26 2018-02-27
2965044 2965044 DIVIDEND ADD 402307102 0 0 E 0 0 58 ? ? 2018-02-26 2018-02-26 0 2018-02-26 ? 0 0005618568 20180226.ifs 2018-02-26 2018-02-27
2736843 2736843 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2017-11-09 2017-11-10 2017-11-24 2017-10-26 0 2017-10-26 ? 0 0005518766 20171026.ifs 2017-10-26 2017-10-27
2736857 2736857 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2017-11-09 2017-11-10 2017-11-24 2017-10-26 0 2017-10-26 ? 0 0005518766 20171026.ifs 2017-10-26 2017-10-27
2632421 2632421 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2017-08-08 2017-08-10 2017-08-24 2017-07-27 0 2017-07-27 ? 0 0005472164 20170727.ifs 2017-07-27 2017-07-28
2548436 2548436 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2017-05-09 2017-05-11 2017-05-25 2017-04-26 0 2017-04-26 ? 0 0005424376 20170426.ifs 2017-04-26 2017-04-27
2494686 2494686 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2017-03-08 2017-03-10 2017-03-24 2017-02-23 0 2017-02-23 ? 0 0005390956 20170223.ifs 2017-02-23 2017-02-24
2439120 2439120 EQUITY CHANGE 402307102 COM 0 0 1997-04-04 ? 8 yes no yes 1997-10-06 2001-01-19 ? 20170123.ifs 2017-01-23 2017-01-24
2439121 2439120 EQUITY CHANGE 402307102 COM 0 0 1997-04-04 ? 4 yes no yes 1997-10-06 2001-01-19 ? 20170123.ifs 2017-01-23 2017-01-24
2327993 2327993 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2016-11-08 2016-11-10 2016-11-23 2016-10-27 0 2016-10-27 ? 0 0005301798 20161027.ifs 2016-10-27 2016-10-28
2259246 2259246 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2016-08-09 2016-08-11 2016-08-25 2016-07-28 0 2016-07-28 ? 0 0005255686 20160728.ifs 2016-07-28 2016-07-29
2181309 2181309 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2016-05-10 2016-05-12 2016-05-26 2016-04-28 0 2016-04-28 ? 0 0005209443 20160428.ifs 2016-04-28 2016-04-29
2119264 2119264 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2016-03-08 2016-03-10 2016-03-24 2016-02-25 0 2016-02-25 ? 0 0005175926 20160225.ifs 2016-02-25 2016-02-26
1999277 1999277 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2015-11-10 2015-11-13 2015-11-27 2015-10-29 0 2015-10-29 ? 0 0005083289 20151029.ifs 2015-10-29 2015-10-30
1928966 1928966 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2015-08-12 2015-08-14 2015-08-28 2015-07-30 0 2015-07-31 ? 0 0005037704 20150731.ifs 2015-07-31 2015-08-01
1846148 1846148 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2015-05-13 2015-05-15 2015-05-29 2015-04-23 0 2015-04-23 ? 0 0004988844 20150423.ifs 2015-04-23 2015-04-24
1802519 1802519 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2015-03-11 2015-03-13 2015-03-27 2015-02-26 0 2015-03-02 ? 0 0004963096 20150302.ifs 2015-03-02 2015-03-03
1662875 1662875 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2014-11-06 2014-11-10 2014-11-24 2014-10-23 0 2014-10-24 ? 0 0004861956 20141024.ifs 2014-10-24 2014-10-25
1586881 1586881 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2014-08-07 2014-08-11 2014-08-25 2014-07-24 0 2014-07-25 ? 0 0004817532 20140725.ifs 2014-07-25 2014-07-26
1502387 1502387 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2014-05-09 2014-05-13 2014-05-30 2014-04-24 0 2014-04-25 ? 0 0004770984 20140425.ifs 2014-04-25 2014-04-26
1453713 1453713 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2014-03-12 2014-03-14 2014-03-24 2014-02-27 0 2014-02-28 ? 0 0004740606 20140228.ifs 2014-02-28 2014-03-01
1323340 1323340 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2013-11-07 2013-11-12 2013-11-27 2013-10-25 0 2013-10-25 ? 0 0004647943 20131025.ifs 2013-10-25 2013-10-26
1246835 1246835 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2013-08-07 2013-08-10 2013-08-28 2013-07-25 0 2013-07-25 ? 0 0004604633 20130725.ifs 2013-07-25 2013-07-26
1167355 1167355 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2013-05-10 2013-05-14 2013-05-31 2013-04-25 0 2013-04-25 ? 0 0004560896 20130425.ifs 2013-04-25 2013-04-26
1131582 1131582 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2013-03-14 2013-03-18 2013-04-01 2013-03-06 0 2013-03-12 ? 0 0004540224 20130312.ifs 2013-03-12 2013-03-13
993515 993515 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2012-11-07 2012-11-12 2012-11-27 2012-10-25 0 2012-10-26 ? 0 0004448203 20121026.ifs 2012-10-26 2012-10-27
843902 843902 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2012-05-10 2012-05-14 2012-05-31 2012-04-26 0 2012-04-26 ? 0 0004364638 20120426.ifs 2012-04-26 2012-04-27
785983 785983 DIVIDEND ADD 402307102 0 0 1 0 .1 00 2012-03-08 2012-03-12 2012-03-26 2012-02-24 0 2012-02-27 ? 0 0004335744 20120227.ifs 2012-02-27 2012-02-28
679383 679383 DIVIDEND ADD 402307102 0 0 1 0 .06 00 2011-11-09 2011-11-14 2011-11-29 2011-10-27 0 2011-10-27 ? 0 0004260878 20111027.ifs 2011-10-27 2011-10-28
598102 598102 DIVIDEND ADD 402307102 0 0 1 0 .06 00 2011-08-10 2011-08-12 2011-08-29 2011-07-28 0 2011-07-29 ? 0 0004220541 20110729.ifs 2011-07-29 2011-07-30
510877 510877 DIVIDEND ADD 402307102 0 0 1 0 .06 00 2011-05-11 2011-05-13 2011-05-30 2011-04-28 0 2011-04-28 ? 0 0004179125 20110428.ifs 2011-04-28 2011-04-29
451265 451265 DIVIDEND ADD 402307102 0 0 1 0 .06 00 2011-03-10 2011-03-14 2011-03-28 2011-02-24 0 2011-02-24 ? 0 0004149757 20110224.ifs 2011-02-24 2011-02-25
344060 344060 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2010-11-10 2010-11-15 2010-12-01 2010-10-28 0 2010-10-28 ? 0 0004078325 20101028.ifs 2010-10-28 2010-10-29
269053 269053 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2010-08-12 2010-08-16 2010-09-02 2010-07-30 0 2010-08-02 ? 0 0004042861 20100802.ifs 2010-08-02 2010-08-03
164816 164816 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2010-05-05 2010-05-07 2010-05-24 2010-04-22 0 2010-04-22 ? 0 0003995324 20100422.ifs 2010-04-22 2010-04-23
122858 122858 DIVIDEND ADD 402307102 0 0 1 0 .01 00 2010-03-11 2010-03-15 2010-03-29 2010-02-26 0 2010-03-01 ? 0 0003972615 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 = 130762
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