From the course: Financial Modeling Foundations

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Gathering data from FRED for Excel

Gathering data from FRED for Excel

From the course: Financial Modeling Foundations

Start my 1-month free trial Buy for my team

Gathering data from FRED for Excel

“

- [Instructor] When you're building financial models, you're often going to rely on data. It's the first place you start. Typically, you'll gather internal data from the company, for example, historical accounting statements, to get you started. But you may also need external data, particularly macroeconomic data, if you're trying to build certain types of models. So let's talk about where you can get that from. I'm in the 01_05_Begin Excel file. Now, one of my favorite sources of data, particularly macroeconomic data, is the FRED, or Federal Reserve Economic Database tool. You can download the FRED Economic Database add-in for Excel if you have an older version of Excel, Excel 2016 and before, or if you have a newer version of Excel, you'll need to come over to the Add-ins option and you can search for FRED, and it'll pull up the FRED DATA option. Once you've added that, you'll see this tab appear. And it lets us go…

Contents