Support Board
Date/Time: Mon, 21 Apr 2025 13:05:49 +0000
Trading Signal fields in 'Spreadsheet System for Trading'
View Count: 178
| [2025-03-01 15:29:40] |
| User616054 - Posts: 25 |
|
Hi Sierra Support Team, I'm currently looking at the study called 'Spreadsheet System for Trading' - under the settings tab I cannot find the Trading signal fields like: Buy Entry Sell Entry Buy Exit Sell Exit Stop Loss for Buy Entries Stop Loss for Sell Entries I would like to define the criteria, I'm unable to use the study without these fields I have searched through the first tab "settings and Inputs" I'm running version 2671 any idea why I cannot see them? |
| [2025-03-01 18:29:11] |
| ForgivingComputers.com - Posts: 1042 |
|
After closing the Study Settings for the Spreadsheet System for Trading, you can open the spreadsheet as if it was another chart. You will see the fields you are looking for on Row 2 starting at Column K. The study settings for the spreadsheet have to do with how the spreadsheet interacts with the chart and trading. The cells in the spreadsheet, specifically the formulas in K3-N3, determine when to place the buy and sell orders. |
| [2025-03-01 20:48:31] |
| User616054 - Posts: 25 |
|
@ForgivingComputers.com Thanks that is very helpful. I add my logic/formula for those cells K - N then copy down, I also update Column labels and formulas for F - J on the spreadsheet but when I make a change to the chart or simply exit and re-enter the spreadsheet I lose all of the new information, it seems to default back to original values before I added the formulas. I cannot work out how to save my updates. Do I need to map the columns and add the formula somewhere else aswell? |
| [2025-03-01 21:26:08] |
| ForgivingComputers.com - Posts: 1042 |
|
The formulas do not need to be copied down, that is automatic. Enter them in row 3. Any reference to a row number is automatically incremented, so if K3 has: =(E3-B3) then K4 will be assigned =(E4-B4)
Use the $ sign for fixed values for example J$8 should not increment if used in a formula. The spreadsheet study is its own file (e.g. System.scss) and it needs to be saved separately or with File>>Save All. Columns F-G should not be changed. Column H can be used for fixed formulas or values. Most of the cells in Column J, are read only, like J$8 (Position Quantity) but some are read-write, like J$71 (Order Type). Any studies on the chart will have their subgraph values show up after the last formula column in column AA when you use the default 16 Formula Columns. It is recommended you don't reference the study by Column Number (e.g. AA3), but by its ID/SG like this: =ID1.SG1@3 The "@3" at the end means row 3.
|
| [2025-03-01 23:34:30] |
| User616054 - Posts: 25 |
|
I've got the hang of it now. Thank you
|
| [2025-03-02 00:28:26] |
| User616054 - Posts: 25 |
|
My backtest results seem to be showing multiple trades for one signal compared to the s/s (in some cases). I wonder why that is.... Also, is the session times on chart settings the only way to program start and end time for executions? I use a custom column in the buy/sell entry logic which looks at prior high, prior low, the data would be incorrect if I skipped data by having gaps in the session times. |
| [2025-03-02 00:43:28] |
| User616054 - Posts: 25 |
|
Quote "My backtest results seem to be showing multiple trades for one signal compared to the s/s (in some cases). I wonder why that is...." I have fixed this by setting 'signal only once per bar' from No to Yes |
| [2025-03-02 14:51:46] |
| Sawtooth - Posts: 4209 |
|
is the session times on chart settings the only way to program start and end time for executions?
Use cell J28.Here are two examples: Spreadsheet Example Formulas and Usage: Disable Trading From Spreadsheet Study for Trading Note: The reference to J8=0 disallows entries outside the times, but allows exits. |
To post a message in this thread, you need to log in with your Sierra Chart account: