Support Board
Date/Time: Sat, 21 Dec 2024 13:01:04 +0000
spreadsheet trading ?
View Count: 942
| [2014-12-01 16:39:34] |
| User120827 - Posts: 77 |
|
When you use a formula like: bv3 > bv4 in order to signal an increase in something like a MACD for instance. What is the proper formula so you can show historical signals for backtesting. I am familiar with a range for crossovers like : =crossfrombelow(AB3:AB4,AC3:AC4) But I cant figure out how to write formula for a simple "greater than last bar " signal. Like " bv3>bv4 so as to get historical signals to allow me to backtest it. thanks shane Date Time Of Last Edit: 2014-12-01 16:40:18
|
| [2014-12-01 20:10:53] |
| Sawtooth - Posts: 4141 |
|
I use this to find the first occurrence of a slope change to up: =AND(BV5>=BV4,BV3>BV4) Then for a slope change to down, you only have to change the direction of the operator: =AND(BV5<=BV4,BV3<BV4) |
| [2014-12-01 20:14:10] |
| |
|
As long as you have set the Number of Rows input with the Spreadsheet Study high enough and have arrow Draw Styles for the Buy and Sell columns the formulas are in, you will see arrows on the chart. Refer to the information here about running an actual back test: http://www.sierrachart.com/index.php?page=doc/doc_Backtesting.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: 2014-12-01 20:15:04
|
| [2014-12-01 20:45:01] |
| User120827 - Posts: 77 |
|
hi ok, thats good thank you for the insight and info Tom thanks again, as always ! The change of slope may be helpful as another condition for my formula ! shane |
| [2014-12-01 21:41:34] |
| Sawtooth - Posts: 4141 |
|
To see arrows previous to the Number of Rows setting, scroll the chart into the past and start a Replay Chart, then press Pause.
|
To post a message in this thread, you need to log in with your Sierra Chart account: