Support Board
Date/Time: Wed, 15 Jan 2025 13:36:29 +0000
Post From: number bar calculations
| [2017-01-23 17:20:33] |
| User99934 - Posts: 227 |
|
The output I would like is one column. It would show the whether the diagonally measured bid or offer is larger and highlight it. I have column 1 background type set to "ABDiff Profile" and column 1 background Coloring Method to "Based on askvol bidvol diagonal" difference percentage. The way I have it set up now does everything fine except when you have a "tie" as in the attached 2 pics. In the left hand column of the attached pic, you have bids of 94,573,1275,667 in the first column and offers of 722,539,996,17. My question is when you get to the row of 1275 bid 996 offer. If you look at it diagonally, 1275/539= 2.365, if you look at 996/667= 1.493. Since 2.365 is greater than 1.493 the bids should have won at the 1257 price and colored it red. Instead, it is colored green. Could you please explain how you calculate it and what settings I need to use to make it calculate the way I want. When there is only one winner at a price, everything is fine. Its just when there is both a winner at the bid and the offer diagonally that things don't work well. Thanks! Date Time Of Last Edit: 2017-01-23 20:33:24
|
 113022.JPG / V - Attached On 2017-01-23 17:03:19 UTC - Size: 14.94 KB - 277 views 113022 numbers.JPG / V - Attached On 2017-01-23 17:03:44 UTC - Size: 27.91 KB - 313 views |