Support Board
Date/Time: Mon, 05 Jan 2026 04:13:17 +0000
TPO profile chart and spreadsheet system for trading
View Count: 222
| [2025-11-19 13:08:51] |
| Fabio - Posts: 136 |
|
Hello SC! I have a question that I couldn't find an answer to. I have the TPO profile and a spreadsheet system for trading studies applied to the same chart. On the TPO subgraph section there are also the inputs related to the "value area extension lines (SG16)" with the option to be included in the spreadsheet (tick box below the list of subgraph options). However, toggling on or off this option, doesn't make them visible in the spreadsheet. Am I missing something? Look forward to hearing back from you. Thanks in advance, Fabio. |
| [2025-11-19 16:11:39] |
| John - SC Support - Posts: 43722 |
|
Extension lines are not stored as a Subgraph, so they can not be accessed in a Spreadsheet. The purpose of that Subgraph is to allow you to change the color and width of the lines. The only way to get the value of the Value Area Lines would be to use the "TPO Value Area Lines" study. This would need to be on a separate chart, however, as you can not apply this study to a chart with a TPO on it. You can use the "Study/Price Overlay" to get the lines to the TPO chart in order to get the value into the Spreadsheet study. Refer to the following: TPO Value Area Lines Study/Price Overlay Study For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-20 08:53:48] |
| Fabio - Posts: 136 |
|
Hey John thanks for the info. I have a problem with the TPO value area lines though. What if I want to merge, or split, a profile? The study applied to another chart won't recognise the "new" value area (or value area lines). Is there a way you can think of that would help me solve the problem and let the spreadsheet recognise the value area? For example, can I use a drawing tool, say, an extending rectangle, and map the edges of it onto the spreadsheet? If so, what's the best way for doing that? Thanks, Fabio. Date Time Of Last Edit: 2025-11-20 10:55:25
|
| [2025-11-20 15:39:32] |
| John - SC Support - Posts: 43722 |
|
The best solution would be to create a custom study to access the Value Area values and then have them in a subgraph for the Spreadsheet to access. Refer to the following: ACSIL Interface Members - Functions: sc.GetStudyProfileInformation https://www.sierrachart.com/index.php?page=doc/SierraChartStudyAndSystemProgrammers.php But, there is a way to do what you are suggesting, and truthfully we never considered what you are thinking. Here is what you can do. - Draw the Rectangle such that it is covering the Value Area. - Use to copies of the "Spreadsheet Formula" study to access the anchor points of the rectangle, which will then give you the Value Area High and Value Area Low prices. - You can then access those prices in the Spreadsheet which will display the results of the Spreadsheet Formula studies. In order to get the information into the Spreadsheet Formula, you need to enter a formula like the following: =UDID[4].A1 Where the number 4 is the ID of the Rectangle and A1 is the first anchor point. Refer to the following: Study/Chart Alerts And Scanning: Reference by Anchor Keep in mind you will need to do this for each anchor, so the second Spreadsheet Formula would have a formula like the following: =UDID[4].A2 The advantage to this is that all you would need to do is adjust the rectangle for the particular TPO, and the data will update in the spreadsheet. Do not delete the drawing and redo it - if you do this you will get a different UDID, in which case you will need to update your studies. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2025-11-26 09:21:27] |
| Fabio - Posts: 136 |
|
Hey John, thanks for the heads up. The solution you suggested me works exactly as I wanted. I was able to map the edges of the "custom" value area using the extended rectangle and mapping A1 and A2 using 2 different spreadsheet formula studies with the suggested formula. It works beautifully. A little tricky to set them up with formulas and all, but eventually it does its job just fine. Maybe I can suggest you guys to implement the value area lines (or simply price whatever it's easier) in a way that can be "seen" directly on the spreadsheet as it does for the OHLC prices? I am not a programmer so from this side it looks easier to be implemented :) Now I have another question: I have the ATR study on the TPO profile chart that I also want to implement in the spreadsheet, however, I noticed that regardless the input chosen (both Moving Average Type and Length within the ATR settings) the ATR calculation does not really change based on those variables. I can choose an MA length of 1 or 7 (let's say) but the outcome remains about the same. I tried the normalised ATR as well, but this seems to show a completely "off" calculation, like 0.50 for the ES. Can you please tell me if I am doing something wrong? It looks I cannot get it wrong because there are just 2 inputs but hey, maybe I am missing something... Thanks for the help! |
| [2025-11-26 14:32:09] |
| John - SC Support - Posts: 43722 |
|
You can not use the ATR study on the TPO chart. Refer to the following: Time Price Opportunity (TPO) Profile Charts: Using Other Studies on a TPO Chart You would need to use the ATR on a non-TPO chart and then you can use the Study/Price Overlay to put that information into the TPO chart. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: