Compid = 130540Number Of Rows Found :1
$tempCalculation=0
START :
END :0.2
Compid Found :130540 Tic Found :LTRE
FINALLTRE | 130540
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =130540 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1
liquidatedTotalCompanies1
liquidatedTotalValue-3
liquidatedTotalShares-15340
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-15340
totalValueChange-3
totalHolders0
COMPID130540
TICLTRE
CIK0001002037
SHSOUT13224
NAMELearning Tree International Inc
SECTOR503003
CUSIP522015106
PRICE0.2
virgina 0
virgina2 -0.12
SELECT * from sectors where level3num = '503003'Number Of Rows Found :1
The Sector is Education & Training Services
CRAIG TOTAL SHARES VALE : 0
MKCAP2644.8/n/ninsert into institSumNewHoldings values(
Null,
'0001002037',
'130540',
'Learning Tree International Inc',
'LTRE',
'0.2',
'522015106',
'13224',
'0',
'503003',
'Education & Training Services',
'2644.8',
'1',
'-3',
'-15340',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'-15340',
'-3',
'0',
'0',
'0',
'0',
'-0.12',
'-0',
'-0',
'-0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye