OpenCandle vs Spreadsheets
OpenCandle and spreadsheets work best at different stages of financial research. Spreadsheets are strong for owned models, repeatable calculations, scenario tables, and long-lived portfolio tracking. OpenCandle is stronger at the front of the workflow: gathering current evidence, routing a question to the right finance tools, recording provider gaps, and turning the evidence trail into a risk-aware answer.
OpenCandle is read-only research software. It does not place trades, route orders, or provide financial advice.
The Short Version
Use a spreadsheet when you already know the model you want to maintain. Use OpenCandle when you are still gathering evidence across quotes, filings, macro data, options chains, sentiment, fundamentals, crypto data, or portfolio context and you want the tool output visible before synthesis.
Comparison Table
| Capability | OpenCandle | Spreadsheet |
|---|---|---|
| Evidence gathering | Agent routes prompts to explicit finance tools | Manual imports, formulas, plugins, or pasted data |
| Provider gaps | Missing keys, stale data, and degraded sources are surfaced in the session | Usually tracked manually in notes or formulas |
| Portfolio context | Local state can be referenced in a conversation | Strong for maintained positions, allocation tables, and formulas |
| Repeatable models | Useful for first-pass research and workflow routing | Best fit for durable valuation, allocation, and scenario models |
| Collaboration artifact | Chat transcript, tool output, docs, and markdown context | Workbook tabs, formulas, comments, and exports |
| Trade execution | Not supported | Not supported unless connected to separate brokerage tooling |
Where OpenCandle Helps First
OpenCandle helps when the research question is still fluid. A user can ask for a quote, compare two assets, inspect options, pull a FRED macro series, search SEC filings, summarize sentiment, or review a local portfolio position without building a workbook first. The resulting answer can show which provider supplied the evidence, where data was missing, and what risks matter before any spreadsheet model is worth maintaining.
Where Spreadsheets Still Win
Spreadsheets win when the workflow is stable and arithmetic-heavy. Discounted cash flow models, position sizing tables, tax lots, rebalancing plans, and scenario matrices belong in a workbook when the user needs complete control over formulas and assumptions.
How To Use Them Together
Use OpenCandle to gather the facts and caveats, then move stable assumptions into a spreadsheet. This pairing keeps the spreadsheet focused on the model while OpenCandle handles the messy first pass across sources, provider availability, and natural-language follow-up questions.