Compid = 138839Number Of Rows Found :1
$tempCalculation=0
START :
END :0
Compid Found :138839 Tic Found :138839-OLD
FINAL138839-OLD | 138839
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =138839 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 30
totalSharesHeld30
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders1
COMPID138839
TIC138839-OLD
CIK0000745651
SHSOUT76140
NAMEAdvanced Battery Technologies Inc
SECTOR102001
CUSIP00752H102
PRICE0
virgina 0
virgina2 0
SELECT * from sectors where level3num = '102001'Number Of Rows Found :1
The Sector is Appliances
CRAIG TOTAL SHARES VALE : 0
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0000745651',
'138839',
'Advanced Battery Technologies Inc',
'138839-OLD',
'0',
'00752H102',
'76140',
'0',
'102001',
'Appliances',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'30',
'0',
'0',
'0',
'1',
'1',
'0',
'30',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye