--- title: Copilot Basics sidebar_position: 7 description: Learn the basics of OpenBB Copilot interface and functionality keywords: - OpenBB Copilot - copilot basics - AI assistant - interface - prompt library --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; The OpenBB Copilot is an AI-powered companion seamlessly integrated into the OpenBB Workspace, designed to enhance and accelerate your financial analysis workflow. This sophisticated assistant understands natural language queries, retrieves data from multiple sources, performs complex analysis, and generates actionable insights. Built for financial professionals, the Copilot transforms your workflow by accelerating analysis and providing context-aware insights based on your specific datasets and workspace configuration.
OpenBB Copilot Interface
## Structure
Copilot interface structure
The Copilot interface is designed for intuitive interaction with a clean three-section layout: - **Header:** At the top, you'll find controls to manage your conversation. You can see which chat you're in, start a new one, clear the history, expand to full-screen mode, or hide the agent entirely. - **Body:** The main chat window where your conversation takes place. It displays the Copilot's answers, its step-by-step reasoning, and any output like charts, tables, or code. The chat automatically scrolls, keeping everything in chronological order. Hover over a message to see its timestamp. - **Footer:** Here, you can manage the data and widgets the Copilot uses as context for its answers. You can also add your own custom AI agents or open your prompt library. ## Full screen AI-chat You can resize the AI panel by dragging the border. In side-panel mode, it provides quick access for simple queries while maintaining your primary workspace view.
Full screen AI-chat
When expanded to full-screen mode, you gain maximum real estate for complex conversations, detailed reasoning steps, and large artifacts like comprehensive charts or extensive data tables.
Full screen AI-chat
This flexibility allows seamless transitions between quick consultations and deep analytical sessions without losing context or interrupting your workflow. You can also hide the AI agent entirely if you want to work solely with the dashboard.
AI agent hidden
## Prompt library The integrated prompt library serves as a productivity multiplier by storing and organizing your most valuable queries. You can save complex prompts and even tag widgets, to ensure the right context is utilized for the right prompt.
Prompt library
## Model The OpenBB Copilot is specifically optimized for financial analysis and data interpretation tasks, leveraging the latest models from OpenAI. For enterprise deployments, OpenBB provides seamless integration with your organization's Azure OpenAI. This ensures compliance with internal security and data sovereignty policies. If you would like full control over your agent capabilities, here's [our open source repository](https://github.com/OpenBB-finance/agents-for-openbb) with examples of AI custom agents that you can build and integrate into the OpenBB Workspace. --- --- title: Context Management sidebar_position: 8 description: Understanding how OpenBB Copilot manages and prioritizes context keywords: - context management - explicit context - dashboard context - global retrieval - conversation history --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; The Copilot employs a sophisticated context understanding system that prioritizes and processes multiple information sources simultaneously. This hierarchical approach ensures that the most relevant and specific data takes precedence when generating responses, while still maintaining awareness of broader workspace context and conversation history. ## Priority The agent prioritizes context in the following order: | Priority | Context Type | Description | |---|---|---| | 1 | Explicit | Widgets, skills, or MCP tools mentioned explicitly. | | 2 | Skill | Skills added under AI Library. | | 3 | MCP tool | Active MCP tools connected to the Copilot. | | 4 | Attached files | Files uploaded directly to the Copilot. | | 5 | Dashboard | All widgets currently on your dashboard (in all tabs). | | 6 | Conversation | The history of your current conversation. | | 7 | Global | All widgets available within the OpenBB Workspace, if Global Data is enabled. | | 8 | Web search | Retrieve information from the web, if Web Search is enabled. | ## Context Types ### Explicit Context Explicit context represents the highest priority information source, allowing you to precisely direct the Copilot's attention to specific datasets. This mechanism is particularly powerful for ensuring accuracy when working with multiple similar datasets or when you need analysis focused on a specific dataset. When you add any of the following explicit context types (widgets, skills, or MCP tools), Copilot prioritizes them above all other available information. After sending the prompt, the context remains active. #### 1. Skills When tagging a skill with the syntax `/skill:skill-name`, you are adding it explicitly to context.
Explicit context
#### 2. MCP Tools Similar to skills, MCP tools can be added to context using the `/` command. This displays a list of all available tools, allowing you to select exactly which one to trigger.
Explicit context
#### 3. Widgets Click the "Add to context" button on any widget to create a direct reference that Copilot prioritizes. Alternatively, use the "@" symbol followed by a widget name for a quick tag reference. Once the prompt is sent, the widget is removed from context.
Explicit context with @
### Skills Skills added under AI Library are prioritized next. Skills are reusable instruction sets that extend what the OpenBB Copilot can do. This is particularly useful when you want to create custom workflows. Even if you don't explicitly tag a skill, the Copilot will try to match one of the available skills to your request when relevant.
Skills overview
To see all available skills, navigate to the "Skills" tab under AI Library. An example skill called `openbb-html-report` is included by default. To add your own custom skill, see the [Skills](/workspace/analysts/ai-features/skills) page. ### MCP Tools Active MCP tools connected to OpenBB Workspace are the next priority level. For more details, see the MCP tools documentation [here](/workspace/analysts/ai-features/mcp-tools). Depending on your use case, MCP tools offer a powerful way to connect to third-party data providers or specialized financial tools using a standardized protocol. This eliminates the need for custom development inside OpenBB Workspace. To use MCP tools, first configure your servers (see [MCP Tools configuration](/workspace/analysts/ai-features/mcp-tools#configure-your-mcp-servers)), then select the desired tools.
MCP tools
When enabled, Copilot gains access to all active MCP tools. You can also explicitly call a specific MCP tool to guarantee it’s invoked.
MCP tools
### Attached Files The attachment system enables the Copilot to process documents and datasets that aren't part of your current workspace widgets. Supported file types include PDF, Excel, CSV, and various other document formats. The Copilot automatically extracts and indexes content from attached files, making them searchable and referenceable throughout your conversation. This capability is essential for performing ad-hoc analysis or incorporating external datasets and documents into your workflow. Please note that for PDF files, text must be selectable as Optical Character Recognition (OCR) is not supported. However, you can integrate your own agent that performs OCR.
Attached files
### Dashboard Context The dashboard context provides the Copilot with comprehensive awareness of your currently active dashboard. All widgets on your active dashboard become automatically available as data sources, allowing the Copilot to understand the broader context of your work session. It also has access to each widget's metadata and the currently selected parameters.
Dashboard context
### Conversation History Conversational context enables natural, iterative analysis by maintaining awareness of your entire dialogue history within the current session. The Copilot tracks your explicit questions and its responses. This memory allows for follow-up queries, refinement of analysis parameters, and building upon previous insights without needing to re-establish context. The Copilot understands references to "the previous chart", "that analysis", or "the data we discussed" and can seamlessly continue complex analytical workflows across multiple conversation turns.
Conversation history
### Global Data (ON/OFF flag) The Global Data provides the Copilot with access to the entire OpenBB Workspace widget library, extending far beyond your current dashboard widgets. When your current dashboard doesn't contain the specific data or analysis tool needed to answer a query, the Copilot can automatically identify and utilize the appropriate widgets from the entire widget library, effectively expanding your analytical capabilities on-demand without manual widget selection. This is only possible due to the metadata associated with each widget and is why it's important to invest time in specifying the metadata carefully.
Global retrieval
### Web Search (ON/OFF flag)
Web search
The web search capability enables the Copilot to access real-time information from across the internet when: - The available workspace data is insufficient to fully answer your query. - You ask to look for information on the web. This feature automatically activates as a fallback mechanism, ensuring comprehensive responses even when dealing with breaking news, recent market developments, or information not available in your current workspace widgets.
Web search
--- --- title: Data Handling sidebar_position: 9 description: How OpenBB Copilot processes structured and unstructured data keywords: - data handling - structured data - unstructured data - AgGrid - Plotly - document processing --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; ## Widget interaction Dynamic parameter modification represents one of the OpenBB's Copilot most powerful capabilities. The system understands the parameter schemas of each widget and can intelligently modify settings like date ranges, asset symbols, calculation periods, and analysis parameters to match your specific requirements. This eliminates the need for manual widget configuration and enables the Copilot to perform iterative analysis with different parameters automatically, such as comparing the same analysis across different time periods or asset classes within a single conversation.
Widget parameters
## Structured data The Copilot excels at processing and analyzing structured financial datasets through multiple specialized capabilities: - **Table widgets:** A natural language to SQL translation tool allows you to query tabular data from your widgets using plain English. Once your data is loaded in a tabular format, `text2sql` converts your questions into SQL queries under the hood and retrieves specific information from these tables. This allows you to explore and analyze your data through simple natural language questions.
text2sql querying tabular data
- **Plotly widgets:** Full-featured charting engine that not only generates interactive visualizations but also allows developers to provide the underlying data. The Copilot can extract specific data points, and create derivative analyses from existing visualizations. The AI agent will have better results in case the Plotly widget has raw data associated with it.
Plotly chart with raw data switch
## Unstructured data The Copilot's unstructured data processing capabilities enable comprehensive analysis of diverse document types and media: - **Document Processing (MD/PDF):** Advanced text extraction and comprehension. The system maintains document structure understanding, preserving context around tables and hierarchical information. This utilizes a sophisticated retrieval system that chunks large documents intelligently, maintains semantic relationships, and provides precise citations. The system can cross-reference information across multiple documents and identify contradictions or supporting evidence.
Document processing with citations
- **Web search:**: When the user provides a URL to the AI agent, it converts the web page to markdown for it to be parsed by the model - as done above.
Web search markdown conversion
- **Image Analysis:** Image processing capabilities for charts, screenshots, financial diagrams, and infographics. The Copilot can extract data from visual representations, understand chart types, and incorporate visual information into broader analytical workflows.
Image analysis extracting data from charts
--- --- title: Output Formats sidebar_position: 12 description: Understanding OpenBB Copilot's output formats and capabilities keywords: - output formats - citations - create widgets - user feedback --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; The Copilot's output system delivers comprehensive, contextual responses that synthesize all available information into actionable insights. Each response is structured to provide immediate answers while supporting deeper investigation, combining direct responses with supporting evidence, data visualizations, and clear pathways for follow-up analysis. ## Citations Comprehensive citation system ensures full traceability and verification of all information sources used in responses. The citation system provides different levels of detail based on source type: - **Widget citations:** Direct links to widgets with parameters selected. Smart linking enables "Scroll to widget" functionality for existing dashboard widgets. If the widget doesn't exist in the dashboard or has modified parameters the linking will provide a "Add widget to dashboard" options to facilitate workspace workflow.
Widget citations
- **Document citations:** Precise page and section references for PDF documents with automatic highlighting of relevant content areas.
Document citations
- **Web citations:** Full URL references when web pages are utilized.
Web citations
## Create widgets from AI output The widget creation system enables seamless integration of Copilot-generated content into your workspace environment. This capability transforms temporary conversational outputs into permanent analytical assets that can be referenced, shared, and incorporated into ongoing workflows. The system supports multiple artifact types including formatted text summaries, interactive data tables with sorting and filtering capabilities, and fully functional charts with preserved interactivity. - Text widget:
Text widget from AI output
- Table widget:
Table widget from AI output
- Chart widget:
Chart widget from AI output
## User feedback loop The thumbs up and down buttons in the agent output allow the user to provide feedback in terms of their experience with the copilot. That data can be utilized to create a flywheel that allows developers to understand how the AI agent can be improved. While the thumbs up does not prompt the user for any additional details.
Thumbs up
The thumbs down asks for clarification of what went wrong.
Thumbs down
--- --- title: Step-by-Step Reasoning sidebar_position: 11 description: Understanding the transparent reasoning process of OpenBB Copilot keywords: - step-by-step reasoning - planning - querying widgets - intermediate artifacts - transparency --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; Transparency and auditability are fundamental to the OpenBB's Copilot design, with comprehensive step-by-step reasoning displayed for every analysis. This detailed process visibility enables users to understand the logical flow, verify data sources, identify potential biases, and ensure compliance with analytical standards. The reasoning display serves both educational and quality assurance purposes, building user confidence while maintaining the ability to audit and reproduce analytical processes.
Step-by-step reasoning
## Planning The planning phase demonstrates the Copilot's tactical thinking by decomposing complex analytical requests into logical, sequential sub-tasks. This planning process considers data dependencies, optimal execution order, and resource requirements. The displayed plan serves as a roadmap that users can review before execution, ensuring alignment with analytical objectives and providing clear expectations for the upcoming analysis workflow.
Planning
## Querying widgets Widget query transparency provides complete visibility into data retrieval operations, including the specific widget accessed, all parameters used, and data source information. This documentation enables users to understand exactly what data was retrieved, verify parameter settings, and reproduce the analysis independently. The system also displays any parameter modifications made automatically, ensuring full awareness of how the Copilot adapted widget configurations to meet query requirements.
Querying widgets
## Intermediate result artifact Intermediate artifacts provide crucial visibility into the Copilot's analytical methodology by displaying generated code, SQL queries, calculation formulas, and other technical implementations. These artifacts serve multiple purposes: enabling technical review and validation, supporting learning and knowledge transfer, facilitating debugging and optimization, and ensuring compliance with analytical standards. Users can examine and reuse these artifacts, treating them as valuable analytical assets beyond their immediate application.
Intermediate result artifact
## Artifact generated Final artifacts represent the culmination of the analytical process, displayed with complete context about their creation methodology. The step-by-step reasoning (status updates) maintain full provenance information, including data sources, transformation steps, and parameter settings used in their generation. The system preserves the relationship between artifacts and their creation process, enabling users to understand not just what was created, but how and why, supporting both immediate use and future reference or modification.
Final artifact
--- --- title: Generative UI sidebar_position: 13 description: Understanding the Generative UI capabilities in OpenBB Copilot keywords: - generative ui - widgets - dynamic creation - widget parameters - dashboard manipulation --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; When Generative UI is enabled, the copilot can manipulate widgets directly on your dashboard. ## Update widget parameters The copilot understands the parameter schemas of each widget and, based on your prompt, can automatically update the parameters across widgets on the dashboard.
Widget parameters
## Add widgets from Global Data If Global Data is enabled and you ask for information that the copilot finds in the widget library, the matching widget is automatically added to your dashboard.
Widget parameters
## Add markdown note widget The copilot can also add text content as a markdown note widget directly on your dashboard.
Widget parameters
## Add and edit navigation bar The copilot can add navigation bars to your dashboard, allowing you to organize widgets into separate tabs for a cleaner and more structured layout.
Add navigation bar
Beyond adding new tabs, you can also use this feature to edit existing tab names within the navigation bar.
Add navigation bar
As shown in the examples above, all of these actions can be performed across multiple widgets, navigation bars, or parameters at once. For example, you can ask the copilot to add multiple navigation tabs, each containing a different set of widgets, saving you from making one change at a time. ## Create widgets on the fly The copilot can take its own outputs, such as tables, charts, or markdown notes, and turn them directly into widgets on your dashboard. Instead of copying results manually, the Generative UI feature adds the copilot's response as a fully interactive widget that lives alongside the rest of your data.
Create widget on the fly
--- --- title: MCP Tools sidebar_position: 11 description: Model Context Protocol (MCP) tools integration in OpenBB Copilot keywords: - MCP - Model Context Protocol - tools - integration - external tools --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; Model Context Protocol (MCP) integration enables seamless connection to third-party data providers, analytical services, and specialized financial tools without requiring custom development within the OpenBB Workspace.
We use the [use-mcp library](https://github.com/modelcontextprotocol/use-mcp) and support both MCP and SSE protocols, but not STDIO. If you need STDIO support, we recommend exploring solutions like [supergateway](https://github.com/supercorp-ai/supergateway). ### Configure your MCP Servers To configure your MCP servers, open the MCP server menu from the copilot settings.
From here, click "Manage MCP servers" in the top right to add, edit, or delete MCP servers.
This opens the MCP Servers tab under AI Library, where you can view all available ones and their active or inactive status. To add a new MCP server, click on the "Add server" button on the top right.
This opens the MCP server configuration dialog. Fill in the details, such as the server name and URL.
If your chosen MCP server requires authentication, similar to the one from Financial Modelling Prep below, click the "Add Custom Header" button in the bottom left and enter the key-value pair.
Once you click "Add", you return to the MCP Servers tab where you can see each server's active status. Click on a connected server to view its discovered tools, and expand any tool to read its description.
### Select MCP Server tools With the MCP Tools dialog open, you can enable or disable specific MCP tools for Copilot access.
Once an MCP Server is successfully connected, you can: 1. **Select all or none**: toggles every tool from a specific MCP server at once. This is the quickest way to include or exclude an entire server from Copilot's context. 2. **Enable or disable individual tools**: gives you granular control over which tools from a server are available to Copilot. Enabling all tools does not guarantee Copilot will use every one. It simply makes them available. This granular control helps keep Copilot's context focused on what is most relevant to your needs. ### MCP in action When you submit a query to Copilot with MCP tools enabled, it can utilize one or more tools based on your prompt, including sequential tool usage when necessary. For example, accessing OpenBB documentation requires two tools from the same MCP Server. Copilot automatically determines and executes this sequence on your behalf.
### Matching widget to MCP tools In the reasoning step shown above, you can see when each MCP tool was called. You can also configure a widget with matching metadata. This links the widget to its corresponding MCP tool. Once a matching widget is set up, a citation marked with an asterisk (\*) appears whenever the MCP tool is used. Widget hover tooltip showing option to add to dashboard Click “Add matching widget to dashboard” to add the widget to your current dashboard with the same parameters applied by Copilot. Interactive widget dashboard showing parameters, charting, and OpenBB properties --- --- title: Skills sidebar_position: 14 description: Create and invoke custom AI skills from the OpenBB Copilot chat interface keywords: - skills - custom skills - AI skills - skill commands - reusable prompts - copilot skills --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; Skills are reusable instruction sets that tell the Copilot how to perform a specific task. Instead of typing the same detailed prompt every time, you can create a skill once and invoke it directly from the chat with a simple command.
Skills overview
For example, the `/openbb-html-report` skill, included by default, generates a full HTML report using data from your dashboard. Inside the skill, you can define report types, suggested structures, writing style, formatting rules, and any other guidelines for the Copilot to follow.
Skills overview
## Creating a skill To create a new skill, open the Skills tab under AI Library and select the "Add Skill" button in the top right corner. Give your skill a name, a description, and the instructions the Copilot should follow when invoked.
Creating a skill
## Using a skill The Copilot automatically tries to identify a relevant skill before proceeding with a task. Simply mentioning the skill name in your prompt will very likely trigger it.
Invoking a skill
If you want to force a specific skill, you can type `/skill:skill-name` to tag it directly. This ensures the Copilot invokes that exact skill.
Invoking a skill
## Viewing all available Skills You can type `/` in the chat to see the full list of available Skills and MCP tools. You can also hover over it to see the skill description.
Invoking a skill
--- --- title: Apps sidebar_position: 4 description: Discover and use OpenBB Apps - pre-configured dashboard templates with integrated AI agents and custom prompts for optimized analytical workflows. keywords: - OpenBB Apps - Dashboard Templates - AI Agents - Custom Prompts - Workflow Optimization - Financial Analysis - Portfolio Management - Market Research --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; # Apps Apps in OpenBB Workspace are pre-configured dashboard templates that combine widgets, pre-selected AI agents, and custom prompts to create optimized analytical workflows. Unlike individual dashboards that you build from scratch, Apps provide instant access to complete analytical environments designed for specific use cases.
OpenBB Workspace Multiple Applications View
## What are Apps? Apps function as analytical templates that combine three core components: widgets, prompts, and pre-selected agents. ### Widgets Apps include curated sets of widgets that are specifically optimized for their analytical workflow. These widgets come with parameter synchronization, automatically linking shared parameters to maintain analytical coherence across all components. The layout design positions and sizes widgets optimally for data visualization and workflow efficiency. ### Prompts An App can include a custom library of pre-written prompts tailored to its analytical focus. These prompts provide app-aware AI instructions and enable more effective interactions with the specialized agent. E.g.: - "Please analyze my current portfolio holdings. What are the top 5 positions by weight? Are there any concentration risks I should be aware of?" - "What are the strongest correlations between my portfolio holdings? Which positions might provide good diversification benefits?" - "What is my current sector exposure compared to market benchmarks? What are the risks and opportunities in my current allocation?" These prompts are specifically crafted for the App's analytical context, enabling consistent analysis approaches and more targeted AI assistance. ### Agents Apps can advertise a particular AI agent that is optimized for its analytical domain. When you click on an App with a specified agent ID, OpenBB Workspace automatically selects the corresponding AI agent. ## How Apps Differ from Dashboards While dashboards are blank canvases that you customize entirely yourself, Apps provide structured starting points: | **Apps** | **Dashboards** | |----------|----------------| | Pre-configured templates with specific analytical purpose | Blank canvas for custom configuration | | Widgets with pre-linked parameters | Manual parameter configuration required | | Come with curated prompt libraries | Start with no predefined prompts | | Designed by domain experts for specific workflows | General-purpose analytical workspace | Once you click on an App, it gets immediately rendered as a dashboard that you can also customize. ## Apps Gallery To see Apps examples that you can do, check [our solutions page](https://openbb.co/solutions). Here's an example of a Portfolio Risk Management dashboard (converted from an App).
Portfolio Risk Management Dashboard
--- --- title: Dashboards Overview sidebar_position: 0 description: Learn how to create, manage, and share interactive dashboards in OpenBB Workspace keywords: - dashboards - data visualization - financial analysis - widgets - collaboration - reporting --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; # Dashboards Dashboards are the interactive environments where you bring financial data to life in OpenBB Workspace. They let you organize multiple widgets into cohesive analytical views, combining visualization and analysis in a flexible layout tailored to your needs. ## What are Dashboards? Dashboards provide a canvas where you arrange and organize multiple data widgets into cohesive analytical views. They enable you to create custom layouts for different analysis workflows, monitor real-time market data and indicators, share insights with team members, and generate professional reports for documentation and presentations. The flexible layout system allows you to drag and drop widgets exactly where you need them, resizing and arranging components to emphasize important data and create visual hierarchies that match your analytical priorities. Dashboards refresh automatically so that your analysis always reflects current data conditions. Collaboration is built into the application through dashboard sharing capabilities. Team members can view shared dashboards and create their own copies for further customization while preserving the original configuration. ## Dashboard Folders Organize your analytical workspace by creating folders in the left sidebar to group related dashboards together. This organizational structure helps maintain clarity and efficiency as your collection of dashboards grows. To create a new folder, click the "+" icon in the sidebar and select "New Folder". Name your folder descriptively to reflect its contents, such as "Portfolio Analysis", "Market Research", or "Daily Reports". You can then drag and drop existing dashboards into these folders or use the "Move to" option from the dashboard's ellipsis menu. Folders can be nested to create hierarchical organization structures that match your workflow. For example, you might have a main "Research" folder with subfolders for different sectors or asset classes. This flexibility allows you to maintain a clean, navigable workspace even with dozens or hundreds of dashboards. ## Dashboard Management Access the management options through the ellipsis menu next to each dashboard in the sidebar: - **Rename** - Customize dashboard names for better organization - **Move to** - Organize dashboards into folders for structured workflows - **Duplicate** - Create copies with all widgets and settings intact - **Open in new window** - Expand across multiple monitors - **Share** - Collaborate with team members - **Delete** - Remove unused dashboards - **Refresh data** - Update all widget data immediately ## Dashboard Actions Right-clicking anywhere on the dashboard canvas provides quick access to essential functions: - **Add widget** - Quickly add a new widget to your dashboard - **Add data** - Import new data sources directly from the dashboard - **Refresh data** - Update all widget data with the latest information - **Refresh backends** - Reload backend connections and configurations (good for development purposes) - **Export apps.json** - Export your dashboard configuration as an `apps.json` - **Disable grouping** - Toggle widget grouping functionality ## Creating Your First Dashboard 1. Click the "+" button in the sidebar to create a new dashboard 2. Give your dashboard a descriptive name 3. Add widgets by clicking the "Add Widget" button (or right clicking and selecting "Add Widget") 4. Arrange widgets by dragging them to desired positions 5. Resize widgets to create your optimal layout 6. Add a navigation bar widget so you can separate widgets based on different categories 7. Save your dashboard to preserve your configuration --- --- title: Excel Add-in Installation sidebar_position: 14 description: This page presents the general requirements and the steps to install the OpenBB Add-in for Excel. The OpenBB Add-in for Excel is available on Windows, Mac, and Excel on the web. It can be installed by an administrator or by individual users. keywords: - Microsoft Excel - Add-in --- import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; ## Requirements - The OpenBB Add-in for Excel is available on the following platforms: Windows (Microsoft 365), Mac (Microsoft 365), Excel on the web. - Access to OpenBB Workspace. If you don't have access you can sign up [here](https://my.openbb.co/app/pro). ## Installation
## Core capabilities ### Production-Ready UI Framework Transform your workflows with a fully customizable UI that adapts to your team's specific needs. OpenBB Workspace gives you complete control over every aspect of the interface, allowing you to tailor it precisely to your workflow requirements. Teams can collaborate through shared dashboards and applications, while the flexible framework enables you to build comprehensive solutions ranging from simple data visualizations to complex AI-powered workflows. ### Unified Data Integration OpenBB Workspace brings all your data sources together in one secure, scalable system. Whether you're working with proprietary internal data, licensed third-party feeds, or public datasets, the Workspace provides data access through a single interface. The system handles both structured and unstructured data with equal ease, and its open architecture supports flexibility as your needs evolve. ### AI Agent Integration Deploy and manage AI agents in a secure, controlled environment that puts you in charge. OpenBB Workspace offers the flexibility to integrate any AI agent that supports your workflows, whether it's powered by a proprietary model, open-source solution, or third-party service. Agents run in a protected environment with carefully controlled data access, ensuring security and compliance when connecting AI capabilities to your existing processes. This integration happens naturally within your workflows, enhancing rather than disrupting your established practices. ### Enterprise-Grade Deployment OpenBB Workspace provides the deployment flexibility modern enterprises demand. Deploy the Workspace on-premises or in your private cloud, maintaining complete control over your infrastructure and data. Your sensitive information never leaves your environment, staying protected within your existing security perimeter. The system includes detailed role-based access controls, allowing you to implement fine-grained security policies that align with your organization's requirements and compliance standards. ## Key concepts ### Widgets Widgets are the fundamental data units in OpenBB Workspace. Each widget represents a self-contained data component with: - **Data Source**: Integration with internal or external data sources - **Metadata**: Title, description, category, sub-category and source information - **Visual Layer**: Presentation through tables, charts, PDFs or images and other feed formats - **Parameters**: Configurable input parameters for data display and interaction Widget Metadata Structure and Components ### Dashboards Dashboards are your personal spaces in OpenBB Workspace, designed to adapt to your unique analytical style and requirements. Each dashboard starts as a blank canvas where you can create your perfect analytical environment by combining elements from your entire widget library, organizing and customizing them in ways that make sense for your specific workflows. The power of dashboards lies in their flexibility. You can add widgets and group them by linking their parameters - when you update a date range or a ticker symbol in one widget, related widgets will update automatically. This parameter grouping ensures your analysis remains synchronized across multiple data views. OpenBB Workspace Dashboard Interface Beyond dynamic data widgets, dashboards support a rich variety of content types. You can enhance your analysis by adding static files like PDFs, images, text documents, and spreadsheets, incorporating AI-generated artifacts directly from your chats, or writing notes to document your thought process and findings. This combination of dynamic data, static resources, and personal annotations creates a wide-ranging analytical workspace that captures both the quantitative and qualitative aspects of your research. Once you've crafted your perfect dashboard, sharing it with your organization is effortless. Team members can access your shared dashboards to benefit from your analytical setup. This transforms individual insights into collective intelligence, elevating your dashboards to become organizational assets and fostering collaboration and knowledge sharing. ### AI Agents AI Agents make OpenBB Workspace an intelligent system that understands your data and automates complex workflows. These agents leverage the metadata from your widgets to query the right datasets with appropriate parameters. What makes AI Agents particularly powerful is their contextual awareness. They can access your entire dashboard ecosystem, understand relationships between different data sources and maintain context across multiple queries. This enables sophisticated multi-step analysis where agents can gather data from various widgets, perform calculations, generate insights, and even create new visualizations based on their findings. OpenBB Workspace AI Agents Interface AI Agents excel at both reactive and proactive analysis. They can respond to your specific queries about market conditions, company performance, or economic indicators while also monitoring your dashboards for anomalies, trends, or opportunities that require attention. You can configure agents with custom instructions and prompts, creating specialized assistants for different analytical tasks – from earnings analysis to risk assessment to market surveillance. The integration between AI Agents and your widget library creates a multiplier effect. Agents can dynamically combine data from multiple sources to apply advanced analytical techniques, and present results in formats that best suit your needs. OpenBB Workspace AI Agent Widget Integration Finally, AI agents can produce artifacts (text, tables, charts) that are added back to the dashboard, closing the feedback loop. ### Apps Apps are pre-built dashboard templates designed for specific workflows. Each app includes a curated set of widgets with parameters already linked, a pre-selection of an AI agent for the task at hand, and custom prompts relevant to that use case. When you change a ticker or date range, all connected widgets update together. OpenBB Workspace Multiple Applications View Examples include portfolio management apps with position tracking and risk metrics, market surveillance apps with data monitoring and anomaly detection, and research apps with fundamental analysis and news sentiment tools. The workspace supports unlimited apps that can be shared across teams and customized to fit your exact needs. Explore our app gallery and use cases at [openbb.co/solutions](https://openbb.co/solutions). OpenBB Workspace Applications Overview #### Prompts: Context-Aware Suggestions Prompts are query suggestions specific to each app. The AI agent knows your widget library and can automatically tag relevant widgets when responding to prompts. For example, in a portfolio app, prompts might suggest "Show me today's top performers" and automatically reference the position tracking and performance widgets. This context awareness means prompts always work with the actual data available in your app, eliminating guesswork and ensuring accurate, relevant responses.