Compid = 132435Number Of Rows Found :1
$tempCalculation=0
START :
END :1.18
Compid Found :132435 Tic Found :EFOI
FINALEFOI | 132435
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =132435 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :13
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld3296
totalSharesValue5
totalPostionChange-356
totalValueChange-1
totalHolders1
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld3546
totalSharesValue5
totalPostionChange-106
totalValueChange-1
totalHolders2
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld7938
totalSharesValue12
totalPostionChange2060
totalValueChange3
totalHolders3
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 463
totalSharesHeld8401
totalSharesValue13
totalPostionChange2060
totalValueChange3
totalHolders4
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 483
totalSharesHeld8421
totalSharesValue13
totalPostionChange2060
totalValueChange3
totalHolders5
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 12333
totalSharesHeld20271
totalSharesValue32
totalPostionChange2060
totalValueChange4
totalHolders6
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18
liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-478
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-356
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 12333
totalSharesHeld20271
totalSharesValue32
totalPostionChange1582
totalValueChange3
totalHolders6
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18
liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-478
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-384
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 12333
totalSharesHeld20293
totalSharesValue32
totalPostionChange1554
totalValueChange3
totalHolders7
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-478
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-384
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 1
unchangedHoldingTotalShares 12333
totalSharesHeld20293
totalSharesValue32
totalPostionChange1554
totalValueChange3
totalHolders8
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-478
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-384
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 24705
totalSharesHeld32665
totalSharesValue52
totalPostionChange1554
totalValueChange4
totalHolders9
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18
liquidatedTotalCompanies2
liquidatedTotalValue-17
liquidatedTotalShares-11267
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-384
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 24705
totalSharesHeld32665
totalSharesValue52
totalPostionChange-9235
totalValueChange-12
totalHolders9
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-17
liquidatedTotalShares-11267
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-384
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 24717
totalSharesHeld32677
totalSharesValue52
totalPostionChange-9235
totalValueChange-12
totalHolders10
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18must have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-17
liquidatedTotalShares-11267
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares250
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-384
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue4
oldIncreaseHoldingTotalShares2166
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 24725
totalSharesHeld32685
totalSharesValue52
totalPostionChange-9235
totalValueChange-12
totalHolders11
COMPID132435
TICEFOI
CIK0000924168
SHSOUT5070
NAMEEnergy Focus Inc
SECTOR102002
CUSIP29268T508
PRICE1.18
virgina 0.64
virgina2 -0.18
SELECT * from sectors where level3num = '102002'Number Of Rows Found :1
The Sector is Business Equipment
CRAIG TOTAL SHARES VALE : 52
MKCAP5982.6/n/ninsert into institSumNewHoldings values(
Null,
'0000924168',
'132435',
'Energy Focus Inc',
'EFOI',
'1.18',
'29268T508',
'5070',
'0.64',
'102002',
'Business Equipment',
'5982.6',
'2',
'-17',
'-11267',
'1',
'0',
'250',
'2',
'-1',
'-384',
'1',
'4',
'2166',
'32685',
'52',
'-9235',
'-12',
'11',
'7',
'2',
'24725',
'-0.18',
'-93.6',
'NULL',
'-93.6',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye