SWRD DCA Tracker

⠿ Overview

Current Price (USD)

1Y High

—

From 52W High

—

Next Dip Tier

—

USD/SGD Rate

—

SGD to Invest

—

Total in USD

—

via Google Finance (15min delayed)

⠿ Order

Units to Buy

—

Set base amount to calculate

Entry Price (USD)

—

Current market price

⠿ Buy Calculator

DCA Amount —

SGD/USD Rate —

DCA in USD —

Residual Cash —

Total to Deploy —

SWRD Units to Buy —

New Residual —

⠿ Connect Sheet

Step 1 — Create a Google Sheet with these formulas in column B:
B1 → =GOOGLEFINANCE("LON:SWRD","price")
B2 → =MAX(GOOGLEFINANCE("LON:SWRD","high",TODAY()-365,TODAY()))
B3 → =MIN(GOOGLEFINANCE("LON:SWRD","low",TODAY()-365,TODAY()))
B4 → Residual cash (USD)
B5 → USD/SGD exchange rate

Step 2 — Share → Anyone with the link can view

Step 3 — Copy the Sheet ID from the URL:
docs.google.com/spreadsheets/d/SHEET_ID/edit

Paste your Sheet ID

⠿ DCA Rules

Base Monthly (SGD)

Extra per 5% dip

Dip from 52W High	Multiplier	Buy Amount
Enter base amount above