₦airaland Forum

yodiyokun:
@Windy wendy

I think the vlookup may be useful if you keep the daily fsdh reports in different worksheets

you can create colums in worksheet 1 for opening price, close, high, low and volume - and use vlookup to populate from the FSDH worksheets.

I believe you can even link excel files.

This is getting very complicated oooo. all in the name of charting.

keep the daily fsdhh reports in different worksheets . Naa, the file will become too large then. I used to keep track of volumes by just copying and pasting from the FSDH reports, but lost track of that one when I got real busy. I think what i'll just do is format easi's report to align with the fsdh one and then copy and paste the latest volumes column from then on, unless there's an easier way. Easimoni?

@Easimoni: Thanks for the sheet on volumes! That's a breath of FRESH  AIR

How do you get the numbers? Do you input them manually or do you just cut and paste from the FSDH spreadsheet? Is there some other way to automate the population of the sheet (obviously the vlookup function in excel doesnt work for this one as the closing price sheet gets replaced each day abi?)

FatherOF2:
My dear brother pumping,na lagos state govt. get julius berger shares oh.Its hardly available.
Try not to focus on these illiquid stocks.Don't you see they always have the highest YTD % change.
20,000 can make JB or Costain jump 5% tomorrow.You'll never get to buy.
Anybody on this thread can make Chellarams move 5% tomorrow tomorrow.
If you were doing serious margin trading,you'll understand the power of volume.

My thoughts EXACTLY!

aktopgun:
ladies and gentlemen,
please allow me to introduce u'all to OLUWATAMILORE TOBECHUKWU

born 4.46am 12/12/07, 3.5kg.

mother and child alive and well, father is beat!!!

now i know why jewish men wake up every morning and thank god he didn't make them women, no be yam.
i have a whole new level of respect for my wife now.

thank you to all the fellas on nairaland for all the support.

And the journey begins.

Father is Beat ke? Hehehehehe . Abeg no make me laugh . . .

_{**wondering what father would be if he was the one that actually went thru labor instead . . . **}

BIG Congrats to you o jare! And WELL DONE to madam. That "whole new level of respect" is perfectly in order  . Don't forget to fill up the fridge with all of her favorite juices, fruits and veggies   _{plus say "goodbye" to your long and uninterrupted hours of sleep at night}  

@Pumping777: abeg no mind the vipico jare. No one pays anyone on this forum for all of the self less _{and time consuming} work and research they do. If someone is generous enough to continually find time to share information on the forum, why would anyone come to the conclusion that the person is a snub simply because he/she didn't respond to an email?

On the matter of DEAP CAPITAL's listing, I've just been informed by my broker that the listing has been postponed indefinitely. Could this be for real or is this just a diversion tactic If the listing was going to be done today then I presume that they would have already met all of the listing requirements. Why the sudden post-ponement, and indefinitely for that matter?

@Temmi10: Sorry, couldn't look thru the phb prospectus, and I don't think I'll have the time to do so before the offer closes _{no thanks to work demands. . .} But from all indications though, it looks like a good offer and (according to my broker) it has been very well received.

@All:

Anyone knows anything about Linkage Assurance? Just curious

@shigidi, did you read the proshare article about plans by Dangote Sugar to jettison the quarterly dividend thingy? that should do something for the stock. Very very good value stock by the way.

Peace!

Guys, I've really enjoyed this forum today. Gotta go. Be back next week!

@ Pumping777: Na ifeite dey incharge of generator . That your yabis na "below the belt"

Temmie10:
I doubt anyone here can really move Zenith, that is a liquid stock and 10 million units of zenith even for the mtners is a lot.
, but just in case you are out there, i hail o
BUt yes, the illiquid ones are not that difficult to move,
Just look at what shigidi and windywendy have collectively done to betaglass

Not me. Point the finger to shigidi and shigidi alone

easimoni:
Make una read these articles on Business week. It's about the potential on the African markets, esp Naija. From the latest edition.

http://www.businessweek.com/magazine/content/07_50/b4062046700574.htm?chan=magazine+channel_in+depth

http://www.businessweek.com/magazine/content/07_50/b4062052715835.htm

Who sabi Notore Chemicals and how we fit join the train?

WOW! You this man, you too much! Thanks!

shigidi:
u know i didnt know those gdrs will be credited so soon, it might be quite juicy to get those gdrs OOOOOOO.
dangote sugar is heading northward and wendy , na u cause am oooooooooooo

Eh? na so I get power reach _{and to think I didn't even know it}   In that case I better start recommending all the stocks in my portfolio  

loma:
We great Ife guys dey here too dey look, dey buy! We not get time to make noise like those boys from Akoka!

Abi o. No mind those Akoka boyz! But come o, looking like lucozade is NOT allowed na. You must contribute something. How else are we going to learn from your invaluable insight?

Temmie10:
I used to think the NSE was big enough for all of us but it seems folks from akoka with billions are drowning small fish like me out,
smiles and runs away

Abi o. No mind all these folks from Akoka. Anyway God dey sha  

As for me, I'm NOT an akokite.

easimoni:
Yes O. If you show your cards on this forum, peeps will beat you to the punch.

Talking from experience?

Temmie10:
At the end of the day, she's the prime beneficiary of all your profit cycles so she reserves that right to command abeg. I'm watching unilever too but its one of 4 or so in that frame that i am considering, nothing definite yet though, will let u know after i have bought, u know why now lol

Ah! see you! My broker will CHANCE your broker

Temmie10:
I am fine, recapping what has been a very fruitful year, and rearing to go for next year while at that
Look at phb o,

It all depends on Her Royal Highness o! She's the commander in chief for now. If she says "jump", I say "how high"  . And considering that i also have a full time job . . . _{infact let's leave that matter for now}. I'll do what I can sha.

@aktopgun,

Did I hear you say you'll be looking to invest in Q2 08? If you don't want to be hanging out with the jonses _{(you know those ones that usually miss out on the good stuff?? Yep, that's them!)}, I suggest you invest sooner, preferably in the timeframe suggested by Wanaj0 and Fatherof2.

By the way, Unilever? Sounds like a good turn-around play. I wonder why the market did not react to the results _{perhaps there's some suspicion}. But I'm kind of liking it. I'll be watching 

Anyone watching AirService, it's just on its early upswing after a long downtrend. I don't know much about this company but it's been doing this up and down trend for a while. So might be one for the momentum traders to watch. Meanwhile I heard that Aureous (the guys that bought CI leasing) recently acquired an airservice company in Ghana. Wonder what potential they saw there. Also wondering that if an airservice company in Ghana can have potential enough to attract a PE firm like Aureous, what potential do you think one in Nigeria (whose economy and airspace is multiple times more vibrant) can hold? Time to dig your heels in and do some ground work here. _{You may not find anything exciting, but again it might be worth the dig . . .}

@ temmie10 how you dey? Still haven't had a chance to look at the bank phb prospectus, but from a quick perusal, it doesn't look bad. Will see if I get a chance to look at it this weekend.

@all:

For those who've been cycling in and out of IEI, I hope you've cycled out already  . There are strong rumors of a potential suspension and share reconstruction, so unless you don't mind being reconstructed, I suggest you cycle OUT asap.

wanaj0:
All this 6-3-3-4 students are just making me feel old whereas my mates are still planning to play You 17 tournamnet come 2009!!!!

Well, UBA na special breed. If not provision for some doubtful loans, it will be provision for fraud or one extraordinary item. Basically it shows lack of good internal controls and corporate governance. Was selling my UBA in annoyance because of such issues. STB is not better. Hakeem and Tony are just similar in stule and character. Don't trust them one bit. Even in the banking sector, Tony is considered a cow boy. Rules are secondary to him. targets first. Under such scenario, expect many infractions on good corporate governance.

That said, for long term positioning, UBA is good but can give you heart ache.

Had a friend that bought UBA at 14.00 based on the impressive quarterly report only to see it crash to 6.00 when the result was released. The money invested was his housing loan menat to build a house. You can inagine seeing your portfolio halved within a short period. That is a recipe for High blood pressure.

6-3-3-4   . That's funny!

But Wanaj0, are you sure you're not comparing the old UBA to the new and improved one? I don't know about character oh, but when it comes to style, I think Tony delivers the goods -- at least look where he's taken UBA to in less than 24months. He was here in the States sometime in 2006 to give a presentation and after listening to that presentation and doing some ground work, I went and bought UBA at N12. The man has foresight and a solid management style -- otherwise, how else could the merger of those two radically different cultures (Old UBA vs. STB) have been able to produce the results that have been produced to date? Check out the products those guys are rolling out today, the alliances they're forming and the deals they're getting involved in . . . I'm simply impressed. That's what Hakeem couldn't do with UBA. Of course I've since sold my UBA but am planning to re-enter. I know their style is aggressive (which I really like by the way) but I seriously doubt that rules are secondary to them. But like I said earlier, I'll do some sniffing and see what I find.

husu:
My question is how can 1.20k dividend in UBA revive that price to like #55. it looks impossible.

Wait o, who told you that N1.20 dividend in UBA will revive the price to like N55 Have you been talking to bigboylarry lately? _{confess now!}

Seriously though, it's not necessarily the dividend that'll move the price of UBA up, it's the growth prospects. Most people don't invest in stocks solely for the dividend yield (even banks will pay you more for your money). But UBA is currently looking cheap, based on its forward PE and those who believe in the company will buy it for the growth prospects, which should ultimately result in capital appreciation. Am I making sense?

Kai, I don miss out on some serious laughs here! Yodiyokun, see how dem guys just over rule you simply because you no get back ups  . Aktopgun, you mean say Aktopgun junior still never land? Ah, I pity im mama oh _{nothing is more tiring than an unborn baby overstaying his welcome in there . . .}

But come oh, all of una wey dey mention class of 91 and other classes of the 90s, are you sure you're not exaggerating? Hehehehe . Ah don sabi my level now. Respect O! 91 ke? those were days when I was still fighting with my good 'ol papa say I no wan go study medicine _{na by force?} . Akokites, unibenites, ifeites and all the other ites, make una shift comot for road jare. There's only one great uni and that is . . . _{ok never mind}

@Wanaj0, thanks for the UBA insight. I'll look into it again. But I must say I'm quite shocked, considering that they've been cleaning up their act and aggressively recruiting. The N4b you're refering to related to the old UBA and there's a new management at the helm now. But again let me dig further and see what comes up.

Temmie10:
Apart from the fact that Shigidi is a major pal,
sharing it wont affect my gains one bit, 

Must say i like your investment philosophy tho, very similar to mine
, you understand that one size doesnt fit all,
Sometimes some investments are not sane, but because u understand the risk and mechanics, u buy the stock, make a huge chunk most times and then find an undervalued  and sound cashcow to dump it on,

You definitely get my drift. I see regular fights between peeps who call themselves "fundamentalists" and those who call themselves "technical analysts" and wonder why they can't just see the value in both strategies and use to their advantage. The objective is to make money abi?

easimoni:
http://businessdayonline.com/Insurance/1416.html

Cornerstone confirmed they received most of the escrowed funds from CBN (N3.8B). Tidings of great returns from Ins Coys in 2008!

Do you know if they still have their sights set on doing a PO?

ololufemi:
@ Fatherof2,

Heres another disciple. It seems your disciples are increasing daily baba ke.

You may soon become FatherofMany.  

Hehehehe . kai ololufemi, this your sucking up na grade ONE . Seriously though, I like your people skills! But softly, softly my brother, so that you don't divide the house. We're all investors looking to take advantage of good opportunities, and several strategies work to that end. Leave the "disciple" thing out for now Please _{na God I take beg you Sir .}

Thanks a lot Pumping777, this is really good!

lawalidowu:
@windywendy

Please can you do an analysis on Fidelity? No one really says much about it here.
do u have any idea when they will return to the market?
also why has the price been marked down? someone said it is because of bonuses. where does one get information as to if a company will be giving bonuses or not? i know it gets rumoured around initialy.
PLS O! MAKE WIND NO CARRY MY MONEY GO

I don't know much about Fidelity, and my brother, in all honesty, I doubt that I'll have time to go through their prospectus. I know they just concluded a PO (or perhaps the PO is still on), and that's about all I know. Please anyone in the house who knows more should help this brother out. Thanks!

Seems like Proshare hasn't put out the dealers' perspective for a couple of days now. Anyone knows how that information can be obtained -- information that shows net bids and offers? Pls share. Thanks.

FatherOF2:
@Windywendy
  I don't personally make 25% every single week but many speculators do.Sometimes its three/four weeks,but i try to ensure i'm making money every
 month. Do you know if you start with N25m in January and set a conservative target of 25% every quarter(4 quarters total), you'll end up with N61m by year end 
  with compounding.Each year the cycle repeats itself you just need to know how to ride it from experience.

Hmmm, Fatherof2, for many weeks in the market the only stocks that make 25% are the small cap ones that are illiquid -- those ones that if you put just 100k units out, the price will crash. So unless the speculators are using just small amounts to trade, I find it hard to believe that anyone makes 25% every week on the floor. Your three/four week timeframe is more plausible, as I do that very often myself. And yes, you're right, 25% every quarter is very conservative at least for now.

@ALL:

Assuming a growth rate of 50% in profit after tax, and no additional issue of shares, UBA's forward PE is 17. The growth rate of 50% is very conservative in my opinion, because the current year profits do not fully reflect the benefits that will accrue from the new alliance with the Chinese bank and the other aggressive initiatives that the bank put in place towards the end of its last financial year. Also, the last year's profit took a hit of over N4b and this is not expected to occur going forward. I think a more realistic growth rate will be somewhere around 70%, giving a forward PE of about 15. For those of you interested in long term investing, this is one to get into. The stock is currently trading well below even its 100-day MA so you might not get it at this price again (my opinion). This is a solid Long Term play guys!

Temmie10:
For starters, any thing that ends with MA is a moving average.
IN Technical analysis, some chartists use specific numbers like 40 day moving averages, or 50 or 20 to determine the trend a stock is moving or to make an informed decision about when to buy or sell a stock.
Someone might say, i will buy when a stock goes above its 200 day moving average and sell when the 20 day average crosses the 50 day one downwards, a lot of it is subjective though.
its not absolute but you'll be surprised how many times they work, and because a lot of people use them, u can ride on them.
If i can find the right link, i'll provide it.

That's exactly what I'm talking about! You can ride on it to generate cash for "much saner" investments _{at least until the strategy stops working} .

[s]But Temmie10, why are leaking this secret for free?[/s]

shigidi:
@ windy wendy, please whats your take on diamond now? what effect do u think the gdrs will have.
plus what do u think of dangote sugar?

In all honesty, I'm still pondering that question in my head (wrt Diamond and the GDRs). Otherwise I really think Diamond is undervalued and is a GOOD medium to long term play. I haven't bought yet and won't until I figure out how the GDR will affect the valuation. However with the info Temmie10 provided about Actis amassing the GDRs, I'm beginning to think this deal might be SWEET afterall. Let's see how that plays out.

WRT Dangote Sugar, Seriously undervalued company. I have it in my portfolio as one of my longterm plays, and am just patiently waiting for the market to come to its senses on this one   . I'm watching the price closely and picking up units here and there as the price dips to unreasonable levels. Plus I hear that Dangote is reconsidering this nonsense quarterly dividend thing -- that should do something good for the stock price, knowing how the market can be . . .

hbrednic:
please anybody with inform on BOC GAS should share with a brother.


@yodiyokun
if you like i can forward you the fsdh reports for the last 3days.

From the last time I was following this company: They got acquired by Linde, a much larger global player, in 9/2006 (or thereabout) and embarked on a restructuring of the business. Seemed like a very good investment then (@N4) but my broker couldn't even get me 100k units -- very illiquid stock then, so I lost interest. Not sure if the price now is OK but there's a lot of info on the website (I mean the parent company's website) -- take time to look up the presentations and read up on the plans they have for their divisions. You can also listen in on the investors' presentation. It seems like Linde is planning to use the Nigerian division as a launching pad for West Africa (though they already have a Kenyan plant). They expanded production capacity of their CO2 plant. I like the new management, they seem focused and seem to have a generous dividend payout policy. That's about all I know for now.

yodiyokun:
I just downloaded it -- @Easimoni , you are the bomb, it was as if you were in my head.

@Windywendy - check the top right hand corner - input the code there and click download.

It will tell you to wait for a few seconds and you can click free download.

Takes about 1 minute for the whole process.

ok Thanks! I've downloaded it.

Easimoni: Thanks man, this spreadsheet is GOOOODDDD

@ Easimoni, I don't understand how to use this megaupload thingy. Do I have to sign up or is there a share password to use for logging in? Thanks in advance for responding