Support Board
Date/Time: Sat, 01 Feb 2025 04:00:00 +0000
Post From: Different formula for last bar when using Spreadsheet Formula study?
| [2019-06-17 16:33:15] |
| User132748 - Posts: 159 |
|
Hey is there any smart way to define different formula for the last bar in the chart vs other bars when using Spreadsheet Formula study? I dont't know how to detect/reference last bar. It all would be easy when using full spreadsheed - just use IF(ROW()=3,...) clause, but how can I do that in spreadsheed formula study? So lets say formula for all bars in the chart would be ID0.SG2+10, but for the last bar I want it to be ID0.SG2+50. How should I do that? I was thinking about Bars Numbering study, but unfortunately it enumarates bars from oldest to current. It would be great if it could enumrate backwards as option too. Thanks! |