Login Page - Create Account

Support Board


Date/Time: Thu, 26 Dec 2024 16:28:10 +0000



Post From: Automated Bitcoin Trading based on Parabolic SAR

[2013-06-30 14:46:07]
User59357 - Posts: 15
Hi there,

I am quite new to Sierra Chart, and I am interested in it's automatic trading functionality
especially against MtGox.

I would like to use a trading system based on Parabolic SAR for the beginning.
I have setup the Bitcoin DataStream and Parabolic SAR as indicator plus a Spreadsheet System for trading. How may I generate trade signals which will be automatically executed against MtGox via the trading spreadsheet?

The idea is something like:

Buy Entry:
PSAR CROSSFROMBELOW
Buy @ Market
Quantity: 10000
TimeInForce: Good till Canceled

---

Sell Entry:
PSAR CROSSFROMABOVE
Sell @ Market
Quantity: 10000
TimeInForce: Good till Canceled

The Parabolic SAR Indicator writes its values at: AD3
So I wrote this small formula to get the BUY / SELL Entries (TRUE or FALSE) values at K3 and M3:

Buy Entry:
=AND(AD4>E4,E3>AD3) (High compared with PSAR Values)

Sell Entry:
=AND(AD4<E4,E3<AD3) (Low compared with PSAR Values)

The spreadsheet indicates the error message: "Invalid Formula"
I assume it should return "True" or "False" in this case.
I would like to locate the SAR changing point as BUY / SELL Entry.

P.s. the manual trading from the chart is already working.

Thank you in advance!

Date Time Of Last Edit: 2013-07-09 13:22:39