Compid = 145589Number Of Rows Found :1<BR>$tempCalculation=0<BR>START :<BR>END :1.17<BR><BR>Compid Found :145589 Tic Found :BKEAY<BR>FINALBKEAY | 145589<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =145589 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 :1must have stayed the same<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies0<BR>oldDecreaseHoldingTotalValue0<BR>oldDecreaseHoldingTotalShares0<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 1<BR>unchangedHoldingTotalValue -2<BR>unchangedHoldingTotalShares 45214<BR><BR><BR>totalSharesHeld45214<BR>totalSharesValue54<BR>totalPostionChange0<BR>totalValueChange-2<BR>totalHolders1<BR>COMPID145589<BR>TICBKEAY<BR>CIK<BR>SHSOUT1849000<BR>NAMEBank of East Asia Ltd.<BR>SECTOR301002<BR>CUSIP061874103<BR>PRICE1.17<BR>virgina 0<BR><BR>virgina2 0<BR>SELECT * from sectors where level3num = '301002'Number Of Rows Found :1<BR>The Sector is Foreign Regional Banks<BR><BR>CRAIG TOTAL SHARES VALE : 54<BR><BR>MKCAP2163330/n/ninsert into institSumNewHoldings values(
								 Null,
								'',
								'145589',
								'Bank of East Asia Ltd.',
								'BKEAY',
								'1.17',
								'061874103',
								'1849000',
								'0',
								'301002',
								'Foreign Regional Banks',
								 '2163330',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '45214',
								 '54',
								 '0',
								 '-2',
								 '1',
								 '1',
								 '-2',
								 '45214',
								 '0',
								 '0',
								 '0',
								 '0',
								 '', 
 								 '', 
 								 '', 
 								 '0', 


								  NULL,  NULL,NULL)

OKbye