Introduction to Anaconda Code including Python User Defined Functions!
In this informal session, we'll look at two of the features of Anaconda Toolbox for Excel:
1. Anaconda Code:
Configurable environment that runs locally in the add-in (data does not leave the workbook)
Ability to define Excel User-Defined Functions with Python (including functions that return charts!)
Use pyscript.com to build and share libraries of functions
Isolated Mode vs. Linked Mode
2. Anaconda Assistant - chat with an LLM directly in the add-in to get help with writing Python
Here are the links to the Pyscript.com tutorials for the TECHNICAL_ANALYSIS and SQL.* functions:
https://pyscript.com/@owenprice/excel...
https://pyscript.com/@owenprice/excel...