topic Re: Nigerian Stocks Market Analysis (Live Report) in Data Stories Gallery

Nigerian Stocks Market Analysis (Live Report)

olafusimichael — Tue, 28 Mar 2017 08:45:19 GMT

I use Power BI for my Stocks Analysis. Here is the very dashboard I use, it shows all the analysis I do when considering which stock to buy and allows you to compare companies.

Enjoy!

P.S.> It is updated daily with live stock price.

eyJrIjoiZDQ5MDZjOGItMmE4Yi00N2UzLWJlMjUtYmRiZGYxNDk0NDQ5IiwidCI6IjgwZTlhM2Y3LTZhNTQtNDQ2OS05NTlhLWQ2MWFhNTM4Y2M4ZiIsImMiOjh9

Re: Nigerian Stocks Market Analysis (Live Report)

jamalq123 — Tue, 11 Apr 2017 09:39:07 GMT

Dear Michael,

You did an excellent job. I need your guidline that how scroll works with live data of stock market. I want to take live data from https://www.psx.com.pk/. Please help me, if you can share pbix, then it will be more helpful for me. I also added soem template on the Data Stories Gallery, please find the link given below:

https://community.powerbi.com/t5/Data-Stories-Gallery/AUTOMATED-FINANCIAL-STATEMENTS-ANALYSIS/m-p/157046

Regards,

Jamal Qamar

Re: Nigerian Stocks Market Analysis (Live Report)

olafusimichael — Fri, 14 Apr 2017 07:56:29 GMT

Hi Jamal,

Thanks for the kind comment.

We had to have a developer do the backend aggregation of the daily stocks data and warehousing them on a cloud SQL server database which the Power BI dashboard connects to in pulling data with daily scheduled refresh.

I looked at the Pakistan Stock Exchange link you provided, it doesn't seem to have a list of stocks and their prices. You might need to buy an API access from them or someone else for that data.

Regards,

Michael

Re: Nigerian Stocks Market Analysis (Live Report)

pokdbz — Mon, 15 May 2017 15:20:21 GMT

How did you create the bar at the top based on the measure that filters the chart below?

Re: Nigerian Stocks Market Analysis (Live Report)

Anonymous — Sat, 14 Aug 2021 20:18:23 GMT

Hi Jamal

I'm trying to build a similar dashboard for PSX stocks. Is it possible if you could me from where were you able to fetch the data?

Thanks,

Shayan