| Asset | Sector | Country | Qty | Avg € | Price € | Value € | Wgt % | P&L € | P&L % | Fees € | Day | Week | YTD | 1M | 3M | Contrib | Since | α Sect. 3M | α Ctry 3M | α CAPM | β | ESG | DCF | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||||||||||||||||||
| Name | Sector | Weight % | Perf % | Contribution % |
|---|
| # | Asset | Δ individual | Perf. |
|---|
| # | Asset | Return |
|---|
| # | Sells | Buys | Proceeds | Delta |
|---|
| Asset | Qty | Exec. price | Current price | Proceeds | Δ if held |
|---|
| Asset | Invested | Exec. price | Qty | Curr. value | P&L |
|---|
| Asset | Change | Qty (original) | Qty (arb) | Value (original) | Value (arb) | Delta |
|---|
| Name | Category | Sector | Weight % | Perf % | Contribution % |
|---|
| Asset | Weight % | Daily vol. % | Risk contribution % | Ref. Index |
|---|
| Sector | Port. weight % | Bench. weight % | Port. perf % | Bench. perf % | Allocation | Selection | Interaction | Total |
|---|
| Metric | Ptf |
|---|
| # | Asset | Sector | Simulated price | Current price | Shares (sim.) | Value (sim.) | Gain/Loss € | Return % | Qty to buy | Current cost | Cash left € |
|---|
| Name | Ticker | Current | Intrinsic | Upside % | WACC % | Score | Beta | Type | Actions |
|---|
esg_data.json via export_esg.py.
| Name | Ticker | ISIN | ESG latest | Period | ESG prev | Period prev | Δ ESG |
|---|---|---|---|---|---|---|---|
| Open this tab or click Load to fetch all tickers. | |||||||
.zip containing one PDF per portfolio.config.json.{url}/{TICKER}?api_token={key}&filter=ESGScores&fmt=json
Historical prices for unlisted instruments in the portfolio.
The latest entered price is used in the positions table (Price € column, M badge).
panel_aiesgratings · Legacy = panel_esgrating.
Without ESG = no esg score in the selected source(s).
| Type | Total | AI | Legacy | None |
|---|---|---|---|---|
| Load ESG coverage to see counts. | ||||
., Yahoo/EODHD TICKER.EX),
ISIN, CUSIP, or exact normalized name.
| Unrated | Rated | Name | ISIN | Match |
|---|---|---|---|---|
| Load ESG coverage to see matches. | ||||
panel_company columns isEtf, isAdr, isFund
(true = 1, false = 0, null = NULL). Categories are mutually exclusive when flags do not overlap.
| Flag | True | False | Null | Total |
|---|---|---|---|---|
| Load ESG coverage to see counts. | ||||
| Category | Count |
|---|---|
| — | |
| Symbol | Name | Country | Zone | Sector |
|---|---|---|---|---|
| Open this tab and click Refresh to load data. | ||||
| Zone | Total | AI | Legacy | None |
|---|
| Country | None | Total |
|---|
| Sector | None | Total | Co none | ETF none | ADR none | Fund none |
|---|
| Industry | None | Total | Co none | ETF none | ADR none | Fund none |
|---|
| Year | Freq | Assets |
|---|
| Year | Freq | Assets |
|---|
| Click Refresh to load. |
| Click Refresh to load. |
| Symbol | Year | Field | FMP | EODHD | Status |
|---|---|---|---|---|---|
| Click Refresh to load. | |||||
UPDATE panel_company SET sector=…, industry=… WHERE symbol=…).
Existing values are not overwritten unless Overwrite is checked.
If the DB user cannot UPDATE, results stay in preview mode.
| Symbol | Name | Country | Sector | Industry |
|---|---|---|---|---|
| Click Load to list company targets from MySQL (read-only). ETF, ADR, and Fund are excluded. | ||||
| Symbol | Status | Sector (before → after) | Industry (before → after) | FMP symbol | Detail |
|---|---|---|---|---|---|
| Click Refresh (write MySQL) to fetch FMP and UPDATE empty fields. | |||||
| Method | Return | Volatility | Sharpe |
|---|
| Ticker | Exp. Return | Volatility | β | α (ann.) | Current w. | Max Sharpe w. | Risk Parity w. | α/β w. |
|---|
Add views to activate Black-Litterman.
| Ticker | Name | Current | Target | Delta | Amount (€) | Qty | Tx cost | Action |
|---|
| Portfolio | Yesterday | 1 week | 2 weeks | 3 weeks | 1 month | 2 months | 3 months | 6 months | Avg gain (€) |
|---|
| Asset | Weight % | α ann. % | α period % | Beta | β Contribution |
|---|
| Ticker | Name | α CAPM % | t-stat | β mkt | R² | α FF5 % | t-stat | β SMB | β HML | β RMW | β CMA | R² FF5 |
|---|
| Factor | β | Relative weight | Direction |
|---|
| Ticker | Name | ESG Score | Grade | DCF Score | Upside % | Intrinsic | Price |
|---|
| # | Ticker | Name | α CAPM (%) | z(α) | z(ESG) | z(DCF) | Signal | Recommendation |
|---|
Paste ISINs or tickers (one per line or comma-separated). The app will search and pre-fill the details.
| Ticker | Name | Exchange | Currency | Qty | Avg Cost (€) | Fees (€) |
|---|
Upload a CSV file. Each row must have at least one of: ISIN, SEDOL, or Ticker.
After loading, click Validate to confirm each security via Yahoo Finance before importing.
| Status | Input ID | Matched ticker | Name | Exch. | Curr. | Qty | Avg Cost | Fees |
|---|
The CSV file must have a header row. Column order doesn't matter — the app matches by name (case-insensitive). Each row needs at least one of ISIN, SEDOL, or Ticker to validate against Yahoo Finance.
| Column | Required | Format / Values | Example |
|---|---|---|---|
| ISIN | one of 3 | 12-char alphanumeric | FR0000131104 |
| SEDOL | one of 3 | 7-char alphanumeric (London) | B7TL820 |
| Ticker | one of 3 | Yahoo Finance ticker | AAPL, AIR.PA, NESN.SW |
| Name | optional | Free text | BNP Paribas |
| Category | optional | Stock · ETF · Fund · Other | Stock |
| Quantity | optional | Decimal number | 10 or 10.5 |
| AvgCost | optional | Purchase price in € (decimal) | 45.50 |
| Currency | optional | EUR · USD · GBP · GBp · CHF · HKD | USD |
| EntryDate | optional | YYYY-MM-DD | 2024-01-15 |
| Target | optional | Analyst target in % (can be negative) | 15 or -5 |
| Sector | optional | Free text | Finance |
| Country | optional | ISO 2-letter code | FR US DE UK |
| Fees | optional | Transaction fees in € (deducted from P&L) | 12.50 |
ISIN,SEDOL,Ticker,Name,Category,Quantity,AvgCost,Currency,EntryDate,Target,Sector,Country,Fees FR0000131104,,BNP.PA,BNP Paribas,Stock,10,45.50,EUR,2024-01-15,15,Finance,FR,12.50 ,,AAPL,Apple Inc.,Stock,5,150.00,USD,2023-06-01,,Technologie,US,8.00 ,B7TL820,,Diageo plc,Stock,20,32.00,GBp,2024-03-01,10,Consommation,UK,5.00 IE00B4L5Y983,,IWDA,iShares Core MSCI World,ETF,15,70.00,EUR,2023-01-10,,Fonds,IE,3.00
| Name | Ticker | ETF % | Price | Intrinsic | Upside % | WACC | Score | Beta | Actions |
|---|
| Country | Ticker / index |
|---|
| Sector | Ticker / ETF |
|---|