Support Board
Date/Time: Sat, 18 Jan 2025 19:23:39 +0000
[Programming Help] - spreadsheet trading question
View Count: 1895
| [2018-02-16 20:58:06] |
| Glenn Infinity - Posts: 103 |
|
Is it possible to generate a "Buy Entry"/"Sell Entry" on a specific price as defined by cell K3/M3? For example I'm interested in entering on the price 5 ticks below the Moving Average Cross. |
| [2018-02-17 00:21:32] |
| Sawtooth - Posts: 4154 |
|
To place Limit entries 5 ticks below/above Close price at the signal of a MA crossover in K3 or M3, try this: 1. Find the MA crossover in K3 and M3, and use it for the entry signals: =CROSSFROMBELOW(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4) =CROSSFROMABOVE(ID1.SG1@3:ID1.SG1@4,ID2.SG1@3:ID2.SG1@4) where the ID#s of the MAs are ID1 and ID2, and ID1 is the faster MA; edit as needed. 2. Return the Close price of the faster MA at the crossover: -Put this in J22: =IF(K3,ID1.SG1@4-5*J21,0) Put this in J24: =IF(M3,ID1.SG1@4+5*J21,0) -Set J71 and J73 to L |
| [2018-02-18 13:51:53] |
| User241198 - Posts: 6 |
|
This is the condition I'm interested in. Is it possible to send an order to the market that is a "Stop-Fill?" For example, where a Limit-Buy-Stop order is sent 5 ticks above the current price OR a Limit-Sell-Stop order is sent 5 ticks below the current price. If the market reverses and moves away from that limit order, is it possible to cancel that with an Exit Buy/Sell condition? |
| [2018-02-18 14:19:13] |
| Sawtooth - Posts: 4154 |
|
The entry orders in that case would be called a Buy Stop or Sell Stop. Use this instead: 2. Return the Close price of the faster MA at the crossover: -Put this in J22: =IF(K3,ID1.SG1@4+5*J21,0) Put this in J24: =IF(M3,ID1.SG1@4-5*J21,0) -Set J71 and J73 to S |
| [2018-02-20 13:43:38] |
| Glenn Infinity - Posts: 103 |
|
the column "J" rows he referenced are not on the TA spreadsheet, J22, J24, J71 and J73. What do I need to do to get those cells functioning? |
| [2018-02-20 13:50:22] |
| Sawtooth - Posts: 4154 |
|
Those cells are only used in the Spreadsheet System for Trading study.
|
| [2018-02-20 14:33:56] |
| Glenn Infinity - Posts: 103 |
|
thank you!
|
| [2018-02-21 18:51:59] |
| Glenn Infinity - Posts: 103 |
|
Here's my issue, In a Spreadsheet in Cells J63 & J64 I am unable to Save a "True" (1) value in those cells. I can make the change in the spreadsheet and then do a "Ctrl-S" but when I exit and return or I run a back test the values change to "False" (0) and my backtest fails.
|
| [2018-02-21 20:43:51] |
| Sawtooth - Posts: 4154 |
|
Those are read only output values from the spreadsheet study settings and cannot be edited on the spreadsheet sheet. Set those values in the spreadsheet study settings. |
To post a message in this thread, you need to log in with your Sierra Chart account: