How could one plot the volatility of a series of numbers in Excel?
Thanks
How could one plot the volatility of a series of numbers in Excel?
Thanks
You need to calculate volatility in the worksheet, then plot the calculated
values.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"mtt14" <mtt14@discussions.microsoft.com> wrote in message
news:2AA1984A-14C3-4897-A145-B06047A75398@microsoft.com...
> How could one plot the volatility of a series of numbers in Excel?
>
> Thanks
Any formulas and/or functions for doing this greatly appreciated.
Thanks
"Jon Peltier" wrote:
> You need to calculate volatility in the worksheet, then plot the calculated
> values.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "mtt14" <mtt14@discussions.microsoft.com> wrote in message
> news:2AA1984A-14C3-4897-A145-B06047A75398@microsoft.com...
> > How could one plot the volatility of a series of numbers in Excel?
> >
> > Thanks
>
>
>
Go to Google and search on Price Volatility, then find a description and
formula you feel describes your situation.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"mtt14" <mtt14@discussions.microsoft.com> wrote in message
news:44A7B3E4-89CA-4F61-B74F-AB9D055B386C@microsoft.com...
> Any formulas and/or functions for doing this greatly appreciated.
>
> Thanks
>
> "Jon Peltier" wrote:
>
>> You need to calculate volatility in the worksheet, then plot the
>> calculated
>> values.
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>> "mtt14" <mtt14@discussions.microsoft.com> wrote in message
>> news:2AA1984A-14C3-4897-A145-B06047A75398@microsoft.com...
>> > How could one plot the volatility of a series of numbers in Excel?
>> >
>> > Thanks
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks