Track and Analyze Forex News Trading Results with MyFxBook and Google Sheets

Created by

Harry Gunadi Permana

Last update

Last update 2 days ago

Analyze which news events have a higher probability of generating profit.
Decide on Take Profit and Stop Loss levels for specific currency pairs or news events.

EURUSD, GBPUSD, AUDUSD, NZDUSD, USDJPY, USDCHF, USDCAD, XAUUSD

We use High, Low, and Live Prices from MyFxBook. These values may differ depending on the broker.
Spread widening and slippage will vary across brokers.
Price gaps may occur over weekends.
Profit/Loss also depends on when the trade is closed.

Each day, the workflow checks if the Sheets have empty High and Low Price values.
It queries MyFxBook for updated High and Low Prices for Date+1 (the next trading day after opening a buy/sell position) using the HTTP Request node.
The response from the HTTP Request is parsed.
If new High and Low data are available, the workflow retrieves the date.
It scrapes the new High and Low Price data and calculates the multiplier for the respective currency pair.
Example: USDJPY prices have 3 decimals, so the multiplier is 1000.
Sheets are updated with High, Low, Points Up, and Points Down.
The workflow checks if the buy/sell position results in profit or loss.
Example: if we have a EURUSD Buy position and Points Up > 0, then there is a possibility of profit.
Points Up can be negative if the new High Price remains below the Buy position entry price.
If we have a Buy position and Points Up ≤ 0, then there is a possibility of a loss.

Join the Discord or ask in the Forum!

Thank you!

Forex News Trading Result Data