Kevin Patrick Lim

I write on time series, forecasting, and data-driven finance at yellowplannet.com. With a Master’s in Information Systems, CFA Level II, and TensorFlow certification, I connect markets, data, and machine learning. Contact: info@yellowplannet.com.

Datasets

Philippine Cooking Oil Price Trends

Methodology To track the real-time cooking oil price in the Philippines, a fully automated monitoring system extracts retail prices daily from leading online grocery platforms such as SM Supermarket and Waltermart. This provides timely insights into the cost of one of the most essential household staples for Filipino families. The

Datasets

Philippine 3-in-1 Instant Coffee Price Trends

Methodology To monitor the real-time retail prices of 3-in-1 instant coffee in the Philippines, a data pipeline was implemented to extract daily price information from major online grocery retailers such as SM Supermarket and Waltermart. The monitoring focuses on popular 3-in-1 instant coffee mixes frequently purchased by Filipino households, including

Data Analysis

Decoding EUR/USD: The U.S. Economic Events That Matter Most

Few currency pairs react as sharply to U.S. economic news as EUR/USD — the global barometer of dollar strength and investor sentiment. Every week, forex traders around the world track high-impact events on calendars like Forex Factory, watching for red labels that warn of potential volatility: Nonfarm Payrolls, CPI,

Datasets

Philippine Instant Noodles Price Trends

Methodology To monitor the real-time retail prices of instant noodles in the Philippines, a data pipeline was implemented to extract daily price information from major online grocery retailers such as SM Supermarket and Waltermart. The focus of this monitoring system is on instant noodle products commonly found in Filipino households,

Business Analysis

Carnival Q3 2025 Results: Earnings Results: Key Highlights and SWOT Analysis of Promises vs. Delivery

Carnival delivered the strongest quarter in its history, driven by robust demand, record yields, disciplined cost management, and balance sheet improvements. With upgraded full-year guidance and strong forward bookings for 2026 and 2027, the company is well-positioned to further expand profitability, strengthen its financial profile, and capture market share in

Data Analysis

How Fractional Differencing Changes the Look of EUR/USD Prices

What happens when prices are transformed, yet still keep their essence? This post takes a visual dive into how fractional differencing reshapes the EUR/USD series while preserving critical information. A fractional differencing parameter of 0.2 is applied, which is the level that makes the EUR/USD series stationary.

Business Analysis

Costco Q4 2025 Earnings Results: Key Highlights and SWOT Analysis of Promises vs. Delivery

Costco’s Q4 and FY2025 results, released September 25, 2025, showcased resilient growth in sales, profits, and memberships. Quarterly net sales climbed to $84.4B (+8% YoY), driving full-year revenues to $269.9B and net income to $8.1B. Memberships hit a record 81M paid cards, with renewal rates holding

Datasets

Philippine Fresh Milk & Plant-Based Alternatives Price Trends

Methodology To track real-time retail prices of liquid milk and milk alternatives in the Philippines, a data pipeline ingests daily listings from major online grocery retailers (e.g., SM Supermarket, Waltermart). Because stock-keeping units (SKUs) appear in a wide variety of pack sizes (e.g. 180 ml single packs, 250

Budgies

Converting Budgie to Pellets: Step-by-Step Guide for a Healthier Diet

Switching a budgie from seeds to pellets can feel overwhelming, but it’s one of the most important steps you can take for your bird’s long-term health. Not all pellets are created equally—some brands are loaded with sugar and artificial ingredients that can actually harm your bird more

Data Analysis

Treasury Yields and the Fed: What Lower Rates Mean for Stocks and Industries

When the Federal Reserve tweaks interest rates, the ripple isn’t just in the bond market — entire industries feel the shift. Some sectors tend to thrive when borrowing gets cheaper, while others lag behind. Think of lower rates as fuel: tech companies may sprint ahead, finance might catch a tailwind,

Data Analysis

Fractional Differencing for Technical Analysis: Reducing Noise in MACD, ATR, and RSI Signals

TL;DR  This analysis explores whether fractional differencing can make common trading indicators more predictive. 👉 The purpose is not to prove or disprove the usefulness of MACD, RSI, ROC, Bollinger Bands, or Z-Score, but to test whether these signals can be made more predictive by make it less noisy and

How Markets Really Move Together: Smarter Insights with Fractional Differencing & Variation of Information

Markets Move Together — But Not in Straight Lines In finance, we often hear that two markets are “highly correlated.” But what does that really mean? Most people rely on correlation, which assumes that relationships between assets are linear and stationary. That’s a problem—because markets are almost never either.

Data Analysis

From Commodities to Currencies: Making Price Data Stationary with Fractional Differencing

Financial prices tend to wander—they drift, trend, and shift in unpredictability. Statisticians call this non-stationarity—when a series doesn’t hold a stable mean and variance. A common remedy is full differencing (subtracting today’s price from yesterday’s), but that uses a whole “1” simply because it’s

Datasets

Philippine Egg Price Trends

Methodology To track real-time retail prices of medium eggs in the Philippines, a data pipeline ingests daily listings from major online grocery retailers (e.g., SM Supermarket and Waltermart). Because stock-keeping units (SKUs) often bundle eggs in different counts (e.g., 6s, 10s, 12s, 30s), all prices are normalized to

Data Analysis

Forecasting EUR/USD with Interest Rate Gaps: What the Germany–US Spread Tells Us

TL;DR — Can Interest Rate Gaps Help Predict EUR/USD? This study investigates whether German–U.S. interest rate differentials and related macro features can forecast EUR/USD moves using trend scanning, a supervised labeling method from Marcos López de Prado. The dataset includes simulations across multiple forecast windows and

Datasets

Philippine Rice Price Trends

Methodology To track the real-time retail prices of rice in the Philippines, a data pipeline was implemented that extracts daily price information from major online grocery retailers such as SM Supermarket and Waltermart. The primary focus of this monitoring system is on two of the most widely consumed rice varieties

Budgies

Budgie Testicular Tumor

I wanted to share my experience with my budgie, Baden-Baden, and his testicular tumor because I found it incredibly difficult at the time to find clear, relevant information. Most of what I came across came from Facebook or Reddit posts—helpful, but often lacking specific details about what to expect.

Can COT Data Predict the EUR/USD? A Data-Driven FAQ on Positioning, Reversals, and Trading Models

The Commitments of Traders (COT) report, published every Friday by the U.S. Commodity Futures Trading Commission (CFTC), provides a breakdown of open interest in futures markets by trader type — including dealers, asset managers, leveraged money, and other reportables. For the EUR/USD currency pair, this report offers a valuable

Data Techniques

Clustering Large Datasets

Clustering large datasets is often computationally expensive because many algorithms require computing pairwise distances or similarities between samples—a process that grows quadratically with the number of data points. This poses a significant challenge in high-dimensional datasets such as those in finance, where instruments and time series are numerous. One

Data Analysis

Average Cash Flow to Debt Ratio by Industry

Table Summary Industry 2019 2020 2021 2022 2023 Energy/Transport 0.29 0.12 0.37 0.60 0.55 Finance 0.38 0.22 0.61 0.75 0.46 Industrial 0.45 0.63 0.75 0.56 0.62 LifeSci 0.79 0.93 1.58 1.

Budgies

Budgie Sounds and Meanings: Analyzing Call Type Similarities Through Phoneme Patterns

Budgies are some of the most vocal and socially complex birds. Through various sounds and calls, they express emotions ranging from excitement and affection to stress and urgency. In this analysis, I explore the idea that not only are these calls behaviorally distinct, but their underlying phoneme structures—the basic

Data Techniques

Backtesting Financial Time Series Forecasting

Time series forecasting plays a critical role in decision-making across industries. However, creating a predictive model is not enough — assessing whether the model generalizes to future data is essential. This is where model assessment and backtesting come in. A poorly executed backtest can lead to inflated expectations, poor real-world performance,

Budgies

Budgie Sounds and Meanings: A Phonemic and Behavioral Analysis

What if we could decode the language of budgies—not just by observing their body language, but by analyzing the structure of their chirps, calls, and chatter? Inspired by a groundbreaking study published in Nature, which found that budgerigars have brain regions specialized for vocalization that mirror those used for

Data Analysis

Inflation Adjusted Capital Expenditures US companies

Over the past decade, capital expenditures (CapEx) across major U.S. industries have revealed critical shifts in corporate strategy, economic resilience, and policy-driven priorities. By examining CapEx relative to operating cash flows (investment rate), we gain insight into how different sectors deploy their financial resources. This blog explores major CapEx

Data Analysis

U.S. Public Company Tax Payments and Cash Flow Insights by Industry

Companies generate trillions annually in operating cash flow, but how much of that actually translates into federal income tax paid? Using cash-based metrics and EDGAR filings, I’ve aggregated calendar-year estimates of both cash flow and taxes paid by industry. Here’s what the data reveals. This visualization presents a