Compid = 159957Number Of Rows Found :1
$tempCalculation=0
START :
END :0.000001
Compid Found :159957 Tic Found :CLCL
FINALCLCL | 159957
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159957 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 393334
totalSharesHeld393334
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders1
COMPID159957
TICCLCL
CIK9000004423
SHSOUT99580
NAMECalcol Inc
SECTOR999999
CUSIP128699105
PRICE0.000001
virgina 0.39
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 0
MKCAP0.09958/n/ninsert into institSumNewHoldings values(
Null,
'9000004423',
'159957',
'Calcol Inc',
'CLCL',
'0.000001',
'128699105',
'99580',
'0.39',
'999999',
'N/A',
'0.09958',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'393334',
'0',
'0',
'0',
'1',
'1',
'0',
'393334',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye