Support Board
Date/Time: Fri, 29 Nov 2024 18:43:50 +0000
Show chart study value in quote spreadsheet
View Count: 446
| [2023-01-18 07:40:24] |
| donnicky - Posts: 33 |
|
Hello! In quote spreadsheet is there some formula to get study value from some opened chart with this study added? |
| [2023-01-18 15:18:49] |
| John - SC Support - Posts: 36350 |
|
Sorry, but we are not understanding the question. What is the study you are wanting to get the value from? What exactly do you want to do with the Quote Spreadsheet?
For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2023-01-18 15:34:28] |
| donnicky - Posts: 33 |
|
Please, look at the attachment. In this example I would like to have last MACD subgraph value in quote spreadsheet column and ask if such formula is possible. Or perhaps any other way to accomplish this? If no existing function of this kind can I write custom function?
|
 2023-01-18_18-30-53_3143591b-c8b7-4c4b-9a05-99f87b443ef3.png / V - Attached On 2023-01-18 15:31:22 UTC - Size: 99.72 KB - 97 views |
| [2023-01-18 16:56:37] |
| John - SC Support - Posts: 36350 |
|
It can be done, but you have to be very careful. The basic idea is to open the Quote Spreadsheet first and save that chartbook (when you save the Chartbook, the system will ask to save the Spreadsheet) and then you will use that Spreadsheet with a different sheet, to get the data for the MACD. The following link gives the instructions for how to open multiple sheets that reference different charts. You want to start by opening and saving the Quote Board for Spreadsheet and then adding the Spreadsheet Study. Working with Spreadsheets: References to Other Spreadsheets Windows With regards to the ACSIL question - yes, you can use ACSIL to get and set data in the Quote Board Spreadsheet, as it is like any other spreadsheet. But you can not do those functions within the Spreadsheet, you need to create a custom study. Refer to the information here: How to Build an Advanced Custom Study from Source Code 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: