Compid = 141843Number Of Rows Found :1
$tempCalculation=0
START :
END :78.694

Compid Found :141843 Tic Found :DDAIF
FINALDDAIF | 141843

Split info : 1



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

Number Of Rows Found :9


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue178
oldDecreaseHoldingTotalShares-280
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0


totalSharesHeld18563
totalSharesValue1480
totalPostionChange-280
totalValueChange178
totalHolders1
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694must have stayed the same


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue178
oldDecreaseHoldingTotalShares-280
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 116
unchangedHoldingTotalShares 10955


totalSharesHeld29518
totalSharesValue2353
totalPostionChange-280
totalValueChange294
totalHolders2
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 116
unchangedHoldingTotalShares 10955


totalSharesHeld408101
totalSharesValue32531
totalPostionChange-31249
totalValueChange2174
totalHolders3
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694


liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-3900
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 116
unchangedHoldingTotalShares 10955


totalSharesHeld408101
totalSharesValue32531
totalPostionChange-35149
totalValueChange1905
totalHolders3
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-3900
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 119
unchangedHoldingTotalShares 11221


totalSharesHeld408367
totalSharesValue32552
totalPostionChange-35149
totalValueChange1908
totalHolders4
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694


liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-3900
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares10
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 119
unchangedHoldingTotalShares 11221


totalSharesHeld408377
totalSharesValue32553
totalPostionChange-35139
totalValueChange1909
totalHolders5
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-3900
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares10
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 120
unchangedHoldingTotalShares 11306


totalSharesHeld408462
totalSharesValue32560
totalPostionChange-35139
totalValueChange1910
totalHolders6
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694must have stayed the same


liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-3900
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares10
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 123
unchangedHoldingTotalShares 11594


totalSharesHeld408750
totalSharesValue32583
totalPostionChange-35139
totalValueChange1913
totalHolders7
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694


liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-3900
newHoldingTotalCompanies1
newHoldingTotalValue1
newHoldingTotalShares10
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue2058
oldDecreaseHoldingTotalShares-31249
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue18
oldIncreaseHoldingTotalShares200
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 123
unchangedHoldingTotalShares 11594


totalSharesHeld409150
totalSharesValue32615
totalPostionChange-34939
totalValueChange1931
totalHolders8
COMPID141843
TICDDAIF
CIK0001067318
SHSOUT1070000
NAMEDaimler AG
SECTOR101002
CUSIPD1668R123
PRICE78.694
virgina 0.04

virgina2 -0
SELECT * from sectors where level3num = '101002'Number Of Rows Found :1
The Sector is Auto Manufacturers

CRAIG TOTAL SHARES VALE : 32615

MKCAP84202580/n/ninsert into institSumNewHoldings values( Null, '0001067318', '141843', 'Daimler AG', 'DDAIF', '78.694', 'D1668R123', '1070000', '0.04', '101002', 'Auto Manufacturers', '84202580', '1', '-269', '-3900', '1', '1', '10', '2', '2058', '-31249', '1', '18', '200', '409150', '32615', '-34939', '1931', '8', '4', '123', '11594', '-0', '-0', '-0', '-0', '', '', '', '0', NULL, NULL,NULL) OKbye