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-03-31'
Number Of Rows Found :12
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue107
oldIncreaseHoldingTotalShares14611
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld53595
totalSharesValue350
totalPostionChange14611
totalValueChange107
totalHolders1
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue829
oldIncreaseHoldingTotalShares103541
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld426171
totalSharesValue2805
totalPostionChange103541
totalValueChange829
totalHolders2
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies1
liquidatedTotalValue-109
liquidatedTotalShares-17810
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue829
oldIncreaseHoldingTotalShares103541
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld426171
totalSharesValue2805
totalPostionChange85731
totalValueChange720
totalHolders2
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue829
oldIncreaseHoldingTotalShares103541
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld426171
totalSharesValue2805
totalPostionChange69531
totalValueChange619
totalHolders2
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue830
oldIncreaseHoldingTotalShares103641
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld426575
totalSharesValue2808
totalPostionChange69631
totalValueChange620
totalHolders3
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-449
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue830
oldIncreaseHoldingTotalShares103641
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld429690
totalSharesValue2829
totalPostionChange69182
totalValueChange619
totalHolders4
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-6402
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue830
oldIncreaseHoldingTotalShares103641
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld662121
totalSharesValue4361
totalPostionChange63229
totalValueChange694
totalHolders5
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-6402
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue944
oldIncreaseHoldingTotalShares117942
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld739743
totalSharesValue4869
totalPostionChange77530
totalValueChange808
totalHolders6
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-6402
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue944
oldIncreaseHoldingTotalShares117942
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 13312
totalSharesHeld753055
totalSharesValue4956
totalPostionChange77530
totalValueChange812
totalHolders7
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-6402
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue944
oldIncreaseHoldingTotalShares117942
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 13623
totalSharesHeld753366
totalSharesValue4958
totalPostionChange77530
totalValueChange812
totalHolders8
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-6402
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue959
oldIncreaseHoldingTotalShares119122
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 13623
totalSharesHeld770081
totalSharesValue5068
totalPostionChange78710
totalValueChange827
totalHolders9
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
liquidatedTotalCompanies2
liquidatedTotalValue-210
liquidatedTotalShares-34010
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares261
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-6402
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue959
oldIncreaseHoldingTotalShares119122
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 13623
totalSharesHeld770342
totalSharesValue5070
totalPostionChange78971
totalValueChange829
totalHolders10
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.6
virgina 0.07
virgina2 0.01
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 5070
MKCAP6996000/n/ninsert into institSumNewHoldings values(
Null,
'9000000031',
'142443',
'Kingfisher ADR',
'KGFHY',
'6.6',
'495724403',
'1060000',
'0.07',
'999999',
'N/A',
'6996000',
'2',
'-210',
'-34010',
'1',
'2',
'261',
'2',
'74',
'-6402',
'5',
'959',
'119122',
'770342',
'5070',
'78971',
'829',
'10',
'2',
'4',
'13623',
'0.01',
'NULL',
'507',
'507',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye