Introduction In the last post in this series I am going to look at calling Python from R. Even though Excel now provides a means of calling Python scripts directly, using the =PY() formula in a worksheet, there are still occasions when it is beneficial...

Introduction Recently, I’ve been doing some portfolio analysis and I came across an interesting video: How to Calculate the Intrinsic Value of a Stock like Benjamin Graham. Since not all the data is available in Excel, I thought it might be useful to a...

Introduction The first part of this two-part blog described the YFinanceService. This is a Flask service that wraps calls to the Python yfinance library and which served up some of the data via the APIs (/IntrinsicValue, /TickerData and so on). Part II...

Introduction Recently, I’ve been using Python’s yfinance library to perform some simple portfolio analysis. Rather than using a Jupyter notebook to run the Python code and visualise the results, I thought it might be a nice idea to build a .NET desktop...

Introduction This post describes a particular use-case for Python in Excel and how it was solved using the R package Reticulate 1.39.0 along with the ExcelRAddIn. A while back I read an interesting post on LinkedIn that identified a number of criteria...