Compid = 159624Number Of Rows Found :1
$tempCalculation=0.4
START :14.87
END :14.93
Compid Found :159624 Tic Found :ASEA
FINALASEA | 159624
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159624 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :25
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue394
oldIncreaseHoldingTotalShares26098
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld26098
totalSharesValue394
totalPostionChange26098
totalValueChange394
totalHolders1
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-18
oldDecreaseHoldingTotalShares-1229
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue394
oldIncreaseHoldingTotalShares26098
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld34182
totalSharesValue516
totalPostionChange24869
totalValueChange376
totalHolders2
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-18
oldDecreaseHoldingTotalShares-1229
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue394
oldIncreaseHoldingTotalShares26098
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 15300
totalSharesHeld49482
totalSharesValue747
totalPostionChange24869
totalValueChange376
totalHolders3
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-18
oldDecreaseHoldingTotalShares-1229
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue394
oldIncreaseHoldingTotalShares26098
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 15300
totalSharesHeld49482
totalSharesValue747
totalPostionChange3644
totalValueChange56
totalHolders3
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-18
oldDecreaseHoldingTotalShares-1229
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue501
oldIncreaseHoldingTotalShares33209
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 15300
totalSharesHeld123068
totalSharesValue1857
totalPostionChange10755
totalValueChange163
totalHolders4
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-18
oldDecreaseHoldingTotalShares-1229
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 15300
totalSharesHeld135599
totalSharesValue2047
totalPostionChange23286
totalValueChange353
totalHolders5
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-26
oldDecreaseHoldingTotalShares-1789
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 15300
totalSharesHeld135837
totalSharesValue2051
totalPostionChange22726
totalValueChange345
totalHolders6
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-26
oldDecreaseHoldingTotalShares-1789
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 16272
totalSharesHeld136809
totalSharesValue2066
totalPostionChange22726
totalValueChange345
totalHolders7
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-76
oldDecreaseHoldingTotalShares-5115
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 16272
totalSharesHeld156254
totalSharesValue2359
totalPostionChange19400
totalValueChange295
totalHolders8
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-76
oldDecreaseHoldingTotalShares-5115
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 16272
totalSharesHeld173966
totalSharesValue2626
totalPostionChange37112
totalValueChange562
totalHolders9
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 16272
totalSharesHeld189469
totalSharesValue2860
totalPostionChange36665
totalValueChange555
totalHolders10
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue691
oldIncreaseHoldingTotalShares45740
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld439437
totalSharesValue6632
totalPostionChange36665
totalValueChange557
totalHolders11
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue693
oldIncreaseHoldingTotalShares45879
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld442913
totalSharesValue6684
totalPostionChange36804
totalValueChange559
totalHolders12
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue1394
oldIncreaseHoldingTotalShares92222
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld632487
totalSharesValue9545
totalPostionChange83147
totalValueChange1260
totalHolders13
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1441
oldIncreaseHoldingTotalShares95302
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld648117
totalSharesValue9781
totalPostionChange86227
totalValueChange1307
totalHolders14
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies1
newHoldingTotalValue267
newHoldingTotalShares17712
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1441
oldIncreaseHoldingTotalShares95302
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld648117
totalSharesValue9781
totalPostionChange86227
totalValueChange1307
totalHolders15
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5562
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1441
oldIncreaseHoldingTotalShares95302
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld695517
totalSharesValue10496
totalPostionChange133627
totalValueChange2022
totalHolders16
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5563
oldIncreaseHoldingTotalCompanies6
oldIncreaseHoldingTotalValue1441
oldIncreaseHoldingTotalShares95302
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld695517
totalSharesValue10496
totalPostionChange133626
totalValueChange2022
totalHolders17
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-83
oldDecreaseHoldingTotalShares-5563
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld696656
totalSharesValue10513
totalPostionChange133745
totalValueChange2024
totalHolders18
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-90
oldDecreaseHoldingTotalShares-6030
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266240
totalSharesHeld735432
totalSharesValue11098
totalPostionChange133278
totalValueChange2017
totalHolders19
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93must have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue-90
oldDecreaseHoldingTotalShares-6030
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266560
totalSharesHeld735752
totalSharesValue11103
totalPostionChange133278
totalValueChange2017
totalHolders20
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue-546
oldDecreaseHoldingTotalShares-36293
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266560
totalSharesHeld809985
totalSharesValue12223
totalPostionChange103015
totalValueChange1561
totalHolders21
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies8
oldDecreaseHoldingTotalValue-655
oldDecreaseHoldingTotalShares-42120
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266560
totalSharesHeld879452
totalSharesValue13271
totalPostionChange97188
totalValueChange1452
totalHolders22
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies2
newHoldingTotalValue982
newHoldingTotalShares65112
oldDecreaseHoldingTotalCompanies9
oldDecreaseHoldingTotalValue-699
oldDecreaseHoldingTotalShares-45070
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266560
totalSharesHeld885420
totalSharesValue13361
totalPostionChange94238
totalValueChange1408
totalHolders23
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
liquidatedTotalCompanies1
liquidatedTotalValue-320
liquidatedTotalShares-21225
newHoldingTotalCompanies3
newHoldingTotalValue2092
newHoldingTotalShares138698
oldDecreaseHoldingTotalCompanies9
oldDecreaseHoldingTotalValue-699
oldDecreaseHoldingTotalShares-45070
oldIncreaseHoldingTotalCompanies7
oldIncreaseHoldingTotalValue1443
oldIncreaseHoldingTotalShares95421
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 2
unchangedHoldingTotalShares 266560
totalSharesHeld959006
totalSharesValue14471
totalPostionChange167824
totalValueChange2518
totalHolders24
COMPID159624
TICASEA
CIK9000004090
SHSOUT1250
NAMEGlobal X Ftse Asean 40
SECTOR999999
CUSIP37950E648
PRICE14.93
virgina 76.72
virgina2 13.43
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 14471
MKCAP18662.5/n/ninsert into institSumNewHoldings values(
Null,
'9000004090',
'159624',
'Global X Ftse Asean 40',
'ASEA',
'14.93',
'37950E648',
'1250',
'76.72',
'999999',
'N/A',
'18662.5',
'1',
'-320',
'-21225',
'3',
'2092',
'138698',
'9',
'-699',
'-45070',
'7',
'1443',
'95421',
'959006',
'14471',
'167824',
'2518',
'24',
'5',
'2',
'266560',
'13.43',
'NULL',
'1943455.3',
'1943455.3',
'14.94',
'15.09',
'14.87',
'0.4',
NULL, NULL,NULL)
OKbye