Compid = 130747Number Of Rows Found :1
$tempCalculation=0
START :
END :16.5
Compid Found :130747 Tic Found :SBB
FINALSBB | 130747
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130747 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :8
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares1
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld2
totalSharesValue0
totalPostionChange1
totalValueChange0
totalHolders1
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5
liquidatedTotalCompanies1
liquidatedTotalValue-1229
liquidatedTotalShares-77179
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares1
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld2
totalSharesValue0
totalPostionChange-77178
totalValueChange-1229
totalHolders1
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5
liquidatedTotalCompanies1
liquidatedTotalValue-1229
liquidatedTotalShares-77179
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue390
oldIncreaseHoldingTotalShares24830
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld24831
totalSharesValue390
totalPostionChange-52349
totalValueChange-839
totalHolders2
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5
liquidatedTotalCompanies2
liquidatedTotalValue-1233
liquidatedTotalShares-77490
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue390
oldIncreaseHoldingTotalShares24830
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld24831
totalSharesValue390
totalPostionChange-52660
totalValueChange-843
totalHolders2
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-1233
liquidatedTotalShares-77490
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue390
oldIncreaseHoldingTotalShares24830
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 500
totalSharesHeld25331
totalSharesValue398
totalPostionChange-52660
totalValueChange-843
totalHolders3
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5
liquidatedTotalCompanies2
liquidatedTotalValue-1233
liquidatedTotalShares-77490
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-2
oldDecreaseHoldingTotalShares-74
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue390
oldIncreaseHoldingTotalShares24830
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 500
totalSharesHeld27396
totalSharesValue430
totalPostionChange-52734
totalValueChange-845
totalHolders4
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-1233
liquidatedTotalShares-77490
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-2
oldDecreaseHoldingTotalShares-74
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue390
oldIncreaseHoldingTotalShares24830
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 500
totalSharesHeld27396
totalSharesValue430
totalPostionChange-52734
totalValueChange-845
totalHolders5
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5
liquidatedTotalCompanies2
liquidatedTotalValue-1233
liquidatedTotalShares-77490
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1000
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-2
oldDecreaseHoldingTotalShares-74
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue390
oldIncreaseHoldingTotalShares24830
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 500
totalSharesHeld28396
totalSharesValue430
totalPostionChange-51734
totalValueChange-845
totalHolders6
COMPID130747
TICSBB
CIK9000000569
SHSOUT900
NAMEProShares Shrt Smlcap 600 Etf
SECTOR301009
CUSIP74348A376
PRICE16.5
virgina 3.16
virgina2 -5.75
SELECT * from sectors where level3num = '301009'Number Of Rows Found :1
The Sector is Domestic Regional Banks
CRAIG TOTAL SHARES VALE : 430
MKCAP14850/n/ninsert into institSumNewHoldings values(
Null,
'9000000569',
'130747',
'ProShares Shrt Smlcap 600 Etf',
'SBB',
'16.5',
'74348A376',
'900',
'3.16',
'301009',
'Domestic Regional Banks',
'14850',
'2',
'-1233',
'-77490',
'1',
'0',
'1000',
'1',
'-2',
'-74',
'2',
'390',
'24830',
'28396',
'430',
'-51734',
'-845',
'6',
'2',
'0',
'500',
'-5.75',
'-24725',
'NULL',
'-24725',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye