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 HINKY Charts Yahoo HINKY Profile
  Run HINKY Institutional Summary Yahoo HINKY Key Statisics
  J3 Open HINKY Pricing Yahoo HINKY Pricing
  J3 HINKY Insider   J3 HINKY Insitutions Yahoo HINKY Holders
     
  Open up Sector/Exchange Map Fidelity HINKY Lookup
  Open up sec.gov For Market Ca MSN HINKY 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
423012202 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 : 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:142469
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
1035017 1035017 CORPACTION ADD 423012202 66 V 2012-12-11 423012301 66 ? 20121211.ifs 2012-12-11 2012-12-12
1035020 1035020 EQUITY CHANGE 423012202 ADR 0 0 1996-09-03 ? 8 no no no 1997-04-11 2000-04-11 ? 20121211.ifs 2012-12-11 2012-12-12
1035021 1035020 EQUITY CHANGE 423012202 ADR V 0 1996-09-03 2012-12-11 8 no no 423012301 no 1997-04-11 2012-12-11 ? 20121211.ifs 2012-12-11 2012-12-12
952411 952411 DIVIDEND DELETE 423012202 B 0 1 0 .156182 02 2012-08-30 2012-09-04 2012-09-20 2012-08-22 2 2012-08-22 2012-09-04 0 0004417805 20120907.ifs 2012-09-07 2012-09-08
952412 952412 DIVIDEND ADD 423012202 0 0 1 0 .207273 00 2012-08-30 2012-09-04 2012-09-20 2012-08-22 3 2012-08-22 2012-09-07 0 0004417805 20120907.ifs 2012-09-07 2012-09-08
947811 947811 DIVIDEND DELETE 423012202 0 0 1 5 .205755 19 2012-08-30 2012-09-04 2012-09-20 2012-08-22 1 2012-08-22 2012-08-23 0 0004417805 20120904.ifs 2012-09-04 2012-09-05
947812 947812 DIVIDEND ADD 423012202 B 0 1 0 .156182 02 2012-08-30 2012-09-04 2012-09-20 2012-08-22 2 2012-08-22 2012-09-04 0 0004417805 20120904.ifs 2012-09-04 2012-09-05
938116 938116 DIVIDEND DELETE 423012202 0 0 1 5 .205755 19 ? 2012-09-04 2012-09-20 2012-08-22 0 2012-08-22 ? 0 0004417805 20120823.ifs 2012-08-23 2012-08-24
938117 938117 DIVIDEND ADD 423012202 0 0 1 5 .205755 19 2012-08-30 2012-09-04 2012-09-20 2012-08-22 1 2012-08-22 2012-08-23 0 0004417805 20120823.ifs 2012-08-23 2012-08-24
937411 937411 DIVIDEND ADD 423012202 0 0 1 5 .205755 19 ? 2012-09-04 2012-09-20 2012-08-22 0 2012-08-22 ? 0 0004417805 20120822.ifs 2012-08-22 2012-08-23
854911 854911 DIVIDEND DELETE 423012202 0 0 1 5 .353139 19 2012-04-18 2012-04-20 2012-05-23 2012-04-04 1 2012-04-04 2012-04-05 0 0004359791 20120503.ifs 2012-05-03 2012-05-04
854912 854912 DIVIDEND ADD 423012202 B 0 1 0 .275753 02 2012-04-18 2012-04-20 2012-05-23 2012-04-04 2 2012-04-04 2012-05-03 0 0004359791 20120503.ifs 2012-05-03 2012-05-04
831669 831669 DIVIDEND DELETE 423012202 0 0 1 5 .353139 19 ? 2012-04-20 2012-05-23 2012-04-04 0 2012-04-04 ? 0 0004359791 20120405.ifs 2012-04-05 2012-04-06
831670 831670 DIVIDEND ADD 423012202 0 0 1 5 .353139 19 2012-04-18 2012-04-20 2012-05-23 2012-04-04 1 2012-04-04 2012-04-05 0 0004359791 20120405.ifs 2012-04-05 2012-04-06
830616 830616 DIVIDEND ADD 423012202 0 0 1 5 .353139 19 ? 2012-04-20 2012-05-23 2012-04-04 0 2012-04-04 ? 0 0004359791 20120404.ifs 2012-04-04 2012-04-05
651980 651980 DIVIDEND CHANGE 423012202 B 0 1 0 .158461 02 2011-09-01 2011-09-06 2011-09-27 2011-08-24 3 2011-08-24 2011-09-06 0 0004231844 20110923.ifs 2011-09-23 2011-09-24
651981 651980 DIVIDEND CHANGE 423012202 B 0 1 0 .158461 02 2011-09-01 2011-09-06 2011-09-27 2011-08-24 4 2011-08-24 2011-09-23 0 0004231844 20110923.ifs 2011-09-23 2011-09-24
637373 637373 DIVIDEND DELETE 423012202 B 0 1 5 .16439 39 2011-09-01 2011-09-06 2011-09-27 2011-08-24 2 2011-08-24 2011-08-30 0 0004231844 20110906.ifs 2011-09-06 2011-09-07
637374 637374 DIVIDEND ADD 423012202 B 0 1 0 .158461 02 2011-09-01 2011-09-06 2011-09-27 2011-08-24 3 2011-08-24 2011-09-06 0 0004231844 20110906.ifs 2011-09-06 2011-09-07
628293 628293 DIVIDEND DELETE 423012202 0 0 1 5 .21693 19 2011-09-01 2011-09-06 2011-09-27 2011-08-24 1 2011-08-24 2011-08-25 0 0004231844 20110830.ifs 2011-08-30 2011-08-31
628294 628294 DIVIDEND ADD 423012202 B 0 1 5 .16439 39 2011-09-01 2011-09-06 2011-09-27 2011-08-24 2 2011-08-24 2011-08-30 0 0004231844 20110830.ifs 2011-08-30 2011-08-31
626477 626477 DIVIDEND DELETE 423012202 0 0 1 5 .21693 19 ? 2011-09-06 2011-09-27 2011-08-24 0 2011-08-24 ? 0 0004231844 20110825.ifs 2011-08-25 2011-08-26
626478 626478 DIVIDEND ADD 423012202 0 0 1 5 .21693 19 2011-09-01 2011-09-06 2011-09-27 2011-08-24 1 2011-08-24 2011-08-25 0 0004231844 20110825.ifs 2011-08-25 2011-08-26
625396 625396 DIVIDEND ADD 423012202 0 0 1 5 .21693 19 ? 2011-09-06 2011-09-27 2011-08-24 0 2011-08-24 ? 0 0004231844 20110824.ifs 2011-08-24 2011-08-25
523063 523063 DIVIDEND CHANGE 423012202 B 0 1 0 .289888 02 2011-04-21 2011-04-26 2011-05-20 2011-03-15 3 2011-03-15 2011-05-05 0 0004159342 20110509.ifs 2011-05-09 2011-05-10
523064 523063 DIVIDEND CHANGE 423012202 B 0 1 0 .289888 02 2011-04-21 2011-04-26 2011-05-20 2011-03-15 4 2011-03-15 2011-05-09 0 0004159342 20110509.ifs 2011-05-09 2011-05-10
521012 521012 DIVIDEND DELETE 423012202 B 0 1 5 .275502 39 2011-04-21 2011-04-26 2011-05-20 2011-03-15 2 2011-03-15 2011-04-19 0 0004159342 20110505.ifs 2011-05-05 2011-05-06
521013 521013 DIVIDEND ADD 423012202 B 0 1 0 .289888 02 2011-04-21 2011-04-26 2011-05-20 2011-03-15 3 2011-03-15 2011-05-05 0 0004159342 20110505.ifs 2011-05-05 2011-05-06
504608 504608 DIVIDEND DELETE 423012202 0 0 1 5 .34765 19 2011-04-21 2011-04-26 2011-05-20 2011-03-15 1 2011-03-15 2011-03-16 0 0004159342 20110419.ifs 2011-04-19 2011-04-20
504609 504609 DIVIDEND ADD 423012202 B 0 1 5 .275502 39 2011-04-21 2011-04-26 2011-05-20 2011-03-15 2 2011-03-15 2011-04-19 0 0004159342 20110419.ifs 2011-04-19 2011-04-20
472091 472091 DIVIDEND ADD 423012202 0 0 1 5 .34765 19 ? 2011-04-26 2011-05-20 2011-03-15 0 2011-03-15 ? 0 0004159342 20110315.ifs 2011-03-15 2011-03-16
301926 301926 DIVIDEND DELETE 423012202 B 0 1 5 .11987 39 2010-08-31 2010-09-02 2010-09-27 2010-08-25 1 2010-08-25 2010-08-26 0 0004049493 20100903.ifs 2010-09-03 2010-09-04
301927 301927 DIVIDEND ADD 423012202 B 0 1 0 .121962 02 2010-08-31 2010-09-02 2010-09-27 2010-08-25 2 2010-08-25 2010-09-03 0 0004049493 20100903.ifs 2010-09-03 2010-09-04
287156 287156 DIVIDEND DELETE 423012202 B 0 1 5 .11987 39 ? 2010-09-02 2010-09-27 2010-08-25 0 2010-08-25 ? 0 0004049493 20100826.ifs 2010-08-26 2010-08-27
287157 287157 DIVIDEND ADD 423012202 B 0 1 5 .11987 39 2010-08-31 2010-09-02 2010-09-27 2010-08-25 1 2010-08-25 2010-08-26 0 0004049493 20100826.ifs 2010-08-26 2010-08-27
286059 286059 DIVIDEND ADD 423012202 B 0 1 5 .11987 39 ? 2010-09-02 2010-09-27 2010-08-25 0 2010-08-25 ? 0 0004049493 20100825.ifs 2010-08-25 2010-08-26
177567 177567 DIVIDEND DELETE 423012202 B 1 0 .20483 02 2010-04-21 2010-04-23 2010-05-20 ? 0 2010-04-30 ? 0 0003971925 20100503.ifs 2010-05-03 2010-05-04
177568 177568 DIVIDEND ADD 423012202 B 0 1 0 .20483 0 02 2010-04-21 2010-04-23 2010-05-20 2010-02-26 0 ? 2010-05-03 0 0003971925 20100503.ifs 2010-05-03 2010-05-04
176577 176577 DIVIDEND ADD 423012202 B 1 0 .20483 02 2010-04-21 2010-04-23 2010-05-20 ? 0 2010-04-30 ? 0 0003971925 20100430.ifs 2010-04-30 2010-05-01
124177 124177 DIVIDEND DELETE 423012202 B 0 1 5 .211 39 ? 2010-04-23 2010-05-20 2010-03-01 0 2010-03-01 ? 0 0003971925 20100302.ifs 2010-03-02 2010-04-07
122795 122795 DIVIDEND ADD 423012202 B 0 1 5 .211 39 ? 2010-04-23 2010-05-20 2010-03-01 0 2010-03-01 ? 0 0003971925 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 = 142469
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