Thanks for this video! My first financial data scraped! Finally someone did a video on this that I could understand. Do more of this sort of stuff please!
I'm glad you liked it! I do have a few other videos related to the financial side of things (DCF, and monte carlo -- feel free to check those out!) I have a few other videos (And a ton of financial related ideas) related to finance coming down the road.
noobie python here could'nt figure out how to convert json to csv so i write code to downoad csv. then open csv from desktop via csv reader. this way easier. 1 line of code in line 20 in video was all it took. thank u.
Hi, I am not sure if you covered this, but do we have to pay to get cash flow statement? I keeping getting "This endpoint is not available under your current subscription please visit...." when I try to retrieve it. Income statement was very easy to retrieve. Thanks for your help! Love the video!
Hmm. What do you mean by analyzing data? Many of the videos I have posted "analyze" data to some extent. Maybe some cleaning videos might do you some good? ua-cam.com/video/iLI_ymRe0w0/v-deo.html
Hi Spencer Thanx for the video its far more educating than i realised.........would you please make the .py file available, i n9ormally use sublime text...thanks in advance
Great tutorial.!! I have a question.. I would like to know how import data to google sheet in cells that are already filled by other data. ?? I'm trying to automate my stocks imported financial data (income statement, balance sheet, cash flow statement) but I'm only able to import one by one because google sheet cells are already filled by the first stock data I imported.! For example if I want to import balance sheet data of my stocks and the first imported stock data fill cells B2:F57; I would not be able to import financial data of the rest of my stocks because cells are already filled by the first stock ticker data.
That seems like a wide table (with multiple tables). Have you looked into creating an entirely new sheet with the financial statments listed separately ?
@@SpencerPaoHere I tried to do so but I still didn't find any source explaining how to do that. Should I use google script ? or is there any other simple formula for what I'm trying to do ? Thanks
@@moneymaker8227 I like to use python for these situations (quite versatile). You can check out this post here that may be of assistance: stackoverflow.com/questions/67551298/using-python-to-create-a-new-google-sheet
Hi Spencer, thank you for your great work and inspiration. I want to ask do you have some good and reliable source of fundamental stock data which is affordably priced? Thank a lot!
No problem! I'm glad I was helpful. Now, it depends on what you mean by "affordable". If you're willing to spend a little bit, Morningstar is notable and has some quality data. They go for around $250 per year. Eikon Reuters can go for $3,600 for a reduced version per year.
Hello, Do you know how I can edit the code in-order to get the quarterly NIAT of all the publicly traded companies in the S&P 500. I really want to have a script like the one you made. So I can see what businesses have the highest quarterly net income after taxes growth so I can buy their stocks. I've been wanting to automate that for years. But I have no idea what I'm doing when it comes to coding.
You could pull my code on github and run it on your local machine. You'd just need to get the appropriate ticker symbol AND address/location of what data you'd want to scrape.
When I call this function, def get_daily_prices(ticker, timeseries, key):, i get ValueError: If using all scalar values, you must pass an index, can you tell me how to fix this - thanks Ed
For the Financial Modeling Prep site, you are limited to 250 query calls for the lifetime of the account (unless you pay for a subscription) And yes. I think that each GET/POST call you use on the site counts as one query through your signed account.
Is there a specific time in the video that you can point to so that I can best assist? Thanks! You can also check my github repository if you want all the code associated with the scraping process. (Everything is included) Located: github.com/SpencerPao/FinanceScrape
Perhaps this video might help you: ua-cam.com/video/tQqKQOsjEw8/v-deo.html If you prefer a more in-depth approach, you can check out this site: pandas.pydata.org/docs/getting_started/index.html#getting-started
Thanks for this video! My first financial data scraped! Finally someone did a video on this that I could understand. Do more of this sort of stuff please!
I'm glad you liked it! I do have a few other videos related to the financial side of things (DCF, and monte carlo -- feel free to check those out!)
I have a few other videos (And a ton of financial related ideas) related to finance coming down the road.
Hi Spencer, just wanted to say thanks for making this! This was my first time doing anything like this and managing to get it to work!
Thanks
Thanks for the motivation again
noobie python here
could'nt figure out how to convert json to csv so i write code to downoad csv.
then open csv from desktop via csv reader.
this way easier. 1 line of code in line 20 in video was all it took.
thank u.
I'm glad I helped!
All I did was search saving alot of data to find some Pokemon platinum diamond and pearl videos and I got a financial video.
Hi, I am not sure if you covered this, but do we have to pay to get cash flow statement? I keeping getting "This endpoint is not available under your current subscription please visit...." when I try to retrieve it. Income statement was very easy to retrieve.
Thanks for your help! Love the video!
There is an endpoint that has cash-flow-statement that you can reference at the end of the URL
do you have video teaching the basic of analying the data, like one or two.e.g.
Hmm. What do you mean by analyzing data? Many of the videos I have posted "analyze" data to some extent.
Maybe some cleaning videos might do you some good?
ua-cam.com/video/iLI_ymRe0w0/v-deo.html
i sub you because you say welcome!
Hi Spencer
Thanx for the video its far more educating than i realised.........would you please make the .py file available, i n9ormally use sublime text...thanks in advance
I'm glad you liked it!
I've uploaded the corresponding scripts on my github: github.com/SpencerPao/FinanceScrape
@@SpencerPaoHere You're a star...thanks man
can you do one for google sheets
Great tutorial.!! I have a question.. I would like to know how import data to google sheet in cells that are already filled by other data. ??
I'm trying to automate my stocks imported financial data (income statement, balance sheet, cash flow statement) but I'm only able to import one by one because google sheet cells are already filled by the first stock data I imported.!
For example if I want to import balance sheet data of my stocks and the first imported stock data fill cells B2:F57; I would not be able to import financial data of the rest of my stocks because cells are already filled by the first stock ticker data.
How Can I RESOLVE This Issue.??
Thanks
That seems like a wide table (with multiple tables). Have you looked into creating an entirely new sheet with the financial statments listed separately ?
@@SpencerPaoHere I tried to do so but I still didn't find any source explaining how to do that.
Should I use google script ? or is there any other simple formula for what I'm trying to do ?
Thanks
@@moneymaker8227 I like to use python for these situations (quite versatile). You can check out this post here that may be of assistance: stackoverflow.com/questions/67551298/using-python-to-create-a-new-google-sheet
@@SpencerPaoHere thanks I'll check it
Hi Spencer, thank you for your great work and inspiration. I want to ask do you have some good and reliable source of fundamental stock data which is affordably priced? Thank a lot!
No problem! I'm glad I was helpful. Now, it depends on what you mean by "affordable". If you're willing to spend a little bit, Morningstar is notable and has some quality data. They go for around $250 per year. Eikon Reuters can go for $3,600 for a reduced version per year.
Hello, Do you know how I can edit the code in-order to get the quarterly NIAT of all the publicly traded companies in the S&P 500.
I really want to have a script like the one you made. So I can see what businesses have the highest quarterly net income after taxes growth so I can buy their stocks.
I've been wanting to automate that for years. But I have no idea what I'm doing when it comes to coding.
You could pull my code on github and run it on your local machine. You'd just need to get the appropriate ticker symbol AND address/location of what data you'd want to scrape.
When I call this function, def get_daily_prices(ticker, timeseries, key):, i get ValueError: If using all scalar values, you must pass an index, can you tell me how to fix this - thanks Ed
Ah. FinancialModelingPrep has changed their API. I updated the code on GitHub to accommodate this change.
Great video! Do you know how to get past float??
float is a datatype and can be addressed. It depends on your situation. But you can look into casting.
Does executing this count as 1 of your 250 calls with the free plan for financial modeling prep? Or is the 250 call limit a new thing they have added?
For the Financial Modeling Prep site, you are limited to 250 query calls for the lifetime of the account (unless you pay for a subscription)
And yes. I think that each GET/POST call you use on the site counts as one query through your signed account.
Genious¡¡¡ thank a lot for this video¡¡¡
Could you show in detail how you made the finance_scrapper
Is there a specific time in the video that you can point to so that I can best assist? Thanks!
You can also check my github repository if you want all the code associated with the scraping process. (Everything is included) Located: github.com/SpencerPao/FinanceScrape
what about symbols with dots inside? why i cant call them?
Hmm i’m not sure what you’re referring to. Can you provide a time stamp or something to reproduce the scenario?
Do you have any book recommendations on pandas?
Perhaps this video might help you: ua-cam.com/video/tQqKQOsjEw8/v-deo.html
If you prefer a more in-depth approach, you can check out this site: pandas.pydata.org/docs/getting_started/index.html#getting-started
thank you