Python Investing Case StudyPython + Time Series + Interactive Charts

Is drip-feeding into index funds actually better than investing a lump sum upfront?

I personally invest in index funds and wanted to test a practical question with real market data. This project compares pound cost averaging and lump sum investing across four London-listed index ETFs using an equal-capital design from 2014 to 2024.

Headline Finding

Lump sum won in every ETF test

When the same total capital was used, investing earlier beat drip-feeding monthly across all four funds. The advantage was strongest in the US and global ETFs, which had the clearest long-run upward trend over the period.

ETF Comparisons

4

Global, US, UK, and emerging-market index ETFs listed in London.

Equal Capital Tested

GBP 60,000

Both strategies used the same total capital over the full 10-year period.

Overall Winner

Lump Sum

It finished ahead in all four ETF comparisons from 2014 to 2024.

What The Analysis Shows

A business-facing story built from equal-capital ETF simulations.

Personal motivation

I personally invest in index funds and wanted to test whether drip-feeding monthly was genuinely better than investing a lump sum upfront.

Main result

Across all four ETFs, investing the full amount earlier beat spreading the same capital across 120 monthly contributions.

Nuance that matters

The advantage was huge in US and global equities, but much smaller in the UK fund, showing that market path matters.

Portfolio Value Over Time

Equal-capital comparison through time.

Interactive

Final Return Comparison

Lump sum led in every ETF, but by very different margins.

Higher is better

Value Gap By ETF

How much more the lump-sum strategy was worth by the end of the period.

GBP

Monthly Units Bought Under PCA

Visualise the pound cost averaging mechanism.

Selected ETF

Methodology

How the comparison was structured.

Step 1

Downloaded daily ETF prices with Python and yfinance for January 2014 to January 2024.

Step 2

Resampled prices into monthly start observations so each strategy used the same monthly investing date.

Step 3

Simulated an equal-capital comparison: GBP 60,000 upfront versus GBP 500 per month for 120 months.

Step 4

Measured final value, total return, monthly volatility, and the value gap between strategies.

Results Summary

Equal-capital comparison after 10 years.

ETFMarketLump SumPCAGapWinner
VUSA.LUnited StatesGBP 193,722
222.87% return
GBP 109,358
82.26% return
GBP 84,365Lump Sum
VWRL.LGlobalGBP 132,617
121.03% return
GBP 88,758
47.93% return
GBP 43,859Lump Sum
VFEM.LEmerging MarketsGBP 78,929
31.55% return
GBP 62,741
4.57% return
GBP 16,188Lump Sum
ISF.LUnited KingdomGBP 66,331
10.55% return
GBP 64,404
7.34% return
GBP 1,927Lump Sum

Key Takeaways

The main interpretation points without the interview framing.

Lump sum outperformed because this was mostly a rising-market period, so earlier market exposure mattered more.

The strongest advantage appeared in VUSA and VWRL, where long-run equity growth was strongest.

The much smaller gap in ISF shows that the case for lump sum is weaker when market growth is slower.

Pound cost averaging still has behavioural value for investors who prefer gradual entry or do not have a large upfront sum.