Compid = 160352Number Of Rows Found :1
$tempCalculation=0
START :
END :30.18

Compid Found :160352 Tic Found :DSNKY
FINALDSNKY | 160352

Split info : 1

START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =160352 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'

Number Of Rows Found :13must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld83
totalSharesValue2
totalPostionChange0
totalValueChange0
totalHolders1
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld83
totalSharesValue2
totalPostionChange-56
totalValueChange-2
totalHolders1
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue573
oldIncreaseHoldingTotalShares8798
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld74565
totalSharesValue2371
totalPostionChange8742
totalValueChange571
totalHolders2
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue601
oldIncreaseHoldingTotalShares9584
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld76989
totalSharesValue2448
totalPostionChange9528
totalValueChange599
totalHolders3
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares23
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue601
oldIncreaseHoldingTotalShares9584
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld77012
totalSharesValue2449
totalPostionChange9551
totalValueChange600
totalHolders4
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies2
newHoldingTotalValue2
newHoldingTotalShares39
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue601
oldIncreaseHoldingTotalShares9584
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld77028
totalSharesValue2450
totalPostionChange9567
totalValueChange601
totalHolders5
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies2
newHoldingTotalValue2
newHoldingTotalShares39
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue794
oldIncreaseHoldingTotalShares11279
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld110764
totalSharesValue3523
totalPostionChange11262
totalValueChange794
totalHolders6
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies3
newHoldingTotalValue221
newHoldingTotalShares6928
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue794
oldIncreaseHoldingTotalShares11279
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld117653
totalSharesValue3742
totalPostionChange18151
totalValueChange1013
totalHolders7
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies3
newHoldingTotalValue221
newHoldingTotalShares6928
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue795
oldIncreaseHoldingTotalShares11302
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld117813
totalSharesValue3747
totalPostionChange18174
totalValueChange1014
totalHolders8
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies3
newHoldingTotalValue221
newHoldingTotalShares6928
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue996
oldIncreaseHoldingTotalShares14702
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld142183
totalSharesValue4522
totalPostionChange21574
totalValueChange1215
totalHolders9
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies3
newHoldingTotalValue221
newHoldingTotalShares6928
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue999
oldIncreaseHoldingTotalShares14812
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld142293
totalSharesValue4525
totalPostionChange21684
totalValueChange1218
totalHolders10
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18

liquidatedTotalCompanies1
liquidatedTotalValue-2
liquidatedTotalShares-56
newHoldingTotalCompanies4
newHoldingTotalValue433
newHoldingTotalShares13579
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1333
oldIncreaseHoldingTotalShares16533
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 83

totalSharesHeld216585
totalSharesValue6881
totalPostionChange30056
totalValueChange1764
totalHolders12
COMPID160352
TICDSNKY
CIK0001340156
SHSOUT1940000
NAMEDaiichi Sankyo S ADR
SECTOR999999
CUSIP23381D102
PRICE30.18
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 : 6881

MKCAP58549200/n/ninsert into institSumNewHoldings values( Null, '0001340156', '160352', 'Daiichi Sankyo S ADR', 'DSNKY', '30.18', '23381D102', '1940000', '0.01', '999999', 'N/A', '58549200', '1', '-2', '-56', '4', '433', '13579', '0', '0', '0', '7', '1333', '16533', '216585', '6881', '30056', '1764', '12', '1', '0', '83', '0', '0', '0', '0', '', '', '', '0', NULL, NULL,NULL) OKbye