Login Page - Create Account

Support Board


Date/Time: Tue, 13 May 2025 06:17:37 +0000



Post From: Building a spreadsheet trading system

[2017-04-05 00:55:21]
Goldsea - Posts: 13
Hi!

I have build a spreadsheet trading system in excel, I would like to do this within the spreadsheet in Sierra Charts with the objective of forward testing and eventually have it executed by my trading service.

The backtest result looks promising so I like to simulate it real-time. Based on the open, high, low and close 1 minute data, my strategy will run some calculations to output some binary buy/sell orders.

To do this, I would need the data to be coming in real-time to the spreadsheet and constantly adding as the time passes. I was wondering how I could achieve this with the Sierra Chart spreadsheet.