Support Board
Date/Time: Wed, 01 Jan 2025 13:52:06 +0000
Plotting a value from a static cell eg. AK1 in spreadsheet study possible?
View Count: 872
| [2016-05-18 17:52:55] |
| Colcan - Posts: 7 |
|
Hi, I was wondering if it's possible to plot a value continuously from a specific cell in a spreadsheet study. Eg. plotting the value of cell AK1 every bar. I need the plot to stay on the chart as time progresses and if possible to also work during the replay mode. Any help from anyone would be much appreciated. Thanks, Mike |
| [2016-05-18 18:31:22] |
| |
|
Not exactly like this. You really need to use the Spreadsheet Study: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudy.html The data you want in each chart bar needs to be in one of the formula columns (K through Z) 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 |
| [2016-05-18 18:48:56] |
| Colcan - Posts: 7 |
|
What if the data in column K is the stop limit price? Is there a way to plot this stop price as it changes so that we have a history of the stop price?
|
| [2016-05-18 19:08:05] |
| |
|
This will not happen automatically.
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 |
| [2016-05-18 19:12:45] |
| Colcan - Posts: 7 |
|
Sorry I understand this won't happen automatically. Would you please let me know how I can plot a static cell such as J22 (Limit or Stop Price) in the spreadsheet study? I just want a visual record of the stop price used. |
| [2016-05-18 19:14:57] |
| |
|
Not really sure how to do this with spreadsheets. You really need to look into using ACSIL for this: http://www.sierrachart.com/index.php?page=doc/doc_ACSILProgrammingConcepts.html#ReferencingDataFromSpreadsheet When using ACSIL the value will have to be in cell K3 or at least write a formula to reference it. 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 |
| [2016-05-18 19:46:50] |
| Colcan - Posts: 7 |
|
Ok thanks for confirming that this is not doable with spreadsheets. I will look into using ACSIL. Thanks!
|
| [2016-05-18 20:24:23] |
| Sawtooth - Posts: 4144 |
|
The only way to plot historical values with a spreadsheet study is if formulas could return the stop price in the Formula Columns array at each row/bar, and only one price per row/bar.
|
| [2016-05-18 20:39:00] |
| Colcan - Posts: 7 |
|
Any idea on how to return the stop price value without using a formula(to ensure it keeps the historical value)? If I use a formula in column X3 to get the stop price in column J22, the formula would cause the value to change as time progresses and the cell moves to X4. |
| [2016-05-18 21:17:50] |
| Sawtooth - Posts: 4144 |
|
It cannot be done without a formula. And historical values can only be at close of bar. For example: If the Buy Stop is 1 tick above the previous high, and the K3 entry conditions are TRUE, then your X3 formula would look like this: =IF(K3,C4+$J$21,0) Your J22 formula would be: =X4 (for close of bar entry) |
To post a message in this thread, you need to log in with your Sierra Chart account: