Login Page - Create Account

Support Board


Date/Time: Thu, 02 May 2024 13:56:59 +0000



Problem with excel

View Count: 593

[2020-06-21 14:01:15]
Eric - Posts: 21
Hi, I'm trying to setup excel for backtesting.
I've input the buy entry condition and it automatically enters for me for all the rows. But it doesn't do the same for the buy exit, sell entry and sell exit columns.
I tried to drag it down or double click like what I normally do with MS excel but still won't work.
May I know if I've done something wrong?
It's quite tedious to enter manually and there should be some way to get this done.
Thanks
Date Time Of Last Edit: 2020-06-22 00:05:34
imageIMG_20200621_215436.jpg / V - Attached On 2020-06-21 13:56:35 UTC - Size: 6.69 MB - 204 views
[2020-06-21 23:54:13]
Eric - Posts: 21
I'm talking about the spreadsheet in Sierra chart
[2020-06-22 00:03:38]
Sierra Chart Engineering - Posts: 104368
Yes they are not using Microsoft Excel.



You need to enable Global Settings >> Spreadsheet Settings >> Spreadsheet Study >> Recalculate the Chart When a Formula Column Is Changed.

Refer to:
Global Settings Menu: Spreadsheet Settings (Global Settings menu)
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account