Support Board
Date/Time: Mon, 23 Dec 2024 12:08:12 +0000
Post From: Spreadsheet to chart plot
| [2015-09-20 14:12:34] |
| Sawtooth - Posts: 4141 |
|
-Formulas in Formula Columns must be entered in row 3. -Formula columns will auto-fill to rows below when a formula is entered in row 3. Row 3 is the current chart bar, rows below are previous chart bars. -Since each row is a chart bar, Formula Columns are for formulas that relate to chart bars. Columns A to G are also chart bar specific. -Column H is not associated with chart bars. It can be used for calculations that are not chart bar specific. Use column H instead for your list of times. Then with a formula in K3, use absolute references to values in column H. See this: http://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#RelativeAbsoluteReferences You'll want to compare times in column H with times in column A, however column A also includes the date. To remove the date, include something like this in your K3 formula: =A3-INT(A3) When comparing times, you may also need to deal with the imprecision of floating point numbers. See this: http://www.sierrachart.com/index.php?page=doc/doc_StudiesSystemsAlerts.php#ImprecisionOfFloatingPointNumbers |