Support Board
Date/Time: Mon, 23 Dec 2024 12:28:41 +0000
[User Discussion] - ohlc levels
View Count: 930
| [2015-09-23 20:48:08] |
| jim branch - Posts: 23 |
|
I am interested in created an input on the ohlc study possibly using a spread sheet. I use yesterday's levels on an intraday chart. I would like to extend naked levels until future intersection.(price) On the intersected day, I would like to continue the level until the end of the session. Is this possible? Has anyone done this? If so, is there a formula I can use to accomplish this. This is the same idea as extended levels on a volume profile chart. Thanks
|
| [2015-09-23 21:25:26] |
| Sawtooth - Posts: 4141 |
|
This could be done with a spreadsheet study, but it wouldn't be simple, plus there would be a limit to the number of naked levels it could track because of the 60 column limit of Formula Columns. This type of project would best be done with ACSIL. |
| [2015-09-23 22:15:17] |
| jim branch - Posts: 23 |
|
60 would not be a problem
Date Time Of Last Edit: 2015-09-23 22:18:32
|
| [2015-09-23 23:58:02] |
| Sawtooth - Posts: 4141 |
|
You could workaround the 60 column limit with multiple instances of the spreadsheet study, but there are at least two other limitations, if you are using it in real time: 1) The lookback is directly related to the bar period and the Number of Rows setting, and a high number would cause lag in real time. 2) The formulas would require a INDEX(...MATCH( function combination which is not efficient in the New Spreadsheets, and would cause lag in real time, even with a low Number of Rows setting. The Old Spreadsheets version would work much better with this, but they will soon no longer be included in updated SC versions. |
To post a message in this thread, you need to log in with your Sierra Chart account: