 Hey there, Chad Bons here for High University Libraries. If you're looking for economic series such as consumer price index, we're looking for GDP, that sort of thing for international countries as well as the US, or if you're looking for historical stock pricing or historical equity index pricing, things like that, you want to check out data stream. It's a great resource to allow you to get that data that you need and download it into an Excel format. This video shows you the basis of using data stream and how to download information that you need in Excel. Okay, so the easiest way to use data stream is to open up Excel on the dedicated data stream terminal in the library. What you'll do is, once you open that up, you'll see a data stream ribbon up here. So you can click on data stream there. And that will give you all these options here. So we're going to go in and create a time series request because we're looking for time series information. Historical pricing, that kind of stuff would be a time series request. So we'll do that and click start time series request there. And then it gives you this option here. So here's where it gives you the choice of where you can find your time, your series that you're looking for. So the first thing you're going to do to kind of step by step process is click on find series here. And what it'll do is it'll open up. Now it may open up as a search, like a tech search or something like that. I usually prefer to use the explore option there. It depends on what I'm looking for there. So if you're looking for, let's just look for, right now we're in equity indices. If we change this to equities, we're looking for information about Best Buy. We do a search for Best Buy. And all you have to do is click there and then click use. And then you can go down and choose what kind of data types you want. If you wanted different kind of pricing information, things like that, you can just click on key data types here. And you can kind of see the information that we have available. I mean, what in this alibis we can see here. You can see what the time series is, things like that. You can go down and say, well, I'm looking for actually, we can do market value. We could do market value capital. You can go down and do price opening, price low, price high. You can just do price. And once you do all that, you can click use selected. And it gives you that information. Now what you can do is you can change the time if you want to. You can do a start date, end date. You want to definitely go down and click on display headings. If you're doing any kind of international stock index or something like that, you're going to do display currency, that sort of thing. And then change it what your frequency is. Now your frequency needs to match up with what the frequency is for the particular data type you're looking at. So if it's an annual data type, you can't do a daily frequency. So you want to look at that as well. Otherwise you'll get an error. So we'll click submit here and it'll do its thing. It's going to crunch some numbers here and then we're going to get our data. Okay, so there's all the data we have. We can download that to obviously with some Excel format, that sort of thing. So that's for an equity. Now let's say you want to look at an equity index or something like that. We can also go under time series request. We can do find series and then unless you have to actually choose equity indices or if you want to consumer price information, you have to go into economics. You kind of have to look around a little bit to find the information that you need there. So I'm going to click on equity indices. And what you can do is actually click on explore and you can actually go in and choose what you're looking for. So if you wanted like benchmarks at a glance, you could do that sort of thing. If you wanted, click on explore more. If you wanted by market. So for example, if we're looking at Argentina and we want information about the Buenos Aires Stock Exchange, you can go in and grab Merckfall there. Click use. And once again, we can display currency here. You can have it exchange the currency you wanted to. Just by simply clicking on the dollar sign there, you can tell it what currency you wanted in. If you leave it default here, it'll give you the price index. If we click submit, it'll go in and give us the price index for that. And you see we get the currency, that sort of thing. So that's how you basically use it. You just basically click on time series request and go in and find your series and then change your dates. Make sure they match up. Make sure you're looking for... If you're finding that if the available is available, data is available daily. You can click on daily. If not, you have to actually click on what is available for that sort of thing. And usually it'll tell you under the series what information is available and how often it's updated and that sort of thing. So that's the basis of how to use a data stream. Data stream is available at one library terminal. Just ask at the second floor desk. It's also available in the economics lab in Bentley. So a good resource to use for economic and stock price information as well. Hopefully this helps you. If you need more help, look for the contact link on the business blog. I'll be glad to help you. Anyway, take care and have a great day.