How to use Alpha Vantage API Python- 2021🔴 [FREE data] - YouTube

If you want real-time financial data for free  then watch this video till the end and there is  

also a small gift from my side to all my lovely  subscribers. What is up everybody, I am Ritvik  

Dashora and I am back with a new video and some  new learnings. Today, I am going to talk about one  

of the most popular and a free data-provider  Alpha Vantage and how to use Alpha Vantage  

API directly in python such that you get all the  financial information for free. In the last video,  

I talked about IEX cloud API and you can click on  this i button to watch more about that, and just  

to remind IEX cloud is also a free data provider.  Alpha Vantage provides data related to stocks such  

as time-series data or I would say financial data,  the statements data. It also provides data related  

to Forex, Cryptocurrencies and there's also one  great feature of Alpha Vantage that it gives  

us information about the Technical Indicators.  It covers more than 50 technical indicators so  

it's quite useful if you directly synchronize it  with python and do your analysis for Algorithmic  

Trading purposes. For time-series data, several  frames are available on Alpha Vantage and it  

goes as low as one-minute interval to monthly  interval. Now let's see how to use alpha Vantage  

API in python. First of all, what you need to  do is go to uh the Alpha Vantage website. The  

link is in the description box and claim your  API key. It's free of cost... just provide some  

very basic details here by clicking on this  button which is "Get free API key". You'll get  

an API that you'll be using for extracting  financial information. The next step is to  

"pip install alpha_vantage" on whatever platform  you're using. Maybe you're using jupyterlab or  

google colab or spyder etc. pip install alpha  underscore vantage. It will take some time  

um to install it and as you can see it's already  satisfied in my computer but in your case,  

it will be downloading some files. Now let's  see the API documentation of alpha vantage  

um the link is in the description box. Just click  on that and this is the API documentation you can  

see that on the left hand side it provides data  related to stock time-series, Fundamental data,  

Forex, cryptocurrencies and technical indicators  and you can see the high usage parameters such as  

intraday or company overview or daily adjusted  stock time series data etc. It's quite big  

documentation but I would recommend you to skim it  at least such that you would have a basic idea of  

the API documentation. Now let's see one by one  how to extract these financial informations such  

as time-series, Fundamental data etc. In python in  order to extract time series data, what we will be  

doing here is from alpha underscore vantage dot  time series import time series and then this is  

the API key that I got by making this account that  I showed earlier. I'll be disabling this API key  

such that you guys don't use it just go here it's  free of cost. Just get your own API and use it  

for your purposes um. Now what we need to do here  is let me just introduce this parameter which is  

ts is equal to time series and then we need to  provide the API key which is key is equal to

API key and the next thing is output format  in my case I'm not interested in JSON format  

I'm interested in pandas from it so uh we'll be  getting the output uh which will be in data frame  

format so let me just run this uh cell now what  I will be doing here is data is equal to ts it's  

fairly easy then get ts dot get daily adjusted  entry extended monthly monthly adjusted etc.  

You can see it in the API documentation that  these are the data that will that can be  

provided by alpha vantage and we can directly get  it from here so on on writing get um let me just  

go to the monthly adjusted for example so  um the information that is required in this  

parenthesis is symbol which is the ticker. If  you remember in IEX cloud, I explained how to  

use symbol which is ticker in IEX cloud. In this  case, we just need to provide it in the string  

format which is AAPL for apple for Microsoft  it will be MSFT and so on and let's see what  

is the data now. If I run this cell, I get  it in actually I get two output and I'm just  

interested in the first one which is if I take the  zeroth one then I get it this one which is in the  

data frame format pandas data frame format  and you can see the data is monthly. If we had  

provided a get daily adjusted it would be daily  data so we have open high low close adjusted close  

volume etc. Similarly, as I mentioned that if we  used in this case I have let me just change it to

daily adjusted daily adjusted and then in  this case let's see apple and then by running  

it we will get the daily data. If you  are interested in intra-day um data  

uh with an interval of just 15 minutes then  we just need to provide get entry ticker an  

interval is equal to 15 minutes or five minutes  or even one minute so for example, in this case,  

you can see the output is 15 minutes interval data  if I change it to five minutes it will be the five  

minutes interval data which is quite useful uh  for algorithmic trading. I would say and doing  

the interval analysis you can make candlesticks  here etc. You can do a lot of analysis here.  

Before going to the fundamental data, um I  would like you to tell me in the comment box  

which topic you want me to make my next video  on? And the comment with the highest likes  

will be the topic that I'll be  considering for my upcoming videos.  

Anyways so let's move to the fundamental data  uh in order to get the fundamental data which is  

actually the statements data we need to import I  would say from alpha_vantage dot fundamental data  

import fundamental data the key is the same which  is this, one you would have your own key. uh fd is  

equal to fundamental data the key is provided  and then output format is equal to pandas and  

like it's exactly the same as that we did for the  time series data then what you need to do here is  

actually let me just delete it for  some time data is equal to fd dot

get you can get balance sheet data, cash flow  statement, company overview or income statement um  

data quarterly and annual. So let  me just take the income statement  

annual in the parenthesis I am just  required to provide the symbol which is  

ticker. Let me just write MSFT and then let's see  what the data. So again you can see the data is  

um again there are two output I am just interested  in the first one so data is zero this is the  

income statement but unfortunately, the um line  items are on the column header and I'm interested  

I would be interested if it is in the transposed  format. So yeah exactly so this is the  

income statement. All the items related to income  statement are on the left-hand side and you can  

see the uh the financial date ending is 2020,  2019, 2018, 2017, and 2016. So last five years  

of data and old data. If it were quarterly then  it would have been quarterly data the currency  

and everything is here total revenue it's quite  useful information that will we can use for our  

analysis purpose so and if you are interested in  say balance sheet data then you need to provide  

or say cash flow quarterly data for example you  just need to provide cash flow quarterly and MSFT  

and let me just first see what the data is.  Perfect so the data let me just write zero and  

.T exactly so this is the cash flow statement. For  balance sheet, again you just need to write fd.get  

underscore balance sheet and then provide  the ticker now you can see that the API  

documentation of alpha vantage and I would  say writing all these lines here is a kind of  

a LOT OF WORK. Here's a GIFT from my side to all  my subscribers. I have written a code here um that  

I'll be sharing with my subscribers in which you  what you need to do here is I've made different  

cells for different types of data and you just  need to provide the basic details and this will  

give you the output that you need. So for example,  in this case, this is cell is for time series  

data. If you run this cell, it will ask some  information such as what ticker are you interested  

in MSFT MSFT and then what type of data you are  interested in for example in this case monthly,  

and then you'll see that you have got the  monthly data output here if you're interested  

in interval data for example in this case  if I write ticker as uh ford and interval

um what interval five minutes for example and  then you'll see the output of which is five  

five minutes interval data here. So it's kind of  user-friendly code that I have written here for  

you for all of my subscribers. And for similarly  for the fundamental data you just need to run this  

code here it will ask for some basic information  such as ticker which is again let's say Apple and  

then annual data period what type of statement I'm  interested in income statement so income statement  

and then you'll see that you've got  the income statement of apple annual  

um income statement of apple similarly for foreign  exchange for cryptocurrencies and for technical  

indicators I have made a code for you now. For  my new viewers, I'll be saving this code on my  

google drive and all my subscribers can have A  FREE ACCESS OF MY GOOGLE DRIVE. What you need to  

do here is just subscribe to my youtube channel  and click on the get access of my google drive  

button on my youtube channel and then just provide  some basic details and I'll be using that email  

address to give a free access of my personal  google drive where I will be saving this code  

and not just this code there are a lot many um  codes and I would say files that are saved on that  

uh platform on that drive and you can use all  of them for your personal users and there will  

be no copyright issues from my side. Now it  can be fairly seen that I'm doing a lot of  

work for you guys so I don't need anything  from you just LIKE this video and support me  

and also share it with your friends.  If you find this video informative,  

subscribe to my youtube channel if you don't  want to miss out on my future videos, and  

don't forget to comment the topic that you want me  to make my next video on. Also get a free access  

to my google drive by following the steps that I  mentioned already. Thank you so much see you soon.