Support Board
Date/Time: Mon, 25 Nov 2024 02:02:46 +0000
[User Discussion] - Spreadsheet for Trading Fails to Generate Trades and Alerts
View Count: 1387
| [2014-01-05 09:53:25] |
| djcurcio - Posts: 236 |
|
I built an Alert spreadsheet using the SuperTrend study. It plots the entry and exit bars and generates the alerts (columns k-n) correctly. I then built a new chart book but this time with the Trading Spreadsheet using the same settings as the Alert spreadsheet. I set J26 to 1. I then run a chart replay to test the system and it only paints the bars but does not generate any orders or alert sounds. Help please. |
| [2014-01-05 12:15:11] |
| TechTrader - Posts: 116 |
|
Check "Trade>Auto Trading Enabled"
|
| [2014-01-05 23:02:37] |
| djcurcio - Posts: 236 |
|
much thanks - it worked.
|
| [2014-01-06 01:40:54] |
| djcurcio - Posts: 236 |
|
Is there a way to modify the spreadsheet study using the SuperTrend so that I can: 1. Manually enter and or exit a trade within a trend segment and then let the SuperTrend study manage the position? 2. Have a user Trade Go/No-Go button object that would be activated by the SuperTrend when it detects and entry / exit? Sort of a gray box auto trader? Thanks |
| [2014-01-06 20:42:32] |
| Sawtooth - Posts: 4120 |
|
1) The spreadsheet study can manage its own entry, or your manual entry. Not sure what you mean when you say you want to manage a trade that is exited. 2) You could put a y/n in a non-updating cell (e.g. any cell in column H) and have the entry/exit formulas reference that cell (H1="y"). You could also use a cell in a standalone spreadsheet. |
| [2014-01-07 13:00:23] |
| djcurcio - Posts: 236 |
|
What I was trying to say is: If I turn on auto trade - SuperTrend generates many trades - so I would want it to give me the opportunity to say Yes or No to taking the trade SuperTrend generated. If I modify the cells K3 and M3 where the SuperTrend are set to have a Switch (something such as =and(AND(EB4>E4,E3>EB4,H1=y)) then this blocks the SuperTrend signals that would still prefer to see regardless of my taking the trade. So what I am looking for is how to let SuperTrend still generate the signals but to have control on taking the trade. |
| [2014-01-07 13:52:29] |
| Sawtooth - Posts: 4120 |
|
Separate the arrows from the entry signals. For example (Buy Entry): K3: =AND(O3>0,$H$1="y") O3: =IF(AND(EB4>E4,E3>EB4),D3,0) Set the Draw Style of SG1 to Hidden, and SG5 to Arrow Up. |
To post a message in this thread, you need to log in with your Sierra Chart account: