Support Board
Date/Time: Fri, 24 Jan 2025 20:28:37 +0000
Post From: Placing order with spreadsheet study Excel
| [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