Compid = 159958Number Of Rows Found :1
$tempCalculation=2.08
START :187.11
END :191
Compid Found :159958 Tic Found :CMXHF
FINALCMXHF | 159958
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159958 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
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue7136
oldIncreaseHoldingTotalShares46394
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld249962
totalSharesValue46953
totalPostionChange46394
totalValueChange7136
totalHolders1
COMPID159958
TICCMXHF
CIK9000004424
SHSOUT452400
NAMECsl Ltd
SECTOR999999
CUSIPQ3018U109
PRICE191
virgina 0.06
virgina2 0.01
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 46953
MKCAP86408400/n/ninsert into institSumNewHoldings values(
Null,
'9000004424',
'159958',
'Csl Ltd',
'CMXHF',
'191',
'Q3018U109',
'452400',
'0.06',
'999999',
'N/A',
'86408400',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'7136',
'46394',
'249962',
'46953',
'46394',
'7136',
'1',
'0',
'0',
'0',
'0.01',
'NULL',
'4695.3',
'4695.3',
'189.05',
'184.35',
'187.11',
'2.08',
NULL, NULL,NULL)
OKbye