Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 11:33:18 +0000



Horizontal Line from Spreadsheet

View Count: 315

[2023-12-07 15:12:26]
pismo10 - Posts: 159
How can I draw a horizontal line on an price chart from a cell that is calculated in a spreadsheet.scss.
Thanks
[2023-12-07 16:46:20]
John - SC Support - Posts: 36286
You can not do this from a "standard" spreadsheet (i.e. a spreadsheet opened using File >> New/Open Spreadsheet). You need to use the Spreadsheet Study and then enter the value you want in row 3 of the one of the Formula Columns (such as column K) and this will create the line. Refer to the following:
Using the Spreadsheet Study
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-12-07 18:14:46]
User584084 - Posts: 262
Google Sheets CSV Importer | SierraChart Custom C++ Study

https://www.youtube.com/watch?v=0R73EQxfeGY
Date Time Of Last Edit: 2023-12-07 18:15:47
[2023-12-07 20:13:59]
pismo10 - Posts: 159
Be great if I could find a password it will accept..
[2023-12-07 22:37:24]
User584084 - Posts: 262
1) In Google Sheets, go to File >> "Make a copy" of the password protected sheet. A Copy Document window pops up. Type a name for the file, Folder >> My Drive and click the "Make a copy" button.

2) Click the "Share" button in the upper right hand corner of your new Google Sheet. Under General Access, change access from "Restricted" to "Anyone with the link" and click Done.

3) Change the ES price levels in the new Google sheet to match current price levels.

3) Now copy the URL to the Google Sheets Importer Study in Sierra Chart.

Should work now.
Date Time Of Last Edit: 2023-12-07 22:39:34

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

Login

Login Page - Create Account