Compid = 159760Number Of Rows Found :1
$tempCalculation=1.19
START :249.4
END :252.38
Compid Found :159760 Tic Found :HVRRF
FINALHVRRF | 159760
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159760 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :1
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue3716
oldDecreaseHoldingTotalShares-11546
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld184518
totalSharesValue50556
totalPostionChange-11546
totalValueChange3716
totalHolders1
COMPID159760
TICHVRRF
CIK9000004226
SHSOUT120600
NAMEHann.rueckver.ag Na O.n.
SECTOR999999
CUSIPD3015J135
PRICE252.38
virgina 0.15
virgina2 -0.01
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 50556
MKCAP30437028/n/ninsert into institSumNewHoldings values(
Null,
'9000004226',
'159760',
'Hann.rueckver.ag Na O.n.',
'HVRRF',
'252.38',
'D3015J135',
'120600',
'0.15',
'999999',
'N/A',
'30437028',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'3716',
'-11546',
'0',
'0',
'0',
'184518',
'50556',
'-11546',
'3716',
'1',
'0',
'0',
'0',
'-0.01',
'-5055.6',
'NULL',
'-5055.6',
'240.255',
'265.5',
'249.4',
'1.19',
NULL, NULL,NULL)
OKbye