Back to blogging

Two things got me off blogging over the last 2months+.
First I divorced my previous web host because they got too cranky, nagging and wanted things I couldn’t give (more money!) despite the fact that their performance was just marginally better than a Russian Lada car raising a dust storm on a back road in Western Sahara. Along the line my bro hooked me up with another host but didn’t kind of fancy her (or it?). It lacked the pizzazz to make my blood sizzle. So like what boys do, I went searching for that fancy host. Found one, paid top dollars and guess what, absolutely rubbish! Too bad, premium wine down the basket, so back to the host I spurned – the one from my bro. maybe elders do know what is good for us after all.
Then I got into another function at work that practically sucked all the time I have. In fact, the few minutes I could eke out each day are spent thinking of how I could invent a time expander. Since Einstein said that time is relative, maybe I could find a way to get more minutes per hour, especially between 12 midnight and 5AM in the morn.
On a serious note, I’m actively considering my interest in ColdFusion. I have stick this for so long but I think Adobe is too greedy and too shortsighted that in 5 years, only dinosaurs would know how to write CF. Getting a decent hosting for a CF site is like asking for a pink elephant with wings. I could search forever.
Time to start punishing my friends with those crazy posts!

Download Nigerian Stock Exchange Historical Stock Price Dataset

Some months ago I was trying to do some data analysis on historical equity data with Geek Impressario, Femi Aluko, but we practically ran into brick walls: no data. There wasn’t any easy place to get daily prices in one single place.

I turned to a friend who had one but then due to some vague business secrecy, I was told to hug an electric pole (told in a nice way that I actually looked forward to that shocking experience).

So like what geeks are known for, our impresario sat down and cooked some codes, helped with a generous dose of caffeine and bush meat and presto, a scrapper was born to scour the web for fragments and we built a database of the stock prices from January 1, 2000 till date.

But we won’t be asking you to hug the next shocking thing you can lay your hands on, we have decided to give out part of the data to anyone who needs to download and use for any type of analysis or financial weapon of mass destruction that can be cooked up.

The data is available for download in CSV from Google Docs. The data we have made available ends at December 31, 2010.

By the way, download and use this data at your own peril. We make absolutely no claim that this is not more than a collection of numerical junks.

Power supply so good; and then so bad

I don’t know if it’s just my end alone but of recent the electricity supply from PHCN has been pretty good. In fact too good to be true. But who can satisfy Nigerians? Trust that I still need to gripe about it. Why? Well, it is a bit complicated. I use a prepaid meter and the non-stop electricity supply is zapping my “credit” so fast you could think that the utility meter is a stop watch. To get me even more annoyed, government announced that they are upgrading the prices to N25/KwH soon. Why do we always benchmark cost to other countries but we never do same for minimum wage or roads or rails or [*insert your gripe here*].

The following table shows the price of electricity per Kilowatt Hour across different countries. This should serve as a quick reference to what other guys pay in these countries.

Country$/KwHN/KwH
Kingdom of Tonga0.457073.12
Denmark0.428968.62
Italy0.372359.57
Netherlands0.347055.52
Germany0.306649.06
Philippines0.288046.08
Sweden0.273443.74
Ireland0.238938.22
Spain0.195031.20
France0.192530.80
UK0.185929.74
Croatia0.175528.08
Singapore0.173427.74
Portugal0.163926.22
Nigeria (Proposed)0.156325.00
Hong Kong0.123019.68
Iceland0.116118.58
Belgium0.114318.29
Perú0.104416.70
South Africa0.101516.24
USA0.092814.85
Malaysia0.074211.87
Australia0.071111.38
Finland0.069511.12
Nigeria (Currently)0.062510.00
Canada0.0618  9.89

Infopenia – when paucity of information saps life out of a business

It is no coincidence that many have likened organizations to organisms. Both are born, grow and die, sometimes not in the prettiest fashion. Organizations sometimes are seen as complex mechanisms. Organisms are organic mechanisms. Ok, I need to stop here; it can get quickly confusing.

If complex organisms, such as animals (me, you, your cousins and their pets), fall sick then I assume that organizations could fall sick too. Illnesses are caused by diseases and they manifest with symptoms. Unfortunately while you could drag a human to hospital or haul a dog to a vet, most people don’t even know when an organization is sick and even when they know, there is no place to drag them for a fix.

There is a strange illness called infopenia. It ravages organizations by impeding their growth and then chokes them to death, It is similar to leukopenia, a dangerous illness that kills mortal organisms.

Infopenia is an organizational malaise where there is a dearth of information that subsequently prevents effective decision making and doesn’t allow just any random staff from knowing what should have been taken for granted. This is apparent when the average employee does not know all he needs to about his organization and when he doesn’t know, there is no place for him to undo his ignorance. When employees don’t have access to information, no matter how mundane, it slows down his decision making, ensures that those precious “ha ha” moments never come and trust me, they ultimately frustrate your customers. Apparently, the competitors wouldn’t mind.

A good example of the manifestation of this malady was when HP sued a company in Germany for an illegal operation concerning its doomed TouchPad. The sad part is that the “offending” company was contracted by HP itself.

Interestingly infopenia doesn’t affect small businesses the same way a bacteria couldn’t have a broken leg – you get the drift? But as an organization starts to add staff and departments, the impact of poor information management starts to crop up. In fact, there is a formula to denote the complexity of information sharing within a large group: n(n-1)/2 where n is the number of possible colleagues that could annoy you.

One of the attributes of efficient and fast-growing company is that information is open, non-redundant and mashable – information from different sources can be harnessed together to unearth new insights.

In my own country, a third-world corner of the globe, while malaria and other little diseases are singing “samba” for us, infopenia is also dealing with companies trying to grow but without success. You want to try this out: Visit a random company that has more than a few offices and ask any of the frontline staff about any of their products. Then visit another of their offices and ask about the same things and see if any answers tally.

A company is likely to be infected with infopenia when it doesn’t have a single or at worst few sources of information. The new product paper not searchable on the intranet and the budget stuck inside some Excel document is a sure way to get things wrong. Redundant information maintained by different departments will ultimately get things mixed up.

Another problem rears up when senior people think the only way to protect the organization is to create information security by locking things down. While I do not subscribe to carelessness, it’s more beneficial to have information liberated than caged. You never know what fate serendipity could hand over.
Information should also be in an easy to access format. A web intranet wins hands down. A company with money to splurge could shell out some cash on fancy intranets like Microsoft SharePoint Portal but those around my ‘hood can go the open-source way. Nothing beats free.

As much as possible, data should be maintained by those who produce them – and it should be the only source. That way, you can always be sure that the product information is as correct as the product manager has put it. And if he corrects it, you get the new version. And concerning versioning, data and information should be time-stamped such that when confronted with two copies it would be easy to determine which is the most recent and hopefully the most correct.

It takes a lot to build a successful business same way an Usain Bolt must have survived a legion of different diseases before breaking the world sprint record. Good information management doesn’t guarantee the survival of a company but having infopenia is sure going to send any promising business down south.

The Nigerian Constitutions: 1951, 1964, 1960, 1979, 1989, 1999

I have been able to get two rare gems: The Nigerian constitutions for 1951 and 1954. They are the the 5th and 6th in our collection of Nigeria’s constitutions.

Question: How many constitutions would Nigeria end up with?