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