diff options
Diffstat (limited to 'website/content/excel/data-connectors.md')
-rw-r--r-- | website/content/excel/data-connectors.md | 36 |
1 files changed, 31 insertions, 5 deletions
diff --git a/website/content/excel/data-connectors.md b/website/content/excel/data-connectors.md index 4094df81e40..2fda0f8deb6 100644 --- a/website/content/excel/data-connectors.md +++ b/website/content/excel/data-connectors.md @@ -18,29 +18,55 @@ import HeadTitle from '@site/src/components/General/HeadTitle.tsx'; OpenBB Add-In for Excel allows you to access your [data connectors](https://docs.openbb.co/pro/main-menu/data-connectors) from OpenBB Terminal Pro inside Microsoft Excel. This can be done using the [OBB.BYOD](https://docs.openbb.co/excel/reference/byod) function. -To access data from a [single widget](https://docs.openbb.co/pro/main-menu/data-connectors/single-widget) use: +## [Single widget](https://docs.openbb.co/pro/main-menu/data-connectors/single-widget) ```excel =OBB.BYOD("widget_name") ``` -To access data from your own [backend](https://docs.openbb.co/pro/main-menu/data-connectors/integrate-your-own-backend) use: +:::info + +- Make sure your widget is setup in the OpenBB Terminal Pro. + +::: + +## [Own backend](https://docs.openbb.co/pro/main-menu/data-connectors/integrate-your-own-backend) ```excel =OBB.BYOD("widget_name","backend_name") ``` -If your backend supports it is possible to pass a symbol, date or other optional parameters: +If your backend supports it is possible to pass a symbol, a date or other optional parameters: ```excel -=OBB.BYOD("widget_name","backend_name","my_symbol","my_date",{"param1":"value1","param2":"value2", ...}) +=OBB.BYOD("widget_name","backend_name","my_symbol","YYYY-MM-DD",{"param1":"value1","param2":"value2", ...}) ``` :::tip The easiest way to pass optional parameters is to write them into cells and reference them in the function. For example, `=OBB.BYOD(...,A1:B2)` where A1 contains "param1", B1 "value1", A2 "param2", B2 "value2" and so on. ::: -#### Additional notes +:::info - Make sure your backend's CORS settings allow requests coming from <https://excel.openbb.co>. - Requests via HTTP will be blocked by Excel. So if you are using the Add-in for Excel on Mac or Office on the web with Safari browser you need to run your backend via HTTPS. + +::: + +## [Native integrations](https://docs.openbb.co/pro/main-menu/data-connectors#native-integrations) + +Supported native integrations: + +- database +- snowflake + +```excel +=OBB.BYOD("widget_name","native_integration") +``` + +:::info + +- Make sure your OpenBB Data Connector is properly configured and the widget is setup in the OpenBB Terminal Pro. +- Native integrations are available only for Excel on the web or Windows. + +::: |