Harry Gunadi Permana
Templates by Harry Gunadi Permana
Track and analyze Forex news trading results with MyFxBook and Google Sheets
Forex News Trading Result Data This n8n template simulates the results if we take every trade based on the previous workflow: https://n8n.io/workflows/8340-automated-forex-news-alert-system-with-forex-factory-and-telegram/ Use Cases 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. Currency Pairs EURUSD, GBPUSD, AUDUSD, NZDUSD, USDJPY, USDCHF, USDCAD, XAUUSD Limitations 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. How It Works 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. How to Use Enter all required credentials. Create or download a Google Sheets file (example): https://docs.google.com/spreadsheets/d/1OhrbUQEclGegk5pRWWKz5nrnMbTZGT0lxK9aJqqId4/edit?usp=drivelink Run the workflow. Requirements Enable the Google Drive API in Google Cloud Console. Provide Google Sheets credentials. Need Help? Join the Discord or ask in the Forum! Thank you!
By Harry Gunadi PermanaSelective forex factory calendar import & cleanup for Google Calendar
Import Forex Factory Calendar To Google Calendar Purpose of this n8n Template Import Forex Factory Calendar events into Google Calendar. Delete past Forex Factory Calendar events from Google Calendar. Use Cases: Get reminders for important economic data releases — especially High Impact news. Use as a trigger for opening trading positions. How It Works (Adding Next Week’s Events to Google Calendar) Every Sunday, the workflow fetches the next week’s events (.ics file) using the HTTP node. The file is parsed with the Extract From File node. Events are split using the Split Out node so each event is processed separately. Events are classified into three categories — High, Medium, and Low Impact — using the Switch node. High Impact news is added to Google Calendar with a popup reminder set 30 minutes before release. Medium Impact news is added to Google Calendar without a reminder. Low Impact news is ignored. How It Works (Deleting Past Events from Google Calendar) The workflow retrieves events from the past 10 days using the Google Calendar node. If an event is related to Forex Factory, it will be deleted. If it is not related, it will be left untouched. How to Use Enter your credentials for all Google Calendar nodes. Requirements A valid Google Calendar credential. Need Help? Join the Discord or ask in the Forum! Thank you!
By Harry Gunadi Permana