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

the compid is:130747
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
5582603 5582603 DIVIDEND ADD 74348A376 0 0 1 0 .187672 00 2024-06-26 2024-06-26 2024-07-03 2024-06-25 0 2024-06-25 ? 0 0006937571 20240625.ifs 2024-06-25 2024-06-26
5518751 5518751 DIVIDEND ADD 74348A376 0 0 1 0 .111292 00 2024-03-20 2024-03-21 2024-03-27 2024-03-19 0 2024-03-19 ? 0 0006891844 20240319.ifs 2024-03-19 2024-03-20
5449325 5449325 DIVIDEND ADD 74348A376 0 0 1 0 .273495 00 2023-12-20 2023-12-21 2023-12-28 2023-12-19 0 2023-12-19 ? 0 0006840377 20231219.ifs 2023-12-19 2023-12-20
5375862 5375862 DIVIDEND ADD 74348A376 0 0 1 0 .234446 00 2023-09-20 2023-09-21 2023-09-27 2023-09-19 0 2023-09-19 ? 0 0006784795 20230919.ifs 2023-09-19 2023-09-20
5314328 5314328 DIVIDEND ADD 74348A376 0 0 1 0 .123038 00 2023-06-21 2023-06-22 2023-06-28 2023-06-20 0 2023-06-20 ? 0 0006741203 20230620.ifs 2023-06-20 2023-06-21
5252000 5252000 DIVIDEND ADD 74348A376 0 0 1 0 .107542 00 2023-03-22 2023-03-23 2023-03-29 2023-03-21 0 2023-03-21 ? 0 0006698118 20230321.ifs 2023-03-21 2023-03-22
5182767 5182767 DIVIDEND ADD 74348A376 0 0 1 0 .05812 00 2022-12-22 2022-12-23 2022-12-30 2022-12-21 0 2022-12-21 ? 0 0006648280 20221221.ifs 2022-12-21 2022-12-22
5100330 5100330 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2022-09-28 2022-09-20 0 2022-09-20 ? 0 0006585693 20220920.ifs 2022-09-20 2022-09-21
5037081 5037081 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2022-06-29 2022-06-21 0 2022-06-21 ? 0 0006541439 20220621.ifs 2022-06-21 2022-06-22
4975204 4975204 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2022-03-30 2022-03-22 0 2022-03-22 ? 0 0006497654 20220322.ifs 2022-03-22 2022-03-23
4907710 4907710 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2021-12-31 2021-12-22 0 2021-12-22 ? 0 0006446004 20211222.ifs 2021-12-22 2021-12-23
4806408 4806408 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2021-09-29 2021-09-21 0 2021-09-21 ? 0 0006370469 20210921.ifs 2021-09-21 2021-09-22
4733921 4733921 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2021-06-29 2021-06-21 0 2021-06-21 ? 0 0006324967 20210621.ifs 2021-06-21 2021-06-22
4658662 4658662 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2021-03-30 2021-03-22 0 2021-03-22 ? 0 0006280172 20210322.ifs 2021-03-22 2021-03-23
4567329 4567329 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2020-12-31 2020-12-22 0 2020-12-22 ? 0 0006230265 20201222.ifs 2020-12-22 2020-12-23
4567330 4567330 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 0 A 2014-01-21 ? 0 no no no 2014-01-22 2017-10-16 ? 20201222.ifs 2020-12-22 2020-12-23
4567331 4567330 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 0 A 2014-01-21 ? 4 no no no 2014-01-22 2017-10-16 ? 20201222.ifs 2020-12-22 2020-12-23
4467188 4467188 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2020-09-30 2020-09-22 0 2020-09-22 ? 0 0006161866 20200922.ifs 2020-09-22 2020-09-23
4398088 4398088 DIVIDEND ADD 74348A376 0 0 E 0 0 58 ? ? 2020-07-01 2020-06-23 0 2020-06-23 ? 0 0006116823 20200623.ifs 2020-06-23 2020-06-24
4252065 4252065 DIVIDEND ADD 74348A376 0 0 1 0 .009701 00 2020-03-25 2020-03-26 2020-04-01 2020-03-24 0 2020-03-24 ? 0 0006072658 20200324.ifs 2020-03-24 2020-03-25
4252223 4252223 DIVIDEND ADD 74348A376 0 0 1 0 .009701 00 2020-03-25 2020-03-26 2020-04-01 2020-03-24 0 2020-03-24 ? 0 0006072658 20200324.ifs 2020-03-24 2020-03-25
4115429 4115429 DIVIDEND ADD 74348A376 0 0 1 0 .05241 00 2019-12-24 2019-12-26 2020-01-02 2019-12-23 0 2019-12-23 ? 0 0006021467 20191223.ifs 2019-12-23 2019-12-24
4115444 4115444 DIVIDEND ADD 74348A376 0 0 1 0 .05241 00 2019-12-24 2019-12-26 2020-01-02 2019-12-23 0 2019-12-23 ? 0 0006021467 20191223.ifs 2019-12-23 2019-12-24
3936162 3936162 DIVIDEND ADD 74348A376 0 0 1 0 .103347 00 2019-09-25 2019-09-26 2019-10-02 2019-09-24 0 2019-09-24 ? 0 0005949583 20190924.ifs 2019-09-24 2019-09-25
3936295 3936295 DIVIDEND ADD 74348A376 0 0 1 0 .103347 00 2019-09-25 2019-09-26 2019-10-02 2019-09-24 0 2019-09-24 ? 0 0005949583 20190924.ifs 2019-09-24 2019-09-25
3796551 3796551 DIVIDEND ADD 74348A376 0 0 1 0 .117677 00 2019-06-25 2019-06-26 2019-07-02 2019-06-24 0 2019-06-24 ? 0 0005903380 20190624.ifs 2019-06-24 2019-06-25
3796558 3796558 DIVIDEND ADD 74348A376 0 0 1 0 .117677 00 2019-06-25 2019-06-26 2019-07-02 2019-06-24 0 2019-06-24 ? 0 0005903380 20190624.ifs 2019-06-24 2019-06-25
3637409 3637409 DIVIDEND ADD 74348A376 0 0 1 0 .086038 00 2019-03-20 2019-03-21 2019-03-27 2019-03-19 0 2019-03-19 ? 0 0005854759 20190319.ifs 2019-03-19 2019-03-20
3637412 3637412 DIVIDEND ADD 74348A376 0 0 1 0 .086038 00 2019-03-20 2019-03-21 2019-03-27 2019-03-19 0 2019-03-19 ? 0 0005854759 20190319.ifs 2019-03-19 2019-03-20
3494755 3494755 DIVIDEND ADD 74348A376 0 0 1 0 .062942 35 2018-12-26 2018-12-27 2019-01-03 2018-12-24 0 2018-12-24 ? 0 0005804420 20181224.ifs 2018-12-24 2018-12-25
2724000 2724000 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 N A 2014-01-21 ? 0 no no no 2014-01-22 2014-01-24 ? 20171016.ifs 2017-10-16 2017-10-17
2724002 2724001 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 0 A 2014-01-21 ? 0 no no no 2014-01-22 2017-10-16 ? 20171016.ifs 2017-10-16 2017-10-17
2724005 2724005 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 N A 2014-01-21 ? 0 no no no 2014-01-22 2014-01-24 ? 20171016.ifs 2017-10-16 2017-10-17
2724007 2724006 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 0 A 2014-01-21 ? 0 no no no 2014-01-22 2017-10-16 ? 20171016.ifs 2017-10-16 2017-10-17
1426602 1426602 EQUITY CHANGE 74348A376 ETF N A 2014-01-21 ? 0 no no no 2014-01-22 ? ? 20140124.ifs 2014-01-24 2014-01-25
1426603 1426602 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 N A 2014-01-21 ? 0 no no no 2014-01-22 2014-01-24 ? 20140124.ifs 2014-01-24 2014-01-25
1426754 1426754 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 N A 2014-01-21 ? 0 no no no 2014-01-22 2014-01-24 ? 20140124.ifs 2014-01-24 2014-01-25
1426755 1426754 EQUITY CHANGE 74348A376 SHORT SMALLCAP600 NEW JAN 2014 N A 2014-01-21 ? 0 no no no 2014-01-22 2014-01-24 ? 20140124.ifs 2014-01-24 2014-01-25
1426756 1426756 EXCHANGE ADD 74348A376 04 2014-01-24 2014-01-24 SBB 0 A ? 2014-01-24 20140124.ifs 2014-01-24 2014-01-25
1426867 1426867 SPLIT ADD 74348A376 4 2014-01-24 54 2014-01-14 2014-01-24 20140124.ifs 2014-01-24 2014-01-25
1426869 1426869 DIVIDEND ADD 74348A376 0 0 6 0 .25 0 54 2014-01-24 2014-01-24 2014-01-24 2014-01-24 0 ? 2014-01-24 0 0004724032 20140124.ifs 2014-01-24 2014-01-25
1425434 1425434 EQUITY ADD 74348A376 ETF N A 2014-01-21 ? 0 no no no 2014-01-22 ? ? 20140122.ifs 2014-01-22 2014-01-23


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