Support Board
Date/Time: Fri, 27 Dec 2024 11:46:28 +0000
Spreadsheet System for Trading Example
View Count: 1144
| [2015-12-31 04:33:48] |
| User760942 - Posts: 120 |
|
Hi SC, I followed your step by step example (as shown in this link http://bit.ly/1YOHxHD) to make the "Moving Average-Simple" Spreadsheet System for Trading. However, no "buy and sell arrows" showed up on the chart when I was done and no trades happened when I backtested it. I figure the problem may have something to do with the "#name?" message I'm getting in cells 3K and 3M and the "#sytax!" message I'm getting in cell 3L (as circle in red in the attached screenshot)? Any idea whats causing this issue? Thanks! Date Time Of Last Edit: 2015-12-31 04:35:00
|
1.jpg| [2015-12-31 04:59:47] |
| |
|
We have made a correction to the documentation. The documentation mistakenly was identifying the Moving Average-Simple using ID1 when in most cases it would have been ID2. This is the correct formula for K3: =CROSSFROMBELOW( ID0.SG4@3:ID0.SG4@4, ID2.SG1@3:ID2.SG1@4) Surprising no one else has pointed this out until now. But the documentation was not updated all that long ago. About two months ago. Not sure about the syntax error because we cannot see the formula. 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 |
| [2015-12-31 06:05:17] |
| User760942 - Posts: 120 |
|
Cool. Adding that new formula to K3 made both K3 and M3 say "FALSE" and got buy and sell arrows to show up on the chart. However, L3 still says "#SYNTAX!" and my "Trade Activity Log" shows no trades happened when I ran the backtest. Here is the formula I've been using in L3 =OR( AND( $J$8 > 0, ID0.SG4@$3 < =$J$9-1), AND( $J$8 > 0, ID0.SG4@$3 >= $J$9+2)) Date Time Of Last Edit: 2015-12-31 06:05:40
|
| [2015-12-31 17:59:40] |
| |
|
The documentation has been corrected. There was a space between < =. This is the corrected formula: =OR( AND( $J$8 > 0, ID0.SG4@$3 <= $J$9-1), AND( $J$8 > 0, ID0.SG4@$3 >= $J$9+2)) If you are still not getting any trade signals, follow through this test procedure here: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetTradingTestProcedure.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 Date Time Of Last Edit: 2015-12-31 18:02:15
|
| [2016-01-02 06:38:08] |
| User760942 - Posts: 120 |
|
Hi SC, I rebuilt it via your updated documentation. I then ran a backtest of it on AAPL stock, then clicked the "Trade Activity Log" then clicked "Trade Stats for charts" and saw the results shown in attached screenshot 1.jpg (which show there were 126 daily fills). However, no fills or trade activity showed up when I clicked the "Trade Activity Log's" "Trade Statistics" (as shown in attached screenshot 2.jpg) and "Trade Activity" (as shown in attached screenshot 3.jpg). Any idea why this is? everything else seems to be working fine. The .scss file i used for the backtest is attached. (FYI: I also ran the test procedure you mentioned here http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetTradingTestProcedure.php and had the same results.) |
 jan1spreadsheet.scss - Attached On 2016-01-02 06:23:29 UTC - Size: 24.79 KB - 441 views |
| [2016-01-02 22:07:01] |
| |
|
Here is the documentation for the Trade Activity Log: https://www.sierrachart.com/index.php?page=doc/doc_TradeActivityLog.php#ViewingHistoricalTA Be sure to follow through the steps. The problem is you did not select the "Symbol". 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-01-04 00:10:41] |
| User760942 - Posts: 120 |
|
Great, it works now, thanks!
|
| [2016-01-04 01:26:16] |
| |
|
There is no need to say thank you. It is an extra burden on us.
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: