Compid = 142443Number Of Rows Found :1
$tempCalculation=0
START :
END :6.6
Compid Found :142443 Tic Found :KGFHY
FINALKGFHY | 142443
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =142443 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2025-09-30'
Number Of Rows Found :11
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-3
oldDecreaseHoldingTotalShares-1142
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld15573
totalSharesValue129
totalPostionChange-1142
totalValueChange-3
totalHolders1
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-3
oldDecreaseHoldingTotalShares-1142
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld20295
totalSharesValue168
totalPostionChange-816
totalValueChange1
totalHolders2
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue13
oldDecreaseHoldingTotalShares-1228
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld69158
totalSharesValue574
totalPostionChange-902
totalValueChange17
totalHolders3
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-312
oldDecreaseHoldingTotalShares-42039
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld70003
totalSharesValue581
totalPostionChange-41713
totalValueChange-308
totalHolders4
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-312
oldDecreaseHoldingTotalShares-42039
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue556
oldIncreaseHoldingTotalShares49428
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld511801
totalSharesValue4239
totalPostionChange7389
totalValueChange244
totalHolders5
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-286
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-312
oldDecreaseHoldingTotalShares-42039
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue556
oldIncreaseHoldingTotalShares49428
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld511801
totalSharesValue4239
totalPostionChange7103
totalValueChange242
totalHolders5
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-286
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-312
oldDecreaseHoldingTotalShares-42039
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue556
oldIncreaseHoldingTotalShares49428
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 5
unchangedHoldingTotalShares 13312
totalSharesHeld525113
totalSharesValue4350
totalPostionChange7103
totalValueChange247
totalHolders6
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-286
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-312
oldDecreaseHoldingTotalShares-42039
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue686
oldIncreaseHoldingTotalShares62509
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 5
unchangedHoldingTotalShares 13312
totalSharesHeld602627
totalSharesValue4994
totalPostionChange20184
totalValueChange377
totalHolders7
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-286
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-312
oldDecreaseHoldingTotalShares-42039
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue687
oldIncreaseHoldingTotalShares62600
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 5
unchangedHoldingTotalShares 13312
totalSharesHeld602729
totalSharesValue4995
totalPostionChange20275
totalValueChange378
totalHolders8
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-286
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-313
oldDecreaseHoldingTotalShares-52316
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue687
oldIncreaseHoldingTotalShares62600
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 5
unchangedHoldingTotalShares 13312
totalSharesHeld819375
totalSharesValue6789
totalPostionChange9998
totalValueChange377
totalHolders9
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-4
liquidatedTotalShares-547
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-313
oldDecreaseHoldingTotalShares-52316
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue687
oldIncreaseHoldingTotalShares62600
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 5
unchangedHoldingTotalShares 13312
totalSharesHeld819375
totalSharesValue6789
totalPostionChange9737
totalValueChange375
totalHolders9
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
virgina 0.08
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 6789
MKCAP6996000/n/ninsert into institSumNewHoldings values(
Null,
'9000000031',
'142443',
'Kingfisher ADR',
'KGFHY',
'6.6',
'495724403',
'1060000',
'0.08',
'999999',
'N/A',
'6996000',
'2',
'-4',
'-547',
'0',
'0',
'0',
'4',
'-313',
'-52316',
'4',
'687',
'62600',
'819375',
'6789',
'9737',
'375',
'9',
'1',
'5',
'13312',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye