Hi

Not sure what you mean by market volatility. If it is to do with moevments
in share prices, I can't help you.

If you mean the Price Elasticity of Demand, then there is not an inbuilt
formula, but you can use Excel to calculate the value for you.

Price Elasticity of Demand = % change in demand / % change in price

To calculate the percent change in demand, find the difference between the
quantities purchased at each price and divide the difference by the average
of the two quantities:

Step 1 (Quantity2 - Quantity1) / ((Quantity1 + Quantity2)/2)

To calculate the percent change in price, find the difference between the
two product prices and divide the difference by the average of the two
prices:

Step 2 (Price2 - Price1) / ((Price1 + Price2)/2)

Dividing the percent change in demand (result of step 1) by the percent
change in price (result of step 2) provides the price elasticity of demand
for the product.


--
Regards
Roger Govier



"Dyn" wrote in message
...
anybody knows the formula??