Login Page - Create Account

Support Board


Date/Time: Sat, 01 Mar 2025 05:10:43 +0000



Post From: Help with spreadsheet study. Did not find similar question on the boards

[2021-09-10 15:55:38]
VolTrader73 - Posts: 136
Hello. Thank you for the help.
This seems to be in the right direction but again the history of the bars change because the spreadsheet populates 1 row down and as such it refers to less and less of the top 10 book levels (cells K3-N3 refer to rows 3-12 which are the 10 price levels of the Bid/Ask, but then: cells K4-N4 refers to rows 4-13 ... and cells K12-N12 refer to rows 12-21. Due to this, each row not only calculates a wrong ratio but also continues to change "in the past" of the last 10 bars on the chart.

** I have only the 10 top levels configured from the data feed (top inside bid levels in column BC3-BC12 and top inside ask levels in columns BE3-BE12). To correctly plot the candles on the chart there should be only N3 ratio to refer sample as only it refers to the 10 book levels and holds the correct ratio.

Please advise.
Date Time Of Last Edit: 2021-09-10 15:59:19