Compid = 159615Number Of Rows Found :1
$tempCalculation=0
START :
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 >= '2025-03-31'
Number Of Rows Found :3
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-33
oldDecreaseHoldingTotalShares-90
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld5199
totalSharesValue4476
totalPostionChange-90
totalValueChange-33
totalHolders1
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-33
oldDecreaseHoldingTotalShares-90
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue622
oldIncreaseHoldingTotalShares656
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld13971
totalSharesValue12029
totalPostionChange566
totalValueChange589
totalHolders2
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
liquidatedTotalCompanies1
liquidatedTotalValue-269
liquidatedTotalShares-315
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-33
oldDecreaseHoldingTotalShares-90
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue622
oldIncreaseHoldingTotalShares656
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld13971
totalSharesValue12029
totalPostionChange251
totalValueChange320
totalHolders2
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
virgina 0.16
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 12029
MKCAP7828371/n/ninsert into institSumNewHoldings values(
Null,
'9000004081',
'159615',
'Us Bancorp',
'USB.PA',
'869.819',
'902973866',
'9000',
'0.16',
'999999',
'N/A',
'7828371',
'1',
'-269',
'-315',
'0',
'0',
'0',
'1',
'-33',
'-90',
'1',
'622',
'656',
'13971',
'12029',
'251',
'320',
'2',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye