Compid = 159663Number Of Rows Found :1
$tempCalculation=1.11
START :16.21
END :16.39
Compid Found :159663 Tic Found :CHIE
FINALCHIE | 159663
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159663 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :6
liquidatedTotalCompanies1
liquidatedTotalValue-7
liquidatedTotalShares-447
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-447
totalValueChange-7
totalHolders0
COMPID159663
TICCHIE
CIK9000004129
SHSOUT9000
NAMEGlobal X China Energy
SECTOR999999
CUSIP37950E507
PRICE16.39
liquidatedTotalCompanies2
liquidatedTotalValue-834
liquidatedTotalShares-54605
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-54605
totalValueChange-834
totalHolders0
COMPID159663
TICCHIE
CIK9000004129
SHSOUT9000
NAMEGlobal X China Energy
SECTOR999999
CUSIP37950E507
PRICE16.39
liquidatedTotalCompanies3
liquidatedTotalValue-834
liquidatedTotalShares-54607
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-54607
totalValueChange-834
totalHolders0
COMPID159663
TICCHIE
CIK9000004129
SHSOUT9000
NAMEGlobal X China Energy
SECTOR999999
CUSIP37950E507
PRICE16.39
liquidatedTotalCompanies4
liquidatedTotalValue-834
liquidatedTotalShares-54607
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-54607
totalValueChange-834
totalHolders0
COMPID159663
TICCHIE
CIK9000004129
SHSOUT9000
NAMEGlobal X China Energy
SECTOR999999
CUSIP37950E507
PRICE16.39
liquidatedTotalCompanies5
liquidatedTotalValue-843
liquidatedTotalShares-55198
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-55198
totalValueChange-843
totalHolders0
COMPID159663
TICCHIE
CIK9000004129
SHSOUT9000
NAMEGlobal X China Energy
SECTOR999999
CUSIP37950E507
PRICE16.39
liquidatedTotalCompanies6
liquidatedTotalValue-865
liquidatedTotalShares-56610
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-56610
totalValueChange-865
totalHolders0
COMPID159663
TICCHIE
CIK9000004129
SHSOUT9000
NAMEGlobal X China Energy
SECTOR999999
CUSIP37950E507
PRICE16.39
virgina 0
virgina2 -0.63
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 0
MKCAP147510/n/ninsert into institSumNewHoldings values(
Null,
'9000004129',
'159663',
'Global X China Energy',
'CHIE',
'16.39',
'37950E507',
'9000',
'0',
'999999',
'N/A',
'147510',
'6',
'-865',
'-56610',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'-56610',
'-865',
'0',
'0',
'0',
'0',
'-0.63',
'-0',
'-0',
'-0',
'15.54',
'16.39',
'16.21',
'1.11',
NULL, NULL,NULL)
OKbye