Compid = 145506Number Of Rows Found :1
$tempCalculation=0
START :
END :21.897

Compid Found :145506 Tic Found :ATGFF
FINALATGFF | 145506

Split info : 1



START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =145506 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'

Number Of Rows Found :2


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-135
oldDecreaseHoldingTotalShares-12100
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld119000
totalSharesValue2631
totalPostionChange-12100
totalValueChange-135
totalHolders1
COMPID145506
TICATGFF
CIK
SHSOUT279440
NAMEAltaGas Income Trust
SECTOR999999
CUSIP021361100
PRICE21.897


liquidatedTotalCompanies1
liquidatedTotalValue-4714
liquidatedTotalShares-224527
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-135
oldDecreaseHoldingTotalShares-12100
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld119000
totalSharesValue2631
totalPostionChange-236627
totalValueChange-4849
totalHolders1
COMPID145506
TICATGFF
CIK
SHSOUT279440
NAMEAltaGas Income Trust
SECTOR999999
CUSIP021361100
PRICE21.897
virgina 0.04

virgina2 -0.08
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A

CRAIG TOTAL SHARES VALE : 2631

MKCAP6118897.68/n/ninsert into institSumNewHoldings values( Null, '', '145506', 'AltaGas Income Trust', 'ATGFF', '21.897', '021361100', '279440', '0.04', '999999', 'N/A', '6118897.68', '1', '-4714', '-224527', '0', '0', '0', '1', '-135', '-12100', '0', '0', '0', '119000', '2631', '-236627', '-4849', '1', '0', '0', '0', '-0.08', '-2104.8', 'NULL', '-2104.8', '', '', '', '0', NULL, NULL,NULL) OKbye