Compid = 159615Number Of Rows Found :1
$tempCalculation=1.94
START :853.26
END :869.819
Compid Found :159615 Tic Found :USB.PA
FINALUSB.PA | 159615
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159615 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :3
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-158
oldDecreaseHoldingTotalShares-377
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld5728
totalSharesValue4837
totalPostionChange-377
totalValueChange-158
totalHolders1
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-158
oldDecreaseHoldingTotalShares-377
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 8
unchangedHoldingTotalShares 315
totalSharesHeld6043
totalSharesValue5103
totalPostionChange-377
totalValueChange-150
totalHolders2
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-130
oldDecreaseHoldingTotalShares-623
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 8
unchangedHoldingTotalShares 315
totalSharesHeld14792
totalSharesValue12491
totalPostionChange-623
totalValueChange-122
totalHolders3
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
virgina 0.16
virgina2 -0.01
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 12491
MKCAP7828371/n/ninsert into institSumNewHoldings values(
Null,
'9000004081',
'159615',
'Us Bancorp',
'USB.PA',
'869.819',
'902973866',
'9000',
'0.16',
'999999',
'N/A',
'7828371',
'0',
'0',
'0',
'0',
'0',
'0',
'2',
'-130',
'-623',
'0',
'0',
'0',
'14792',
'12491',
'-623',
'-122',
'3',
'1',
'8',
'315',
'-0.01',
'-1249.1',
'NULL',
'-1249.1',
'830.99',
'844.45',
'853.26',
'1.94',
NULL, NULL,NULL)
OKbye