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 130739-OLD Charts Yahoo 130739-OLD Profile
  Run 130739-OLD Institutional Summary Yahoo 130739-OLD Key Statisics
  J3 Open 130739-OLD Pricing Yahoo 130739-OLD Pricing
  J3 130739-OLD Insider   J3 130739-OLD Insitutions Yahoo 130739-OLD Holders
     
  Open up Sector/Exchange Map Fidelity 130739-OLD Lookup
  Open up sec.gov For Market Ca MSN 130739-OLD 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
88102J100 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:130739
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
2988582 2988582 DIVIDEND DELETE 88102J100 0 0 6 0 .066667 54 2018-03-13 2018-03-13 2018-03-13 2018-03-12 0 2018-03-12 ? 0 0005628419 20180313.ifs 2018-03-13 2018-03-14
2988584 2988584 DIVIDEND ADD 88102J100 0 0 6 0 .066667 0 54 2018-03-13 2018-03-13 2018-03-13 2018-03-13 0 ? 2018-03-13 0 0005628419 20180313.ifs 2018-03-13 2018-03-14
2988595 2988595 CORPACTION ADD 88102J100 66 Q 2018-03-13 88102J209 66 2018-03-13 20180313.ifs 2018-03-13 2018-03-14
2988597 2988597 EQUITY CHANGE 88102J100 COM 0 0 2012-02-13 ? 0 no no no 2012-02-13 2014-01-23 ? 20180313.ifs 2018-03-13 2018-03-14
2988599 2988598 EQUITY CHANGE 88102J100 COM Q 0 2012-02-13 2018-03-13 0 no no 88102J209 no 2012-02-13 2018-03-13 ? 20180313.ifs 2018-03-13 2018-03-14
2988601 2988601 SPLIT DELETE 88102J100 15 2018-03-13 54 2018-03-12 ? 20180313.ifs 2018-03-13 2018-03-14
2988606 2988606 DIVIDEND DELETE 88102J100 0 0 6 0 .066667 0 54 2018-03-13 2018-03-13 2018-03-13 2018-03-13 0 ? 2018-03-13 0 0005628419 20180313.ifs 2018-03-13 2018-03-14
2988647 2988647 DIVIDEND DELETE 88102J100 0 0 6 0 .066667 54 2018-03-13 2018-03-13 2018-03-13 2018-03-12 0 2018-03-12 ? 0 0005628419 20180313.ifs 2018-03-13 2018-03-14
2988649 2988649 DIVIDEND ADD 88102J100 0 0 6 0 .066667 0 54 2018-03-13 2018-03-13 2018-03-13 2018-03-13 0 ? 2018-03-13 0 0005628419 20180313.ifs 2018-03-13 2018-03-14
2988659 2988659 CORPACTION ADD 88102J100 66 Q 2018-03-13 88102J209 66 2018-03-13 20180313.ifs 2018-03-13 2018-03-14
2988661 2988661 EQUITY CHANGE 88102J100 COM 0 0 2012-02-13 ? 0 no no no 2012-02-13 2014-01-23 ? 20180313.ifs 2018-03-13 2018-03-14
2988663 2988662 EQUITY CHANGE 88102J100 COM Q 0 2012-02-13 2018-03-13 0 no no 88102J209 no 2012-02-13 2018-03-13 ? 20180313.ifs 2018-03-13 2018-03-14
2988665 2988665 SPLIT DELETE 88102J100 15 2018-03-13 54 2018-03-12 ? 20180313.ifs 2018-03-13 2018-03-14
2988669 2988669 DIVIDEND DELETE 88102J100 0 0 6 0 .066667 0 54 2018-03-13 2018-03-13 2018-03-13 2018-03-13 0 ? 2018-03-13 0 0005628419 20180313.ifs 2018-03-13 2018-03-14
2988029 2988029 DIVIDEND ADD 88102J100 0 0 6 0 .066667 54 2018-03-13 2018-03-13 2018-03-13 2018-03-12 0 2018-03-12 ? 0 0005628419 20180312.ifs 2018-03-12 2018-03-13
2988031 2988031 SPLIT ADD 88102J100 15 2018-03-13 54 2018-03-12 ? 20180312.ifs 2018-03-12 2018-03-13
2988117 2988117 DIVIDEND ADD 88102J100 0 0 6 0 .066667 54 2018-03-13 2018-03-13 2018-03-13 2018-03-12 0 2018-03-12 ? 0 0005628419 20180312.ifs 2018-03-12 2018-03-13
2988119 2988119 SPLIT ADD 88102J100 15 2018-03-13 54 2018-03-12 ? 20180312.ifs 2018-03-12 2018-03-13
1425930 1425930 EQUITY CHANGE 88102J100 COM N 0 2012-02-13 ? 0 no no no 2012-02-13 ? ? 20140123.ifs 2014-01-23 2014-01-24
1425931 1425930 EQUITY CHANGE 88102J100 COM 0 0 2012-02-13 ? 0 no no no 2012-02-13 2014-01-23 ? 20140123.ifs 2014-01-23 2014-01-24
1425394 1425394 CORPACTION ADD 88102J100 65 X 2014-01-22 88102J100 66 ? 20140122.ifs 2014-01-22 2014-01-23
1425395 1425395 EXCHANGE ADD 88102J100 66 2014-01-22 ? TRTC 0 0 2014-01-22 ? 20140122.ifs 2014-01-22 2014-01-23
1156422 1156422 CORPACTION DELETE 88102J100 65 # 2013-04-03 88102J100 65 ? 20130408.ifs 2013-04-08 2013-04-09
1156424 1156423 CORPACTION DELETE 88102J100 65 2013-04-03 TRTC TERRA TECH CORP COM TRTCE TERRA TECH CORP COM 2013-04-03 ? 20130408.ifs 2013-04-08 2013-04-09
1156425 1156425 CORPACTION DELETE 88102J100 65 # 2013-04-04 88102J100 65 ? 20130408.ifs 2013-04-08 2013-04-09
1156427 1156426 CORPACTION DELETE 88102J100 65 2013-04-04 TRTC TERRA TECH CORP COM TRTCE TERRA TECH CORP COM 2013-04-04 ? 20130408.ifs 2013-04-08 2013-04-09
1156428 1156428 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-04-05 TRTCE 0 0 2012-02-13 2013-04-04 20130408.ifs 2013-04-08 2013-04-09
1156429 1156428 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-04-05 TRTC 0 0 2012-02-13 2013-04-08 20130408.ifs 2013-04-08 2013-04-09
1155259 1155259 CORPACTION ADD 88102J100 65 # 2013-04-04 88102J100 65 ? 20130404.ifs 2013-04-04 2013-04-05
1155260 1155260 CORPACTIONAUX ADD 88102J100 65 2013-04-04 TRTC TERRA TECH CORP COM TRTCE TERRA TECH CORP COM 2013-04-04 ? 20130404.ifs 2013-04-04 2013-04-05
1155261 1155261 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-04-03 TRTCE 0 0 2012-02-13 2013-04-03 20130404.ifs 2013-04-04 2013-04-05
1155262 1155261 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-04-03 TRTCE 0 0 2012-02-13 2013-04-04 20130404.ifs 2013-04-04 2013-04-05
1153886 1153886 CORPACTION ADD 88102J100 65 # 2013-04-03 88102J100 65 ? 20130403.ifs 2013-04-03 2013-04-04
1153887 1153887 CORPACTIONAUX ADD 88102J100 65 2013-04-03 TRTC TERRA TECH CORP COM TRTCE TERRA TECH CORP COM 2013-04-03 ? 20130403.ifs 2013-04-03 2013-04-04
1153888 1153888 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-04-02 TRTC 0 0 2012-02-13 2013-01-08 20130403.ifs 2013-04-03 2013-04-04
1153889 1153888 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-04-02 TRTCE 0 0 2012-02-13 2013-04-03 20130403.ifs 2013-04-03 2013-04-04
1085733 1085733 CORPACTION ADD 88102J100 65 # 2013-01-08 88102J100 65 ? 20130108.ifs 2013-01-08 2013-01-09
1085734 1085734 CORPACTIONAUX ADD 88102J100 65 2013-01-08 TRTCE TERRA TECH CORP COM TRTC TERRA TECH CORP COM 2013-01-08 ? 20130108.ifs 2013-01-08 2013-01-09
1085735 1085735 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-01-07 TRTCE 0 0 2012-02-13 2013-01-07 20130108.ifs 2013-01-08 2013-01-09
1085736 1085735 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-01-07 TRTC 0 0 2012-02-13 2013-01-08 20130108.ifs 2013-01-08 2013-01-09
1084940 1084940 CORPACTION ADD 88102J100 65 # 2013-01-07 88102J100 65 ? 20130107.ifs 2013-01-07 2013-01-08
1084941 1084941 CORPACTIONAUX ADD 88102J100 65 2013-01-07 TRTC TERRA TECH CORP COM TRTCE TERRA TECH CORP COM 2013-01-07 ? 20130107.ifs 2013-01-07 2013-01-08
1084942 1084942 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-01-04 TRTC 0 0 2012-02-13 ? 20130107.ifs 2013-01-07 2013-01-08
1084943 1084942 EXCHANGE CHANGE 88102J100 65 2012-02-13 2013-01-04 TRTCE 0 0 2012-02-13 2013-01-07 20130107.ifs 2013-01-07 2013-01-08
778378 778378 EQUITY ADD 88102J100 COM N 0 2012-02-13 ? 0 no no no 2012-02-13 ? ? 20120213.ifs 2012-02-13 2012-02-14
778382 778382 EXCHANGE ADD 88102J100 65 2012-02-13 ? TRTC 0 0 2012-02-13 ? 20120213.ifs 2012-02-13 2012-02-14


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