Compid = 145495Number Of Rows Found :1
$tempCalculation=0
START :
END :0.499
Compid Found :145495 Tic Found :ASOLF
FINALASOLF | 145495
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =145495 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-15
liquidatedTotalShares-40000
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-40000
totalValueChange-15
totalHolders0
COMPID145495
TICASOLF
CIK
SHSOUT38043
NAMEAscot Resources Ltd. (Canada)
SECTOR999999
CUSIP04364G106
PRICE0.499
virgina 0
virgina2 -0.11
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 0
MKCAP18983.457/n/ninsert into institSumNewHoldings values(
Null,
'',
'145495',
'Ascot Resources Ltd. (Canada)',
'ASOLF',
'0.499',
'04364G106',
'38043',
'0',
'999999',
'N/A',
'18983.457',
'1',
'-15',
'-40000',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'-40000',
'-15',
'0',
'0',
'0',
'0',
'-0.11',
'-0',
'-0',
'-0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye