Compid = 159767Number Of Rows Found :1<BR>$tempCalculation=5.59<BR>START :161<BR>END :170<BR><BR>Compid Found :159767 Tic Found :IFCZF<BR>FINALIFCZF | 159767<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159767 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 :2<BR><HR><BR>liquidatedTotalCompanies0<BR>liquidatedTotalValue0<BR>liquidatedTotalShares0<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies1<BR>oldDecreaseHoldingTotalValue-1094<BR>oldDecreaseHoldingTotalShares-10800<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 0<BR>unchangedHoldingTotalValue 0<BR>unchangedHoldingTotalShares 0<BR><BR><BR>totalSharesHeld71976<BR>totalSharesValue11703<BR>totalPostionChange-10800<BR>totalValueChange-1094<BR>totalHolders1<BR>COMPID159767<BR>TICIFCZF<BR>CIK9000004233<BR>SHSOUT9000<BR>NAMEIntact Finl Corp<BR>SECTOR999999<BR>CUSIP45823T106<BR>PRICE170<BR><HR><BR>liquidatedTotalCompanies1<BR>liquidatedTotalValue-93385<BR>liquidatedTotalShares-606984<BR>newHoldingTotalCompanies0<BR>newHoldingTotalValue0<BR>newHoldingTotalShares0<BR>oldDecreaseHoldingTotalCompanies1<BR>oldDecreaseHoldingTotalValue-1094<BR>oldDecreaseHoldingTotalShares-10800<BR>oldIncreaseHoldingTotalCompanies0<BR>oldIncreaseHoldingTotalValue0<BR>oldIncreaseHoldingTotalShares0<BR>unchangedHoldingTotalCompanies 0<BR>unchangedHoldingTotalValue 0<BR>unchangedHoldingTotalShares 0<BR><BR><BR>totalSharesHeld71976<BR>totalSharesValue11703<BR>totalPostionChange-617784<BR>totalValueChange-94479<BR>totalHolders1<BR>COMPID159767<BR>TICIFCZF<BR>CIK9000004233<BR>SHSOUT9000<BR>NAMEIntact Finl Corp<BR>SECTOR999999<BR>CUSIP45823T106<BR>PRICE170<BR>virgina 0.8<BR><BR>virgina2 -6.86<BR>SELECT * from sectors where level3num = '999999'Number Of Rows Found :1<BR>The Sector is N/A<BR><BR>CRAIG TOTAL SHARES VALE : 11703<BR><BR>MKCAP1530000/n/ninsert into institSumNewHoldings values(
								 Null,
								'9000004233',
								'159767',
								'Intact Finl Corp',
								'IFCZF',
								'170',
								'45823T106',
								'9000',
								'0.8',
								'999999',
								'N/A',
								 '1530000',
								 '1',
								 '-93385',
								 '-606984',
								 '0',
								 '0',
								 '0',
								 '1',
								 '-1094',
								 '-10800',
								 '0',
								 '0',
								 '0',
								 '71976',
								 '11703',
								 '-617784',
								 '-94479',
								 '1',
								 '0',
								 '0',
								 '0',
								 '-6.86',
								 '-802825.8',
								 'NULL',
								 '-802825.8',
								 '153.02', 
 								 '162.12', 
 								 '161', 
 								 '5.59', 


								  NULL,  NULL,NULL)

OKbye