Basic Technical Analysis of Nigerian Equities Market Using Power BI

, , No Comments
I have been working hard on our stocks analysis platform -- -- and some of the recent additions I made are some level of technical analysis incorporation.

Personally, I took a big hit in the stock market this year. I kept buying throughout the year even as stocks were going down. I did not pay too much attention to general buy/sell trends in the market. Actually, I have a disdain for technical analysis, partly because it's a big deal in forex (currency) markets and I have always been losing money in forex (currency) markets. All the fuss about support, resistance, candle patterns and so on looked too abstract and impractical to me. 

The amazing guys at were able to make me start seeing where the practicality of technical analysis lies for a fundamentals addict like me. Got to say a big thanks to Adetunji Adeshina

The truth is that I am still a fundamentals guy and I don't regret buying throughout the year in stocks. I am as proud of the losses I have made this year as the bumper gains I made last year. The main difference now is that I pay attention to trends -- technical analysis -- and I will be less willing to catch falling knives. I invest month: I usually first take out my savings/investment from my monthly income and live on the remainder. Throughout this year all those monthly investments went to stocks (and ETFs). Going forward, I will spread the money more strategically across all my asset classes; when the stock market is trending massively downwards I will pause monthly inflow into it (except if some amazing deals pop up) and channel more into another asset class that is not evidently trending downwards (also not necessarily evidently trending upwards).

In tracking the stocks market trends, I have designed via Power BI a price and volume action tracker -- showing changes in volume activity and the very important 50 days & 200 days moving averages. You too can access this (for free) in the Power BI section of 

On the side bar, you can select any company you want to analyse. And at the upper end, there is a timeline to specify the timeframe to analyse for. The upper chart shows the price plotted to the left axis and the volume plotted to the right axis. That way you can see when the market was most active for that stock and what direction it pushed the price. The lower chart shows the current price vs 50 days MA (moving average) and 200 days MA. With these basic technical data -- price, volume and moving average -- you can pull out useful technical analysis.

You can also analyse the entire NSE All Share Index.

Don't worry about the blood stains on the lower chart. I am still trying to figure out the reason for that. 

All these, I created by using Python scripts running on an Azure (cloud) server to store daily trade data on an Azure (cloud) database, then connect Power BI directly to that database with daily auto-refresh set. So without any manual intervention on my part, every day, stocks data is being pulled directly into the charts in Power BI.

If you go through some of my Power BI tutorial videos on and you will see how I created the core of this particular Power BI report.

Power BI is, indeed, an amazing data analysis tool for better decision making.


Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.