Login Page - Create Account

Support Board


Date/Time: Tue, 23 Apr 2024 10:51:45 +0000



Use Spreadsheet to create horizontal lines for trading alert?

View Count: 902

[2018-10-11 16:21:50]
User550330 - Posts: 3
Is it possible to create horizontal lines from data entered into the spreadsheet? These will be used as the reference for Trading System Based on Alert Condition. Please point me to an example or documentation.

Thanks!
[2018-10-11 18:57:35]
Sierra Chart Engineering - Posts: 104368
Yes you can do this. Here is the relevant documentation:
http://www.sierrachart.com/index.php?page=doc/UsingTheSpreadsheetStudy.php
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-10-11 19:36:59]
User550330 - Posts: 3
Thank you. However I have read the document you provided several times prior to asking the question.

Can you provide specific reference to the instructions (or an example) that describes how to graphically display on the main chart region a number (float) or formula that has been entered into the spreadsheet (K3)?

I am using a Spreadsheet Study and have entered data into the spreadsheet. I have confirmed that the K SG1 is set to Line but nothing displays on the main chart region. How do I get a line to display?

Thanks!
[2018-10-11 20:09:07]
Sierra Chart Engineering - Posts: 104368
You will want to set the Spreadsheet Study to display in Chart Region 1:
http://www.sierrachart.com/index.php?page=doc/ChartStudies.html#ChartRegion

As long as you have the value entered in K3 you should see it.

Do you see the value in Window >> Chart Values Window?
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
Date Time Of Last Edit: 2018-10-11 20:09:30
[2018-10-11 20:50:21]
User550330 - Posts: 3
Unfortunately, no.

However, I created a new chartbook and added a new Spreadsheet Study with a value in K3. It works! The first one must have been buggered.

Thanks for your help!

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

Login

Login Page - Create Account