{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ژورنال معاملات","داشبورد","لیست‌ها","راهنما"],"not_rendered":{"charts":2,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ژورنال معاملات","index":0,"n_rows":104,"n_cols":22,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,21],[1,0,1,21]]}
["ژورنال معاملاتی اسکالپ و معاملات کوتاه‌مدت"]
["بعد از هر معامله، داده‌ها را ثبت کنید تا نرخ برد، سود/ضرر، میانگین R و اشتباهات تکراری شما مشخص شود. ستون‌های زرد را پر کنید؛ ستون‌های آبی فرمولی هستند."]
[]
["ردیف","تاریخ","بازار","نماد","تایم‌فریم","نوع معامله","استراتژی","قیمت ورود","حد ضرر","حد سود","قیمت خروج","حجم/لات","ریسک مبلغی","سود/ضرر خالص","R:R هدف","R واقعی","نتیجه","دلیل ورود","احساسات","اشتباه/درس","لینک اسکرین‌شات","وضعیت"]
[{"$f":"ROW()-4","v":1},"2026-06-18","Forex","EURUSD","M5","خرید","Breakout",1.084,1.0825,1.087,1.0865,0.1,20.0,32.0,{"$f":"IFERROR(ABS(J5-H5)/ABS(H5-I5),\"\")","v":2},{"$f":"IFERROR(N5/M5,\"\")","v":1.6},{"$f":"IF(N5=\"\",\"\",IF(N5>0,\"برد\",IF(N5<0,\"باخت\",\"سربه‌سر\")))","v":"برد"},"شکست مقاومت و پولبک","آرام","خروج کمی زود انجام شد",null,"ثبت شد"]
[2,"2026-06-18","Gold","XAUUSD","M1","فروش","Reversal",2335.0,2340.0,2325.0,2339.0,0.01,15.0,-13.0,2,-0.8666666667,"باخت","واگرایی + شکست خط روند","عجول","ورود بدون تأیید کندل",null,"نیاز به بررسی"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[61,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[62,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[64,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[65,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[66,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[68,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[69,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[70,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[71,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[72,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[73,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[74,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[75,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[76,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[77,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[78,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[79,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[80,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[81,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[82,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[83,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[84,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[85,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[86,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[87,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[88,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[89,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[90,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[91,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[92,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[93,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[94,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[95,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[97,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[98,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]

{"sheet":"داشبورد","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["داشبورد عملکرد معاملات"]
[]
["شاخص","مقدار",null,"شاخص","مقدار"]
["کل معاملات",{"$f":"COUNTA('ژورنال معاملات'!B5:B104)","v":2},null,"سود/ضرر خالص",{"$f":"SUM('ژورنال معاملات'!N5:N104)","v":19}]
["تعداد برد",{"$f":"COUNTIF('ژورنال معاملات'!Q5:Q104,\"برد\")","v":1},null,"بهترین معامله",{"$f":"MAX('ژورنال معاملات'!N5:N104)","v":32}]
["تعداد باخت",{"$f":"COUNTIF('ژورنال معاملات'!Q5:Q104,\"باخت\")","v":1},null,"بدترین معامله",{"$f":"MIN('ژورنال معاملات'!N5:N104)","v":-13}]
["نرخ برد",{"$f":"IFERROR(B5/B4,\"\")","v":0.5},null,"میانگین R واقعی",{"$f":"IFERROR(AVERAGEIF('ژورنال معاملات'!P5:P104,\"<>\",'ژورنال معاملات'!P5:P104),\"\")","v":0.3666666667}]
["Profit Factor",{"$f":"IFERROR(SUMIF('ژورنال معاملات'!N5:N104,\">0\",'ژورنال معاملات'!N5:N104)/ABS(SUMIF('ژورنال معاملات'!N5:N104,\"<0\",'ژورنال معاملات'!N5:N104)),\"\")","v":2.461538462},null,"معاملات سربه‌سر",{"$f":"COUNTIF('ژورنال معاملات'!Q5:Q104,\"سربه‌سر\")","v":0}]
[]
[]
["نتیجه","تعداد",null,"تاریخ","سود/ضرر روزانه"]
["برد",{"$f":"COUNTIF('ژورنال معاملات'!Q5:Q104,\"برد\")","v":1},null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),1),\"\"\"\")\"),46191.0)","v":"2026-06-18"},{"$f":"IF(D12=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D12,'ژورنال معاملات'!N5:N104))","v":19}]
["باخت",{"$f":"COUNTIF('ژورنال معاملات'!Q5:Q104,\"باخت\")","v":1},null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),2),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D13=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D13,'ژورنال معاملات'!N5:N104))","v":""}]
["سربه‌سر",{"$f":"COUNTIF('ژورنال معاملات'!Q5:Q104,\"سربه‌سر\")","v":0},null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),3),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D14=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D14,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),4),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D15=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D15,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),5),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D16=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D16,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),6),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D17=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D17,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),7),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D18=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D18,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),8),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D19=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D19,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),9),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D20=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D20,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),10),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D21=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D21,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),11),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D22=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D22,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),12),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D23=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D23,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),13),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D24=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D24,'ژورنال معاملات'!N5:N104))","v":""}]
[null,null,null,{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"IFERROR(SMALL(UNIQUE(FILTER('ژورنال معاملات'!B5:B104,'ژورنال معاملات'!B5:B104<>\"\"\"\")),14),\"\"\"\")\"),\"\")","v":""},{"$f":"IF(D25=\"\",\"\",SUMIF('ژورنال معاملات'!B5:B104,D25,'ژورنال معاملات'!N5:N104))","v":""}]

{"sheet":"لیست‌ها","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["بازار","نوع معامله","تایم‌فریم","احساسات","وضعیت","استراتژی نمونه"]
["Forex","خرید","M1","آرام","ثبت شد","Breakout"]
["Crypto","فروش","M5","عجول","نیاز به بررسی","Pullback"]
["Gold",null,"M15","ترس","بررسی شد","Reversal"]
["Oil",null,"M30","طمع",null,"Range"]
["Indices",null,"H1","انتقام",null,"News"]
["Stocks",null,"H4","مطمئن",null,"Trend"]
[null,null,"D1","بی‌برنامه",null,"Support/Resistance"]

{"sheet":"راهنما","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["راهنمای استفاده از ژورنال معاملاتی"]
[]
["بخش","توضیح"]
["بعد از هر معامله","تاریخ، بازار، نماد، تایم‌فریم، نوع معامله، ورود، حد ضرر، حد سود، خروج، ریسک مبلغی و سود/ضرر خالص را وارد کنید."]
["R:R هدف","به‌صورت خودکار از نسبت فاصله حد سود تا ورود به فاصله ورود تا حد ضرر محاسبه می‌شود."]
["R واقعی","سود/ضرر خالص تقسیم بر ریسک مبلغی است. اگر R واقعی زیر صفر باشد معامله زیان‌ده بوده است."]
["نتیجه","بر اساس سود/ضرر خالص به‌صورت خودکار برد، باخت یا سربه‌سر مشخص می‌شود."]
["اشتباه/درس","حتماً دلیل اشتباه یا نکته مثبت معامله را بنویسید تا الگوهای تکراری خودتان را پیدا کنید."]
["داشبورد","در شیت داشبورد، نرخ برد، Profit Factor، میانگین R، بهترین و بدترین معامله و نمودارها به‌صورت خودکار به‌روزرسانی می‌شوند."]