hi
i had the same problem... i analyse my stocks with excel and i wanted the closing prices for the last full year.
The easiest way I found was to get them there (For COOP as exemple):
http://live.mystocks.co.ke/stock=COOPIts not for free but payable if you only got in and export the data.
There is also the possibility to make it by hand from the bloomberg chart. For exaple here:
http://www.bloomberg.com/apps/quote?ticker=COOP:KNGo to the big Chart and do it by hand ;-). Was the only way I found for Stocks in Botswana...
Maybe there are a lot of other options, but I only f0und this two in short therm..
hope it helps