Technical Analysis Using Aptistock

A Member? Please Login  
type your username and password to login
Date: July 26, 2008, 12:42 PM
223787 members and 127096 Topics
Latest Member: avwe
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  General Discussion  |  Business  |  Stocks & Investment (Moderator: FOD)  |  Technical Analysis Using Aptistock
Pages: (1) (2) (3) (4) Go Down Send this topic Notify of replies
Author Topic: Technical Analysis Using Aptistock  (Read 4252 views)
easimoni (m)
Technical Analysis Using Aptistock
« on: January 05, 2008, 08:19 PM »

We have seen an increased interest in technical analysis in the last few months. Excel spreadsheets have been too difficult to develop or too cumbersome to maintain. And they certainly aren't as aesthetically pleasing as some professional packages.

I know of one website and one software developer working on tech analysis software tailored to the NSE, but in the meantime, you can work with AptiStock (kudos to naijadr for the hook-up). It's free software you can download here:

http://www.aptistock.com/

Once you download and install (and yes it worked on my vista machine), go to "Setting" and select "Add/Remove Stock Market". Deselect all the listed markets (unless you wish to use the software to monitor any of the listed markets).

In your windows explorer go to

C:\Program Files\AptiStock\Data

Delete all the data files/folders in there (it will only confuse and clutter your software)

You are now ready to upload data from the NSE and become a tech analyst.
easimoni (m)
Finding the Data You Need
« #1 on: January 05, 2008, 08:20 PM »

SavvyLanre/Big Jay were kind enough to provide us with open, high, low, close and volume data for all stocks dating back to April 2007. Please let us know if you have data dating back even further. Note this file is only valid till Jan 02, 2008. I will post updated files once a week starting next week.
Download the file here

http://www.megaupload.com/?d=A8P3GNBA

If you wish to update the file by yourself, use an excel macro that Man Jiro wrote. You can find it here and it contains instructions for use.

http://www.nairaland.com/nigeria/topic-31554.8896.html#msg1814156
easimoni (m)
Loading the Data in AptiStock
« #2 on: January 05, 2008, 08:21 PM »

Now that you have the NSE OLHC/Volume data (named NNSE to avoid confusion with AptiStock's Indian NSE), go through the following steps to import the file.

"Tools"
"Data Downloader"
Under Data Destination, check "Other Market" and input the market name NNSE

Select "Import" at the bottom of the window and the "Import Data from EOD Data File" will come up.
Under "File Select", click on "Browser"
Change file type to "Comma Separated File (*.csv)"
Find the place you saved the NNSE file (which you must have unzipped) and select it.
Click "open"
Back on the "Import Data from EOD Data File" window, click "Import"


AptiStock will spend some time loading the data and creating a CSV file for every stock. Repeat the import process when you get new data and it will append new data to existing stocks. It will also create new symbols for new stocks

Congrats! Your data is now loaded.
easimoni (m)
Navigating Thru Aptistock
« #3 on: January 05, 2008, 08:21 PM »

To use AptiStock

ON the left panel, select "Files", double-click on NNSE and select any stock. Some charts will come up. To change the type of chart, select the triangle next to VOL and a list of available curves will pop up. Select one and choose "replace".

If, for example, you'd rather see 14 day RSI instead of 11, go to "Tools"/"Indicator Parameter Settings". Under Main Chart Indicator or Sub Chart Indicator, you can tune any indicator to your preference. A brief tutorial on each indicator is even displayed!
easimoni (m)
New to Tech Analysis?
« #4 on: January 05, 2008, 08:29 PM »

If you are new to tech analysis, please download and read the following investopedia article.

http://www.investopedia.com/university/indicator_oscillator/

If you have not read something on Tech analysis, you will not be able to interpret the charts

Please do not post kudos/gbosas or topics of other interests here. I intended for this thread to be a resource for getting people up and running ONLY. I'd like to keep it short so things are easy to find. If you have any questions about a particular stock (even if it is a technical question), please go to the most popular thread on nairaland and you'll get an answer. Please don't discuss buy/sell issues.

If you have problems installing, loading data, or navigating/tweaking the software, feel free to post here so we can address and improve

oawele
Re: Technical Analysis Using Aptistock
« #5 on: January 05, 2008, 10:38 PM »

@easimoni,
thanks for this thread. i was actually thinking of something like this thread before i started Learn How To Analysis Nigerian Stocks thread before i saw this.

i personally must confess that when i went through nigeria stock market tip thread, things were just jamming .
and the thread long oh!

any way i started a thread Learn How To Analysis Nigerian Stocks where we could just pick some good stocks and bad stock so to say and analysis them together. we must mustn`t buy the stocks but learn with it.

what do you think??!??
Gudchoice
Re: Technical Analysis Using Aptistock
« #6 on: January 06, 2008, 12:37 AM »

Easibaba - you are da bomb. okurin meta be ko. You are a real treasure, really.

I recently deleted Aptistock from my pc. I just couldn't get it to work. I turned to Metastock, but that required verification. Now with your wonderful tutorial I can boldly venture back into Aptistock.

Thanks ever so much.
Etin (f)
Re: Technical Analysis Using Aptistock
« #7 on: January 06, 2008, 04:06 AM »

Thanks Easimoni
Dis Guy
Re: Technical Analysis Using Aptistock
« #8 on: January 06, 2008, 04:50 AM »

Thanks Easimoni

Can you please explain how to set the overbought and oversold lines using RSI
 
http://www.investopedia.com/university/indicator_oscillator/ind_osc7.asp

cheers
stanchuks (m)
Re: Technical Analysis Using Aptistock
« #9 on: January 06, 2008, 06:32 AM »

@Easimoni
My Oga thanks for this trend, i am finding it difficult uploading into Aptistock or is it not Vista compliance, if so is there a solution for this?
Nice weekend
pumping777 (m)
Re: Technical Analysis Using Aptistock
« #10 on: January 08, 2008, 08:32 PM »

@easimoni - Thanks for all the effort here o. You dey too try!!!
bigjay01 (m)
Re: Technical Analysis Using Aptistock
« #11 on: January 08, 2008, 11:11 PM »

Quote from: stanchuks on January 06, 2008, 06:32 AM
@Easimoni
My Oga thanks for this trend, i am finding it difficult uploading into Aptistock or is it not Vista compliance, if so is there a solution for this?
Nice weekend

the vibes i got from other thread is that aptistock is not Vista compliant. I stand corrected Huh Huh Huh. also note that the help section provides a very good guide as to the interpretation of all the indicators.

Also note that TA Pro & Deluxe have just been released on www.nigeriansecurities.com. they have data going back 2 years

I would be be wary of using TA in isolation without looking at the fundamental analysis & future prospects of the stock. Most of these software were developed with developed / perfect market in mind. From what is happening on some stock on NSE at the moment, you wouldnt touch some stock with a barge pole (from their TA data), but these are the stocks doing very well (albeit 4 now)
spicie
Re: Technical Analysis Using Aptistock
« #12 on: January 09, 2008, 05:21 PM »

Yello,
        Can someone kindly help me with the data file, because i can't download it from megaupload, the site is blocked in my country. Tanx
easimoni (m)
Re: Technical Analysis Using Aptistock
« #13 on: January 09, 2008, 05:53 PM »

Quote from: spicie on January 09, 2008, 05:21 PM
Yello,
 Can someone kindly help me with the data file, because i can't download it from megaupload, the site is blocked in my country. Tanx

Spell out your email addy and I email the file to you after I update it on Friday.
Quote from: stanchuks on January 06, 2008, 06:32 AM
@Easimoni
My Oga thanks for this trend, i am finding it difficult uploading into Aptistock or is it not Vista compliance, if so is there a solution for this?
Nice weekend
It works fine on my vista machine. The loading data session never seems to end but if you abort it, it seems to have loaded the data just fine. The charts will work okay.

Quote from: Dis Guy on January 06, 2008, 04:50 AM
Can you please explain how to set the overbought and oversold lines using RSI
http://www.investopedia.com/university/indicator_oscillator/ind_osc7.asp
cheers

I don't know that you can "set" the lines in AptiStock. I simply do some visual inspection and llok for 70/30 or 80/20
tommy t (m)
Re: Technical Analysis Using Aptistock
« #14 on: January 12, 2008, 03:51 PM »

Thanks alot bro,
is good to have people like u in niraland, thanks for taking at of your preciuos time to add to peoples life.
enything i clink on my stock downloader  now is giving me error report, i will hold on a bit and re try it latter in the day if the problem and if there is no progres may be i will uninstall it and re install, or do you have any solution to it?
thanks and God bless
easimoni (m)
Re: Technical Analysis Using Aptistock
« #15 on: January 14, 2008, 11:29 PM »

http://www.megaupload.com/?d=CCPROODQ

OHLC & Volume Data current as of today! Still looking for someone with data that pre-dates April 2007.
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #16 on: January 15, 2008, 11:58 PM »

Quote from: easimoni on January 14, 2008, 11:29 PM
http://www.megaupload.com/?d=CCPROODQ

OHLC & Volume Data current as of today! Still looking for someone with data that pre-dates April 2007.

@ easimoni

I just discovered this thread.

I have data that goes to Dec 2006 but its too big to upload here. Not too sure of the process for uploading into megaupload but will check it out.

I also found out that the help files in Metastock  and aptistock are quite elaborate on explaining the indicators. Will upload some pdf i got too.
easimoni (m)
Re: Technical Analysis Using Aptistock
« #17 on: January 16, 2008, 12:23 AM »

@ Man_Jiro,
Megaupload should be easy to use. If you have issues, let me know. Maybe you can email it to me and I'll "megaupload" it.

Should be useful stuff.
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #18 on: January 16, 2008, 03:38 PM »

Quote from: easimoni on January 16, 2008, 12:23 AM
@ Man_Jiro,
Megaupload should be easy to use. If you have issues, let me know. Maybe you can email it to me and I'll "megaupload" it.

Should be useful stuff.

Okay. Will send the stuff to you today.
Whats you email? Mine is man4jiro@yahoo.co.uk
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #19 on: January 17, 2008, 09:57 PM »

Quote from: easimoni on January 16, 2008, 12:23 AM
@ Man_Jiro,
Megaupload should be easy to use. If you have issues, let me know. Maybe you can email it to me and I'll "megaupload" it.

Should be useful stuff.

@easimoni,

Waiting for you to send me an e-mail I can send it to: it might be wise to have all the materials in the space you have created.
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #20 on: January 18, 2008, 01:33 AM »

Gents,

I have uploaded some files for your benefit

PDF about market Indicators (basically investopedia)
http://www.megaupload.com/?d=KFDS8V0U


NSE data from Dec 2006 to April 2007
http://www.megaupload.com/?d=GONEBC13

Interpreting Market Indicators (Metastock)
http://www.megaupload.com/?d=5P9T30IC

I guess somebody could consolidate these files into a library for nairalanders
dollarmani
Re: Technical Analysis Using Aptistock
« #21 on: January 18, 2008, 03:11 AM »

the volume indicators show that there has been a strategic mopup of unitybank for the last 40days
dollarmani
Re: Technical Analysis Using Aptistock
« #22 on: January 18, 2008, 03:13 AM »

Hi guys,

Check out the the technical analysis tool on nigeriansecurities. They have data as far back as 2007 and you don't have to worry about updating daily data for aptistock if you have gotten aptistock to work.

Unfortunately i have not been able to get aptistock to work making this timely.

I can at least now focus on using the indicators instead of trying to make them work
shigidi (m)
Re: Technical Analysis Using Aptistock
« #23 on: January 18, 2008, 10:08 AM »

easimoni, ure a real gem
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #24 on: January 18, 2008, 01:02 PM »

Quote from: dollarmani on January 18, 2008, 03:13 AM
Hi guys,

Check out the the technical analysis tool on nigeriansecurities. They have data as far back as 2007 and you don't have to worry about updating daily data for aptistock if you have gotten aptistock to work.

Unfortunately i have not been able to get aptistock to work making this timely.

I can at least now focus on using the indicators instead of trying to make them work

Thanks: will check it out.

I think it would still be wise to use the aptistock/metastock as backup though. You never know when these guy might change their mind about free usage.
easimoni (m)
Re: Technical Analysis Using Aptistock
« #25 on: January 18, 2008, 03:46 PM »

Quote from: Man Jiro on January 18, 2008, 01:02 PM
Thanks: will check it out.

I think it would still be wise to use the aptistock/metastock as backup though. You never know when these guy might change their mind about free usage.

Man Jiro,
thanks for the work and the links.  Smiley Also agree per your comments; it's only a matter of time before they ask for money for the non-basic versions.
easimoni (m)
Re: Technical Analysis Using Aptistock
« #26 on: January 22, 2008, 05:19 PM »

http://www.megaupload.com/?d=HQLCZ5H0


NSE OHLC data from Dec 2006 to Jan 22, 2008
SOJ (m)
Re: Technical Analysis Using Aptistock
« #27 on: January 24, 2008, 12:58 PM »

@easimoni
thanks for your tips here man.i downloaded the software ad followed your instructions but couldnt get it to work.i deleted the data files in program files and uploaded our NNSE data into the data folder.Still it failed to list NNSE under "files" in the lefthand tab.Can you help me out here?
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #28 on: January 25, 2008, 05:45 PM »

Quote from: SOJ on January 24, 2008, 12:58 PM
@easimoni
thanks for your tips here man.i downloaded the software ad followed your instructions but couldnt get it to work.i deleted the data files in program files and uploaded our NNSE data into the data folder.Still it failed to list NNSE under "files" in the lefthand tab.Can you help me out here?

@ SOJ

Did you also import the list of NSE symbols? If not, you need to.

easimoni (m)
Re: Technical Analysis Using Aptistock
« #29 on: January 25, 2008, 06:22 PM »

Quote from: SOJ on January 24, 2008, 12:58 PM
@easimoni
thanks for your tips here man.i downloaded the software ad followed your instructions but couldnt get it to work.i deleted the data files in program files and uploaded our NNSE data into the data folder.Still it failed to list NNSE under "files" in the lefthand tab.Can you help me out here?

Did you go through the import process? You can't just copy the NNSE.csv file, you have to import it use the Aptistock data downloader. Message #3 on this thread describes how to import the CSV file into Aptistock. Have u done that? If you have respond and I'll think of something else
easimoni (m)
Re: Technical Analysis Using Aptistock
« #30 on: February 01, 2008, 10:58 PM »

OLHC Data updated till Feb 1, 2008

Only contains 2008 data

NNSE Jan 02, 2008 to Date.csv
* NNSE Jan 02, 2008 to Date.csv (152.71 KB - downloaded )
Man Jiro (m)
Re: Technical Analysis Using Aptistock
« #31 on: February 03, 2008, 03:44 PM »

Quote from: easimoni on February 01, 2008, 10:58 PM
OLHC Data updated till Feb 1, 2008

Only contains 2008 data

Thanks man
 Best NSE Stocks For Short Term Investment?  Zenith Bank Shares Offer: Opportunity Or Hype?  Made More Than A Million Naira From First Bank Shares!  Page 2
Pages: (1) (2) (3) (4) Go Up Send Topic to Friend by E-mail Reply 
Google
 
Web www.nairaland.com
Sections: TV/Movies (2) Music/Radio (2) Celebrities Jobs (2) Career Romance Books Politics Sports Fashion Travel
Health Schooling Religion General(2) Business Webmaster Programming Computers Phones Cars & Trucks

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.