Compid = 168573Number Of Rows Found :1
Compid Found :168573 Tic Found :CPTK.U
FINALCPTK.U | 168573
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =168573 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :5
liquidatedTotalCompanies1
liquidatedTotalValue-19
liquidatedTotalShares-1793
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-1793
totalValueChange-19
totalHolders0
COMPID168573
TICCPTK.U
CIK0001827899
SHSOUT
NAMECrown Proptech Acquisitions
SECTOR999999
CUSIPG25741128
PRICE
liquidatedTotalCompanies2
liquidatedTotalValue-19
liquidatedTotalShares-1795
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld0
totalSharesValue0
totalPostionChange-1795
totalValueChange-19
totalHolders0
COMPID168573
TICCPTK.U
CIK0001827899
SHSOUT
NAMECrown Proptech Acquisitions
SECTOR999999
CUSIPG25741128
PRICEmust have stayed the same
liquidatedTotalCompanies2
liquidatedTotalValue-19
liquidatedTotalShares-1795
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 355
totalSharesHeld355
totalSharesValue4
totalPostionChange-1795
totalValueChange-19
totalHolders1
COMPID168573
TICCPTK.U
CIK0001827899
SHSOUT
NAMECrown Proptech Acquisitions
SECTOR999999
CUSIPG25741128
PRICE
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-1795
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 355
totalSharesHeld355
totalSharesValue4
totalPostionChange-1795
totalValueChange-19
totalHolders1
COMPID168573
TICCPTK.U
CIK0001827899
SHSOUT
NAMECrown Proptech Acquisitions
SECTOR999999
CUSIPG25741128
PRICE
liquidatedTotalCompanies3
liquidatedTotalValue-19
liquidatedTotalShares-1795
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue-21
oldIncreaseHoldingTotalShares403
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 355
totalSharesHeld2721
totalSharesValue4
totalPostionChange-1392
totalValueChange-40
totalHolders2
COMPID168573
TICCPTK.U
CIK0001827899
SHSOUT
NAMECrown Proptech Acquisitions
SECTOR999999
CUSIPG25741128
PRICE
virgina 0
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 4
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001827899',
'168573',
'Crown Proptech Acquisitions',
'CPTK.U',
'',
'G25741128',
'',
'0',
'999999',
'N/A',
'0',
'3',
'-19',
'-1795',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'-21',
'403',
'2721',
'4',
'-1392',
'-40',
'2',
'1',
'0',
'355',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye