In an earlier post, I discussed adding conditional formatting to an Excel chart. One key benefit of using Python in Excel for this—rather than relying on standard Excel charting—is the flexibility it offers. With Python, it’s simpler to adjust the chart when adding new variables or expanding ...

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...

On Day 16, we showed the adjusted 12-by-12 strategy with full performance metrics against buy-and-hold, the 60-40 SPY-IEF ETF portfolio, and the 200-day SMA strategy. In all cases, it tended to perform better than the benchmarks. However, against th...

Companies just need more Python Selenium automation experts as they expand their testing capabilities. A well-laid-out Python Selenium resume opens doors to promising career opportunities in test automation. Job seekers who showcase their expertise in Python programming, Selenium WebDriver, and test automation frameworks excel among competitors in the ever-changing field ...

Data reshaping is a vital task in modern data analysis. Data analysts can handle complex data transformations quickly with dcast and variable labels in data.table R. The data.table package provides powerful tools to restructure datasets. These tools help professionals work with large-scale data manipulation tasks in R. This ...

Gradient boosting with any regression algorithm in Python and R package mlsauce. Part4, Time series forecasting

The digital world of JavaScript frameworks keeps changing. Developers face tough choices between Next.js, Vite, and Angular when building modern web applications. These frameworks come with their own special features that can make or break project success. Teams need to review these options carefully before making decisions about their 2024 ...

Mobile apps just need to use screen space well and keep users involved. Developers often struggle to show more information without making the interface messy. React Native’s expandable icon components offer a great solution. These components help apps present content in a clean way that lets users access extra ...

On Day 15 we adjusted our model to use more recent data to forecast the 12-week look forward return. As before, we used that forecast to generate a trading signal that tells us to go long the SPY if the forecast is positive, and exit (or short for t...

On Day 14 we showed how the trading model we built was snooping and provided one way to correct it. Essentially, we ensure the time in which we actually have the target variable data aligns with when the trading signals are produced. We then used th...