Support Board
Date/Time: Sat, 01 Mar 2025 05:09:41 +0000
Post From: Help with spreadsheet study. Did not find similar question on the boards
| [2021-09-08 10:29:48] |
| VolTrader73 - Posts: 136 |
|
Hello. Im not sure how to post and where but I need help with this question I posted https://www.sierrachart.com/SupportBoard.php?ThreadID=66790 Maybe I posted it wrong as I got no reply and help. Basically, I have both spreadsheet and depth of market studies on the chart. The spreadsheet populates the market depth correctly in columns BC through BF. I have the market depth size ratio in cell K3 (simple formula referencing the BE and BC columns containing the first 10 levels of sizes). Problem: when charting it, the values fluctuates and changes values also backwards as the K column populates K4-12 with levels from the book which fill the chart array but continue to fluctuate. I want to plot on a subgraph a candle of the K3 cell only (each candle interval on the chart will show the K3 o/h/l/c values for the interval and so the history of that value on the chart will be correct. This is so basic yet I did not find any post about this and how to make the chart use only the K3 cell and display its history correctly. Just like the Bid & Ask depth bars study set to RATIO (btw, both the current and "old" B&A depth bars studies and value of K3 are not the same even though i use the same formula for the ratio. They resemble but not the same). Please advise. Thank you Date Time Of Last Edit: 2021-09-08 10:48:27
|