Compid = 159574Number Of Rows Found :1
$tempCalculation=-13.09
START :31.54
END :27.41

Compid Found :159574 Tic Found :AAGIY
FINALAAGIY | 159574

Split info : 1

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

Number Of Rows Found :23

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld80
totalSharesValue2
totalPostionChange80
totalValueChange2
totalHolders1
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld80
totalSharesValue2
totalPostionChange-925
totalValueChange-33
totalHolders1
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-13668
oldDecreaseHoldingTotalShares-58838
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld1452108
totalSharesValue39001
totalPostionChange-59763
totalValueChange-13701
totalHolders2
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-13668
oldDecreaseHoldingTotalShares-58838
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1452262
totalSharesValue39005
totalPostionChange-59763
totalValueChange-13702
totalHolders3
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-14111
oldDecreaseHoldingTotalShares-60323
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1501234
totalSharesValue40321
totalPostionChange-61248
totalValueChange-14145
totalHolders4
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-14111
oldDecreaseHoldingTotalShares-60323
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-93
oldIncreaseHoldingTotalShares1276
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1518894
totalSharesValue40796
totalPostionChange-59972
totalValueChange-14238
totalHolders5
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-14122
oldDecreaseHoldingTotalShares-60511
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-93
oldIncreaseHoldingTotalShares1276
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1519452
totalSharesValue40811
totalPostionChange-60160
totalValueChange-14249
totalHolders6
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares80
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-14346
oldDecreaseHoldingTotalShares-65006
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-93
oldIncreaseHoldingTotalShares1276
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1528158
totalSharesValue41045
totalPostionChange-64655
totalValueChange-14473
totalHolders7
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-14346
oldDecreaseHoldingTotalShares-65006
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-93
oldIncreaseHoldingTotalShares1276
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1528195
totalSharesValue41046
totalPostionChange-64618
totalValueChange-14472
totalHolders8
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-14346
oldDecreaseHoldingTotalShares-65006
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue-290
oldIncreaseHoldingTotalShares5106
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1570630
totalSharesValue42187
totalPostionChange-60788
totalValueChange-14669
totalHolders9
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-14346
oldDecreaseHoldingTotalShares-65006
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-248
oldIncreaseHoldingTotalShares6661
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1572185
totalSharesValue42229
totalPostionChange-59233
totalValueChange-14627
totalHolders10
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-14568
oldDecreaseHoldingTotalShares-65668
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-248
oldIncreaseHoldingTotalShares6661
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1597733
totalSharesValue42916
totalPostionChange-59895
totalValueChange-14849
totalHolders11
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-14593
oldDecreaseHoldingTotalShares-66279
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-248
oldIncreaseHoldingTotalShares6661
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 154

totalSharesHeld1599114
totalSharesValue42953
totalPostionChange-60506
totalValueChange-14874
totalHolders12
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-14593
oldDecreaseHoldingTotalShares-66279
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-248
oldIncreaseHoldingTotalShares6661
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -8
unchangedHoldingTotalShares 1054

totalSharesHeld1600014
totalSharesValue42977
totalPostionChange-60506
totalValueChange-14881
totalHolders13
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-14675
oldDecreaseHoldingTotalShares-66596
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-248
oldIncreaseHoldingTotalShares6661
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -8
unchangedHoldingTotalShares 1054

totalSharesHeld1609132
totalSharesValue43222
totalPostionChange-60823
totalValueChange-14963
totalHolders14
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-14675
oldDecreaseHoldingTotalShares-66596
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue578
oldIncreaseHoldingTotalShares53034
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -8
unchangedHoldingTotalShares 1054

totalSharesHeld1709371
totalSharesValue45916
totalPostionChange-14450
totalValueChange-14137
totalHolders15
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-14675
oldDecreaseHoldingTotalShares-66596
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue578
oldIncreaseHoldingTotalShares53034
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -1324
unchangedHoldingTotalShares 169992

totalSharesHeld1878309
totalSharesValue50457
totalPostionChange-14450
totalValueChange-15453
totalHolders16
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-14675
oldDecreaseHoldingTotalShares-66596
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue391
oldIncreaseHoldingTotalShares71984
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -1324
unchangedHoldingTotalShares 169992

totalSharesHeld1986631
totalSharesValue53369
totalPostionChange4500
totalValueChange-15640
totalHolders17
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares117
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-14675
oldDecreaseHoldingTotalShares-66596
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue-142
oldIncreaseHoldingTotalShares76447
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -1324
unchangedHoldingTotalShares 169992

totalSharesHeld2072748
totalSharesValue55682
totalPostionChange8963
totalValueChange-16173
totalHolders18
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41

liquidatedTotalCompanies1
liquidatedTotalValue-35
liquidatedTotalShares-1005
newHoldingTotalCompanies3
newHoldingTotalValue3
newHoldingTotalShares118
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-14675
oldDecreaseHoldingTotalShares-66596
oldIncreaseHoldingTotalCompanies8
oldIncreaseHoldingTotalValue421
oldIncreaseHoldingTotalShares97387
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -1329
unchangedHoldingTotalShares 170697

totalSharesHeld2094394
totalSharesValue56264
totalPostionChange29904
totalValueChange-15615
totalHolders22
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE27.41
virgina 0.07

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

CRAIG TOTAL SHARES VALE : 56264

MKCAP82778200/n/ninsert into institSumNewHoldings values( Null, '9000004040', '159574', 'Aia Group Ltd', 'AAGIY', '27.41', '001317205', '3020000', '0.07', '999999', 'N/A', '82778200', '1', '-35', '-1005', '3', '3', '118', '7', '-14675', '-66596', '8', '421', '97387', '2094394', '56264', '29904', '-15615', '22', '4', '-1329', '170697', '0', '0', '0', '0', '33.3', '26.88', '31.54', '-13.09', NULL, NULL,NULL) OKbye