Compid = 145686Number Of Rows Found :1
$tempCalculation=0
START :
END :51.8487
Compid Found :145686 Tic Found :CCDBF
FINALCCDBF | 145686
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =145686 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :2
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3085
newHoldingTotalShares60300
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld60300
totalSharesValue3085
totalPostionChange60300
totalValueChange3085
totalHolders1
COMPID145686
TICCCDBF
CIK
SHSOUT0
NAMECCL Industries Inc. (Canada)
SECTOR999999
CUSIP124900309
PRICE51.8487
liquidatedTotalCompanies1
liquidatedTotalValue-2715
liquidatedTotalShares-60361
newHoldingTotalCompanies1
newHoldingTotalValue3085
newHoldingTotalShares60300
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld60300
totalSharesValue3085
totalPostionChange-61
totalValueChange370
totalHolders1
COMPID145686
TICCCDBF
CIK
SHSOUT0
NAMECCL Industries Inc. (Canada)
SECTOR999999
CUSIP124900309
PRICE51.8487
virgina 0
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 3085
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'',
'145686',
'CCL Industries Inc. (Canada)',
'CCDBF',
'51.8487',
'124900309',
'0',
'0',
'999999',
'N/A',
'0',
'1',
'-2715',
'-60361',
'1',
'3085',
'60300',
'0',
'0',
'0',
'0',
'0',
'0',
'60300',
'3085',
'-61',
'370',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye