RINCONPAUL
04-18-2016, 05:52 PM
In the attachment I've built a linear speedometer. Cell B16 has a constantly updating feed of price values between 0 and 1000 (type a value in B16 and the needle will move). The 180 deg arc is divided into 10 equal segments, however they don't represent 10% of the scale. The scale is not logarithmic in the sense that a value within a segment of the pie, let's say the value $5 is halfway (50%) between $4 and $6 on the speedo increments. However the speedo increments have a wider value range, each segment.
At the moment the needle is at $2.5 as if the fraction was 2.5/100, but it's showing a value less than $1 on the speedo. I need a formula that converts the input value to a relative % of the applicable segments.
Background: These segments represent Betfair tick sizes. System formula has been devised around a price being within a certain tick size segment at the close of betting, however as the starting price is never really known till after the close, a price hovering close to the border between two tick size segments, could go either way and ruin the system premise, so a bet to avoid possibly. Being able to see when the speedo needle is hovering close to a changeover, would be handy to know at a glance?
Thanks, as always.
At the moment the needle is at $2.5 as if the fraction was 2.5/100, but it's showing a value less than $1 on the speedo. I need a formula that converts the input value to a relative % of the applicable segments.
Background: These segments represent Betfair tick sizes. System formula has been devised around a price being within a certain tick size segment at the close of betting, however as the starting price is never really known till after the close, a price hovering close to the border between two tick size segments, could go either way and ruin the system premise, so a bet to avoid possibly. Being able to see when the speedo needle is hovering close to a changeover, would be handy to know at a glance?
Thanks, as always.