Published in Python in Plain English·Jun 27, 2022Install Python on a Locked-Down PC Without Local AdminEven if you don’t have local admin or if you are not able to run installers to install software on your PC, you can still use Python. — Many of us work for companies where the PC environment is restricted, limiting what we can do. …Python9 min readPython9 min read
Published in Towards Data Science·Nov 11, 2021Building a Univariate GARCH Model In ExcelVolatility forecasting using GARCH in Excel with Python and PyXLL — In this article we are going to build a Univariate Garch model in Excel. Garch models are used to estimate the volatility of financial assets. This article first appeared on the PyXLL blog here: https://www.pyxll.com/blog/building-a-univariate-garch-model-in-excel/ Building this model in VBA would be an extremely difficult task, even for people who…Garch9 min readGarch9 min read
Published in Towards Data Science·Dec 22, 2020Python Jupyter Notebooks in ExcelEmbed Jupyter into Microsoft Excel and write Python instead of VBA — It used to be an “either/or” choice between Excel and Python Jupyter Notebooks. With the introduction of the PyXLL-Jupyter package now you can use both together, side by side. In this article I’ll show you how to set up Jupyter Notebooks running inside Excel. Share data between the two and…Python9 min readPython9 min read
Published in Towards Data Science·Oct 27, 2020Real Time Crypto Prices in ExcelLearn how to stream live crypto prices into Microsoft Excel — Note from Towards Data Science’s editors: While we allow independent authors to publish articles in accordance with our rules and guidelines, we do not endorse each author’s contribution. You should not rely on an author’s works without seeking professional advice. See our Reader Terms for details. Trading crypto currencies can…Cryptocurrency5 min readCryptocurrency5 min read
Published in Towards Data Science·Jul 15, 2020A Non-Volatile INDIRECT Alternative in Excel using the Pub/Sub PatternDramatically improve spreadsheet performance and decouple your workbooks. — The INDIRECT function in Excel is a tricky beast. One the one hand it can be incredibly useful, but on the other hand, it is responsible for crippling the performance of many spreadsheets. In this article, we’ll look at what the INDIRECT function is, why it is so bad for…Excel9 min readExcel9 min read
Published in Towards Data Science·Mar 24, 2020Member-onlyMitigating End User Computing Risk with ExcelThe risk associated with End User Computing, or EUC, is something that companies more and more are taking seriously. End User Computing is, put simply, any system that allows and end user to perform complex computations outside of the prescribed solutions available to them. A typical example in the finance…Excel9 min readExcel9 min read
Published in Towards Data Science·Dec 2, 2019Member-onlyInteractive Neural Network Fun in ExcelAfter reading Making deep neural networks paint to understand how they work by Paras Chopra I was inspired to delve into some experiments of my own. …Python8 min readPython8 min read
Published in Towards Data Science·Nov 22, 2019Member-onlyA Better Excel Goal Seek using PythonMicrosoft Excel has a great feature, “Goal Seek”, under the Data / What If… menu. Given a formula, it will calculate what the input needs to be in order for that formula to equal a specific result. It’s a very powerful but simple tool. The standard “Goal Seek” feature while…Python4 min readPython4 min read
Oct 24, 2019Integrating Excel and ClojureClojure combines the interactive development convenience of a scripting language with an efficient and robust infrastructure for multithreaded programming. …Clojure7 min readClojure7 min read
Published in Towards Data Science·Jun 12, 2019Replacing VBA with Java in ExcelExcel is ubiquitous in nearly every workplace. From top tier investment firms and large scale engineering companies right down to individual sole traders, people get work done using Excel. This article will look at some of the problems and advantages of using Excel, and how using Java embedded in Excel…Programming8 min readProgramming8 min read
