Login Page - Create Account

Support Board

Date/Time: Sat, 22 Feb 2020 12:49:05 +0000

Spreadsheet trading using a higher time frame as the trend

[2020-01-24 20:01:41]
User312841 - Posts: 22 | Ending Date: 2020-08-05
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?

imageCapture.JPG / V - Attached On 2020-01-24 19:27:42 UTC - Size: 49.15 KB - 15 views
[2020-01-28 19:46:13]
Sierra_Chart_Engineering - Posts: 530 | Ending Date: 2020-11-26
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:
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:

To post a message in this thread, you need to login with your Sierra Chart account:


Login Page - Create Account