Compid = 159578Number Of Rows Found :1
$tempCalculation=11.85
START :9.92
END :11.0955
Compid Found :159578 Tic Found :ACGBY
FINALACGBY | 159578
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159578 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-79
oldDecreaseHoldingTotalShares-9111
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld10850
totalSharesValue113
totalPostionChange-9111
totalValueChange-79
totalHolders1
COMPID159578
TICACGBY
CIK9000004044
SHSOUT1230000
NAMEAgricultural Bk Chin
SECTOR999999
CUSIP00850M102
PRICE11.0955
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-97
oldDecreaseHoldingTotalShares-11039
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld11911
totalSharesValue124
totalPostionChange-11039
totalValueChange-97
totalHolders2
COMPID159578
TICACGBY
CIK9000004044
SHSOUT1230000
NAMEAgricultural Bk Chin
SECTOR999999
CUSIP00850M102
PRICE11.0955
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares318
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-97
oldDecreaseHoldingTotalShares-11039
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld12229
totalSharesValue127
totalPostionChange-10721
totalValueChange-94
totalHolders3
COMPID159578
TICACGBY
CIK9000004044
SHSOUT1230000
NAMEAgricultural Bk Chin
SECTOR999999
CUSIP00850M102
PRICE11.0955
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares318
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-98
oldDecreaseHoldingTotalShares-11149
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld12273
totalSharesValue127
totalPostionChange-10831
totalValueChange-95
totalHolders4
COMPID159578
TICACGBY
CIK9000004044
SHSOUT1230000
NAMEAgricultural Bk Chin
SECTOR999999
CUSIP00850M102
PRICE11.0955
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares318
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-98
oldDecreaseHoldingTotalShares-11149
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue20
oldIncreaseHoldingTotalShares1099
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld24310
totalSharesValue252
totalPostionChange-9732
totalValueChange-75
totalHolders5
COMPID159578
TICACGBY
CIK9000004044
SHSOUT1230000
NAMEAgricultural Bk Chin
SECTOR999999
CUSIP00850M102
PRICE11.0955
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue3
newHoldingTotalShares318
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-98
oldDecreaseHoldingTotalShares-11149
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue20
oldIncreaseHoldingTotalShares1102
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld24316
totalSharesValue252
totalPostionChange-9729
totalValueChange-75
totalHolders6
COMPID159578
TICACGBY
CIK9000004044
SHSOUT1230000
NAMEAgricultural Bk Chin
SECTOR999999
CUSIP00850M102
PRICE11.0955
virgina 0
virgina2 -0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 252
MKCAP13647465/n/ninsert into institSumNewHoldings values(
Null,
'9000004044',
'159578',
'Agricultural Bk Chin',
'ACGBY',
'11.0955',
'00850M102',
'1230000',
'0',
'999999',
'N/A',
'13647465',
'0',
'0',
'0',
'1',
'3',
'318',
'3',
'-98',
'-11149',
'2',
'20',
'1102',
'24316',
'252',
'-9729',
'-75',
'6',
'0',
'0',
'0',
'-0',
'-0',
'-0',
'-0',
'9.445',
'10.39',
'9.92',
'11.85',
NULL, NULL,NULL)
OKbye