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 GMSPZ Charts Yahoo GMSPZ Profile
  Run GMSPZ Institutional Summary Yahoo GMSPZ Key Statisics
  J3 Open GMSPZ Pricing Yahoo GMSPZ Pricing
  J3 GMSPZ Insider   J3 GMSPZ Insitutions Yahoo GMSPZ Holders
     
  Open up Sector/Exchange Map Fidelity GMSPZ Lookup
  Open up sec.gov For Market Ca MSN GMSPZ 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
36186R209 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:159747
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
777003 777003 CORPACTION ADD 36186R209 66 Q 2012-02-09 02005N605 66 2012-02-09 20120209.ifs 2012-02-09 2012-02-10
777004 777004 EQUITY CHANGE 36186R209 PERP PFD SER G 7% 144A 0 1 2010-07-29 ? 0 no no no ? 2012-02-08 ? 20120209.ifs 2012-02-09 2012-02-10
777005 777004 EQUITY CHANGE 36186R209 PERP PFD SER G 7% 144A Q 1 2010-07-29 2012-02-09 0 no no 02005N605 no ? 2012-02-09 ? 20120209.ifs 2012-02-09 2012-02-10
777006 777006 EXCHANGE CHANGE 36186R209 66 2010-08-02 2010-10-14 GMSPZ 0 1 2010-08-02 ? 20120209.ifs 2012-02-09 2012-02-10
777007 777006 EXCHANGE CHANGE 36186R209 66 2010-08-02 2012-02-08 GMSPZ 0 1 2010-08-02 2012-02-09 20120209.ifs 2012-02-09 2012-02-10
775908 775908 EQUITY CHANGE 36186R209 PERP PFD SER G 7% 144A N 1 2010-07-29 ? 0 no no no ? ? ? 20120208.ifs 2012-02-08 2012-02-09
775909 775908 EQUITY CHANGE 36186R209 PERP PFD SER G 7% 144A 0 1 2010-07-29 ? 0 no no no ? 2012-02-08 ? 20120208.ifs 2012-02-08 2012-02-09
756796 756796 DIVIDEND ADD 36186R209 0 0 1 0 17.5 00 ? 2012-02-01 2012-02-15 2012-01-04 0 2012-01-13 ? 0 0004320714 20120113.ifs 2012-01-13 2012-01-14
670884 670884 DIVIDEND ADD 36186R209 0 0 1 0 17.5 00 ? 2011-11-01 2011-11-15 2011-10-06 0 2011-10-11 ? 0 0004256752 20111011.ifs 2011-10-11 2011-10-12
593163 593163 DIVIDEND ADD 36186R209 0 0 1 0 17.31 00 ? 2011-08-01 2011-08-15 2011-07-18 0 2011-07-26 ? 0 0004219432 20110726.ifs 2011-07-26 2011-07-27
507044 507044 DIVIDEND ADD 36186R209 0 0 1 0 17.69 00 ? 2011-05-02 2011-05-16 2011-04-18 0 2011-04-21 ? 0 0004177010 20110421.ifs 2011-04-21 2011-04-22
419015 419015 DIVIDEND ADD 36186R209 0 0 1 0 17.5 00 ? 2011-02-01 2011-02-15 2011-01-14 0 2011-01-14 ? 0 0004135031 20110114.ifs 2011-01-14 2011-01-15
337553 337553 DIVIDEND ADD 36186R209 0 0 1 0 17.31 00 ? 2010-11-01 2010-11-15 2010-10-01 0 2010-10-19 ? 0 0004075405 20101019.ifs 2010-10-19 2010-10-20
266742 266742 EXCHANGE ADD 36186R209 66 2010-08-02 ? GMSPZ 0 1 2010-08-02 ? 20100802.ifs 2010-08-02 2010-08-03
262924 262924 EQUITY ADD 36186R209 PERP PFD SER G 7% 144A N 1 2010-07-29 ? 0 no no no ? ? ? 20100729.ifs 2010-07-29 2010-07-30
262925 262925 DIVIDEND ADD 36186R209 0 0 1 4 17.89 00 ? 2010-05-03 2010-05-17 2010-03-25 0 2010-07-29 ? 1 0004037756 20100729.ifs 2010-07-29 2010-07-30
262926 262926 DIVIDEND ADD 36186R209 0 0 1 0 17.31 00 ? 2010-02-01 2010-02-15 2010-01-08 0 2010-07-29 ? 0 0004037755 20100729.ifs 2010-07-29 2010-07-30
262927 262927 DIVIDEND ADD 36186R209 0 0 1 0 17.31 00 ? 2010-08-02 2010-08-16 2010-07-14 0 2010-07-29 ? 2 0004037754 20100729.ifs 2010-07-29 2010-07-30


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