Login Page - Create Account

Support Board


Date/Time: Thu, 16 Jan 2025 17:19:10 +0000



Post From: Spreadsheet Formula Question and Testing Help

[2017-11-07 23:20:45]
User29926 - Posts: 92
SC software and spreadsheets is the most aggravating application and auto trading method I have every had to deal with.

It is not stable at all..

I made the mistake of upgrading from version 1621 to version 1637 yesterday.
Soon as I restarted SC and tried to use my spreadsheet autotrader, it was a totally cluster bust.

It was no longer placing orders with the K and M cells stuck on "1" and will not enter a trade.
No coding changes made or setting changes made.

I knew right away, but too late that I had just screwed myself by updating to the latest version.

I Enable the "Enhanced Auto Trade Signal Related Logging" to see why signals was being ignored
No date shows up in the Trade Service Log.


I immediately reverted back to version 1621, hoping everything would go back to working correctly.
Nope, its still a cluster bust.

Spreadsheet is still no longer placing orders with the K and M cells stuck on "1" and will not enter a trade.
No date shows up in the Trade Service Log either.

Auto Trading is enabled on the chart.

For debugging:
I tried setting the"Reset Condition on new bar" to Yes.
K and M columns still never switch to back to zero.

Tried "Signal Only On Bar Close" to Yes
Still gets stuck on "1".

Enable the "Enhanced Auto Trade Signal Related Logging".
No date shows up in the Trade Service Log.

I completely removed the formulas from the K and M column and enter a "0".
Ran the chart a few bars and placed a "1" in the K column and still no trade placed and no data appears in the Trade Service Log.

I was going to downgrade to version 1619 to see if that helped.
However SC has removed all zip version lower then 1633 from the download page.
https://www.sierrachart.com/index.php?page=doc/SCZipInstallerList.php

Let my spreadsheet destruction serve as a warning, do not try to improve on what is working correctly.
If its working on your version, upgrade at your own peril.
Date Time Of Last Edit: 2017-11-07 23:32:07