Compid = 139445Number Of Rows Found :1
$tempCalculation=0
START :
END :7.54
Compid Found :139445 Tic Found :NSANY
FINALNSANY | 139445
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =139445 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :4
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares884
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld2729
totalSharesValue22
totalPostionChange884
totalValueChange7
totalHolders1
COMPID139445
TICNSANY
CIK0000800937
SHSOUT1960000
NAMENissan Motor Co Ltd (ADR)
SECTOR101002
CUSIP654744408
PRICE7.54must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue7
oldIncreaseHoldingTotalShares884
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 35266
totalSharesHeld37995
totalSharesValue302
totalPostionChange884
totalValueChange10
totalHolders2
COMPID139445
TICNSANY
CIK0000800937
SHSOUT1960000
NAMENissan Motor Co Ltd (ADR)
SECTOR101002
CUSIP654744408
PRICE7.54
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue105
oldIncreaseHoldingTotalShares13057
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 35266
totalSharesHeld65847
totalSharesValue523
totalPostionChange13057
totalValueChange108
totalHolders3
COMPID139445
TICNSANY
CIK0000800937
SHSOUT1960000
NAMENissan Motor Co Ltd (ADR)
SECTOR101002
CUSIP654744408
PRICE7.54
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue113
oldIncreaseHoldingTotalShares14057
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 35266
totalSharesHeld67147
totalSharesValue533
totalPostionChange14057
totalValueChange116
totalHolders4
COMPID139445
TICNSANY
CIK0000800937
SHSOUT1960000
NAMENissan Motor Co Ltd (ADR)
SECTOR101002
CUSIP654744408
PRICE7.54
virgina 0
virgina2 0
SELECT * from sectors where level3num = '101002'Number Of Rows Found :1
The Sector is Auto Manufacturers
CRAIG TOTAL SHARES VALE : 533
MKCAP14778400/n/ninsert into institSumNewHoldings values(
Null,
'0000800937',
'139445',
'Nissan Motor Co Ltd (ADR)',
'NSANY',
'7.54',
'654744408',
'1960000',
'0',
'101002',
'Auto Manufacturers',
'14778400',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'3',
'113',
'14057',
'67147',
'533',
'14057',
'116',
'4',
'1',
'3',
'35266',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye