Compid = 159684Number Of Rows Found :1
$tempCalculation=78.39
START :3.1
END :5.53

Compid Found :159684 Tic Found :CESDF
FINALCESDF | 159684

Split info : 1



START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =159684 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'

Number Of Rows Found :1


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue84
oldDecreaseHoldingTotalShares-205
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld99387
totalSharesValue345
totalPostionChange-205
totalValueChange84
totalHolders1
COMPID159684
TICCESDF
CIK9000004150
SHSOUT267580
NAMECes Energy Solutio
SECTOR999999
CUSIP15713J104
PRICE5.53
virgina 0.04

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

CRAIG TOTAL SHARES VALE : 345

MKCAP1479717.4/n/ninsert into institSumNewHoldings values( Null, '9000004150', '159684', 'Ces Energy Solutio', 'CESDF', '5.53', '15713J104', '267580', '0.04', '999999', 'N/A', '1479717.4', '0', '0', '0', '0', '0', '0', '1', '84', '-205', '0', '0', '0', '99387', '345', '-205', '84', '1', '0', '0', '0', '-0', '-0', '-0', '-0', '2.608', '3.47', '3.1', '78.39', NULL, NULL,NULL) OKbye