Compid = 166941Number Of Rows Found :1
Compid Found :166941 Tic Found :ROMO
FINALROMO | 166941

Split info : 1

START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =166941 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-224
liquidatedTotalShares-8474
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld0
totalSharesValue0
totalPostionChange-8474
totalValueChange-224
totalHolders0
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares2
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld2
totalSharesValue0
totalPostionChange-8472
totalValueChange-224
totalHolders1
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares2
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-158
oldDecreaseHoldingTotalShares-11332
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld66441
totalSharesValue1876
totalPostionChange-19804
totalValueChange-382
totalHolders2
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-158
oldDecreaseHoldingTotalShares-11332
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld70460
totalSharesValue1992
totalPostionChange-15785
totalValueChange-266
totalHolders3
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-158
oldDecreaseHoldingTotalShares-11332
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue884
oldIncreaseHoldingTotalShares16938
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld244309
totalSharesValue7018
totalPostionChange1153
totalValueChange618
totalHolders4
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-263
oldDecreaseHoldingTotalShares-16462
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue884
oldIncreaseHoldingTotalShares16938
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld256709
totalSharesValue7376
totalPostionChange-3977
totalValueChange513
totalHolders5
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICEmust have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-263
oldDecreaseHoldingTotalShares-16462
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue884
oldIncreaseHoldingTotalShares16938
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 1200

totalSharesHeld257909
totalSharesValue7411
totalPostionChange-3977
totalValueChange516
totalHolders6
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-263
oldDecreaseHoldingTotalShares-16462
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue953
oldIncreaseHoldingTotalShares19329
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 1200

totalSharesHeld260311
totalSharesValue7480
totalPostionChange-1586
totalValueChange585
totalHolders7
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-263
oldDecreaseHoldingTotalShares-16462
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1349
oldIncreaseHoldingTotalShares33037
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 1200

totalSharesHeld274019
totalSharesValue7876
totalPostionChange12122
totalValueChange981
totalHolders8
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICEmust have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies2
newHoldingTotalValue116
newHoldingTotalShares4021
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-263
oldDecreaseHoldingTotalShares-16462
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1349
oldIncreaseHoldingTotalShares33037
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 1200

totalSharesHeld274019
totalSharesValue7876
totalPostionChange12122
totalValueChange981
totalHolders9
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-224
liquidatedTotalShares-8474
newHoldingTotalCompanies3
newHoldingTotalValue328
newHoldingTotalShares11342
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-3458
oldDecreaseHoldingTotalShares-184325
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1349
oldIncreaseHoldingTotalShares33037
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 3
unchangedHoldingTotalShares 1200

totalSharesHeld772544
totalSharesValue22289
totalPostionChange-148420
totalValueChange-2002
totalHolders12
COMPID166941
TICROMO
CIK9000006457
SHSOUT9000
NAMENewfound/resolve Robust Momentum Etf
SECTOR999999
CUSIP86280R886
PRICE
virgina 8.58

virgina2 -1.65
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A

CRAIG TOTAL SHARES VALE : 22289

MKCAP0/n/ninsert into institSumNewHoldings values( Null, '9000006457', '166941', 'Newfound/resolve Robust Momentum Etf', 'ROMO', '', '86280R886', '9000', '8.58', '999999', 'N/A', '0', '1', '-224', '-8474', '3', '328', '11342', '4', '-3458', '-184325', '3', '1349', '33037', '772544', '22289', '-148420', '-2002', '12', '2', '3', '1200', '-1.65', '-367768.5', 'NULL', '-367768.5', '', '', '', '0', NULL, NULL,NULL) OKbye