Support Board
Date/Time: Wed, 27 Nov 2024 16:48:08 +0000
[User Discussion] - Referencing (ln:83) in Spreadsheet Formula Study
View Count: 1163
| [2023-06-06 00:48:37] |
| User486817 - Posts: 83 |
|
hello, within the VbP study, is it possible to reference ex. (ln:83 or any other) in a spreadsheet formula? if so, how is this accomplished? as it says (ln:83) and not IDx.SGy can you give an example of the syntax used to access this information? kindest regards, |
| [2023-06-06 02:20:52] |
| j4ytr4der_ - Posts: 938 |
|
As far as I know you can only access data that is exposed in a Subgraph. This might not be the case if you are coding something in ACSIL, but I'm reasonably confident it is the case from a spreadsheet or study.
|
| [2023-06-06 03:33:33] |
| Sawtooth - Posts: 4120 |
|
If you want to know what a study outputs, add the Spreadsheet Study study, and look in columns AA and above. In a spreadsheet or Alert formula, you would only be able to reference what is output. |
| [2023-06-06 07:10:35] |
| User486817 - Posts: 83 |
|
hello tomglib, thank you for the replies. i have up USDJPY 30 min chart with the default ficksize. the first study i've applied to the chart is VbP set to 1 week, and the second study Spreadsheet Study. i've set the spreadsheet study to output volume data. on the USDJPY chart, the POC is 140.115, and the POC volume is listed at 3885 lots. my question is, where is this 3885 lots listed on the spreadsheet? ID1.SG2 shows up in the spreadsheet, and it gives price data only. i'm looking for the actual cell where the POC volume value rests. is it on there and i'm missing it? kindest regards, |
| [2023-06-06 16:37:54] |
| Sawtooth - Posts: 4120 |
|
When you set 'Output Volume At Price Data' to Yes, the VAP values appear in columns BC and above. However, since each spreadsheet row is a price bar, the VAP values are horizontal for each bar, not vertical. This makes it difficult to isolate a certain volume with a formula. What are you trying to do? |
| [2023-06-07 00:54:05] |
| User486817 - Posts: 83 |
|
hi tomglib, thank you for your reply. basically, i'm trying to do two things: 1) find and isolate the POC Volume Value and 2) find and isolate the current tick volume value so they can be referenced in a formula. is this possible? thanks again tomglib for taking your time to help me. kindest regards, |
| [2023-06-07 02:00:02] |
| Sawtooth - Posts: 4120 |
|
basically, i'm trying to do two things: 1) find and isolate the POC Volume Value and 2) find and isolate the current tick volume value so they can be referenced in a formula. is this possible?
Maybe. If it is, the solution is in the details, and more than can be offered in a forum post.
|
| [2023-06-07 02:08:29] |
| User486817 - Posts: 83 |
|
hi tomglib, thank you for your reply. i can accept that answer. i think i'm at a point where i need to take time and learn how to program in ASCIL so i can do more of the things i want to do with SC. thanks again tomglib. kindest regards, |
| [2023-08-01 09:45:22] |
| ManuelEmanuel - Posts: 7 |
|
Hi User486817, I wanna say you can access data beyond what is exposed in a Subgraph. I just mean while coding in ACSIL might provide additional capabilities, it's not the only way to access more data. In a spreadsheet or study, you can indeed access data beyond what the Subgraph exposes. For instance, if you want to know what a study outputs, you can add the Spreadsheet Study study and look in columns AA and above, as it is mentioned above. However, it's essential to note that you are not limited to just what is output in a study when using spreadsheets or Alert formulas. Besides that I highly recommend you to try this source https://edubirdie.com/essay-writers-for-hire because I have already been using it for many years (since college) and it really helps me a lot. With the help of these guys you can hire essay writer and do any kind of writing. In these environments, you have the ability to reference and work with data beyond the study outputs. I like it 'cause this allows for more flexibility and advanced data analysis in my trading strategies or other financial applications. So, you can also leverage the power of spreadsheets and formulas to access and process additional data beyond the confines of the Subgraph. I hope this helps. Cheers, Manuel Date Time Of Last Edit: 2023-08-02 16:08:51
|
| [2023-08-01 11:47:39] |
| j4ytr4der_ - Posts: 938 |
|
Manuel, can you elaborate on what you mean here? Looking at the columns in a spreadsheet, is literally just looking at the subgraph outputs. I'm not sure what you mean by seeing anything "beyond the study outputs" but if there's something I'm overlooking I'd sure like to know about it.
Date Time Of Last Edit: 2023-08-03 01:32:44
|
| [2023-08-03 01:33:23] |
| j4ytr4der_ - Posts: 938 |
|
oh FFS you're a spammer? Really?
|
To post a message in this thread, you need to log in with your Sierra Chart account: