Compid = 147107Number Of Rows Found :1
$tempCalculation=0
START :
END :52.35
Compid Found :147107 Tic Found :SFTBF
FINALSFTBF | 147107
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =147107 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1
liquidatedTotalCompanies1
liquidatedTotalValue-134
liquidatedTotalShares-3000
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-3000
totalValueChange-134
totalHolders0
COMPID147107
TICSFTBF
CIK
SHSOUT0
NAMESoftbank Corp. (Japan)
SECTOR6040
CUSIPJ75963108
PRICE52.35
virgina 0
virgina2 0
SELECT * from sectors where level3num = '6040'Number Of Rows Found :0
The Sector is
CRAIG TOTAL SHARES VALE : 0
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'',
'147107',
'Softbank Corp. (Japan)',
'SFTBF',
'52.35',
'J75963108',
'0',
'0',
'6040',
'',
'0',
'1',
'-134',
'-3000',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'-3000',
'-134',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye