Login Page - Create Account

Support Board


Date/Time: Wed, 01 May 2024 22:28:49 +0000



Can I do simulated trading based on alerts?

View Count: 1006

[2016-10-25 13:16:27]
pip_monster - Posts: 6
I have looked around and information on this is abundant, but yet I just can't seem to find a quick answer before I needlessly invest the time into learning backtesting/automated trading.

Basically, I subscribe to some indicators which naturally means I do not have access to the DLL study settings. What I do have are alerts that work exactly as I want them to. Is it possible to have back testing performed by simply using the alerts for the indicators that are generated? Basically, the indicator posts a green dot for long and a red dot for short, if that dot shows up the alert goes and that's what I want to test.

If this is possible, I have found some links here at SC talking about backtesting but any additional direction is much appreciated.

Thanks in advance.
[2016-10-25 17:24:50]
Sierra Chart Engineering - Posts: 104368
Yes. You can do this by using the Spreadsheet System for Trading study. Refer to:

http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php

The data from the indicator will be outputted to the Spreadsheet and you can then examine the numeric values it is outputting and write formulas which refer to those values.

Here is the page about back testing:
http://www.sierrachart.com/index.php?page=doc/Backtesting.php
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-10-30 02:01:42]
pip_monster - Posts: 6
That is great! I have made some great progress and have a system loosely in place. I want to use a fixed value take profit and stoploss as my exit strategy but can't seem to figure out where to go to find out how to make that happen. Basically I want to pick fixed values like a 3 pip Take Profit and a 15 pip Stop Loss on the trades. I want to start by doing so back testing and then go live if it works. I have seen the order send functions, but it doesn't look like that applies to the back testing. Here's what I have but doesn't quite work.

=OR(AND($J$8 > 0, ID0.SG3@3 <= ID0.SG1-10), AND($J$8 > 0, ID0.SG2@3 >= ID0.SG1 + 2))

It is throwing a #NAME? Error, basically the idea is, exit the trade if the LOW is 10 pips less than the open OR close the trade if the HIGH is 2 pips greater than the open assuming that I enter the trade at the open value.

I think the logic in that should be sound, probably just not formatting it correctly.

Thanks!
[2016-10-30 20:44:57]
Sierra Chart Engineering - Posts: 104368
The study references you have that do not specify a row by using the @ are not complete. This is the reason for the #NAME? error. Refer to:
https://www.sierrachart.com/index.php?page=doc/Spreadsheets.html#ReferencesStudySubgraphColumnsSpreadsheetStudy

Also refer to this section here about using Attached Orders for the exits which is going to be the easiest way:
http://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#UsingManualOrAttachedOrdersExits
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2016-10-30 20:45:32
[2016-10-30 23:08:21]
pip_monster - Posts: 6
So the attached orders will allow me to backtest the strategy? Because it doesn't quite seem like that's the case.

Also the trade activity log doesn't have any trades in it, it just says connected to server, requesting open orders from trade service, disconnected from server. Each message gets it's own timestamp and entry, but that's all.
[2016-10-30 23:35:41]
Sierra Chart Engineering - Posts: 104368
So the attached orders will allow me to backtest the strategy?

Not sure we understand the question. To do back testing requires that there is an automated trading system on the chart.

Refer to the documentation here for the Trade Activity Log:
Trade Activity Log: Viewing Historical Trade Activity
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing
[2016-10-31 00:03:08]
pip_monster - Posts: 6
The trade activity log shows 1 trade out of the 3 that are shown in Cell J35. What are the different order types in cells I72 and I74, is there not just a simple take profit and stop loss system that can be used in spreadsheets?
[2016-10-31 08:54:25]
Sierra Chart Engineering - Posts: 104368
The Trade Activity Log is not going to miss any simulated order fills. They will all be listed.

You can find the order types here:
https://www.sierrachart.com/index.php?page=doc/SystemsAlerts.php#BuyEntryLimit

For a simple Stop and Target, set those up as Attached Orders:
Attached Orders
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account