Two Price Series: Normalising, Log Returns and a Correlation Written Out
This lesson is part of the course
In this lesson
You put 120 daily closes of two fictional freight companies on a common base of 100, turn them into log returns, write the return correlation out with SUMPRODUCT and measure how far the two lines still drift apart.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Two Price Series: Normalising, Log Returns and a Correlation Written Out Locked
- The Hedge Ratio: SLOPE, the Intercept by Hand and the Spread Locked
- Is the Spread Mean-Reverting? A Regression Test Against a Fictional Table Locked
- Z-Score Signals: Rolling Mean and σ, Entry, Exit and Stop Levels Locked
- Half-Life of Mean Reversion: Sizing the Look-Back Window and the Holding Limit Locked
- Positions and P&L: A State Column, Units per Leg and the Daily Result Locked
- Costs and Capital: Trading Costs, Borrow Fees, Trade Count and Maximum Drawdown Locked
- Capstone: In-Sample vs Out-of-Sample, a Drifting Hedge Ratio and a Threshold Grid Locked