Compid = 145463Number Of Rows Found :1
$tempCalculation=0
START :
END :0.3462
Compid Found :145463 Tic Found :ANZFF
FINALANZFF | 145463
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =145463 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 26315
totalSharesHeld26315
totalSharesValue10
totalPostionChange0
totalValueChange-1
totalHolders1
COMPID145463
TICANZFF
CIK
SHSOUT1002730
NAMEAir New Zealand Ltd. (New Zealand)
SECTOR999999
CUSIPQ0169V100
PRICE0.3462
virgina 0
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 10
MKCAP347145.126/n/ninsert into institSumNewHoldings values(
Null,
'',
'145463',
'Air New Zealand Ltd. (New Zealand)',
'ANZFF',
'0.3462',
'Q0169V100',
'1002730',
'0',
'999999',
'N/A',
'347145.126',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'26315',
'10',
'0',
'-1',
'1',
'1',
'-1',
'26315',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye