From the course: Algorithmic Trading and Finance Models with Python, R, and Stata Essential Training

Unlock this course with a free trial

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

Getting currency data

Getting currency data

- [Instructor] Now, once you've installed Stata and you've gotten familiar with it, one of the first things that you're going to want to do is to import some data. To do that, we'll go to File Import, and let's import an Excel spreadsheet. You could import this in a variety of different file features, but I'm simply going to browse for Excel files and I've preloaded our file folder, and I'm going to put in the 04_02 begin file, and Stata will give me a preview of what that data looks like. I want to make sure that I import the first row as variable names, and then the rest of the variables should be okay. We're going to click OK, and now all of a sudden Stata is going to pull in that data. Now let's take a look at the data and just examine what we've got here, shall we? So I've pulled data on trading prices, just to mix things up a little bit, for foreign currencies, US dollar to Japanese yen, Japanese Yen to the Thai baht, and then US dollar to the Thai baht. And this is all sourced…

Contents