Calling =TECHTO_SIMULATION for Stochastic Simulation in Excel is just a matter of copying and pasting

=TECHTO_SIMULATION in Excel is based on R and Python code from the Techtonique project’s univariate and multivariate time series SIMULATIONing functions.

Here’s a unified way to use =TECHTO_SIMULATION directly and easily in Excel with xlwings Lite:

• If you haven’t done it yet, install xlwings Lite https://lite.xlwings.org/installation and click on its icon in the top right corner to open the editor

• Get a token from https://www.techtonique.net/token

• In the xlwings Lite editor, click on the dropdown menu > Environment variables

• Name the environment variable TECHTONIQUE_TOKEN, provide its token value, and push “Save”

• In the main xlwings Lite code editor (main.py), paste:

from techtonique_apis import TECHTO_SIMULATION

• In xlwings Lite’s requirements.txt, paste:

xlwings==0.33.14  # required
python-dotenv==1.1.0  # required
pyodide-http  # required
black  # required
techtonique_apis

Related