I’ve been trading OANDA for about a month and I’m trying to build a system to understand my actual net profit per trade. Right now, I’m manually checking each trade in my broker statement, seeing what the spread was, what commission I paid (if any), and then I’m trying to match that up with my GlobeGain rebate somehow.
It’s a mess. By the time I figure out my actual cost on a trade, I’ve already moved on to the next one.
I know some traders have spreadsheets or use third-party tools to consolidate all this data. But I’m not sure what the simplest approach is. Do you just use Excel? Are there OANDA-specific tools? Can you pull data directly from OANDA into GlobeGain?
I want something where I can see: entry price, exit price, spread at entry, spread at exit, commission, rebate amount, and then net profit. All in one row.
Has anyone built a system that actually works for this? What do you use?
Excel spreadsheet. Pull OANDA data manually. Update weekly.
Google Sheets works fine. Track spread lot commission rebate profit.
Most traders don’t do this. Just check monthly profit statement.
The challenge is that rebates don’t flow instantly. OANDA shows the trade cost immediately, but GlobeGain rebates are calculated and paid monthly or quarterly depending on your tier.
Best approach: use Excel to track daily costs from OANDA’s statement. Then separately log your GlobeGain rebate when it posts. At month-end, subtract rebates from total costs.
For a per-trade view, calculate rebate as a percentage and apply it retroactively. If your rebate rate is 25%, multiply each trade’s cost by 0.75 to see net cost.
If you’re serious about this, use OANDA’s API to export trade data directly into a custom sheet. But that requires some technical setup. For most traders, a simple monthly reconciliation works better than per-trade tracking.
Here’s what I do: pull my OANDA statement once a month, total all costs (spread + commission), then check GlobeGain for rebates paid that month. Subtract rebate from total cost. That’s your real monthly cost.
Do that for 3 months and you’ll have a realistic per-trade average cost.
I use Google Sheets and it’s pretty simple. I have columns for date, instrument, entry, exit, pips profit, spread charged, commission, rebate percentage, and then a formula that calculates net profit.
I fill in most of it from OANDA, and I just update the rebate percentage once a month when GlobeGain posts my cashback. Takes maybe 10 minutes a day and I can see the full picture.
I just check my profit at month end. Don’t track every cost in between.
Excel is fine. Most traders use something simple like that.
If you want per-trade visibility, use a spreadsheet but understand the limitation: GlobeGain rebates don’t show up trade-by-trade. They’re calculated as a pool monthly.
So what I do is import trades from OANDA, calculate the net cost assuming the rebate percentage I’ll likely earn, then at month-end I compare actual rebate to my projection. If I’m within 5-10%, my estimate is accurate enough.
This way, you get per-trade visibility without waiting for the full monthly rebate to post. More useful for decision-making.