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-06-30'
Number Of Rows Found :12
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue8
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld897
totalSharesValue37
totalPostionChange126
totalValueChange8
totalHolders1
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue135
oldDecreaseHoldingTotalShares-84
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue8
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld32592
totalSharesValue1360
totalPostionChange42
totalValueChange143
totalHolders2
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue137
oldDecreaseHoldingTotalShares-88
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue8
oldIncreaseHoldingTotalShares126
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld33096
totalSharesValue1381
totalPostionChange38
totalValueChange145
totalHolders3
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue137
oldDecreaseHoldingTotalShares-88
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue9
oldIncreaseHoldingTotalShares139
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld33213
totalSharesValue1386
totalPostionChange51
totalValueChange146
totalHolders4
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue137
oldDecreaseHoldingTotalShares-88
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue9
oldIncreaseHoldingTotalShares139
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld33430
totalSharesValue1395
totalPostionChange51
totalValueChange147
totalHolders5
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue192
oldDecreaseHoldingTotalShares-690
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue9
oldIncreaseHoldingTotalShares139
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld51234
totalSharesValue2138
totalPostionChange-551
totalValueChange202
totalHolders6
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue192
oldDecreaseHoldingTotalShares-690
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue116
oldIncreaseHoldingTotalShares1614
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld63321
totalSharesValue2642
totalPostionChange924
totalValueChange309
totalHolders7
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue192
oldDecreaseHoldingTotalShares-690
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue205
oldIncreaseHoldingTotalShares2459
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld76571
totalSharesValue3194
totalPostionChange1769
totalValueChange398
totalHolders8
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue192
oldDecreaseHoldingTotalShares-690
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue267
oldIncreaseHoldingTotalShares3381
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld82920
totalSharesValue3459
totalPostionChange2691
totalValueChange460
totalHolders9
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue529
oldDecreaseHoldingTotalShares-2126
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue267
oldIncreaseHoldingTotalShares3381
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 217
totalSharesHeld172865
totalSharesValue7207
totalPostionChange1255
totalValueChange797
totalHolders10
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue529
oldDecreaseHoldingTotalShares-2126
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue267
oldIncreaseHoldingTotalShares3381
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 241
totalSharesHeld172889
totalSharesValue7208
totalPostionChange1255
totalValueChange797
totalHolders11
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue529
oldDecreaseHoldingTotalShares-2126
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue267
oldIncreaseHoldingTotalShares3381
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 45
unchangedHoldingTotalShares 10241
totalSharesHeld182889
totalSharesValue7625
totalPostionChange1255
totalValueChange841
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 : 7625
MKCAP31972500/n/ninsert into institSumNewHoldings values(
Null,
'0001012854',
'151948',
'Koninklijke Ahold',
'ADRNY',
'30.45',
'500467501',
'1050000',
'0.02',
'107007',
'Food Wholesale',
'31972500',
'0',
'0',
'0',
'0',
'0',
'0',
'4',
'529',
'-2126',
'5',
'267',
'3381',
'182889',
'7625',
'1255',
'841',
'12',
'3',
'45',
'10241',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye