Compid = 151500Number Of Rows Found :1
$tempCalculation=0
START :
END :7.5
Compid Found :151500 Tic Found :JMP
FINALJMP | 151500
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =151500 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :2must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1
totalSharesHeld1
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders1
COMPID151500
TICJMP
CIK0001383803
SHSOUT19670
NAMEJMP Group Inc
SECTOR302007
CUSIP46629U107
PRICE7.5
liquidatedTotalCompanies1
liquidatedTotalValue-120
liquidatedTotalShares-21719
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1
totalSharesHeld1
totalSharesValue0
totalPostionChange-21719
totalValueChange-120
totalHolders1
COMPID151500
TICJMP
CIK0001383803
SHSOUT19670
NAMEJMP Group Inc
SECTOR302007
CUSIP46629U107
PRICE7.5
virgina 0
virgina2 -0.11
SELECT * from sectors where level3num = '302007'Number Of Rows Found :1
The Sector is Investment Brokerage - National
CRAIG TOTAL SHARES VALE : 0
MKCAP147525/n/ninsert into institSumNewHoldings values(
Null,
'0001383803',
'151500',
'JMP Group Inc',
'JMP',
'7.5',
'46629U107',
'19670',
'0',
'302007',
'Investment Brokerage - National',
'147525',
'1',
'-120',
'-21719',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'0',
'-21719',
'-120',
'1',
'1',
'0',
'1',
'-0.11',
'-0',
'-0',
'-0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye