Python in Excel: How to understand the Matplotlib package

December 24, 2024 | George Mount

Python’s incorporation into Excel offers data analysts robust new tools, particularly in the realm of data visualization. This blog post introduces Matplotlib, a core Python library for crafting visualizations. We’ll begin with the essential components, explore Matplotlib’s customization features, and discuss the benefits of using Pandas DataFrames ...
[...Read more...]

Kelly Can’t Fail

December 19, 2024 | John Mount

Introduction You may have heard of the Kelly bet allocation strategy. It is a system for correctly exploiting information or bias in a gambling situation. It is also known as a maximally aggressive or high variance strategy, in that betting more than the Kelly selection can be quite ruinous. I […] [...Read more...]

Day 30: Summing up

December 12, 2024 | OSM

On Day 29, we conducted our out-of-sample test on the four strategies and found that the adjusted strategy came out on top. We made this conclusion after ranking a cross section of the following metrics: cumulative return, Sharpe Ratio, and max draw...
[...Read more...]

Python in Excel: Why use Python for data visualization?

December 10, 2024 | George Mount

Excel has for decades been a mainstay for business and data professionals, providing a familiar environment for organizing, analyzing, and visualizing data. Its built-in charts and graphs offer a quick, accessible solution for conveying insights. In many cases, these standard visuals are still perfectly adequate: if all you need is ... [...Read more...]
1 13 14 15 16 17 143