Support Board
Date/Time: Tue, 04 Feb 2025 14:40:43 +0000
Spreadsheet trading using a higher time frame as the trend
View Count: 674
| [2020-01-24 20:01:41] |
| User312841 - Posts: 26 |
|
I am testing trading on a lower timeframe, referencing bars off a higher timeframe, 5 minute chart as the trend using Spreadsheets. The reddish background represents a trend on the 5 minute charts, means go Short. But the Spreadsheet trades Long while the 5 min trend is clearly short (see pic). I have tried setting all studies to Evaluate on Bar Close, Use Earliest Value for Corresponding Chart, etc. Stumped, why is the behavior different than the chart? Thanks |
 Capture.JPG / V - Attached On 2020-01-24 19:27:42 UTC - Size: 49.15 KB - 250 views |
| [2020-01-28 19:46:13] |
| Sierra_Chart Engineering - Posts: 18240 |
|
There is something wrong with your formulas in the Trading Spreadsheet. From what you state, the formula in K3 is becoming True when you are setup for a Sell situation, which means that the formula in M3 should be True, but it is not. You just need to review your formulas and make sure they are working the way you expect in the proper columns. Refer to the following, particularly starting at step 23 and after for examples of entering formulas for Buy and Sell: Spreadsheet Systems, Alerts and Automated Trading: Halting Order Entry 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, use 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: