Support Board
Date/Time: Sun, 22 Dec 2024 16:21:38 +0000
spreadsheet for trading
View Count: 934
| [2015-01-29 00:48:19] |
| jimnovak - Posts: 42 |
|
hi is it possible to use a spreadsheet to perform a very simple order placement task? say price currently is 1.75 and i want to buy at 1.25. if i place a regular limit order, entry is made as soon as the price hits 1.25. now i dont want that. i want to buy at 1.25 only when the price has fallen below 1.25 and is on its way up and enter the trade then. i can currently do that with a buystop order but price has to be below 1.25 for it to work. i basically want to be able to set a trade as explained at prices higher than 1.25. any help to put me in the right direction is appreciated. attached is a link to a chart with an example scenario explained visually. http://www.sierrachart.com/image.php?l=14224920554.png regards |
| [2015-01-29 02:26:05] |
| jimnovak - Posts: 42 |
|
just to let you know that ive used crossfrombelow for this but it dont seem to work. so in column K(buy entry) i write =crossfrombelow(E3,1.25) where 1.25 is a hard coded number. i understand this is pretty juvenile but was a try that not surprisingly didnt work. and same for exits. |
| [2015-01-29 13:58:10] |
| jimnovak - Posts: 42 |
|
ive put the buy value in column P, and it fills it down i assume correctly. formula i use in column K is =CROSSFROMBELOW(E3:E4,P3:P4) now. although initially seemed to trigger off correctly after a few more realistic tests, this doesnt seem to work either. |
| [2015-01-29 18:02:34] |
| |
|
is it possible to use a spreadsheet to perform a very simple order placement task?
Yes.We do not provide automated trading system formula help or debugging. It is not within the scope of our support. We can only refer you to the documentation here: http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php 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-01-29 18:04:05
|
| [2015-01-29 18:06:23] |
| |
|
It also sounds like you will need to use a stop order and you can control the order types through these cells: http://www.sierrachart.com/index.php?page=doc/doc_SystemsAlerts.php#BuyEntryLimit 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: