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-06-30'
Number Of Rows Found :3
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-853
oldDecreaseHoldingTotalShares-803
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld4396
totalSharesValue3623
totalPostionChange-803
totalValueChange-853
totalHolders1
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-853
oldDecreaseHoldingTotalShares-803
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue260
oldIncreaseHoldingTotalShares315
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld4711
totalSharesValue3883
totalPostionChange-488
totalValueChange-593
totalHolders2
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819must have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-853
oldDecreaseHoldingTotalShares-803
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue260
oldIncreaseHoldingTotalShares315
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 8772
totalSharesHeld13483
totalSharesValue11436
totalPostionChange-488
totalValueChange-593
totalHolders3
COMPID159615
TICUSB.PA
CIK9000004081
SHSOUT9000
NAMEUs Bancorp
SECTOR999999
CUSIP902973866
PRICE869.819
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 : 11436
MKCAP7828371/n/ninsert into institSumNewHoldings values(
Null,
'9000004081',
'159615',
'Us Bancorp',
'USB.PA',
'869.819',
'902973866',
'9000',
'0.15',
'999999',
'N/A',
'7828371',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'-853',
'-803',
'1',
'260',
'315',
'13483',
'11436',
'-488',
'-593',
'3',
'1',
'0',
'8772',
'-0.01',
'-1143.6',
'NULL',
'-1143.6',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye