Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 10:41:48 +0000



Spreadsheet System for Trading Study - not working as required

View Count: 665

[2016-01-05 22:34:34]
AP - Posts: 117
Hi -

I am having trouble running bar based back testing using the spreadsheet system for trading study. I see that even in case where the long entry column i.e. K return a FALSE value - a trade is generated at that time point i.e. for that bar.

1. Any reason this happens? Or when this happens?

2. Also, all I was using is RSI and its average and I see that trade entry price (say long entry) is not consistent across bars - it is open in one case and it is close in the other. Do you know if I can control the trade entry price by asking the back testing to only use CLOSE price?

3. Lastly, is it not possible and this so even on a 1-min bar chart - where the K column return FALSE since (maybe) it evaluates a simple RSI above its average condition at the close of the bar; however when you run the back testing using bar based method - the condition satisfies anytime during that bar (not just at the close) and it fires up an order. Is this not possible? If so, could this be the reason for my issues in 1 above? And finally, how to control this?


Please help!
[2016-01-06 03:09:40]
Sierra Chart Engineering - Posts: 104368
1. Refer to:
https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#DisappearingArrows

2, 3. Refer to:
https://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#SignalOnlyonBarClose
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