N
n8n Store
Workflow Market
Track and Analyze Forex News Trading Results with MyFxBook and Google Sheets

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

by harrygp0 views

Description

Categories

🤖 AI & Machine Learning

Nodes Used

n8n-nodes-base.ifn8n-nodes-base.ifn8n-nodes-base.ifn8n-nodes-base.ifn8n-nodes-base.ifn8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.noOpn8n-nodes-base.noOpn8n-nodes-base.markdown
PriceGratis
Views0
Last Updated11/28/2025
workflow.json
{
  "meta": {
    "instanceId": "84b390fbc5fa25072285b148d9fdc04a69134c7197b10b734c5b01fb008ddd54",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "2e9591c4-052a-46bb-b47d-75c4ae25b0c8",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        800
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "43c206ab-b604-441f-a09e-dc8f96bab5a5",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        800
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "=",
              "lookupColumn": "HIGH"
            },
            {
              "lookupValue": "=",
              "lookupColumn": "LOW"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit?usp=drivesdk",
          "cachedResultName": "ForexFactory News Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": " ",
          "name": " "
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "e2f0eca7-c7e1-4aad-865c-562d84c3724b",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        448,
        800
      ],
      "parameters": {
        "url": "=https://www.myfxbook.com/forex-market/currencies/{{ $json.PAIRS }}-historical-data",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "4b3a67ba-f867-415a-8df8-3b7fb938c6e8",
      "name": "Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        672,
        800
      ],
      "parameters": {
        "html": "={{ $json.data }}",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "2fa9dbfd-fe96-47c1-83a0-8a00bc3818c3",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        768,
        1424
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0131a8ad-8fe3-4f27-8004-bc7c2c850f48",
      "name": "High, Low, Points Up, Points Down",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        96,
        1536
      ],
      "parameters": {
        "columns": {
          "value": {
            "LOW": "={{ $json.LOW }}",
            "HIGH": "={{ $json.HIGH }}",
            "POINTS UP": "={{ ($json.HIGH-$('Get row(s) in sheet').item.json.PRICE)*$('Date, Multiplier').item.json['POINTS MULTIPLIER'] }}",
            "row_number": "={{ $('Get row(s) in sheet').item.json.row_number }}",
            "POINTS DOWN": "={{ ($('Get row(s) in sheet').item.json.PRICE-$json.LOW)*$json['POINTS MULTIPLIER'] }}",
            "PROFIT/LOSS": "="
          },
          "schema": [
            {
              "id": "DATE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PAIRS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PAIRS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NEWS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "NEWS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "IMPACT",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "IMPACT",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POSITION",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "POSITION",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PRICE",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PRICE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "HIGH",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "HIGH",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LOW",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "LOW",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POINTS UP",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "POINTS UP",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POINTS DOWN",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "POINTS DOWN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PROFIT/LOSS",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "PROFIT/LOSS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit?usp=drivesdk",
          "cachedResultName": "ForexFactory News Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": " ",
          "name": " "
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "e6d06720-f224-4289-a4eb-ac46b4072f27",
      "name": "Buy & Points Up > 0 = Profit",
      "type": "n8n-nodes-base.if",
      "position": [
        320,
        1136
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "36945935-4922-40e4-95e3-e5bb901fefe4",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $('Get row(s) in sheet').item.json.POSITION }}",
              "rightValue": "BUY"
            },
            {
              "id": "05aad2f5-6a22-404d-8318-ddb41b119562",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json['POINTS UP'] }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "b4dd2d72-f4cc-440b-ac2a-f6f19ff6abd5",
      "name": "Buy & Points Up <= 0 = Loss",
      "type": "n8n-nodes-base.if",
      "position": [
        320,
        1568
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "36945935-4922-40e4-95e3-e5bb901fefe4",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $('Get row(s) in sheet').item.json.POSITION }}",
              "rightValue": "BUY"
            },
            {
              "id": "05aad2f5-6a22-404d-8318-ddb41b119562",
              "operator": {
                "type": "number",
                "operation": "lte"
              },
              "leftValue": "={{ $json['POINTS UP'] }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0a7f0a85-f2bd-46ec-b812-93c29b238b1f",
      "name": "Sell & Points Down > 0 = Profit",
      "type": "n8n-nodes-base.if",
      "position": [
        320,
        1376
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "36945935-4922-40e4-95e3-e5bb901fefe4",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $('Get row(s) in sheet').item.json.POSITION }}",
              "rightValue": "SELL"
            },
            {
              "id": "05aad2f5-6a22-404d-8318-ddb41b119562",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json['POINTS DOWN'] }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "176a4897-8d25-4442-8860-b8b5c2136a7f",
      "name": "Sell & Points Down <= 0 = Loss",
      "type": "n8n-nodes-base.if",
      "position": [
        320,
        1856
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "36945935-4922-40e4-95e3-e5bb901fefe4",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $('Get row(s) in sheet').item.json.POSITION }}",
              "rightValue": "SELL"
            },
            {
              "id": "05aad2f5-6a22-404d-8318-ddb41b119562",
              "operator": {
                "type": "number",
                "operation": "lte"
              },
              "leftValue": "={{ $json['POINTS DOWN'] }}",
              "rightValue": 0
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "c45972e9-10c9-47c3-b1d9-61fc2d5b2544",
      "name": "Profit",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        544,
        1136
      ],
      "parameters": {
        "columns": {
          "value": {
            "row_number": "={{ $('Get row(s) in sheet').item.json.row_number }}",
            "PROFIT/LOSS": "Profit"
          },
          "schema": [
            {
              "id": "DATE",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PAIRS",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PAIRS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NEWS",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NEWS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "IMPACT",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "IMPACT",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POSITION",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POSITION",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PRICE",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PRICE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "HIGH",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "HIGH",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LOW",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "LOW",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POINTS UP",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POINTS UP",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POINTS DOWN",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POINTS DOWN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PROFIT/LOSS",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PROFIT/LOSS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit?usp=drivesdk",
          "cachedResultName": "ForexFactory News Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": " ",
          "name": " "
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "2ffff77b-c1be-4f4e-8f67-03a081b98907",
      "name": "Loss",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        544,
        1712
      ],
      "parameters": {
        "columns": {
          "value": {
            "row_number": "={{ $('Get row(s) in sheet').item.json.row_number }}",
            "PROFIT/LOSS": "Loss"
          },
          "schema": [
            {
              "id": "DATE",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PAIRS",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PAIRS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NEWS",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NEWS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "IMPACT",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "IMPACT",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POSITION",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POSITION",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PRICE",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PRICE",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "HIGH",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "HIGH",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LOW",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "LOW",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POINTS UP",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POINTS UP",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "POINTS DOWN",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "POINTS DOWN",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "PROFIT/LOSS",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "PROFIT/LOSS",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1f6SS-WVj3p2rZJ6SOawzWsXm5l796vQaNyGFIwABlqQ/edit?usp=drivesdk",
          "cachedResultName": "ForexFactory News Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": " ",
          "name": " "
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "a5b606eb-b4f3-4e45-8aaf-207ad1101910",
      "name": "Date+1 Data Available",
      "type": "n8n-nodes-base.if",
      "position": [
        896,
        800
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d65b2b31-d978-4c56-93d1-727e81bd201d",
              "operator": {
                "type": "string",
                "operation": "notContains"
              },
              "leftValue": "={{ $json.data.substring($json.data.indexOf(\"Change (%) |  | \"),$json.data.indexOf(\"Change (%) |  | \")+100) }}",
              "rightValue": "={{ $('Get row(s) in sheet').item.json.DATE }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "a1f8926c-3128-402e-8df1-7d9275b2ea41",
      "name": "No Operation, do nothing2",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1120,
        896
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e340c1df-1f44-4834-9bd6-55223c6e782e",
      "name": "Date, Multiplier",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        704
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "2a7b73ea-dddc-4625-89e0-ffb628c42bc4",
              "name": "DATE+1",
              "type": "string",
              "value": "={{ $json.data.substring($json.data.indexOf(\"Change (%) |  | \"),$json.data.indexOf(\"Change (%) |  | \")+100).split(\" | \")[2].split(\"00\")[0].trim() }}"
            },
            {
              "id": "2af02ac1-d631-4832-b080-5451c548966b",
              "name": "POINTS MULTIPLIER",
              "type": "number",
              "value": "={{\n$if($('Get row(s) in sheet').item.json.PAIRS == \"USDJPY\", 1000,\n$if($('Get row(s) in sheet').item.json.PAIRS == \"XAUUSD\", 100, 100000\n)) }}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "97a71ba2-60b1-451e-8da6-c321f790e3cc",
      "name": "High Low Price",
      "type": "n8n-nodes-base.set",
      "position": [
        1344,
        896
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "90a3cbb1-54fb-4f42-8c0c-ec19d82024b1",
              "name": "HIGH",
              "type": "number",
              "value": "={{ $json.data.substring($json.data.indexOf($json['DATE+1']),$json.data.indexOf($json['DATE+1'])+100).split(\" | \")[2] }}"
            },
            {
              "id": "9229aa4e-df3a-4d30-b78b-9c148516c1b0",
              "name": "LOW",
              "type": "number",
              "value": "={{ $json.data.substring($json.data.indexOf($json['DATE+1']),$json.data.indexOf($json['DATE+1'])+100).split(\" | \")[3] }}"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "dcca5994-e7dd-4cb8-bf60-477977b9a8e9",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        656
      ],
      "parameters": {
        "width": 460,
        "height": 1360,
        "content": "## Forex News Trading Result Data\n### 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/\n\n### Use Cases\n1. Analyze which news events have a higher probability of generating profit.\n2. Decide on Take Profit and Stop Loss levels for specific currency pairs or news events.\n\n### Currency Pairs\nEURUSD, GBPUSD, AUDUSD, NZDUSD, USDJPY, USDCHF, USDCAD, XAUUSD\n\n### Limitations\n1. We use High, Low, and Live Prices from MyFxBook. These values may differ depending on the broker.\n2. Spread widening and slippage will vary across brokers.\n3. Price gaps may occur over weekends.\n4. Profit/Loss also depends on when the trade is closed.\n\n### How It Works\n* Each day, the workflow checks if the Sheets have empty High and Low Price values.\n* 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.\n* The response from the HTTP Request is parsed.\n* If new High and Low data are available, the workflow retrieves the date.\n* It scrapes the new High and Low Price data and calculates the multiplier for the respective currency pair.\n* Example: USDJPY prices have 3 decimals, so the multiplier is 1000.\n* Sheets are updated with High, Low, Points Up, and Points Down.\n* The workflow checks if the buy/sell position results in profit or loss.\n* Example: if we have a EURUSD Buy position and Points Up > 0, then there is a possibility of profit.\n* Points Up can be negative if the new High Price remains below the Buy position entry price.\n* If we have a Buy position and Points Up ≤ 0, then there is a possibility of a loss.\n\n### How to Use\n* Enter all required credentials.\n* Create or download a Google Sheets file (example): https://docs.google.com/spreadsheets/d/1OhrbUQEc_lGegk5pRWWKz5nrnMbTZGT0lxK9aJqqId4/edit?usp=drive_link\n* Run the workflow.\n\n### Requirements\n* Enable the Google Drive API in Google Cloud Console.\n* Provide Google Sheets credentials.\n\n### Need Help?\nJoin the [Discord](https://discord.gg/n8n) or ask in the [Forum](https://community.n8n.io/)!\n\nThank you!"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Loss": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Profit": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown": {
      "main": [
        [
          {
            "node": "Date+1 Data Available",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "High Low Price": {
      "main": [
        [
          {
            "node": "High, Low, Points Up, Points Down",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Date, Multiplier": {
      "main": [
        [
          {
            "node": "High Low Price",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Date+1 Data Available": {
      "main": [
        [
          {
            "node": "Date, Multiplier",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Buy & Points Up <= 0 = Loss": {
      "main": [
        [
          {
            "node": "Loss",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Buy & Points Up > 0 = Profit": {
      "main": [
        [
          {
            "node": "Profit",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sell & Points Down <= 0 = Loss": {
      "main": [
        [
          {
            "node": "Loss",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sell & Points Down > 0 = Profit": {
      "main": [
        [
          {
            "node": "Profit",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "High, Low, Points Up, Points Down": {
      "main": [
        [
          {
            "node": "Buy & Points Up > 0 = Profit",
            "type": "main",
            "index": 0
          },
          {
            "node": "Buy & Points Up <= 0 = Loss",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sell & Points Down > 0 = Profit",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sell & Points Down <= 0 = Loss",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

相关工作流