How can I download Data from the Federal Reserve Bank of St. Louis Database (FRED) ?

If you work with economic data you probably know FRED, the massive database created by the US Federal Reserve Bank of Saint Louis, that claims to have 816,000 US and international time series from 108 sources.

You can now access all that data directly into Alphacast, using Alphacast pipelines.

Creating a dataset or pipeline by importing from Yahoo finance is as simple as

1 Create a new pipeline (Top right --> Create New --> Pipeline) and choose "FRED" as your data source.

2.To load data into Alphacast you need to know the series Code. Each series has a unique code that can be found in two places on FRED site. On the URL and next to its name.

In the following example the series code is T10Y2Y and MORTGAGE30US

image.png

3.Include as many series as you like, separating them by a comma. See a working example here

image.png

4.Ready! You can now publish the dataset, chart the data, process it or any other cool option available in pipelines.

Luciano Cohan

Written by

Luciano Cohan

Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías

Alphacast

Part of

Alphacast

Related insights

  • Read more...

    How to convert a series to the official USD or Blue Chip Swap?

    The pipeline engine "Apply Transform" step incorporates a new transformation that allows changing the source unit: Convert to dollar official or to Blue Chip Swap (for Argentina only).

    The pipeline is separated into Two steps

    1. Select ("Fetch") the dataset and its columns
    2. "Apply transform"
  • Read more...

    How is a Time Series seasonally adjusted?

    Removing seasonality from time series is always complicated and laborious. The standard deseasonalization method is X-13ARIMA-SEATS or some other version of the methodologies maintained by the United States Census Bureau. Denationalizing usually includes using some application such as Eviews, Demetra or Stata or Python, combining it with the files that are downloaded

  • Read more...

    How to merge the content of two datasets?

    Surely in your usual work with data, you needed to join several data sources and if your calculation tool is Excel you may solve it with some combination of the VLOOKUP, HLOOKUP, and/or MATCH formulas. Excel is a great solution in many cases, but it can be difficult in some scenarios.

  • Read more...

    How to calculate a monthly end-of-period series?

    Pipelines are an easy way to apply transformations to datasets that update automatically every time data is updated.

    Suppose we have a daily data series for which we need only the last value of each month. It is possible to do that in Excel. For example, an auxiliary column is added that