Problems with spreadsheet automated trading in Sierra Chart - Sierra Chart | futures io social day trading
futures io futures trading

Problems with spreadsheet automated trading in Sierra Chart
Updated: Views / Replies:1,535 / 1
Created: by jcartru1974 Attachments:0

Welcome to futures io.

(If you already have an account, login at the top of the page)

futures io is the largest futures trading community on the planet, with over 100,000 members. At futures io, our goal has always been and always will be to create a friendly, positive, forward-thinking community where members can openly share and discuss everything the world of trading has to offer. The community is one of the friendliest you will find on any subject, with members going out of their way to help others. Some of the primary differences between futures io and other trading sites revolve around the standards of our community. Those standards include a code of conduct for our members, as well as extremely high standards that govern which partners we do business with, and which products or services we recommend to our members.

At futures io, our focus is on quality education. No hype, gimmicks, or secret sauce. The truth is: trading is hard. To succeed, you need to surround yourself with the right support system, educational content, and trading mentors Ė all of which you can find on futures io, utilizing our social trading environment.

With futures io, you can find honest trading reviews on brokers, trading rooms, indicator packages, trading strategies, and much more. Our trading review process is highly moderated to ensure that only genuine users are allowed, so you donít need to worry about fake reviews.

We are fundamentally different than most other trading sites:
  • We are here to help. Just let us know what you need.
  • We work extremely hard to keep things positive in our community.
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts.
  • We firmly believe in and encourage sharing. The holy grail is within you, we can help you find it.
  • 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.

-- Big Mike, Site Administrator

Thread Tools Search this Thread

Problems with spreadsheet automated trading in Sierra Chart

  #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
  #2 (permalink)
Elite Member
Phoenix AZ USA
Futures Experience: Advanced
Platform: SierraChart
Broker/Data: TradePro/TransAct
Favorite Futures: NQ YM
Posts: 318 since Nov 2009
Thanks: 126 given, 382 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:


futures io > > > > Problems with spreadsheet automated trading in Sierra Chart

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

Fundraiser: Feeding Families in Need (ends Dec 17)


Battlestations! Show us your trading desks w/GFF Brokers ($750 in Prizes)


An Afternoon With Morad Askar (aka FuturesTrader71)

Elite only

TBA w/Brett Steenbarger

Elite only

Traders Tax Advice w/Ryan Curran CPA

Elite only

Black Swan Events w/Adam Grimes

Elite only

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

automated trading, back test, backtesting, how to, range bars, sierra chart, sierra_chart, signal, signals, strategy, trading, trading system, values

All times are GMT -4. The time now is 01:42 AM. (this page content is cached, log in for real-time version)

Copyright © 2018 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432 WhatsApp Business,
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 2018-12-18 in 0.08 seconds with 14 queries on phoenix