Support Board
Date/Time: Thu, 16 Jan 2025 12:49:18 +0000
Post From: spreadsheet, formula modification
| [2017-10-27 08:00:23] |
| aydex - Posts: 110 |
|
Hi, 1. I have played with using column H as a "contraint-free "column with success so far,(instead of bottom of I/J) doing isolated calculations for use in entries and exits. Does that sound like a good plan? 2. http://www.sierrachart.com/index.php?page=doc/StudyChartAlertsAndScanning.php#ReferencingDataOtherLastBar a. Can e.g ID2.SG1[-4] be used in a spreadsheet system for trading? I'm trying to avoid a circular reference when a buy entry formula is including sell entry cell $M$6 and vice versa (if I paste in =ID2.SG1[-4], SYNTAX error is returned.) b. If this isnt allowed, is there a workaround for a such a reference? 3. http://www.sierrachart.com/index.php?page=doc/StudyChartAlertsAndScanning.php#BaseGraphIdentifiers can these be used in spreadsheet system for trading? i may need to just ignore that page :) |