Forum Discussion
Post PatronImporting Stock Data into Power BI recomendation
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
Super UserHi 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
Post PatronI 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.