Compid = 159729Number Of Rows Found :1
$tempCalculation=6.38
START :26.81
END :28.52
Compid Found :159729 Tic Found :FPA
FINALFPA | 159729
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159729 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :17must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders1
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-63
oldDecreaseHoldingTotalShares-2414
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld5091
totalSharesValue141
totalPostionChange-2414
totalValueChange-63
totalHolders2
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-63
oldDecreaseHoldingTotalShares-2414
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld6591
totalSharesValue182
totalPostionChange-2414
totalValueChange-63
totalHolders3
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-63
oldDecreaseHoldingTotalShares-2414
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld13863
totalSharesValue383
totalPostionChange4858
totalValueChange138
totalHolders4
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-63
oldDecreaseHoldingTotalShares-2414
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld13863
totalSharesValue383
totalPostionChange-4312
totalValueChange-112
totalHolders4
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-68
oldDecreaseHoldingTotalShares-3097
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld43302
totalSharesValue1198
totalPostionChange-4995
totalValueChange-117
totalHolders5
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-68
oldDecreaseHoldingTotalShares-3097
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue99
oldIncreaseHoldingTotalShares3182
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld76745
totalSharesValue2121
totalPostionChange-1813
totalValueChange-18
totalHolders6
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-68
oldDecreaseHoldingTotalShares-3097
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue159
oldIncreaseHoldingTotalShares4302
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld217945
totalSharesValue6018
totalPostionChange-693
totalValueChange42
totalHolders7
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-3638
oldDecreaseHoldingTotalShares-134321
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue159
oldIncreaseHoldingTotalShares4302
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld230457
totalSharesValue6363
totalPostionChange-131917
totalValueChange-3528
totalHolders8
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-3638
oldDecreaseHoldingTotalShares-134321
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue161
oldIncreaseHoldingTotalShares4333
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld232450
totalSharesValue6418
totalPostionChange-131886
totalValueChange-3526
totalHolders9
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies1
liquidatedTotalValue-250
liquidatedTotalShares-9170
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-3638
oldDecreaseHoldingTotalShares-134321
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue161
oldIncreaseHoldingTotalShares4339
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld232493
totalSharesValue6419
totalPostionChange-131880
totalValueChange-3526
totalHolders10
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies2
liquidatedTotalValue-250
liquidatedTotalShares-9178
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-3638
oldDecreaseHoldingTotalShares-134321
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue161
oldIncreaseHoldingTotalShares4339
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld232493
totalSharesValue6419
totalPostionChange-131888
totalValueChange-3526
totalHolders10
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies2
liquidatedTotalValue-250
liquidatedTotalShares-9178
newHoldingTotalCompanies1
newHoldingTotalValue201
newHoldingTotalShares7272
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-3638
oldDecreaseHoldingTotalShares-134321
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares4986
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld257575
totalSharesValue7111
totalPostionChange-131241
totalValueChange-3500
totalHolders11
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies2
liquidatedTotalValue-250
liquidatedTotalShares-9178
newHoldingTotalCompanies2
newHoldingTotalValue653
newHoldingTotalShares23659
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-3638
oldDecreaseHoldingTotalShares-134321
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares4986
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld273962
totalSharesValue7563
totalPostionChange-114854
totalValueChange-3048
totalHolders12
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies2
liquidatedTotalValue-250
liquidatedTotalShares-9178
newHoldingTotalCompanies2
newHoldingTotalValue653
newHoldingTotalShares23659
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-3758
oldDecreaseHoldingTotalShares-138845
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares4986
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld283348
totalSharesValue7822
totalPostionChange-119378
totalValueChange-3168
totalHolders13
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies2
liquidatedTotalValue-250
liquidatedTotalShares-9178
newHoldingTotalCompanies2
newHoldingTotalValue653
newHoldingTotalShares23659
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-3755
oldDecreaseHoldingTotalShares-138968
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares4986
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld300853
totalSharesValue8305
totalPostionChange-119501
totalValueChange-3165
totalHolders14
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
liquidatedTotalCompanies2
liquidatedTotalValue-250
liquidatedTotalShares-9178
newHoldingTotalCompanies3
newHoldingTotalValue704
newHoldingTotalShares25500
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-3755
oldDecreaseHoldingTotalShares-138968
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue187
oldIncreaseHoldingTotalShares4986
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1500
totalSharesHeld302694
totalSharesValue8356
totalPostionChange-117660
totalValueChange-3114
totalHolders15
COMPID159729
TICFPA
CIK9000004195
SHSOUT1600
NAMEFirst Trust Asia Pacific Ex Japan Alphadex Fund
SECTOR999999
CUSIP33737J109
PRICE28.52
virgina 18.92
virgina2 -7.35
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 8356
MKCAP45632/n/ninsert into institSumNewHoldings values(
Null,
'9000004195',
'159729',
'First Trust Asia Pacific Ex Japan Alphadex Fund',
'FPA',
'28.52',
'33737J109',
'1600',
'18.92',
'999999',
'N/A',
'45632',
'2',
'-250',
'-9178',
'3',
'704',
'25500',
'5',
'-3755',
'-138968',
'5',
'187',
'4986',
'302694',
'8356',
'-117660',
'-3114',
'15',
'2',
'0',
'1500',
'-7.35',
'-614166',
'NULL',
'-614166',
'26.8122',
'27.6',
'26.81',
'6.38',
NULL, NULL,NULL)
OKbye