Compid = 159573Number Of Rows Found :1
$tempCalculation=7.93
START :57.66
END :62.23
Compid Found :159573 Tic Found :AADR
FINALAADR | 159573
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159573 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :17
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-39
oldDecreaseHoldingTotalShares-1478
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld7264
totalSharesValue452
totalPostionChange-1478
totalValueChange-39
totalHolders1
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-82
oldDecreaseHoldingTotalShares-2864
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld13075
totalSharesValue814
totalPostionChange-2864
totalValueChange-82
totalHolders2
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-120
oldDecreaseHoldingTotalShares-3538
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld13082
totalSharesValue814
totalPostionChange-3538
totalValueChange-120
totalHolders3
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-120
oldDecreaseHoldingTotalShares-3538
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld13082
totalSharesValue814
totalPostionChange-3538
totalValueChange-120
totalHolders4
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-342
oldDecreaseHoldingTotalShares-7929
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld17215
totalSharesValue1071
totalPostionChange-7929
totalValueChange-342
totalHolders5
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-351
oldDecreaseHoldingTotalShares-8270
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld18967
totalSharesValue1180
totalPostionChange-8270
totalValueChange-351
totalHolders6
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-351
oldDecreaseHoldingTotalShares-8270
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 5209
totalSharesHeld24176
totalSharesValue1504
totalPostionChange-8270
totalValueChange-320
totalHolders7
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-260
oldDecreaseHoldingTotalShares-8446
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 5209
totalSharesHeld41004
totalSharesValue2551
totalPostionChange-8446
totalValueChange-229
totalHolders8
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-260
oldDecreaseHoldingTotalShares-8446
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 31
unchangedHoldingTotalShares 5209
totalSharesHeld41004
totalSharesValue2551
totalPostionChange-16203
totalValueChange-665
totalHolders8
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-260
oldDecreaseHoldingTotalShares-8446
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 32
unchangedHoldingTotalShares 5217
totalSharesHeld41012
totalSharesValue2552
totalPostionChange-16203
totalValueChange-664
totalHolders9
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-173
oldDecreaseHoldingTotalShares-8487
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 32
unchangedHoldingTotalShares 5217
totalSharesHeld55968
totalSharesValue3482
totalPostionChange-16244
totalValueChange-577
totalHolders10
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-173
oldDecreaseHoldingTotalShares-8487
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 9871
totalSharesHeld60622
totalSharesValue3772
totalPostionChange-16244
totalValueChange-549
totalHolders11
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue-147
oldDecreaseHoldingTotalShares-8921
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 9871
totalSharesHeld69132
totalSharesValue4301
totalPostionChange-16678
totalValueChange-523
totalHolders12
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies9
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-9639
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 9871
totalSharesHeld78745
totalSharesValue4899
totalPostionChange-17396
totalValueChange-506
totalHolders13
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies9
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-9639
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 9891
totalSharesHeld78765
totalSharesValue4900
totalPostionChange-17396
totalValueChange-506
totalHolders14
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies10
oldDecreaseHoldingTotalValue130
oldDecreaseHoldingTotalShares-9809
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 60
unchangedHoldingTotalShares 9891
totalSharesHeld123855
totalSharesValue7705
totalPostionChange-17566
totalValueChange-246
totalHolders15
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-436
liquidatedTotalShares-7757
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies10
oldDecreaseHoldingTotalValue130
oldDecreaseHoldingTotalShares-9809
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 62
unchangedHoldingTotalShares 10142
totalSharesHeld124106
totalSharesValue7721
totalPostionChange-17566
totalValueChange-244
totalHolders16
COMPID159573
TICAADR
CIK9000004039
SHSOUT1330
NAMEAdvisorShares Dorsey Wright ADR ETF
SECTOR999999
CUSIP00768Y206
PRICE62.23
virgina 9.33
virgina2 -1.32
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 7721
MKCAP82765.9/n/ninsert into institSumNewHoldings values(
Null,
'9000004039',
'159573',
'AdvisorShares Dorsey Wright ADR ETF',
'AADR',
'62.23',
'00768Y206',
'1330',
'9.33',
'999999',
'N/A',
'82765.9',
'1',
'-436',
'-7757',
'0',
'0',
'0',
'10',
'130',
'-9809',
'0',
'0',
'0',
'124106',
'7721',
'-17566',
'-244',
'16',
'6',
'62',
'10142',
'-1.32',
'-101917.2',
'NULL',
'-101917.2',
'55.02',
'62.21',
'57.66',
'7.93',
NULL, NULL,NULL)
OKbye