Compid = 159959Number Of Rows Found :1
$tempCalculation=-13.13
START :36.35
END :31.576
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 >= '2024-03-31'
Number Of Rows Found :6
liquidatedTotalCompanies1
liquidatedTotalValue-5718
liquidatedTotalShares-157212
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-157212
totalValueChange-5718
totalHolders0
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE31.576
liquidatedTotalCompanies1
liquidatedTotalValue-5718
liquidatedTotalShares-157212
newHoldingTotalCompanies1
newHoldingTotalValue251232
newHoldingTotalShares6802658
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld6802658
totalSharesValue251232
totalPostionChange6645446
totalValueChange245514
totalHolders1
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE31.576
liquidatedTotalCompanies1
liquidatedTotalValue-5718
liquidatedTotalShares-157212
newHoldingTotalCompanies1
newHoldingTotalValue251232
newHoldingTotalShares6802658
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-192
oldDecreaseHoldingTotalShares-5389
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld6811110
totalSharesValue251544
totalPostionChange6640057
totalValueChange245322
totalHolders2
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE31.576must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-5718
liquidatedTotalShares-157212
newHoldingTotalCompanies1
newHoldingTotalValue251232
newHoldingTotalShares6802658
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-192
oldDecreaseHoldingTotalShares-5389
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 8
unchangedHoldingTotalShares 4475
totalSharesHeld6815585
totalSharesValue251711
totalPostionChange6640057
totalValueChange245330
totalHolders3
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE31.576
liquidatedTotalCompanies1
liquidatedTotalValue-5718
liquidatedTotalShares-157212
newHoldingTotalCompanies1
newHoldingTotalValue251232
newHoldingTotalShares6802658
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-207
oldDecreaseHoldingTotalShares-5489
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 8
unchangedHoldingTotalShares 4475
totalSharesHeld6819045
totalSharesValue252190
totalPostionChange6639957
totalValueChange245315
totalHolders4
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE31.576
liquidatedTotalCompanies1
liquidatedTotalValue-5718
liquidatedTotalShares-157212
newHoldingTotalCompanies1
newHoldingTotalValue251232
newHoldingTotalShares6802658
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-207
oldDecreaseHoldingTotalShares-5489
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue1180
oldIncreaseHoldingTotalShares30747
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 8
unchangedHoldingTotalShares 4475
totalSharesHeld6920826
totalSharesValue255954
totalPostionChange6670704
totalValueChange246495
totalHolders5
COMPID159959
TICDGEAF
CIK9000004425
SHSOUT2340000
NAMEDiageo Plc New Ord
SECTOR999999
CUSIPG42089113
PRICE31.576
virgina 0.3
virgina2 0.29
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 255954
MKCAP73887840/n/ninsert into institSumNewHoldings values(
Null,
'9000004425',
'159959',
'Diageo Plc New Ord',
'DGEAF',
'31.576',
'G42089113',
'2340000',
'0.3',
'999999',
'N/A',
'73887840',
'1',
'-5718',
'-157212',
'1',
'251232',
'6802658',
'2',
'-207',
'-5489',
'1',
'1180',
'30747',
'6920826',
'255954',
'6670704',
'246495',
'5',
'1',
'8',
'4475',
'0.29',
'NULL',
'742266.6',
'742266.6',
'35.57',
'37.27',
'36.35',
'-13.13',
NULL, NULL,NULL)
OKbye