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-03-31'
Number Of Rows Found :5must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -17
unchangedHoldingTotalShares 3460
totalSharesHeld3460
totalSharesValue385
totalPostionChange0
totalValueChange-17
totalHolders1
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-12836
oldDecreaseHoldingTotalShares-50745
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -17
unchangedHoldingTotalShares 3460
totalSharesHeld1946093
totalSharesValue50898
totalPostionChange-50745
totalValueChange-12853
totalHolders2
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-12973
oldDecreaseHoldingTotalShares-51224
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -17
unchangedHoldingTotalShares 3460
totalSharesHeld1949543
totalSharesValue51260
totalPostionChange-51224
totalValueChange-12990
totalHolders3
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-13025
oldDecreaseHoldingTotalShares-51399
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -17
unchangedHoldingTotalShares 3460
totalSharesHeld1957620
totalSharesValue51470
totalPostionChange-51399
totalValueChange-13042
totalHolders4
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-13025
oldDecreaseHoldingTotalShares-51399
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4161
oldIncreaseHoldingTotalShares159967
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -17
unchangedHoldingTotalShares 3460
totalSharesHeld2117587
totalSharesValue55631
totalPostionChange108568
totalValueChange-8881
totalHolders5
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE32.387
virgina 0.09
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 55631
MKCAP75785580/n/ninsert into institSumNewHoldings values(
Null,
'9000004425',
'159959',
'Diageo Plc New Ord',
'DGEAF',
'32.387',
'G42089113',
'2340000',
'0.09',
'999999',
'N/A',
'75785580',
'0',
'0',
'0',
'0',
'0',
'0',
'3',
'-13025',
'-51399',
'1',
'4161',
'159967',
'2117587',
'55631',
'108568',
'-8881',
'5',
'1',
'-17',
'3460',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye