Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 22:49:36 +0000



Referencing Chart Drawings in a Spreadsheet Study

View Count: 1388

[2019-07-08 12:04:23]
User247273 - Posts: 37
What I'm trying to achieve is to display the value of a chart drawing in a cell on a spreadsheet study. I thought using the formula =UDID[#].A# might work, but it didn't. Is there a way for me to acocmplish this? If not, is it something you might add in the future? If that's unliikely, could you tell me if its the kind of thing a developer could accomplish with some custom programming?

By way of context, my end goal is this:
I have values from various study subgraphs on worksheets for the charts they're plotted on. I also have a lot of drawings whose values I'd like to see in relation to those various subgraphs. Ideally, I'd like to create a worksheet where I can coalate (and possibly sort) those references to give me an overview of how they all relate to one another. Seemingly that would mean a column of simple formulas that might look something like the one below, but I get the feeling it's not that simple.

=Sheet12!AA3
=Sheet20!BC3
=UDID[321].A1
=UDID[321].A2
=Sheet17!AM3
etc.
[2019-07-08 18:38:21]
Sierra Chart Engineering - Posts: 104368
This is not supported.

If that's unliikely, could you tell me if its the kind of thing a developer could accomplish with some custom programming?
Yes because ACSIL can access Chart Drawings and can also interact with cells on a Spreadsheet.
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

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account