Compid = 159959Number Of Rows Found :1
$tempCalculation=0
START :
END :32.387
Compid Found :159959 Tic Found :DGEAF
FINALDGEAF | 159959
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159959 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2025-06-30'
Number Of Rows Found :7
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue79108
newHoldingTotalShares3015679
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld3015679
totalSharesValue79108
totalPostionChange3015679
totalValueChange79108
totalHolders1
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue79108
newHoldingTotalShares3015679
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -14
unchangedHoldingTotalShares 3450
totalSharesHeld3019129
totalSharesValue79456
totalPostionChange3015679
totalValueChange79094
totalHolders2
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies1
liquidatedTotalValue-4161
liquidatedTotalShares-159967
newHoldingTotalCompanies1
newHoldingTotalValue79108
newHoldingTotalShares3015679
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -14
unchangedHoldingTotalShares 3450
totalSharesHeld3019129
totalSharesValue79456
totalPostionChange2855712
totalValueChange74933
totalHolders2
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies1
liquidatedTotalValue-4161
liquidatedTotalShares-159967
newHoldingTotalCompanies2
newHoldingTotalValue87139
newHoldingTotalShares3095319
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -14
unchangedHoldingTotalShares 3450
totalSharesHeld3098769
totalSharesValue87487
totalPostionChange2935352
totalValueChange82964
totalHolders3
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-4161
liquidatedTotalShares-159967
newHoldingTotalCompanies2
newHoldingTotalValue87139
newHoldingTotalShares3095319
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -22
unchangedHoldingTotalShares 11527
totalSharesHeld3106846
totalSharesValue87689
totalPostionChange2935352
totalValueChange82956
totalHolders4
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-4161
liquidatedTotalShares-159967
newHoldingTotalCompanies2
newHoldingTotalValue87139
newHoldingTotalShares3095319
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -42
unchangedHoldingTotalShares 14987
totalSharesHeld3110306
totalSharesValue88054
totalPostionChange2935352
totalValueChange82936
totalHolders5
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies1
liquidatedTotalValue-4161
liquidatedTotalShares-159967
newHoldingTotalCompanies2
newHoldingTotalValue87139
newHoldingTotalShares3095319
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-300
oldIncreaseHoldingTotalShares61868
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -42
unchangedHoldingTotalShares 14987
totalSharesHeld5114807
totalSharesValue138267
totalPostionChange2997220
totalValueChange82636
totalHolders6
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
virgina 0.22
virgina2 0.13
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 138267
MKCAP75785580/n/ninsert into institSumNewHoldings values(
Null,
'9000004425',
'159959',
'Diageo Plc New Ord',
'DGEAF',
'32.387',
'G42089113',
'2340000',
'0.22',
'999999',
'N/A',
'75785580',
'1',
'-4161',
'-159967',
'2',
'87139',
'3095319',
'0',
'0',
'0',
'1',
'-300',
'61868',
'5114807',
'138267',
'2997220',
'82636',
'6',
'3',
'-42',
'14987',
'0.13',
'NULL',
'179747.1',
'179747.1',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye