skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Overview
    • Find consulting services
    • Partner showcase
    • Find a partner
    • Become a partner
    • Instructor-led training
    • Getting started
      • Overview
      • Online workshops
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 
    • Microsoft Power BI Community
    • Galleries
    • Data Stories Gallery
    • Nigerian Stocks Market Analysis (Live Report)

    Nigerian Stocks Market Analysis (Live Report)

    03-28-2017 01:45 AM

    olafusimichael
    MVP
    4961 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    olafusimichael
    olafusimichael
    MVP
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    Nigerian Stocks Market Analysis (Live Report)

    ‎03-28-2017 01:45 AM

    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

    Preview file
    114 KB
    Message 1 of 5
    4,961 Views
    4
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    pokdbz
    pokdbz Helper II
    Helper II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎05-15-2017 08:20 AM

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

    Message 5 of 5
    4,665 Views
    1
    Reply
    jamalq123
    jamalq123 Helper II
    Helper II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-11-2017 02:39 AM

    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/15...

     

    Regards,

     

    Jamal Qamar 

    Message 2 of 5
    4,874 Views
    0
    Reply
    shayanrizwan
    shayanrizwan
    Frequent Visitor
    In response to jamalq123
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎08-14-2021 01:18 PM

    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 

     

    Message 4 of 5
    1,247 Views
    0
    Reply
    olafusimichael
    olafusimichael
    MVP
    In response to jamalq123
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎04-14-2017 12:56 AM

    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

    Message 3 of 5
    4,861 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    California Consumer Privacy Act (CCPA) Opt-Out Icon Your California Privacy Choices