课程: Excel Modeling Tips and Tricks

免费学习该课程！

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

External data in financial models

External data in financial models - Microsoft Excel教程

课程: Excel Modeling Tips and Tricks

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

External data in financial models

“

- [Instructor] Getting external data is one of the biggest challenges that you may face when building a novel Excel model. So, where can you turn for that data? Well, there's a few good sources you can use, and Excel makes it very easy to get access to them. I'm in the 03_06_Begin Excel file. Now, if you're using Excel 365, that Excel model comes with some pretty cool additional data types that you might want to be aware of and take advantage of. In particular, if you're trying to gather data on stock prices, or information about currencies or geography, there's some new data types, currencies, stocks, and geography, that can be helpful, but they're still limited in terms of their actual applicable uses for many firms. So, what I want to turn to instead are third-party add-ins that you can put into Excel. And one of my favorites is what's called FRED. Now, FRED stands for Federal Reserve Economic Database, and you can get this from the Excel Office Add-in. So to get FRED, we can come…

内容