Login Page - Create Account

Support Board

Date/Time: Fri, 29 Sep 2023 00:43:30 +0000

[User Discussion] - Spreadsheet help

View Count: 1798

[2013-04-07 18:18:03]
N!co - Posts: 140

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 - 709 views
[2013-04-09 01:20:40]
Sawtooth - Posts: 3776
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 log in with your Sierra Chart account:


Login Page - Create Account