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