{ "edges": [ { "to": "8bff5c53-a58e-4ef7-9a19-d2498b109d8b", "from": "49cec2c0-592f-4da8-b62b-b2817e99cc30", "toPort": "0", "fromPort": "0" }, { "to": "8501869c-241e-4b71-9be5-61caf10718f3", "from": "5185948d-fb68-4c8f-9049-96ab5511c5d5", "toPort": "0", "fromPort": "0" }, { "to": "5185948d-fb68-4c8f-9049-96ab5511c5d5", "from": "8bff5c53-a58e-4ef7-9a19-d2498b109d8b", "toPort": "0", "fromPort": "0" }, { "to": "d3a4a779-d121-4d7c-b125-fe3d52513378", "from": "8501869c-241e-4b71-9be5-61caf10718f3", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "8501869c-241e-4b71-9be5-61caf10718f3", "name": "Aggregate Crude Prices", "type": "passthrough", "params": { "mode": "aggregate", "options": {}, "aggregate": "aggregateAllItemData" }, "position": [ 1360, 160 ] }, { "id": "49cec2c0-592f-4da8-b62b-b2817e99cc30", "name": "When Market Opens", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "weeks", "triggerAtDay": [ 1, 2, 3, 4, 5 ], "triggerAtHour": 9 }, { "field": "weeks", "triggerAtDay": [ 1, 2, 3, 4, 5 ], "triggerAtHour": 11, "triggerAtMinute": 11 }, { "field": "weeks", "triggerAtDay": [ 1, 2, 3, 4, 5 ], "triggerAtHour": 13, "triggerAtMinute": 30 }, { "field": "weeks", "triggerAtDay": [ 1, 2, 3, 4, 5 ], "triggerAtHour": 16 }, { "field": "weeks", "triggerAtDay": [ 1, 2, 3, 4, 5 ], "triggerAtHour": 19, "triggerAtMinute": 15 } ] } }, "position": [ 608, 160 ] }, { "id": "d3a4a779-d121-4d7c-b125-fe3d52513378", "name": "Send Crude Price Alert", "type": "integration", "params": { "text": "={{ $json.data[0].text }}", "chatId": "ENTER YOUR TELEGRAM CHAT ID", "service": "telegram", "operation": "read", "additionalFields": { "parse_mode": "HTML", "appendAttribution": false } }, "position": [ 1584, 160 ] }, { "id": "8bff5c53-a58e-4ef7-9a19-d2498b109d8b", "name": "Fetch Murban Prices", "type": "http", "params": { "url": "https://oilprice.com/futures/murban/", "options": {} }, "position": [ 880, 160 ] }, { "id": "5185948d-fb68-4c8f-9049-96ab5511c5d5", "name": "Extract Murban Data", "type": "code", "params": { "jsCode": "// ============================================================\n// MURBAN CRUDE OIL — FUTURES TELEGRAM ALERT\n// n8n Code Node | Mode: Run Once for All Items\n// ============================================================\n\n// --- CONTRACT DATA (from OilPrice.com scrape / upstream node) ---\n// Replace this array with $input.all() if fetching live via HTTP Request node\nconst contracts = [\n { name: \"Jul 2026\", symbol: \"DBN26\", last: 92.82, change: -9.39, open: 96.04, high: 96.04, low: 92.82 },\n { name: \"Aug 2026\", symbol: \"DBQ26\", last: 89.50, change: -1.10, open: 90.60, high: 90.60, low: 89.50 },\n { name: \"Dec 2026\", symbol: \"DBZ26\", last: 84.20, change: -0.95, open: 85.15, high: 85.15, low: 84.20 },\n { name: \"Jan 2027\", symbol: \"DBF27\", last: 82.50, change: -0.88, open: 83.38, high: 83.38, low: 82.50 },\n { name: \"Jul 2027\", symbol: \"DBN27\", last: 79.80, change: -0.75, open: 80.55, high: 80.55, low: 79.80 },\n { name: \"Jan 2028\", symbol: \"DBF28\", last: 77.40, change: -0.65, open: 78.05, high: 78.05, low: 77.40 },\n { name: \"Jul 2028\", symbol: \"DBN28\", last: 76.20, change: -0.60, open: 76.80, high: 76.80, low: 76.20 },\n { name: \"Jan 2029\", symbol: \"DBF29\", last: 74.71, change: -1.21, open: 74.71, high: 74.71, low: 74.71 },\n { name: \"Jul 2029\", symbol: \"DBN29\", last: 74.20, change: -0.97, open: 74.20, high: 74.20, low: 74.20 },\n { name: \"Jan 2030\", symbol: \"DBF30\", last: 73.73, change: -0.68, open: 73.73, high: 73.73, low: 73.73 },\n { name: \"May 2030\", symbol: \"DBK30\", last: 73.57, change: -0.48, open: 73.57, high: 73.57, low: 73.57 },\n];\n\n// ---- HELPER FUNCTIONS ----\nfunction arrow(change) {\n return change > 0 ? \"🟢 ▲\" : change < 0 ? \"🔴 ▼\" : \"⚪ —\";\n}\n\nfunction fmt(num) {\n return Number(num).toFixed(2);\n}\n\nfunction sign(num) {\n return num > 0 ? `+${fmt(num)}` : `${fmt(num)}`;\n}\n\nfunction trendEmoji(change) {\n if (change > 1) return \"🚀\";\n if (change > 0) return \"📈\";\n if (change < -3) return \"🆘\";\n if (change < 0) return \"📉\";\n return \"➡️\";\n}\n\n// ---- DATE & TIME ----\nconst now = new Date();\nconst dateStr = now.toLocaleDateString(\"en-IN\", {\n weekday: \"long\", year: \"numeric\", month: \"long\", day: \"numeric\",\n timeZone: \"Asia/Dubai\"\n});\nconst timeStr = now.toLocaleTimeString(\"en-IN\", {\n hour: \"2-digit\", minute: \"2-digit\", timeZone: \"Asia/Dubai\", timeZoneName: \"short\"\n});\n\n// ---- FRONT MONTH (first contract = spot/near) ----\nconst front = contracts[0];\nconst frontDir = front.change >= 0 ? \"UP\" : \"DOWN\";\nconst mktSentiment = front.change > 1 ? \"BULLISH 🐂\" \n : front.change > 0 ? \"MILDLY BULLISH 📊\"\n : front.change < -3 ? \"BEARISH 🐻\"\n : front.change < 0 ? \"MILDLY BEARISH 📊\"\n : \"NEUTRAL ➡️\";\n\n// ---- BUILD CONTRACT TABLE ROWS (near-term 6 contracts) ----\nconst nearTerm = contracts.slice(0, 6);\nconst contractRows = nearTerm.map(c => {\n const dir = arrow(c.change);\n return ` ${c.name.padEnd(9)} $${fmt(c.last)} ${dir} ${sign(c.change)}`;\n}).join(\"\\n\");\n\n// ---- CURVE SUMMARY (full forward curve) ----\nconst curveRows = contracts.map(c => {\n const bar = c.change >= 0 ? \"▲\" : \"▼\";\n return `${c.symbol} | ${c.name} | $${fmt(c.last)} ${bar}`;\n}).join(\"\\n\");\n\n// ---- SPREAD: Front vs Back ----\nconst spread = contracts[0].last - contracts[contracts.length - 1].last;\nconst curveShape = spread > 2 ? \"🔴 Backwardation (spot premium)\" \n : spread < -2 ? \"🟢 Contango (deferred premium)\"\n : \"⚪ Flat Curve\";\n\n// ---- ASSEMBLE TELEGRAM MESSAGE ----\nconst message = `\n🛢️ MURBAN CRUDE OIL — FUTURES REPORT\nICE Futures Abu Dhabi (IFAD) | FOB Fujairah\n━━━━━━━━━━━━━━━━━━━━\n📅 ${dateStr}\n🕐 ${timeStr}\n\n━━━━━━━━━━━━━━━━━━━━\n🔆 FRONT MONTH: ${front.name}\n💵 Price: $${fmt(front.last)} / bbl\n${trendEmoji(front.change)} Change: ${sign(front.change)} (${sign((front.change/front.open*100).toFixed(2))}%)\n📂 Open: $${fmt(front.open)} 📊 Range: $${fmt(front.low)} – $${fmt(front.high)}\n🌡️ Market Sentiment: ${mktSentiment}\n\n━━━━━━━━━━━━━━━━━━━━\n📋 NEAR-TERM FUTURES (6 Contracts)\n\n${contractRows}\n\n━━━━━━━━━━━━━━━━━━━━\n📐 FORWARD CURVE SHAPE\n${curveShape}\n↔️ Spread (Front vs Dec'30): ${sign(spread.toFixed(2))} $/bbl\n\n━━━━━━━━━━━━━━━━━━━━\n📊 FULL FORWARD CURVE\n\n${curveRows}\n\n━━━━━━━━━━━━━━━━━━━━\nℹ️ Murban: UAE Light Crude | API ~39.9° | Sulfur ~0.79%\n🏭 Produced by ADNOC | Delivered FOB Fujairah, UAE\n🔗 Source: OilPrice.com / ICE IFAD\n━━━━━━━━━━━━━━━━━━━━\n`.trim();\n\n// ---- OUTPUT FOR TELEGRAM NODE ----\nreturn [{\n json: {\n chat_id: \"YOUR_CHAT_ID\", // 🔁 Replace with your Telegram chat/channel ID\n text: message,\n parse_mode: \"HTML\",\n disable_web_page_preview: true,\n }\n}];" }, "position": [ 1152, 160 ] } ] }

Send Murban crude futures price alerts with HTTP request and Telegram