how to read Bhavcopy in metastock

#2
Sara,

Perhaps you have already found out how to do this, but here it is anyway.

1) Download file in csv format.

2) Double click to open with Excel.

3) Right click on the K (Timestamp) column to select the whole column and choose "cut".

4) Right click on A (Symbol) column and click " Insert cut cells".

5) Again right click on the column header to highlight the whole column and click "format cells".

6) Number -> Date -> Type. Choose mm-dd-yy. Ok.

7) Delete columns C ("Series"), H ("Last"), I ("Prevclose") and K ("Tottrdval").

8) Now is the important part. In the first row change :

TIMESTAMP to <Date>

SYMBOL to <Ticker>

OPEN to <open>

HIGH to <High>

LOW to <Low>

CLOSE to <Close>

TOTTRDQTY to <Volume>.

9) Save the file.

10) Use the Downloader to convert the data to metastock format. Source file type should be ASCII text and while browsing in "Files of Type" choose "All Files".

Good luck.

Debraj
 
#4
Debraj said:
Sara,

Perhaps you have already found out how to do this, but here it is anyway.

1) Download file in csv format.

2) Double click to open with Excel.

3) Right click on the K (Timestamp) column to select the whole column and choose "cut".

4) Right click on A (Symbol) column and click " Insert cut cells".

5) Again right click on the column header to highlight the whole column and click "format cells".

6) Number -> Date -> Type. Choose mm-dd-yy. Ok.

7) Delete columns C ("Series"), H ("Last"), I ("Prevclose") and K ("Tottrdval").

8) Now is the important part. In the first row change :

TIMESTAMP to <Date>

SYMBOL to <Ticker>

OPEN to <open>

HIGH to <High>

LOW to <Low>

CLOSE to <Close>

TOTTRDQTY to <Volume>.

9) Save the file.

10) Use the Downloader to convert the data to metastock format. Source file type should be ASCII text and while browsing in "Files of Type" choose "All Files".

Good luck.

Debraj
Thank you very much Bebraj, I will try that and come back to you,
 

Similar threads