Compid = 159574Number Of Rows Found :1
$tempCalculation=0
START :
END :26.27

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 >= '2025-06-30'

Number Of Rows Found :26must have stayed the same


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld700
totalSharesValue25
totalPostionChange0
totalValueChange4
totalHolders1
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld700
totalSharesValue25
totalPostionChange-55
totalValueChange2
totalHolders1
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies1
newHoldingTotalValue206
newHoldingTotalShares5684
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld6384
totalSharesValue231
totalPostionChange5629
totalValueChange208
totalHolders2
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies1
newHoldingTotalValue206
newHoldingTotalShares5684
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue122
oldIncreaseHoldingTotalShares2755
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld16106
totalSharesValue605
totalPostionChange8384
totalValueChange330
totalHolders3
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies2
newHoldingTotalValue439
newHoldingTotalShares11751
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue122
oldIncreaseHoldingTotalShares2755
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld22173
totalSharesValue838
totalPostionChange14451
totalValueChange563
totalHolders4
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies3
newHoldingTotalValue483
newHoldingTotalShares12980
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue122
oldIncreaseHoldingTotalShares2755
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld23402
totalSharesValue882
totalPostionChange15680
totalValueChange607
totalHolders5
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies3
newHoldingTotalValue483
newHoldingTotalShares12980
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue374
oldIncreaseHoldingTotalShares2991
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld120639
totalSharesValue4614
totalPostionChange15916
totalValueChange859
totalHolders6
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue374
oldIncreaseHoldingTotalShares2991
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld126912
totalSharesValue4841
totalPostionChange22189
totalValueChange1086
totalHolders7
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue188
oldDecreaseHoldingTotalShares-2010
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue374
oldIncreaseHoldingTotalShares2991
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 700


totalSharesHeld168773
totalSharesValue6356
totalPostionChange20179
totalValueChange1274
totalHolders8
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue188
oldDecreaseHoldingTotalShares-2010
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue374
oldIncreaseHoldingTotalShares2991
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 814


totalSharesHeld168887
totalSharesValue6360
totalPostionChange20179
totalValueChange1274
totalHolders9
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue188
oldDecreaseHoldingTotalShares-2010
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue3023
oldIncreaseHoldingTotalShares44596
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 814


totalSharesHeld403387
totalSharesValue14844
totalPostionChange61784
totalValueChange3923
totalHolders10
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue188
oldDecreaseHoldingTotalShares-2010
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue3023
oldIncreaseHoldingTotalShares44596
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 17
unchangedHoldingTotalShares 6578


totalSharesHeld409151
totalSharesValue15066
totalPostionChange61784
totalValueChange3936
totalHolders11
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue259
oldDecreaseHoldingTotalShares-3488
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue3023
oldIncreaseHoldingTotalShares44596
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 17
unchangedHoldingTotalShares 6578


totalSharesHeld428641
totalSharesValue15771
totalPostionChange60306
totalValueChange4007
totalHolders12
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue259
oldDecreaseHoldingTotalShares-3488
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue3056
oldIncreaseHoldingTotalShares45457
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 17
unchangedHoldingTotalShares 6578


totalSharesHeld429574
totalSharesValue15807
totalPostionChange61167
totalValueChange4040
totalHolders13
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue259
oldDecreaseHoldingTotalShares-3488
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue3096
oldIncreaseHoldingTotalShares46470
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 17
unchangedHoldingTotalShares 6578


totalSharesHeld431209
totalSharesValue15866
totalPostionChange62180
totalValueChange4080
totalHolders14
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue259
oldDecreaseHoldingTotalShares-3488
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue3096
oldIncreaseHoldingTotalShares46470
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 200
unchangedHoldingTotalShares 89506


totalSharesHeld514137
totalSharesValue19049
totalPostionChange62180
totalValueChange4263
totalHolders15
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue278
oldDecreaseHoldingTotalShares-4234
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue3096
oldIncreaseHoldingTotalShares46470
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 200
unchangedHoldingTotalShares 89506


totalSharesHeld521146
totalSharesValue19303
totalPostionChange61434
totalValueChange4282
totalHolders16
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue278
oldDecreaseHoldingTotalShares-4234
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue3096
oldIncreaseHoldingTotalShares46470
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 267
unchangedHoldingTotalShares 116181


totalSharesHeld547821
totalSharesValue20327
totalPostionChange61434
totalValueChange4349
totalHolders17
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-55
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue278
oldDecreaseHoldingTotalShares-4234
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue3649
oldIncreaseHoldingTotalShares57893
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 267
unchangedHoldingTotalShares 116181


totalSharesHeld584240
totalSharesValue21633
totalPostionChange72857
totalValueChange4902
totalHolders18
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue278
oldDecreaseHoldingTotalShares-4234
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue3649
oldIncreaseHoldingTotalShares57893
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 267
unchangedHoldingTotalShares 116181


totalSharesHeld584240
totalSharesValue21633
totalPostionChange72655
totalValueChange4895
totalHolders18
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue7317
oldDecreaseHoldingTotalShares-44002
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue3649
oldIncreaseHoldingTotalShares57893
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 267
unchangedHoldingTotalShares 116181


totalSharesHeld2015003
totalSharesValue72985
totalPostionChange32887
totalValueChange11934
totalHolders19
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue7317
oldDecreaseHoldingTotalShares-44002
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue3649
oldIncreaseHoldingTotalShares57893
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 273
unchangedHoldingTotalShares 118701


totalSharesHeld2017523
totalSharesValue73082
totalPostionChange32887
totalValueChange11940
totalHolders20
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue7317
oldDecreaseHoldingTotalShares-44002
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue3649
oldIncreaseHoldingTotalShares57893
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue 273
unchangedHoldingTotalShares 119412


totalSharesHeld2018234
totalSharesValue73103
totalPostionChange32887
totalValueChange11940
totalHolders21
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies4
newHoldingTotalValue710
newHoldingTotalShares19253
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue7317
oldDecreaseHoldingTotalShares-44002
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue4374
oldIncreaseHoldingTotalShares64953
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue 273
unchangedHoldingTotalShares 119412


totalSharesHeld2104373
totalSharesValue76220
totalPostionChange39947
totalValueChange12665
totalHolders22
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies5
newHoldingTotalValue715
newHoldingTotalShares19393
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue7317
oldDecreaseHoldingTotalShares-44002
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue4374
oldIncreaseHoldingTotalShares64953
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue 273
unchangedHoldingTotalShares 119412


totalSharesHeld2104513
totalSharesValue76225
totalPostionChange40087
totalValueChange12670
totalHolders23
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same


liquidatedTotalCompanies2
liquidatedTotalValue-9
liquidatedTotalShares-257
newHoldingTotalCompanies5
newHoldingTotalValue715
newHoldingTotalShares19393
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue7317
oldDecreaseHoldingTotalShares-44002
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue4374
oldIncreaseHoldingTotalShares64953
unchangedHoldingTotalCompanies 8
unchangedHoldingTotalValue 394
unchangedHoldingTotalShares 139412


totalSharesHeld2124513
totalSharesValue76949
totalPostionChange40087
totalValueChange12791
totalHolders24
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
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 : 76949

MKCAP79335400/n/ninsert into institSumNewHoldings values( Null, '9000004040', '159574', 'Aia Group Ltd', 'AAGIY', '26.27', '001317205', '3020000', '0.07', '999999', 'N/A', '79335400', '2', '-9', '-257', '5', '715', '19393', '4', '7317', '-44002', '7', '4374', '64953', '2124513', '76949', '40087', '12791', '24', '8', '394', '139412', '0', '0', '0', '0', '', '', '', '0', NULL, NULL,NULL) OKbye