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

the compid is:140132
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
5142589 5142589 EQUITY CHANGE G63907102 ORD S 0 2003-12-31 2022-11-18 4 no no no 2014-04-16 2022-11-18 ? 20221122.ifs 2022-11-22 2022-11-23
5142590 5142589 EQUITY CHANGE G63907102 ORD 0 0 2003-12-31 ? 4 no no no 2014-04-16 2022-11-22 ? 20221122.ifs 2022-11-22 2022-11-23
5141118 5141118 EQUITY CHANGE G63907102 ORD S 0 2003-12-31 2022-11-17 4 no no no 2014-04-16 2022-11-17 ? 20221118.ifs 2022-11-18 2022-11-19
5141119 5141118 EQUITY CHANGE G63907102 ORD S 0 2003-12-31 2022-11-18 4 no no no 2014-04-16 2022-11-18 ? 20221118.ifs 2022-11-18 2022-11-19
5141120 5141120 CORPACTION ADD G63907102 01 X 2022-11-18 G63907102 66 ? 20221118.ifs 2022-11-18 2022-11-19
5141121 5141121 EXCHANGE ADD G63907102 66 2022-11-18 ? NTPIF 0 0 2022-11-18 ? 20221118.ifs 2022-11-18 2022-11-19
5140504 5140504 CORPACTION ADD G63907102 01 S 2022-11-17 2022-11-17 20221117.ifs 2022-11-17 2022-11-18
5140505 5140505 EQUITY CHANGE G63907102 ORD N 0 2003-12-31 ? 4 no no no 2014-04-16 ? ? 20221117.ifs 2022-11-17 2022-11-18
5140506 5140505 EQUITY CHANGE G63907102 ORD S 0 2003-12-31 2022-11-17 4 no no no 2014-04-16 2022-11-17 ? 20221117.ifs 2022-11-17 2022-11-18
2837990 2837990 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2018-09-27 2018-09-30 2018-10-19 2017-10-30 0 2017-12-18 ? 3 0005562366 20171218.ifs 2017-12-18 2017-12-19
2837991 2837991 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2018-06-28 2018-06-30 2018-07-20 2017-10-30 0 2017-12-18 ? 2 0005562365 20171218.ifs 2017-12-18 2017-12-19
2837992 2837992 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2018-03-28 2018-03-31 2018-04-20 2017-10-30 0 2017-12-18 ? 1 0005562362 20171218.ifs 2017-12-18 2017-12-19
2837993 2837993 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2017-12-28 2017-12-31 2018-01-19 2017-12-18 0 2017-12-18 ? 0 0005561915 20171218.ifs 2017-12-18 2017-12-19
2530818 2530818 DIVIDEND DELETE G63907102 0 0 1 0 .07 00 2017-09-27 2017-09-30 2017-10-20 2016-10-31 0 2016-11-28 ? 3 0005314346 20170403.ifs 2017-04-03 2017-04-04
2530819 2530819 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2017-09-28 2017-09-30 2017-10-20 2016-10-31 1 2016-11-28 2017-04-03 3 0005314346 20170403.ifs 2017-04-03 2017-04-04
2448130 2448130 EQUITY CHANGE G63907102 ORD N 0 2003-12-31 ? 0 no no no 2014-04-16 ? ? 20170123.ifs 2017-01-23 2017-01-24
2448131 2448130 EQUITY CHANGE G63907102 ORD N 0 2003-12-31 ? 4 no no no 2014-04-16 ? ? 20170123.ifs 2017-01-23 2017-01-24
2349292 2349292 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2017-09-27 2017-09-30 2017-10-20 2016-10-31 0 2016-11-28 ? 3 0005314346 20161128.ifs 2016-11-28 2016-11-29
2349293 2349293 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2017-06-28 2017-06-30 2017-07-20 2016-10-31 0 2016-11-28 ? 2 0005314345 20161128.ifs 2016-11-28 2016-11-29
2349294 2349294 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2017-03-29 2017-03-31 2017-04-20 2016-10-31 0 2016-11-28 ? 1 0005314344 20161128.ifs 2016-11-28 2016-11-29
2349295 2349295 DIVIDEND ADD G63907102 0 0 1 0 .07 00 2016-12-28 2016-12-31 2017-01-20 2016-10-31 0 2016-11-28 ? 0 0005314343 20161128.ifs 2016-11-28 2016-11-29
2323703 2323703 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2016-09-28 2016-09-30 2016-10-31 2016-04-25 1 2016-04-25 2016-07-22 1 0005207597 20161020.ifs 2016-10-20 2016-10-21
2323704 2323704 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2016-09-28 2016-09-30 2016-10-20 2016-04-25 2 2016-04-25 2016-10-20 1 0005207597 20161020.ifs 2016-10-20 2016-10-21
2255630 2255630 DIVIDEND CHANGE G63907102 0 0 1 0 .02 00 2016-09-28 2016-09-30 2016-10-31 2016-04-25 0 2016-04-25 ? 0 0005207597 20160722.ifs 2016-07-22 2016-07-23
2255631 2255630 DIVIDEND CHANGE G63907102 0 0 1 0 .02 00 2016-09-28 2016-09-30 2016-10-31 2016-04-25 1 2016-04-25 2016-07-22 1 0005207597 20160722.ifs 2016-07-22 2016-07-23
2254711 2254711 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2016-06-28 2016-06-30 2016-07-31 2015-11-02 1 2015-12-10 2015-12-23 3 0005109590 20160721.ifs 2016-07-21 2016-07-22
2254712 2254712 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2016-06-28 2016-06-30 2016-07-20 2015-11-02 2 2015-12-10 2016-07-21 2 0005109590 20160721.ifs 2016-07-21 2016-07-22
2182062 2182062 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2016-03-29 2016-03-31 2016-04-30 2015-11-02 1 2015-12-10 2015-12-23 2 0005109586 20160429.ifs 2016-04-29 2016-04-30
2182063 2182063 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2016-03-29 2016-03-31 2016-04-15 2015-11-02 2 2015-12-10 2016-04-29 0 0005109586 20160429.ifs 2016-04-29 2016-04-30
2172427 2172427 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2016-09-28 2016-09-30 2016-10-31 2016-04-25 0 2016-04-25 ? 0 0005207597 20160425.ifs 2016-04-25 2016-04-26
2061893 2061893 DIVIDEND CHANGE G63907102 0 0 1 0 .02 00 2016-06-28 2016-06-30 2016-07-31 2015-11-02 0 2015-12-10 ? 2 0005109590 20151223.ifs 2015-12-23 2015-12-24
2061894 2061893 DIVIDEND CHANGE G63907102 0 0 1 0 .02 00 2016-06-28 2016-06-30 2016-07-31 2015-11-02 1 2015-12-10 2015-12-23 3 0005109590 20151223.ifs 2015-12-23 2015-12-24
2061895 2061895 DIVIDEND CHANGE G63907102 0 0 1 0 .02 00 2016-03-29 2016-03-31 2016-04-30 2015-11-02 0 2015-12-10 ? 1 0005109586 20151223.ifs 2015-12-23 2015-12-24
2061896 2061895 DIVIDEND CHANGE G63907102 0 0 1 0 .02 00 2016-03-29 2016-03-31 2016-04-30 2015-11-02 1 2015-12-10 2015-12-23 2 0005109586 20151223.ifs 2015-12-23 2015-12-24
2061897 2061897 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2015-12-29 2015-12-31 2016-01-31 2015-11-02 0 2015-12-10 ? 0 0005109406 20151223.ifs 2015-12-23 2015-12-24
2061898 2061898 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-12-29 2015-12-31 2016-01-20 2015-11-02 1 2015-12-10 2015-12-23 0 0005109406 20151223.ifs 2015-12-23 2015-12-24
2030343 2030343 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2016-06-28 2016-06-30 2016-07-31 2015-11-02 0 2015-12-10 ? 2 0005109590 20151210.ifs 2015-12-10 2015-12-11
2030344 2030344 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2016-03-29 2016-03-31 2016-04-30 2015-11-02 0 2015-12-10 ? 1 0005109586 20151210.ifs 2015-12-10 2015-12-11
2030345 2030345 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-12-29 2015-12-31 2016-01-31 2015-11-02 0 2015-12-10 ? 0 0005109406 20151210.ifs 2015-12-10 2015-12-11
1989476 1989476 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2015-09-28 2015-09-30 2015-10-30 2015-04-27 0 2015-06-19 ? 1 0005016401 20151012.ifs 2015-10-12 2015-10-13
1989477 1989477 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-09-28 2015-09-30 2015-10-19 2015-04-27 1 2015-06-19 2015-10-12 1 0005016401 20151012.ifs 2015-10-12 2015-10-13
1894246 1894246 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2015-06-26 2015-06-30 2015-07-31 2015-04-27 0 2015-06-19 ? 0 0005016400 20150624.ifs 2015-06-24 2015-06-25
1894247 1894247 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-06-26 2015-06-30 2015-07-20 2015-04-27 1 2015-06-19 2015-06-24 0 0005016400 20150624.ifs 2015-06-24 2015-06-25
1890840 1890840 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-09-28 2015-09-30 2015-10-30 2015-04-27 0 2015-06-19 ? 1 0005016401 20150619.ifs 2015-06-19 2015-06-20
1890841 1890841 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-06-26 2015-06-30 2015-07-31 2015-04-27 0 2015-06-19 ? 0 0005016400 20150619.ifs 2015-06-19 2015-06-20
1814832 1814832 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2015-03-27 2015-03-31 2015-04-20 2015-03-18 0 2015-03-18 ? 0 0004969558 20150318.ifs 2015-03-18 2015-03-19
1730228 1730228 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2014-12-29 2014-12-31 2015-01-30 2014-11-03 0 2014-12-08 ? 0 0004886990 20141219.ifs 2014-12-19 2014-12-20
1730229 1730229 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2014-12-29 2014-12-31 2015-01-20 2014-11-03 1 2014-12-08 2014-12-19 0 0004886990 20141219.ifs 2014-12-19 2014-12-20
1702831 1702831 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2014-12-29 2014-12-31 2015-01-30 2014-11-03 0 2014-12-08 ? 0 0004886990 20141208.ifs 2014-12-08 2014-12-09
1635213 1635213 DIVIDEND DELETE G63907102 0 0 1 0 .02 00 2014-09-26 2014-09-30 2014-10-30 2014-08-04 0 2014-08-04 ? 0 0004826032 20140922.ifs 2014-09-22 2014-09-23
1635214 1635214 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2014-09-26 2014-09-30 2014-10-20 2014-08-04 1 2014-08-04 2014-09-22 0 0004826032 20140922.ifs 2014-09-22 2014-09-23
1598479 1598479 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2014-09-26 2014-09-30 2014-10-30 2014-08-04 0 2014-08-04 ? 0 0004826032 20140804.ifs 2014-08-04 2014-08-05
1550112 1550112 DIVIDEND ADD G63907102 0 0 1 0 .02 00 2014-06-26 2014-06-30 2014-07-18 2014-06-16 0 2014-06-16 ? 0 0004796456 20140616.ifs 2014-06-16 2014-06-17
1499364 1499364 EXCHANGE ADD G63907102 01 2014-04-22 2014-04-22 NTP 0 0 2014-04-22 ? 20140422.ifs 2014-04-22 2014-04-23
1496667 1496667 EQUITY ADD G63907102 ORD N 0 2003-12-31 ? 0 no no no 2014-04-16 ? ? 20140416.ifs 2014-04-16 2014-04-17


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