Compid = 131028Number Of Rows Found :1
Compid Found :131028 Tic Found :CBKN
FINALCBKN | 131028
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =131028 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :0
virgina 0
virgina2 0
SELECT * from sectors where level3num = '301009'Number Of Rows Found :1
The Sector is Domestic Regional Banks
CRAIG TOTAL SHARES VALE : 0
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001071992',
'131028',
'Capital Bank Corp',
'CBKN',
'',
'139793103',
'85800',
'0',
'301009',
'Domestic Regional Banks',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye