Compid = 145468Number Of Rows Found :1
$tempCalculation=0
START :
END :16.265
Compid Found :145468 Tic Found :APELY
FINALAPELY | 145468
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =145468 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
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-85
oldIncreaseHoldingTotalShares5991
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld107769
totalSharesValue1688
totalPostionChange5991
totalValueChange-85
totalHolders1
COMPID145468
TICAPELY
CIK
SHSOUT0
NAMEAlps Electric Co., Ltd. (Japan)
SECTOR999999
CUSIP021090204
PRICE16.265
virgina 0
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 1688
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'',
'145468',
'Alps Electric Co., Ltd. (Japan)',
'APELY',
'16.265',
'021090204',
'0',
'0',
'999999',
'N/A',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'-85',
'5991',
'107769',
'1688',
'5991',
'-85',
'1',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye