Compid = 142443Number Of Rows Found :1
$tempCalculation=12.54
START :5.74
END :6.46
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 >= '2024-03-31'
Number Of Rows Found :6must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 16179
totalSharesHeld16179
totalSharesValue102
totalPostionChange0
totalValueChange2
totalHolders1
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.46
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares100
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 16179
totalSharesHeld16556
totalSharesValue104
totalPostionChange100
totalValueChange2
totalHolders2
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.46must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares100
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 17111
totalSharesHeld17488
totalSharesValue110
totalPostionChange100
totalValueChange2
totalHolders3
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.46
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue15
oldIncreaseHoldingTotalShares2551
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 17111
totalSharesHeld29699
totalSharesValue187
totalPostionChange2551
totalValueChange17
totalHolders4
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.46
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue25
oldIncreaseHoldingTotalShares4114
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 17111
totalSharesHeld47779
totalSharesValue301
totalPostionChange4114
totalValueChange27
totalHolders5
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.46
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue52
oldIncreaseHoldingTotalShares8050
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 17111
totalSharesHeld76784
totalSharesValue484
totalPostionChange8050
totalValueChange54
totalHolders6
COMPID142443
TICKGFHY
CIK9000000031
SHSOUT1060000
NAMEKingfisher ADR
SECTOR999999
CUSIP495724403
PRICE6.46
virgina 0.01
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 484
MKCAP6847600/n/ninsert into institSumNewHoldings values(
Null,
'9000000031',
'142443',
'Kingfisher ADR',
'KGFHY',
'6.46',
'495724403',
'1060000',
'0.01',
'999999',
'N/A',
'6847600',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'4',
'52',
'8050',
'76784',
'484',
'8050',
'54',
'6',
'2',
'2',
'17111',
'0',
'0',
'0',
'0',
'6.06',
'6.3',
'5.74',
'12.54',
NULL, NULL,NULL)
OKbye