Python Script: Real Time Stock Market Data Analysis with Python - Excel Data Scraping in 15 minutes!

today i'm going to talk about how can you download a stock or forex or cryptocurrency to your exile it's pretty easy and i'm going to show you step by step we will use the finance and they are providing the stock data forex cryptocurrency fundamentals and widgets and you can also register in their websites it's totally free and up to 1 000 requests per month and let's sign up matt mckenzie at gmail.com and make a strong password and register when you register they call it it's moon it's pretty clever actually yeah when we get to the dashboards you can start free now and free api package you have the free api package instantly okay now we have our own api key and you can just click and copy and they are also giving some endpoints it's pretty easy u.s stock forex crypto and stock aod circle data you can just make an example requested by clicking over here yes now i'm opening my visual studio code i created a new file pa and also these are two must install packages if your computer doesn't have these packages you have to install with this codes okay let's start implementation import requests and imports pandas for excel connection of course now program if my api key is open cover backs it and i'm opening to my moon dashboard and copying just click your api key and paste it is that easy okay okay the next one when i open the executor script i want to ask me the symbol name which symbol is apple tesla which one i want i want to really okay the next one it has to ask me to start dates to which dates i would like to start to catch the data inputs again okay it's called start dates okay the next one it says and dates and inputs okay and dates okay the final one now i want to get response from the request request dot gets yeah now where will we get this data i'm opening to and stock market aggregates because i want to open high low clause volume in that way and i'm just copying the end points from here and paste it the inside of it i will modify it because i will get the everything from the above multiply one because i want that one the time is day but you can make it minutes seconds or day hours which in my case i will use day and deleting the curly braces okay one day now it's start from i'm gonna use that one from symbol i'm gonna use that one and plus yes because i want to do the ask from me and i will also delete this okay stock plus symbol yeah now it's correct it will get sunboard from the up and then one day and then from two parts plus start date and plus open it close it here we are and plus and date and plus yeah let's take the api key from api key i'm going to use that one yeah to sum up guys i will just get from the finish documentation and end point and i will put my all variables above and and here okay that's all let's make the print parts prints let's call it total results false okay and from here str now i'm going to take the json because it's response to me it's json way now i'm going to turn this one is total results that's all okay let's add in plus over here because it's variable and remove that one and it's also it's unnecessary i'm checking okay indentation errors for me okay that's perfect checking also here okay now i'm continue let's create a list because i take the json from the update and push over here it's empty now for each item i'm creating a for response that's json open it and inside of it i'm pushing to results i'm getting from the up okay perfect now json elements create and open brackets okay now i'm checking to finish documentation here you can find the details it's all mean open high low close and volume and t mean it's time step you can clearly copy or you can just use that one in my case i will just chat and write it from here let's make it small and let's make it small again here okay perfect now if i want to open high levels let's make it like that it says open it's item oh because it's called it oh okay next one it's i item it's h okay the next one it's what is that open high loaf yeah let's make an invitation from here yeah perfect it's look better huh it's me why are you hating but i like that style okay now let's call it slow l in my case it's i'm just using to this the short versions of the numbers but let's select the close c okay next one is of course volume let's take the volume for data okay it's called i believe okay the last one it's dates stay to date from pandas yeah pandas to dates time in that case guys i'm changing because the finish is milliseconds now i'm converting this milliseconds to normal dates that is that's four to date time for this i'm using item t it's mean timestamp two units milliseconds yes that is off now i'm closing to my curl brackets and the last one json list appends and json elements okay and that one okay let's call it and dates if plus pandas date friend jason list two now i now we are converting to excel from here actually to exile let's take the sample plus and create and in that case i'm creating and xaml sorry xls i'm creating an xls excel file okay checking for anything wrong yeah i forgot that one thing because it's creating a sunboard plus uh that is false part because i'm telling the index false that's me when we get the excel files i will show you from the beginning it says one two three for each data but i don't want this if you want you can just put it true that's not important actually yeah i forget okay i'm just checking to all everything on this also let's make a response okay yeah here and i also change that one i will put in s here as results let's make it here and yeah we have an error here it's going to be units try i'm calling to python python3 data that's pa and now he's asking me somebody to check out the short version of assemble to finance has an incredible apps you can come here in stock ui and whenever you call it for example microsoft's and you can see the every detail and news and also the short version and in my case i'm using to apple yeah and he's asking start dates it's perfect okay let's call it and it's also it's asking for another let's make it one month okay and yeah it's give me uh 25 results my case i created this folder and yes you can see i'm opening you can also open in online excel and your excel in my case i now we have an apple open high love clause and volume in excel and the old values it's here it's incredible and you can create really cool charts charts from here yeah let's make it pie chart yeah you can easily make analysts with the data and you can let's check the clause and volume make it another charts for example that one yeah these are the claws and volume that's really incredible useful you can also get in day by day and hours and with finish and we did it with the free api it's really incredible you can create anything you want and i'm also sharing their websites and the links you can get and free api plan and 1000 requests per month in one dail updates and you can easily upgrade whenever you're ready to go in really affordable prices you can use it and thank you so much for your interest i hope you like it and see you in another video

Channel: Finageltd

Views: 1,422

Rating: 4.9259257 out of 5

Keywords: real time Stock API, market api with excel, real time forex api, python market data, python stock market data, us Stock API with excel, free Stock API, finage free us Stock API, realtime stock market data, us stock market data with excel, Python script financial data, financial data analysis with python, python api, real time stock market daha python, stock market Data API python excel, how to pull stock market data by excel with python

Id: LSa47ADI9LM

Length: 14min 21sec (861 seconds)

Published: Tue Jan 26 2021