Compid = 147566Number Of Rows Found :1
$tempCalculation=0
START :
END :8.94
Compid Found :147566 Tic Found :YAMHF
FINALYAMHF | 147566
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =147566 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue48
oldDecreaseHoldingTotalShares-1300
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld239600
totalSharesValue2200
totalPostionChange-1300
totalValueChange48
totalHolders1
COMPID147566
TICYAMHF
CIK
SHSOUT0
NAMEYamaha Motor Co., Ltd. (Japan)
SECTOR101004
CUSIPJ95776126
PRICE8.94
virgina 0
virgina2 0
SELECT * from sectors where level3num = '101004'Number Of Rows Found :1
The Sector is Recreational Vehicles
CRAIG TOTAL SHARES VALE : 2200
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'',
'147566',
'Yamaha Motor Co., Ltd. (Japan)',
'YAMHF',
'8.94',
'J95776126',
'0',
'0',
'101004',
'Recreational Vehicles',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'48',
'-1300',
'0',
'0',
'0',
'239600',
'2200',
'-1300',
'48',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye