课程: Financial Modeling Foundations

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Gathering data from FRED for Excel

Gathering data from FRED for Excel - Microsoft Excel教程

课程: Financial Modeling Foundations

开始一个月试用 购买团队方案

Gathering data from FRED for Excel

“

- [Narrator] While many financial models may not require special data, some do. In particular, if you're making projections about the future, or about the level of market share a firm will have, it's helpful to have outside data as part of that process. You can often get this data through Excel. In particular, I'm gonna show you how to use a tool called "FRED" to do this. Now FRED, or the Federal Reserve Economic Database, is available for free from the St. Louis Federal Reserve. You will need to download a special free Excel add-in, and generally you'll want to use the Excel 2013 version. Go ahead and download that Excel add-in, and you'll be ready to use it. Once you're in Excel, you're prepared to begin downloading data from FRED, but to do this, you need to install the add-in. So you'll want to go to File, then down to Options, come over to Add-Ins, and then come down to Manage Excel Add-Ins and click Go. Once you'll do that, you'll see a variety of different add-ins you can use…

内容