Download Financial Data in R

Welcome to the Data Hall YouTube channel

In today's video, we are going to look into how do we download stock prices data in R

So to download stock prices data in R, we use the quant mode package

So if you haven't installed this package, you can install it using this line of code

I have already installed it. So I'm not going to reinstall it. We are going to just load this quant mode library

And then we are going to look into this function, which is called get symbols

Remember, the S is a capital S. So, Gat symbols, what it does is it asks us for three main parameters

First, it asks us for the symbol, the ticker that you want to download

So for example, we want to download the data for the Apple stock

Then the time period from where you do, you want the data to start

So for example, we want the data to start from 1st of January 2010 till 31st of

December 2023. If I press control enter it would take if a couple of seconds and the data

would be downloaded Now do remember that this data would be downloaded in an XTS object XTS object is a kind of an object where we have the dates in the index the row index right

So we have the open price, high price, low closing volume and the adjusted price of the Apple stock

So each time it would download an XTS object of its own, right

We would have a video on XTS object and how to work with XTS object in a couple of days

And we can also plot this data. So let's say I am going to plot the closing price

just to give you an idea of how the closing price are going from this time period

Now we can define the starting and ending date in a vector and then pass that date as a parameter

in this get symbol function, right? And we can also specify this source

So by default the source is Yahoo, but you can explicitly specify it or if you want to change the source

and you want to download it from somewhere else, then you can also download it from the other source

Now, there is a function called Today. It is coming from the Tidewurst Library within Tidewurst Library there is a library for working with dates but I just going to load the Tidiverse library

And once we load this library, we have this today's function. And what today would do is it would give us today's date

So it is 7th of May, 2024. So we want to download, say, one year of data

starting from today. So what we do is minus 365 and that is one year of data, maybe more than one year of data because, yeah

So, and we also assign an auto assign over here. Let me execute this

Now we are going to download the Microsoft data. And what this auto assign does is instead of creating an object over here, it just presents the data in the console, right

So remember, it starts. from 8th of May 2022 till the 6th of May 2024 so it is exactly the one year because

it is 24 is a leap year so we should have given 365 365 instead of 365 so auto sign do not create an object so if we didn had also auto sign equal to false rather it should be equal to true If we do that then it would download the data instead of presenting it in the console it would create an object of its own You can also download the index So SSSP 500 index is represented by this sticker and we can download that And we can also create a vector of all the all the tickers that we want to download So we want to download after

Microsoft and SPY. And although we have it over here, these two over here

in our environment, but let's just say if we didn't have them, we can assign and we can create a ticker

and then pass that ticker instead of a single. Let's say you have a lot of tickers that you want to download

Then in that case, downloading that individually would be a difficult task to perform

Therefore, we can pass a vector. into it and that would download all these

So let me define this vector first. And that would download all those and those stickers one by one and we would have an object

for each of them. Right. So I hope this was useful. Do subscribe to this channel

Do hit the bell icon. And thanks for watching this video