Federal Reserve Economic Data

The FRED® Blog

Measuring uncertainty and volatility with FRED data

Uncertainty and volatility are closely related but distinct concepts. People are uncertain if they lack confidence in their knowledge of the state of the world or future events. News is more likely to change the views of people with high uncertainty. In financial markets, changing views is associated with changing asset prices. Volatility denotes the size of changes in asset prices, so volatility is an ex post (after the fact) measure of uncertainty.

Uncertainty and volatility are carefully watched variables because of their relation to financial crises. During such periods, uncertainty often rises to high levels as the prices of risky assets, such as stocks, tend to fall. This produces a short-term, negative relation between uncertainty and returns.

FRED has a number of series that are related to uncertainty and/or volatility, some of which are derived from options data. One of the most frequently used such series is the Chicago Board of Options Exchange (CBOE) Volatility Index, or VIX. This options-derived series predicts one-month-ahead volatility on the CBOE S&P 500 futures contract.

To illustrate an example of the common negative relation between uncertainty and stock returns, FRED users can employ the two-axis option to overlay a volatility index, such as VIX, with the underlying price series. In the first FRED graph at the top of the post, one can easily see how the rise in VIX coincides with the decline in S&P 500 prices during the period from mid-February to late-March 2020.

Note that if users graph a long span of daily data, such as VIX or the S&P series, FRED will automatically revert to graphing lower-frequency data instead of daily data, although the underlying series are still daily. For example, if we extend the time scale on the first graph back to 1990, FRED will revert to graphing monthly data and no longer show us the values for individual days. See the second FRED graph above.

Users can define their own lines to enhance the look of their graphs. Horizontal lines can emphasize periods when uncertainty or volatility is above a certain level. One could download a series to a spreadsheet or some statistics software to find its 10th or 50th or 90th percentile and then use those percentile values to emphasize particularly high or low values. For example, in the third graph shown above, 90% of the VIX series observations are less than 28.84. By creating a line at that level, we can indicate the upper 10% of VIX observations.

Users can also create a vertical line to highlight action on dates of interest. For example, March 16, 2020, was a very volatile day for U.S. financial markets, as participants came to grips with the impact of COVID-19 and the likely policy responses. The vertical line in our very first graph draws emphasis to this date as a turning point in the financial market reaction to COVID-19.

Finally, it’s possible to compare an ex ante (before the fact) prediction of volatility over the next month (e.g., VIX) to an ex post (after the fact) volatility measure that uses daily prices. To compute actual daily volatility (i.e., the absolute daily percent changes), change the units of S&P 500 prices to percent change and apply the following formula in the formula bar: (a^2)^(1/2). Ex post volatility over a day need not exactly correspond to ex ante predictions of volatility over a month. For example, volatility may be low today but high over the next month if important news is expected to come out in a couple of weeks. Conversely, volatility might be temporarily high as important news is released but expected to decline in the near future. Still, our last graph (below) usefully illustrates the tendency of the two series to move together.

How these graphs were created:
First graph. Search FRED for “VIX” and select “CBOE Volatility Index: VIX.” The default graph will be a daily graph of VIX. Use the “edit graph” button to open the editing box. Use the “add line” tab to search for and add the daily series “S&P 500.” Use the “format” tab to shift the y-axis position of the “S&P 500” series to “right axis.” Go back to the “add line” tab to “Create user-defined line.” Click on “Create line” and type in starting and ending dates of “2020-03-16” and starting and ending values of 0 and 90. This will produce a vertical line on 2020-03-16. You can change the line style, width, and color from the format tab. Returning to the main graph, use the date range boxes to set the beginning date to “2019-06-10.”
Second graph. From the first graph, change the beginning date to “1990-01-02” using the date range boxes.
Third graph. Search FRED for “VIX” and select “CBOE Volatility Index: VIX.” Use the date range boxes to set the beginning date to “1990-01-02”. Use the “download” button to download the series to an Excel file. Once you have opened the file, type: =PERCENTILE.EXC(IF(ISNUMBER(B13:B8214),B13:B8214),0.9) in an empty cell (cell range will be different from when this was written). This returns the 90th percentile of the VIX data (i.e., 28.84). Back to the graph, use the “edit graph” button, go to the “add line” tab to “Create user-defined line.” Set the starting and ending values for the line to “28.84.”
Fourth graph. Search FRED for “S&P.” The default graph will be a daily graph of the S&P 500 for the past 5 years. Click the “edit graph” button and select the units for the S&P 500 as “Percent Change” and the formula as (a^2)^(1/2). Click on “add line” and search for “VIX”. “Select the daily “CBOE Volatility Index: VIX”. Select “Add data series.” Select the units as “Index,” not percent change. Using the format tab, select “Right” for the y-axis position of “CBOE volatility Index: VIX” series. Close the editing box. Using the date range boxes for the graph, select a 5-year date range.

Suggested by Christopher Neely.

The pandemic’s boost to online sales: A one-time event or a new normal?

The FRED graph above shows online retail sales. It’s no surprise these sales have been steadily increasing, even if there are a few rough patches during recessions. And it’s also completely expected that the pandemic provided a large boost to e-commerce over on-site retail. The question is whether this is a temporary boost that will subside once the world returns to normal. That is, will the previous trend continue where it left off or has the online sector gotten a boost that will put it on a higher trajectory?

Obviously, it’s still too early to say exactly what the “new normal” will look like. But, at the time of this writing, it looks like the second option is correct and there’s a new trajectory for online sales. But not much has been normal about the current recession, so only time will tell. Visit this blog post later to see how the graph updates with new data.

How this graph was created: Search FRED for “online retail” and the right series is among the first choices.

Suggested by Christian Zimmermann.

View on FRED, series used in this post: ECOMSA

Change in the metal value of coins

For a long time, coins were supposed to contain enough valuable metal to be worth their face value. This intrinsic value was intended to create trust in the coins and, thus, facilitate transactions for a smooth-running economy. But this hasn’t always worked out well.

  1. Coin issuers had strong incentives to dilute the value by adding less-precious metals or reducing the weight of the coins.
  2. The value of the underlying metals could fluctuate quite a bit, leading to more fluctuation in the price of goods than some liked.
  3. There’s the chronic big problem of small change—the high costs and degree of difficulty to produce the coins.

Today, the most-used U.S. coins are made of nickel, copper, and zinc. The FRED graph above shows that the value of these metals still fluctuates a lot. But that’s not as important now, since nobody expects these coins to have the metal value to match their face value. (Their role is to facilitate change, not really to store value.) But the coins still have some metal value, and the FRED graph below shows that value for quarters (blue), dimes (red), nickels (green), and pennies (purple). 

It may be surprising that the most expensive coin is the nickel, whose metal value frequently exceeds five cents, whereas the penny rarely goes over a cent. Note that these are just the raw costs of the metals. The actual manufacturing on the planchets and their minting adds cents to the cost for each coin.

Suggested by Christian Zimmermann.



Back to Top