Compid = 159753Number Of Rows Found :1
$tempCalculation=0.51
START :48.66
END :48.908
Compid Found :159753 Tic Found :HDG
FINALHDG | 159753
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159753 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :17
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1132
oldIncreaseHoldingTotalShares22986
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld22986
totalSharesValue1132
totalPostionChange22986
totalValueChange1132
totalHolders1
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1132
oldIncreaseHoldingTotalShares22986
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld22986
totalSharesValue1132
totalPostionChange17759
totalValueChange878
totalHolders1
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-53
oldDecreaseHoldingTotalShares-1155
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1132
oldIncreaseHoldingTotalShares22986
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld29088
totalSharesValue1432
totalPostionChange16604
totalValueChange825
totalHolders2
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-53
oldDecreaseHoldingTotalShares-1155
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue1177
oldIncreaseHoldingTotalShares23268
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld80782
totalSharesValue3978
totalPostionChange16886
totalValueChange870
totalHolders3
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-415
oldDecreaseHoldingTotalShares-8623
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue1177
oldIncreaseHoldingTotalShares23268
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld82774
totalSharesValue4076
totalPostionChange9418
totalValueChange508
totalHolders4
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-415
oldDecreaseHoldingTotalShares-8623
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1631
oldIncreaseHoldingTotalShares32213
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld114459
totalSharesValue5636
totalPostionChange18363
totalValueChange962
totalHolders5
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-412
oldDecreaseHoldingTotalShares-8665
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1631
oldIncreaseHoldingTotalShares32213
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld122979
totalSharesValue6056
totalPostionChange18321
totalValueChange965
totalHolders6
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-412
oldDecreaseHoldingTotalShares-8665
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1733
oldIncreaseHoldingTotalShares33175
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld214341
totalSharesValue10556
totalPostionChange19283
totalValueChange1067
totalHolders7
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-412
oldDecreaseHoldingTotalShares-8665
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1733
oldIncreaseHoldingTotalShares33175
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld220735
totalSharesValue10872
totalPostionChange25677
totalValueChange1383
totalHolders8
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-558
oldDecreaseHoldingTotalShares-12177
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1733
oldIncreaseHoldingTotalShares33175
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld262794
totalSharesValue12943
totalPostionChange22165
totalValueChange1237
totalHolders9
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies1
liquidatedTotalValue-254
liquidatedTotalShares-5227
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-653
oldDecreaseHoldingTotalShares-14151
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1733
oldIncreaseHoldingTotalShares33175
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld263789
totalSharesValue12992
totalPostionChange20191
totalValueChange1142
totalHolders10
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies2
liquidatedTotalValue-281
liquidatedTotalShares-5786
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-653
oldDecreaseHoldingTotalShares-14151
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1733
oldIncreaseHoldingTotalShares33175
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld263789
totalSharesValue12992
totalPostionChange19632
totalValueChange1115
totalHolders10
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies3
liquidatedTotalValue-281
liquidatedTotalShares-5787
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-653
oldDecreaseHoldingTotalShares-14151
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1733
oldIncreaseHoldingTotalShares33175
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld263789
totalSharesValue12992
totalPostionChange19631
totalValueChange1115
totalHolders10
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies3
liquidatedTotalValue-281
liquidatedTotalShares-5787
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-653
oldDecreaseHoldingTotalShares-14151
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1758
oldIncreaseHoldingTotalShares33579
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld269959
totalSharesValue13296
totalPostionChange20035
totalValueChange1140
totalHolders11
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908must have stayed the same
liquidatedTotalCompanies3
liquidatedTotalValue-281
liquidatedTotalShares-5787
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-653
oldDecreaseHoldingTotalShares-14151
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1758
oldIncreaseHoldingTotalShares33579
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld269959
totalSharesValue13296
totalPostionChange20035
totalValueChange1140
totalHolders12
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies3
liquidatedTotalValue-281
liquidatedTotalShares-5787
newHoldingTotalCompanies1
newHoldingTotalValue316
newHoldingTotalShares6394
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-778
oldDecreaseHoldingTotalShares-16871
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1758
oldIncreaseHoldingTotalShares33579
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld283000
totalSharesValue13938
totalPostionChange17315
totalValueChange1015
totalHolders13
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
liquidatedTotalCompanies3
liquidatedTotalValue-281
liquidatedTotalShares-5787
newHoldingTotalCompanies2
newHoldingTotalValue316
newHoldingTotalShares7394
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-778
oldDecreaseHoldingTotalShares-16871
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1758
oldIncreaseHoldingTotalShares33579
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld284000
totalSharesValue13938
totalPostionChange18315
totalValueChange1015
totalHolders14
COMPID159753
TICHDG
CIK9000004219
SHSOUT1150
NAMEProshares Hedge Replication
SECTOR999999
CUSIP74347X294
PRICE48.908
virgina 24.7
virgina2 1.59
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 13938
MKCAP56244.2/n/ninsert into institSumNewHoldings values(
Null,
'9000004219',
'159753',
'Proshares Hedge Replication',
'HDG',
'48.908',
'74347X294',
'1150',
'24.7',
'999999',
'N/A',
'56244.2',
'3',
'-281',
'-5787',
'2',
'316',
'7394',
'6',
'-778',
'-16871',
'5',
'1758',
'33579',
'284000',
'13938',
'18315',
'1015',
'14',
'1',
'0',
'0',
'1.59',
'NULL',
'221614.2',
'221614.2',
'48.4833',
'49.2492',
'48.66',
'0.51',
NULL, NULL,NULL)
OKbye