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 MSY Charts Yahoo MSY Profile
  Run MSY Institutional Summary Yahoo MSY Key Statisics
  J3 Open MSY Pricing Yahoo MSY Pricing
  J3 MSY Insider   J3 MSY Insitutions Yahoo MSY Holders
     
  Open up Sector/Exchange Map Fidelity MSY Lookup
  Open up sec.gov For Market Ca MSN MSY 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:130770
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
938652 938652 CORPACTION ADD 46133K108 01 M 2012-08-27 46131F101 01 ? 20120827.ifs 2012-08-27 2012-08-28
938653 938653 EQUITY CHANGE 46133K108 COM 0 7 2010-06-01 ? 0 no no no 2010-06-01 2010-06-01 ? 20120827.ifs 2012-08-27 2012-08-28
938654 938653 EQUITY CHANGE 46133K108 COM M 7 2010-06-01 2012-08-27 0 no no 46131F101 no 2010-06-01 2012-08-27 ? 20120827.ifs 2012-08-27 2012-08-28
939009 939009 DIVIDEND CHANGE 46133K108 0 0 1 0 .1258 00 2012-08-22 2012-08-24 2012-08-31 2012-08-20 1 2012-08-20 2012-08-21 0 0004417113 20120827.ifs 2012-08-27 2012-08-28
939010 939009 DIVIDEND CHANGE 46133K108 0 0 1 0 .1258 00 2012-08-22 2012-08-24 2012-08-31 2012-08-20 2 2012-08-20 2012-08-27 0 0004417113 20120827.ifs 2012-08-27 2012-08-28
936543 936543 DIVIDEND CHANGE 46133K108 0 0 1 0 .1258 00 2012-08-22 2012-08-24 2012-08-31 2012-08-20 0 2012-08-20 ? 0 0004417113 20120821.ifs 2012-08-21 2012-08-22
936544 936543 DIVIDEND CHANGE 46133K108 0 0 1 0 .1258 00 2012-08-22 2012-08-24 2012-08-31 2012-08-20 1 2012-08-20 2012-08-21 0 0004417113 20120821.ifs 2012-08-21 2012-08-22
935809 935809 DIVIDEND ADD 46133K108 0 0 1 0 .1258 00 2012-08-22 2012-08-24 2012-08-31 2012-08-20 0 2012-08-20 ? 0 0004417113 20120820.ifs 2012-08-20 2012-08-21
904502 904502 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-07-12 2012-07-16 2012-07-31 2012-07-02 0 2012-07-02 ? 0 0004398915 20120702.ifs 2012-07-02 2012-07-03
876035 876035 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-06-13 2012-06-15 2012-06-29 2012-06-01 0 2012-06-01 ? 0 0004382091 20120601.ifs 2012-06-01 2012-06-02
851367 851367 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-05-11 2012-05-15 2012-05-31 2012-05-01 0 2012-05-01 ? 0 0004370182 20120501.ifs 2012-05-01 2012-05-02
825406 825406 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-04-11 2012-04-13 2012-04-30 2012-04-02 0 2012-04-02 ? 0 0004356295 20120402.ifs 2012-04-02 2012-04-03
793743 793743 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-03-12 2012-03-14 2012-03-30 2012-03-01 0 2012-03-01 ? 0 0004340770 20120301.ifs 2012-03-01 2012-03-02
771159 771159 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-02-13 2012-02-15 2012-02-29 2012-02-01 0 2012-02-01 ? 0 0004328708 20120201.ifs 2012-02-01 2012-02-02
747404 747404 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2012-01-12 2012-01-17 2012-01-31 2012-01-03 0 2012-01-03 ? 0 0004314693 20120103.ifs 2012-01-03 2012-01-04
708653 708653 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-12-13 2011-12-15 2011-12-30 2011-12-01 0 2011-12-01 ? 0 0004278983 20111201.ifs 2011-12-01 2011-12-02
686681 686681 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-11-14 2011-11-16 2011-11-30 2011-11-01 0 2011-11-01 ? 0 0004265550 20111101.ifs 2011-11-01 2011-11-02
659959 659959 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-10-12 2011-10-14 2011-10-31 2011-09-30 0 2011-09-30 ? 0 0004249039 20110930.ifs 2011-09-30 2011-10-01
633925 633925 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-09-13 2011-09-15 2011-09-30 2011-09-01 0 2011-09-01 ? 0 0004237917 20110901.ifs 2011-09-01 2011-09-02
601263 601263 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-08-11 2011-08-15 2011-08-31 2011-08-01 0 2011-08-01 ? 0 0004225226 20110801.ifs 2011-08-01 2011-08-02
580375 580375 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-07-13 2011-07-15 2011-07-29 2011-07-01 0 2011-07-01 ? 0 0004211743 20110701.ifs 2011-07-01 2011-07-02
543818 543818 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-06-13 2011-06-15 2011-06-30 2011-06-01 0 2011-06-01 ? 0 0004195894 20110601.ifs 2011-06-01 2011-06-02
516628 516628 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-05-11 2011-05-13 2011-05-31 2011-05-02 0 2011-05-02 ? 0 0004182768 20110502.ifs 2011-05-02 2011-05-03
491851 491851 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-04-13 2011-04-15 2011-04-29 2011-04-01 0 2011-04-01 ? 0 0004170686 20110401.ifs 2011-04-01 2011-04-02
460080 460080 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-03-11 2011-03-15 2011-03-31 2011-03-01 0 2011-03-01 ? 0 0004154697 20110301.ifs 2011-03-01 2011-03-02
433750 433750 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-02-11 2011-02-15 2011-02-28 2011-02-01 0 2011-02-01 ? 0 0004142411 20110201.ifs 2011-02-01 2011-02-02
410037 410037 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2011-01-12 2011-01-14 2011-01-31 2011-01-03 0 2011-01-03 ? 0 0004130172 20110103.ifs 2011-01-03 2011-01-04
358718 358718 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2010-11-26 2010-11-30 2010-12-15 2010-11-19 0 2010-11-19 ? 0 0004088801 20101119.ifs 2010-11-19 2010-11-20
337537 337537 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2010-10-27 2010-10-29 2010-11-15 2010-10-19 0 2010-10-19 ? 0 0004075443 20101019.ifs 2010-10-19 2010-10-20
310822 310822 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2010-09-28 2010-09-30 2010-10-15 2010-09-20 0 2010-09-20 ? 0 0004061644 20100920.ifs 2010-09-20 2010-09-21
282151 282151 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2010-08-27 2010-08-31 2010-09-15 2010-08-20 0 2010-08-20 ? 0 0004048396 20100820.ifs 2010-08-20 2010-08-21
255592 255592 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2010-07-28 2010-07-30 2010-08-13 2010-07-20 0 2010-07-20 ? 0 0004034930 20100720.ifs 2010-07-20 2010-07-21
222886 222886 DIVIDEND ADD 46133K108 0 0 1 0 .045 00 2010-06-28 2010-06-30 2010-07-15 2010-06-18 0 2010-06-18 ? 0 0004019897 20100618.ifs 2010-06-18 2010-06-19
204949 204949 EQUITY ADD 46133K108 COM N 0 2010-06-01 ? 0 no no no 2010-06-01 ? ? 20100601.ifs 2010-06-01 2010-06-02
204953 204953 EXCHANGE ADD 46133K108 01 2010-06-01 2010-06-01 MSY 0 7 2010-06-01 ? 20100601.ifs 2010-06-01 2010-06-02
206438 206438 EQUITY CHANGE 46133K108 COM N 0 2010-06-01 ? 0 no no no 2010-06-01 ? ? 20100601.ifs 2010-06-01 2010-06-02
206439 206438 EQUITY CHANGE 46133K108 COM N 7 2010-06-01 ? 0 no no no 2010-06-01 2010-06-01 ? 20100601.ifs 2010-06-01 2010-06-02
209788 209788 EQUITY CHANGE 46133K108 COM N 7 2010-06-01 ? 0 no no no 2010-06-01 2010-06-01 ? 20100601.ifs 2010-06-01 2010-06-02
209789 209788 EQUITY CHANGE 46133K108 COM 0 7 2010-06-01 ? 0 no no no 2010-06-01 2010-06-01 ? 20100601.ifs 2010-06-01 2010-06-02


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