Support Board
Date/Time: Sun, 09 Mar 2025 21:06:47 +0000
[Programming Help] - how making custom formula to a regular bar (high low open close) in chart ?
View Count: 878
| [2022-02-28 15:23:40] |
| User278398 - Posts: 291 |
|
hello all, i'm using spreadsheet formula study to get value which i want to see in a regular chart (high low open close)... but with this study i can see line,bar,etc (in subgraphs). there is any other study which can help me ? thank u all :) |
| [2022-02-28 15:36:44] |
| John - SC Support - Posts: 38516 |
|
It sounds like you want to use the Spreadsheet Formula (Bar) study. It works the same as the Spreadsheet Formula except you can enter formulas for the Open, High, Low and Close and get a bar to display.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-03-01 07:18:02] |
| User278398 - Posts: 291 |
|
i was trying to use it...but it doesn't work....
|
| [2022-03-01 08:30:52] |
| |
|
Start with a very basic formula. You should not have any trouble with that study.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-03-03 07:32:36] |
| User278398 - Posts: 291 |
|
i try with simple formula, but i dont get full data... please check the pic i uploaded. i got only "last", second, it is not looking to a "bar" what i need to do to see it correctly ? regards. |
1.png| [2022-03-03 15:10:38] |
| John - SC Support - Posts: 38516 |
|
You need to set each of the Open/High/Low/Close to a different formula. Having them all be the same formula will give you the line as you see as they are all the same value.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2022-03-03 16:26:22] |
| Sawtooth - Posts: 4181 |
|
In order to capture the intrabar OHLC values of a 1 min bar's Volume, try this: 1. Duplicate your 1 min chart. - Change the Bar Duration to 0-0-1 (1 second) - Remove all studies except the Volume study. 2. On the 1 min chart, add the Study Overlay - OHLC study. - Set the 'Chart, Study, Subgraph Reference' to the 1 sec chart, Volume study, Volume (SG1). Study Overlay - OHLC (Open, High, Low, Close) |
| [2022-03-08 09:38:56] |
| User278398 - Posts: 291 |
|
i mange to work with the study overlay-ohlc and spread sheet (bar), BUT the values that i get from my formula (for example) are: 5-open,3-high,6-low,1-close but the chart price (for example) are: 20-open,22-high,19-low,21-close the spread sheet (bar) display me the values 5-open,3-high,6-low,1-close on the chart, at price level 5$,3$... which i dont want /// i want to see those values ( 5-open,3-high,6-low,1-close) on the "real" graph (20-open,22-high,19-low,21-close) //// for example, i want to see in 20-open of the real chart mark for my formula which is 5-open in 22-high of the real chart mark for my formula which is 3-high in 19-low of the real chart mark for my formula which is 6-low in 21-close of the real chart mark for my formula which is 1-close many thanks |
| [2022-03-08 13:55:14] |
| Sawtooth - Posts: 4181 |
|
It is unclear what you are doing, or want to do. The Study Overlay - OHLC study produces OHLC bars. Why are you also use the Spreadsheet Formula (Bar) study? |
| [2022-03-08 15:54:18] |
| User278398 - Posts: 291 |
|
thank u for your response. i attached pic which describe what i want to display (according to the example above)... which studies will do that ? thank you. |
| [2022-03-08 17:21:19] |
| Sawtooth - Posts: 4181 |
|
Do you want to display the Volume OHLC values at the price bar's OHLC prices?
|
| [2022-03-09 06:26:30] |
| User278398 - Posts: 291 |
|
yes (i want to display the volume in this example... but in regularly i want to display the value of formula i built by spreadsheet formula study) many thanks. |
| [2022-03-09 13:36:40] |
| Sawtooth - Posts: 4181 |
|
There is no native study that will do what you want. There is no DrawStyle that can place a value at a certain price. You would need to create a custom ACSIL study. |
| [2022-03-09 16:49:26] |
| User278398 - Posts: 291 |
|
study overlay OHLC cant help me with that (to see what i want on ohlc prices) ?
|
To post a message in this thread, you need to log in with your Sierra Chart account: