Compid = 160386Number Of Rows Found :1
$tempCalculation=0
START :
END :111.906

Compid Found :160386 Tic Found :TTFS
FINALTTFS | 160386

Split info : 1

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

Number Of Rows Found :24

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-37
oldDecreaseHoldingTotalShares-363
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld49
totalSharesValue6
totalPostionChange-363
totalValueChange-37
totalHolders1
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-37
oldDecreaseHoldingTotalShares-363
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld4495
totalSharesValue526
totalPostionChange4083
totalValueChange483
totalHolders2
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-37
oldDecreaseHoldingTotalShares-363
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 279

totalSharesHeld4774
totalSharesValue559
totalPostionChange4083
totalValueChange487
totalHolders3
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 4
unchangedHoldingTotalShares 279

totalSharesHeld7584
totalSharesValue888
totalPostionChange3858
totalValueChange499
totalHolders4
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 85
unchangedHoldingTotalShares 6788

totalSharesHeld14093
totalSharesValue1649
totalPostionChange3858
totalValueChange580
totalHolders5
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue269
oldIncreaseHoldingTotalShares490
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 85
unchangedHoldingTotalShares 6788

totalSharesHeld31655
totalSharesValue3702
totalPostionChange4348
totalValueChange849
totalHolders6
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue269
oldIncreaseHoldingTotalShares490
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 109
unchangedHoldingTotalShares 8719

totalSharesHeld33586
totalSharesValue3928
totalPostionChange4348
totalValueChange873
totalHolders7
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue269
oldIncreaseHoldingTotalShares490
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 183
unchangedHoldingTotalShares 14639

totalSharesHeld39506
totalSharesValue4620
totalPostionChange4348
totalValueChange947
totalHolders8
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 183
unchangedHoldingTotalShares 14639

totalSharesHeld43853
totalSharesValue5128
totalPostionChange4748
totalValueChange1043
totalHolders9
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 183
unchangedHoldingTotalShares 14639

totalSharesHeld43853
totalSharesValue5128
totalPostionChange4748
totalValueChange1043
totalHolders10
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 189
unchangedHoldingTotalShares 15119

totalSharesHeld44333
totalSharesValue5184
totalPostionChange4748
totalValueChange1049
totalHolders11
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue 237
unchangedHoldingTotalShares 18996

totalSharesHeld48210
totalSharesValue5637
totalPostionChange4748
totalValueChange1097
totalHolders12
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-25
oldDecreaseHoldingTotalShares-588
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 8
unchangedHoldingTotalValue 325
unchangedHoldingTotalShares 26016

totalSharesHeld55230
totalSharesValue6458
totalPostionChange4748
totalValueChange1185
totalHolders13
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-745
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 8
unchangedHoldingTotalValue 325
unchangedHoldingTotalShares 26016

totalSharesHeld64476
totalSharesValue7539
totalPostionChange4591
totalValueChange1284
totalHolders14
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue520
newHoldingTotalShares4446
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-745
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue 328
unchangedHoldingTotalShares 26283

totalSharesHeld64743
totalSharesValue7570
totalPostionChange4591
totalValueChange1287
totalHolders15
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue532
newHoldingTotalShares4546
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue74
oldDecreaseHoldingTotalShares-745
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue 328
unchangedHoldingTotalShares 26283

totalSharesHeld64843
totalSharesValue7582
totalPostionChange4691
totalValueChange1299
totalHolders16
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue532
newHoldingTotalShares4546
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue104
oldDecreaseHoldingTotalShares-890
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue365
oldIncreaseHoldingTotalShares890
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue 328
unchangedHoldingTotalShares 26283

totalSharesHeld68499
totalSharesValue8009
totalPostionChange4546
totalValueChange1329
totalHolders17
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue532
newHoldingTotalShares4546
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue104
oldDecreaseHoldingTotalShares-890
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue407
oldIncreaseHoldingTotalShares1190
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue 328
unchangedHoldingTotalShares 26283

totalSharesHeld69299
totalSharesValue8103
totalPostionChange4846
totalValueChange1371
totalHolders18
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-8
newHoldingTotalCompanies2
newHoldingTotalValue532
newHoldingTotalShares4546
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue104
oldDecreaseHoldingTotalShares-890
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue407
oldIncreaseHoldingTotalShares1190
unchangedHoldingTotalCompanies 9
unchangedHoldingTotalValue 328
unchangedHoldingTotalShares 26283

totalSharesHeld69299
totalSharesValue8103
totalPostionChange4838
totalValueChange1370
totalHolders18
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906must have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-1
liquidatedTotalShares-8
newHoldingTotalCompanies2
newHoldingTotalValue532
newHoldingTotalShares4546
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue104
oldDecreaseHoldingTotalShares-890
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue407
oldIncreaseHoldingTotalShares1190
unchangedHoldingTotalCompanies 10
unchangedHoldingTotalValue 373
unchangedHoldingTotalShares 29858

totalSharesHeld72874
totalSharesValue8521
totalPostionChange4838
totalValueChange1415
totalHolders19
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906

liquidatedTotalCompanies2
liquidatedTotalValue-20
liquidatedTotalShares-193
newHoldingTotalCompanies2
newHoldingTotalValue532
newHoldingTotalShares4546
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue104
oldDecreaseHoldingTotalShares-890
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue552
oldIncreaseHoldingTotalShares2184
unchangedHoldingTotalCompanies 12
unchangedHoldingTotalValue 379
unchangedHoldingTotalShares 30382

totalSharesHeld76729
totalSharesValue8971
totalPostionChange5647
totalValueChange1547
totalHolders22
COMPID160386
TICTTFS
CIK9000004544
SHSOUT1400
NAMETrimtabs Float Shrink
SECTOR999999
CUSIP00768Y818
PRICE111.906
virgina 5.48

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

CRAIG TOTAL SHARES VALE : 8971

MKCAP156668.4/n/ninsert into institSumNewHoldings values( Null, '9000004544', '160386', 'Trimtabs Float Shrink', 'TTFS', '111.906', '00768Y818', '1400', '5.48', '999999', 'N/A', '156668.4', '2', '-20', '-193', '2', '532', '4546', '4', '104', '-890', '4', '552', '2184', '76729', '8971', '5647', '1547', '22', '12', '379', '30382', '0.4', 'NULL', '35884', '35884', '', '', '', '0', NULL, NULL,NULL) OKbye