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 >= '2024-03-31'
Number Of Rows Found :18
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue771
oldIncreaseHoldingTotalShares20717
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld146622
totalSharesValue4389
totalPostionChange20717
totalValueChange771
totalHolders1
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue771
oldIncreaseHoldingTotalShares20717
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld146747
totalSharesValue4393
totalPostionChange20664
totalValueChange770
totalHolders2
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue9
newHoldingTotalShares300
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue771
oldIncreaseHoldingTotalShares20717
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld147047
totalSharesValue4402
totalPostionChange20964
totalValueChange779
totalHolders3
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-7
liquidatedTotalShares-242
newHoldingTotalCompanies1
newHoldingTotalValue9
newHoldingTotalShares300
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue771
oldIncreaseHoldingTotalShares20717
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld147047
totalSharesValue4402
totalPostionChange20722
totalValueChange772
totalHolders3
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-7
liquidatedTotalShares-242
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue771
oldIncreaseHoldingTotalShares20717
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld148247
totalSharesValue4438
totalPostionChange21922
totalValueChange808
totalHolders4
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies1
liquidatedTotalValue-7
liquidatedTotalShares-242
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue5063
oldIncreaseHoldingTotalShares120150
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1321341
totalSharesValue39550
totalPostionChange121355
totalValueChange5100
totalHolders5
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue5063
oldIncreaseHoldingTotalShares120150
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1321341
totalSharesValue39550
totalPostionChange112536
totalValueChange4847
totalHolders5
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue5063
oldIncreaseHoldingTotalShares120150
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16597
totalSharesHeld1337938
totalSharesValue40047
totalPostionChange112536
totalValueChange4867
totalHolders6
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue5076
oldIncreaseHoldingTotalShares120572
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16597
totalSharesHeld1338817
totalSharesValue40073
totalPostionChange112958
totalValueChange4880
totalHolders7
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue5127
oldIncreaseHoldingTotalShares121963
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16597
totalSharesHeld1347872
totalSharesValue40344
totalPostionChange114349
totalValueChange4931
totalHolders8
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue5127
oldIncreaseHoldingTotalShares121963
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16701
totalSharesHeld1347976
totalSharesValue40347
totalPostionChange114349
totalValueChange4931
totalHolders9
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue5220
oldIncreaseHoldingTotalShares123882
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16701
totalSharesHeld1378687
totalSharesValue41266
totalPostionChange116268
totalValueChange5024
totalHolders10
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-260
liquidatedTotalShares-9061
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue5220
oldIncreaseHoldingTotalShares123882
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16860
totalSharesHeld1378846
totalSharesValue41271
totalPostionChange116268
totalValueChange5024
totalHolders11
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies3
liquidatedTotalValue-265
liquidatedTotalShares-9235
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-53
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue5220
oldIncreaseHoldingTotalShares123882
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16860
totalSharesHeld1378846
totalSharesValue41271
totalPostionChange116094
totalValueChange5019
totalHolders11
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies3
liquidatedTotalValue-265
liquidatedTotalShares-9235
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-63
oldDecreaseHoldingTotalShares-2582
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue5220
oldIncreaseHoldingTotalShares123882
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16860
totalSharesHeld1387908
totalSharesValue41542
totalPostionChange113565
totalValueChange4957
totalHolders12
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies3
liquidatedTotalValue-265
liquidatedTotalShares-9235
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-78
oldDecreaseHoldingTotalShares-3581
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue5220
oldIncreaseHoldingTotalShares123882
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16860
totalSharesHeld1399084
totalSharesValue41876
totalPostionChange112566
totalValueChange4942
totalHolders13
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies3
liquidatedTotalValue-265
liquidatedTotalShares-9235
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-78
oldDecreaseHoldingTotalShares-3581
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue5436
oldIncreaseHoldingTotalShares125497
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16860
totalSharesHeld1540684
totalSharesValue46115
totalPostionChange114181
totalValueChange5158
totalHolders14
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
liquidatedTotalCompanies4
liquidatedTotalValue-283
liquidatedTotalShares-9851
newHoldingTotalCompanies2
newHoldingTotalValue45
newHoldingTotalShares1500
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-78
oldDecreaseHoldingTotalShares-3581
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue5436
oldIncreaseHoldingTotalShares125497
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 20
unchangedHoldingTotalShares 16860
totalSharesHeld1540684
totalSharesValue46115
totalPostionChange113565
totalValueChange5140
totalHolders14
COMPID151948
TICADRNY
CIK0001012854
SHSOUT1050000
NAMEKoninklijke Ahold
SECTOR107007
CUSIP500467501
PRICE30.45
virgina 0.15
virgina2 0.01
SELECT * from sectors where level3num = '107007'Number Of Rows Found :1
The Sector is Food Wholesale
CRAIG TOTAL SHARES VALE : 46115
MKCAP31972500/n/ninsert into institSumNewHoldings values(
Null,
'0001012854',
'151948',
'Koninklijke Ahold',
'ADRNY',
'30.45',
'500467501',
'1050000',
'0.15',
'107007',
'Food Wholesale',
'31972500',
'4',
'-283',
'-9851',
'2',
'45',
'1500',
'3',
'-78',
'-3581',
'6',
'5436',
'125497',
'1540684',
'46115',
'113565',
'5140',
'14',
'3',
'20',
'16860',
'0.01',
'NULL',
'4611.5',
'4611.5',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye