would enable you to enjoy an array of other services such as Member Rankings, User Groups, Own Posts & Profile, Exclusive Research, Live Chat Box etc.. 
Home
thanks my dear.
I want excel format as I want to convert it to Metastock. Is it possible?
Thanks.
I want excel format as I want to convert it to Metastock. Is it possible?
Thanks.
twimalasuriya wrote:ha_na wrote:I need 9 February 2011 and 9 may 2011 EOD data for all companies. I have error on those two days. Can someone help me?
Thanks
I just copied two files you wanted to the location below
(Symbol Date (YYMMDD) Open High Low Close Vol )
http://wimalasuriya.com/cse/eod/20110209.txt
http://wimalasuriya.com/cse/eod/20110509.txt
These are from a local database I update each day from data taken from cse.lk
I run a sql like below to get the file
- Code:
SELECT share,DATE_FORMAT(date,'%Y%m%d') , open,high,low,close,sharevolume
INTO OUTFILE '/tmp/20110509.txt'
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
from ohlc where date = '2011-5-9' ;
