Problems with spreadsheet automated trading in Sierra Chart - Sierra Chart | futures trading

Go Back

> Futures Trading, News, Charts and Platforms > Platforms and Indicators > Sierra Chart

Problems with spreadsheet automated trading in Sierra Chart
Started:November 15th, 2014 (07:48 PM) by jcartru1974 Views / Replies:757 / 1
Last Reply:November 16th, 2014 (04:02 PM) Attachments:0

Welcome to

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.

You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Thread Tools Search this Thread

Problems with spreadsheet automated trading in Sierra Chart

Old November 15th, 2014, 07:48 PM   #1 (permalink)
Trading Apprentice
Sioux Falls SD/US
Futures Experience: Beginner
Platform: Sierra Chart
Favorite Futures: Futures
Posts: 3 since Nov 2014
Thanks: 2 given, 0 received

Problems with spreadsheet automated trading in Sierra Chart

I am interested in developing an automated trading system based on the Sierra Chart program.
In fact I have developed an strategy but I am not able of backtesting it. And here come my problems.
I set up my CLZ4 chart that include the spreadsheet study for trading with all the study settings set to No or default except for Signal Only on bar close (Column K,M). For the rest of the symbols I just duplicated the first set of studied and changed the symbol and range values, since I use range bars.
I ran the back test for the CLZ4 chart, and the signals for buy entry and sell entry that I set in the spreadsheet worked beautifully. BUT when I come to the rest of the charts the system does only read the sell entries. So I only have results for the short entries not the long ones.
I am not sure of the possible cause but I could be something related to the following
I see Prior position quantity read only (-1)
I am pretty sure it could have something to do with it recognizing an existing position, and because no order can be let in if there is already a position in, it does not allow me to buy anything.
Could anybody let me know, how could I avoid this mistake in the program?
Probably I am doing something wrong, but I don't know how to solve it.
Any help will be appreciated.

Reply With Quote

Old November 16th, 2014, 04:02 PM   #2 (permalink)
Elite Member
Phoenix AZ USA
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM ES
Posts: 262 since Nov 2009
Thanks: 121 given, 283 received

If your formulas are referencing any 'write' cells in column J, or any cell in column H, those values/formulas are not automatically copied to other sheets when duplicating a chart with a spreadsheet study. Further complicating the issue when duplicating a chart is that the Formula Source Sheet Number in the spreadsheet study's settings does not follow the new chart number (although this could be an advantage depending on how you want to configure the system).

The solution might be as simple as copying J and H formulas/values to all of the other sheets, but one way to keep things straightforward is to set the Formula Source Sheet Number of each spreadsheet study so that it matches the chart number it is applied to. Then copy/paste all of the formulas to each sheet so that there is complete separation between charts and their sheets.

Reply With Quote
The following user says Thank You to tomgilb for this post:

Reply > Futures Trading, News, Charts and Platforms > Platforms and Indicators > Sierra Chart > Problems with spreadsheet automated trading in Sierra Chart

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Upcoming Webinars and Events (4:30PM ET unless noted)

Corey Rosenbloom: Tips, Tactics, and Real Trades: Trading Intraday Trend Reversals

Elite only

An Afternoon with FIO trader bobwest

Elite only

NinjaTrader 8: Programming Profitable Trading Edges w/Scott Hodson

Elite only

Anthony Drager: Executing on Intermarket Correlations & Order Flow, Part 2

Elite only

Adam Grimes: Five critically important keys to professional trading

Elite only

Machine Learning Concepts w/FIO member NJAMC

Elite only

MarketDelta Cloud Platform: Announcing new mobile features

Dec 1

NinjaTrader 8: Features and Enhancements

Dec 6

Similar Threads
Thread Thread Starter Forum Replies Last Post
System Testing and Trading with Sierra Chart kiwi Sierra Chart 2 November 29th, 2014 11:50 PM
Need some help with automated IB TWS order entry from a simple Excel spreadsheet. Snorkel IB Trader Workstation 2 October 25th, 2014 06:38 PM
Webinar: Sierra Chart and CTS Futures, Automated Trading Systems and Backtesting Big Mike Sierra Chart 11 January 8th, 2013 04:15 PM
Sierra Chart for Charting and MBT for Trading ? Lawrencejude Sierra Chart 7 December 24th, 2012 11:50 AM
Reliability of Sierra Chart for automated trading? Xyzzy Sierra Chart 3 May 29th, 2011 05:46 AM

All times are GMT -4. The time now is 09:09 AM.

Copyright © 2016 by All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts

Page generated 2016-10-21 in 0.07 seconds with 19 queries on phoenix via your IP