Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 22:03:44 +0000
OutsideBar Problem
View Count: 745
| [2017-02-03 11:50:21] |
| User792126 - Posts: 2 |
|
Hi, I'm trying to use spreadsheet study to draw horizontal lines only from Otsidebar created/pointed Candle and and all lines like OHLC and I would also extend these lines until next day or even longer. Have used spreadsheet study and in cell K3 following formula: =if(aa3>0,b3,0) (Outside bar is seen at column AA) Spreadsheet seems ok and it can find all the outside bar only open prices , but when I try to plot these into chart at subgraphs K(SG1) nothing is drawn? And if I try to change draw style into OHCL and then apply it will reset back to Candlestick. I have tried to input manually a number into K3 but it does not output anything into chart. Is there something wrong with parameters somewhere? |
| [2017-02-03 17:58:45] |
| |
|
What is the Graph Draw Type for the spreadsheet study set to? Refer to: Graph Draw Types How is this Spreadsheet Study Input set?: https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#PriceGraphStyle What happens when you enter =E3 into cell K3. You should see a single line of the last trade price outputted by the Spreadsheet study on the chart. 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 |
| [2017-02-04 07:15:01] |
| User792126 - Posts: 2 |
|
Graph Draw type is set for Candlestick and as I mentioned earlier it will be reset into that for some reason. If I will refer to E3 at cell K3 -nothing will be displayed. If I tick name label then I can see "K" in the main Price Graph. |
| [2017-02-05 20:43:08] |
| |
|
Make sure this Spreadsheet Study Input is set to No: Spreadsheet Study Inputs: Use Price Graph Style Go through the Spreadsheet Study instructions for a basic introduction to use the Spreadsheet Study: https://www.sierrachart.com/index.php?page=doc/StudiesSystemsAlerts.php#Instructions Start with a completely new instance of the Spreadsheet Study. This way you can see how to use it and not have any problems like this. 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: 2017-02-05 20:45:33
|
To post a message in this thread, you need to log in with your Sierra Chart account: