Please find the Updated Data from 2009 to 5th Oct 2011
You can use this to do technical analysis in metatock,
Unzip the folder and Open it using Metastock, for Metastock installation please refer posts below
http://www.mediafire.com/?utcza34oq3e2ac9
Last updated 5th OCT 2011
Sammy's Blog
When Technology Addiction Takes Over Your Life!
Friday, August 12, 2011
Tuesday, June 14, 2011
How to Update MetaStock Data Manualy
to start with download the latest file which i have prepared (or you can create your own using DFN pro)
our approach will be, use my file as a base and you will continue to update it daily
you can find the base file (already prepared metastock file)
at the time of writing this post, i have updated the data from 2009 - June 13, 2011
you can grab it from
http://www.mediafire.com/?l3m3r8jg225ajjt
also i might post it on this blog when ever i update it, but strongly i suggest. get the latest file and get your own mechanism to update (refer below) so you dont have to depend on anyone
Download the data, Unzip it, Open it in Metastock, if it works proceed with steps below
How to Update it with Daily Prices
Step1.
You can find the daily prices from the CSE site, in CSV format
The file will be on the following format
Company Name, Symbol, Share Volume, Trade Volume, Previous Close (Rs.), Open (Rs.) High (Rs.), Low (Rs.), ** Last Traded Price (Rs.) ,Change (Rs.) ,Change (%)
We only need Symbol, Trade Volume, Open, High, Low, Close (last traded) - High lighted in red
Step2
Prepare an Excel sheet (in CSV format) with the following order and with the following headers
All you can do is have a excel sheet (Saved as CSV) with the above headers and copy paste the daily data in to it,
Remember
Save the file somewhere and Open the Downloader (which will be automatically installed with Metastock)
On the downloader Tools - > Convert
Click ok, bingo, you got the data
All you have to do is daily , or when ever you find time, update the CSV file with CSE data and follow the above stops on downloader (it will remember the paths) and Click OK
This is how i update it simply
There can be ppl who try with complicated macros / sql scripts but my Principe is you don't need bombs/guns to kill a fly
How to Install MetaStock
Due to popular demand i thought ill write this on a blog. i will keep it short and simple, just to give instructions & directions only
Step1 - Finding the Software
Find and Install Equis MetaStock.Pro.EOD.v11.0
(Just google Equis.MetaStock.Pro.EOD.v11.0.Cracked you will find torrents / rapid share hosted locations)
Step2 - Installation & Cracking
Install the software (You can just do a default installation click next for everything) & crack it by placing the MsWin.exe in to the installation directory from the crack folder.
This will install Metastock and a Program called Optionscope
Step 3 - Verify
Open Metastock and check all works without any nagging error messages
If you get any error messages let me know or just simply re install and restart lol :)
Step4 - Data Data Data
Now the million doller question arises where do i get the colombo stock exchange data
i really dont know whether its 60USD or 600 USD to get the realtime feed, but there is always a cheap / free workaround (for anything) so lets go for the option II
4.1 Either You can download the data from DirectFN Pro and update it from Scratch,
4.2 Or you can use my files which i have already prepared up to date and use it, (and continue to update daily,
Download the Data from the site (Refer to the latest update on this same blog and grab it)
Unzip the folder,
Open it using Metastock
There you go..
How to update it daily will follow in the next post
Subscribe to:
Posts (Atom)