X-2-X:

Compliments of the season to all.

I am searching for a reliable source of daily price updates in Excel format.

Can anyone recommend and provider (I tried registering on FSDH, nothing received so far after > 3weeks, Meristem is sending out unuseable excel workbooks {hard, nay, impossible to cut and past stuff easily from theirs} and Zenith has not updated their website since 18th).

I need a source that has Opening, Closing, High, Low as well as Volumes information in MS Excel formated documents.

Thanks.

Merci beacoup et bien à vous!!

bigjay01:

I download from Zenith securities, run a macro in textpad that tab delimits the field (by changing all spaces to tabs) then copied and pasted in excel. Unforttunately I only have from August this year till 21st of Dec. Its pretty str8 fwd to do. Is this any good 2 u? or do u want it further back?

kpineo:

Todays position attached.

E be like say i need to go and pay Cecilia a vist at home oh, abi wey my Oceanic Certificate now. 100% profit and i can't verify talkless of selling. E gbami oh!!!

yodiyokun:

Compliments of the Season to all

Anyone knows whether Access Banks has released their 2nd Qtr results?

bosunabuja:

I bought public offer from intercontinental since last year and I have not received my certifcate up till now. Please what should I do?

X-2-X:



Bigjay. Thanks for your response.

I am not in need of historic data. Rather I am in need of future data from today onwards .

Zenith's site hasnt been updated since the 18th. It used to be my primary source.

So now I am looking for an alternative. I fancy a service (from a stockbroker, website
etc) that can send Excel formated documents to me via email. That way, I wouldnt
have to  bother going through the extraction process daily as I can always download
the excel worksheets from my email box when I am free (say weekends). You dig?


Cant seem to get anything from my FSDH susbcription. Information regarding any
alternate source will be appreciated

yodiyokun:

@Easimoni and @Grabdaloot.

I tried computing RSI for First Bank - just to see if I understand whats up

I have attached the spreadsheet for your review - please confirm if I am on the right track or I have done jargon?

easimoni:


Bottom line: due to YE timing, UBA is suddenly looking like the best bank. A great short-term play till the 1Q result is released.

grabdaloot:

Yeah you have it on the mark but remember the key thing about RSI is the time frame from start of evaluation. For instance it there is a transition from a bearish market to a bullish one or vice versa, the early RSI computation might be quite misleading might give you an overbought whereas it is highly oversold that is if a bull market is setting in. As a guard to that always try to vary the time frame for the averaging. I use 5 days 10 days 15 days and 20 - 20 days to get a better picture. Generally they all give the same results over time but varying the duration of the evaluation can give early signs of when the tempo of the market is about to swing . If you can set up your sheet so that you can use different durations on different stocks then you would have confirmation on the change in market tempo.

yodiyokun:

@Easimoni and @Grabdaloot.

I tried computing RSI for First Bank - just to see if I understand whats up

I have attached the spreadsheet for your review - please confirm if I am on the right track or I have done jargon?

easimoni:

Yodi, you calculated it right but I have included a second sheet that does it in four columns instead of 8.

Ciaman:

@Easimoni and @Grabdaloot

Please whats RSI and What does it implies in a stock?/ Thank you

yodiyokun:

Thanks,

But How on earth do I use the information, is there any basis for comparison. How do I determine when to buy or sell and when is it applicable.

For example using it on A.G leventis - the RSI has risen over the last few months to about 70- I used the 14 days pattern.

Based on this, Entering this stock at the current price may not be a good idea-- but what if the stock price doesnt come down and keeps going up? what then?

Or are there times when the RSI is not applicable - I want to be balanced in my analysis.

Talk to me oo.

I beg make your email visible - make I email you with some more questions

Thanks.

grabdaloot:

[
Yodi,
How you apply the RSI is purely up to you but I will try to explain the general principle of the application. It can be used by all kinds of investors, dividend hunters, capital gain pursuants, long term investors etc. The thing is that when you have decided on stock you want to invest in, the RSI will aid you in getting in at the best time/price. It can also serve as an aid for when to exit (short sellers love the RSI to death). Various people have various bars but typically 70 seems to be the sell indicator and 30 the buy one. As for AGLEVENT, I just looked again and the RSI to me seem to be in the 54 - 56 range. Still a good entry point for the stock if you ask me considering the relatively lean volumes. I used the 5 - 25 day range to look at it (increment of 5 days), so decide on a stock evaluate the RSI and know when to jump on the boat. Those of you that like 'cyclic' stocks this is a must use! With higher highs and higer lows immenient the swingers/surfers should get ready to ride the wave

grabdaloot:

[
It can also serve as an aid for when to exit [b](short sellers love the RSI to death).[/b]Those of you that like 'cyclic' stocks this is a must use! With higher highs and higer lows immenient the swingers/surfers should get ready to ride the wave

FatherOF2:

AND THEY SHALL LEARN TO MAKE MONEY EVERY MONTH _{as said earlier}