Support Board
Date/Time: Fri, 24 Jan 2025 20:31:41 +0000
Placing order with spreadsheet study Excel
View Count: 758
| [2019-01-25 08:56:19] |
| User978290 - Posts: 25 |
|
Hi, Is there a way to automatically place order as the price, stop, close populates in a specific cells in excel? I couldn't find the open with "Use Excel" in "Spreadsheet System for Trading" setting like Spreadsheet study, but I would really like to get this system started. A screen of the order cells is attached. When price and stop pops up, send an attached order. When close pops up. Close the position. some basic functions like that. Is there a simple solution? or is a custom made option is needed? I tried migrating to the default spreadsheet but encounter some syntax errors =MAX(OFFSET(AW3,-AT3+MAX(OFFSET(BL3,-AT3+1,,):BL3),,):AW3) or Array Entered in excel =IF(AT3=1,"",IF(BL3=2,1,IF(NOT(ISNUMBER(BL3)),"",ROW()-1-MAX(IF(NOT(ISTEXT(OFFSET(BL2,-AT3+1,,):BL2)),ROW(OFFSET(BL2,-AT3+1,,):BL2)))))) I'm no coder, and confined to basic functions / vba in excel. I would really appreciate the help. Thank you. |
Order.png| [2019-01-28 00:35:08] |
| |
|
Excel is not supported for automated trading. It is just not reliable for that. It is not anything we would provide any help for. If you cannot accomplish what you need with Sierra Chart spreadsheet formulas, then you need to use ACSIL: Table of Contents | (Advanced Custom Study/System Interface and Language (ACSIL)) 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: