Support Board
Date/Time: Mon, 21 Apr 2025 14:56:48 +0000
Post From: Trading Signal fields in 'Spreadsheet System for Trading'
| [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.
|