المتاجرة نظام جدول

أنظمة جداول البيانات والتنبيهات والتداول الآلي في هذه الصفحة في الإصدارات الأخيرة من مخطط سييرا قمنا بإعادة تسمية المصنف وورقة العمل إلى جدول البيانات. تمت إعادة تسمية الدراسات 3 ورقة العمل الآن وتبدأ باسم جدول البيانات. تمت إعادة تسمية دراسة ورقة العمل إلى دراسة جدول البيانات. تستخدم هذه الوثيقة مصطلح جدول البيانات. في إصدار مخطط سييرا الذي تقوم بتشغيله، يمكنك الرجوع إلى أسماء الدراسة بدءا من ورقة العمل اسم القديم. معلومات عامة يمكن استخدام نظام جداول البيانات دراسة أليرت ونظام جدول البيانات لدراسة التداول لإنشاء نظام التداول أو تنبيه للرسم البياني الخاص بك. نظام التداول أو التنبيه يعني القواعد التي تحددها والتي ستوفر إشارات شراء أو بيع عندما تكون القواعد صحيحة لشريط معين في المخطط. سيتم عرض هذه الإشارات كمؤشرات رسومية على الرسم البياني، وعرض خطوط التنبيه النص وإعطاء التنبيهات مسموعة. في حالة دراسة نظام جداول البيانات للتجارة، سيتم أيضا إعطاء أوامر التجارة الفعلية. يشير تنبيه إلى إشارة معينة عندما تكون قواعد سيستيماليرت الخاص بك صحيحا على الشريط الأخير. ويرد وصف كل ذلك بمزيد من التفصيل أدناه. إذا كنت مهتما فقط في الحصول على تنبيه عندما تكون حالتك صحيحة في نهاية المخطط وكنت لا تحتاج إلى رؤية المؤشرات البيانية التاريخية على الرسم البياني لهذا، ثم في معظم الحالات يمكنك ببساطة استخدام ميزة تنبيه بسيط. ولا تهتم باستخدام دراسات جداول البيانات الأكثر تقدما. الفرق بين نظام جدول البيانات للدراسة التداول بالمقارنة مع دراسة جدول البيانات سيستيماليرت، هو أن نظام جدول بيانات التداول لديه منطق أكثر تقدما بكثير لإنشاء نظام التداول. مع مع نظام جداول البيانات لدراسة التداول يمكنك إجراء اختبار الظهر وتوليد إشارات التجارة الفعلية إما التي سيتم محاكاة أو يمكن إرسالها إلى خدمة التداول الخاصة بك. افتراضيا أنها سوف تكون دائما محاكاة. حتى لو كنت لا تريد فعلا أن تضع أوامر حية مع نظام جدول البيانات لدراسة التداول، وكنت ترغب فقط في إنشاء نظام واختبار الظهر ذلك، أو ترغب فقط في وضع الصفقات يدويا منه، لا تزال سوف ترغب في استخدام جدول البيانات نظام التداول دراسة بدلا من نظام جدول البياناتالعلاج. إذا كنت ببساطة تريد إنشاء نظام بسيط أو تنبيه المتقدمة لتعطيك مؤشرا عندما عاد القواعد ترو، ثم سوف تحتاج إلى استخدام دراسة جدول البيانات سيستيماليرت. يتم إنشاء سيستيماليرت عن طريق إدخال "شرط الشرط" في أعمدة الصيغة في جدول البيانات. يمكن لهذا الشرط الشرط الوصول إلى بيانات السعر والدراسة (يتم إخراج بيانات الدراسة بدءا من العمود آ بشكل افتراضي ويعتمد على عدد مدخلات أعمدة الصيغة.). سيتم تطبيق صيغة الشرط هذه على الرسم البياني للسعر بالكامل. وسوف يتم رصدها بشكل مستمر، ويمكن أيضا مسحها (يجب أن لا تفعل التداول الآلي من المسح الضوئي). يتم استخدام هذه الشرط الشرط لإعطاء مؤشر على حالة شرط معين هو ترو لأي عمود عمود مخطط. وتستخدم هذه المؤشرات لإنشاء نظام التداول أو تنبيه. ليس هناك فرق بين الطريقة سييرا الرسم البياني يفعل الأنظمة والتنبيهات. كلاهما يعطي الرسوم البيانية والنصوص والمؤشرات الصوتية عندما تكون صيغة الشرط الخاص بك ترو. على الرغم من أنه يتم إعطاء رسالة نصية أو صوت مسموع أو إشارة تجارية في حالة نظام جدول البيانات للدراسة التداول فقط عند إرجاع صيغة الشرط ترو على العمود الأخير في المخطط. أيضا، عندما يكون شرط الشرط هو ترو على العمود الأخير في المخطط، ثم سيتم عرض علامة أمام اسم الدراسة وسيتم تسليط الضوء على اسم الدراسة باللون الأحمر. نص رسالة التنبيه والصوت التنبيه مسموعة هي التي تشكل مؤشرا في حالة تأهب. في حالة دراسة نظام جدول البيانات للتداول، لا يتم إعطاء إشارة تجارية وتنبيه بالضرورة عندما تقوم صيغة الشرط في أحد أعمدة صيغة إدخال بيسيل بإرجاع ترو في العمود الأخير في المخطط. وهناك منطق آخر يتم تطبيقه وظروف أخرى يجب أن تتحقق. يتم شرح كل هذا في هذه الصفحة. بالإضافة إلى ذلك، في حالة دراسة نظام جداول البيانات للتداول، إذا كانت صيغة الشرط ترجع ترو في العمود الأخير في المخطط، فسيتم تجاهلها إذا تم تنزيل البيانات في المخطط أو عند إعادة حساب المخطط بالكامل. هذه هي طرق السلامة لمنع الصفقات من أن تعطى عن غير قصد، في حالة عندما سييرا الرسم البياني ليس في وضع محاكاة التجارة. يوفر سييرا الرسم البياني تنبيه النص لصيغة الشرط الخاص بك عندما يصبح ترو بإضافة رسالة مفصلة إلى سجل التنبيهات. لفتح سجل التنبيهات، حدد ويندو غغت أليرتس ماناجر غغت تنبيهات سجل في القائمة. إذا كانت الحالة ترو في شريط عمود مخطط بخلاف عمود المخطط الأخير، يتم إعطاء إشارة بيانية فقط. إنشاء نظام أو تنبيه ينطبق هذا القسم على دراسة جدول البيانات سيستيماليرت. اتبع التعليمات خطوة بخطوة دراسة جدول البيانات. عند اتباع هذه التعليمات، وتحصل على خطوة لإضافة الدراسة إلى المخطط، تأكد من إضافة دراسة جدول البيانات سيستيماليرت بدلا من ذلك. عند الوصول إلى الخطوة التي تدخل فيها صيغة، أدخل صيغة الشرط سيستيماليرت بدلا من ذلك. راجع قسم الأمثلة أدناه على سبيل المثال جداول البيانات سيستيماليرت شرط الصيغ. في حالة دراسة جدول البيانات سيستيماليرت، سيتم عرض نتائج الصيغة من جدول البيانات في منطقة الرسم البياني للأسعار الرئيسية (الرسم البياني المنطقة 1) من المخطط ويتم رسمها باستخدام أنماط "سهم التراجع" بشكل افتراضي. يمكن تغيير نمط الرسم من خلال إعدادات سوبغرافس على علامة التبويب سوبغرافس من نافذة ستودي سيتينغس لدراسة جدول البيانات سيستيماليرت. للحصول على إرشادات، ارجع إلى دراسات الإضافة. يجب أن ترجع الصيغ الموجودة في جدول البيانات قيمة 1 (ترو) أو 0 (فالس). تشير قيمة 1 أو ترو إلى استيفاء شرط الصيغة سيستيماليرت. على سبيل المثال: أدخل ID0.SG43 لوت 100 في الصف 3 من عمود الصيغة K لإعداد تنبيه دخول طويل عندما يكون سعر الإغلاق أقل من 100. عمود إدخال طويل العمود K هو عمود الإدخال الطويل. إذا كانت الخلية في هذا العمود ترو (1)، فسيتم رسم السهم لأعلى (يعتمد على نمط الرسم سوبغراف) على المخطط عند القيمة المنخفضة للشريط المقابل للإشارة إلى إدخال طويل لهذا الشريط. عمود إنهاء طويل العمود L هو عمود إنهاء طويل. إذا كانت الخلية في هذا العمود ترو (1)، فسيتم رسم سهم لليسار (يعتمد على نمط رسم سوبغراف) على المخطط عند القيمة العالية للشريط المقابل للإشارة إلى مخرج طويل لهذا الشريط. عمود الدخول القصير العمود M هو عمود الدخول القصير. إذا كانت الخلية في هذا العمود ترو (1)، فسيتم رسم سهم لأسفل (يعتمد على نمط رسم سوبغراف) على المخطط عند القيمة العالية للشريط المقابل للإشارة إلى إدخال قصير. عمود الخروج القصير العمود N هو عمود الخروج القصير. إذا كانت الخلية في هذا العمود ترو (1)، فسيتم رسم سهم لليمين (يعتمد على نمط الرسم من سوبغراف) على المخطط عند انخفاض قيمة الشريط للإشارة إلى إنهاء قصير. أعمدة أخرى عند رسم الأعمدة غير K. ل. م. أو N مع نمط رسم مرئي، يجب أن تكون قيمة إرجاع صيغة الشرط ضمن نطاق قيم السعر الرئيسي الرسم البياني مضاف إلى دراستك. وإلا، فإن عرض سوبغراف سيؤثر سلبا على عرض المخطط. لا توجد ترجمة تلقائية من ترو (1) أو فالس (0) إلى قيم بار عالية ومنخفضة، من عمودي الصيغة O وأعلى. مثال على الصيغة التي يمكنك استخدامها لأعمدة الصيغة O وأعلى هو إف (ID0.SG43 غ 100، C3، 0). تغيير أسماء الأعمدة ما سبق هي أسماء العمود صيغة سيستيماليرت الافتراضية. يمكنك إعادة تسمية الأعمدة في الصف 2 في الورقة واستخدامها لأي نوع من الشرط. لإعادة تسمية عمود، انقر مرتين على الخلية التي تحمل الاسم في الصف 2 واكتب اسما جديدا. التحكم في موقع السهام أو قيم سوبغراف يمكنك أيضا إرجاع قيم بخلاف ترو (1) أو فالس (0) في الصيغ حالة سيستيماليرت الخاص بك. إذا كانت القيمة التي تم إرجاعها بواسطة الصيغة غير ترو (1) أو فالس (0)، فسيتم رسم السهم بالقيمة التي ترجعها الصيغة عند استخدام الأعمدة K. ل. م. أو N عند استخدام دراسة جدول البيانات سيستيماليرت. بالنسبة لأعمدة الصيغة O وأعلى، سيتم دائما رسم أسهم سوبغراف أو أيا كان نمط الرسم، بالقيمة التي يتم إرجاعها من الصيغة. عند استخدام دراسة جدول البيانات سيستيماليرت، يمكنك إجراء مسح ضوئي لنتائج ترو من صيغ شرط النظام أو التنبيه بين قائمة من الرموز. لمزيد من المعلومات، راجع وثائق أوامر قائمة المسح الضوئي. إنشاء نظام تداول للتداول الآلي دخول أوامر التوقف إذا كنت تستخدم نظام جدول البيانات لدراسة التداول على حساب حقيقي وإرسال الطلبات إلى خدمة التداول المتصلة، وكنت ترغب في وقف دخول النظام لأي سبب من الأسباب، يمكنك القيام بأي من التالية: تمكين وضع محاكاة التجارة من خلال التأكد من أن هناك علامة الاختيار من قبل التجارة غتغ التجارة محاكاة وضع التشغيل. تعيين الإدخال إرسال أوامر التجارة الخدمة مع نظام جدول البيانات للتجارة إلى نو. قم بتعيين خلية "تعطيل التجارة التلقائية" على الورقة في جدول البيانات المستخدمة بواسطة نظام جدول البيانات لدراسة التداول، إلى ترو. قم بتعطيل الأمر تريد ترادينغ غغت أوتو ترادينغ إنابلد. خطوات إنشاء نظام تداول للتداول الآلي تأكد أولا من تمكين تداول السيارات. تأكد من وجود علامة الاختيار عن طريق التجارة غتغت تجارة السيارات تمكين في القائمة. تأكد من وجود علامة الاختيار عن طريق التجارة غتجت التجارة محاكاة وضع على القائمة. هذا هو أن أوامر لن يتم إرسالها إلى خدمة التداول الخاصة بك. بدلا من ذلك سيتم محاكاة جميع الصفقات. بالإضافة إلى ذلك، يجب تعيين المدخلات "إرسال أوامر للتجارة" مع نظام جداول البيانات للدراسة التداول إلى لا. كما يمنع ذلك من إرسال الأوامر إلى خدمة التداول المتصلة. مع هذين الإعدادين، هناك طبقتان من الحماية ضد إرسال أوامر الفعلية. للحصول على التفاصيل الكاملة، يرجى الرجوع إلى سيندوردرزتوترادسرفيس. اذهب إلى مخطط مفتوح أو افتح مخططا باستخدام ملف غتغ ابحث عن الرمز. تمكين التجارة غغت الرسم البياني وضع التجارة. حدد التجارة غتغ إرفاق التجارة نافذة إلى الرسم البياني. عندما يتم تنشيط وضع التداول المخطط على الرسم البياني، سترى أوامر والموقف من نظام التداول الآلي الخاص بك المعروضة على الرسم البياني. من خلال إرفاق نافذة التجارة بالرسم البياني، سيكون لديك لوحة تحكم تداول كاملة متاحة لاتخاذ أي إجراءات يدوية تحتاج إليها ولتعيين الأوامر المرفقة. يمكن العثور على مزيد من التفاصيل في وثائق التداول البياني. حدد تحليل غت الدراسات في القائمة. حدد نظام جداول البيانات للتداول في قائمة الدراسات المتاحة على اليسار. لا تخلط بين هذه الدراسة مع دراسة جدول البيانات أو نظام جداول البياناتالبرامج. اضغط على الزر إضافة لإضافة نظام جدول البيانات لدراسة التداول إلى قائمة الدراسات إلى الرسم البياني. على سبيل المثال، أضف الدراسة التي تدعى موفينغ أفيراج-سيمبل. لا تحتاج إلى تغيير إعدادات هذه الدراسة، الافتراضات مقبولة. سنقوم بإنشاء نظام سوف يشتري عندما يتحرك السعر الحالي فوق المتوسط ​​المتحرك وبيع عندما يتحرك السعر الحالي دون المتوسط ​​المتحرك. ويهدف هذا فقط كمثال في هذه التعليمات. هذا ليس بالضرورة نظام تداول عملي للاستخدام الفعلي. إذا كنت تريد أن تجعل نظام مختلف عن هذا المثال باستخدام دراسات أخرى، إضافتها إلى المخطط الآن إذا لم تكن قد أضفتها بالفعل. ضبط الإعدادات كما كنت في حاجة إليها لكل دراسة. تسليط الضوء على نظام جدول البيانات لدراسة التداول في مربع قائمة الدراسات إلى الرسم البياني. اضغط على زر الإعدادات. في نافذة إعدادات الدراسة الفنية في علامة التبويب الإعدادات والمدخلات، هناك مربع نص لاسم جدول البيانات (أسفل اليسار). أدخل اسما في مربع النص بدون إضافة ملف. هذا هو اسم جدول البيانات الذي سيتم فتحه أو إنشاؤه لاحتواء البيانات والصيغ. يجب أن يكون الاسم مرتبطا بما سيقوم به نظامك المخصص. للحصول على أوامر المرسلة إلى نظام محاكاة التجارة الداخلية سييرا المخطط، يجب أن يتم تعيين المدخلات "إرسال أوامر للتجارة" الخدمة إلى لا. لإرسال إشارات الطلب إلى خدمة التداول المتصلة، يجب أن يتم تعيين الإدخال إرسال أوامر التجارة الخدمة إلى نعم وتحتاج أيضا إلى تعطيل التجارة غغت التجارة محاكاة وضع على القائمة. للحصول على التفاصيل الكاملة، يرجى الرجوع إلى سيندوردرزتوترادسرفيس. في قائمة الإدخال، سوف تجد في إدخال اسمه أقصى موقف مسموح به في نفس الاتجاه. تعيين هذا الإدخال كما تريد. هو الحد الأقصى للموقف في الأسهم أو العقود المسموح بها. المدخلات الأخرى صحيحة كما هي في هذا المثال. لمزيد من المعلومات حول كافة المدخلات، راجع المدخلات التي هي محددة لأنظمة، والتنبيهات، والتداول الآلي. في قائمة الدراسة المتاحة المدخلات سترى مدخلات اسمه العمود K-Z تنبيه. قم بتعيينها إلى رقم صوت التنبيه الذي تريد سماعه عندما تصبح صيغة الشرط سيستيماليرت في العمود المقابل ترو في الشريط الأخير. للحصول على مزيد من المعلومات، يرجى الرجوع إلى "تنبيه صوتي" و "رسائل البريد الإلكتروني". اضغط على الزر موافق في نافذة إعدادات الدراسة الفنية. اضغط على الزر موافق في نافذة الدراسات التخطيطية. سيتم فتح جدول البيانات في الخلفية. انتقل إلى ذلك عن طريق اختيار سو في القائمة. سيتم سرد اسم جدول البيانات ويمكن تحديده. سيكون الاسم ما قمت بتحديده في نافذة إعدادات الدراسة للدراسة. يحتوي جدول البيانات على جداول بيانات متعددة. رقم الورقة التي يتم إخراج البيانات إليها، هو نفس رقم الورقة كرقم المخطط. على سبيل المثال، سيتم إخراج المخطط 2 إلى الورقة 2 في جدول البيانات. يمكن تحديد الورقة مع مربع القائمة في أعلى يسار جدول البيانات. يتم أيضا إخراج جميع الدراسات الرسم البياني الفردية إلى نفس الورقة بدءا من العمود آ (الافتراضي عند استخدام 16 أعمدة الصيغة). حدد الورقة من مربع القائمة في الجزء العلوي الأيسر من إطار جدول البيانات الذي يتوافق مع رقم المخطط الذي يحتوي على نظام جدول البيانات لدراسة التداول. تعيين الخلية J26 (طلب الكمية) لعدد من الأسهم أو العقود التي تريد التجارة عند إرسال أمر. ويمكن أيضا أن يتم تعيين هذا إلى 0 وسيتم تحديد كمية الطلب من الرسم البياني نافذة التجارة. جميع الأوامر الجديدة تستخدم إعدادات نافذة التجارة للرسم البياني. انتقل إلى المخطط الذي يحتوي على نظام جدول البيانات لدراسة التداول. حدد التجارة غغت فتح نافذة التجارة الرسم البياني لمعرفة ما هي الإعدادات التي تم تعيينها إلى. على سبيل المثال، إذا تم تعيين الوقت في القوة إلى يوم. فإن جميع الطلبات الجديدة التي يتم تقديمها من جدول البيانات سيكون لها تلقائيا الوقت الساري من اليوم. وتشمل الإعدادات التي يمكنك تعيينها في نافذة التجارة أيضا الأوامر المرفقة. للحصول على تعليمات كاملة بشأن الطلبات المرفقة، راجع صفحة الطلبات المرفقة. توفر الخطوات التالية مثالا لنظام التداول باستخدام صيغ جداول البيانات. شراء يتم إدخال الصيغ دخول وبيع. للشراء عندما يعبر السعر الأخير من أسفل المتوسط ​​المتحرك، اكتب K3 الخلية (المسمى: دخول الشراء): كروسفرومبيلو (ID0.SG43: ID0.SG44، ID2.SG13: ID2.SG14) حيث ID0.SG43: ID0.SG44 يشير إلى أسعار التداول الأخيرة والسابقة الأخيرة من أشرطة الرسم البياني و ID2.SG13: ID2.SG14 يشير إلى المتوسط ​​المتحرك الحالي والسابق - قيم الدراسة البسيطة التي تقع في العمود آ. في جميع الأماكن في صيغ الصيغ الموجودة في هذه الصفحة، قد يلزم تغيير ID2 إلى رقم المعرف الفعلي الذي تستخدمه دراسة المتوسط ​​المتحرك. يمكنك رؤية رقم المعرف الفعلي في الصف 1 في العمود الذي يتم إخراج الدراسة إليه. الرجوع إلى الصورة أدناه: يمكنك أيضا اختياريا استخدام: أند (كروسفرومبيلو (ID0.SG43: ID0.SG44، ID2.SG13: ID2.SG14)، J80) J8 هو الكمية الحالية للوضع التجاري. هذا يمكن استخدامها للتحقق من موقف شقة قبل دخول السوق. منطق التداول الآلي الأساسي يتحقق هذا، ولكن يمكن التحقق في الصيغة الخاصة بك لتجنب الرسائل غير الضرورية إلى التجارة التجارة غغت سجل الخدمة. العيب هو أنه لا يمكنك أن ترى على الرسم البياني الخاص بك التاريخية شراء وبيع السهام إشارة دون تشغيل اختبار الظهر. لفهم المراجع مثل ID2.SG43. راجع المراجع إلى أعمدة سوبغراف الدراسة عند استخدام دراسة جدول البيانات. للبيع عندما يعبر السعر الأخير من فوق المتوسط ​​المتحرك، اكتب في الخلية M3 (المسمى: دخول دخول): كروسفرومابوف (ID0.SG43: ID0.SG44، ID2.SG13: ID2.SG14) حيث ID0.SG43: ID0.SG44 يشير إلى أسعار التجارة الحالية والسابقة الأخيرة من أشرطة الرسم البياني و ID2.SG13: يشير ID2.SG14 إلى المتوسط ​​المتحرك الحالي والسابق - القيم البسيطة التي توجد في العمود آ. يمكنك أيضا اختياريا استخدام: أند (كروسفرومبيلو (ID0.SG43: ID0.SG44، ID2.SG13: ID2.SG14)، J80) J8 هو الكمية الحالية للوضع التجاري. هذا يمكن استخدامها للتحقق من موقف شقة قبل دخول السوق. منطق التداول الآلي الأساسي يتحقق هذا، ولكن يمكن التحقق في الصيغة الخاصة بك لتجنب الرسائل غير الضرورية إلى التجارة التجارة غغت سجل الخدمة. العيب هو أنه لا يمكنك أن ترى على الرسم البياني الخاص بك التاريخية شراء وبيع السهام إشارة دون تشغيل اختبار الظهر. وباستخدام هذه الصيغ، عندما يعبر السعر الأخير من أسفل المتوسط ​​المتحرك، فإن K3 (دخول الشراء) سيؤدي إلى أمر الشراء، وعندما يعبر السعر الأخير من المتوسط ​​المتحرك، سيصدر M3 (دخول البيع) أمر بيع. الافتراضي، يمكن إرسال أمر واحد فقط حتى يتم إعطاء إشارة خروج المقابلة. لذلك، إذا كان هناك بالفعل شراء شراء، ثم يتم تجاهل كافة إشارات شراء دخول أخرى حتى تصبح الصيغة خروج الخروج ترو ويؤدي إلى بيع أو موقف بالارض بطريقة أخرى. إذا كان هناك بالفعل "إدخال بيع"، يتم تجاهل كافة إشارات "دخول بيع" أخرى حتى تصبح الصيغة "إنهاء بيع" ترو ويؤدي إلى شراء أو يتم تسوية الوضع القصير بطريقة أخرى. يتم التحكم في هذا السلوك مع السماح الإدخالات متعددة في نفس الاتجاه الإدخال. إذا تم تعيين السماح الدخول المعاكس مع موقف معارضة أو أوامر الإدخال إلى نعم. الذي هو الافتراضي، ثم إذا كان هناك حاليا موقف طويل، ثم دخول بيع يمكن الخروج من هذا المنصب. الشيء نفسه مع موقف قصير وشراء الدخول. إذا كان لديك شروط متعددة لنظام التداول الخاص بك، ثم سوف تحتاج إلى استخدام الدالة أند (). على سبيل المثال، إذا كان لديك مؤشر رسي (مؤشر القوة النسبية) دراسة على الرسم البياني ويتم إخراج البيانات إلى العمود أس على ورقة، وتريد الجمع بين ذلك مع دراسة المتوسط ​​المتحرك، استخدم صيغة مماثلة لهذا لشراء إنتري: أند (كروسفرومبيلو (ID0.SG43: ID0.SG44، ID2.SG13: ID2.SG14)، ID3.SG13 لوت 40). ID3.SG13 تشير إلى مؤشر القوة النسبية على افتراض أنه يحتوي على معرف الدراسة من 3. لمزيد من المعلومات، راجع مراجع لأعمدة دراسة سوبغراف عند استخدام دراسة جدول البيانات. في هذا المثال سنقوم بإنشاء "شراء خروج" (بيع) الذي يخرج من موضع عند الوصول إلى قيمة إيقاف أو الهدف. A شراء الخروج هو اختياري. يمكن أن يقوم "بيع بيع" بإغلاق الصفقة التي تم إنشاؤها بواسطة إدخال الشراء. أو، يمكن إغلاق الموقف يدويا أو مع النظام المرفق. في هذا المثال، نستخدم صيغة "إنهاء الشراء" لعرض استراتيجية خروج يتم إدارتها بالكامل بواسطة نظام جدول البيانات للدراسة التجارية. في الخلية L3 (المسمى: إنهاء الخروج)، اكتب أور (أند (J8 غ 0، ID0.SG43 لوت J9-1) و (J8 غ 0، ID0.SG43 غ J92)). ID0.SG43 يشير إلى آخر سعر أحدث شريط الرسم البياني، يشير J8 إلى الوضع الحالي الكمية، ويشير J9 إلى الوضع الحالي متوسط ​​السعر. عندما ترجع هذه الصيغة في الخلية L3 ترو، سيتم تشغيل أمر بيع. ما تعنيه هذه الصيغة هو أنه عندما يكون هناك موقف طويل والسعر الأخير أقل من السعر الذي تم ملئه في شراء نقطة الشراء ناقص 1 نقطة كاملة (إيقاف)، أو هناك موقف طويل والسعر الأخير أكبر من السعر تم شغل دخول الشراء في زائد 2 نقاط كاملة (الحد)، ثم عودة ترو. سيؤدي هذا إلى وضع أمر بيع. هذا مجرد مثال وتحتاج إلى استخدام ما هو مناسب في حالتك المحددة. ملحوظة . من الضروري أن تحتوي الصيغة على شيك بأن هناك موضع غ 0. يتم شرح ذلك بمزيد من التفصيل في قسم "إنهاء الشراء". تعني إشارة مرجع الخلية إلى خلية مطلقة ولن يتم ضبط العمود والصف عند ملء الصيغة تلقائيا. هذه الصيغة ذات صلة فقط بأعلى صف في جدول البيانات (يتوافق مع الشريط الأخير في المخطط)، على الرغم من أنه يتم تطبيقه على أشرطة تاريخية أيضا. ارجع إلى قسم القيم المخرجات الخاصة بجدول البيانات للحصول على مزيد من المعلومات حول البيانات في العمود J. عند إدخال الأرقام والصيغ، ضع في اعتبارك استخدام المحددات المناسبة في الأرقام والصيغ، وفقا للإعدادات العالمية غت إعدادات جدول البيانات غغت عشري وإعداد محددات الوظيفة. لمزيد من المعلومات، راجع المقطع العشري وقسم محددات الدالة. في هذا المثال، سننشئ عملية بيع بيع (شراء) تخرج من الموضع عندما يتم الوصول إلى إيقاف أو هدف. بيع الخروج هو اختياري. A شراء يمكن أن تغلق الدخول من موقف إنشاؤها من قبل دخول بيع. أو، يمكن إغلاق الموقف يدويا أو مع النظام المرفق. في هذا المثال، نحن نستخدم "إنهاء بيع" لعرض استراتيجية خروج تدار بشكل كامل من قبل نظام جدول البيانات للدراسة التداول. في الخلية N3 (المسمى: بيع إنهاء)، اكتب أور (و (J8 لوت 0، ID0.SG43 غ J91 )، و (J8 لوت 0، ID0.SG43 لوت J9-2)). ID0.SG43 يشير إلى آخر سعر من شريط الرسم البياني الأخير، يشير J8 إلى الموضع الكمية، ويشير J9 إلى الموضع متوسط ​​السعر. عندما ترجع هذه الصيغة في الخلية N3 ترو، فإنه سيتم إرسال أمر شراء. ما تعنيه هذه الصيغة هو أنه عندما يكون هناك موقف قصير ويكون السعر الأخير أكبر من السعر الذي تم ملئه في عملية الشراء عند نقطة واحدة زائد (إيقاف) أو يوجد موضع قصير والسعر الأخير أقل من السعر تم ملء عملية بيع البيع في ناقص 2 نقاط كاملة (الحد)، ثم إرجاع ترو. سيؤدي هذا إلى وضع أمر الشراء. هذا مجرد مثال وتحتاج إلى استخدام ما هو مناسب في حالتك المحددة. ملحوظة . من الضروري أن تحتوي الصيغة على شيك بأن هناك موضع لوت 0. يتم شرح ذلك بمزيد من التفصيل في قسم "إنهاء بيع". تعني إشارة مرجع الخلية إلى خلية مطلقة ولن يتم ضبط العمود والصف عند ملء الصيغة لأسفل. هذه الصيغة ذات صلة فقط بأعلى صف في جدول البيانات (يتوافق مع الشريط الأخير في المخطط)، على الرغم من أنه يتم تطبيقه على أشرطة تاريخية أيضا. ارجع إلى قسم القيم المخرجات الخاصة بجدول البيانات للحصول على مزيد من المعلومات حول البيانات في العمود J. ملاحظة: في حالة التداول المباشر الفعلي، يتم إرسال هذه التوقفات والأهداف بواسطة مخطط سييرا لخدمة التداول المتصلة عند استيفاء الشروط. هذا ضروري من أجل تحقيق استراتيجيات الخروج المتقدمة. على الرغم من أن هذه ليست استراتيجيات الخروج المتقدمة، ونحن نوضح كيف يمكنك القيام استراتيجيات الخروج المتقدمة. من أجل وضع أمر في أسرع وقت ممكن، فمن فكرة جيدة للتأكد من مخطط تحديث الفاصل الزمني. الذي يتم تعيينه من خلال الإعدادات العامة إعدادات غغت العامة في القائمة، يتم تعيين إلى 1000 ميلي ثانية أو أقل. ومع ذلك، تجنب جعلها صغيرة جدا إلا إذا كان جهاز الكمبيوتر الخاص بك سريع جدا. يمكنك أيضا استخدام الأوامر المرفقة للخروج من الموضع. ارجع إلى بدء صفقات التداول التلقائي واستخدام مخارج الطلبات اليدوية أو المرفقة. الآن بعد أن أدخلنا الصيغ جدول البيانات على جدول البيانات، فمن الضروري أن نعود إلى الرسم البياني. حدد نافذة في القائمة وحدد المخطط الذي قمت بتطبيقه نظام جدول البيانات للدراسة التداول، أو حدده من علامات التبويب نافذة المخطط الموجودة في أعلى أو أسفل النافذة الرئيسية. للتأكد من أن الصيغ التي تم إدخالها يتم نسخها بالكامل أسفل أعمدة الصيغة في جدول البيانات، حدد تشارت غغت ريكالكولات في القائمة. الرجوع إلى الأسهم شراء وبيع على الرسم البياني. تمثل هذه الأسهم قيم ترو التي تم إرجاعها من الصيغ شرط الشراء دخول وبيع إدخال في أعمدة الصيغة. افتراضيا، يتم تعيين نمط رسم سوبغراف لأعمدة الخروج (L و N) إلى "مخفي". حتى لا تظهر. في هذا المثال، نستخدم المخارج التي تستند إلى بيانات الموضع التي تعرف فقط بالوضع الحالي. وبالتالي فإن الأسهم بيسيل ليست ذات صلة تاريخيا. إذا كانت المخارج الخاصة بك على أساس بيانات دراسة السعر أندور، ثم هل يمكن تعيين الأعمدة خروج المقابلة إلى نمط رسم مرئية. تأكد من وجود علامة الاختيار عن طريق التجارة غتغت تجارة السيارات ممكنة بحيث تتم معالجة النتائج ترو التي توفرها الصيغ شرط، كما الصفقات. كما يتم تحديث المخطط، إما مع تدفق البيانات في الوقت الحقيقي وردت من تغذية البيانات المتصلة، أو أثناء إعادة التشغيل، وإشارات الشراء والبيع والخروج والخروج سوف يسبب أوامر التجارة لتوليد ومعالجتها. هذه الإشارات أيضا إنتاج رسائل التنبيه وهذه يمكن أن ينظر إليها عن طريق تحديد نافذة غغت شوهيد مدير تنبيهات غغت تسجيل الدخول في القائمة. لعرض أوامر التداول الخاصة بك، حدد التجارة غغت سجل النشاط التجاري في القائمة. لعرض سجل خدمة التجارة، حدد تريد غغت تريد سيرفيس لوغ في القائمة. يعرض سجل خدمة التجارة الإشارات المتجاهلة من صيغة الشرط. الخطوة التالية هي ببساطة مشاهدة النظام الخاص بك أداء في الوقت الحقيقي كما يتم تحديث المخطط الخاص بك أو إعادة الرسم البياني الخاص بك لإجراء اختبار الظهر. اختبار مرة أخرى من خلال الاعادة هو وسيلة جيدة جدا لاختبار النظام الخاص بك على البيانات التاريخية والحصول على شعور جيد لذلك. للانتقال من التداول المحاكى الى التداول غير المحاكى (لايف)، اتبع التعليمات فى الانتقال من التداول المحاكى الى التداول غير المحاكى (لايف). الانتقال من التداول المحاكى إلى التداول غير المحاكى (الحي) إذا كنت مستعدا لتقديم نظام التداول الخاص بك عندما تكون مستعدا لتقديم أوامر حقيقية، سوف تحتاج إلى الذهاب إلى وضع غير محاكاة من خلال التأكد من عدم وجود علامة الاختيار من قبل التجارة التجارة غغت محاكاة وضع التشغيل. بعد ذلك، انتقل إلى "إعدادات الدراسة" لنظام جداول البيانات لدراسة التداول على الرسم البياني الخاص بك، وقم بتعيين "إرسال أوامر إلى التجارة خدمة الإدخال" إلى "نعم". في هذا الوقت سيتم إرسال أية إشارات تداول معينة كأوامر إلى خدمة التداول الخاصة بك، على افتراض أنك متصل بخدمة تداول صالحة وكنت متصلا بخادم البيانات والتجارة (ملف غغت الاتصال بتغذية البيانات). نضع في اعتبارنا أنه إذا كنت تستخدم حساب محاكاة مع خدمة التداول الخاص بك، ثم على الرغم من أنك لست في سييرا الرسم البياني وضع محاكاة التجارة وإرسال أوامر لخدمة التجارة يتم تعيين إلى نعم، سوف لا يزال يتم محاكاة أوامر. صوت لتنبيه مسموع والبريد الإلكتروني الإخطارات رسالة يمكنك تحديد صوت تنبيه ليتم تشغيلها عندما تصبح حالة النظام أو تنبيه في الخلايا من K3 إلى Z3 ترو. للصيغ في ورقة لتحريك التنبيهات الصوتية يتطلب تمكين لهم. انتقل إلى نافذة إعدادات الدراسة لدراسة جدول البيانات الخاص بك. للحصول على إرشادات، راجع "تعديل الدراسات". ضع في اعتبارك أنه بعد تطبيق دراسة جدول بيانات على مخطط فإنه يغير اسمه في قائمة الدراسات إلى الرسم البياني في نافذة الدراسات التخطيطية إلى اسم ملف جدول البيانات الذي يشير إليه. في علامة التبويب إعدادات والمدخلات من نافذة إعدادات الدراسة سترى قائمة بجميع المدخلات الدراسة المتاحة. سترى العديد من المدخلات اسمه العمود K، L، M، N، O، P، Q، R، S، T، U، V-Z تنبيه التي سوف تمكنك من تحديد رقم صوت تنبيه لاستخدامها في كل عمود. حدد رقم صوت التنبيه الذي تريد استخدامه أو حدد لا تنبيه لعدم تشغيل صوت تنبيه عندما تصبح الصيغة ترو في الخلايا من K3 إلى Z3. تستخدم أعمدة الورقة من W إلى Z رقم صوت التنبيه نفسه كعمود V. لتعيين ملف الصوت الذي يتم تشغيله لكل رقم تنبيه، حدد الإعدادات العامة غت إعدادات عامة في القائمة. يمكنك أيضا إعداد رسالة بريد إلكتروني ليتم إرسالها عند تشغيل صوت التنبيه. إذا تم تعيين العمود رسم نمط ورقة لتجاهل. ثم لا يمكن تشغيل أي إشارات النظام أو التنبيه من خلال الصيغ ورقة. ومع ذلك، لا ينطبق هذا على العمود K إلى N عند استخدام نظام جدول البيانات لدراسة التداول. مع هذه الدراسة، إشارات التجارة يمكن دائما أن تكون ناجمة عن الصيغ ورقة بغض النظر عن إعداد نمط الرسم. بدء صفقات التداول التلقائي واستخدام عمليات الخروج اليدوية أو المرفقة الطلبات ليس من الضروري استخدام خلايا صيغة "إنهاء الشراء" أو "إنهاء أمر إنهاء الإجراء" في نظام جدول البيانات للدراسة التداول للخروج من الموضع الحالي. يمكن أن يتم الخروج من خلال إدخال أمر يدويا من خلال نافذة التجارة. من خلال الرسم البياني للتجارة. أو يمكن تنفيذها باستخدام ميزة "الأوامر المرفقة" (الأهداف والتوقف). في أي من هذه الحالات، يمكنك بعد ذلك ترك اختياريا خيار الشراء أو الخروج من أمر إجراء إجراءات صيغة فارغة. يتم تكوين الأهداف والإيقافات من خلال نافذة التجارة في علامة التبويب الأهداف. للحصول على وثائق كاملة، ارجع إلى صفحة الطلبات المرفقة. عند استخدام الأوامر المرفقة، تأكد من تمكين استخدام الأوامر المرفقة في نافذة التجارة للرسم البياني الذي يحتوي على نظام جداول البيانات للدراسة التداول. ارجع الى فتح نافذة التجارة للرسم البياني لفتح نافذة التداول. يتم حفظ مجموعة الأوامر المرفقة التي يتم إدخالها في نافذة التجارة لرسم بياني عند حفظ تشارتبوك. لن يتم استخدام الأوامر التي يتم تقديمها من خلال خلايا صيغة أكتيون أوردر أكتيون أكتيون أوردر أكتيون أوردرز أكتيون أوردرز التي تم تكوينها في نافذة التداول. فقط شراء دخول الدخول وبيع استخدامها عند استخدام استخدام الأوامر المرفقة تمكين على نافذة التجارة. عندما كنت تستخدم وظيفة التداول الآلي في سييرا الرسم البياني، فمن المستحسن أن تقوم دائما بإلغاء وإلغاء أي أوامر يدوية من داخل سييرا الرسم البياني لتجنب أي قضايا التجارة السيارات غير متوقعة بسبب سييرا الرسم البياني لم تكن على بينة من أوامر والموقف التجاري التغييرات لك القيام به من برامج التداول الأخرى. للحصول على معلومات إضافية حول استخدام الأوامر المرفقة مع نظام التداول الآلي، راجع سوبورتاتاشدوردرزفورترادينغ. استخدام كل من الأوامر المرفقة وشراء الخروج والخروج الخروج في نفس الوقت من الممكن تحديد مجموعة من الأوامر المرفقة لاستخدامها مع نظام جدول البيانات الخاص بك لدراسة التداول وأيضا استخدام أعمدة الخروج بيسيل في نفس الوقت. لكي يعمل هذا بشكل صحيح، تحتاج إلى تعيين إلغاء كافة أوامر العمل عند الخروج من الإدخال إلى نعم. التجارة كمية أمر النافذة مع الأوامر المرفقة عند استخدام الأوامر المرفقة مع نظام جدول بيانات للدراسة التداول، فإن كمية الطلب على نافذة التجارة سوف تتغير إلى كمية الطلب الحالية المحددة في جدول البيانات. وذلك لأن الأوامر المرفقة يتم تعريفها من خلال علامة التبويب أهداف نافذة التجارة، ومن الضروري تحديث كمية نافذة التجارة لتتناسب مع كمية الطلب من نظام التداول من أجل أن يكون للأوامر المرفقة كمية مطابقة. للحصول على مزيد من المعلومات حول إعداد "كمية الطلب" لنظام جدول البيانات لدراسة التداول، راجع الخلية J26 (كمية الطلب). استراتيجيات الخروج المتقدم الآلي قد ترغب في إدخال موضع يدويا ثم الحصول على مخرج الموضع التلقائي بناء على بعض الشروط التقنية التي يمكن أن تستند إلى السعر وبيانات الدراسة. ويتم ذلك باستخدام نظام جدول البيانات لدراسة التداول. ارجع إلى إنشاء نظام التداول لتعليمات التداول الآلي في هذه الصفحة لاستخدام هذه الدراسة وتحديد شروط الخروج. سوف تحتاج الدراسة إلى تطبيق على رسم نفس الرمز الذي يتم تداوله. عند استخدام نظام جدول البيانات للتداول لهذا الغرض، لن تستخدم أعمدة "شراء دخول" و "إدخال أمر الدخول". يجب ترك هذه الأعمدة فارغة. Any steps in the instructions associated with them can be skipped. You will only use the Buy Exit and Sell Exit Order Action columns. Spreadsheet System for Trading study Inputs related to Buy Entry and Sell Entry will not apply for your automated exit strategy. When either the Buy Exit or Sell Exit Order Action columns become TRUE, an order will be submitted at that time. This can be any of the order types supported by the Spreadsheet System for Trading study. Only when your Exit condition is met, will the order be submitted, not before. Therefore, it is not possible to submit a Stop or Limit order ahead of time and modify it. Therefore, Sierra Chart needs to be running to monitor your current Position and submit the orders. It is possible to use the ACSIL Trading functions and modify an order that has been submitted. Spreadsheet Study Inputs that are Specific to Systems, Alerts, and Automated Trading This section lists Inputs for the Spreadsheet Studies which are specific to the Spreadsheet System for Trading and the Spreadsheet SystemAlert studies. These inputs can only be set through the Study Settings window for the Spreadsheet studies. For the other available Spreadsheet Study Inputs which are set through the Study Settings window, refer to the Spreadsheet Study Inputs page. A Read-only display of these Study Inputs is displayed on the Spreadsheet Sheet that the chart data is outputted to, in cell columns I and J . It is not possible to modify the value of these Inputs through the Sheet cells. They can only be set through the Study Settings window for the Spreadsheet study. Reset Condition On New Bar If this option is set to Yes . then a system or alert signal will be given when a new bar is added to the chart and the SystemAlert condition is TRUE at row 3 even though the SystemAlert condition was previously TRUE on the prior barrow. Normally, when a formula returns TRUE or a nonzero value in one of the Spreadsheet columns used for systems or alerts and a new bar is added, a new signal will not be given even if it still TRUE. It will have to go back to FALSE and then back to TRUE again, unless this input is set to Yes. AlertSignal Only Once per Bar If the AlertSignal Only Once Per Bar option is set to Yes . then an alert or trading signal will be given only once per Formula Column per bar in the chart. When an alert or trading is given once for a specific Spreadsheet Formula Column, then another will not be given until there is a new bar in the chart and the SystemAlert Condition Formula goes back to FALSE and then to TRUE. This applies to each formula column independently. For example, in the case of the Spreadsheet System for Trading study, if there is a Buy Entry at a particular bar, there can still be a Buy Exit given at the same bar. However, there cannot be 2 Buy Entries on the same bar when this option is enabled. It is recommended that if you have any trouble obtaining a trading signal when you normally would expect one, that you try setting this option to No . In the case of the Spreadsheet System for Trading study, when a signal is ignored because of this option, that ignored signal will be logged in the Trade gtgt Trade Service Log . This is very helpful for troubleshooting purposes. The message is: Signal ignored because Signal Only Once Per Bar is enabled and a signal was already given from formula column for bar. Allow Multiple Entries In Same Direction This input applies only to the Spreadsheet System for Trading study. Refer to the description on the Auto Trade Management page. Signal Only on Bar Close The Signal Only on Bar Close Inputs are specific to the Spreadsheet System for Trading study and the Spreadsheet SystemAlert study. There are two versions of this input, one for Sheet columns K and M and the other for columns L . N-Z . When this input is set to Yes . Sheet formulas that return a non-zero (TRUE) value at row 3 in the corresponding formula columns are ignored until the last bar closes. The way this is accomplished is row 4 is monitored instead of row 3. When this input is set to Yes . then anywhere in the documentation row 3 is mentioned, it is row 4 instead. In the same way that row 3 is continuously monitored for TRUE results from formulas in the corresponding formula columns, row 4 will be continuously monitored when this input is set to Yes. You may want to set Strict Signal Only On Bar Close Evaluation to Yes, when you set one of these inputs to Yes. There is one scenario that you should keep in mind about when using Signal Only on Bar Close . Consider you have a formula and one of the Sheet formula columns and it returns TRUE at row 3 (the last bar of the chart) in the column. You refer to the arrow on the chart. A new bar is added, the bar therefore is considered closed, the formula moves down to row 4, it is no longer TRUE and the arrow disappears. In this case when you are using Signal Only on Bar Close. you will not get a signal. Strict Signal Only On Bar Close Evaluation The Strict Signal Only On Bar Close Evaluation input applies a stricter method of evaluation when you have either of the Signal Only on Bar Close inputs set to Yes. When this input is set to Yes, then only at the moment when a bar closes when one or more new bars are added to the chart, will an evaluation of your Spreadsheet formulas from the corresponding Spreadsheet columns ( K . M . L . N-Z ) be evaluated for TRUE conditions. When this input is set to Yes, row 4 will not be continuously monitored as usual, only exactly at the moment when a bar closes and the chart is updated. Use Chase Orders This input only applies to the Spreadsheet System for Trading study. When this input is set to Yes and you have enabled limit orders for a particular BuySell column, then the limit order will be submitted as a Limit Chase Order. The chase amount is set through the J46 cell labelled Maximum Chase Amount for Limit Chase Orders . Enhanced Auto Trade Signal Related Logging This Input when set to Yes . will log additional messages indicating the reason why an order signal is ignored from formula columns K, L, M, N at rows 3 and 4 when using the Spreadsheet System for Trading study. This is helpful to troubleshoot problems with ignored signals. Set this Input to Yes only for a short period of time and only when necessary because it generates a large amount of messages and can create a very heavy and unnecessary CPU load when doing back testing to the point where a tick by tick back test becomes next to impossible to complete and extremely burdensome. BuyEntry (K), BuyExit (L), SellEntry (M), SellExit (N) Spreadsheet Order Action Columns The following Spreadsheet Order Action Columns only apply to the Spreadsheet System for Trading study. Note: For all of the below Order Actions: When an order is submitted, an Alert Sound will also be played if you selected an Alert Sound for the corresponding Spreadsheet column in the Input Settings in the Study Settings window. An alert message will also be added to the Window gtgt Alerts Manager gtgt Alerts Log . Buy Entry (column K) When your Condition Formula in row 3 of column K on the Spreadsheet returns a nonzero value or TRUE, then a Buy order will be given if certain conditions are met. For complete details, refer to the Auto Trade Management page. Buy Exit (column L) When your Condition Formula in row 3 of column L on the Spreadsheet returns a nonzero value or TRUE, then a Sell order will be given if certain conditions are met. For complete details, refer to the Auto Trade Management page. You need to code into your Exit formulas by using the AND() Spreadsheet function, a check that there is a Trade Position Quantity. An example would be: OR(AND(J8 gt 0, ID0.SG43 lt J9-1), AND(J8 gt 0, ID0.SG43 gt J92)). The reference to cell J8 refers to the current Trade Position Quantity . The dollar signs in J8 mean it is an absolute Spreadsheet reference. In the case of a Buy Exit formula, you must to check to make certain there is a long Trade Position by making certain that J8 is gt than 0. The purpose of this is so that the formula remains FALSE until such time that a Trade Position can be exited. Otherwise, the formula could become TRUE on a bar and give a signal even before there is a Trade Position. In this case it will be ignored as it should be. However, if it remains TRUE and then later on that very same bar or a different bar, when there finally is a Trade Position, there will no longer be an Exit signal because the prior TRUE state was already ignored and the formula remains TRUE and not giving a new signal. Sell Entry (column M) When your Condition Formula in row 3 of column M on the Spreadsheet returns a nonzero value or TRUE, then a Sell order will be given if certain conditions are met. For complete details, refer to the Auto Trade Management page. Sell Exit (column N) When your Condition Formula in row 3 of column N on the Spreadsheet returns a nonzero value or TRUE, then a Buy order will be given if certain conditions are met. For complete details, refer to the Auto Trade Management page. You need to code into your Exit formulas by using the AND() Spreadsheet function, a check that there is a Trade Position Quantity. An example would be: OR(AND(J8 lt 0, ID0.SG43 gt J91), AND(J8 lt 0, ID0.SG43 lt J9-2)). The reference to cell J8 refers to the current Trade Position Quantity . The dollar signs in J8 mean it is an absolute Spreadsheet reference. In the case of a Sell Exit formula, you must to check to make certain there is a short Trade Position by making certain that J8 is lt than 0. The purpose of this is so that the formula remains FALSE until such time that a Trade Position can be exited. Otherwise, the formula could become TRUE on a bar and give a signal even before there is a Trade Position. In this case it will be ignored as it should be. However, if it remains TRUE and then later on that very same bar or a different bar, when there finally is a Trade Position, there will no longer be an Exit signal because the prior TRUE state was already ignored and the formula remains TRUE and not giving a new signal. Ignored Signals With Spreadsheet Systems or Alerts Introduction There are many cases in which a Buy or Sell signal from the Entry and Exit formula columns (K, L, M, N) will be ignored. When a signal is ignored from a formula that returns a nonzero number or TRUE, then there will be no Alert Sound played, Alert Message logged, or a Trade Order sent . This section explains all of this. Enabling Auto Trading If Trade gtgt Auto Trading Enabled is unchecked, then Buy and Sell trade order signals from the Spreadsheet System for Trading study will be ignored. In this case you will see messages added to the Trade gtgt Trade Service Log indicating this. The Send Orders to Trade Service study Input setting needs to be set consistently with the Trade gtgt Trade Simulation Mode On setting on the menu. If it is not, then Buy and Sell trade order signals from the Spreadsheet System for Trading study will be ignored. In this case you will see messages added to the Trade gtgt Trade Service Log indicating this. For complete details, refer to SendOrdersToTradeService. Ignored Signals During Historical Data Downloading With the Spreadsheet System for Trading study and the Spreadsheet SystemAlert study, System and Alert signals from the Sheet formula columns are ignored on historical data and when historical data is being downloaded. They are monitored for when the chart is actually updating with new data. A chart will be updating with new data during real-time chart updating with live data, during replays, or during a Back Test. If you want to see the Back Test results from historical Buy and Sell signals from the BuySell formula columns in the case of when using the Spreadsheet System for Trading study, then refer to the Back Testing section. BuySell Arrows Do Not Mean Trade Signals When using the Spreadsheet System for Trading study and a formula returns TRUE in the Buy Entry (K3), Buy Exit (L3), Sell Entry (M3), or Sell Exit (N3) cell, a trade signal is not necessarily going to be given. You will see an arrow on the chart indicating a buy or sell signal, assuming the corresponding Subgraph Draw Style is set to a visible style. However, this does not necessarily mean that the formula TRUE result will be followed and a trade signal will be given. The BuyEntry (K), BuyExit (L), SellEntry (M), SellExit (N) Spreadsheet Order Action Columns rules must be met and the additional conditions imposed by the related study Input Settings must be met, for a trade signal to be actually given. If one is ignored, then a message will be added to the Trade gtgt Trade Service Log indicating the reason. Review the Trade Service Log for the reason. To see on the chart the actual filled orders from trades made, refer to Displaying Filled Orders. Reset Condition on New Bar When using either the Spreadsheet System for Trading or Spreadsheet SystemAlert studies, the TRUE signals given from cells K3 through Z3 may not always be followed and give an alert or trade signal, even though they still return TRUE or a non zero value and an arrow shows on the chart. If a cell is TRUE and there is a new bar added to the chart and the cell continues to be TRUE, because the state is already TRUE, you will not get a new signal unless the input Reset Condition on New Bar is set to Yes. Signal Only Once per Bar If a TRUE signal has been given by the formula in a particular cell and then it goes back to FALSE and back to TRUE on the same bar, you will not get a signal if the study Input Signal Only Once Per Bar is set to Yes . Signal Only on Bar Close If you have the Signal Only On Bar Close (Column K, M) input set to Yes, then a TRUE signal will be ignored on cells K3 and M3, and only the cells K4 and M4 will be monitored for signals. Likewise with the Signal Only On Bar Close (Column L, N-Z) input. In the case of when either Signal Only Once per Bar and Signal Only on Bar Close study Inputs have been set to Yes . when a signal is ignored by these restrictions, there is no message added to the Trade Service Log or the Alerts Log . except in the case of the Spreadsheet System for Trading study when the signal has been ignored as the result of Signal Only Once Per Bar being set to Yes . Troubleshooting In order to troubleshoot a problem with ignored signals, we recommend setting both of the Signal Only On Bar Close Inputs to No . Detailed logging can also be enabled which will add reasons for ignored signals in all cases . to the Trade gtgt Trade Service Log . When using the Spreadsheet System for Trading study, set the Enhanced Auto Trade Signal Related Logging Input to Yes . When using the Spreadsheet SystemAlert study, set the Enhanced System Signal Related Logging Input to Yes . Only set these Inputs to Yes when absolutely necessary because they will add a very large number of messages to the Trade Service Log and can cause Sierra Chart to be nonresponsive at times. SystemAlerts and Draw Style In the case of the Spreadsheet SystemAlert study, if the Draw Style for a Spreadsheet column is set to Ignore . then System or Alert signals in that column will be ignored. Nonzero Trade Position Quantity In the case of the Buy Exit or Sell Exit Order Action columns when using the Spreadsheet System for Trading study, if a BuySell Exit formula is TRUE and remains TRUE before there is a nonzero Trade Position Quantity and then a nonzero Trade Position Quantity later exists, then the Exit will be ignored it until it goes back to FALSE and then to TRUE. Therefore, you need to program the formula to remain FALSE until there is a Trade Position Quantity. This can be done by using the AND function and checking that cell J5 is nonzero. Delayed TRUE Result from Formulas Another thing to also consider is that you may see an arrow on the chart from one of the Order Action formula column cells indicating TRUE, but it is on the bar prior to the last bar in the chart and it appeared after a new bar was added to the chart. Therefore, unless the corresponding Signal Only On Bar Close Input is set to Yes, then that TRUE result going to be ignored as well. You cannot make an assumption that when you see a 1TRUE in a cell, that at the moment the cell is evaluated for an orderalert signal that the 1TRUE was present at that time. It may have been 0 and could have went to 1 quickly after. Spreadsheet System for Trading Test Procedure To get an understanding of how the TRUE signals in K3, L3, M3, N3 are processed follow the test procedures on the Spreadsheet System for Trading Test Procedure page. After you go through this test procedure, and you are still having difficulty troubleshooting your Spreadsheet System for Trading study implementation, we recommend changing the formulas to simple TRUE1 values temporarily during a replay just like explained in the test procedure, and then gradually add to the complexity of them until you can determine the source of the problem. Disappearing Arrows or Signals When using either the Spreadsheet System for Trading study or the Spreadsheet SystemAlert study, when a formula in a cell in one of the Spreadsheet columns that is graphed on the chart, typically this is going to be Spreadsheet columns K, L, M, N, returns a nonzero or TRUE value, you will see an arrow on the corresponding bar on the chart representing the TRUE condition. You also need to make certain that the Draw Style for the particular Spreadsheet formula column you want to see arrows for, is set to one of the Arrow UpDownLeftRight Draw Styles or other similar style. These TRUE formula signals can trigger an Alert Sound as well and also a Trade signal (in the case of the Spreadsheet System for Trading study) if these signals are given in row 3, or row 4 if have set the study Input Signal Only On Bar Close (Columns K, M)(Columns L, N-Z) to Yes . If the formula no longer is returning a nonzero or TRUE value and instead returning FALSE (0), then the arrow will disappear even though the Alert and the Trade signal was previously given. So it is important to understand that your formula could go to TRUE momentarily and then FALSE. In summary, the standard Up and Down arrows on a chart displayed by these Spreadsheet studies, indicate the present state of the formulas. During the formation of a bar or after new bars are added to the chart, a formula could go from TRUE to FALSE based upon the logic of the formula and changing data in the cells that it references. It is up to you to determine specifically what is happening and why. To actually see where the trades were made, you need to display Order Fills on the chart. If you are using the Spreadsheet System for Trading study and you wish to visibly see where trades have been made on the chart in the case of when the arrows on the chart disappear, then enable Trade gtgt Show Order Fills . Various options affecting the display of order fills can be set by enabling Trade gtgt Chart Trade Settings on the menu. When a cell that can trigger an Alert Sound or Trade signal becomes TRUE and an Alert Sound andor a Trade signal is actually given, then an alert message will be added to the Window gtgt ShowHide Alerts Manager gtgt Alerts Log . All of these events are logged in the Alerts Log tab. Not only can you experience the condition where the arrows disappear, you could also have the condition where the state of your formulas change, based upon how they are programmed and the data they are referencing, and you see an arrow later appear on a bar where a signal was not previously given when it was evaluated for an alert or trade signal. You may also see that the arrow direction does not correspond to an order fill displayed on a bar due to changes with the formula results during processing of a bar. For example, initially a bar may have given a Buy signal, a Buy fill is displayed on the chart for the bar, but then later the bar gives a Sell signal which is ignored based upon the auto trade logic. So at the present moment you see a Down Arrow, but a Buy fill for the bar. In order to create more stability when it comes to generating orders when using the Spreadsheet System for Trading study, you may want to set the Signal Only On Bar Close (Columns K, M) (Columns L, N-Z) input to Yes. All of what is described in this section is something that you need to be aware of when you are looking at the final results of your trading system and comparing them to the current FALSETRUE state of the Spreadsheet formulas that you visually see at the present moment. The Effect of the Number of Rows Input The Number of Rows input with the Spreadsheet studies, affects the standard Up and Down arrows displayed on a chart by the Spreadsheet studies. You will need to increase this input value to see arrows going back more bars. Arrows that were placed on bars further back than the Number of Rows input during real-time updating and chart replays, can disappear, or if they have not been removed because there has not been a full recalculation of the study, they may no longer be valid. Special Spreadsheet Outputted Values The Spreadsheet studies will output additional values in the I and J Spreadsheet columns for information and calculation purposes. This is in addition to the main price graph data outputted to columns A through G and the study data outputted beginning at column AA. The following is a list of all the additional values that are outputted. Special Spreadsheet System for Trading Values These values are outputted for the Spreadsheet System for Trading study only. These values can be used in Spreadsheet formulas. Below is a description of what each Row means. Working Orders Quantity Cell J3 This is the combined quantity for all the Working orders for the chart symbol. This is positive for Buy orders and negative for Sell orders. If there is one Buy working order with a quantity of 5, it will be 5. If there is one Buy order and one Sell order, each with the same quantity, it will be 0. Position with Working Orders Quantity Cell J4 This is the Position quantity combined with the quantities from Working orders. BuyEntry and SellEntry depend on this number to determine whether or not another entry should be allowed. For more information, refer to Trade Positions. Position Quantity Cell J5 or J8 Cells J5 and J8 contain the Quantity of the current Trade Position for the chart symbol. This Quantity can either be a quantity from the Trade Simulation Mode system or the quantity from the external trading service. This depends upon whether the Spreadsheet System for Trading study is in Simulation Mode or not. For instructions to control this, refer to Going From Simulated Trading to Non-Simulated (Live) Trading . This value can be negative (a Short quantity) or positive (a Long quantity). Both of these cells, J5 or J8, contain the same Position data and either one can be used. In the case of a Trade Position Quantity when in Trade Simulation Mode, for information about how that is determined, refer to Simulated Trade Positions. For information about non-simulated Trade Positions, refer to Trade Positions Tab. Position with Working Exit Orders Quantity Cell J6 This is the Position quantity for the symbol combined with the quantity of working orders that can potentially exit the current Position. Therefore, if the Position quantity is 5 and there is a Sell order with a quantity of 4, this will be 1. For more information, refer to Trade Positions . Prior Position Quantity Cell J7 The Prior Position Quantity cell indicates the Position Quantity right before a new order fill is processed. If a trade order fills with multiple fills, then this field will be updated for each of those fills. Prior Position Quantity is calculated using the available order fill data in the Trade gtgt Trade Activity Log gtgt Trade Activity tab for the symbol. The Global Settings gtgt General Trade Settings gtgt Number of Days to Save in Trade Activity Log controls how many days of data are saved in the log. You may need to adjust that to meet your requirements. Position Average Price Cell J9 This is the average of the fill prices of the currently open Trade Position for the Symbol and Trade Account the chart is set to. For more information, refer to Trade Positions . Open ProfitLoss Cell J10 This is the profit or loss of the currently open Trade Position for the Symbol and Trade Account the chart is set to. For more information, refer to Trade Positions . This value is outputted as a Currency Value. Refer to Position ProfitLoss for the calculation method for Currency Value . Cumulative Closed ProfitLoss Cell J11 This is the profit or loss of the closed out trades for the Symbol and Trade Account the chart is set to and is based upon the available order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . This value is outputted as a Currency Value. Refer to Position ProfitLoss for the calculation method for Currency Value . If the order fills from Trades made, are not available in the Trade Activity Log, then the Cumulative Closed ProfitLoss value will not consider those trades. The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . To reset this value, you will need to clear the order fill data from the Trade Activity Log for the Symbol and Trade Account. For instructions to do this, refer to Clearing Trade Activity Log. The order fill data for replays and back tests, when you initiate a replay or back test will be automatically cleared. At that time you will receive a prompt to clear this data. When you press Yes, the data will be automatically cleared and therefore the Cumulative Closed ProfitLoss will be reset back to 0. Maximum Open Position Profit Cell J31 The Maximum Open Position Profit is what the maximum profit of the current Position has been. This is reset whenever the Position Quantity changes. For more information, refer to Trade Positions . Maximum Open Position Loss Cell J32 The Maximum Open Position Loss is what the maximum loss of the current Position has been. This is reset whenever the Position Quantity changes. For more information, refer to Trade Positions . Win Trades Cell J33 The total number of winning trades based upon the available fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . A winning trade is defined as a trade that reduces or closes out a Position while the Open ProfitLoss is positive or flat. The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . Lose Trades Cell J34 The total number of losing trades based upon the available fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . A losing trade is defined as a trade that reduces or closes out a Position while the Open ProfitLoss is negative. The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . Total Trades Cell J35 The total number of closed trades based upon the available fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . A trade is defined as a trade that reduces or closes out a Position. This is going to be an individual fill. Not necessarily an entire order. The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . Seconds Per Bar - Intraday (read-only) Cell J36 This cell contains the number of seconds that the chart bars are set to ( Chartgtgt Chart Settings ). This will always be a nonzero number. Even when one of the Number of Trades Per Bar, Volume Per Bar, Range Per Bar cells are nonzero. Number of Trades Per Bar - Intraday (read-only) Cell J37 The cell contains the number of trades per bar setting in Chartgtgt Chart Settings . It will be zero if the chart bars are not set to be based upon a number of trades. Volume Per Bar - Intraday (read-only) Cell J38 The cell contains the volume per bar setting in Chartgtgt Chart Settings . It will be zero if the chart bars are not set to be based upon a specified volume. Range Per Bar (in ticks) - Intraday (read-only) Cell J39 The cell contains the range per bar setting in Chartgtgt Chart Settings . It will be zero if the chart bars are not set to be based upon a specified price range. Symbol Cell J40 The cell contains the symbol of the chart. In the case where a Trade and Current Quote Symbol is set on the chart, that symbol will be returned. Last Bar End DateTime Cell J41 This cell contains the latest date and time of the last bar in the chart in a Serial DateTime format. This number can be used for various comparisons within formulas that are based on times. To ensure you see this value formatted as a Date-Time, right-click on the cell and select Number Format from the menu or Spreadsheet gtgt Number Format . Change the Number Format to Date-Time . This cell data is outputted with all of the Spreadsheet studies. Last Entry Trade Date-Time Cell J42 This cell displays a number that represents the Date and Time of the bar at which the last Entry trade was triggered and processed. This number can be used for various comparisons within formulas that are based on times. This data is maintained by the internal Trades list in the chart. Last Exit Trade Date-Time Cell J43 This cell displays a number that represents the Date and Time of the bar at which the last Exit trade was triggered and processed. This number can be used for various comparisons within formulas that are based on times. This data is maintained by the internal Trades list in the chart. Last Trade ProfitLoss Cell J44 This is the Profit or Loss of the last completed trade for the symbol. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . Closed Daily ProfitLoss Cell J45 This is the Profit or Loss of Trades made that have been closed during the day for the symbol. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default it resets at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . Trade Service Account Balance Cell J47 This is the current cash balance for the selected Trade Account on the Trade Window for the chart when not in Trade Simulation Mode. This data is from the external connected Trading service. Not all Trading services provide this data. This is not a simulated account balance. To select the Trade Account on the Trade Window for the chart, refer to Selecting Trade Account . Last Entry Fill Price Cell J48 This cell displays the fill price of the order for the last Entry trade. If your trading system is in simulation mode, then this data is from a simulated order. Otherwise, it is from a non-simulated order. This data is maintained by the internal Trades list in the chart. Last Exit Fill Price Cell J49 This cell displays the fill price of the order for the last Exit trade. If your trading system is in simulation mode, then this data is from a simulated order. Otherwise, it is from a non-simulated order. This data is maintained by the internal Trades list in the chart. Daily Win Trades Cell J50 This the number of trades that have completed and had a profit or were breakeven during the trading day. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default this field reset at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . Daily Lose Trades Cell J51 This the number of trades that have completed and had a loss during the trading day. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default this field resets at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . Daily Total Trades Cell J52 This the number of Trades that have completed during the trading day. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default this field resets at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . This field can be used to limit the number of automated trades during the trading day. For example, in the Disable Auto Trading (J28) cell, enter the following: J52 1. This will limit your automated trading to 1 trade per day. Daily Total Quantity Filled Cell J53 This is the total quantity of the order fill quantities for the trading day. For example, if you have a buy order fill during the trading day of quantity 5 and a sell order fill of quantity 5, then this will be 10, assuming these are the only 2 fills during the trading day. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default this field resets at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . Daily Number of Long Trades Cell J54 This the number of Long Trades that have completed during the trading day. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default this field resets at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . Daily Number of Short Trades Cell J55 This the number of Short Trades that have completed during the trading day. This uses a Fill to Fill order fill grouping method for Trades. This is calculated from the order fill data in Trade gtgt Trade Activity Log gtgt Trade Activity . The number of days saved in the Trade Activity Log is set through Global Settings gtgt General Trade Settings . By default this field resets at midnight according to the Time Zone setting in Sierra Chart. The reset time can be changed through Global Settings gtgt General Trade Settings gtgt Daily Stats Reset Time . Current Quote Values Cells J12 through J20 Cells J12 through J20 display the Current Quote Values for the chart symbol. These are always displayed on the Spreadsheet used by the Spreadsheet System for Trading study, and will only be displayed if the Output Current Quote Data input is set to Yes for the other Spreadsheet studies. The Daily Open, Daily High, Daily Low, Daily Net (Daily Price Change), and Daily Volume are only going to be set when connected to the data feed ( File gtgt Connect to Data Feed ) and the associated chart is not replaying. Otherwise, they will be 0. The data that you see is the same data displayed in Window gtgt Current Quote Window . The Current Quote Window contains the daily quote data for the symbol of the active chart. Tick Size Cell J21 This cell contains the Tick Size of the symbol. This is the minimum increment that the symbol trades in. This data is outputted for all of the Spreadsheet studies. Special Spreadsheet Trading Inputs on the Spreadsheet The following is a list of special Spreadsheet inputs in columns I and J used by the Spreadsheet System for Trading study. These are actual inputs that will use the values you type into the corresponding row in the J column. Limit or Stop Prices J22, J23, J24, J25 Cells J22 through J25 allow you to set the Limit or Stop order prices for each of the 4 different Spreadsheet Order Actions. These apply when you have set to use a Limit or Stop order for a particular Order Action in cells J71 through J74. Refer to Buy Entry: Order Type J71. You are able to set a Limit or Stop price to either the Bid or Ask prices by using these formulas: J12 (Bid price) or J14 (Ask Price). This allows you to buy at the Bid or sell at the Ask respectively. Order Quantity J26 Cell J26 controls the Order Quantity for orders that are submitted from the Spreadsheet System for Trading study. This quantity can be dynamically controlled by a formula. If the cell is empty or 0, the Order Quantity will be set to 1 for Buy Entry and Sell Entry . If the cell is empty or 0 during a Buy Exit or Sell Exit . then the quantity is determined by the automated trading logic and the end result will be that the Trade Position for the Symbol and Trade Account is flattened. Negative order quantities are converted to positive numbers. Use Separate Exit Order Quantity J82 When this cell is set to TRUE or a nonzero value, then a Buy Exit or Sell Exit Order Action will use the quantity specified by the Exit Order Quantity J83 cell. Exit Order Quantity J83 This cell is only used when Use Separate Exit Order Quantity J82 is set to TRUE or a nonzero value. This cell controls the Order Quantity for Buy Exit or Sell Exit Order Actions from the Spreadsheet System for Trading study. This quantity can be dynamically controlled by a formula. If the cell is empty or 0 during a Buy Exit or Sell Exit . then the quantity is determined by the automated trading logic and the end result is that the Trade Position for the Symbol and Trade Account the automated trading system is for will be flattened. Negative order quantities are converted to positive numbers. Maximum Chase Amount for Limit Chase Orders Cell J46 This cell is used to specify the maximum chase amount for limit chase orders. For more information, refer to the Use Chase Orders input. Cancel Working Orders J27 Cell J27 allows you to cancel all working orders for the Symbol and Trade Account of the chart that the Spreadsheet System for Trading study is currently applied to. Setting this cell to TRUE or any non-zero number (such as 1 ) will trigger the canceling of orders. You can also input a formula into this cell to cancel all working orders when certain conditions are met. The canceling of orders occurs before any of the Entry and Exit signal cells are evaluated. However, these cancellations in the case of non-simulated trading do take time to occur and they will be pending during the evaluation of the Entry and Exit signal cells. When this cell is set to a nonzero or TRUE value, additional cancellations will not occur until it is set back to zero or FALSE and then back to a nonzero or TRUE value. If you wish to cancel working orders at a specific time, then you can use a formula like this: (J41-INT(J41)) gt TIMEVALUE(16:15:00). This example will return TRUE when the time is 16:15 or greater. Cell J41 is the latest time in the last bar in the chart. It is best to use that cell, since NOW() always refers to the current time, and that will not work during back testing. Cancel All Orders except working Attached Orders J78 Cell J78 allows you to cancel all working orders except for working Attached Orders for the Symbol and Trade Account of the chart that the Spreadsheet System for Trading study is currently applied to. Attached Orders that have a Pending Child - ClientServer status will still be canceled. Only Attached Orders that have an OpenPending OpenPending Modify status will not be canceled. Setting this cell to TRUE or any non-zero number (such as 1 ) will trigger the canceling of orders. You can also input a formula into this cell to cancel all working orders when certain conditions are met. The canceling of orders occurs before any of the Entry and Exit signal cells are evaluated. However, these cancellations in the case of non-simulated trading do take time to occur and they will be pending during the evaluation of the Entry and Exit signal cells. When this cell is set to a nonzero or TRUE value, additional cancellations will not occur until it is set back to zero or FALSE and then back to a nonzero or TRUE value. Flatten Position and Cancel Working Orders J29 Cell J29 flattens the existing Trade Position that the Spreadsheet System for Trading study is reporting on the Sheet. So this will be for the Symbol and Trade Account that the chart is set to. All Working orders will also be canceled for the symbol and Trade Account. Simply setting this cell to TRUE or any non-zero number (such as 1 ) will trigger the flattening of the Position and canceling of orders. You can also input a formula here to perform the action when certain conditions are met. The flattening of the Position and canceling of orders occurs before any of the Entry and Exit signal cells are evaluated. When this cell is set to a nonzero or TRUE value, additional flattening of the Position and canceling of orders will not occur until it is set back to zero or FALSE and then back to a nonzero or TRUE value. If you want to flatten the Trade Position and cancel working orders at a specific time, then you can use a formula like this: (J41-INT(J41)) gt TIMEVALUE(16:15:00). This example will return TRUE when the time is 16:15 or greater. Cell J41 is the latest time in the last bar in the chart. It is best to use that cell, since NOW() always refers to the current time, and that will not work during back testing. Disable Auto Trading J28 When Cell J28 is set to TRUE it disables all trading from the Spreadsheet. When this cell is set to TRUE . all Spreadsheet BuySell entries and exits, flatten Position and cancel order commands are ignored . However, if this cell is set to TRUE at the same time that a cell like Flatten Position and Cancel Working Orders is set to TRUE, then the Flatten Position and Cancel Working Orders action will still occur and then automated trading will be disabled after that. This paragraph applies to versions 1463 and higher. You can enter a formula in this cell to disable trading when certain conditions are met or even when the latest Date-Time of the last bar in the chart meets some specified time condition. Manually setting this input to TRUE or any non-zero number will simply disable all auto trading until the cell is set back to FALSE . If you want to disable automated trading at a specific time, then you can use a formula like this: (J41-INT(J41)) gt TIMEVALUE(16:15:00). This example returns TRUE when the time is 16:15 or greater. Cell J41 is the latest time in the last bar in the chart. It is best to use that cell, since NOW() always refers to the current time, and that will not work during back testing. For documentation for the particular Spreadsheet functions used, refer to Spreadsheet Functions . To limit trading to the day session only, use this formula: OR(J41-INT(J41) lt TIMEVALUE(09:30:00), J41-INT(J41) gt TIMEVALUE(16:00:00) ). This formula assumes your time zone in Sierra Chart is set to New York, and the symbol of the chart is a stock or stock index. Buy Entry: Order Type J71 This Spreadsheet input is for specifying the order type for the Buy Entry Order Action column. The corresponding Limit or Stop price is set in cell J22 . If the Limit or Stop price cell is set to 0 or is blank, then the Limit or Stop price will be set to the current Ask price. If the Order Type is blank, it will be set to M (Market). The order type can be programmatically set with a formula. Here is an example: IF(J5 0, L, M). Buy Exit: Order Type J72 This Spreadsheet input is for specifying the order type for the Buy Exit Order Action column. The corresponding Limit or Stop price is set in cell J23 . If the Limit or Stop price cell is set to 0 or is blank, then the Limit or Stop price will be set to the current Bid price. If the Order Type is blank, it will be set to M (Market). The order type can be programmatically set with a formula. Here is an example: IF(J5 0, L, M). Sell Entry: Order Type J73 This Spreadsheet input is for specifying the order type for the Sell Entry Order Action column. The corresponding Limit or Stop price is set in cell J24 . If the Limit or Stop price cell is set to 0 or is blank, then the Limit or Stop price will be set to the current Bid price. If the Order Type is blank, it will be set to M (Market). The order type can be programmatically set with a formula. Here is an example: IF(J5 0, L, M). Sell Exit: Order Type J74 This Spreadsheet input is for specifying the order type for the Sell Exit Order Action column. The corresponding Limit or Stop price is set in cell J25 . If the Limit or Stop price cell is set to 0 or is blank, then the Limit or Stop price will be set to the current Ask price. If the Order Type is blank, it will be set to M (Market). The order type can be programmatically set with a formula. Here is an example: IF(J5 0, L, M). Attached Order Target Offset (write only) J80 When this is set to a nonzero value, this will replace any existing defined Attached Orders on the Trade Window for the chart with a Target Limit order with the Offset specified in this cell. The purpose of using a Spreadsheet cell to set the Target Attached Order Offset is so that it can be set according to a formula rather than hardcoded at a particular value on the Trade Window for the chart. The Offset is relative to the parent order price. This Offset needs to be specified as an actual price value . If a Stop order is also set through cell J81 . then this will be added to the Attached Orders at the same time as well. For more information, refer to Attached Orders . For the Attached Orders to actually be used when submitting a BuySell Entry order, the Use Attached Orders option needs to be enabled on the Trade Window for the chart. Attached Order Stop Offset (write only) J81 When this is set to a nonzero value, this will replace any existing defined Attached Orders on the Trade Window for the chart with a Stop order with the Offset specified in this cell. The purpose of using a Spreadsheet cell to set the Stop Attached Order Offset is so that it can be set according to a formula rather than hardcoded at a particular value on the Trade Window for the chart. The Offset is relative to the parent order price. This Offset needs to be specified as an actual price value . If a Target order is also set through cell J80 . then this will be added to the Attached Orders at the same time as well. For more information, refer to Attached Orders . For the Attached Orders to actually be used when submitting a BuySell Entry order, the Use Attached Orders option needs to be enabled on the Trade Window for the chart. Working Orders Exist (read-only) J84 This is set to TRUE when there are orders which currently have a Status indicating they are working and can be filled. This also includes Pending Child orders. Otherwise, this is set to FALSE. This cell is read-only. Allow Trading Only During Time Range (readwrite) J85 This can be set to TRUE to only allow automated trading by the Spreadsheet System for Trading study during the time range specified in the Start Time For Allowed Time Range and End Time For Allowed Time Range cells. Start Time For Allowed Time Range (readwrite) J86 When the Allow Trading Only During Time Range cell has been set to TRUE, then this cell specifies the starting time in the charts time zone that automated trading is allowed to begin at. End Time For Allowed Time Range (readwrite) J87 When the Allow Trading Only During Time Range cell has been set to TRUE, then this cell specifies the ending time in the charts time zone that automated trading will no longer be allowed after. Flatten Positions And Cancel Orders At Set Time (readwrite) J88 When this cell is set to TRUE, then the current Trade Position will be flattened and any working Orders will be canceled for the Symbol and Trade Account of the chart the Spreadsheet System for Trading study is applied to, at the time specified by the Time For Flatten Positions And Cancel Orders cell. Time For Flatten Positions And Cancel Orders (readwrite) J89 When the Flatten Positions And Cancel Orders At Set Time cell is set to TRUE, then this cell specifies the time to flatten the Trade Position and cancel the Orders at. Last EntryExit Order Date-Time (read-only) J90 This is the Date-Time in the charts time zone, of the last entry or exit order which was submitted whether it has filled or not. This is useful to use in formulas to determine the amount of time elapsed since an order was submitted and it has not yet filled. Back Testing Spreadsheet Calculations and Spreadsheet Study Processing of Spreadsheet Data This section describes the calculations of formulas on a Sheet in a Spreadsheet window and the subsequent reading and processing of values and formula results from a particular Sheet being referenced by one of the Spreadsheet studies. There is a difference between these two operations and this needs to be understood. The general method by which a Spreadsheet study interacts with a particular Sheet in a Spreadsheet window (also known as a Sheet Collection), is that first the chart data and study values are outputted to the Sheet, the Sheet is calculated, and then the Spreadsheet study gets the results from the formula columns K through Z (last formula column by default) and processes those results and puts them into internal chart arrays for graphing on the chart. In the case of the Spreadsheet System for Trading study, if there is a full recalculation of the chart, the Sheet will be updated and calculated, however there will not be processing of any of the Sheet formula columns during that full recalculation, by the Spreadsheet System for Trading study. A full recalculation will occur when the chart is opened as part of its Chartbook opening, studies are modified through the Chart Studies window, or if the chart has been tagged for a full recalculation by a chart it is referencing. This last case is not a common case. After a full recalculation occurs, it is normal for the last bar in the chart to be calculated again. At this time it is normal for any of the Spreadsheet studies to process the formula columns for the last bar in the Sheet. In the case of the Spreadsheet System for Trading study, if 100 or more bars are added at once to the chart when the chart is updated, then there will not be processing of the Sheet formula columns. This kind of event will be indicated in the Trade gtgt Trade Service Log when it happens. The below sections explain how the K through Z formula columns that contain formula results are processed based on the Signal Only on Bar Close inputs. There are two of these inputs and this section applies to both of them. For example, if you use the Signal Only on Bar Close (Columns K, M) input, then this description would apply to columns K and M . The time at which formula results are processed by any of the Spreadsheet studies is after all the Sheets within the Spreadsheet have been calculated and all cells are reporting their current values. If Signal Only on Bar Close is set to No . then the following occurs: If there are no new bars added to the chart during a chart update, then only Sheet row 3 is checked for TRUEFALSE values that are returned by formulas in the Spreadsheet signal columns (K-Z). If there are new bars added to the chart during a chart update, then the first row in the Sheet that is examined for TRUEFALSE values that are returned by the formulas, is the previous topmost row during the prior update (the data previously at row 3). The reason the previous topmost row is examined, is because there could be changes with the price data and studies at that row during the chart update. In other words, the examination continues where it left off. Next, the Spreadsheet study processing function moves up the rows all the way up to 3, examining for TRUEFALSE conditions row by row. For example, if there is one new bar added, then first row 4 is examined and then row 3 is examined for TRUEFALSE conditions. One potential issue to be aware of with this processing logic is that if a formula in a particular column is TRUE at row 3 and then a new bar is added and it becomes FALSE at row 4, then the internal state maintained by Sierra Chart for the Spreadsheet column goes to FALSE and can then go back to TRUE if the formula is TRUE at row 3 during that update. The potential issue with this is an unexpected signal due to a state change. If Signal Only on Bar Close is set to Yes . then the following occurs: If there are no new bars added to the chart during a chart update, then only Sheet row 4 is checked for TRUEFALSE values that are returned by formulas in the Spreadsheet signal columns (K-Z). If there are new bars added to the chart during a chart update, then the first row in the Sheet that is examined for TRUEFALSE values that are returned by the formulas, is the previous second topmost row during the prior update (the data previously at row 4). The reason the previous second topmost row is examined, is because there could be changes with the price data and studies at that row during the chart update. Although, usually not in this case since the data was previously at row 4. In other words, the examination continues where it left off. Next, the Spreadsheet study processing function moves up the rows all the way up to 4, examining for TRUEFALSE conditions row by row. For example, if there is one new bar added, then first row 5 is examined and then row 4 is examined for TRUEFALSE conditions. One potential issue to be aware of with this processing logic is that if a formula in a particular column is TRUE at row 4 and then a new bar is added and it becomes FALSE at row 5, then the internal state maintained by Sierra Chart for the Spreadsheet column goes to FALSE and can then go back to TRUE if the formula is TRUE at row 4 during that update. The potential issue with this is an unexpected signal due to a state change. Although, this kind of scenario is highly unlikely with Signal Only on Bar Close set to Yes because data other than at the last bar in the chart is not likely to change. Order of Formula Column Processing and Internal Calculation Order When the formula results in columns K through Z (last formula column by default) are processed for Trade Order or Alert signals by the Spreadsheet System for Trading or Spreadsheet SystemAlert studies, column K is evaluated first, then L, then M, and so on through and including the last formula column (by default column Z). The last formula column is set by the Number of Formula Columns Input. Therefore in the case of the Spreadsheet System for Trading study, the following columns are evaluated in the order in which they are listed left to right: Buy Entry, Buy Exit, Sell Entry, Sell Exit . The order of calculation for the formulas in cells within a Spreadsheet is based upon the dependency they have to each other. A cell dependent on another cell is always going to be calculated after the cell it is dependent on. In the case where 2 cells refer to each other, this is known as a circular reference. In the version of Sierra Chart with New Spreadsheets, there is no special handling of a circular reference, the result can be unpredictable, and an error may be given. Circular references are not supported as they simply make no mathematical sense and have an absolute impossibility to resolve accurately. Multiple Exit Automated Trading Example This is an example of an automated trading exit which utilizes two targets. This example applies to the Spreadsheet System for Trading study. A stop is not used in this example. There are three formulas involved in this strategy and they are used in the following cells: Buy Exit, Sell Exit, and Custom Order Quantity. In this example, these formulas set a price target of 3 points and 5 points away from the Position Average Price (Cell J9 ). It is assumed that there is a Position quantity of 5. For the first target, two contracts will be exited. For the second target, three contracts will be exited. Order Quantity Formula (Cell J26 ): IF( ABS(J8) 5, 2, IF( ABS(J8) 3, 3, 0)) . Buy Exit Formula (Cell L3): OR( AND( J8 5, ID0.SG43 - J9 gt 3), AND( J8 3, ID0.SG43 - J9 5)) Sell Exit Formula (Cell N3): OR( AND( J8 -5, J9 - ID0.SG43 gt 3), AND( J8 -3, J9-ID0.SG43 gt 5)) This is merely a simple example and this will need to be tested and modified to be certain it will work for you. Limiting Trading to Certain Time Ranges This section uses the GETTIMEFROMDATETIMEVALUE function which is going to be available in an upcoming release at the time of this writing. To restrict trading during only a certain time range, you can use the Disable Auto Trading cell. Here is an example formula to limit trading during a specific time range: AND((GETTIMEFROMDATETIMEVALUE(J41)) gt TIME(9,30,0), GETTIMEFROMDATETIMEVALUE(J41) lt TIME(16,15,0)). J41 contains the Last Bar End DateTime . Or this formula could be combined into a Buy Entry and Sell Entry formula by using the AND function. Last modified Wednesday, 25th January, 2017.Send in a Review of your TJS experience What some of our 8,000 users are saying about the Trading Journal Spreadsheet You can find the TJS being used in the following 97 countries . Read how an Amazon customer came across a trading book by internationally known author and president of the Van Tharp Institute, after using his new TJS spreadsheet. Duncan 8220Sailor Dunc8221 McLean 8230 CANADA 8220What an excellent product8230 As someone who has been trading for over 10-years now, I have to say that this is the best value for money trading spreadsheet that I8217ve come across. I really love the Expectancy Formulator. That page is addictive. You really should raise the price. 8221 Lance reviews one of the first TJS versions (from 2008) on YouTube 8230 while discussing the importance of trade journaling8221. As an elite swimmer, I8217m a true believer in documenting my results. It is my firm belief that in order to achieve success, one not only needs to spend many hours training and becoming expert in their field but they also need to be extremely metric drivendetail oriented. 8212 You bring in all the necessary tools to help us navigate through our own trading emotions. You have unequivocally developed the best trade tracking analysis tool and I am confident that traders looking to increase their overall performance and forecasting should use TJS8221. Randall Bal, Olympic swimmer8230 USA Every professional athlete I know uses a training log as a tool for documenting their development and the ability to spot the areas where adjustment is needed according to a preset goal for the sport he is performing. If not the athlete will be in total darkness when it comes to a structural mindset for reaching the short term and long term goals. The same is with any successful company, have a strategy and a plan, to periodically check if you are in-line with your strategy and target. My development from not being a consistently profitable trader to the trading level I have achieved is because of three factors: Pro Mentorship, a Trading Plan (that is respected and followed), and extensive use of the Trading Journal Spreadsheet. The Trading Journal provided by Trading Journal Spreadsheet is the best software I could find after thorough research. It has all the needed contents for blending together: planning, scenario models, and journaling all in detail. It is a low user threshold and excellent service that makes it my most precious tool (aside from my Trading Plan). I guarantee that everyone that combines and commits to a Trading Plan and this Trading Journal Spreadsheet tool will make huge leaps in performance after only a short period.8221 Click to read moregtgt Close Pl-Harald Uthus , Chief Market Analyst at, nor Securities8230 NORWAY 8220Thank you Greg and TradingSpreadsheets for putting together one of the best Trading Journals I have had the pleasure of using in over 10 years trading. In the L2ST Live Trading Room we utilize the Trading Journal to record our daily trades and record our results for specific L2ST setups and Markets. With a quick glance you can highlight what trades are working best for a particular market and easily make that your major focus for higher probability trading. There are so many great features to your journal, myself and our trading room members are enjoying the benefits where it counts, the bottom line 8211 PROFIT8221 Kam Dhadwar at L2ST. co. uk 8230 UNITED KINGDOM 8220This is by far the best trading journalspreadsheet I have seen. I have been trading since 2000 and have been a trading educator since 2008. I stress over and over to my students the importance of keeping a good trading record with as many details as possible so they can go back and analyze where the strong points and weak points are in their trading. This spreadsheet does it all for you. No longer will you have to thumb backwards through your hand written journal or scroll back in your hand made Excel spreadsheets, this product will track and analyze everything you want and need. I have recommended this product to my students and I don8217t ever do that. This is money well spent8221 It not only allows for the standard tracking information that can help you evaluate your performance, it also has features for forecasting what if scenarios. This can increase your confidence in using leverage, and help pinpoint under which conditions to use it. I highly recommend it.8221 Ed Abreu (ProTrader Ed) at Jaguar Traders 8230 New York, USA 8220I would like to take a moment to thank you, I mean REALLY thank you. This is a great product for ANY trader. I am a Forex trader actively trading on 3 or more time frames every day. This product allows me to easily analyze the results from each time frame in an instant, and the Expectancy tool is exceptional. I am also a trader coach, and above all else, we stress to traders the importance of consistency8230 this product allows a trader to easily enter all of the information related to any given trade, and track the results in real time which aids in error correction and quickly identifies where a trader is consistent8230 good or bad. Kudos Colin Jessup, Forex coach 8230 CANADA 8220I can8217t say enough good things about it, how I8217ve used it, and how it8217s helped me. Thank you for creating such a terrific product 8220 Michael is the founder of ChartYourTrade, and has taken the time to write a very comprehensive review of the Trading Journal Spreadsheet . Michael Lamothe, founder of ChartYourTrade 8230 New York, USA 8220Developing the correct mindset for trading can be one of the toughest aspects of learning how to trade options. If you want to improve your trading by analyzing, planning and placing your trades better, then the Trading Journal Spreadsheet is a great tool to compile and analyze all your data in a single space.8221 Patrick provides an in-depth review of the Trading Journal Spreadsheet at the Naked Options Trader. his site on learning options trading. Patrick Smith, author of the Naked Options Trader 8230 Texas, USA 8220I appreciate your time and work that went in to creating this spreadsheet It truly is an exceptional value I am not a savvy Excel user, though I can navigate through this product with ease It8217s an outstanding resource for optimization of one8217s strategymethodology. Furthermore, the customer service and support is impeccable Angela Heil, Forex Trader 8230 USA 8220Hi everyone8230 I just wanted to pass on some information about a really great trade log made by Greg at TradingSpreadsheets. I had just finished creating a database that I was quite happy with but someone suggested I look at that site. When I did, I realized my database would never be able to provide the functionality already available in the spreadsheet. Anyway, I just wanted to pass along the recommendation. I8217ve copied Greg on this email if you have any questions. He8217s extremely helpful and responsive.8221 Kelly Knight-Pellas 8230 USA 8220This product will track my forex trades8230WOW8230I have been looking for a product that will do this. I had a few questions once I started to log my data and Greg was very prompt in helping me out8230Excellent customer service. 8221 Thomas Schafer 8230 USA 8220I have made several entries of stock purchases and it is very easy. When I first got the spreadsheet I was confused, However, I asked for help 8211 and I received immediate help 8211 the problem was resolved and now I am off and running. With this kind of help and assistance for a small price 8211 HOW CAN YOU GO WRONG.8221 Joseph Bendzinski 8230 USA 8220Hi Greg, I just wanted to write and thank you for the excellent spreadsheet you have developed, it has been a tremendous help in my trading. I have pinpointed exact changes that I needed to make, simply by examining the 8220tracking8221 sheet, and i8217ve seen exactly how to maximize my system itself. This spreadsheet is the best, most professional sheet I have ever seen or used, and I truly thank you for your excellent work in this. I have already promoted it on a trading forum and will continue to do so. Thank you again, Greg8221 Mike Cleveland, Forex Trader 8230 USA 8220Thanks Greg, for creating the ideal vehicle that makes the capture and accessibility of crucial learning and bad-habit correcting data so easy. This is quite simply the most effective and invaluable tool that I have ever encountered, for tracking trades and more importantly for helping one discover areas of concern and improvememt. Thanks also for the exemplary after-sale service and support. Your product is a winner and now I8217m beginning to feel I can become one too8221 Mike Ward. 8230 CANADA 8220Thank you Greg. Every now and again we can be lucky enough to part with our hard earned money and be happy about it. Not only are the spreadsheets you created excellent and easy to use, your customer service is top shelf. I am absolutely confident that this new tool that I have in my arsenal of trading weapons is going to pay for itself many times over. Thanks Mate.8221 Brendon Cordang 8230 AUSTRALIA 8220I was skeptical to using an Excel spreadsheet as a trading tool for tracking, reporting and progress, but after buying and using Greg8217s TJS, I am very happy with my choice. It is very comprehensive in terms of reporting and statistics, easy to use, and quick to learn. Greg does a great job in explaining everything in details in his website, and links to important tips and tricks are provided inside the spreadsheets. Now a few words about Greg8217s service, before and after purchasing the TJS: he was very kind and patient chatting live with me when I was deciding whether to purchase it. After purchase, the spreadsheet was delivered immediately via email, with all the necessary instructions. He answered all my questions I had immediately, and with the right solutions. Feel free to contact me with any questions. I wholeheartedly recommend Greg8217s spreadsheet8221 Skerdi Kostreci 8230 USA 8220All I can say is that I do not know how anyone could trade without Greg8217s trading journal. It shows you where you have an edge and where you do not. This includes many things such as what time of day you will have your best trades, what entry strategy works best, what exit strategy works best, and even what chart timeframe you take the best trades on. Greg has been most helpful and prompt to call me if needed. I would say that it was money well spent to improve my trading.8221 Jeff Horn 8230 USA 8220I think the TJS is excellent. I have been using it for some time. For a relatively small trading investment it will prove invaluable. It will show you what areas (strategies, TFs, pairs, etc) are profitable or non-profitable, and therefore allow you to address these. It is also a good psychological tool, in that, after any period of drawdown, you can review your journal and see that over a longer period of time your trade plan makes you money. Therefore, you can more easily regain your good trading mind-state (and not be paralysed to make decisions or make emotionally distorted bad ones). Also, having talked to Greg Thurman (the TJS8217s developer), I must say he provides very good support for this product. Highly recommended8221 Kevin Loughlin, Trader 8230 United Kingdom I was able to filter out the times where I wasn8217t profitable and cut the crap out.8221 PH. Caenen, Trader 8230 Belgium 8220Hi Greg, I wanted to drop you a note to congratulate you on your exceptional product. The visual aspects, functions, and layout are superb. I acquired both the Forex and Futures Spreadsheets which I have now mandated for use by our company. Our company paid a programmer to create a trade spreadsheet for internal use and the cost was 30 times more and does not compare to your trade spreadsheet. Your retail price point for your 8220Trading Spreadsheet8221 should be at least 3 to 5 times more than what you are charging. Thanks again Greg for the great product and keep up the outstanding work.8221 Scott Schaffer, Certified International Trade Advisor at Emitec2000 8220Very nice work: combines Elegance, Beauty, and Utility. That8217s a 3R win.8221 Dr. Ken Long, DM, MSSM, Tortoise Capital Mgt 8230 USA 8220Your spreadsheet is fantastic. I am using it to build up the slides we are doing for our trading plan and journal webcast. Just letting you know that you have a great program and to keep doing what you are doing.8221 Mike Arnold, Chief Strategy Officer at TopstepTrader 8230 USA 8220I have been using your product for a week now and have found it Excellent. It really brings the Van Tharp thinking together in a practical way. It has focused my trading in a way that none of my other applications has. I am very happy with it. Patrick Ryan8230 IRELAND 8220Hi, I8217m a big fan of your spreadsheet. Your product is great (to say the least) and it is very affordable and your response to customers (me) has been terrific, so I8217ve developed a high respect for you and your company.8221 Randy Riley 8230 USA 8220Very pleased with this product. I drifted from one home-made spreadsheet to another, but this is something much different, it8217s very comprehensive and I intend it to be the nerve centre of my trading business. Thanks very much Greg for sharing it. Any serious trader should have something like this. Bobby Fielding 8230 UK 8220I LOVE THE SOFTWARE. I put in all my 2011 trades and it8217s amazing to see all the analytics and statistics. It8217s already helped me revise my trading strategy.8221 Steve Miller 8230 USA 8220I have used many different trade tracking programs over the 20 years I8217ve been trading and have never seen anything as powerful, well designed and valuable to my trading as TJS. Thanks so much for your dedication to my success.8221 8220Hi Greg, I just purchased the trading worksheets you8217ve developed. I trade physical Natural Gas and physical Western Power markets8230I8217m very impressed that your sheets have the ability to easily integrate my markets (volume and size) to analyze my trading performance. This is simply incredible as physical power and gas markets can be ugly to track. I felt compelled to thank you I8217ve been a trader for about 8 years8230and all of the areassections (from execution to the psychological side) have been thought out SO well8230it8217s impressive. I8217m happy I8217ve stumbled upon this. Thank you very much for your hard work.8221 Jason Miller 8230 USA 8220Thanks Greg for a fantastic product This is by far the most important aspect of trading. Documenting your trades and trading behaviour will enable you to identify very quickly where you are going wrong and what you are doing right. Greg8217s spreadsheets have all you need to monitor your performance from which to develop your trading success.8221 Peter Jarvis at forexmind 8230 UK 8220Just want to say what a brilliant tool8230 I have limited use of Excel and this has saved me a whole lot of time trying to create something that frankly would not have stood up to this. A very valuable tool and easy to work through, some great work. Thanks for making this.8221 Bryan Wiggins 8230 UK Not only is the spreadsheet simply a good excel programming value for active traders but the trading philosophies evident in the particular measures you supplied to track were VERY influential on me Tharp analysis, position sizing, rewardrisk, expectancy, etc. I shudder to think what shape my trading account might be in a year later if I had not been inspired to get my brain around those ways of looking at ones experience and using the mathematics for decision making. There are lots of glossy little products and 8220courses8221 available on line 8211 your quiet little 8220spreadsheet8221 offering says it all and is hence GREAT value. Of course it hasn8217t saved me from periods of draw-downs but thanks to better risk management even these are more like water off a ducks back Duncan McLean 8230 CANADA 8220This spreadsheet offers all traders, novice and advanced, the opportunity to not only record all of your trades, which everyone knows is vital to success, but also the opportunity to learn from your trading style. You can quickly see which trades are more successful, and which ones tend not to work out. Overall, this is a fantastic product and definitely worth the investment8221 Keith Elliott 8230 USA 8220What can I say 8211 Should have had your spreadsheet years ago8230 Having all this data right in front of you is simply amazing. I kept a log in excel previously but it just didn8217t have this clarity and this no BS overview. I just love the way you can see which market strategy timeframe you make most of your money. I am sure that will show a few trends in a few months time.8221 Oliver Ockerlander 8230 AUSTRALIA 8220Greg, I would just like to say that your product is absolutely brilliant. I have been trading for over two years now and still consider myself a novice but I8217m getting there. Your product has proved to be a vital ingredient that has been missing for me. Everybody talks about strategies, psychology and getting your trading plan written up. Well I have to say an accurate measurement system is probably one of the most important ingredients of all. I actually paid someone over three times the price of your product to design an excel spreadsheet for my record-keeping, but that proved to ba a bad idea, because that programmer had no real understanding of how markets work. Anyway, suffice it to say, your personal serviceback-up and product is one of the best investments I8217ve made in my trading career to date. Thank you.8221 John Buckley 8230 IRELAND 8220After reviewing your slideshow and looking at the detail that you have put into this trading log 8211 it8217s just the journal I8217ve been looking for. The depth of information that8217s at my finger tips will help me become a better trader and understand my mistakes. The thing that impressed me most was your vary prompt response to my question about the product over the weekend. I like customer service. Thank you Greg8221 Sid Sali 8230 CANADA 8220Greg, this software is beyond brilliant. I have done SO many spreadsheets for my own trading but was never satisfied with its tracking capabilities. I came across yours and have begun using it eagerly. I love the drawdown table. I love the expectancy curve. Actually I love the whole package. Worth the money in spades. Well done Greg8221 K. C. 8230 AUSTRALIA 8220This is an excellent investment. The cost is very minuscule compared to the product quality and features. I would highly recommend to simply buy this without second thinking. The product will definitely make you a better trader and put discipline in documenting your trades. On top of this, you have Greg to provide unlimited support as well 8211 this kind of service is invaluable.8221 Subramani Kottlingam 8230 USA 8220So far, I have to say AWESOME. You are truly amazing. Thank you for sharing your knowledge with others. This is such a valuable tool that it deserves to be linked into and talked about all over the trading community. Next, I wish to say your customer service exceeds expectations 8211 First class help and service. Many many thanks.8221 N. G. 8230 AUSTRALIA 8220I spent a few hours designing my own spreadsheet before deciding that someone must already have come up with something better than my attempt, and so you have. The Trading Journal Spreadsheet (spread betting version) is by far and away the best such journal I have found. TJS is a great product. I can keep accurate records and see at a glance all the vital info I need.8221 C. K. 8230 UNITED KINGDOM 8220When a trader develops to a level where they finally realize the need for proper journaling, tracking and analysis, the value of this product becomes painfully obvious. To try designing something that would come even close to this product would be beyond the scope of most people. For someone qualified, the work and time involved could not possibly be justified let alone the fact that they probably don8217t have the trading experience or knowledge to incorporate the necessary features. Without question, this is excellent value for money and a must for any trader wishing to treat their trading as a business. Many thanks.8221 Paul Terbizan 8230 AUSTRALIA 8220A must have for people who are trading stocks, futures or currencies. Helps improve your profitability by seeing what is working and what is not working. Also, the company is very responsive to customer needs and wants and gets back to you with answers to your questions in a timely manner. I would highly recommend this product to anyone.8221 Posted on TradingApples website. 82208230I just wanted to share if I may, I have found a trading spreadsheet that I think worthy to be checked out. I8217ve also bought a copy of this spreadsheet because it was designed by a full time trader. It contains a lot of features that will help me to further analyze my trades.8221 8220When I finally decided to get serious about tracking my trading progress, no other solution on the market even came close. The attention to detail is remarkable 8211 8211 it8217s clear this was written by a seasoned trader. And the level of support offered by the developer makes this purchase an easy choice.8221 Jason Pollack, USA 8220One of the most important aspects of trading is simply, having a Trading Journal. Greg at TradingSpreadsheets has what you need 8211 a very powerful yet intuitive spreadsheet even for the most basic Excel users like myself. Greg is also quick to respond to any questions you may have.8221 8220Came across this spreadsheet in a search for a trading log I read the testimonials 8212 all positive 8212 and I could NOT believe ALL the info. this sheet can impart. Keeping track is something I have not done other than on paper, but that doesn8217t mean anything other than tree killing in the long run With this spreadsheet, it actually provides you with information you CAN USE and keeps you focused. Thanks Greg8221 8220I really like the way you have integrated risk management (8216R8221 multiples) into your product, as this will be a constant guide and reminder to people such as myself, who too frequently tend to over commit capital to a trade. Thanks for a wonderfully useful product.8221 Gale Nelson 8230 USA 8220Love it. The analytical feedback I get from compiling my trade stats on this spreadsheet is motivational. Helps me identify strengths and weaknesses in my trading disciplines. Helps me develop and track trading goals and gives useful feedback for each trading system I use.8221 8220Purchasing this trading journal ended a 10 year search, including trying to develop my own. In my opinion this journal is flawless. Finally, I can go back and study trades I recorded and with the ability to bring up the chart for that trade is great. Thank you.8221 Bob Miller 8230 USA 8220For someone just starting out as a full time trader, these spreadsheets help me to develop my trading plan through showing me areas of strength and weakness in my trading, also providing me an overall snapshot of how I am tracking 8211 Thanks Greg, this really helps.8221 Robert Allisey 8230 AUSTRALIA 8220This is quite simply the most effective and invaluable tool that I have ever encountered, for tracking trades and more importantly for helping one discover areas of concern and improvement. No one can afford to be without it8221 Michael Ward 8230 CANADA 8220This is the best program to easily keep a detailed log of my daily trades with support of partial fills and full performance reporting. I just upgraded to the latest version and Greg Thurman offered an absolutely flawless technical support. Thank you8221 John Banegas, USA 8220Outstanding product designed to deliver exactly what a trader needs to know with minimal cost in terms of time and effort. The worksheet keeps it simple and smart while providing both a macro and micro view of the traders progress. Thanks8221 David Grossman 8230 USA 8220Thank you for your excellent spreadsheet 8212 it8217s absolutely what I was looking for (yet too lazy to create myself) 8212 it8217s helped in giving a clear picture and seeing patterns emerge for my trading activity8230now I have a clear idea of where I stand. Many thanks8221 C. Truong 8230 CANADA 8220This is by far the best example of a trade journal amp trade review system that I have ever seen. It contains details of all of the possible mistakes that I have already made and seems to be able to identify even more of which I was previously unaware.8221 8220Thanks for your help Greg. I really like the way the spreadsheet is constructed. I especially like the fact that I can scale in and out of trades, and get a visual on my equity curve. Also, the expectancy calculator is very interesting.8221 Kevin Kendall 8230 USA 8220If you8217re a gambler or trading for thrills then you don8217t need this. I got serious about treating my trading as a professional business and pinpointing strengths and weaknesses of my plan. This spreadsheet does this. It shines a light on the hidden aspects of the plan and exactly where things need to be changed.8221 Peter Murphy 8230 IRELAND 8220The more I get into the new Elite spreadsheet the more impressed I become. You have done a great job. The 8220Go To8221 really streamlines the navigation of moving from sheet to sheet in a flash. For someone that trades different markets being able to now do it all under one roof is so much more efficient. You have a great product, at a reasonable price, and with excellent support. Congratulations.8221 Robert Warren 8230 PANAMA 8220I really appreciate the fast turn-around customer service experience I received after purchasing the product. I had a couple questions issues, and they were resolved promptly. Thank you8221 Chris LaCourse 8230 USA 8220Critical investment for any trader. Very easy to manage and track important statistics in order to improve one8217s trading performance. Highly recommended8221 Duane Thomas 8230 CANADA 8220Excellent trading journal Easy to use, scrutinize your performance as you like, identify mistakes, solve errors, and improve your bottom line Easier said than done, but: TradingSpreadsheets makes it FAR, FAR easier to achieve.8221 Posted on Brett Steenbarger website, (Traderfeed. blogspot ), by 8220Jeremiah8221: 8220I8217ve just recently started to use some of the spreadsheets at TradingSpreadsheets. I like them because in addition to setups and pampL they also track time of day, days of week and timeframe. Very useful.8221 Jeremiah 8230 USA 8220I have developed several trade tracking spreadsheets myself over the last few years but did not want to invest the time it would take to duplicate the TJS product. Once I downloaded the spreadsheet and got my first look at it, I knew it was a great decision8221 Ted Carolus 8230 USA 8220Excellent product, extremely pleased with the ease-of-use and well laid-out information. Thanks for a great product at a great price, am tempted to try out the Spreads tracker now :)8221 Charles T 8230 CANADA 8220I just bought your Stock Spread SuiteWOW. Its lots more than I expected. I never thought thered be a learning curve with a program designed to track your trades. Im impressed. Thanks, Greg8221 Kristy Coy8230 USA 8220Just wanted to let you know that the latest TJS Elite is phenomenal. I tried subscribing to some online trade-tracking sites but there8217s nothing like taking the time to manually record your trades to really understand your game. Nice to see the drawdown feature in there as well8221 Simon Smith 8230 CANADA 82208230I have downloaded your spreadsheet and it is working fine, I8217m really happy I found it Besides tracking my trades it is very inspiring and instructive, congratulations on your great job8221 R. Santos 8230 BRAZIL 8220Again, I can8217t tell you how pleased I am with your product I have been looking for something like this for a long time. You did an outstanding job in the development of this spreadsheet.8221 Scott Schafer8230 USA 8220I8217m excited I had been journaling with screenshots, a notebook, and a very basic spreadsheet. I would never have been able to develop a sophisticated series of interconnected spreadsheets like you have. Thanks This will bring so much more awareness and informed analysis to my trading.8221 Joan Cousins 8230 USA 8220I really needed a capable spreadsheet program that could track my trades, but this one is more than a tracking program. It allows me to analyze my results. I really like it. Thanks8221 8220Love the program You have done a great job putting everything a trader needs all in one place. 8221 Sanford Paulsen 8230 USA 8220Great product so far in the first week. Love the ability to track different 8220types8221 of trades and edges to see which are the most effective. Thanks for everything. Great support also8221 8220Am enjoying using your TJS Elite spreadsheet for my Stock trades. Going to try it for Forex very soon. عمل عظيم. Love the analytics and being able to see my 8216scores8217. Great to keep me focused. Thank you8221 Joanne Stuhmcke 8230 AUSTRALIA 8220Just a quick note on my deciding factor in choosing this product8230 it was you. Your follow ups to all my emails were really fast, and you answered all my questions. This is a fleeting commodity in today8217s marketplace. I think I am going to benefit greatly by the analysis features of your spreadsheets and look forward to begin tracking my trades.8221 Ken Kittredge 8230 USA 8220I just bought ur spreadsheets a week ago and for now I like very much. I think it8217s worth more then ur price, real time (and money) saver. Excellent job Greg I really appreciate.8221 8220Great value for the money and very easy to use with all the analysis that I need to improve my trading 8211 just what I have been searching for.8221 Dr. Nicholas Cheah 8230 AUSTRALIA 8220Outstanding, fast and effective. Why build and attempt to grapple with Excel when it is all done for you, done right and at a price that is almost free. Thanks.8221 8220I love your spreadsheet I8217m asking myself now how could I trade Forex without this before Thank you so much for making my trading life much easier8221 Richard Kelus 8230 USA 8220You8217ve done a really great job with these spreadsheets, I8217m really amazed. And I appreciate it more than most of the people because I8217m a programmer8221 Patrik Antoni 8230 CANADA 8220Loving it. I have three staff trying to enter all the 1,200 prior trades8230 The program provides fabulous statistical analysis and trends of your trades.8221 Larry Exum 8230 Georgia, USA 8220Thought I would tell you that I am enjoying your spreadsheet for my Options trading. Very well designed and thought out 8211 and easy to use. Thanks, David.8221 David Webber 8230 NEW ZEALAND 8220I got to hand it to you. What a great spreadsheet. I just spent a few minutes on it and I am impressed. It is worth the money just to look at it and prepare the plan and the variables. Great tool8221 Raul Jacomino 8230 USA 8220Great product that is simple to use and provides easy customization of the components of your trading system that you want to track and analyze.8221 D. B. 8230 AUSTRALIA 8220All I can say Greg, it8217s very reasonably priced, it8217s simple to use, it8217s highly effective and it8217s just a great way to record your trades. Thanks8221 Jack G 8230 CANADA 8220I have been using Version v6 which I found to be an excellent product, in fact it went way above my expectations, and that is why I upgraded to Version v7.8221 Derek Penny 8230 SOUTH AFRICA 8220So far I am impressed and really want to thank Greg for his effort to make my spreadsheet as custom as I want it.8221 Radim Frycka 8230 CZECH REPUBLIC 8220Now that I have familiarised myself with the program, I8217d just like to say what an amazing program it is and I8217m sure it will help a great deal with my trading.8221 Robert Miller 8230 GERMANY 8220Just wanted to say that I purchased your product this afternoon and it is fantastic. There is no way I could even come close to building something like this.8221 Fred Hughes 8230 USA 8220I am finding it very handy in identifying my good trades and mistakes much better than I was doing. Would definitely recommend.8221 Mark Lithgow 8230 IRELAND 8220This is a fantastic product Product support and customer service A8230 Highly recommended. 8221 8220I think that the product is great. The tracking is great. Also like the Expectancy and Drawdown tools. Overall 8211 excellent product.8221 Adam Mitchell 8230 AUSTRALIA 8220I love it. It holds me accountable for where I am as a trader and is a personal billboard that shows me what I can do to grow to the next level.8221 8220Very pleased with this product. Just the right amount of detail and simplicity. سهل الاستخدام. Really enjoy it8221 Douglas Schultz 8230 USA 8220I really love the Expectancy tab this tab is the gold mine of the software. Great tool, it8217s a must for all who want to be a pro trader. 8221 Landon Kekuewa 8230 HAWAII 8220Great work on the spreadsheet Very impressed with your commitment to support. That commitment, alone, is worth the price of the spreadsheets8221 8220I8217ve looked around at 8216other8217 products to track my trades and keep a journal. I8217m very confident that I8217ve made the right choice. Thanks for your support along the way and answering all my questions, I appreciate that you8217re there to support your product.8221 Mike Oliver 8230 USA 8220Thanks so much Greg. The spreadsheet works perfectly. Your products and service are awesome 8211 keep up the good work.8221 Tanya Henry 8230 USA 8220Great product Saved many 1008217s of hours to create a spreadsheet like the one purchased. And as we all know, time is money.8221 K. A. 8230 HUNGARY 8220Thank you for a fabulous and well thought out spreadsheet and web site which will tell me all I need to know about my trading strategies. Cheers, Steve.8221 Steve Clay 8230 AUSTRALIA 8220Great product Greg. Worth every penny and I8217ve only started using about 50 of the features. Just what the doctor ordered.8221 Jon Pam 8230 AUSTRALIA 8220Terrific product8230love that it works on both mac and windows and would recommend it to anyone8221 Timothy McHugh 8230 USA 8220Really good layout ideas and functionality. I really like the great support, and that you8217re open to suggestions.8221 8220I think this spreadsheet is great, and in fact it has already helped me focus my trading more in just one day of use.8221 8220I am new to trading and this money management system fits right in with what I was taught to track. Thank you.8221 D. Nickel 8230 USA 8220Just finished my books for the last 2 weeks. I can8217t thank you enough for how simple you8217ve made analysis for me.8221 Zac Putnam 8230 USA 8220Very powerful, I enjoy. I purchased because it8217s exactly what I8217ve wanted to do since several years, but not with your success. Congratulations again.8221 Clip Franck 8230 BELGIUM 8220This is a great spreadsheet. I am tweaking my trading plan and the spreadsheet has streamlined that process.8221 Jose Noriega 8230 USA 8220Wow Everything I need and have been looking for in one package. I wish I would have found this product sooner8221 David Carlson 8230 USA 8220Greg, thanks for the help. Love your work, it is a tremendous timesaver and provides great insight to my trading.8221 Dwain Farley 8230 Texas, USA 8220This trade tracking spreadsheet is one of the most useful money management tools I8217ve found at any price.8221 Fred Esch 8230 USA 8220The best spreadsheet specifically designed for traders I know of, enjoyable to use and truly time saving8221 M. Lovett 8230 UK 8220Very useful, the more I explore it the more I like it. Thanks Greg8221 Ray Germaine 8230 USA 8220Great product Greg, very easy to use and is of vital importance to new traders to track their progress.8221 G. L. 8230 AUSTRALIA 8220Impressive service, the best I8217ve ever received. Many many thanks for your invaluable help.8221 Wayne C. 8230 UNITED KINGDOM 8220Significantly surpassed my expectations Very very high quality spreadsheet Love it.8221 Omar Ignacio 8230 PUERTO RICO 8220Spreadsheet exactly as described, nicely done. Well worth the price8230 Thanks8221 Doug Forman 8230 Washington, USA 8220Man. Sweeet SpreadSheet Never a fan of SS, but this one rocks for trading Awesome svc2.8221 DJ Blackford 8230 USA 8220This sheet you have put together would be a great value for money at twice the price8221 Nick Rayne 8230 GERMANY 8220O my god, this is extra ordinary high level thinking. This is best ever journal.8221 Abdul Soomro 8230 Ontario, CANADA 8220I8217ve been able to double my account studying the spreadsheet results alone and wanted to thank you8221 G. V. Bogota, COLOMBIA 8220Teriffic spreadsheet Very user friendly, easy to use and powerful tool to effectively track my trading.8221 Mark D8217Ascenzo 8230 AUSTRALIA 8220Excellent trade tracking program. I have tried three others, TradingSpreadsheets is the best. Support is excellent.8221 Robert Hemingway 8230 USA 8220I love your spreadsheets and I have been looking for exactly this type of product for some time.8221 Dennis Mojares 8230 USA 8220Impressive, I8217d have to give up trading to construct a spreadsheet this good.8221 Peter Murphy 8230 IRELAND 8220Very excellent program, worth a lot more than it costs. Thanks Greg.8221 Rodney Daniels 8230 Pennsylvania, USA 8220The 8216Bonus8217 material alone is worth what I paid, let alone your tracking program.8221 J. V. 8230 Ontario, CANADA 8220Hi Greg, Well done on a excellent spreadsheet. It8217s brilliant. Worth every cent.8221 Monty Gadd 8230 SOUTH AFRICA 8220Good instrument that helps to be firm on the trading plan.8221 Marion Resescu 8230 Breaza, ROMANIA 8220Great Journal. Excellent Set up. Will recommend to other traders.8221 Verlin Sanciangco 8230 USA 8220This spreadsheet is excellent Does everything I can think of thus far82308221 M. O. 8230 London, UK 8220Very useful spreadsheet and good value for the money.8221 Damien Foley8230 Dublin, IRELAND 8220I am glad to see Van Tharp8217s R multiples and position sizing8221 8220Simply awesome is an understatement8221 Randy Dillon 8230 Tennessee, USA 8220Extremely comprehensive log. It covers everything.8221 S. C. 8230 St. Louis, USA 8220Product is exactly what I was looking for8221 R. R. 8230 Sydney, AUSTRALIA 8220It8217s a superb product. Nothing else like it out there.8221 8220Thanks8230 I love your product.8221 Tim McHugh 8230 Washington, USA 8220Very comprehensive, exactly what I need.8221 V. S. 8230 Florida, USA 8220A superb product and exceptional value8221 P. S. 8230 London, UK 8220Easy, casual, professional 8211 very contemporary 8211 no b. s.8221 John Stearns 8230 Idaho, USA Crispian Ho 8230 SINGAPOREOriginally Posted by cchase Not sure if this helps. Earlier today I posted a very similar request for an excel trading spreadsheet but got no replys. Why is this so hard to find I found one here but its a hundred bucks. exceltradingspreadsheet Dont really want to buy one but it may be cheaper than building. If you findhave a free one, can you post it You can easily do it yourself, take a look here. كوت دائما يدفع رجل ليكون على حق في الوقت المناسب. كوت - جيسي ليفرمور أقل ماركس، أكثر ميسس