how to read Bhavcopy in metastock

Discuss how to read Bhavcopy in metastock at the MetaStock within the Traderji.com - Discussion forum for Stocks Commodities & Forex; I would like to know is there a way to convert Bhavcopy of nse from ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > TOOLS & RESOURCES > Software > MetaStock
Register Blogs FAQ Chat Room Search Today's Posts Mark Forums Read


Welcome to the Traderji.com - Discussion forum for Stocks Commodities & Forex.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features.

By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features.

Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please read the FAQ.

Reply
 
Thread Tools
Sponsored Links
  #1  
Old 29th April 2005, 08:24 PM
Member
 
Join Date: Feb 2005
Posts: 29
sara is on a distinguished road
Default how to read Bhavcopy in metastock



I would like to know is there a way to convert Bhavcopy of nse from csv / dbf format to metastock readable format.

Reply With Quote
  #2  
Old 2nd May 2005, 08:21 PM
Member
 
Join Date: Aug 2004
Posts: 120
Debraj is on a distinguished road
Default Re: how to read Bhavcopy in metastock

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

Reply With Quote
  #3  
Old 2nd May 2005, 11:00 PM
Member
 
Join Date: Apr 2005
Location: I live in Nasik.
Posts: 11
Samarth is on a distinguished road
Default Re: how to read Bhavcopy in metastock

Thnx a lotttttt ..... samarth

Reply With Quote
  #4  
Old 5th May 2005, 10:00 PM
Member
 
Join Date: Feb 2005
Posts: 29
sara is on a distinguished road
Default Re: how to read Bhavcopy in metastock

Quote:
Originally Posted by Debraj
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,

Reply With Quote
  #5  
Old 5th May 2005, 10:35 PM
Member
 
Join Date: Feb 2005
Posts: 15
osp2osp is on a distinguished road
Default Re: how to read Bhavcopy in metastock

Sara

Try this:
Mansoor utilities

Reply With Quote
Sponsored Links


Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads for: how to read Bhavcopy in metastock
Thread Thread Starter Forum Replies Last Post
How to get realtime data and convert it to metastock format alexonias Data Feeds 21 15th April 2008 11:48 AM
Metastock Expert advisor as a learning aid. sh50 MetaStock 10 12th May 2007 08:44 AM
Is metastock really the best? sh50 MetaStock 15 18th February 2006 08:22 PM
Metastock Data us_junk MetaStock 1 9th February 2005 08:13 AM
Making the most of Metastock sh50 MetaStock 0 9th February 2005 08:07 AM



All times are GMT +5.5. The time now is 02:24 AM.

Indemnity, Disclaimer & Disclosure Notice:
• By visiting Traderji.com you indicate your acceptance of our Forum Rules Disclaimer & Disclosure and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of this information.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
• All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy of information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. If you find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © 2001 - 2008, Traderji.com All Rights Reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.HiFiVision.com - www.MasterOfTrading.com - www.NotebookTalk.com