Compid = 159575Number Of Rows Found :1<BR>$tempCalculation=-13.65<BR>START :7.84<BR>END :6.77<BR><BR>Compid Found :159575 Tic Found :AAIGF<BR>FINALAAIGF | 159575<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159575 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes'  AND reportDate >= '2024-03-31' <BR><BR>Number Of Rows Found :3<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies1<BR>oldDecreaseHoldingTotalValue-14202<BR>oldDecreaseHoldingTotalShares-31800<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 0<BR>unchangedHoldingTotalValue 0<BR>unchangedHoldingTotalShares 0<BR><BR><BR>totalSharesHeld6977065<BR>totalSharesValue46857<BR>totalPostionChange-31800<BR>totalValueChange-14202<BR>totalHolders1<BR>COMPID159575<BR>TICAAIGF<BR>CIK9000004041<BR>SHSOUT12090000<BR>NAMEAia Group Ltd<BR>SECTOR999999<BR>CUSIPY002A1105<BR>PRICE6.77must have stayed the same<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies1<BR>oldDecreaseHoldingTotalValue-14202<BR>oldDecreaseHoldingTotalShares-31800<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 1<BR>unchangedHoldingTotalValue -47<BR>unchangedHoldingTotalShares 23413<BR><BR><BR>totalSharesHeld7000478<BR>totalSharesValue47014<BR>totalPostionChange-31800<BR>totalValueChange-14249<BR>totalHolders2<BR>COMPID159575<BR>TICAAIGF<BR>CIK9000004041<BR>SHSOUT12090000<BR>NAMEAia Group Ltd<BR>SECTOR999999<BR>CUSIPY002A1105<BR>PRICE6.77<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies2<BR>oldDecreaseHoldingTotalValue-22825<BR>oldDecreaseHoldingTotalShares-393058<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 1<BR>unchangedHoldingTotalValue -47<BR>unchangedHoldingTotalShares 23413<BR><BR><BR>totalSharesHeld9737246<BR>totalSharesValue65390<BR>totalPostionChange-393058<BR>totalValueChange-22872<BR>totalHolders3<BR>COMPID159575<BR>TICAAIGF<BR>CIK9000004041<BR>SHSOUT12090000<BR>NAMEAia Group Ltd<BR>SECTOR999999<BR>CUSIPY002A1105<BR>PRICE6.77<BR>virgina 0.08<BR><BR>virgina2 -0<BR>SELECT * from sectors where level3num = '999999'Number Of Rows Found :1<BR>The Sector is N/A<BR><BR>CRAIG TOTAL SHARES VALE : 65390<BR><BR>MKCAP81849300/n/ninsert into institSumNewHoldings values(
								 Null,
								'9000004041',
								'159575',
								'Aia Group Ltd',
								'AAIGF',
								'6.77',
								'Y002A1105',
								'12090000',
								'0.08',
								'999999',
								'N/A',
								 '81849300',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '2',
								 '-22825',
								 '-393058',
								 '0',
								 '0',
								 '0',
								 '9737246',
								 '65390',
								 '-393058',
								 '-22872',
								 '3',
								 '1',
								 '-47',
								 '23413',
								 '-0',
								 '-0',
								 '-0',
								 '-0',
								 '8.12', 
 								 '6.85', 
 								 '7.84', 
 								 '-13.65', 


								  NULL,  NULL,NULL)

OKbye