Login Page - Create Account

Support Board

Date/Time: Sat, 20 Jan 2018 13:19:39 +0000

[User Discussion] - Spreadsheet help

Support Request:
[2013-04-07 18:18:03]
N!co - Posts: 115

My knowledge of excel is very poor, so I hope someone is so kind to help me solve this problem,

I wish to create a spreadsheet for trading
I have one 1 indicator on the chart ( Swing High/Low )
and the rules are very simple

If a HIGHER LOW SWING LOW is found --> Place a PENDING SELLSTOP @ the LOW of this bar
If there after an other HIGHER SWING LOW is found --> Place a PENDING SELLSTOP @ the LOW of this bar
OR modify to the new entry value
filled orders are managed through the TradeWindow

(the reverse would be thue for long orders)

attached is a screenshot showing a few short entries

Date Time Of Last Edit: 2013-04-07 20:15:33
imageEURUSD 50 renko #1 41371.7619.png / V - Attached On 2013-04-07 18:17:55 UTC - Size: 113.49 KB - 155 views
[2013-04-09 01:20:40]
tomgilb - Posts: 1753
Your rules may seem simple, but actually coding it in a spreadsheet study requires more than you realize. You would need formulas in J22, J24 and J27, in addition to formulas in K3 and M3.

If this is something you want to pursue and are willing to pay for development, here is a programmer:

Date Time Of Last Edit: 2013-04-09 13:26:57

To post a message in this thread, you need to login with your Sierra Chart account:


Login Page - Create Account