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-06-30'

Number Of Rows Found :12


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld4722
totalSharesValue39
totalPostionChange326
totalValueChange4
totalHolders1
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-118
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld5008
totalSharesValue41
totalPostionChange208
totalValueChange3
totalHolders2
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6must have stayed the same


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-118
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 22
unchangedHoldingTotalShares 16715


totalSharesHeld21723
totalSharesValue173
totalPostionChange208
totalValueChange25
totalHolders3
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-118
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares326
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 22
unchangedHoldingTotalShares 16715


totalSharesHeld21723
totalSharesValue173
totalPostionChange-103
totalValueChange23
totalHolders3
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-118
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue655
oldIncreaseHoldingTotalShares20446
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 22
unchangedHoldingTotalShares 16715


totalSharesHeld414419
totalSharesValue3279
totalPostionChange20017
totalValueChange674
totalHolders4
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-177
oldDecreaseHoldingTotalShares-36084
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue655
oldIncreaseHoldingTotalShares20446
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 22
unchangedHoldingTotalShares 16715


totalSharesHeld456075
totalSharesValue3611
totalPostionChange-15949
totalValueChange498
totalHolders5
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies1
newHoldingTotalValue390
newHoldingTotalShares48949
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-177
oldDecreaseHoldingTotalShares-36084
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue655
oldIncreaseHoldingTotalShares20446
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 22
unchangedHoldingTotalShares 16715


totalSharesHeld505024
totalSharesValue4001
totalPostionChange33000
totalValueChange888
totalHolders6
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies1
newHoldingTotalValue390
newHoldingTotalShares48949
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue86
oldDecreaseHoldingTotalShares-41592
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue655
oldIncreaseHoldingTotalShares20446
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 22
unchangedHoldingTotalShares 16715


totalSharesHeld731947
totalSharesValue5796
totalPostionChange27492
totalValueChange1151
totalHolders7
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies1
newHoldingTotalValue390
newHoldingTotalShares48949
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue86
oldDecreaseHoldingTotalShares-41592
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue655
oldIncreaseHoldingTotalShares20446
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 30027


totalSharesHeld745259
totalSharesValue5907
totalPostionChange27492
totalValueChange1156
totalHolders8
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies1
newHoldingTotalValue390
newHoldingTotalShares48949
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue86
oldDecreaseHoldingTotalShares-41592
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue785
oldIncreaseHoldingTotalShares33527
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 30027


totalSharesHeld822773
totalSharesValue6551
totalPostionChange40573
totalValueChange1286
totalHolders9
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies1
newHoldingTotalValue390
newHoldingTotalShares48949
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue86
oldDecreaseHoldingTotalShares-41592
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue786
oldIncreaseHoldingTotalShares33618
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 30027


totalSharesHeld822875
totalSharesValue6552
totalPostionChange40664
totalValueChange1287
totalHolders10
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-311
newHoldingTotalCompanies1
newHoldingTotalValue390
newHoldingTotalShares48949
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue86
oldDecreaseHoldingTotalShares-41592
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue786
oldIncreaseHoldingTotalShares33618
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 27
unchangedHoldingTotalShares 30288


totalSharesHeld823136
totalSharesValue6554
totalPostionChange40664
totalValueChange1287
totalHolders11
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 : 6554

MKCAP6996000/n/ninsert into institSumNewHoldings values( Null, '9000000031', '142443', 'Kingfisher ADR', 'KGFHY', '6.6', '495724403', '1060000', '0.08', '999999', 'N/A', '6996000', '1', '-2', '-311', '1', '390', '48949', '3', '86', '-41592', '4', '786', '33618', '823136', '6554', '40664', '1287', '11', '3', '27', '30288', '0', '0', '0', '0', '', '', '', '0', NULL, NULL,NULL) OKbye