Plotly Studio generates Python code that uses Dash components, including editable tables! This means you can generate simulation apps that have editable tables akin to a spreadsheet.
Here’s an example I just made shows the performance of 3 different stock portfolios and you can edit the portfolios directly in the table:
Full prompt:
Editable, compact (short rows) ag grid table to create 3 portfolios (ticker, percentage of portfolio 1, portfolio 2, portfolio 3). Include 10 tickers (10% each for first portfolio, and then different ones for 2nd & 3rd) by default in table. Make table 500px tall, use column names P1, P2, P3 and set column width to 40px. Include a “submit button” below table that updates the charts with the portfolios in the table. Do popular UK stocks by default.
Then, display two charts on the right that are very short (200px)
- Historical returns of the 3 portfolios from the table as separate lines
- Monte Carlo Value at Risk calculator as a histogram showing P&L distribution for the 3 portfolios from table with rich hover data and risk metrics. Stagger annotations vertically.
Don’t display any other parameters.
Show in the chart hover data the portfolio composition.