Compid = 159640Number Of Rows Found :1
$tempCalculation=0
START :
END :58.02

Compid Found :159640 Tic Found :BIB
FINALBIB | 159640

Split info : 1

START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =159640 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2025-06-30'

Number Of Rows Found :24

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld88
totalSharesValue4
totalPostionChange22
totalValueChange1
totalHolders1
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 250

totalSharesHeld338
totalSharesValue15
totalPostionChange22
totalValueChange0
totalHolders2
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares-1
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 250

totalSharesHeld338
totalSharesValue15
totalPostionChange21
totalValueChange0
totalHolders3
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares-1
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 448

totalSharesHeld536
totalSharesValue24
totalPostionChange21
totalValueChange-1
totalHolders4
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-95
oldDecreaseHoldingTotalShares-1837
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 448

totalSharesHeld3136
totalSharesValue143
totalPostionChange-1815
totalValueChange-96
totalHolders5
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-95
oldDecreaseHoldingTotalShares-1837
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -3
unchangedHoldingTotalShares 523

totalSharesHeld3211
totalSharesValue146
totalPostionChange-1815
totalValueChange-97
totalHolders6
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -3
unchangedHoldingTotalShares 523

totalSharesHeld9553
totalSharesValue437
totalPostionChange-9350
totalValueChange-475
totalHolders7
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -3
unchangedHoldingTotalShares 523

totalSharesHeld9553
totalSharesValue437
totalPostionChange-20116
totalValueChange-994
totalHolders7
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -4
unchangedHoldingTotalShares 576

totalSharesHeld9606
totalSharesValue439
totalPostionChange-20116
totalValueChange-995
totalHolders8
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue -4
unchangedHoldingTotalShares 701

totalSharesHeld9731
totalSharesValue445
totalPostionChange-20116
totalValueChange-995
totalHolders9
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue -4
unchangedHoldingTotalShares 740

totalSharesHeld9770
totalSharesValue447
totalPostionChange-20116
totalValueChange-995
totalHolders10
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue -4
unchangedHoldingTotalShares 976

totalSharesHeld10006
totalSharesValue458
totalPostionChange-20116
totalValueChange-995
totalHolders11
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 8
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld18006
totalSharesValue824
totalPostionChange-20116
totalValueChange-1014
totalHolders12
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld18006
totalSharesValue824
totalPostionChange-20116
totalValueChange-1014
totalHolders13
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies1
liquidatedTotalValue-519
liquidatedTotalShares-10766
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld18702
totalSharesValue856
totalPostionChange-19420
totalValueChange-982
totalHolders14
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies2
liquidatedTotalValue-1599
liquidatedTotalShares-33172
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-473
oldDecreaseHoldingTotalShares-9372
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld18702
totalSharesValue856
totalPostionChange-41826
totalValueChange-2062
totalHolders14
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies2
liquidatedTotalValue-1599
liquidatedTotalShares-33172
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-521
oldDecreaseHoldingTotalShares-10057
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares22
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld24998
totalSharesValue1144
totalPostionChange-42511
totalValueChange-2110
totalHolders15
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies2
liquidatedTotalValue-1599
liquidatedTotalShares-33172
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-521
oldDecreaseHoldingTotalShares-10057
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares145
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld25122
totalSharesValue1150
totalPostionChange-42388
totalValueChange-2104
totalHolders16
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies2
liquidatedTotalValue-1599
liquidatedTotalShares-33172
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-746
oldDecreaseHoldingTotalShares-14686
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares145
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld26119
totalSharesValue1196
totalPostionChange-47017
totalValueChange-2329
totalHolders17
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies3
liquidatedTotalValue-1601
liquidatedTotalShares-33212
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-746
oldDecreaseHoldingTotalShares-14686
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares145
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld26119
totalSharesValue1196
totalPostionChange-47057
totalValueChange-2331
totalHolders17
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies4
liquidatedTotalValue-1610
liquidatedTotalShares-33390
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-746
oldDecreaseHoldingTotalShares-14686
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares145
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue -23
unchangedHoldingTotalShares 8976

totalSharesHeld26119
totalSharesValue1196
totalPostionChange-47235
totalValueChange-2340
totalHolders17
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02

liquidatedTotalCompanies5
liquidatedTotalValue-1658
liquidatedTotalShares-34390
newHoldingTotalCompanies1
newHoldingTotalValue32
newHoldingTotalShares696
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-746
oldDecreaseHoldingTotalShares-14686
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares145
unchangedHoldingTotalCompanies 11
unchangedHoldingTotalValue -45
unchangedHoldingTotalShares 18272

totalSharesHeld35415
totalSharesValue1621
totalPostionChange-48235
totalValueChange-2410
totalHolders19
COMPID159640
TICBIB
CIK9000004106
SHSOUT2700
NAMEProshares Ultra Nasdaq Biotechnology
SECTOR999999
CUSIP74347R214
PRICE58.02
virgina 1.31

virgina2 -1.79
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A

CRAIG TOTAL SHARES VALE : 1621

MKCAP156654/n/ninsert into institSumNewHoldings values( Null, '9000004106', '159640', 'Proshares Ultra Nasdaq Biotechnology', 'BIB', '58.02', '74347R214', '2700', '1.31', '999999', 'N/A', '156654', '5', '-1658', '-34390', '1', '32', '696', '5', '-746', '-14686', '2', '7', '145', '35415', '1621', '-48235', '-2410', '19', '11', '-45', '18272', '-1.79', '-29015.9', 'NULL', '-29015.9', '', '', '', '0', NULL, NULL,NULL) OKbye