Volitilty=%
Not Magnitude...
to compare variation use Excel function
=stdev(< Your Range here>)
Range=Close(t)/Close(T-1)
say goog closed at 400...the day before closed at 385
then on the first data in Rnage 400/385
...so on...need about 40 to 50 days to commpute accurate daily stdev...