Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 13 May 2024 02:07:04 +0000
Post From: Referencing if a position is open on any symbol/different spreadsheets/chartbooks?
| [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! |