Compid = 136616Number Of Rows Found :1
$tempCalculation=0
START :
END :3.445

Compid Found :136616 Tic Found :CAAS
FINALCAAS | 136616

Split info : 1

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

Number Of Rows Found :27

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue115
oldIncreaseHoldingTotalShares9100
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld266759
totalSharesValue947
totalPostionChange9100
totalValueChange115
totalHolders1
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-21
oldDecreaseHoldingTotalShares-8254
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue115
oldIncreaseHoldingTotalShares9100
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld286222
totalSharesValue1016
totalPostionChange846
totalValueChange94
totalHolders2
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-28
oldDecreaseHoldingTotalShares-51254
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue115
oldIncreaseHoldingTotalShares9100
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld699316
totalSharesValue2482
totalPostionChange-42154
totalValueChange87
totalHolders3
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-242
oldDecreaseHoldingTotalShares-122899
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue115
oldIncreaseHoldingTotalShares9100
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld753617
totalSharesValue2675
totalPostionChange-113799
totalValueChange-127
totalHolders4
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-99017
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-242
oldDecreaseHoldingTotalShares-122899
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue115
oldIncreaseHoldingTotalShares9100
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld753617
totalSharesValue2675
totalPostionChange-212816
totalValueChange-447
totalHolders4
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-99017
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-242
oldDecreaseHoldingTotalShares-122899
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue115
oldIncreaseHoldingTotalShares9100
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld753617
totalSharesValue2675
totalPostionChange-212816
totalValueChange-447
totalHolders5
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-99017
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-242
oldDecreaseHoldingTotalShares-122899
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld874026
totalSharesValue3102
totalPostionChange-203716
totalValueChange-380
totalHolders6
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-99017
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-237
oldDecreaseHoldingTotalShares-123299
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld894726
totalSharesValue3175
totalPostionChange-204116
totalValueChange-375
totalHolders7
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-99017
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-239
oldDecreaseHoldingTotalShares-124470
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld900599
totalSharesValue3196
totalPostionChange-205287
totalValueChange-377
totalHolders8
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-99017
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-239
oldDecreaseHoldingTotalShares-124470
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 30
unchangedHoldingTotalShares 94022

totalSharesHeld994621
totalSharesValue3530
totalPostionChange-205287
totalValueChange-347
totalHolders9
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-239
oldDecreaseHoldingTotalShares-124470
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 30
unchangedHoldingTotalShares 94022

totalSharesHeld994621
totalSharesValue3530
totalPostionChange-205887
totalValueChange-349
totalHolders9
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445must have stayed the same

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-239
oldDecreaseHoldingTotalShares-124470
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 96692

totalSharesHeld997291
totalSharesValue3540
totalPostionChange-205887
totalValueChange-348
totalHolders10
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-245
oldDecreaseHoldingTotalShares-126380
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 96692

totalSharesHeld997447
totalSharesValue3541
totalPostionChange-207797
totalValueChange-354
totalHolders11
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-254
oldDecreaseHoldingTotalShares-129094
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 96692

totalSharesHeld997724
totalSharesValue3542
totalPostionChange-210511
totalValueChange-363
totalHolders12
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue-280
oldDecreaseHoldingTotalShares-145186
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 96692

totalSharesHeld1078910
totalSharesValue3830
totalPostionChange-226603
totalValueChange-389
totalHolders13
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445must have stayed the same

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue-280
oldDecreaseHoldingTotalShares-145186
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18200
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 53
unchangedHoldingTotalShares 168062

totalSharesHeld1150280
totalSharesValue4083
totalPostionChange-226603
totalValueChange-367
totalHolders14
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue-280
oldDecreaseHoldingTotalShares-145186
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares18229
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 53
unchangedHoldingTotalShares 168062

totalSharesHeld1151170
totalSharesValue4086
totalPostionChange-226574
totalValueChange-367
totalHolders15
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies2
liquidatedTotalValue-322
liquidatedTotalShares-99617
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue-280
oldDecreaseHoldingTotalShares-145186
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue183
oldIncreaseHoldingTotalShares18262
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 53
unchangedHoldingTotalShares 168062

totalSharesHeld1155203
totalSharesValue4100
totalPostionChange-226541
totalValueChange-366
totalHolders16
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445

liquidatedTotalCompanies3
liquidatedTotalValue-399
liquidatedTotalShares-123573
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies9
oldDecreaseHoldingTotalValue-299
oldDecreaseHoldingTotalShares-151326
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue310
oldIncreaseHoldingTotalShares46257
unchangedHoldingTotalCompanies 8
unchangedHoldingTotalValue 71
unchangedHoldingTotalShares 224740

totalSharesHeld1332086
totalSharesValue4727
totalPostionChange-228642
totalValueChange-317
totalHolders24
COMPID136616
TICCAAS
CIK0001157762
SHSOUT30850
NAMEChina Automotive Systems Inc
SECTOR101003
CUSIP16936R105
PRICE3.445
virgina 4.32

virgina2 -0.74
SELECT * from sectors where level3num = '101003'Number Of Rows Found :1
The Sector is Auto Parts

CRAIG TOTAL SHARES VALE : 4727

MKCAP106278.25/n/ninsert into institSumNewHoldings values( Null, '0001157762', '136616', 'China Automotive Systems Inc', 'CAAS', '3.445', '16936R105', '30850', '4.32', '101003', 'Auto Parts', '106278.25', '3', '-399', '-123573', '0', '0', '0', '9', '-299', '-151326', '7', '310', '46257', '1332086', '4727', '-228642', '-317', '24', '8', '71', '224740', '-0.74', '-34979.8', 'NULL', '-34979.8', '', '', '', '0', NULL, NULL,NULL) OKbye