Support Board
Date/Time: Thu, 16 Jan 2025 22:14:50 +0000
Maximum one position across multiples of the same trading system
View Count: 1087
| [2017-11-18 11:46:03] |
| User515865 - Posts: 2 |
|
Hello I have two seperate questions Firstly, I have a spreadsheet system for trading that I am currently using on the EUR/USD. I was wondering if there was a simple way to use the same spreadsheet system with other currency pairs like USD/CHF, EUR/GBP, USD/GBP etc... all on LMAX without having to create a new spreadsheet for each symbol/chart and copy paste the spreadsheet settings for entries and exits etc.. Secondly, once I have the spreadsheet system set up for several symbols/currency pairs,would it be possible that the system only goes long if there is not a long position already. I know that there is the setting allow multiple entries in same direction within one spreadsheet. What I am looking for is for exmaple that when Im long with the system for EUR/USD, That the other system for e.g. USD/CHF does not go long because I am already long in EUR/USD. I hope you understand my two issues, feel free to ask if the question is unclear. Many many thanks for your help Date Time Of Last Edit: 2017-11-18 11:50:15
|
| [2017-11-18 23:46:00] |
| |
|
1. This is documented here: Spreadsheet Studies Special Tasks: Applying Configured Spreadsheet Study on Other Charts 2. Make sure that all of your trading systems are contained within the same Spreadsheet but use different Sheets. You can then use references to their Position Quantity cells to prevent a trade in the others. Refer to: Spreadsheet Systems, Alerts and Automated Trading: Position Quantity [J5 or J8] Working with Spreadsheets: Cell and Range References 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-11-19 14:18:58] |
| User515865 - Posts: 2 |
|
Thank you very much. I was now able to set up my single spreadsheet system for several charts using several different sheets. However, I then tried to reference other Sheets using for example Sheet2!J5 it did not work properly. All the other sheets seem to copy the reference from sheet1. So the Sheet2!J5 > 0 setting from Sheet1 also appears in Sheet 2. So I cant use references to other sheets Position Quantity cells to prevent a trade in the others. Below is a small graphical explanation: What it should look like: Sheet1 -> Sheet2!J5, Sheet2 -> Sheet1!J5 What it actually looks like: Sheet1 -> Sheet2!J5, Sheet2 -> Sheet2!J5 Great Thanks you for your help. |
| [2017-11-20 15:07:50] |
| |
|
The explanation and solution to this problem is documented with Formula Source Sheet Number: Spreadsheet Study Inputs: Formula Source Sheet Number 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: