₦airaland Forum

easimoni:
Shig,
I think it may just be easeir to move to the APISTOCK software as some on this thread have reommended. Excel takes toooo long to learn and apply to the market + it is way too cumbersome to update.

Pumping/Man Jiro/Najiadr,
could someone repost (or start a new thread containing) all the resources to get up and running with APISTOCK; location for download, macros, etc.

Download AptiStock from here.

http://www.aptistock.com/

It is free.

Download the zip file from bigjay01 (Thanks a lot. This is great!), unzip and save on your local drive.

This has data from 1st August till 21st December 2007.

After installing Aptistock, go to "Tools", then "Datadownloader". Click on "Import", then "Browser".

Change file type to CSV and select the NSE.CSV file saved earlier.

Tick "other market" and fill in as an example "NSE" so all your stocks are listed in this folder/exchange. (In Aptistock you will find whatever you fill in here listed under files tab on the left hand side just as you will find NYSE etc. If you click on this, you get a list of your securities. After uploading new data, you can right click this node and "refresh".)

Click import and you should have all the data populated. If this is populated correctly go to the folder (depending on your installation folder), AptiStock\Data\NSE and you will find a CSV file created for each security.

Now using the formating excel sheet man jiro has blessed us with, collect the data for each trading day (one day at a time - You only have about 6 days to be up to date on 2nd January, 2008 from December 21st 2007) from Zenith securities and format in csv format as described by man jiro. Wicked. I have attached the latest formating sheet as well.

One thing that I found and several errors trying to import the file. You need to change the date format to YYYYMMDD on the CSV file if it is not in this format. The new formating sheet takes care of this though. It does not really have to be formatted. As an example, for today, just type in 20080102 in the first date field and copy this to all the fields below. You don't need any formatting here really. When you copy data from the formatting excel sheet, just accept the destination formating. When copying data from Zenith securities to the formating excel also, just accept the destination formatting.

Now import this new formatted file as you did the NSE.CSV file. Remember to tick the "NSE" flag again so that you don't create new folders. You just want to update the existing CSV files created earlier.  The best thing is that it will update each CSV file created earlier with the new information you have imported.

I hope I am clear enough. Took me a little while to get the hang of it. If anything is not clear, ask on the forum and I'll see if I have an idea.

shigidi:
looks like the market is buzzing right now.
@ easimoni,
HAPPY NEW YEAR.
abeg where can i learn how to plot charts with excel, i need it importantly for my RSI learning.its easier that way instead of always calculating over 14 days evry time,.
and also, whats the importance of OBV, investopedia doesnt say much.

Happy new year. You are welcome back.

I was very lazy about these charts but Man Jiro has delivered. Use his formating sheet with AptiStock and voila!!! You will also find the data from August to last week of December posted earlier. It will take less than 5 minutes to update the data for subsequent days.

Mr. Risky:
Hi Pumping,

I can see you online.  You are welcome from the brief holiday.

Just a brief question.  i can see that Ikeja Hotels looks undervalued at the present price.  What do you think?
Kind regards

So far, Ikeja Hotels does not maintain a premium PE like some other stocks. This may not happen until a consistent high growth rate is established.

With the information we know right now, I think the stock does not have so much more room short term to rise. Long term, the full year results may make things happen.

Man Jiro:
I just sent another sheet: delete the old one.

In Aptistock, NSE is not preloaded.

What you can do is to create your NSE and input the stock symbols you desire. This should be the same as the symbols in the Zenith file you intend to use as input: even an extra space makes a lot of difference

After doing so, go to program files -- aptistock -- data and create a folder for your stock market (NSE or whatever you like: just be consistent).

Go to the data downloader and locate the source data file and specify the destination folder by choosing the market: avoid suffix option

Import: If download happens, then you are good to go.

You dey try o.

I got round the few glitches in the first one and was happy enough with it. This one is making the whole process a piece of cake. This great.

Thanks for sharing.

Man Jiro:
Attached is an excel sheet with Macro to do the formationg for you. After the formating and saving, use Aptistock to upload the file.

Thanks for sharing this!!!

It saves so much work and works like magic with Aptistock.

crazyT:
Na wah o!!! Lasaco just close at 4.63 that is 5% gain, who ever hold down to him Lasaco don gain be that and I am very sure that my broker would have sold mine today.

You should avoid looking at things this way otherwise you fall into the habit of chasing spreadsheet profit that is quickly wiped out once profit takers engage. It is great to be able to sell when you want to.

There is no way of accurately predicting when a stock will peak and pull the trigger at the exact moment.

Prince11:
Which of the website is the first to publish daily stock price position, especially before Cashcraft. ?

and any idea as to when action will start for those of us who bought JAPAUL IPO?

Thanks

This one beats cashcraft most of the time.

http://www.trw-stockbrokers.com/services.aspx

FatherOF2:
Did you miss the 9 month result for ccnn.Surprising considering the sectors current performance.
Also i expect wapco to rub off on it by Feb.
But wait for the next cycle of descent on that stock before a MUST entrance.

I had to go check out CCNN again but I can't find anything good.

Technically, the company declared a loss in Q-3 2007. 189M PAT for Q-2 2007 and then 117M PAT in Q-3 2007.

The forward PE is now 186, the worst by far in the sector.

FatherOF2:
OK will take note and make changes accordingly.Dem be wan play fast one with that date change.I didn't know.

Maybe some more research is needed to confirm. FSDH reported the closure date to be 9th of January but Punch also reports 7th of January below.

http://www.punchng.com/Articl.aspx?theartic=Art200712302341634

I hope the closure date is not 7th to 9th of January and is being mis-inerpreted.

FatherOF2:
Pumping welcome back from your white christmas.
Na brown snow christmas i don dey ski since.
Meanwhile you need to double check that closure date for oceanic,i believe its 9th jan.

Thanks. I envy you. I would have done anything for Naija weather at this time. Even the Texas wey I run come still dey surprise me with some better cold winds.

This is what I got from Meristem. It could be a mistake.
----
UPDATE ON OCEANIC BANK PLC
The new closure date for the Bank's recently proposed dividend of N1:02k per share is now January 07, 2008
----

Still on Oceanic, we should note that it will be an anomaly to list the outstanding shares until after the current closure date since these do not qualify for dividends.

So I will expect the outstanding shares to be listed very very soon and profit takers from the PO will weaken the price.

Oceanic Bank

I'll be cautious about the plan to sell Oceanic on Thursday or Friday. Folks that buy on these dates will not qualify for the dividends since their names cannot appear on the register until after the closure date of 7th January. The latest day to buy and qualify for dividends is Wednesday, 2nd of January. Some folks will not know, but the big volume buyers will know and avoid the stock.

There may not be sufficient buyers on those days for the folks trying to sell to take profit. Nothing can be more painful for some than watching your profit disappear because you cannot sell.

Just a thought.

Wishing everyone a very happy new year.

As long as Nigerians continue to accept that public officials can perform acts which will have ordinary citizens locked up, these officials will continue to loot the nation's treasuries directly or through inflated contracts.

If you hide your identity to sign a government contract, there is everything wrong with it, whoever you may be.

You don't need to know anyone in Nepa to influence a power contract. Everyone falls under the presidency.

When Nigerians rose up against madam speaker, things happened. Good things can also happen in Nigeria if we stand up for what is right.

kingzy:
@All,
Where are all d analysts who promised us to wait till xmas that there will be some good buys. Please what and what are the good buys?

Based on closing prices on Monday and in order of preference, I consider these stocks undervalued.

1.BetaGlass
2.Lawunion
3.AGLeventis
4.Unic
5.UBA

Sorry I don't have the time to share my analysis on these stocks at the moment.

Disclosure:  I own each stock listed above.

Happy holidays and a happy new year in advance to everyone on this thread.

barge:
Most certainly. you identified the peculiar situation of this firm in one of your recent posts , coupled with the expected results.The only reason that may change is if they have to release results prematurely to prop -up the P.O  to oversubscription .I think that is an unlikely scenario . methinks this bull will run as fast as the spanish bull !

Aiico folks are not even advertising the PO as one would have expected. They'd rather keep it to themselves I think.  See how many days it is open for cosidering all the holidays.

More than a couple of folks have asked their brokers about the PO, and they say, they have no clue. Moreover the PO is only for N5.5B.

Aiico's 1st Quarter result was poor in my opinion. If they release a decent half year result now, It will only accelerate the bull run after the TS is lifted.

easimoni:
@ Pumping,
nice insight. Maybe it still works if linked to the timing of results. But it's not the sure-fire thing it was till a few months ago.

I suppose a few months ago there was the band wagon effect in a bulls market.

Imagine if all bank stocks have appreciated about 20% while one is locked down on TS. Once TS is lifted, I expect the price of the bank stock to try and play catch up.

This strategy will probably also work with Aiico.

easimoni:
Looks like all this post-TS bull-run is now B.S. (like my word-play huh?  ) FCMB had only 2(?) days of gains and now loses? It goes to show, if you have a stratgey that works, others will adopt and eat away at the margin till the strategy ceases to work.

I've believed for months that there is a major increase in the sophistication of the Nigerian investor. Typical strategies won't work anymore. Make we find the next thing, this one no go work again.

You have hit on a main point. If many others adopt your strategy, it will stop working  

On the other hand, I thought the recommendation was to position for post TS bull run if company results _{or even better bonus}are expected around the same time.

There is no rumour on FCMB. I don't know what will kick start this bull run. Access finally picked up after rumours of the company results started circulating.

Anyway, looking beyond the horizon, Zenith will be going out of TS about the same time that the half year result will be released. If the result is bam, _{as usual} then I will expect that this strategy will work again.

For those positioning for Bank PHB, the same should be considered. Is the next interim result for Bank PHB being expected in January? If not, the bull run may be delayed if TS is lifted in early January.

easimoni:
Law Union is inching down. For anyone who is interested in Inurance coys, pounce! I'm sure 4 will be a good support.

Take your time o

RoughCut:
I thought you said you were on holidays with your family

Take time o make i no report you to your missus u dey sneak behind her back to log on to nairaland

He be like say you dey here. Missus no find am funny again. I have decided to remain loyal and behave myself. Fiscal Year End declared. Make I take care of my biggest investment 

yodiyokun:
@Wanaj0,

Welcome back!!!.

We all missed your insightful contributions.

For those in Canada - I hope you guys were not snowed in yesterday oooo!!!!. Na wa for the storm.

@Pumping - you ran away from mother nature .

Pele. I hope you were not affected yourself. My friends have been complaining.

The winter came too early in Philly this year. There is no "Happy Holidays" in the snow for me

husu:
Hello,which registrers is in charge of AIICO public offer,cause i want to buy and my broker doesn't have the form.Where will i buy?,please respond.

You will find a list of receiving agents (banks and stockbrokers) in the prospectus.

The issuing house is Greenwich Trust Ltd.

wanaj0:
Well, my LEVELS don CHANGE. I've MOVED UP.

Congratulations

gbangban:
@ Pumping,

I've been a silent observer and quite appreciate your insights.

I'be in Philly the whole of next week. I can be reached at:  charliemike1ng at yahoo dot com.

Would love to share a cup of coffee with you.

Anytime, but too late this time. I left Philly for Corpus, Texas today. Vacation don start till 2nd week of January. The cold in Philly got the better of me so I came here with my family for a little sunshine and we have not been disappointed.

Make we holla via email sha.

tonyjon:
Pumping 777,

If you are to buy stock from the insurance sector now,which of them will you choose and why?.

Peace.

Ha, make I buy finish first The price is finally heading to my bid destination.

If I holla now, the big boyz and girlz here fit out-muscle my broker or even have the price heading north again

Anyway, most folks know my favourite insurance stock. Just that it has absorbed too much of a premium right now but it is now shedding some weight.

Mr. Risky:
Hi Pumping777 and the House,

Point blank, which sector do you think will do it, I mean give more than 75%, during the first and second quarters of 2008?  Can we discuss this please.  And Pumping777 remember millions here respect your opinion a lot.  Regards

If you are cosidering a whole sector, insurance stocks probably have the best chance of highest returns next year. This is because these companies are still small and have just started growing. However, I think we won't see 75% or 100% capital appreciation compared to today's prices until these companies start releasing their half year results. Good results.


As it was already noted, not every insurance stock will do so well, so carefully selecting at least 2 or 3 stocks will be the way to minimize the chance of missing out.

Personally, I am not focusing on any particular sector because I think I can find individual stocks in some other sectors that will outperform a bit of the insurance stocks. I am not so versatile with the sector dynamics.

iconbull:
@fatherof2
@kipneo
You ar quite right.though shares in issue for the insurance industry are quite high peered wt other industies.your broker can still queue up 4 AIICO, supply wl surface soon. you can now buy shares on TS at discounts rather than premium, infact i sold some FCMB @16.20 3 wks ago while it was 17 on the floor.crazy thins can happen in ds mkt, all u hav 2 do is search.well,well.

It is not insurance in general, it is Aiico in particular. The stock did not benefit from the insurance bull run.  When Aiico was N3.45, Lawunion was N3. Check out the price of Lawunion now. Just an example.

The stock is right now undervalued. Even if you add the shares from the current PO, the fundamentals are still good based on the forecast PAT for 2008. Projected PE under 18.  So if you are waiting for Aiico supply to surface during this TS, you will have a long wait.

Fundamentally or technically, there are positive signs and people know it. So buying at a premium is not a bad idea. 

Octupus:
2. I strongly believe that more often than not,stock bullish runs are based on sentiments and propaganda rather than company fundamentals and technicals.Therefore one needs to be very careful in transacting on such stocks.The danger is,if you don't enter and exit early with yor gains,it may all come crahing on you when the bullish run reverses.

This is true for a short term trader and sure many folks here including myself try short term trading. If you don't sell today, the spreadsheet money may be lost in a few days. So wether it is 10% or 15% net short term, you cash out and smile to the bank.

However, for someone looking at say 6 months or even well above, this is not really an issue. Even though stock prices go up and down on a daily basis many of them will be heading in a particular direction long term. This is where buying a fundamentally sound stock comes in.

Consider the trader that has done multiple short trades with Zenith Bank in the last 2 years and made a lot of money. Maybe he/she buys today and sells in a month or even a week once a particular net profit is realizable.

On the other hand, consider the investor that bought the same stock 2 years ago and is still holding it today. He/she will also make a lot of money if he/she decides to sell now. So, despite the up and down movement of the stock price short term over the 2 years, the long term trend has been for the stock price to rise to it's current price. A fluctuation in price will not now bring it back to the price 2 years ago except something fundamentally goes wrong with the company or the NSE.

This is where good fundamentals come to play. If you buy a stock with solid fundamentals, over the long term, you are likely to make good returns. The daily or weekly up and down movements are not an issue.

So, depending on if you are a trader or investor or even both, you have to choose your strategy.

N.B. This your name na wa o. I fear you for this thread already

easimoni:
I think you had not joined when Wanaj0 apprised us of this development. This now takes the no of shares to 753M (formely 572), I think. Some website, such as Naija Securities, had the larger number already. I don't think this is addition to that but a validation of what had been pending for month. I'm changing my sheet to 753M.

Thanks. For some reason I have the updated figure. Now I know how it added up.

moneypalav:
Hello ALL

DON'T FORGET TO RESPOND TO THE QUESTION SOMEONE ASKED EARLIER ,

i checked on Intenegins and could not find their name in all the site result sheet for the day what's up. do anybody know why they are not mentioned today?

I posted the information earlier.

Intenegins is on FULL suspension for reconstruction. I think this means no buying or sell until suspension is lifted.

"Oando and Ocean Oil Investment- 181,769,627 Ordinary Shares was created as a result of the scheme of arrangement between the two companies"

Can anyone explain how this may impact the outstanding shares of OandO?

kpineo:

daily position as promised.
AIICO is on full bid.
Father of 2.
how we go crack this one to enter

Thanks!!!

Aiico must remain on full bid till TS is lifted and the stock price races for N4.50

The Nigerian Stock Exchange today listed 5,200,000,000 Ordinary Shares of National Sports Lottery Plc, by way of introduction at N2.90. Also the following additional shares were listed today: 3,759,398,500 additional shares of Diamond Bank Plc by way of GDR; First Bank of Nigeria Plc hybrid offer of 7,666,470,465 Ordinary Shares and Oando and Ocean Oil Investment- 181,769,627 Ordinary Shares was created as a result of the scheme of arrangement between the two companies. In another development, the share price of First City Monument Bank Plc was listed from technical suspension. While the share price of International Energy Insurance was placed on full suspension following the receipt of their application for a share reconstruction while the share price of African Paints Nigeria Plc was placed on suspension following the receipt of their notification for placing their shares with Institutinal Investors. The share price of Nigerian Energy Fund Plc was also marked down for a dividend payment of N76 per note.