Compid = 166983Number Of Rows Found :1
Compid Found :166983 Tic Found :NCRA
FINALNCRA | 166983
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =166983 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :10
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-85
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-85
totalValueChange0
totalHolders0
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-85
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares255
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld3095
totalSharesValue4
totalPostionChange170
totalValueChange0
totalHolders1
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICEmust have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-85
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares255
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld3095
totalSharesValue4
totalPostionChange170
totalValueChange0
totalHolders2
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
liquidatedTotalCompanies2
liquidatedTotalValue-1
liquidatedTotalShares-468
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares255
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld3095
totalSharesValue4
totalPostionChange-213
totalValueChange-1
totalHolders2
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICEmust have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-1
liquidatedTotalShares-468
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares255
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 134
totalSharesHeld3229
totalSharesValue4
totalPostionChange-213
totalValueChange-1
totalHolders3
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICEmust have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-1
liquidatedTotalShares-468
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares255
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 48090
totalSharesHeld51185
totalSharesValue65
totalPostionChange-213
totalValueChange-3
totalHolders4
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
liquidatedTotalCompanies2
liquidatedTotalValue-1
liquidatedTotalShares-468
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares257
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 48090
totalSharesHeld51253
totalSharesValue65
totalPostionChange-211
totalValueChange-3
totalHolders5
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
liquidatedTotalCompanies2
liquidatedTotalValue-1
liquidatedTotalShares-468
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-469
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares257
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 48090
totalSharesHeld69240
totalSharesValue88
totalPostionChange-680
totalValueChange-4
totalHolders6
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
liquidatedTotalCompanies2
liquidatedTotalValue-1
liquidatedTotalShares-468
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-469
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-1
oldIncreaseHoldingTotalShares265
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 48090
totalSharesHeld96678
totalSharesValue123
totalPostionChange-672
totalValueChange-5
totalHolders7
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
liquidatedTotalCompanies3
liquidatedTotalValue-39
liquidatedTotalShares-28996
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-469
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue-1
oldIncreaseHoldingTotalShares265
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue -2
unchangedHoldingTotalShares 48090
totalSharesHeld96678
totalSharesValue123
totalPostionChange-29200
totalValueChange-43
totalHolders7
COMPID166983
TICNCRA
CIK0001756180
SHSOUT10710
NAMENocera, Inc.
SECTOR999999
CUSIP655186500
PRICE
virgina 0.9
virgina2 -0.27
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 123
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001756180',
'166983',
'Nocera, Inc.',
'NCRA',
'',
'655186500',
'10710',
'0.9',
'999999',
'N/A',
'0',
'3',
'-39',
'-28996',
'0',
'0',
'0',
'1',
'-1',
'-469',
'3',
'-1',
'265',
'96678',
'123',
'-29200',
'-43',
'7',
'3',
'-2',
'48090',
'-0.27',
'-332.1',
'NULL',
'-332.1',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye