Compid = 160337Number Of Rows Found :1
$tempCalculation=0
START :
END :24.55
Compid Found :160337 Tic Found :SFTBY
FINALSFTBY | 160337
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =160337 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :13
liquidatedTotalCompanies1
liquidatedTotalValue-5
liquidatedTotalShares-220
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-220
totalValueChange-5
totalHolders0
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies1
liquidatedTotalValue-5
liquidatedTotalShares-220
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue55
oldIncreaseHoldingTotalShares1074
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld4022
totalSharesValue119
totalPostionChange854
totalValueChange50
totalHolders1
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies1
liquidatedTotalValue-5
liquidatedTotalShares-220
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue55
oldIncreaseHoldingTotalShares1074
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld11620
totalSharesValue345
totalPostionChange8452
totalValueChange276
totalHolders2
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies2
liquidatedTotalValue-17
liquidatedTotalShares-745
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue55
oldIncreaseHoldingTotalShares1074
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld11620
totalSharesValue345
totalPostionChange7927
totalValueChange264
totalHolders2
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-826
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue55
oldIncreaseHoldingTotalShares1074
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld11620
totalSharesValue345
totalPostionChange7846
totalValueChange262
totalHolders2
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-826
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue323
oldIncreaseHoldingTotalShares3960
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld38208
totalSharesValue1135
totalPostionChange10732
totalValueChange530
totalHolders3
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-826
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue323
oldIncreaseHoldingTotalShares3960
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld38465
totalSharesValue1143
totalPostionChange10712
totalValueChange532
totalHolders4
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-826
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue323
oldIncreaseHoldingTotalShares3960
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 300
totalSharesHeld38765
totalSharesValue1152
totalPostionChange10712
totalValueChange534
totalHolders5
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-826
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue323
oldIncreaseHoldingTotalShares3960
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 133
unchangedHoldingTotalShares 17359
totalSharesHeld55824
totalSharesValue1659
totalPostionChange10712
totalValueChange665
totalHolders6
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies4
liquidatedTotalValue-823
liquidatedTotalShares-37326
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue323
oldIncreaseHoldingTotalShares3960
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 133
unchangedHoldingTotalShares 17359
totalSharesHeld55824
totalSharesValue1659
totalPostionChange-25788
totalValueChange-139
totalHolders6
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies4
liquidatedTotalValue-823
liquidatedTotalShares-37326
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue323
oldIncreaseHoldingTotalShares3960
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 133
unchangedHoldingTotalShares 17475
totalSharesHeld55940
totalSharesValue1662
totalPostionChange-25788
totalValueChange-139
totalHolders7
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies4
liquidatedTotalValue-823
liquidatedTotalShares-37326
newHoldingTotalCompanies1
newHoldingTotalValue226
newHoldingTotalShares7598
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1108
oldIncreaseHoldingTotalShares27710
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 133
unchangedHoldingTotalShares 17475
totalSharesHeld98040
totalSharesValue2851
totalPostionChange-2038
totalValueChange646
totalHolders8
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies4
liquidatedTotalValue-823
liquidatedTotalShares-37326
newHoldingTotalCompanies2
newHoldingTotalValue5499
newHoldingTotalShares185696
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-20
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1108
oldIncreaseHoldingTotalShares27710
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 133
unchangedHoldingTotalShares 17475
totalSharesHeld276138
totalSharesValue8124
totalPostionChange176060
totalValueChange5919
totalHolders9
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
virgina 0.01
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 8124
MKCAP91326000/n/ninsert into institSumNewHoldings values(
Null,
'0001065521',
'160337',
'Softbank Corp Unsp ADR',
'SFTBY',
'24.55',
'83404D109',
'3720000',
'0.01',
'999999',
'N/A',
'91326000',
'4',
'-823',
'-37326',
'2',
'5499',
'185696',
'1',
'2',
'-20',
'3',
'1108',
'27710',
'276138',
'8124',
'176060',
'5919',
'9',
'3',
'133',
'17475',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye