Calculating a value

[agog]

I'm trying to set up some automation which includes a calculation which involves both the Highest Traded Price AND the Lowest Traded Price. I know you can do a calculation from a range of specific values but can't see how I can do so with these 2 differing parameters.

Any suggestions would be greatly appreciated.

[Dallas]

There is an example here with a file to capture the high/low prices
viewtopic.php?f=65&t=21151

You can then add another stored value to calculate what it is you need using a range (with the two stored values from above)

[agog]

There is an example here with a file to capture the high/low prices
viewtopic.php?f=65&t=21151

You can then add another stored value to calculate what it is you need using a range (with the two stored values from above)

That's great Dallas - I hadn't realised you could do a calculation using a range of stored values. Much appreciated as always.

[agog]

There is an example here with a file to capture the high/low prices
viewtopic.php?f=65&t=21151

You can then add another stored value to calculate what it is you need using a range (with the two stored values from above)

I'm a bit confused as to why you need to store the high/low values as last traded prices if higher/lower than the previous values - can't you just repeatedly store the 'highest traded price' and 'lowest traded price'? Won't this then increase/decrease if a new high/low is reached?