If any one is curious on how to parse through company overview here is an example in python: from alpha_vantage.fundamentaldata import FundamentalData api_key = "" fd = FundamentalData(api_key, output_format='json') data = fd.get_company_overview('AAPL') print(data[0]['Symbol']) this will print the symbol
Hello I'm curious how you actually found out how to do all the things that are covered in the documentation. Like, I could read the whole documentation but still not understand how to implement any of these things. The documentation doesn't say anything about specific functions or syntax, it just goes over the concepts and I'm not sure how to find out any info for this besides RUclips videos
I understand it is difficult to understand at least for the beginners. That's why I make tutorial videos on them. Subscribe to learn more such great tools. :)
Awesome video thanks! Just wondering, how much can you download with the free version? For example, can you download the balance sheet of 1000 firms at once?
HELP PLEASE!! I finally figured out i was using the wrong python version and wrong environment. Kept getting an error where it basically says cannot find alpha vantage for the “from alpha_vantage.timeseries import TimeSeries” and resolved the import erorr after switching environments to conda with a slightly older python version. The one problem now is.. i have no errors, or highlights for anything. I opened the debug console and run and debug. No issues found! But when I execute the code is outputs nothing!!!!!! It just says “Running file name shit” Then “Done” exited with 1.20 seconds. What in the world is going on. Its just five lines to view apple data.
I recommend you copy my code from my google drive and run line by line and try to figure out the mistake. It's very affordable and completely worth it: ruclips.net/channel/UCyMifqUrSntvvrrGMaVPkrwcommunity?lb=UgwZRm2WrR2BqVk_ho54AaABCQ
Anyone here please Reply. Why i am not able to find anywhere how to use alphavantage library like this in javascript? I have been searching it for many days....
Hi, great tutorial. Which API do you recommend for taking income statements for previous three years and processing the individual data points (Ex. Alpha Vantage, Financial Modeling Prep, IEX Cloud)? Thank you!
Among these, Alpha Vantage. But wait, on this playlist, I'll cover many more free APIs including retrieving information directly from SEC filings. Subscribe not to miss them 😉. What income statement line items are you interested the most?
@@supremekingki That's Great! You can use Alpha Vantage for now. Stay tuned, much better free APIs to come on this channel. Just a point in my mind, you can do multiple companies' Valuation through Python, which won't be possible on Excel. Just remember, CAGR or growth rates differ with different industies (for eg, Capital intensive vs tech). Quite excited for your project, let me know if you want me to cover anything in my next video.
hello sir i am facing one problem when i import this data into mysql the date column is not inserting in the mysql please answer how can i handle this problem it will help me alot
I guess you are making mistake in data cleaning. I recommend you to copy paste my code on Alpha Vantage saved in google drive and then run line by line to understand the mistake.
@@FinancialProgrammingwithRitvik Thanks for responding... I was trying out many things... Now I can web scrab 15 mins data from Yahoo finance... But when I am trying to import 15 mins MACD or 15 mins MFI data from Yahoo finance and also not able to get Hakin Ashi data from investment.com by doing web scraping, I am not able to do that... Can you make a video on how to import data from live charts from investment.com or upstox or zerodha by doing web scraping it will be really helpful... What you thinks will you be able to make a video on that
Great video thank you! My code runs well on VS however how are you able to view the other get_ ... options to pop up (symbol_search or quote_search ...)? Is there an extension I can install for this?
Question: Do you have to use colab to see results? I am using VS code, but running this same code doesn't throw errors but it won't show any data in the terminal.
the syntax / library syntax is different than the documentation (where they use url and request). is the library syntax as you use in the video documented somewhere?
Hi, Can I get nse data from this site? Its says global market, so I assume that would include NSE too. If yes, do I need to prefix the symbol like NSE: or something? Can you please confirm? Thanks
Could you create a video on parsing data from company overview? I am having trouble finding information on this. I just want the EPS of a given company. Thank you for this video.
Hi, I want to ask if it is possible to load an RSI indicator for more than one joint stock company from Alpha Vantage at the same time? And what would such a script look like?
Yes, free version has a limit to export the data... then you will have to wait for sometime to extract more. What you can do here is run a few tickers, save it, then run for more tickers, save it and so on. You can also make it automated.
Thank you for this. New to this and having trouble with data[0] and run. Nothing happens. Cannot seem to get a return in pandas format. I have pip installed pandas and was able to print the pandas version number (1.2.3). Using Visual Studio Code. Is there something I am missing? I see a lot of people starting their code with import pandas as pd. Is this not necessary? I have tried it both ways.
Hello Ritvik, Thanks for providing us such an informative video. But I stuck to reading Indian stock market data using this API. Can u please help me out??
One API call to Alpha Vantage counts as just one API call. There are no limits to the number of data points from an API call. To change the date range in python, put outputsize='full' (it will return the full-length intraday times series, commonly above 1MB ). Then you can easily get desired data as: data_date_changed = data[:'2019-11-29'] You may see some other related codes in my Google Drive.
@@FinancialProgrammingwithRitvik hello sir i am working on stock market historical data for usuk project so i need all tickers for specific exchange, can we get all tickers for specific exchange using python ? how? please reply if it is possible it will be very helpful for me.
Hey! Thanks for this video ; ) I wanted to use crypto (for example BTC-USD) instead of a stock symbol, how can I do that, please? I tried to follow the documentation and do: from_currency=BTC&to_currency=USD but it doesn't work too...
How I can get over all data of traded volume quantity and delivered quantity for comparison Can you make a project on this pls It's very helpful for me
It's not covered under free version. Second to second free data is only available for real time... Please refer this video to learn more... ruclips.net/video/z2ePTq-KTzQ/видео.html
great video just what I needed. I have seen your code on the google drive It is not very clear to me how can I use it to build a nice app with tickers and financial parameters
Hey thanks for such a wonderful video but i would like to know if i would be able to get the fundamental data of the indian stock market through this api?
It does not provide Indian financial data. We need to buy data in India. However, I am looking forward to something that's free and will cover it on this channel very soon. 😉
Hello Ritvik, this was quite informative. I wanted to know if we could get Indian Stock Data and also Indian Companies fundamental data. I tried putting .NS and .NSE in the ticker symbol but those didn't work. .BSE worked however. Still I am not able to access the fundamental data, and the NSE data. Please help. Thank you.
@@FinancialProgrammingwithRitvik actually i had the same question.... i am on a project where i am performing algotrading using some indicators for buy and sell decisions...so i started with getting the NSE data...but the numbers differed from actual ones. The data was in dollars and even after conversion, they weren't matching....and this worked only for INFY ticker...please tell me how to get data for indian stock exchanges(NSE and BSE). thankyou for the tutorial.
Great video dude! I have one question. How do I use Alpha Vantage and Pandas to get (e.g. FB's price data from 1-Jan-2019 to 31-Dec-2019). I'm confused about which documentation to use.
@@FinancialProgrammingwithRitvik Financial statements i get it from tdawl website you can check by this colab.research.google.com/drive/1-6FUhi_Vj4Sr4GB0DtPRPPeXZwUSx9zR?usp=sharing
Thank you for sharing this information. I have a question. Not too knowledgeable with Python myself. Is it possible to instead of entering each symbol manually, to pull a list of symbols from a .csv file? Thus automatically retrieve the price data and save the output into an excel file for further analysis?
@@FinancialProgrammingwithRitvik might consider looking into it. I've been coding a grand total of three weeks and am picking it up pretty easily. The language is very similar to python
Dixon, it's the same as we do in Jupyterlab. First, install alpha_vantage then use it the same way. You can copy my code from google drive open it in google colab and then try extracting data. Please Let me know if there's any other question.
Can we get data for following from alpha vantage API 1.) NSE (Indian National Stock exchange) 2.) BSE (Bombay Stock Exchange, India) 3.) F&O (Future and Options India) 4.) MCX
𝐓𝐢𝐩 𝐦𝐞
by:
buying me a coffee in US Dollars: www.buymeacoffee.com/fpritvikusd
buying me a coffee in Euros: www.buymeacoffee.com/fpritvik
Learned more about alpha_vantage here in 11:45 than any of the videos out there. Thumbs up!!!
Wow... That's a very nice comment ☺️
@@FinancialProgrammingwithRitvik you are welcome. I have subscribed as well ;) Question: What about APIs that can access Canadian Markets for free?
Disregard the Canadian Market question. IN one of our comments below you mention 'ts(help) look for symbols...'. Problem solved! Thank you!
@@garylanigan1 hahaha, you are my best subscriber ;)
@@FinancialProgrammingwithRitvik So where are the files? ;)
If any one is curious on how to parse through company overview here is an example in python:
from alpha_vantage.fundamentaldata import FundamentalData
api_key = ""
fd = FundamentalData(api_key, output_format='json')
data = fd.get_company_overview('AAPL')
print(data[0]['Symbol'])
this will print the symbol
Thank you for your comment :)
Hey, very helpful video, can I get the access of the Google drive link please?
I am not able to view the access button
Hi Jinal... Please check out this post: ruclips.net/channel/UCyMifqUrSntvvrrGMaVPkrwcommunity?lb=UgwZRm2WrR2BqVk_ho54AaABCQ
Hello I'm curious how you actually found out how to do all the things that are covered in the documentation. Like, I could read the whole documentation but still not understand how to implement any of these things. The documentation doesn't say anything about specific functions or syntax, it just goes over the concepts and I'm not sure how to find out any info for this besides RUclips videos
I understand it is difficult to understand at least for the beginners. That's why I make tutorial videos on them. Subscribe to learn more such great tools. :)
Please do a video on getting options chains. I want to be able to get the chain data and find the actual theta value
Noted!
Awesome video thanks! Just wondering, how much can you download with the free version? For example, can you download the balance sheet of 1000 firms at once?
HELP PLEASE!!
I finally figured out i was using the wrong python version and wrong environment. Kept getting an error where it basically says cannot find alpha vantage for the “from alpha_vantage.timeseries import TimeSeries” and resolved the import erorr after switching environments to conda with a slightly older python version.
The one problem now is.. i have no errors, or highlights for anything. I opened the debug console and run and debug. No issues found!
But when I execute the code is outputs nothing!!!!!!
It just says “Running file name shit”
Then
“Done” exited with 1.20 seconds.
What in the world is going on. Its just five lines to view apple data.
I recommend you copy my code from my google drive and run line by line and try to figure out the mistake. It's very affordable and completely worth it: ruclips.net/channel/UCyMifqUrSntvvrrGMaVPkrwcommunity?lb=UgwZRm2WrR2BqVk_ho54AaABCQ
do you have a vagrant file you are using for this development environement by any chance?
I don't have
Anyone here please Reply.
Why i am not able to find anywhere how to use alphavantage library like this in javascript?
I have been searching it for many days....
What error are you getting?
Great Video Ritvik. I am new to stock analysis but I am eager to learn. I will be following you for sure.
Thanks :)
i need help! can we get intraday 1 min data of any stocks in NSE(indian stock market?)
I agree. I got some comments on it before as well. It is on the priority list in my plan.
Hi, great tutorial. Which API do you recommend for taking income statements for previous three years and processing the individual data points (Ex. Alpha Vantage, Financial Modeling Prep, IEX Cloud)? Thank you!
Among these, Alpha Vantage. But wait, on this playlist, I'll cover many more free APIs including retrieving information directly from SEC filings. Subscribe not to miss them 😉. What income statement line items are you interested the most?
Thanks for the response, I have subscribed. I plan to use last three years data to estimate next three years and build DCF model.
@@supremekingki That's Great! You can use Alpha Vantage for now. Stay tuned, much better free APIs to come on this channel. Just a point in my mind, you can do multiple companies' Valuation through Python, which won't be possible on Excel. Just remember, CAGR or growth rates differ with different industies (for eg, Capital intensive vs tech). Quite excited for your project, let me know if you want me to cover anything in my next video.
Please upload more code files on your Google drive. Appreciate if each code are commented to understand them better.
Sure, I will upload more files on google drive. Anything for my subscribers.
Does alpha vantage also provide sector and industry information a company belongs too?
hello sir i am facing one problem when i import this data into mysql the date column is not inserting in the mysql please answer how can i handle this problem it will help me alot
I guess you are making mistake in data cleaning. I recommend you to copy paste my code on Alpha Vantage saved in google drive and then run line by line to understand the mistake.
How would we pull in a larger date range for the 5 min chart? eg all of 2023 or 2024?
How to get the symbol / ticker for any nse/bse companies
You can refer yahoo finance for it.
Great video by the way
Glad you enjoyed it
I guess it's stopped providing nse data... Any other options for nse intraday data
We will have to webscrape NSE data for that. Do you want me to cover a video on that?
@@FinancialProgrammingwithRitvik Thanks for responding... I was trying out many things... Now I can web scrab 15 mins data from Yahoo finance... But when I am trying to import 15 mins MACD or 15 mins MFI data from Yahoo finance and also not able to get Hakin Ashi data from investment.com by doing web scraping, I am not able to do that... Can you make a video on how to import data from live charts from investment.com or upstox or zerodha by doing web scraping it will be really helpful... What you thinks will you be able to make a video on that
Great video thank you! My code runs well on VS however how are you able to view the other get_ ... options to pop up (symbol_search or quote_search ...)? Is there an extension I can install for this?
It's my pleasure 😊. I couldn't understand the question. Could you please elaborate? Are you talking about any specific get...?
Wow man, this is great stuff!
Thank you. Did you like Alpha Vantage API in Python?
@@FinancialProgrammingwithRitvik i did! it was great
Question: Do you have to use colab to see results? I am using VS code, but running this same code doesn't throw errors but it won't show any data in the terminal.
Strange!
the syntax / library syntax is different than the documentation (where they use url and request). is the library syntax as you use in the video documented somewhere?
thanks for the video! i just have 1 question. where can I get a list of the tickers for different stocks?
Thanks for the appreciation. There is a list of all tickers traded on NASDAQ. I covered it in this video: ruclips.net/video/4mrw4aI2_j8/видео.html
Do you know how far back does daily data go? I don't see it mentioned anywhere but looks like about 2 months from what I see? Thanks!
Never read about it. But I guess it would be written in their documentation.
Sir,how to append aroon values in bitcoin trading bot?
Please refer your comment on this video ruclips.net/video/KYQisveoOMQ/видео.html
Hi, Can I get nse data from this site? Its says global market, so I assume that would include NSE too. If yes, do I need to prefix the symbol like NSE: or something? Can you please confirm? Thanks
It does not provide NSE data for now but I guess they are working really hard to cover Indian markets very soon.
@@FinancialProgrammingwithRitvik Thanks for confirmation.
👍
Could you create a video on parsing data from company overview? I am having trouble finding information on this. I just want the EPS of a given company. Thank you for this video.
I will try to cover it in my upcoming videos.
Can I get buying volume and selling volume separately for 5 min data frame
Is it work in Indian stock market for live data about stock CMP
I think Alpha Vantage recently expanded to Indian Market. I'm not 100% sure on that.
i need to show live stock prices of multiple stocks to my web site ,which end point i can use for live stock price ?
Stock prices live data is mostly available with some cost.
what if we take live market data from nse and make API .... 🤔🤔
Hi, I want to ask if it is possible to load an RSI indicator for more than one joint stock company from Alpha Vantage at the same time? And what would such a script look like?
Yes, It is possible. We would need a for loop for that or we can use a batch API
I only want to download historical data from any asset, for example.... from 2000 until 2023 in any time frame in any asset. Pleasee
hey appreciate this help, but i couldn't find the code documentation anywhere. The doc just contains how to get json file. Please help
You can find Alpha Vantage API documentation in the description box. :)
its not working for Indian stocks at NSE
I agree... I will cover a video soon specifically on Indian stocks
@@FinancialProgrammingwithRitvik ok😀
👍
can you get fundamental data for a list of tickers?
Yes, We can. We just need a for loop for that.
@@FinancialProgrammingwithRitvik so you can’t pass in a list of tickers to get past the request limit?
@@FinancialProgrammingwithRitvik can you show us how please?
Yes, free version has a limit to export the data... then you will have to wait for sometime to extract more. What you can do here is run a few tickers, save it, then run for more tickers, save it and so on. You can also make it automated.
Sure, I will try to cover it in future videos.
Thank you for this. New to this and having trouble with data[0] and run. Nothing happens. Cannot seem to get a return in pandas format. I have pip installed pandas and was able to print the pandas version number (1.2.3). Using Visual Studio Code. Is there something I am missing? I see a lot of people starting their code with import pandas as pd. Is this not necessary? I have tried it both ways.
Thank you for appreciation. Try using Anaconda Jupyterlab. If the problem is still there, then Google Colab will work for sure.
Hi, looking for free stock API usages in Python. I am glad to visit your Channel. Informative and helpful. Keep up the good work.
Thank you
im a student at a uni studying python and AI programming but this is something that is very practical...thanks a bunch!
It was my pleasure. Are you making a Trading bot using websocket-client?
Yeah. Finally Alpha-Vantage, for me the best provider. Thank you for covering. And now some more pandas data juggling. Moving averages and so on. :)
My pleasure. Thanks for the appreciation.
Alpha vantage is not getting any Indian stocks. Can you please help.
Indian Stocks' data is rarely available for free. I will check if there's any way to get it for free.
thank u brother , your video helped me alot
My pleasure.
After running the script for time series data, how do you "extract" the full data to excel etc as a csv file?
You can save it using Pandas library... df.to_csv
Have I solved your doubt?
You do long great job sir. Thank you very much !
Thank you for the appreciation
great tutorial!
Glad you think so!
Does this API provides data of Indian Stock Market like NSE/BSE ?
I don't think so. There are other APIs available for Indian data.
This api is useful for indian stocks also ?
Unfortunately, no... Alpha Vantage is not available for Indian stocks. But I will soon cover APIs related to Indian stocks as well.
@@FinancialProgrammingwithRitvik okay man please find some APIs which are almost free and helpful for indian stocks
It's my highest priority now.
Hello Ritvik, Thanks for providing us such an informative video. But I stuck to reading Indian stock market data using this API.
Can u please help me out??
It does not provide Indian stocks data. I would try to cover Indian stock data API soon.
Does alpha vantage provides real-time data from Indian stock exchanges such as nse and bse .?
It does not. I would try to cover Indian stock data API soon.
data = ts.get_intraday('AAPL', interval='15min'). does anyone know how to set the beginning and end of the period for receiving data?
One API call to Alpha Vantage counts as just one API call. There are no limits to the number of data points from an API call. To change the date range in python, put outputsize='full' (it will return the full-length intraday times series, commonly above 1MB ). Then you can easily get desired data as: data_date_changed = data[:'2019-11-29']
You may see some other related codes in my Google Drive.
@@FinancialProgrammingwithRitvik can we get 1 second data?
can we get NSE Symbol Stock EOD data using this API?
I have uploaded videos on NSE stock data recently. Please check them out.
how to get Bitcoin,doge,eth data
what their ticker name?
Ethereum has ETH... I don't know about the Doge... I think it is DOGE only.
Great content - educational!
Thank you so much for your appreciation! :)
do you have any other website like alphavantage from where i can download datas of indian stocks
I am working on a library which will synchronize all these free libraries in one. It will be launched soon. Please stay updated.
Great video! Thanks for making it. New subscriber :)
That's Great. Thanks for the appreciation. Let me know if you want me to cover any specific topic in my upcoming videos.
the data we are getting are in which currency? plz reply sir
It's in USD
@@FinancialProgrammingwithRitvik hello sir i am working on stock market historical data for usuk project so i need all tickers for specific exchange, can we get all tickers for specific exchange using python ? how? please reply if it is possible it will be very helpful for me.
This is extremely helpful!!
Glad you think so! What other API you have heard of? I would like to cover as many as possible.
Hey! Thanks for this video ; ) I wanted to use crypto (for example BTC-USD) instead of a stock symbol, how can I do that, please? I tried to follow the documentation and do: from_currency=BTC&to_currency=USD but it doesn't work too...
I mentioned how to use crypto exchange. But no worries, just look into the file I saved in Google Drive and you will understand :)
How I can get over all data of traded volume quantity and delivered quantity for comparison
Can you make a project on this pls
It's very helpful for me
Hey! Can you please help me and provide the ticker code? I am unable to find it. Need it for my dissertation :)
What is ticker code? You mean tickers? Like AAPL, MSFT?
@@FinancialProgrammingwithRitvik yes what should be the code for indian stocks?
So, I can do the same but using Pyspark?
Sir,how to get second to second data?
It's not covered under free version. Second to second free data is only available for real time... Please refer this video to learn more... ruclips.net/video/z2ePTq-KTzQ/видео.html
@@FinancialProgrammingwithRitvik thankyou so much,sir.
Its,helpful
Thank you. Very usefull informations. keep the good work.
Can i use alpha-vantage to retrieve data only for HFT companies on NASDAQ market ?
Not sure of. Please check with their team.
Hi, is there any way of fetching real-time data ? Like what we get to see in any trading application it's continuously updating each 5 to 10 seconds.
Yes, I covered it here... ruclips.net/video/z2ePTq-KTzQ/видео.html
@@FinancialProgrammingwithRitvik thanks for helping ! One more question, what is the average delay of Alpha Vantage Intraday data from realtime data ?
I will have to check it myself. I will let you know once I find something
@@FinancialProgrammingwithRitvik Okay please let me know and yes, thanks a lot for these awesome tutorials ❤️
My Pleasure :)
is there any api in order to get fund data?
Yes, I will try to cover it in future videos.
@@FinancialProgrammingwithRitvik great, looking forward to it!
@@manuelwunderle7271 let me know if you want me to cover any other topics in the future videos.
Does it work for Japanese Market ? because I am constantly getting error, for example 7974.T
I think it won't work with Japanese market. I'll have to check it. Have you tried putting only 7974 without the "T"
@@FinancialProgrammingwithRitvik if I take the T it won’t understand the Tokyo Exchange.
@@arpsami7797 I know I just to give a shot. For indian companies, it works and automatically takes the most popular exchange.
Great video! Thank you!!
Thanks for the appreciation.
Is alpha vintage works with Indian companies.
great video just what I needed. I have seen your code on the google drive It is not very clear to me how can I use it to build a nice app with tickers and financial parameters
What is unclear to you?
The code is the backend code. I was hoping we get to see the code as it on Jupiter note book cells. Thank you.
It's the updated Code. No worries, I just uploaded the Jupyter notebook code you saw in the video as well :)
I just sent you an email with the directions to follow. Let me know if the problem is solved now. I feel great to help my viwers :)
Hey thanks for such a wonderful video but i would like to know if i would be able to get the fundamental data of the indian stock market through this api?
It does not provide Indian financial data. We need to buy data in India. However, I am looking forward to something that's free and will cover it on this channel very soon. 😉
Much needed video!!!
Glad you liked it!
Thanks man!!!! It is very helpful...
Can I use Alpha Vantage for Indian Stock Market??
Indian Stock market data is rarely available for free. I will try to find a free way to do it very soon.
Hello Ritvik, this was quite informative. I wanted to know if we could get Indian Stock Data and also Indian Companies fundamental data. I tried putting .NS and .NSE in the ticker symbol but those didn't work. .BSE worked however. Still I am not able to access the fundamental data, and the NSE data. Please help. Thank you.
Alpha Vantage will very soon expand to Indian Markets as well (as per their recent announcements), Let's see when it happens.
@@FinancialProgrammingwithRitvik I want to work on a project, how much time is expected for this?
@@DEEPANSHUAGGARWAL Which type of project are you planning?
@@FinancialProgrammingwithRitvik actually i had the same question.... i am on a project where i am performing algotrading using some indicators for buy and sell decisions...so i started with getting the NSE data...but the numbers differed from actual ones. The data was in dollars and even after conversion, they weren't matching....and this worked only for INFY ticker...please tell me how to get data for indian stock exchanges(NSE and BSE). thankyou for the tutorial.
can I get futures historical data?
We have to pay to get this data. I will research if there's any free data provider here.
Thank you sir! Glad I found your channel!
Welcome!
Great video dude! I have one question. How do I use Alpha Vantage and Pandas to get (e.g. FB's price data from 1-Jan-2019 to 31-Dec-2019). I'm confused about which documentation to use.
I have a detailed code saved in the google drive. You can refer it for this. Do you have the access?
tasi market (Saudi stock market )
from where can I get the information or api providers Saudi market
Thank you
I'll have to research on this. What type of data are interested in?
@@FinancialProgrammingwithRitvik Financial statements i get it from tdawl website you can check by this
colab.research.google.com/drive/1-6FUhi_Vj4Sr4GB0DtPRPPeXZwUSx9zR?usp=sharing
but if you have better idea will be awesome
@@Hajar23456 sure, I'll see 😊
Hi Ritvik, i need the python code for pulling the stocks below 10 /- from bse, nse on specified date. Please help me if you have any
We can do it by extracing data from yahoo finance and having a for loop to get all the stocks below 10 rupees.
Thank you for sharing this information. I have a question. Not too knowledgeable with Python myself. Is it possible to instead of entering each symbol manually, to pull a list of symbols from a .csv file? Thus automatically retrieve the price data and save the output into an excel file for further analysis?
Yes, absolutely. It is possible. Thanks for the appreciation, Ricardo.
Would love it if content just like this were introduced for the Julia Language
I only use Python 🙈
@@FinancialProgrammingwithRitvik might consider looking into it. I've been coding a grand total of three weeks and am picking it up pretty easily. The language is very similar to python
I will check it out now. Thanks for the suggestion.
how can I get data on the Pakistan stock exchange by using alphavantage API?
HOW TO GET NSE AND BSE DATA AND SYMBOL USED
I think we can get. I think INFY.BS should work. Similarly INFY.NS... let me know if it works otherwise I'll do some more research and let you know.
And if any one know any api for getting trading quantity and delivered quantity of any stock for overall historical analysis
I'm curious if this is still the best? I'm looking for a free api for a stock app
There are many APIs out there, but still I like it the most; depends on your usage as well.
@@FinancialProgrammingwithRitvik nice. Have you compared this to finviz and the free yahoo finance api
Is it a free API KEY of the paid version?
They have both Free and Paid APIs.
Nice video, keep going 👍
Thanks 🙂
Great Content! How can we save data to CSV format?
Thank you so much for your appreciation! :) We can save the data using Pandas... through "to_csv"
Hi, this is a wonderful video, I found it unique and satisfying
Thanks :)
Could you please make a video on how to do fundamental analysis of stocks using this API and the few indicators available such as PE ratio, income etc
Definitely, It is in my checklist already. I am planning to make a trading bot and a simple robo advisor using fundamental analysis :)
how do you get the alpha vantage data into collab?
Dixon, it's the same as we do in Jupyterlab. First, install alpha_vantage then use it the same way. You can copy my code from google drive open it in google colab and then try extracting data. Please Let me know if there's any other question.
Very helpful, thank you!
Glad it was helpful! Just surveying my viewers, have you got your desired data through Alpha Vantage?
Really helpful, can also share to connect such data with Airtable or WordPress?
That's a nice suggestion. I will try. Thanks.
@@FinancialProgrammingwithRitvik Thank you, will be waiting for this
Great video, can you make an API for binary options?
Noted!
Is there any free API for NSE data?
I will check and try to cover it here. Thanks for the suggestion :)
Can we get data for following from alpha vantage API
1.) NSE (Indian National Stock exchange)
2.) BSE (Bombay Stock Exchange, India)
3.) F&O (Future and Options India)
4.) MCX
Not yet, but I guess they are working really hard to cover Indian markets very soon.
@@FinancialProgrammingwithRitvik Thank you so much for your quick reply...!
@@FinancialProgrammingwithRitvik can you suggest me which API/website is providing this data?
Very good work..
Thank you! Cheers!
very good videos. usefull, very precise and clean examples. please keep up the good work.
Thanks and welcome! Did you like the Alpha Vantage Package?
Thanks for this video ;)
Our pleasure! Did you like Alpha Vantage API?