Home >> Support Board

Support Board

Date/Time: Fri, 03 May 2024 23:00:23 +0000

How to Post a Message for Support

Spreadsheet Usage Questions

View Count: 749

[2018-05-16 18:12:32] #1 [Go To First Post]
User172040 - Posts: 70
I have gone through all the documentation r.e. spreadsheet studies. I do still have a few questions though. The docs a re quite a lot so I may have missed answers to some of my questions: 1. Is it possible to run multiple spreadsheet studies on 1 chart? If so, does that mean I have to add multiple spreadsheet studies (for trading) to my 'Studies to Graph'? 2. If it is not possible to run multiple spreadsheet studies on 1 chart simultaneously, what is the best practice for running multiple strategies on a chart? 3. How can I run multiple strategies across multiple symbols? 4. If I run multiple strategies for trading purposes, is it best practice to load these strategies as study alerts and trade them when the signals fire off? 5. Can I run a scan on lets say 5 strategies through a quote board with multiple symbols? 6. Can you please give an example of what formula type to put in cell J26? I don't trade more than 2 lots on futures. Or should I just hardcode it to the value of 2? 7. How do I use the Sim accounts to run strategies on? Is there a thread you can recommend so I can see how to use the multiple sim accounts to my advantage?

[2018-05-16 18:34:04] #2 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
1. Yes. In this particular case make sure this Input is different for each instance of the Spreadsheet Study: http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#ChartDataOutputSheetNumber 3. You just simply do this. Obviously there is going to be a different chart for each symbol. 4. This is up to you. 5. It sounds unds like you are referring to back testing? 6. Yes just use 2. Also refer to: http://www.sierrachart.com/index.php?page=doc/SpreadsheetSystemsAlertsAndAutomatedTrading.php#MaximumPositionAllowed 7. We do not understand this. 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

[2018-05-17 14:20:24] #3 [Go To First Post]
User172040 - Posts: 70
3. You just simply do this. Obviously there is going to be a different chart for each symbol. What I mean is, how can I backtest a specific study over multiple symbols instantaneously. In other words, with the click of a button, a specific strategy will run as a backtest through a whole list of symbols? 5. It sounds unds like you are referring to back testing? Actually no. Lets assume I have already backtested and now I want my 'spreadsheet system / alert' study to give me alerts by monitoring a list of symbols continually (quote board I guess?). 7. We do not understand this. Where can I read more on the practical functionality of the Sim accounts. I know I can create up to 400 sim accounts but I don't know how to use this to my advantage.

[2018-05-17 20:05:22] #4 [Go To First Post]
Sierra Chart Engineering - Posts: 104368
What I mean is, how can I backtest a specific study over multiple symbols instantaneously. In other words, with the click of a button, a specific strategy will run as a backtest through a whole list of symbols? Yes. Use this command: Trade Menu: AutoTrade System Bar Based Backtest with Scan (Trade menu) But it is not going to be instantaneous. This is an impossibility. Actually no. Lets assume I have already backtested and now I want my 'spreadsheet system / alert' study to give me alerts by monitoring a list of symbols continually (quote board I guess?). You need a chart open for each symbol with the trading system on each of those charts. 7. This is explained here: Auto Trade System Back Testing: Running Multiple Back Tests For Comparisons 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: 2018-05-17 20:05:38

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