Login Page - Create Account

Support Board


Date/Time: Thu, 25 Apr 2024 14:45:56 +0000



[User Discussion] - Spreadsheet help

View Count: 1991

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

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

Short:
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
AND DELETE previous PENDING SELLSTOP order
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 - 773 views
[2013-04-09 01:20:40]
Sawtooth - Posts: 3976
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:
www.sawtoothtrade.com

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

Login Page - Create Account