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 >= '2025-03-31'
Number Of Rows Found :17
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-128
oldDecreaseHoldingTotalShares-3708
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld5896
totalSharesValue149
totalPostionChange-3708
totalValueChange-128
totalHolders1
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-128
oldDecreaseHoldingTotalShares-3708
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld42853
totalSharesValue1081
totalPostionChange33249
totalValueChange804
totalHolders2
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-128
oldDecreaseHoldingTotalShares-3708
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-52
oldIncreaseHoldingTotalShares543
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld61693
totalSharesValue1556
totalPostionChange33792
totalValueChange752
totalHolders3
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-128
oldDecreaseHoldingTotalShares-3708
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-52
oldIncreaseHoldingTotalShares543
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 205
totalSharesHeld61898
totalSharesValue1561
totalPostionChange33792
totalValueChange751
totalHolders4
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-128
oldDecreaseHoldingTotalShares-3708
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-52
oldIncreaseHoldingTotalShares543
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7805
totalSharesHeld69498
totalSharesValue1753
totalPostionChange33792
totalValueChange724
totalHolders5
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-3743
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-52
oldIncreaseHoldingTotalShares543
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7805
totalSharesHeld69850
totalSharesValue1762
totalPostionChange33757
totalValueChange722
totalHolders6
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-3743
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue1980
oldIncreaseHoldingTotalShares81143
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7805
totalSharesHeld150450
totalSharesValue3794
totalPostionChange114357
totalValueChange2754
totalHolders7
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-3743
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue1980
oldIncreaseHoldingTotalShares81143
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld150464
totalSharesValue3794
totalPostionChange114357
totalValueChange2754
totalHolders8
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue932
newHoldingTotalShares36957
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-3743
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1987
oldIncreaseHoldingTotalShares81399
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld150764
totalSharesValue3802
totalPostionChange114613
totalValueChange2761
totalHolders9
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue933
newHoldingTotalShares37007
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-3743
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1987
oldIncreaseHoldingTotalShares81399
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld150814
totalSharesValue3803
totalPostionChange114663
totalValueChange2762
totalHolders10
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue933
newHoldingTotalShares37007
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-2002
oldDecreaseHoldingTotalShares-29878
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1987
oldIncreaseHoldingTotalShares81399
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld414499
totalSharesValue10398
totalPostionChange88528
totalValueChange890
totalHolders11
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue933
newHoldingTotalShares37007
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-2002
oldDecreaseHoldingTotalShares-29878
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1843
oldIncreaseHoldingTotalShares81549
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld455783
totalSharesValue11439
totalPostionChange88678
totalValueChange746
totalHolders12
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue933
newHoldingTotalShares37007
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-2152
oldDecreaseHoldingTotalShares-31700
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1843
oldIncreaseHoldingTotalShares81549
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld482752
totalSharesValue12119
totalPostionChange86856
totalValueChange596
totalHolders13
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies3
newHoldingTotalValue936
newHoldingTotalShares37125
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-2152
oldDecreaseHoldingTotalShares-31700
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1843
oldIncreaseHoldingTotalShares81549
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld482870
totalSharesValue12122
totalPostionChange86974
totalValueChange599
totalHolders14
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies4
newHoldingTotalValue939
newHoldingTotalShares37272
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-2152
oldDecreaseHoldingTotalShares-31700
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1843
oldIncreaseHoldingTotalShares81549
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 7819
totalSharesHeld483017
totalSharesValue12125
totalPostionChange87121
totalValueChange602
totalHolders15
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies4
newHoldingTotalValue939
newHoldingTotalShares37272
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-2152
oldDecreaseHoldingTotalShares-31700
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1843
oldIncreaseHoldingTotalShares81549
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue -28
unchangedHoldingTotalShares 27819
totalSharesHeld503017
totalSharesValue12625
totalPostionChange87121
totalValueChange602
totalHolders16
COMPID160337
TICSFTBY
CIK0001065521
SHSOUT3720000
NAMESoftbank Corp Unsp ADR
SECTOR999999
CUSIP83404D109
PRICE24.55must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies4
newHoldingTotalValue939
newHoldingTotalShares37272
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-2152
oldDecreaseHoldingTotalShares-31700
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue1843
oldIncreaseHoldingTotalShares81549
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue -29
unchangedHoldingTotalShares 27868
totalSharesHeld503066
totalSharesValue12626
totalPostionChange87121
totalValueChange601
totalHolders17
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 : 12626
MKCAP91326000/n/ninsert into institSumNewHoldings values(
Null,
'0001065521',
'160337',
'Softbank Corp Unsp ADR',
'SFTBY',
'24.55',
'83404D109',
'3720000',
'0.01',
'999999',
'N/A',
'91326000',
'0',
'0',
'0',
'4',
'939',
'37272',
'4',
'-2152',
'-31700',
'4',
'1843',
'81549',
'503066',
'12626',
'87121',
'601',
'17',
'5',
'-29',
'27868',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye