You can also install my updated Nigerian Market Data Excel app. If you don't have Excel 2016, just head to Excel Online (https://office.live.com/start/Excel.aspx) and install by clicking on the Insert menu, Office Add-ins, search for "Nigerian Market Data" and add/install it. Same steps if you use Excel 2016.
Here is the list of features it now has:
- Insert latest (yesterday) closing price of stocks on the NSE, insert historic closing price of a specific company and insert closing stock prices of all companies on a specified date.
- Insert quantitative analysis of the financial statements of companies on the NSE from as far back as 2005.
- Insert foreign exchange rates of major currencies against the Naira, using Naira as the base. So no need to start converting first to dollars and then back to Naira as is the case with most other currency converters.
- Insert records of Nigerian Crude Oil production volume per month
- Insert Nigerian GDP Growth rates from as far back as 1980
- Insert Nigerian Inflation rates (CPI monthly) from as far back as 2007
- Insert CBN interest rates from as far back as 2007
- Insert Nigerian population figures from as far back as 1980 (interestingly we were 68.4 million in Nigeria then)
- Insert unemployment rate from as far back as 2010, quarterly.
- Insert states and their capitals in Nigeria
- Insert all the Local Government Areas (LGAs) in Nigeria by state
- Insert as many random Nigerian names you need, maybe for demo data purpose (no need to use foreign names copied online or waste time typing random names)
- Insert as many short inspirational quotes as you want, ideal size for posting as tweets
Don't forget to install it and share any feedback you have.
Thanks!
Hey sir,
ReplyDeleteWhere can I get the Power BI app?
Thank you a muchly.
Hi Ron. You can download the Power BI app from www.powerbi.com
Delete