Forum Discussion
Post PatronImporting Stock Data into Power BI recomendation
Hi
I want to get data from a website which has all stocks and then using Power BI, I will create visuals to show Top 10 stocks in term of price, volume, active, decline etc and some other analysis. I want to do this as project to learn about Power BI and getting date from the internet. I am trying to avoid DAX for now since I am not that familiar yet. Do you recomend any website I can get data from or do you recomend any source file I can learn from. Thank you so much.
Hi lastnn30
What you are asking is quite involved for someone starting out, but do-able.
These articles show you how to create finance/stock dashboards in Excel.
Personal Stock Portfolio Dashboard • My Online Training Hub
Interactive Personal Finance Dashboard • My Online Training Hub
Whilst they are created in Excel, the techniques used will teach you about getting and presenting data.
If you want to fetch data from websites via API, or scrape them, these articles look at that. Both use Power Query and/or Power BI Desktop
Getting Started with API's in Power Query • My Online Training Hub
Scrape Data from Multiple Web Pages with Power Query • My Online Training Hub
Excel supports getting stock data directly into teh worksheet. But if you are using PBI you will need to load data from somewhere like Yahoo Finance, the ASX, NASDAQ websites etc. Just search for stock price data and there will be many results to choose from.
Historical data is usually free to use. If you want real-time (live) data, you will have to pay for that.
regards
Phil
2 Replies
- PhilipTreacy
Super User
Hi lastnn30
What you are asking is quite involved for someone starting out, but do-able.
These articles show you how to create finance/stock dashboards in Excel.
Personal Stock Portfolio Dashboard • My Online Training Hub
Interactive Personal Finance Dashboard • My Online Training Hub
Whilst they are created in Excel, the techniques used will teach you about getting and presenting data.
If you want to fetch data from websites via API, or scrape them, these articles look at that. Both use Power Query and/or Power BI Desktop
Getting Started with API's in Power Query • My Online Training Hub
Scrape Data from Multiple Web Pages with Power Query • My Online Training Hub
Excel supports getting stock data directly into teh worksheet. But if you are using PBI you will need to load data from somewhere like Yahoo Finance, the ASX, NASDAQ websites etc. Just search for stock price data and there will be many results to choose from.
Historical data is usually free to use. If you want real-time (live) data, you will have to pay for that.
regards
Phil
lastnn30I think you are right. I am not 100% ready for API etc. but you reply and the links will be a good start for me. So I would like to thank you a lot for that. Thanks once again. I appreciate it.