Today we're launching the notebook in Investi. When a question needs a calculation, the analyst writes a short Python program, runs it on numbers from the filings, and puts the result in the chat as a table or a chart. Figures that came from a filing keep their source, so you can check a table one cell at a time.
Most research questions end in a calculation. What growth rate does today's share price assume? Did gross margin really slip, or did one bad quarter drag the average down? Done by hand, that means copying every number into a spreadsheet first. The notebook does the math in code you can read, on numbers you can trace back to where they were filed.
#What you can ask it to work out
You don't open a separate tool or write any code. You ask in chat, and the analyst runs the notebook when a question needs it. A few requests that do:
- "Run a reverse DCF on this company at a 9% discount rate." The analyst takes free cash flow from the 10-K and the current share price, then solves for the growth the price implies.
- "Chart gross margin for these five chipmakers over their last ten fiscal years." It builds each series from the companies' own filings and draws them on one chart.
- "Which of my holdings have moved together over the past three years?" It reads your positions from your connected brokerage, loads daily prices and returns a correlation table.
- "Here's my model as an Excel file. Where do my revenue assumptions differ from what the company filed?" It opens the attachment and lines your numbers up against the reported ones.
Tables sort by any column and download as CSV or Excel. Charts download as PNG or SVG, along with the data behind them.
#Filed figures keep their source
The code works from the same record the analyst reads: SEC filings from 1993 to today, government data such as FRED and BLS series, daily price history, and your portfolio if you've connected one. When the analyst puts a filed number in a table, it attaches the filing to that cell. Hover the number to see the form, the company and the filing date, with a link to the passage or table it came from.
A computed figure goes one level deeper. If free cash flow is operating cash flow less capital spending, the cell shows the formula and both inputs, and each input links to its filing. Each table also says how many of its figures are sourced, so a column of your own spreadsheet numbers is easy to tell apart from a column of filed ones.
Charts don't carry a source on each point. To check a line on a chart, ask for the table behind it.
#The code is on the page
Every run shows up in the conversation as a step with one line describing what it does. Hover that step to see the code and anything it printed. You don't need to read Python to use the result. If you do, you can check the discount rate, the date range or the formula in a few seconds, and if something looks wrong, say so and the analyst reruns it with the change.
AI can be wrong, and code can have a bug, so the analyst shows its work for you to check. We explain how that fits the rest of the analyst in How the Investi analyst works.
#Where the code runs
Each run happens in its own isolated process on our servers, with no internet connection and no passwords or keys. When the code needs data, it asks Investi, which fetches the data and hands it back.
The code can read your portfolio and no one else's, and it can't write files. If you've connected a data service of your own, the code can call it through the same route.
#Limits today
Each run starts empty, so nothing carries over from one run to the next. The analyst loads the data again each time, which means the code you see is the whole calculation. You can't edit the code and rerun it yourself; to change an assumption, ask: "redo it at 10%."
A run stops after two minutes of computing, not counting the time spent fetching data, and has 4 GB of memory. Price history is daily, and quotes are delayed 15 to 20 minutes. Nothing the notebook produces is a recommendation; it does the math you asked for and shows it.
#Get started
The notebook is on every plan, including Free. Ask any question that needs a calculation, or tell the analyst to "work it out in Python." To run it on your own holdings, connect your brokerage first. The features page shows the rest of the workspace.