Compid = 145465Number Of Rows Found :1
$tempCalculation=0
START :
END :21.05
Compid Found :145465 Tic Found :AONNY
FINALAONNY | 145465
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =145465 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
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares-11
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld34
totalSharesValue1
totalPostionChange-11
totalValueChange0
totalHolders1
COMPID145465
TICAONNY
CIK
SHSOUT765024
NAMEAeon Co. Ltd. (Japan)
SECTOR999999
CUSIP007627102
PRICE21.05
liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-42
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares-11
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld34
totalSharesValue1
totalPostionChange-53
totalValueChange-1
totalHolders1
COMPID145465
TICAONNY
CIK
SHSOUT765024
NAMEAeon Co. Ltd. (Japan)
SECTOR999999
CUSIP007627102
PRICE21.05
virgina 0
virgina2 -0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 1
MKCAP16103755.2/n/ninsert into institSumNewHoldings values(
Null,
'',
'145465',
'Aeon Co. Ltd. (Japan)',
'AONNY',
'21.05',
'007627102',
'765024',
'0',
'999999',
'N/A',
'16103755.2',
'1',
'-1',
'-42',
'0',
'0',
'0',
'1',
'0',
'-11',
'0',
'0',
'0',
'34',
'1',
'-53',
'-1',
'1',
'0',
'0',
'0',
'-0',
'-0',
'-0',
'-0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye