How should you account for currency effects when DCA-investing in US stocks and ETFs?
We plan to invest the same 3,000 baht each month, yet receive different share counts. Some months, both the stock price and the baht-dollar exchange rate move.

DCA helps manage behavior, not prevent losses
With equal baht contributions, shares purchased depend on both the dollar share price and that period’s exchange rate. To measure a baht outcome, total the actual baht costs before comparing the ending value. An equally weighted average exchange rate may misstate cost.
DCA involves investing similar amounts over time, such as at the beginning of every month. This reduces the burden of guessing timing and makes investing a habit. When prices are low, the same amount of money can buy more. When the price is high, you can buy less.
DCA does not improve the asset itself. Long-term declines can still cause losses. Gradually investing an existing lump sum during rising markets can differ from immediate investment. Distinguish monthly investing from new salary from a lump sum waiting for entry.
Foreign investment has two levels of price.
When buying dollar-denominated assets with baht, the baht outcome depends on asset prices and exchange rates. At an unchanged share price, a stronger dollar against the baht may increase converted value, while a weaker dollar may reduce it.
A stock chart in dollars does not show the final return in baht. Exchange rates also need to be considered, without having to predict the correct rate every month. Investing abroad may diversify exposure across countries while adding currency volatility.
Two equal baht contributions buy different share counts
Suppose you buy an asset that allows fractional shares at US$100 per share each period, investing 3,500 baht each time at hypothetical rates of 35 and 28 baht per dollar, respectively. Fees, taxes, exchange-rate spreads, dividends, and leftover cash are excluded. These figures illustrate the calculation; they are not current prices or exchange rates.
| period | Amount paid | Baht per dollar exchange rate | Dollars received | Shares purchasable |
|---|---|---|---|---|
| 1 | 3,500 Baht | 35 | 100 USD | 1 share |
| 2 | 3,500 Baht | 28 | 125 USD | 1.25 shares |
| Total | 7,000 Baht | Do not take a simple average | 225 USD | 2.25 shares |
If both lots are sold on the same day at $110 per share and converted back at 30 baht per dollar, you receive 2.25 × 110 × 30 = 7,425 baht The gain over total contributions is 425 baht, or about 6.07% of 7,000 baht, even though the dollar share price rises 10% from both purchase prices. This 6.07% is the example's profit relative to total cost, not an annualized or cash-flow-timing-adjusted return.
Do not multiply US$225 by the arithmetic average of 35 and 28, or 31.50, to represent cost. This produces 7,087.50 baht, different from the actual 7,000 baht paid, because each installment buys a different dollar amount. To find the average rate for these exchanges, use 7,000 ÷ 225 ≈ 31.1111 baht per dollar keeping unrounded values until the calculation finishes
Fixed-dollar contributions are different: the baht required varies with exchange rates. Decide which currency amount stays constant and record actual payments and shares for every transaction.
Use profit and currency mode for each period, then total the baht amounts
Accuracy warning: The calculator may produce incorrect results. No input range has been proven safe. Independently verify results against broker records or another method before relying on them for trading, accounting, or tax filing.
- Open US stock cost and profit calculator then select “Profit and currency.” This mode accepts one purchase price and purchase exchange-rate pair per calculation.
- For the first lot, enter 1 share, purchase price 100, sale price 110, purchase exchange rate 35, and sale exchange rate 30. Set dividends and both fees to 0, then calculate: a 200-baht loss.
- Keep purchase price, sale price, and sale exchange rate unchanged. For the second lot, use 1.25 shares and a purchase rate of 28 baht per dollar; the modeled gain is 625 baht.
- Write down the results of each period before changing the data. Total profits as −200 + 625 = 425 baht and divide by the total 7,000-baht cost to obtain about 6.07%. Do not add or average each period's return percentages without considering invested amounts.
The tool separates stock-price effects, currency effects, and their interaction. In the example, the first lot gives 350 - 500 - 50 = -200 baht and the second 350 + 250 + 25 = 625 baht. Simultaneous price and exchange-rate changes have an interaction effect; describing only two components would omit it.
The Average Cost tab supports multiple transactions in one currency, without individual baht exchange rates. Profit and Currency results are not automatically combined with that tab. For actual records, include fees and residual cash from statements. Do not use this two-lot example as tax cost basis or for portfolios with partial sales and dividends on multiple dates.
Record transactions and know what is stored in the CSV.
To track remaining shares and average cost, choose the Average Cost tab and add transactions chronologically. Select buy or sell and enter share count, unit price, and fees in the same currency throughout. This mode does not accept a separate baht exchange rate for each transaction or automatically combine results from the Profit and Currency tab.
Hypothetical example without fees: buy 1 share at $100 and 1 at $120, then sell 0.5 at $130. Average cost before sale is $110. Afterward, 1.5 shares remain at $165 cost, with $10 realized profit under the tool's average-cost method, not certified tax cost-basis treatment.
- Review the items on the page and press “Download CSV” in the Average Cost tab to archive.
stock-transactions.csv - Use the header
type,shares,price,feewheretypemust bebuyorsellas in the downloaded file; do not substitute Thai words. - Before importing CSV, back up current entries. A successful import replaces the whole list rather than appending. Sales must follow purchases and not exceed available shares.
- After importing, compare share counts, average cost, and realized gains with the pre-export records. Select the original currency because CSV does not retain currency information.
The CSV shares, price, and fee fields require decimal numbers and cannot be blank. Scientific notation such as 1e-6 is accepted. Values that convert to infinity or zero despite a nonzero input are rejected. A failed import leaves existing entries in place, but this check does not guarantee accurate calculations for accepted values. Compare results against your broker records before using them.
type,shares,price,fee
buy,1,100,0
buy,1,120,0
sell,0.5,130,0
This file stores only four cost-entry fields, excluding dates, tickers, exchange rates, and the profit/currency form. Keep separate file sets for different securities rather than averaging entries across stocks, and always retain actual trade confirmations.
Understand the limits of browser remembering
“Remember data on this device” saves entries, input values, and the selected tab in the same browser profile. Confirm the saved status before closing. On return, check inputs and recalculate in “Profit and currency.” Restored inputs do not fetch current market prices or rates.
Disable retention or confirm “Delete saved data” to remove the browser copy while preserving the current page. Each tab's “Clear data” resets that tab; the reset is saved if retention remains enabled. Data does not sync across devices, and CSV does not back up every field. Record exchange-rate and date assumptions separately. Others sharing the browser may see retained data.
Small costs matter when buying every month.
Consider commissions, minimum fees, bid-ask spreads, and exchange costs together. For small monthly purchases, a minimum charge can represent a large percentage of each investment.
Do not look only at “commission-free trading”: providers may charge elsewhere. Compare total baht paid with actual asset value received, and read withdrawal and securities-transfer terms too.
Plan a DCA approach you can sustain
- Set aside emergency funds and money that will be used quickly first.
- Set the amount of investment so that it does not cause interruption in necessary expenses.
- Choose a repeatable day or interval without changing it for weekly news
- Set a target percentage of US stocks or ETFs relative to the entire portfolio.
- Review once a year or when income, goals, and risks accepted have changed
With several funds, check overlapping holdings. Disciplined monthly buying does not diversify risk if all money reaches the same companies.
Use calculators with an understanding of their limitations
DCA calculator Try different initial amounts, monthly contributions, durations, and assumed returns. Results use constant returns and exclude volatility, currency effects, fees, and taxes.
Compare cautious, middle, and favorable scenarios. If results fall short, consider whether contributions can increase, the goal can be reduced, or the time horizon extended.
Before using simulations to plan, record at least one complete investment cycle with date, actual baht paid, net dollars, purchase price, share count, and other costs. Investor.gov outlines the currency risks and costs of foreign investing. Meanwhile, FINRA explains the tradeoffs of gradual investing. If average-cost calculations and currency effects are still unclear, read DCA Basics and Mechanism of strong and weak baht first; do not guess exchange rates just to make the table look good
Accuracy warning: The calculator may produce incorrect results. No input range has been proven safe. Independently verify results against broker records or another method before relying on them for trading, accounting, or tax filing.
Let's calculateSeparate stock and currency effectsFind out how much of your profit or loss came from the stock price, currency, and fees.Sources
- FINRA: Dollar-Cost Averaging
- Investor.gov: International Investing
- KrobClick: Stock cost, currency effects, and trade records
General education, not personalized financial or investment advice. Actual returns may differ and principal may be lost. Tool instructions were added after checking code revision 06c6444 on October 21, 2026 and testing hypothetical browser data, without real accounts or transactions.