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