Support Board
Date/Time: Tue, 06 Jan 2026 22:17:27 +0000
Post From: TPO profile chart and spreadsheet system for trading
| [2025-11-20 15:39:32] |
| John - SC Support - Posts: 43819 |
|
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 |