Login Page - Create Account

Support Board


Date/Time: Wed, 15 Jan 2025 18:52:57 +0000



Post From: Help with Spreadsheet trading study.

[2017-08-06 12:07:56]
fjgaspar - Posts: 62
Hi,

I am trying to initiate in begin to automated trading with spreadsheets, and I don't know well where to start. I have read de documentation, but I don't know how to do simple things. As when I have studied other programming languages, I try to start by a simple 'hello word', so I am trying to do a kind of simple hello word without success (not even know where to begin).

Very simple thing: a chart in an 8 tick range. If a bar is green (i.e. close > open), buy a limit order at high (when the follow bar begins, I mean, when you have the confirmation that the previous bar was green) if no position open. If short position is open, close the position and put a buy limit order at that price. When a bar is red (i.e close < open), if a long position is open, close the long and put a limit sell order at low of red bar.

If a limit order doens't executes when the current bar finishes, cancel it.

Anyone can help me with the formulas to wrrite in Buy entry, buy exit, sell entry and sell exit?

Thanks