Compid = 151518Number Of Rows Found :1
Compid Found :151518 Tic Found :ENOC
FINALENOC | 151518
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =151518 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 100
totalSharesHeld100
totalSharesValue1
totalPostionChange0
totalValueChange0
totalHolders1
COMPID151518
TICENOC
CIK0001244937
SHSOUT30013
NAMEEnernoc Inc
SECTOR503001
CUSIP292764107
PRICE
virgina 0
virgina2 0
SELECT * from sectors where level3num = '503001'Number Of Rows Found :1
The Sector is Business Services
CRAIG TOTAL SHARES VALE : 1
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001244937',
'151518',
'Enernoc Inc',
'ENOC',
'',
'292764107',
'30013',
'0',
'503001',
'Business Services',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'100',
'1',
'0',
'0',
'1',
'1',
'0',
'100',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye