Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 28 Apr 2024 11:28:30 +0000
Referencing if a position is open on any symbol/different spreadsheets/chartbooks?
View Count: 1134
| [2017-06-04 23:16:27] |
| tunah - Posts: 16 |
|
I thought of doing this by referencing other spreadsheets, as I like to have a chartbook per symbol with it's own spreadsheet. After searching I found that SC used to include this functionality but it's been phased out when SC changed to it's own spreadsheet functionality from former .net. Is there a way one can reference if a position is open on another/any symbol which is in a different chartbook? Does the Trading: Position Study check for open positions only on the chart in which it is added, or does it check if there are any open positions over all? I did a search on the study but it seems you guys don't have any literature on this study in particular. Also would be great to be able to programmatically change the order type( columns J71-74 ), currently I use separate sheets(within a spreadsheet) for this. Thanks in advance. Date Time Of Last Edit: 2017-06-04 23:16:44
|
| [2017-06-05 18:30:00] |
| |
|
You can add the Spreadsheet System for Trading study to each symbol you want to monitor the Trade Position Quantity for when using Spreadsheets. Just make sure you use the same Spreadsheet for each instance of that study and that each instance of the study is outputting data to a different Sheet. All of this is supported. You can then use standard cell references between Sheets. You can programmatically change the order type. Just write a formula using the IF function which returns the order type letter code. 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 |
| [2017-06-05 20:47:18] |
| tunah - Posts: 16 |
|
>>>You can add the Spreadsheet System for Trading study to each symbol you want to monitor the Trade Position Quantity for when using Spreadsheets.<<< That's what I'm doing >>>Just make sure you use the same Spreadsheet for each instance of that study and that each instance of the study is outputting data to a different Sheet. All of this is supported.<<< I'm doing this as well ***>>>You can then use standard cell references between Sheets.<<<*** This is in line with my question. What I would like to do is reference if a position is open across different *Spreadsheets and chartbooks(not just between sheets within a spreadsheet). I organize my space by having a distinct chartbook and distinct spreadsheet/Spreadsheet System for Trading per symbol, and each spreadsheet within that chartbook may have various sheets within it, with various instances of the Spreadsheet System for Trading study outputting to each of the different sheets. So I may have chartbook A and it's own Spreadsheet on the S&P, and chartbook B and it's own Spreadsheet for the Nasdaq for example, and I want chartbook A(S&P)/Spreadsheet A to check if there's a position open on chartbook B(Nasdaq)/Spreadsheet B and vice versa. SC used to have the functionality of being able to reference across different Spreadsheets but you guys omitted it when you guys replaced the old .net spreadsheet component. If it is no longer possible to reference information across different spreadsheets, Is there a way to access the position information on the Trade and Open Positions log? I know I can add different symbols to a chartbook and use sheets within a spreadsheet to accomplish this, but I may have many sheets as part of the instances of the Spreadsheet System for Trading for a single symbol(don't worry they're not conflicting as it's mainly different entries, with different trading times(J85-87) while the management is handled with attached orders). So you can see if I start adding symbols to chartbook and using the same Spreadsheet for all symbols, how the Spreadsheet could get pretty lengthy. So in short I was just wondering if there was still a way to reference difference Spreadsheets or if there was any other way to access position information, through the Trade and Open Positions log maybe? >>> You can programmatically change the order type. Just write a formula using the IF function which returns the order type letter code.<<< Tried that a few times and it didn't work, for example when I enter the following =IF(ID6.SG1@3 > 0, L, M) I get a #NAME? error Thanks! |
| [2017-06-07 07:37:35] |
| |
|
Is there a way to access the position information on the Trade and Open Positions log? Yes, this can be done by using ACSIL.Correction: =IF(ID6.SG1@3 > 0, "L", "M") 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 |
| [2017-06-08 01:36:32] |
| tunah - Posts: 16 |
|
Great! thanks! I suspected I would have to delve into ACSIL sooner or later, that said I've been able to do almost everything I need with Spreadsheets, with the exception of some custom indicators I coded on another platform/language. Thanks for the correction! The more I use SC the more I think this is a fantastic platform, and your Spreadsheet implementation is better than any "wizard" type of interface. |
| [2017-06-09 00:37:52] |
| |
|
The more I use SC the more I think this is a fantastic platform, and your Spreadsheet implementation is better than any "wizard" type of interface. 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: