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