Icon

FRED Data Files Public

FRED InfoFRED Series/Symbolshttps://fred.stlouisfed.org/docs/api/fred/series_observations.htmlhttps://fred.stlouisfed.org/categoriesGet Examplehttps://api.stlouisfed.org/fred/series/observations?series_id=GNPCA&api_key=abcdefghijklmnopqrstuvwxyz123456&file_type=jsonAPI Key Requesthttps://fred.stlouisfed.org/docs/api/api_key.htmlfile_typeA key or file extension that indicates the type of file to send.string, optional, default: xmlOne of the following values: 'xml', 'json', 'txt', 'xls'xml = Extensible Markup Languagejson = JavaScript Object Notationtxt = Tab delimited Textxls = Excel SpreadsheetNote that if txt or xls is specified then the HTTP Content-Type is application/zip. The application/zip content type is sent to compress and group multiple files as one. The zip file contains the specified file format text or Excel. If xml is specified, the HTTP Content-Type is text/xml. If json is specified, the HTTP Content-Type is application/json. After changing data, open and click "OK" torefresh data. After changing data, open and select new Yaxis symbol. Self refreshing. Instructions1. Go to https://fred.stlouisfed.org/docs/api/api_key.html to obtain your Api Key. Input it in String Widget node.2. Edit the destination in the Decompress Files node for the folder where you want store the Excel files. 3. Edit the "Create Path to Read Excel" String Manipulation node to point to the same folder you created in step 2.4. To add Fred dats series, go to https://fred.stlouisfed.org/categories and search for series of interest. a. Copy series description and add to list in the "Single Selection Widget" node. b. Add the same description to the "Description" column in the "Description/Symbol Dictionary" Table Creator node. c. Copy the series symbol from https://fred.stlouisfed.org/categories and add to the "Symbol" column next to the Description in step 4.b.5. The output Excel files can be used as input for a variety of models.6. This workflow produces three scatter plots. The Plotly and Labs plots are not self refreshing. See yellow boxes for refresh instructions. Pull FRED Data, Unzipand Write ExcelRead UnzippedExcel FileLookup Description(Controlled by Variable)Description/SymbolDictionarySelect SymbolList of DataDescriptions(Right Click &Open InteractiveView)Create URLfor FRED DataNode 22Node 23Create Pathto Read ExcelNode 25Node 26Wait forFile WriteNode 28Node 29Remove Start &End Readme DatesInput YourFRED Api KeyJavaScript Decompress Files Excel Reader Table Creator Table Creator Cell Replacer Single SelectionWidget String Manipulation Table Rowto Variable String to Path(Variable) String Manipulation Table Rowto Variable String to Path(Variable) Wait... Scatter Plot (Labs) Scatter Plot(Plotly) Column Filter String Widget Scatter Plot FRED InfoFRED Series/Symbolshttps://fred.stlouisfed.org/docs/api/fred/series_observations.htmlhttps://fred.stlouisfed.org/categoriesGet Examplehttps://api.stlouisfed.org/fred/series/observations?series_id=GNPCA&api_key=abcdefghijklmnopqrstuvwxyz123456&file_type=jsonAPI Key Requesthttps://fred.stlouisfed.org/docs/api/api_key.htmlfile_typeA key or file extension that indicates the type of file to send.string, optional, default: xmlOne of the following values: 'xml', 'json', 'txt', 'xls'xml = Extensible Markup Languagejson = JavaScript Object Notationtxt = Tab delimited Textxls = Excel SpreadsheetNote that if txt or xls is specified then the HTTP Content-Type is application/zip. The application/zip content type is sent to compress and group multiple files as one. The zip file contains the specified file format text or Excel. If xml is specified, the HTTP Content-Type is text/xml. If json is specified, the HTTP Content-Type is application/json. After changing data, open and click "OK" torefresh data. After changing data, open and select new Yaxis symbol. Self refreshing. Instructions1. Go to https://fred.stlouisfed.org/docs/api/api_key.html to obtain your Api Key. Input it in String Widget node.2. Edit the destination in the Decompress Files node for the folder where you want store the Excel files. 3. Edit the "Create Path to Read Excel" String Manipulation node to point to the same folder you created in step 2.4. To add Fred dats series, go to https://fred.stlouisfed.org/categories and search for series of interest. a. Copy series description and add to list in the "Single Selection Widget" node. b. Add the same description to the "Description" column in the "Description/Symbol Dictionary" Table Creator node. c. Copy the series symbol from https://fred.stlouisfed.org/categories and add to the "Symbol" column next to the Description in step 4.b.5. The output Excel files can be used as input for a variety of models.6. This workflow produces three scatter plots. The Plotly and Labs plots are not self refreshing. See yellow boxes for refresh instructions. Pull FRED Data, Unzipand Write ExcelRead UnzippedExcel FileLookup Description(Controlled by Variable)Description/SymbolDictionarySelect SymbolList of DataDescriptions(Right Click &Open InteractiveView)Create URLfor FRED DataNode 22Node 23Create Pathto Read ExcelNode 25Node 26Wait forFile WriteNode 28Node 29Remove Start &End Readme DatesInput YourFRED Api KeyJavaScriptDecompress Files Excel Reader Table Creator Table Creator Cell Replacer Single SelectionWidget String Manipulation Table Rowto Variable String to Path(Variable) String Manipulation Table Rowto Variable String to Path(Variable) Wait... Scatter Plot (Labs) Scatter Plot(Plotly) Column Filter String Widget Scatter Plot

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: genef
Created at: 2023-02-15
On NodePit since: 2023-02-19
Last update: 2024-05-01
Created with KNIME version: v4.7.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!