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 GUA Charts Yahoo GUA Profile
  Run GUA Institutional Summary Yahoo GUA Key Statisics
  J3 Open GUA Pricing Yahoo GUA Pricing
  J3 GUA Insider   J3 GUA Insitutions Yahoo GUA Holders
     
  Open up Sector/Exchange Map Fidelity GUA Lookup
  Open up sec.gov For Market Ca MSN GUA 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
402479745 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:159752
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
2198591 2198591 CORPACTION ADD 402479745 01 C 2016-05-18 ? 20160518.ifs 2016-05-18 2016-05-19
2198592 2198592 EQUITY CHANGE 402479745 SR NT SER 2011A 0 0 2011-05-23 ? 0 no no no 2011-05-23 2012-08-08 ? 20160518.ifs 2016-05-18 2016-05-19
2198593 2198592 EQUITY CHANGE 402479745 SR NT SER 2011A C 0 2011-05-23 2016-05-18 0 no no no 2011-05-23 2016-05-18 ? 20160518.ifs 2016-05-18 2016-05-19
2167791 2167791 DIVIDEND DELETE 402479745 0 0 1 0 .359375 00 2016-05-13 2016-05-17 2016-06-01 2016-03-29 1 2016-03-29 2016-04-18 0 0005192873 20160420.ifs 2016-04-20 2016-04-21
2167792 2167792 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 ? ? 2016-05-18 2016-03-29 2 2016-03-29 2016-04-20 0 0005192873 20160420.ifs 2016-04-20 2016-04-21
2166467 2166467 DIVIDEND ADD 402479745 0 0 C 0 25 12 ? ? 2016-05-18 2016-04-18 0 ? 2016-04-19 0 20160419.ifs 2016-04-19 2016-04-20
2166304 2166304 DIVIDEND CHANGE 402479745 0 0 1 0 .359375 00 2016-05-13 2016-05-17 2016-06-01 2016-03-29 0 2016-03-29 ? 0 0005192873 20160418.ifs 2016-04-18 2016-04-19
2166305 2166304 DIVIDEND CHANGE 402479745 0 0 1 0 .359375 00 2016-05-13 2016-05-17 2016-06-01 2016-03-29 1 2016-03-29 2016-04-18 0 0005192873 20160418.ifs 2016-04-18 2016-04-19
2145237 2145237 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2016-05-13 2016-05-17 2016-06-01 2016-03-29 0 2016-03-29 ? 0 0005192873 20160329.ifs 2016-03-29 2016-03-30
2012024 2012024 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2016-02-10 2016-02-15 2016-03-01 2015-11-19 0 2015-11-19 ? 0 0005094676 20151119.ifs 2015-11-19 2015-11-20
1987780 1987780 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2015-11-12 2015-11-16 2015-12-01 2015-10-07 0 2015-10-07 ? 0 0005078695 20151007.ifs 2015-10-07 2015-10-08
1924296 1924296 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2015-08-13 2015-08-17 2015-09-01 2015-07-27 0 2015-07-28 ? 0 0005035946 20150728.ifs 2015-07-28 2015-07-29
1810875 1810875 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2015-05-13 2015-05-17 2015-06-01 2015-03-11 0 2015-03-12 ? 0 0004967668 20150312.ifs 2015-03-12 2015-03-13
1766075 1766075 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2015-02-11 2015-02-14 2015-03-02 2015-01-07 0 2015-01-07 ? 0 0004940763 20150107.ifs 2015-01-07 2015-01-08
1605140 1605140 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2014-11-12 2014-11-16 2014-12-01 2014-08-12 0 2014-08-12 ? 0 0004828280 20140812.ifs 2014-08-12 2014-08-13
1543595 1543595 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2014-08-13 2014-08-15 2014-09-01 2014-05-16 0 2014-06-05 ? 0 0004794159 20140605.ifs 2014-06-05 2014-06-06
1500587 1500587 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2014-05-14 2014-05-16 2014-06-01 2014-04-22 0 2014-04-23 ? 0 0004769906 20140423.ifs 2014-04-23 2014-04-24
1427437 1427437 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2014-02-12 2014-02-14 2014-03-03 2014-01-23 0 2014-01-24 ? 0 0004725847 20140124.ifs 2014-01-24 2014-01-25
1247876 1247876 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2013-11-13 2013-11-15 2013-12-02 2013-07-25 0 2013-07-26 ? 0 0004604805 20130726.ifs 2013-07-26 2013-07-27
1219098 1219098 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2013-08-13 2013-08-15 2013-09-03 2013-06-25 0 2013-06-26 ? 0 0004589870 20130626.ifs 2013-06-26 2013-06-27
1183743 1183743 DIVIDEND DELETE 402479745 0 0 1 0 .359375 00 2013-05-13 2013-05-15 2013-06-03 2013-02-26 0 2013-02-28 ? 0 0004532773 20130510.ifs 2013-05-10 2013-05-11
1183744 1183744 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2013-05-15 2013-05-17 2013-06-03 2013-02-26 1 2013-02-28 2013-05-10 0 0004532773 20130510.ifs 2013-05-10 2013-05-11
1121482 1121482 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2013-05-13 2013-05-15 2013-06-03 2013-02-26 0 2013-02-28 ? 0 0004532773 20130228.ifs 2013-02-28 2013-03-01
1073255 1073255 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2013-02-12 2013-02-14 2013-03-01 2012-12-31 0 2013-01-02 ? 0 0004509809 20130102.ifs 2013-01-02 2013-01-03
984571 984571 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2012-11-14 2012-11-18 2012-12-03 2012-10-11 0 2012-10-11 ? 0 0004445128 20121011.ifs 2012-10-11 2012-10-12
930257 930257 EQUITY CHANGE 402479745 SR NT SER 2011A 0 0 2011-05-23 ? 0 no no no 2011-05-23 2011-05-24 ? 20120808.ifs 2012-08-08 2012-08-09
930258 930257 EQUITY CHANGE 402479745 SR NT SER 2011A 0 0 2011-05-23 ? 0 no no no 2011-05-23 2012-08-08 ? 20120808.ifs 2012-08-08 2012-08-09
930259 930259 DIVIDEND CHANGE 402479745 0 1 1 0 .359375 00 2012-02-13 2012-02-15 2012-03-01 2011-12-30 1 2011-12-30 2012-01-20 0 0004310437 20120808.ifs 2012-08-08 2012-08-09
930260 930259 DIVIDEND CHANGE 402479745 0 1 1 0 .359375 00 2012-02-13 2012-02-15 2012-03-01 2011-12-30 1 2011-12-30 2012-08-08 0 0004310437 20120808.ifs 2012-08-08 2012-08-09
930261 930261 EXCHANGE CHANGE 402479745 01 2011-05-23 2012-08-07 GUA 0 0 2011-05-23 2012-08-08 20120808.ifs 2012-08-08 2012-08-09
930262 930261 EXCHANGE CHANGE 402479745 01 2011-05-23 2012-08-07 GUA 0 0 2011-05-23 2012-08-08 20120808.ifs 2012-08-08 2012-08-09
931145 931145 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2012-08-13 2012-08-15 2012-09-04 2012-08-08 0 2012-08-08 ? 0 0004414819 20120808.ifs 2012-08-08 2012-08-09
811557 811557 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2012-05-15 2012-05-17 2012-06-01 2012-03-28 0 2012-03-28 ? 0 0004349730 20120328.ifs 2012-03-28 2012-03-29
760176 760176 DIVIDEND DELETE 402479745 0 1 1 0 .359375 14 2012-02-13 2011-02-15 2012-03-01 2011-12-30 0 2011-12-30 ? 0 0004310437 20120120.ifs 2012-01-20 2012-01-21
760177 760177 DIVIDEND ADD 402479745 0 1 1 0 .359375 00 2012-02-13 2012-02-15 2012-03-01 2011-12-30 1 2011-12-30 2012-01-20 0 0004310437 20120120.ifs 2012-01-20 2012-01-21
672228 672228 DIVIDEND ADD 402479745 0 0 1 0 .359375 00 2011-11-14 2011-11-16 2011-12-01 2011-10-13 0 2011-10-13 ? 0 0004257221 20111013.ifs 2011-10-13 2011-10-14
591880 591880 DIVIDEND ADD 402479745 0 0 1 4 .411284 00 2011-08-11 2011-08-15 2011-09-01 2011-07-22 0 2011-07-22 ? 0 0004219000 20110722.ifs 2011-07-22 2011-07-23
532862 532862 EQUITY CHANGE 402479745 COM 0 0 2011-05-23 ? 0 no no no 2011-05-23 ? ? 20110524.ifs 2011-05-24 2011-05-25
532863 532862 EQUITY CHANGE 402479745 SR NT SER 2011A 0 0 2011-05-23 ? 0 no no no 2011-05-23 2011-05-24 ? 20110524.ifs 2011-05-24 2011-05-25
532084 532084 EQUITY ADD 402479745 COM N 0 2011-05-23 ? 0 no no no 2011-05-23 ? ? 20110523.ifs 2011-05-23 2011-05-24
532085 532085 EXCHANGE ADD 402479745 01 2011-05-23 2011-05-23 GUA 0 0 2011-05-23 ? 20110523.ifs 2011-05-23 2011-05-24
532204 532204 EQUITY CHANGE 402479745 COM N 0 2011-05-23 ? 0 no no no 2011-05-23 ? ? 20110523.ifs 2011-05-23 2011-05-24
532205 532204 EQUITY CHANGE 402479745 COM 0 0 2011-05-23 ? 0 no no no 2011-05-23 ? ? 20110523.ifs 2011-05-23 2011-05-24


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