Support Board
Date/Time: Mon, 10 Mar 2025 02:56:19 +0000
Post From: [STRATEGY][AUTOMATE] How to automate my strategy into Sierrachart ?
| [2022-03-04 19:42:12] |
| Sawtooth - Posts: 4181 |
|
If you don't want to use ACSIL, IMO the Spreadsheet System for Trading study would be best for your automated strategy. Here are some quick spreadsheet formulas: Upper wick size: =C3-MAX(B3,E3) Lower wick size: =MIN(B3,E3)-D3 =Candle range: =C3-D3 Body size: =ABS(B3-E3) Upper wick/candle range %: =(C3-MAX(B3,E3))/(C3-D3) Lower wick/candle range %: =(MIN(B3,E3)-D3)/(C3-D3) -where the OHLC are B3,C3,D3,E3 Enter these formulas in row 3 of a Formula Column to the right of the entry/exit columns (O3 and rightward). Here are some spreadsheet formula examples: Spreadsheet Example Formulas and Usage This one in particular, to determine the bar's color: Spreadsheet Example Formulas and Usage: Formula that Matches the Coloring of Up and Down Price Bars |