Consuming yfinance data in Excel - Part II
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Posts by Year
2025
Building a Flask service to get yfinance data - Part I
Have you ever wanted access to yfinance data in an Excel spreadsheet? If so, this two-part blog may be of interest. It describes an approach using a Flask AP...
Calling Python from C# using Python.NET
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 an...
2024
Calling C++ functions from R using Rcpp
If you are an R/RStudio user and you are learning C/C++ then this blog post may be interesting. Suppose that you’ve written a function in C/C++ (or even a wh...
Python in Excel via Reticulate
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 ...
Office365 AddIns for R (Part III)
A while back, I introduced the ExcelRAddIn (Office365 AddIns for R (Part I)). This is an Office365 AddIn that allows you to evaluate an R-script from within ...
2023
Adventures in Excel: Filtering and grouping data
This started off as a simple experiment and mushroomed. I have a card account, and I wanted to know how much I owed for the previous month. Simple enough. An...
Consume a C++/WinRT component in a C# desktop application
I have a function called ‘GetDescriptiveStatistics’ that takes some data and returns summary statistics. The function is written in C++, and I want to call i...
Office365 AddIns for R (Part II)
In the previous post Office365 AddIns for R (Part I), I introduced the ExcelRAddIn. In this post I would like to describe the RScriptAddIn for Word.
Office365 AddIns for R (Part I)
I’d like to introduce a couple of Office365 add-ins for R that I have been working on recently. I read R-bloggers regularly and I thought these add-ins might...