Login Page - Create Account

Support Board


Date/Time: Thu, 31 Oct 2024 12:15:06 +0000



Spreadsheet System for Trading Example

View Count: 1122

[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
image1.jpg / V - Attached On 2015-12-31 04:33:22 UTC - Size: 362.35 KB - 316 views
[2015-12-31 04:59:47]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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.)
image1.JPG / V - Attached On 2016-01-02 06:23:04 UTC - Size: 142.87 KB - 318 views
image2.JPG / V - Attached On 2016-01-02 06:23:12 UTC - Size: 192.89 KB - 328 views
image3.JPG / V - Attached On 2016-01-02 06:23:21 UTC - Size: 160.01 KB - 328 views
attachmentjan1spreadsheet.scss - Attached On 2016-01-02 06:23:29 UTC - Size: 24.79 KB - 402 views
[2016-01-02 22:07:01]
Sierra Chart Engineering - Posts: 104368
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]
Sierra Chart Engineering - Posts: 104368
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:

Login

Login Page - Create Account