Compid = 151948Number Of Rows Found :1
$tempCalculation=0
START :
END :30.45
Compid Found :151948 Tic Found :ADRNY
FINALADRNY | 151948
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =151948 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2025-03-31'
Number Of Rows Found :13
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue56
oldIncreaseHoldingTotalShares930
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld5427
totalSharesValue203
totalPostionChange930
totalValueChange56
totalHolders1
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue56
oldIncreaseHoldingTotalShares930
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld5427
totalSharesValue203
totalPostionChange-8307
totalValueChange-245
totalHolders1
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue56
oldIncreaseHoldingTotalShares930
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld5644
totalSharesValue211
totalPostionChange-8307
totalValueChange-244
totalHolders2
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue71
oldIncreaseHoldingTotalShares1260
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld6415
totalSharesValue240
totalPostionChange-7977
totalValueChange-229
totalHolders3
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue131
oldIncreaseHoldingTotalShares1523
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld17027
totalSharesValue637
totalPostionChange-7714
totalValueChange-169
totalHolders4
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue388
oldIncreaseHoldingTotalShares4742
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld48806
totalSharesValue1825
totalPostionChange-4495
totalValueChange88
totalHolders5
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue388
oldIncreaseHoldingTotalShares4742
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld49314
totalSharesValue1844
totalPostionChange-4523
totalValueChange90
totalHolders6
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1453
oldIncreaseHoldingTotalShares24168
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld140695
totalSharesValue5255
totalPostionChange14903
totalValueChange1155
totalHolders7
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1453
oldIncreaseHoldingTotalShares24168
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 321
totalSharesHeld140799
totalSharesValue5259
totalPostionChange14903
totalValueChange1156
totalHolders8
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1453
oldIncreaseHoldingTotalShares24168
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 12726
totalSharesHeld153204
totalSharesValue5722
totalPostionChange14903
totalValueChange1214
totalHolders9
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1764
oldIncreaseHoldingTotalShares31019
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 12726
totalSharesHeld171610
totalSharesValue6410
totalPostionChange21754
totalValueChange1525
totalHolders10
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares24
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1764
oldIncreaseHoldingTotalShares31019
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 12726
totalSharesHeld171634
totalSharesValue6411
totalPostionChange21778
totalValueChange1526
totalHolders11
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-301
liquidatedTotalShares-9237
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares24
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-28
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1764
oldIncreaseHoldingTotalShares31019
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 22726
totalSharesHeld181634
totalSharesValue6784
totalPostionChange21778
totalValueChange1526
totalHolders12
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
virgina 0.02
virgina2 0
SELECT * from sectors where level3num = '107007'Number Of Rows Found :1
The Sector is Food Wholesale
CRAIG TOTAL SHARES VALE : 6784
MKCAP31972500/n/ninsert into institSumNewHoldings values(
Null,
'0001012854',
'151948',
'Koninklijke Ahold',
'ADRNY',
'30.45',
'500467501',
'1050000',
'0.02',
'107007',
'Food Wholesale',
'31972500',
'1',
'-301',
'-9237',
'1',
'1',
'24',
'1',
'2',
'-28',
'6',
'1764',
'31019',
'181634',
'6784',
'21778',
'1526',
'12',
'4',
'60',
'22726',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye