CTRL+ALT+JOPX

Understanding conda channels

2026-03-14T15:39:00.004+01:00

Conda channels are package source - locations where conda looks for software packages when you run conda install. Each channel can contain different package versions, build configurations, platform-specific binaries, etc ...

In the screenshot above, you will notice 4 different conda channels:

defaults: the official Anaconda repository, has stable, curated with conservative updates
microsoft: Microsoft maintains its own channel mainly for AzureML environment support or packages tuned for Windows performance.
anaconda: similar to the defaults channel
conda-forge: community driven, massive ecosystem with the latest versions. Receives updates within hours of upstream releases

You can add a channel using this command: conda config --add channels microsoft. Conda searches channels in order, from highest priority to lowest. So from my configuration, it first try to install from defaults. If not found, it falls back to microsoft, and so on ...

Quick tip: fix eID Viewer installation - a driver can't load on this device

2026-01-13T21:11:00.002+01:00

I recently had to use the Belgian eID software and couldn't get it to work on the Windows 11 - it always failed with "A driver can't load on this device" - in the end I had to Turn off memory integrity setting (Microsoft support)

Since keeping the memory integrity setting is highly recommend - I would change the setting as soon as possible. Uninstall the Belgian eID software after you have used it and run pnputil to remove the faulty drivers so that you can enable the memory setting again.

Quick tip: retrieving raw, unprocessed files stored in Github

2025-12-28T10:53:00.007+01:00

The domain raw.githubusercontent.com serves raw, unprocessed files stored in Github repositories - think of it as GitHub's "direct file download" backend. Tools like curl, wget or Python scripts can fetch files directly using a specific url composed of the user name, repo, branch, folder and filename

curl -O https://raw.githubusercontent.com/[user]/[repo]/[branch]/[folder]/[filename]

example: curl -O https://raw.githubusercontent.com/jorisp/tradingnotebooks/master/data/DJI.csv

You can also read these raw files form GitHub using pandas.read_csv

Quick tip: checking your Github Copilot settings

2025-12-24T09:02:00.007+01:00

Open https://github.com/settings/copilot/features

References:

Interactive Pandas dataframes with ITables 2.0

2025-12-23T07:56:00.001+01:00

ITables is a Python package available on Github (maintained by Marc Wouts) which changes how Pandas and Polars dataframes are rendered in Python notebooks and other Python applications. It works out of the box without any dependencies in Jupyter, Dash, Streamlit and Marimo.

For more info see:

Enable and disable Data Wranger in VS Code for Pandas DataFrame and Series

2025-12-23T07:43:00.006+01:00

To disable default rendering of Pandas DataFrames in VS Code Jupyter Notebook with Data Wrangler (after installing the extension) - follow these steps:

Open Command Palette : Preferences: Open Settings (UI)
Search for: Data Wrangler
Uncheck the Data Wrangler>Output Renderer: Enabled Types for Pandas Dataframe and Series to disable the rendering and check them again when needed

Related links:

Getting started with Data Wrangler in VS Code

Datawrapper: enrich your stories with charts, maps and tables

2025-12-07T17:15:00.001+01:00

Datawrapper is designed to make professional-quality charts, maps and tables - even for those without coding or design skills. Also check out their blog which has excellent posts such as Fix my chart - turning donuts into bars (Part of the Data Visualization Do's & Don'ts).

"Statistiek Vlaanderen" (government agency in Flanders) makes extensive use of Datawrapper - it has used it to create more than 2000 Datawrapper charts and maps on more than 300 webpages. (Statistics Flanders: "We want to reach everyone")

Source: International migration (July 2025) - Statistics Flanders

Quick tip: Upgrade yfinance as part of OpenBB

2025-10-13T20:35:00.000+02:00

I have noticed that the yfinance Python package requires regular updating to keep it working. yfinance is also one of the core libraries inside OpenBB and you can upgrade it independently of the other packages using this command

pip install --upgrade openbb-yfinance

References:

Divididend analysis of Telenor ASA using Jupyter Notebook

2025-08-06T07:13:00.007+02:00

Cross posted from Divididend analysis of Telenor ASA using Jupyter Notebook

I just published the notebook dividends.ipynb on my GitHub repository jorisp/tradingnotebooks which shows how dividends contribute to the total return. This notebook uses the yfinance API to retrieve the data. I used Telenor ASA (a Norwegian telecom operator) as an example.

If you are considering to invest in foreign dividend stocks as a Belgian investor, you need to keep in mind the double taxation of dividends. Even with a withholding tax applied abroad, the Belgian government will tax your dividend again at a flat rate of 30%.

Disclaimer: The information on this blog is intended solely for informational and educational purposes. I am not a certified financial advisor, and the content provided here does not constitute professional financial advice. (Full disclaimer)

Getting financial data in Python using the OpenBB SDK

2025-03-18T21:17:00.008+01:00

The OpenBB SDK (also known as OpenBB Platform) is developed as open-source (the code is available on https://github.com/OpenBB-finance/OpenBB) by the company Open BB. The OpenBB SDK provides programmatic access to a wide range of financial data sources from one place in a standard way.

The OpenBB SDK was developed to drive the OpenBB Workspace (See Introducing the new OpenBB Terminal ) which provides a customizable platform for financial analysts, investors and researchers that rivals traditional financial terminals without the steep costs.

By default, the OpenBB SDKwill attempt to download data from free sources such as Yahoo Finance but OpenBB SDK integrates with multiple other data sources as well such as , Alpha Vantage, FRED,FMP,SEC,etc .... In most OpenBB API platform calls, you can indicate a different data source - some of them free others requiring a separate subscription - allowing you to pull equities, options, crypto, forex and macroeconomic data using a single SDK.

Since you can access both historical and real-time market data, OpenBB is ideal for backtesting and live trading strategies. The SDK is compatible with Jupyter Notebooks, Python scripts, and automated trading systems. I recently tested the OpenBB SDK as an alternative to Pandas_DataReader in Jupyter Notebooks, and it worked flawlessly.

I shared this Jupyter notebook on my Github repo:

https://github.com/jorisp/tradingnotebooks/blob/master/openbbdemo.ipynb

Please note that many of the code samples found in various articles and posts are no longer functional due to significant changes in the codebase. The shared Jupyter notebook has been tested with OpenBB 4.3.5 and Python 3.12.8.

Quick tip: command prompt shortcut for PAC development tools

2025-03-18T18:39:00.006+01:00

Last year, I blogged about how you can use PAC to start the Plugin Registration Tool and Configuration Tool (see Start CRM development tools from command prompt with Power Platform CLI).

Remember that you quite easily create a shortcut for this as well by using "C:\Windows\System32\cmd.exe /k pac tool prt" as input for the shortcut.

Quick Tip: installing Azure Service Bus Explorer with Chocolatey

2025-03-18T18:23:00.005+01:00

Recently I had to reinstall Azure Service Bus Explorer on a new laptop and it seems that you now need to use Chocolatey (a package manager for Windows) to install Azure Service Bus Explorer.

Installing Chocolatey, is quite straightforward, - you need to follow the steps outlined on Install Chocolatey for individual use - I installed Chocolatey using PowerShell prompt (with elevated privileges) and did not encounter any issues.

Next you can simply install Azure Service Bus Explorer from command prompt using "choco install servicebusexplorer". By default it will install into this folder C:\ProgramData\chocolatey\lib\ServiceBusExplorer\tools\ServiceBusExplorer.exe . No issues encountered with version 6.0.3

The Rational Reminder podcast - favorite episodes from 2024

2024-12-28T08:15:00.008+01:00

I started listening to the Rational Reminder Podcast somewhere around the beginning of this year and I can highly recommend it to anyone interested in passive evidence based investing and financial decision making.

The Rational Reminder podcast is weekly podcast about personal finance and investing from a couple of Canadians, Benjamin Felix and Cameron Passmore - both work at PWL Capital. The hosts are experienced portfolio managers who share their knowledge about a broad range of financial topics and the show often features interviews with industry experts, offering diverse perspectives and deep dives into specific areas of finance.

Benjamin Felix also creates educational content on YouTube https://www.youtube.com/@BenFelixCSI where he shares insights on investing and financial planning

Both advocate for evidence-based investing, which often includes passive investment strategies such as index funds and they emphasize the benefits of low-cost, diversified, and long-term investment approaches, which align well with passive investing principles.

Episodes which I really liked:

Hidden gem : the business process catalog for Dynamics 365 apps

2024-12-23T07:13:00.002+01:00

The business process catalog for Dynamics 365 apps is an Excel workbook that contains more than 700 processes grouped by end-to-end scenarios and business process areas for different products (Dynamics 365 SCM, Business Central, Customer Service etc ...). It can be used as a blueprint for requirement-gathering and implementation templates.

Microsoft updates the catalog at least four times each year and the latest November 2024 release was recently made available. This latest releases includes:

Azure DevOps templates that you can use to track your implementation
Configuration deliverable downloads for Finance and Operation apps as well as Customer Engagement apps.
AI generated process flow diagrams for level 3 processes to accelerate the discover process.

Download the latest version on https://aka.ms/businessprocesscatalog and explore AI generated flow diagrams at https://aka.ms/businessprocessflow

Dynamics 365 Contact Center - the new kid on the block

2024-12-22T09:28:00.005+01:00

In July 2024, Microsoft announced general availability of Microsoft Dynamics 365 Contact Center. This Contact Center As A Service (CCAAS) offering allows Microsoft to compete against players such as ...

It most likely is also a way for Microsoft to embed the Nuance offering more directly into the Dynamics 365 platform. It can be quite a daunting task for consultants and customers trying to come up with a cost simulation since licensing is not that easy taking into account the different capabilities in the platform (or as Tricia calls it "licensing a contact center deal can be a special place in hell" - in Licensing the Dynamics 365 Contact Center Part 1

Data flow and components in Dynamics 365 Contact Center architecture:

Customers can connect through preferred channels including Teams for internal helpdesks. Licensing and operational cost vary depending on the required channels to support
Azure Communication Services (ACS) offers PSTN integration for voice
Works not only with Dynamics 365 CRM (Customer Service) but also with other CRM platform such as Salesforce and ServiceNow
Use Copilot Studio to configure AI agents and IVR setup
Routing based on Unified routing framework
Agents work in the Agent Workspace or Customer Service Workspace if you are using Dynamics 365
Connectors allow easy integration with Microsoft 365
Typical AI scenario's supported such as case summary, conversation summary, draft e-mails and knowledge article support (mainly existing functionality which already surfaced earlier in Dynamics 365 Customer Service)
Built on top of Power Platform with Dataverse as the core building block
Built in monitoring, management and analytics & reporting functionality

If you want to learn more about this platform - I suggest that you follow Chris Goodwill on LinkedIn and join the Dynamics 365 Contact Center LinkedIn Group

Related posts:

Thoughts about Artificial Intelligence and business value

2024-12-21T16:01:00.004+01:00

The question that a lot of companies have, is how to realize business value from AI. Obviously companies don't invest millions (billions) of dollars in artificial intelligence just to play around with LLMs. Companies need to quantify the business value they want to realize.

To get an answer to this question, you might want to take a look at the white paper Research paper - Artificial Intelligence and business value: a literature review (2021, Ida Merete Enholm, Emmanouil P., Patrick Mikalef and John Krogstie) which provides a framework for connecting AI with business value.

The white paper distinguishes between first and second order effects of GenAI. First order effects are the immediate, direct impacts of implementing Generative AI whereas second order effects are indirect, longer-term impacts that result from the first-order effects.

While first order effects (e.g. enhancing business decisions, increasing process efficiency and transforming business processes) are crucial for justifying the initial investments and demonstrating immediate ROI, second order effects (impact on operational and financial improvements, sustainability etc...) are essential for long term strategic planning and understanding the broader implications of Generative AI.

API Playground in Dataverse Accelerator App

2024-12-20T16:54:00.003+01:00

The API playground is a pre-authenticated software testing tool which is part of the Dataverse Accelerator App. API playground allows you to quickly interact with the Microsoft Dataverse Web API - check out Explore and test Dataverse in the Web API playground (Preview)

Book review: beyond diversification - what every investor needs to know about asset allocation

2024-09-29T20:27:00.006+02:00

I recently finished reading Beyond diversification from Sebastien Page. Sebastien Page (Chief Investment Officer at T. Rowe Price) explains in Beyond diversification the different approaches to forecasting returns, risks and correlations across asset classes by combining academic research and practical hands-on examples.

This book is most likely targeted at the sophisticated investor and should not be the first book to pick up if you want to understand diversification but it provides great insights on how asset managers think about their portfolios.

The book also extensively refers to a number of academic papers that Sebastien Page has written on asset allocation, risk measurement and return forecasting. It explores a number of dynamic asset allocation strategies, acknowledging that risk is time-varying and requires adaptive approaches. Sebastien Page also explains why the typical fixed weight asset allocation (60-40 portfolio) does not deliver a constant risk exposure.

The book recommends using a heuristics to cope with changes in volatility: assume that next month's volatility for each asset class will be the same as last month's. For the longer term the opposite is true, 5 years of calm markets are more likely to be followed by 5 years of turbulence.

The stock-bond mix is the biggest decision that multi-asset investeros make, but this mix does not reliably reduce risk as correlations shift. Stock bond correlations were positive in the 1970s and 1980s when inflation and interest rates drove volality but then the correlation reversed.

PS With volatility being a proxy for risk, you might also check out the white paper "Practical Issues in Forecasting volatility" from Clive Granger and Ser Huang Poon which was published in the Financial Analyst Journal in February 2005.

Dynamics 365 and Power Platform monthly reading list September 2024

2024-09-28T14:46:00.003+02:00

2024 Release Wave 2

Release plans for 2024 release wave 2 are now publicly available - Release plans for Dynamics 365, Power Platform, and Cloud for Industry - Dynamics 365 | Microsoft Learn - from July 29th, early access will be available for activation - other key dates for 2024 release wave 2 are also available . Also check out the videos like Dynamics 365 Service 2024 Release Wave 2 or Dynamics 365 and Power Platform 2024 Release Wave 2 - these might also contain features/functionality which are not listed in the release plans.

2024 Wave 2: Dynamics 365 Customer Service (YouTube) by @d365goddess
2924
Use the Power Platform Environment Settings App
Change history 2024 release wave 1 and change history 2024 release wave 2 - there are frequent changes on features which are part of a release wave - follow up using the change history
2024 release wave 2 for Dynamics 365 Contact Center
Managed identity support for Dataverse plugins

Copilots, AI and machine learning

Technical topics (Configuration, customization and extensibility)

Topics for Dynamics 365 Business Applications Platform consultants, project managers and power users

Three ways AI is transforming service from the field to the contact center (Microsoft white paper)
Capture and communicate value with the business value toolkit (Power Platform CoE toolkit)
Introducing Microsoft Dynamics 365 Contact Center(YouTube)
Eneco Mobility supercharges its customer car with generative AI by introducing Dynamics 365 Contact Center (Case study - Capgemini) - follow Peter Ruiter (@pajruiter) to learn more about copilots and Dynamics 365 Contact Center

Quick tip: Get-AzSubscription and Azure Cloud Shell

2024-09-26T22:32:00.001+02:00

The Get-AzSubscription PowerShell cmdlet gets the subscription ID, subscription name and home tenant for subscriptions that the current account can access. You can also pass this values in as a parameter e.g. "Get-AzSubscription -SubscriptionId" to find the name of a subscription.

The easiest way to execute this cmdlet (without having to install anything on your machine) is by using Azure Cloud Shell. A handy feature of Azure Cloud Shell is predictive intellisense - use the RightArrow key to accept an inline suggestion.

Book tips: Gently easing into Agile and DevOps with the Phoenix project and the Unicorn project

2024-09-26T20:50:00.004+02:00

If you are not familiar with Agile or DevOps, I highly recommend the books below:

The Phoenix Project: a Novel about IT,DevOps and Helping Your Business Win (Gene Kim) is a book which illustrates how Agile principles can be applied to solve complex problems in IT. It is written like a novel, which makes it both educational and entertaining. The main character, Bill Palmer, an IT manager is tasked to rescue a critical business project named Phoenix Project. Thebook is best suited for IT professionals, managers and executives.
The Unicorn Project: A Novel About Developers, Digital Disruption, and Thriving in the Age of Data (Gene Kim) was written 6 years later and takes us back to the same fictional company but this time we get the perspective from the people directly involved in development, testing and operations.

If you have worked in consultancy or software development, you will have surely have a number of "aha moments" which will bring a smile to your face ...

Power Platform Managed Identity support for Dataverse Plugins (preview)

2024-09-19T22:12:00.021+02:00

This is a long overdue feature which allows Dataverse plug-ins to connect to Azure resources (e.g. Azure Key Vault) using managed identities, eliminating the need for credential management and enhancing security. It currently is available in public preview but GA is expected for November 2024

You will need to create a managed identity record in Dataverse and link it ot your specific plugin assembly - for more details take a look at Set up managed identity for Power Platform (Preview) and Power Platform managed identity overview (Preview) for more details.

In your plugin, you will need to the implement the IManagedIdentityService interface which allows your plugins to interact with managed identities. Using this interface, your plugin can request an access token for a specific Azure resource. I asked Copilot to generate the code for this below but did not check it yet ...

In the meanwhile there is also a XrmToolBox plugin available to help with configuring the managed identity - see GitHub - drivardxrm/Driv.XTB.PluginIdentityManager: XrmToolBox Tool to help manage Managed Identity records in Dataverse

References:

Unmasking hidden issues in Dataverse: the surprising role of event expander operations in System job logs - down the rabbit hole we go

2024-08-11T09:25:00.007+02:00

As outlined in Large AsyncOperationBase increase in Dataverse/Dynamics 365 CE: the canary in the coalmine - an increase in the amount of storage consumed by system jobs (visible in the Power Platform Admin Center storage capacity report) is a tell-tale for a Dataverse or Dynamics CRM environment which has some hidden problems.

The AsyncOperationBase table keeps a record of all asynchronous jobs (Async plugins, async workflows, internal Microsoft jobs, etc ...) which are running in the background processing data in your environment. If you have a lot of failed or cancelled jobs, there might be an issue with plugins or workflows. If you see a lot of awaiting resources jobs, there might be a big data load happening on your environment (or maybe an infinite loop).

During a periodic review of the System jobs health status, we noticed that there were a lot more jobs in status "Waiting for resources" then we were used too (More than 200.000). We raised a Microsoft support ticket for this and we got an update on this (redacted version below):

"Microsoft is rolling out a new way of how audit logs are being written in station 4 (EMEA) in a deferred manner. Entities representing these deferred operations are created in the AsyncOperationBase table.

These operations, while rolled up in the AsyncOperationBase table, execute outside of the Async Service and are not meant to be interpreted as additional backlog that the Async Service needs to process. These operations have no negative impact on System Job throughput. When the Audit operation has been fully processed outside of the Async Service, these operations will be removed from the AsyncOperationBase table. Event Expander Operation jobs are used as part of this new audit functionality, these are important jobs to ensure auditing is not lost.

These jobs are however processed by a separate service, so they do not affect async throughput, etc. in any way. Seeing a lot of these jobs (operation type 92 - event expander operation) is not an issue, as these are constantly churning in order to write audit history. If you have custom reporting in place to monitor system jobs - you should exclude AsyncOperationType 92"

Quick tip: Don't bother upgrading very old Raspberry Pi OS version with apt upgrade, just re-install

2024-08-03T15:48:00.001+02:00

A couple of weeks ago, I uncovered an old Raspberry Pi 2 in a drawer and I wanted to try to upgrade the OS to a more recent version. The Raspberry PI still had Debian 8 (Jessie) installed. After a number of failed attempts I just gave up and did a fresh install with Debian 11 (Bullseye)

PS To check the installed Raspberry PI OS version type "cat /etc/os-release" in the command prompt or "hostnamectl"

From boring to soaring: why leaders need to master story telling

2024-08-03T11:59:00.001+02:00

"The most powerful person in the world is the storyteller - Steve Jobs"

I recently read the Harvard Business Review article : your strategy needs a story and the central idea resonated with me: "storytelling is crucial for business leaders because it effectively bridges the gap between strategy and action, making complex strategies engaging, memorable, and motivating for implementation1". Steve Job's quote also aligns with this view on the importance of storytelling in business and marketing

Story telling transforms the complexity of numbers and logic behind a business strategy into simplicity and action. (Narrative and numbers: the values of stories by Aswath Damodaran is a great book on this same topic, but with a different take on it)

93% of a company's employees do not understand its strategy and storytelling can be a solution to make sure that employees understand and implement the strategy and customers understand your value proposition.

PS Although the quote "The most powerful person in the world is the storyteller" is often attributed to Steve Jobs, there's no definitive evidence that he actually said it.