Login Page - Create Account

Support Board


Date/Time: Fri, 26 Apr 2024 17:32:22 +0000



Backtesting - Trade List with Spreadsheet data

View Count: 686

[2018-12-13 15:28:04]
User513228 - Posts: 41
Hi,

I want know if is possible do backtesting and get trade list with data from spreadsheet for every single trade.

Or is some way get this data ? I want know value of RSI, Stochastic, ... and every indicatorĀ“s value from my spreadsheet in time when trade was opened
[2018-12-13 19:24:29]
Sierra Chart Engineering - Posts: 104368
This is not supported. To some extent this can be done with this Text Tag feature though:
Spreadsheet Systems, Alerts and Automated Trading: Support Order Text Tag Cell
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
[2018-12-14 09:15:32]
User513228 - Posts: 41
I updated my sierra, set "Support Order Text Tag Cell" in Spreadsheet Study to Yes. But it doesnt work when i try using formula. I can see this cell in Notes only when i use some text but when i use for example " =$BA$3 " field in Notes is empty then.
[2018-12-14 09:32:29]
Sierra Chart Engineering - Posts: 104368
Convert the number to text with this function:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetFunctions.html#TEXT_Function
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