Compid = 159665Number Of Rows Found :1
$tempCalculation=16.81
START :18.5
END :21.61

Compid Found :159665 Tic Found :CIHKY
FINALCIHKY | 159665

Split info : 1



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

Number Of Rows Found :4


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares138
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld138
totalSharesValue3
totalPostionChange138
totalValueChange3
totalHolders1
COMPID159665
TICCIHKY
CIK9000004131
SHSOUT9000
NAMEChina Merchants Bank
SECTOR999999
CUSIP16950T102
PRICE21.61


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares138
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-4
oldDecreaseHoldingTotalShares-362
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld1080
totalSharesValue22
totalPostionChange-224
totalValueChange-1
totalHolders2
COMPID159665
TICCIHKY
CIK9000004131
SHSOUT9000
NAMEChina Merchants Bank
SECTOR999999
CUSIP16950T102
PRICE21.61


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares160
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-4
oldDecreaseHoldingTotalShares-362
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld1102
totalSharesValue22
totalPostionChange-202
totalValueChange-1
totalHolders3
COMPID159665
TICCIHKY
CIK9000004131
SHSOUT9000
NAMEChina Merchants Bank
SECTOR999999
CUSIP16950T102
PRICE21.61


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares160
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue80
oldDecreaseHoldingTotalShares-385
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld35708
totalSharesValue708
totalPostionChange-225
totalValueChange83
totalHolders4
COMPID159665
TICCIHKY
CIK9000004131
SHSOUT9000
NAMEChina Merchants Bank
SECTOR999999
CUSIP16950T102
PRICE21.61
virgina 0.4

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

CRAIG TOTAL SHARES VALE : 708

MKCAP194490/n/ninsert into institSumNewHoldings values( Null, '9000004131', '159665', 'China Merchants Bank', 'CIHKY', '21.61', '16950T102', '9000', '0.4', '999999', 'N/A', '194490', '0', '0', '0', '2', '3', '160', '2', '80', '-385', '0', '0', '0', '35708', '708', '-225', '83', '4', '0', '0', '0', '-0', '-0', '-0', '-0', '16.815', '19.81', '18.5', '16.81', NULL, NULL,NULL) OKbye