summaryrefslogtreecommitdiffstats
path: root/website/content/excel/data-connectors.md
diff options
context:
space:
mode:
Diffstat (limited to 'website/content/excel/data-connectors.md')
-rw-r--r--website/content/excel/data-connectors.md36
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.
+
+:::