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 AMLTY Charts Yahoo AMLTY Profile
  Run AMLTY Institutional Summary Yahoo AMLTY Key Statisics
  J3 Open AMLTY Pricing Yahoo AMLTY Pricing
  J3 AMLTY Insider   J3 AMLTY Insitutions Yahoo AMLTY Holders
     
  Open up Sector/Exchange Map Fidelity AMLTY Lookup
  Open up sec.gov For Market Ca MSN AMLTY 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:145449
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
1117458 1117458 CORPACTION ADD 0017EP103 66 V 2013-02-26 0017EP202 66 ? 20130226.ifs 2013-02-26 2013-02-27
1117459 1117459 EQUITY CHANGE 0017EP103 UNSPONSORED ADR 2 0 2003-12-31 ? 0 no no no 2005-01-31 2003-12-31 ? 20130226.ifs 2013-02-26 2013-02-27
1117460 1117459 EQUITY CHANGE 0017EP103 UNSPONSORED ADR V 0 2003-12-31 2013-02-26 0 no no 0017EP202 no 2005-01-31 2013-02-26 ? 20130226.ifs 2013-02-26 2013-02-27
986203 986203 DIVIDEND DELETE 0017EP103 6 0 1 5 .4713 26 2012-09-04 2012-09-06 2012-11-01 2012-08-17 1 2012-08-17 2012-08-20 0 0004416896 20121015.ifs 2012-10-15 2012-10-16
986204 986204 DIVIDEND ADD 0017EP103 6 0 1 0 .462155 05 2012-09-04 2012-09-06 2012-11-01 2012-08-17 2 2012-08-17 2012-10-15 0 0004416896 20121015.ifs 2012-10-15 2012-10-16
936074 936074 DIVIDEND DELETE 0017EP103 6 0 1 5 .4713 26 ? 2012-09-06 2012-11-01 2012-08-17 0 2012-08-17 ? 0 0004416896 20120820.ifs 2012-08-20 2012-08-21
936075 936075 DIVIDEND ADD 0017EP103 6 0 1 5 .4713 26 2012-09-04 2012-09-06 2012-11-01 2012-08-17 1 2012-08-17 2012-08-20 0 0004416896 20120820.ifs 2012-08-20 2012-08-21
935205 935205 DIVIDEND ADD 0017EP103 6 0 1 5 .4713 26 ? 2012-09-06 2012-11-01 2012-08-17 0 2012-08-17 ? 0 0004416896 20120817.ifs 2012-08-17 2012-08-18
832539 832539 DIVIDEND DELETE 0017EP103 6 0 1 5 .550488 26 2012-02-28 2012-03-01 ? 2012-02-16 1 2012-02-16 2012-02-17 0 0004333439 20120409.ifs 2012-04-09 2012-04-10
832540 832540 DIVIDEND ADD 0017EP103 6 0 1 0 .526156 05 2012-02-28 2012-03-01 2012-04-26 2012-02-16 2 2012-02-16 2012-04-09 0 0004333439 20120409.ifs 2012-04-09 2012-04-10
781756 781756 DIVIDEND DELETE 0017EP103 6 0 1 5 .550488 26 ? 2012-03-01 ? 2012-02-16 0 2012-02-16 ? 0 0004333439 20120217.ifs 2012-02-17 2012-02-18
781757 781757 DIVIDEND ADD 0017EP103 6 0 1 5 .550488 26 2012-02-28 2012-03-01 ? 2012-02-16 1 2012-02-16 2012-02-17 0 0004333439 20120217.ifs 2012-02-17 2012-02-18
780909 780909 DIVIDEND ADD 0017EP103 6 0 1 5 .550488 26 ? 2012-03-01 ? 2012-02-16 0 2012-02-16 ? 0 0004333439 20120216.ifs 2012-02-16 2012-02-17
674656 674656 DIVIDEND CHANGE 0017EP103 6 0 1 0 .567874 05 2011-09-06 2011-09-08 2011-11-03 2011-08-25 2 2011-08-25 2011-10-17 0 0004232282 20111018.ifs 2011-10-18 2011-10-19
674657 674656 DIVIDEND CHANGE 0017EP103 6 0 1 0 .567874 05 2011-09-06 2011-09-08 2011-11-03 2011-08-25 3 2011-08-25 2011-10-18 0 0004232282 20111018.ifs 2011-10-18 2011-10-19
674031 674031 DIVIDEND DELETE 0017EP103 6 0 1 5 .5776 26 2011-09-06 2011-09-08 ? 2011-08-25 1 2011-08-25 2011-08-26 0 0004232282 20111017.ifs 2011-10-17 2011-10-18
674032 674032 DIVIDEND ADD 0017EP103 6 0 1 0 .567874 05 2011-09-06 2011-09-08 2011-11-03 2011-08-25 2 2011-08-25 2011-10-17 0 0004232282 20111017.ifs 2011-10-17 2011-10-18
627629 627629 DIVIDEND DELETE 0017EP103 6 0 1 5 .5776 26 ? 2011-09-08 ? 2011-08-25 0 2011-08-25 ? 0 0004232282 20110826.ifs 2011-08-26 2011-08-27
627630 627630 DIVIDEND ADD 0017EP103 6 0 1 5 .5776 26 2011-09-06 2011-09-08 ? 2011-08-25 1 2011-08-25 2011-08-26 0 0004232282 20110826.ifs 2011-08-26 2011-08-27
626667 626667 DIVIDEND ADD 0017EP103 6 0 1 5 .5776 26 ? 2011-09-08 ? 2011-08-25 0 2011-08-25 ? 0 0004232282 20110825.ifs 2011-08-25 2011-08-26
499517 499517 DIVIDEND DELETE 0017EP103 6 0 1 5 .5563 26 2011-03-01 2011-03-03 ? 2011-02-18 1 2011-02-18 2011-02-22 0 0004148117 20110408.ifs 2011-04-08 2011-04-09
499518 499518 DIVIDEND ADD 0017EP103 6 0 1 0 .581674 05 2011-03-01 2011-03-03 2011-04-29 2011-02-18 2 2011-02-18 2011-04-08 0 0004148117 20110408.ifs 2011-04-08 2011-04-09
448062 448062 DIVIDEND DELETE 0017EP103 6 0 1 5 .5563 26 ? 2011-03-03 ? 2011-02-18 0 2011-02-18 ? 0 0004148117 20110222.ifs 2011-02-22 2011-02-23
448063 448063 DIVIDEND ADD 0017EP103 6 0 1 5 .5563 26 2011-03-01 2011-03-03 ? 2011-02-18 1 2011-02-18 2011-02-22 0 0004148117 20110222.ifs 2011-02-22 2011-02-23
446221 446221 DIVIDEND ADD 0017EP103 6 0 1 5 .5563 26 ? 2011-03-03 ? 2011-02-18 0 2011-02-18 ? 0 0004148117 20110218.ifs 2011-02-18 2011-02-19
337676 337676 DIVIDEND DELETE 0017EP103 6 0 1 5 .50938 26 2010-09-07 2010-09-09 2010-11-04 2010-08-25 1 2010-08-25 2010-08-27 0 0004049772 20101019.ifs 2010-10-19 2010-10-20
337677 337677 DIVIDEND ADD 0017EP103 6 0 1 0 .57512 05 2010-09-07 2010-09-09 2010-11-04 2010-08-25 2 2010-08-25 2010-10-19 0 0004049772 20101019.ifs 2010-10-19 2010-10-20
288062 288062 DIVIDEND DELETE 0017EP103 6 0 1 5 .50938 26 ? 2010-09-09 2010-11-04 2010-08-25 0 2010-08-25 ? 0 0004049772 20100827.ifs 2010-08-27 2010-08-28
288063 288063 DIVIDEND ADD 0017EP103 6 0 1 5 .50938 26 2010-09-07 2010-09-09 2010-11-04 2010-08-25 1 2010-08-25 2010-08-27 0 0004049772 20100827.ifs 2010-08-27 2010-08-28
286296 286296 DIVIDEND ADD 0017EP103 6 0 1 5 .50938 26 ? 2010-09-09 2010-11-04 2010-08-25 0 2010-08-25 ? 0 0004049772 20100825.ifs 2010-08-25 2010-08-26
159320 159320 DIVIDEND DELETE 0017EP103 6 0 1 5 .55638 26 2010-02-24 2010-02-26 ? 2010-02-18 1 2010-02-18 2010-02-19 0 0003966325 20100414.ifs 2010-04-14 2010-04-15
159321 159321 DIVIDEND ADD 0017EP103 6 0 1 0 .57804 05 2010-02-24 2010-02-26 2010-04-30 2010-02-18 2 2010-02-18 2010-04-14 0 0003966325 20100414.ifs 2010-04-14 2010-04-15
113697 113697 DIVIDEND DELETE 0017EP103 6 0 1 5 .55638 26 ? 2010-02-26 ? 2010-02-18 0 2010-02-18 ? 0 0003966325 20100219.ifs 2010-02-19 2010-04-07
113698 113698 DIVIDEND ADD 0017EP103 6 0 1 5 .55638 26 2010-02-24 2010-02-26 ? 2010-02-18 1 2010-02-18 2010-02-19 0 0003966325 20100219.ifs 2010-02-19 2010-04-07
112576 112576 DIVIDEND ADD 0017EP103 6 0 1 5 .55638 26 ? 2010-02-26 ? 2010-02-18 0 2010-02-18 ? 0 0003966325 20100218.ifs 2010-02-18 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 = 145449
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