Support Board
Date/Time: Mon, 23 Dec 2024 15:39:46 +0000
Excel questions
View Count: 1229
| [2015-10-05 16:19:22] |
| User707727 - Posts: 7 |
|
Hi, I see on your website that you will remove the Excel interface in 2016. Do you know when? Will you give notice? I use the Excel interface extensively for calculations. If I switch to Sierra Chart spreadsheets, will it be possible to read a data cell (single Boolean) in a Sierra Chart spreadsheet from an Excel spreadsheet? For me, this is essential. Many thanks.
|
| [2015-10-05 18:15:34] |
| |
|
No definite decision has been made about this. If Excel spreadsheet support is removed, it will not be possible to read Excel spreadsheets. 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 |
| [2015-10-05 18:35:44] |
| User707727 - Posts: 7 |
|
OK, thank you for the reply. Just to clarify: if you drop the Excel interface, I will not want to read from Excel spreadsheets, I want to read from a Sierra Chart spreadsheet into an Excel spreadsheet. ie. I wish to run an Excel spreadsheet at the same time as the SC spreadsheet and read data (Boolean) from the Sierra Chart spreadsheet into the Excel sheet. I presume you are saying that this would not be possible ??? (My bespoke execution engine works only in Excel, so I cannot transfer everything into Sierra Chart spreadsheets.) For me, it would be a massive blow to drop the Excel interface. What you provide now works for me very well. I am building a complex trading structure around this so the uncertainty is deeply concerning. Do you know when a decision is due? Many thanks. |
| [2015-10-06 09:25:26] |
| |
|
For me, it would be a massive blow to drop the Excel interface. What you provide now works for me very well. I am building a complex trading structure around this so the uncertainty is deeply concerning. Do you know when a decision is due?
Since there is this kind of reliance, we will keep the Excel interface. The primary reason for our comment was to avoid reliance by future users in order to keep the reliance on the Excel interface to a minimum. Would it be possible to write a simple script using VB in the Excel spreadsheet that reads from a file and write the necessary data that you require to a file using an ACSIL study in Sierra Chart? If this is not clear, we can provide more details. 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 Date Time Of Last Edit: 2015-10-07 20:32:14
|
| [2015-10-06 11:20:41] |
| User707727 - Posts: 7 |
|
Thank you for the answer. It is a relief to hear that you will keep the Excel interface. What you suggest may be possible. My programming experience is principally VB although I have many years of trading experience. I have been reading your documentation to discover what is possible, but any guidance you can provide would be welcome. Question: I have a bespoke Excel add-in which sends orders to my broker when given triggers from within the spreadsheet. Importing data to the Excel spreadsheet enables me to run automatic strategies. Ultimately, it may be possible to replicate all the functionality within Sierra Chart, thus avoiding Excel. I am pleased to see that you have a function for moving stops to breakeven (+ offset) when a target is reached and I assume it is possible to achieve this via automated spreadsheet trading. For my strategy, I need to have multiple trades in the same direction up to a limit (which I see is possible), but, beneath the limit, once it has done one trade I need it to prevent the next trade until the breakeven target of the first trade has been reached (and its stop moved to breakeven +/- offset). ie. Each subsequent trade needs to be prevented until the previous one is "safe". Is this possible? |
| [2015-10-07 20:35:08] |
| |
|
I have a bespoke Excel add-in which sends orders to my broker when given triggers from within the spreadsheet. Importing data to the Excel spreadsheet enables me to run automatic strategies. Ultimately, it may be possible to replicate all the functionality within Sierra Chart, thus avoiding Excel. Yes, this is definitely possible and is always going to be the most reliable. Who is the broker/trading service? I am pleased to see that you have a function for moving stops to breakeven (+ offset) when a target is reached and I assume it is possible to achieve this via automated spreadsheet trading
Yes it is. For my strategy, I need to have multiple trades in the same direction up to a limit (which I see is possible), but, beneath the limit, once it has done one trade I need it to prevent the next trade until the breakeven target of the first trade has been reached (and its stop moved to breakeven +/- offset). ie. Each subsequent trade needs to be prevented until the previous one is "safe". Is this possible?
Yes this is possible but probably is tricky to do with the Spreadsheet Trading study. Certainly using the Advanced Custom Study Interface and Language would be more straightforward to do this kind of logic. 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 Date Time Of Last Edit: 2015-10-07 20:36:06
|
| [2015-10-08 08:21:29] |
| User707727 - Posts: 7 |
|
My broker is LMAX. I guess I need to study the docs on ACSIL! Thanks. |
To post a message in this thread, you need to log in with your Sierra Chart account: