Support Board
Date/Time: Mon, 25 Nov 2024 08:51:42 +0000
Spreadsheet Formula study returns zero for DailyOHLC values?
View Count: 208
| [2024-03-21 17:11:11] |
| User656492 - Posts: 143 |
|
I must be doing something silly. ON a TPO chart, I have: - a DailyOHLC as id5. - another DailyOHLC as id8. This one has 0 for reference days back - the second DailyOHLC has 1 for reference days back. - the studies draw levels on the charts as expected. But using a spreadsheet formula study, I just get 0 as a result of =id5.sg1 or =id8.sg1 What am I doing wrong here? Add: other studies are returning values as expected with =id0.sg1 or =id1.sg1 Date Time Of Last Edit: 2024-03-21 17:13:01
|
| [2024-03-21 17:27:01] |
| John - SC Support - Posts: 36238 |
|
We are not able to reproduce this. Using the same setup you describe, we are able to get the value of the Daily OHLC in the "Spreadsheet Formula" without any issue. Please get us your chart for us to take a look. Follow these instructions to get us the chart: Support Board Posting Information: Providing Chartbook with Only a Single Chart We also want to point out that you need to be careful with studies on the TPO profiles. Refer to the following: Time Price Opportunity (TPO) Profile Charts: Using Other Studies on a TPO Chart For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-03-21 17:58:37] |
| User656492 - Posts: 143 |
|
While reducing the chart to upload, I figured out the issue. Somehow, DISPLACEMENT was set to -4. When I put that back at zero, I got the value I expected. I knew it was something silly. Thank you, folks! |
To post a message in this thread, you need to log in with your Sierra Chart account: