Compid = 145376Number Of Rows Found :1
$tempCalculation=0
START :
END :119.74

Compid Found :145376 Tic Found :ADDYY
FINALADDYY | 145376

Split info : 1

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

Number Of Rows Found :18

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld494
totalSharesValue55
totalPostionChange54
totalValueChange16
totalHolders1
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-102
oldDecreaseHoldingTotalShares-3872
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld28437
totalSharesValue3187
totalPostionChange-3818
totalValueChange-86
totalHolders2
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-102
oldDecreaseHoldingTotalShares-3872
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 282
unchangedHoldingTotalShares 27044

totalSharesHeld55481
totalSharesValue6218
totalPostionChange-3818
totalValueChange196
totalHolders3
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-102
oldDecreaseHoldingTotalShares-3872
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 282
unchangedHoldingTotalShares 27044

totalSharesHeld55481
totalSharesValue6218
totalPostionChange-17628
totalValueChange-1209
totalHolders3
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-102
oldDecreaseHoldingTotalShares-3872
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 282
unchangedHoldingTotalShares 27050

totalSharesHeld55487
totalSharesValue6219
totalPostionChange-17628
totalValueChange-1209
totalHolders4
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-105
oldDecreaseHoldingTotalShares-3906
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 282
unchangedHoldingTotalShares 27050

totalSharesHeld55496
totalSharesValue6220
totalPostionChange-17662
totalValueChange-1212
totalHolders5
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-105
oldDecreaseHoldingTotalShares-3906
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 284
unchangedHoldingTotalShares 27180

totalSharesHeld55626
totalSharesValue6235
totalPostionChange-17662
totalValueChange-1210
totalHolders6
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares6
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-105
oldDecreaseHoldingTotalShares-3906
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 284
unchangedHoldingTotalShares 27180

totalSharesHeld55632
totalSharesValue6236
totalPostionChange-17656
totalValueChange-1209
totalHolders7
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares20
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-105
oldDecreaseHoldingTotalShares-3906
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue16
oldIncreaseHoldingTotalShares54
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 284
unchangedHoldingTotalShares 27180

totalSharesHeld55646
totalSharesValue6238
totalPostionChange-17642
totalValueChange-1207
totalHolders8
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares20
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-105
oldDecreaseHoldingTotalShares-3906
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue28
oldIncreaseHoldingTotalShares142
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 284
unchangedHoldingTotalShares 27180

totalSharesHeld55920
totalSharesValue6269
totalPostionChange-17554
totalValueChange-1195
totalHolders9
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares20
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-111
oldDecreaseHoldingTotalShares-4198
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue28
oldIncreaseHoldingTotalShares142
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 284
unchangedHoldingTotalShares 27180

totalSharesHeld58211
totalSharesValue6526
totalPostionChange-17846
totalValueChange-1201
totalHolders10
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares20
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-111
oldDecreaseHoldingTotalShares-4198
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue28
oldIncreaseHoldingTotalShares142
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 346
unchangedHoldingTotalShares 33171

totalSharesHeld64202
totalSharesValue7197
totalPostionChange-17846
totalValueChange-1139
totalHolders11
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-1405
liquidatedTotalShares-13810
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares20
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-111
oldDecreaseHoldingTotalShares-4198
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue28
oldIncreaseHoldingTotalShares142
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 402
unchangedHoldingTotalShares 38543

totalSharesHeld69574
totalSharesValue7799
totalPostionChange-17846
totalValueChange-1083
totalHolders12
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74

liquidatedTotalCompanies2
liquidatedTotalValue-1407
liquidatedTotalShares-13828
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares20
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-129514
oldDecreaseHoldingTotalShares-221600
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue148
oldIncreaseHoldingTotalShares444
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 405
unchangedHoldingTotalShares 38753

totalSharesHeld78818
totalSharesValue8835
totalPostionChange-234964
totalValueChange-130365
totalHolders16
COMPID145376
TICADDYY
CIK
SHSOUT390070
NAMEAdidas AG (New)
SECTOR502008
CUSIP00687A107
PRICE119.74
virgina 0.02

virgina2 -0.06
SELECT * from sectors where level3num = '502008'Number Of Rows Found :1
The Sector is Textile - Apparel Footwear & Accessories

CRAIG TOTAL SHARES VALE : 8835

MKCAP46706981.8/n/ninsert into institSumNewHoldings values( Null, '', '145376', 'Adidas AG (New)', 'ADDYY', '119.74', '00687A107', '390070', '0.02', '502008', 'Textile - Apparel Footwear & Accessories', '46706981.8', '2', '-1407', '-13828', '2', '3', '20', '4', '-129514', '-221600', '4', '148', '444', '78818', '8835', '-234964', '-130365', '16', '6', '405', '38753', '-0.06', '-5301', 'NULL', '-5301', '', '', '', '0', NULL, NULL,NULL) OKbye