Login Page - Create Account

Support Board


Date/Time: Tue, 28 May 2024 02:37:12 +0000



Post From: Referencing Chart Drawings in a Spreadsheet Study

[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.