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 TTFS Charts Yahoo TTFS Profile
  Run TTFS Institutional Summary Yahoo TTFS Key Statisics
  J3 Open TTFS Pricing Yahoo TTFS Pricing
  J3 TTFS Insider   J3 TTFS Insitutions Yahoo TTFS Holders
     
  Open up Sector/Exchange Map Fidelity TTFS Lookup
  Open up sec.gov For Market Ca MSN TTFS 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 : 24 22   Update Insititution By Cusips
% Owned by Insititutions: 5.48 % 7.33 %
pricingQuarterAdminPageOn:
2024-03-31 New %
Delete Company From Institution Summary
Change Institution Stuff 'ZERO' for Cusip

the compid is:160386
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
5460700 5460700 DIVIDEND ADD 00768Y818 0 0 1 0 1.1598 00 2023-12-26 2023-12-27 2023-12-29 2023-12-22 0 2023-12-22 ? 0 0006848607 20231222.ifs 2023-12-22 2023-12-23
5187695 5187695 DIVIDEND ADD 00768Y818 0 0 1 0 1.47594 00 2022-12-23 2022-12-27 2022-12-30 2022-12-22 0 2022-12-22 ? 0 0006650710 20221222.ifs 2022-12-22 2022-12-23
5087753 5087753 CORPACTION ADD 00768Y818 04 # 2022-09-01 00768Y818 04 ? 20220901.ifs 2022-09-01 2022-09-02
5087754 5087754 CORPACTIONAUX ADD 00768Y818 04 2022-09-01 DBLV ADVISORSHARES TR DOUBLELINE VALU SURE ADVISORSHARES TR DOUBLELINE VALU 2022-09-01 ? 20220901.ifs 2022-09-01 2022-09-02
5087755 5087755 EXCHANGE CHANGE 00768Y818 04 2011-10-05 2018-10-10 DBLV 0 A 2011-10-05 2018-10-11 20220901.ifs 2022-09-01 2022-09-02
5087756 5087755 EXCHANGE CHANGE 00768Y818 04 2011-10-05 2018-10-10 SURE 0 A 2011-10-05 2022-09-01 20220901.ifs 2022-09-01 2022-09-02
5087757 5087757 EXCHANGE CHANGE 00768Y818 04 2018-10-11 2022-08-31 DBLV 0 A ? 2018-10-11 20220901.ifs 2022-09-01 2022-09-02
5087758 5087757 EXCHANGE CHANGE 00768Y818 04 2018-10-11 2022-08-31 SURE 0 A ? 2022-09-01 20220901.ifs 2022-09-01 2022-09-02
4910118 4910118 DIVIDEND ADD 00768Y818 0 0 1 0 1.06247 00 2021-12-23 2021-12-27 2021-12-31 2021-12-22 0 2021-12-22 ? 0 0006446212 20211222.ifs 2021-12-22 2021-12-23
4573567 4573567 DIVIDEND ADD 00768Y818 0 0 1 0 1.02479 00 2020-12-24 2020-12-28 2020-12-31 2020-12-23 0 2020-12-23 ? 0 0006232688 20201223.ifs 2020-12-23 2020-12-24
4123484 4123484 DIVIDEND ADD 00768Y818 0 0 1 0 .81532 00 2019-12-27 2019-12-30 2019-12-31 2019-12-26 0 2019-12-26 ? 0 0006024281 20191226.ifs 2019-12-26 2019-12-27
4123501 4123501 DIVIDEND ADD 00768Y818 0 0 1 0 .81532 00 2019-12-27 2019-12-30 2019-12-31 2019-12-26 0 2019-12-26 ? 0 0006024281 20191226.ifs 2019-12-26 2019-12-27
3498945 3498945 DIVIDEND ADD 00768Y818 0 0 1 0 .73856 00 2018-12-27 2018-12-28 2018-12-31 2018-12-26 0 2018-12-26 ? 0 0005805805 20181226.ifs 2018-12-26 2018-12-27
3498959 3498959 DIVIDEND ADD 00768Y818 0 0 1 0 .73856 00 2018-12-27 2018-12-28 2018-12-31 2018-12-26 0 2018-12-26 ? 0 0005805805 20181226.ifs 2018-12-26 2018-12-27
3328122 3328122 CORPACTION ADD 00768Y818 04 # 2018-10-11 00768Y818 04 ? 20181011.ifs 2018-10-11 2018-10-12
3328124 3328124 CORPACTIONAUX ADD 00768Y818 04 2018-10-11 DBLV ADVISORSHARES TR ADVISORSHARES T DBLV ADVISORSHARES TR DOUBLELINE VALU 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328126 3328126 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2016-07-01 ? 20181011.ifs 2018-10-11 2018-10-12
3328127 3328126 EQUITY CHANGE 00768Y818 DOUBLELINE VALUE EQUITY ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328227 3328227 CORPACTION ADD 00768Y818 04 # 2018-10-11 00768Y818 04 ? 20181011.ifs 2018-10-11 2018-10-12
3328229 3328229 CORPACTIONAUX ADD 00768Y818 04 2018-10-11 DBLV ADVISORSHARES TR ADVISORSHARES T DBLV ADVISORSHARES TR DOUBLELINE VALU 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328230 3328230 EQUITY CHANGE 00768Y818 DOUBLELINE VALUE EQUITY ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328231 3328231 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2016-07-01 ? 20181011.ifs 2018-10-11 2018-10-12
3328232 3328231 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328233 3328232 EQUITY CHANGE 00768Y818 DOUBLELINE VALUE EQUITY ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328234 3328234 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328235 3328234 EQUITY CHANGE 00768Y818 DOUBLELINE VALUE EQUITY ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328237 3328237 EXCHANGE ADD 00768Y818 04 2018-10-11 2018-10-11 DBLV 0 A ? 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328241 3328240 EXCHANGE ADD 00768Y818 04 # 2018-10-11 00768Y818 04 ? 20181011.ifs 2018-10-11 2018-10-12
3328243 3328242 EXCHANGE ADD 00768Y818 04 # 2018-10-11 00768Y818 04 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328246 3328245 EXCHANGE ADD 00768Y818 04 2018-10-11 DBLV ADVISORSHARES TR ADVISORSHARES T DBLV ADVISORSHARES TR DOUBLELINE VALU 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328248 3328247 EXCHANGE ADD 00768Y818 04 2018-10-11 TTFS ADVISORSHARES TR WILSHIRE BUYBAC DBLV ADVISORSHARES TR DOUBLELINE VALU 2018-10-11 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328250 3328250 EXCHANGE CHANGE 00768Y818 04 2011-10-05 2018-10-10 TTFS 0 A 2011-10-05 ? 20181011.ifs 2018-10-11 2018-10-12
3328252 3328251 EXCHANGE CHANGE 00768Y818 04 2011-10-05 2018-10-10 DBLV 0 A 2011-10-05 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328254 3328254 EXCHANGE CHANGE 00768Y818 04 2018-10-11 2018-10-11 DBLV 0 A ? 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328256 3328255 EXCHANGE CHANGE 00768Y818 04 2018-10-11 2018-10-11 DBLV 0 A ? 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328347 3328347 EQUITY CHANGE 00768Y818 DOUBLELINE VALUE EQUITY ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328349 3328348 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328351 3328351 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328353 3328352 EQUITY CHANGE 00768Y818 DOUBLELINE VALUE EQUITY ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328355 3328355 EXCHANGE ADD 00768Y818 04 2018-10-11 2018-10-11 DBLV 0 A ? 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328358 3328357 EXCHANGE ADD 00768Y818 04 # 2018-10-11 00768Y818 04 ? 20181011.ifs 2018-10-11 2018-10-12
3328360 3328359 EXCHANGE ADD 00768Y818 04 # 2018-10-11 00768Y818 04 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328364 3328363 EXCHANGE ADD 00768Y818 04 2018-10-11 DBLV ADVISORSHARES TR ADVISORSHARES T DBLV ADVISORSHARES TR DOUBLELINE VALU 2018-10-11 ? 20181011.ifs 2018-10-11 2018-10-12
3328366 3328365 EXCHANGE ADD 00768Y818 04 2018-10-11 TTFS ADVISORSHARES TR WILSHIRE BUYBAC DBLV ADVISORSHARES TR DOUBLELINE VALU 2018-10-11 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328368 3328368 EXCHANGE CHANGE 00768Y818 04 2011-10-05 2018-10-10 TTFS 0 A 2011-10-05 ? 20181011.ifs 2018-10-11 2018-10-12
3328370 3328369 EXCHANGE CHANGE 00768Y818 04 2011-10-05 2018-10-10 DBLV 0 A 2011-10-05 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328372 3328372 EXCHANGE CHANGE 00768Y818 04 2018-10-11 2018-10-11 DBLV 0 A ? 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
3328374 3328373 EXCHANGE CHANGE 00768Y818 04 2018-10-11 2018-10-11 DBLV 0 A ? 2018-10-11 20181011.ifs 2018-10-11 2018-10-12
2870793 2870793 DIVIDEND ADD 00768Y818 0 0 1 0 .46596 00 2017-12-27 2017-12-28 2017-12-29 2017-12-26 0 2017-12-26 ? 0 0005580740 20171226.ifs 2017-12-26 2017-12-27
2456481 2456481 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 0 no no no 2011-10-05 2016-07-01 ? 20170126.ifs 2017-01-26 2017-01-27
2456482 2456481 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 1 no no no 2011-10-05 2016-07-01 ? 20170126.ifs 2017-01-26 2017-01-27
2395714 2395714 DIVIDEND ADD 00768Y818 0 0 1 0 .72534 00 2016-12-23 2016-12-28 2016-12-30 2016-12-22 0 2016-12-22 ? 0 0005352616 20161222.ifs 2016-12-22 2016-12-23
2240449 2240449 CORPACTION ADD 00768Y818 04 # 2016-07-01 00768Y818 04 ? 20160701.ifs 2016-07-01 2016-07-02
2240450 2240450 CORPACTIONAUX ADD 00768Y818 04 2016-07-01 TTFS ADVISORSHARES TR ADVISORSHARES T TTFS ADVISORSHARES TR WILSHIRE BUYBAC 2016-07-01 ? 20160701.ifs 2016-07-01 2016-07-02
2240451 2240451 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF 0 A 2011-10-05 ? 0 no no no 2011-10-05 2011-10-05 ? 20160701.ifs 2016-07-01 2016-07-02
2240452 2240451 EQUITY CHANGE 00768Y818 WILSHIRE BUYBACK ETF 0 A 2011-10-05 ? 0 no no no 2011-10-05 2016-07-01 ? 20160701.ifs 2016-07-01 2016-07-02
2064510 2064510 DIVIDEND ADD 00768Y818 0 0 1 0 .41863 00 2015-12-24 2015-12-29 2015-12-31 2015-12-23 0 2015-12-23 ? 0 0005138658 20151223.ifs 2015-12-23 2015-12-24
1741681 1741681 DIVIDEND ADD 00768Y818 0 0 1 0 .33741 00 2014-12-24 2014-12-29 2014-12-31 2014-12-23 0 2014-12-23 ? 0 0004919251 20141223.ifs 2014-12-23 2014-12-24
1394217 1394217 DIVIDEND ADD 00768Y818 0 0 1 0 .15413 00 2013-12-24 2013-12-27 2013-12-31 2013-12-23 0 2013-12-23 ? 0 0004702649 20131223.ifs 2013-12-23 2013-12-24
1058150 1058150 DIVIDEND ADD 00768Y818 0 0 1 0 .33642 00 2012-12-24 2012-12-27 2012-12-31 2012-12-21 0 2012-12-21 ? 0 0004492637 20121221.ifs 2012-12-21 2012-12-22
667769 667769 EQUITY ADD 00768Y818 TRIMTABS FLOAT SHRINK ETF N 7 2011-10-05 ? 0 no no no 2011-10-05 ? ? 20111005.ifs 2011-10-05 2011-10-06
667770 667770 EXCHANGE ADD 00768Y818 04 2011-10-05 2011-10-05 TTFS 0 A 2011-10-05 ? 20111005.ifs 2011-10-05 2011-10-06
668098 668098 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF N 7 2011-10-05 ? 0 no no no 2011-10-05 ? ? 20111005.ifs 2011-10-05 2011-10-06
668099 668098 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF N 0 2011-10-05 ? 0 no no no 2011-10-05 2011-10-05 ? 20111005.ifs 2011-10-05 2011-10-06
668100 668100 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF N 0 2011-10-05 ? 0 no no no 2011-10-05 2011-10-05 ? 20111005.ifs 2011-10-05 2011-10-06
668101 668100 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF N A 2011-10-05 ? 0 no no no 2011-10-05 2011-10-05 ? 20111005.ifs 2011-10-05 2011-10-06
668150 668150 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF N A 2011-10-05 ? 0 no no no 2011-10-05 2011-10-05 ? 20111005.ifs 2011-10-05 2011-10-06
668151 668150 EQUITY CHANGE 00768Y818 TRIMTABS FLOAT SHRINK ETF 0 A 2011-10-05 ? 0 no no no 2011-10-05 2011-10-05 ? 20111005.ifs 2011-10-05 2011-10-06


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