Compid = 155021Number Of Rows Found :1
$tempCalculation=0
START :
END :37.83
Compid Found :155021 Tic Found :BAMX.Y
FINALBAMX.Y | 155021
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =155021 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :13
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-500
totalValueChange-19
totalHolders0
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 2904
totalSharesHeld2904
totalSharesValue112
totalPostionChange-500
totalValueChange-15
totalHolders1
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue133
oldIncreaseHoldingTotalShares2998
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 2904
totalSharesHeld19520
totalSharesValue752
totalPostionChange2498
totalValueChange118
totalHolders2
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-698
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue133
oldIncreaseHoldingTotalShares2998
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 2904
totalSharesHeld41145
totalSharesValue1585
totalPostionChange1800
totalValueChange120
totalHolders3
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-698
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3344
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 2904
totalSharesHeld42972
totalSharesValue1655
totalPostionChange2146
totalValueChange138
totalHolders4
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue2
oldDecreaseHoldingTotalShares-698
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3344
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 6904
totalSharesHeld46972
totalSharesValue1809
totalPostionChange2146
totalValueChange143
totalHolders5
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3344
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 6904
totalSharesHeld77115
totalSharesValue2970
totalPostionChange1446
totalValueChange159
totalHolders6
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-500
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3347
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 6904
totalSharesHeld77190
totalSharesValue2973
totalPostionChange1449
totalValueChange159
totalHolders7
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies2
liquidatedTotalValue-19
liquidatedTotalShares-501
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3347
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 6904
totalSharesHeld77190
totalSharesValue2973
totalPostionChange1448
totalValueChange159
totalHolders7
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-502
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3347
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 6904
totalSharesHeld77190
totalSharesValue2973
totalPostionChange1447
totalValueChange159
totalHolders7
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies4
liquidatedTotalValue-225
liquidatedTotalShares-6042
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3347
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 6904
totalSharesHeld77190
totalSharesValue2973
totalPostionChange-4093
totalValueChange-47
totalHolders7
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83must have stayed the same
liquidatedTotalCompanies4
liquidatedTotalValue-225
liquidatedTotalShares-6042
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3347
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 7031
totalSharesHeld77317
totalSharesValue2978
totalPostionChange-4093
totalValueChange-47
totalHolders8
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
liquidatedTotalCompanies5
liquidatedTotalValue-3463
liquidatedTotalShares-93042
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue18
oldDecreaseHoldingTotalShares-1398
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue151
oldIncreaseHoldingTotalShares3347
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 9
unchangedHoldingTotalShares 7031
totalSharesHeld77317
totalSharesValue2978
totalPostionChange-91093
totalValueChange-3285
totalHolders8
COMPID155021
TICBAMX.Y
CIK9000002952
SHSOUT601995
NAMEBayerische Motoren Werke AG
SECTOR101002
CUSIP072743305
PRICE37.83
virgina 0.01
virgina2 -0.02
SELECT * from sectors where level3num = '101002'Number Of Rows Found :1
The Sector is Auto Manufacturers
CRAIG TOTAL SHARES VALE : 2978
MKCAP22773470.85/n/ninsert into institSumNewHoldings values(
Null,
'9000002952',
'155021',
'Bayerische Motoren Werke AG',
'BAMX.Y',
'37.83',
'072743305',
'601995',
'0.01',
'101002',
'Auto Manufacturers',
'22773470.85',
'5',
'-3463',
'-93042',
'0',
'0',
'0',
'2',
'18',
'-1398',
'3',
'151',
'3347',
'77317',
'2978',
'-91093',
'-3285',
'8',
'3',
'9',
'7031',
'-0.02',
'-595.6',
'NULL',
'-595.6',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye