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-03-31'
Number Of Rows Found :23must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 114
totalSharesHeld114
totalSharesValue3
totalPostionChange0
totalValueChange0
totalHolders1
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue65
oldIncreaseHoldingTotalShares1252
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 114
totalSharesHeld25110
totalSharesValue756
totalPostionChange1252
totalValueChange65
totalHolders2
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue222
oldIncreaseHoldingTotalShares2779
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 114
totalSharesHeld104189
totalSharesValue3148
totalPostionChange2779
totalValueChange222
totalHolders3
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue266
oldIncreaseHoldingTotalShares3277
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 114
totalSharesHeld125157
totalSharesValue3782
totalPostionChange3277
totalValueChange266
totalHolders4
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue318
oldIncreaseHoldingTotalShares4829
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 114
totalSharesHeld130148
totalSharesValue3933
totalPostionChange4829
totalValueChange318
totalHolders5
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue373
oldIncreaseHoldingTotalShares5525
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 114
totalSharesHeld154300
totalSharesValue4664
totalPostionChange5525
totalValueChange373
totalHolders6
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue373
oldIncreaseHoldingTotalShares5525
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 149
totalSharesHeld154335
totalSharesValue4665
totalPostionChange5525
totalValueChange373
totalHolders7
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue374
oldIncreaseHoldingTotalShares5529
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 149
totalSharesHeld154957
totalSharesValue4684
totalPostionChange5529
totalValueChange374
totalHolders8
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue494
oldIncreaseHoldingTotalShares5582
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 149
totalSharesHeld237861
totalSharesValue7192
totalPostionChange5582
totalValueChange494
totalHolders9
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies8
oldIncreaseHoldingTotalValue498
oldIncreaseHoldingTotalShares5721
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 149
totalSharesHeld238063
totalSharesValue7198
totalPostionChange5721
totalValueChange498
totalHolders10
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies8
oldIncreaseHoldingTotalValue498
oldIncreaseHoldingTotalShares5721
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 149
totalSharesHeld238063
totalSharesValue7198
totalPostionChange3201
totalValueChange425
totalHolders10
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies9
oldIncreaseHoldingTotalValue535
oldIncreaseHoldingTotalShares6598
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 149
totalSharesHeld245818
totalSharesValue7433
totalPostionChange4078
totalValueChange462
totalHolders11
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies9
oldIncreaseHoldingTotalValue535
oldIncreaseHoldingTotalShares6598
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193044
totalSharesHeld438713
totalSharesValue13268
totalPostionChange4078
totalValueChange738
totalHolders12
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies9
oldIncreaseHoldingTotalValue535
oldIncreaseHoldingTotalShares6598
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193044
totalSharesHeld482584
totalSharesValue14595
totalPostionChange2382
totalValueChange752
totalHolders13
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies10
oldIncreaseHoldingTotalValue1530
oldIncreaseHoldingTotalShares36715
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193044
totalSharesHeld590022
totalSharesValue17832
totalPostionChange32499
totalValueChange1747
totalHolders14
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies11
oldIncreaseHoldingTotalValue5395
oldIncreaseHoldingTotalShares111526
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193044
totalSharesHeld2060553
totalSharesValue62145
totalPostionChange107310
totalValueChange5612
totalHolders15
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies11
oldIncreaseHoldingTotalValue5395
oldIncreaseHoldingTotalShares111526
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193099
totalSharesHeld2060608
totalSharesValue62147
totalPostionChange107310
totalValueChange5612
totalHolders16
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies1
liquidatedTotalValue-73
liquidatedTotalShares-2520
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies12
oldIncreaseHoldingTotalValue5470
oldIncreaseHoldingTotalShares112406
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193099
totalSharesHeld2104161
totalSharesValue63459
totalPostionChange108190
totalValueChange5687
totalHolders17
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies2
liquidatedTotalValue-291
liquidatedTotalShares-10096
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies12
oldIncreaseHoldingTotalValue5470
oldIncreaseHoldingTotalShares112406
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 276
unchangedHoldingTotalShares 193099
totalSharesHeld2104161
totalSharesValue63459
totalPostionChange100614
totalValueChange5469
totalHolders17
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-291
liquidatedTotalShares-10096
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies12
oldIncreaseHoldingTotalValue5470
oldIncreaseHoldingTotalShares112406
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 277
unchangedHoldingTotalShares 193799
totalSharesHeld2104861
totalSharesValue63480
totalPostionChange100614
totalValueChange5470
totalHolders18
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies2
liquidatedTotalValue-291
liquidatedTotalShares-10096
newHoldingTotalCompanies1
newHoldingTotalValue78
newHoldingTotalShares2520
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies12
oldIncreaseHoldingTotalValue5470
oldIncreaseHoldingTotalShares112406
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 277
unchangedHoldingTotalShares 193799
totalSharesHeld2107381
totalSharesValue63558
totalPostionChange103134
totalValueChange5548
totalHolders19
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27
liquidatedTotalCompanies2
liquidatedTotalValue-291
liquidatedTotalShares-10096
newHoldingTotalCompanies1
newHoldingTotalValue78
newHoldingTotalShares2520
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies13
oldIncreaseHoldingTotalValue5477
oldIncreaseHoldingTotalShares112626
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 277
unchangedHoldingTotalShares 193799
totalSharesHeld2108092
totalSharesValue63579
totalPostionChange103354
totalValueChange5555
totalHolders20
COMPID159574
TICAAGIY
CIK9000004040
SHSOUT3020000
NAMEAia Group Ltd
SECTOR999999
CUSIP001317205
PRICE26.27must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-291
liquidatedTotalShares-10096
newHoldingTotalCompanies1
newHoldingTotalValue78
newHoldingTotalShares2520
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue14
oldDecreaseHoldingTotalShares-1696
oldIncreaseHoldingTotalCompanies13
oldIncreaseHoldingTotalValue5477
oldIncreaseHoldingTotalShares112626
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 277
unchangedHoldingTotalShares 213799
totalSharesHeld2128092
totalSharesValue64182
totalPostionChange103354
totalValueChange5555
totalHolders21
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 : 64182
MKCAP79335400/n/ninsert into institSumNewHoldings values(
Null,
'9000004040',
'159574',
'Aia Group Ltd',
'AAGIY',
'26.27',
'001317205',
'3020000',
'0.07',
'999999',
'N/A',
'79335400',
'2',
'-291',
'-10096',
'1',
'78',
'2520',
'1',
'14',
'-1696',
'13',
'5477',
'112626',
'2128092',
'64182',
'103354',
'5555',
'21',
'6',
'277',
'213799',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye