Compid = 131030Number Of Rows Found :1
Compid Found :131030 Tic Found :HBSL
FINALHBSL | 131030
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =131030 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 = '201004'Number Of Rows Found :1
The Sector is Confectioners
CRAIG TOTAL SHARES VALE : 0
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001072367',
'131030',
'House Of Brussels Chocolates Inc',
'HBSL',
'',
'441936101',
'33868',
'0',
'201004',
'Confectioners',
'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