Support Board
Date/Time: Tue, 06 Jan 2026 22:17:27 +0000
Post From: TPO profile chart and spreadsheet system for trading
| [2025-11-26 09:21:27] |
| Fabio - Posts: 136 |
|
Hey John, thanks for the heads up. The solution you suggested me works exactly as I wanted. I was able to map the edges of the "custom" value area using the extended rectangle and mapping A1 and A2 using 2 different spreadsheet formula studies with the suggested formula. It works beautifully. A little tricky to set them up with formulas and all, but eventually it does its job just fine. Maybe I can suggest you guys to implement the value area lines (or simply price whatever it's easier) in a way that can be "seen" directly on the spreadsheet as it does for the OHLC prices? I am not a programmer so from this side it looks easier to be implemented :) Now I have another question: I have the ATR study on the TPO profile chart that I also want to implement in the spreadsheet, however, I noticed that regardless the input chosen (both Moving Average Type and Length within the ATR settings) the ATR calculation does not really change based on those variables. I can choose an MA length of 1 or 7 (let's say) but the outcome remains about the same. I tried the normalised ATR as well, but this seems to show a completely "off" calculation, like 0.50 for the ES. Can you please tell me if I am doing something wrong? It looks I cannot get it wrong because there are just 2 inputs but hey, maybe I am missing something... Thanks for the help! |