Support Board
Date/Time: Sun, 19 Jan 2025 23:19:57 +0000
Spreadsheet Usage Questions
View Count: 814
| [2018-05-16 18:12:32] |
| 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] |
| |
|
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] |
| 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] |
| |
|
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?). 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: