Compid = 139443Number Of Rows Found :1
$tempCalculation=0
START :
END :25.14
Compid Found :139443 Tic Found :TTM
FINALTTM | 139443
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =139443 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders1
COMPID139443
TICTTM
CIK0000926042
SHSOUT719490
NAMETata Motors Limited (ADR)
SECTOR101002
CUSIP876568502
PRICE25.14
virgina 0
virgina2 0
SELECT * from sectors where level3num = '101002'Number Of Rows Found :1
The Sector is Auto Manufacturers
CRAIG TOTAL SHARES VALE : 0
MKCAP18087978.6/n/ninsert into institSumNewHoldings values(
Null,
'0000926042',
'139443',
'Tata Motors Limited (ADR)',
'TTM',
'25.14',
'876568502',
'719490',
'0',
'101002',
'Auto Manufacturers',
'18087978.6',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye