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-09-30'
Number Of Rows Found :6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-5753
oldDecreaseHoldingTotalShares-144447
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1860054
totalSharesValue44460
totalPostionChange-144447
totalValueChange-5753
totalHolders1
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies1
liquidatedTotalValue-79108
liquidatedTotalShares-3015679
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-5753
oldDecreaseHoldingTotalShares-144447
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1860054
totalSharesValue44460
totalPostionChange-3160126
totalValueChange-84861
totalHolders1
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies1
liquidatedTotalValue-79108
liquidatedTotalShares-3015679
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-5753
oldDecreaseHoldingTotalShares-144447
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue13941
oldIncreaseHoldingTotalShares150601
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld2090295
totalSharesValue66432
totalPostionChange-3009525
totalValueChange-70920
totalHolders2
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies2
liquidatedTotalValue-79310
liquidatedTotalShares-3023756
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-5753
oldDecreaseHoldingTotalShares-144447
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue13941
oldIncreaseHoldingTotalShares150601
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld2090295
totalSharesValue66432
totalPostionChange-3017602
totalValueChange-71122
totalHolders2
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-79310
liquidatedTotalShares-3023756
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-5753
oldDecreaseHoldingTotalShares-144447
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue13941
oldIncreaseHoldingTotalShares150601
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -19
unchangedHoldingTotalShares 3450
totalSharesHeld2093745
totalSharesValue66761
totalPostionChange-3017602
totalValueChange-71141
totalHolders3
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-79310
liquidatedTotalShares-3023756
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-5753
oldDecreaseHoldingTotalShares-144447
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue13941
oldIncreaseHoldingTotalShares150601
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -53
unchangedHoldingTotalShares 6910
totalSharesHeld2097205
totalSharesValue67092
totalPostionChange-3017602
totalValueChange-71175
totalHolders4
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
virgina 0.09
virgina2 -0.13
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 67092
MKCAP75785580/n/ninsert into institSumNewHoldings values(
Null,
'9000004425',
'159959',
'Diageo Plc New Ord',
'DGEAF',
'32.387',
'G42089113',
'2340000',
'0.09',
'999999',
'N/A',
'75785580',
'2',
'-79310',
'-3023756',
'0',
'0',
'0',
'1',
'-5753',
'-144447',
'1',
'13941',
'150601',
'2097205',
'67092',
'-3017602',
'-71175',
'4',
'2',
'-53',
'6910',
'-0.13',
'-87219.6',
'NULL',
'-87219.6',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye