My MetaStock COmpatable Excel EOD Convertor

joy_mitali · #1 26th March 2006, 10:59 AM

Respected Tradeji and all other seniors,knowledgables and other juniors of this forum,
This is a small utility ---which I made ---in request from Karthick---a very senior and honourable member of this forum---from whom I m obliged in learning many a new things---
This utility basically converts the EOD NSE bhavcopy ---(in .csv formal) to Metstk compatable excel format in a new folder withen the directory ---where the EOD files r generally stored by the respective users--
After the required conversion---The MetaStock downloader can take care of the remaining part---
I will be previledged if knowledgable forum members give necessary Comments regarding the improvement of the utility ---
Regards,
joy_mitali

pkjha30 · #2 27th March 2006, 01:12 PM

Hi Joy

I downloaded the xls file and used it on the file downloaded by me through my downloader and it worked quickly without delay.That is the power of Excel. I think my software has to compete with the speed of your's otherwise it will be thrown out of the forum by the members. I will also work on the speed.

You have made some other software given in the forum like pivot point calculator. If you integrate all these it will make a great combination of excel utilities at one point.
Regards
Pankaj

joy_mitali · #3 27th March 2006, 04:36 PM

Hello Pankaj,
Thanks --for ur review---By the way---ur utility can be termed as a software---while mines remains in a stage of utility---I m working in a diff --excel utility now---and have succeeded in the isolation of company data---along with technical indicators---
I would like to know---what more staff can be included in this utility of mines---
Also---if u have made any development ---in plotting charts---do let me know--Plz--
Wishing u --from the core of my heart---a true success---both in terms of speed--and stability----of ur software---
Regards,
joy_mitali

pkjha30 · #4 27th March 2006, 09:05 PM

Quote:

Originally Posted by joy_mitali

Hello Pankaj,
Thanks --for ur review---By the way---ur utility can be termed as a software---while mines remains in a stage of utility---I m working in a diff --excel utility now---and have succeeded in the isolation of company data---along with technical indicators---
I would like to know---what more staff can be included in this utility of mines---
Also---if u have made any development ---in plotting charts---do let me know--Plz--
Wishing u --from the core of my heart---a true success---both in terms of speed--and stability----of ur software---
Regards,
joy_mitali

Hi Joy
Thanks a lot for appreciation wishing me well in developping software. I would say it is traderji.com's software and not mine.Have a look and tell me how to do some things.

Excel is not very different if you are doing it in vba as I could see in some of your earlier utility.I will suggest common control screen from where you can launch in to specific utility and then come back to it.
You could add a thought of the day startup. I love your quotations.
I think you can do charting in excel though not tried myself.
You can filter companies on the basis of certain parameters such as PL,cash reserv,book value,PE, sales growth , turnover growth and combine it with technical price action and determine if it is a good candidate for investment on long term basis by taking into account sectoral outlays planned by the planning commission as that is a good document which will indicate the future policies.

just a thought.
After all things are interrelated and sentiments and price actions are also linked to the directional thrust given by the Govt and Industries as a whole.

Regards
Pankaj

rongreu · #5 6th June 2006, 11:55 AM

Please Upload File again. thanks U. duy_rongreu@yahoo.com

NSE-CASINO · #6 18th July 2006, 08:51 PM

Hello Joy-Mitali i did every thing you mentioned for converting the bhav copy from NSE to excel format for metastock. but i am getting stuck in 1 place and want your assistance in that.......i cannot convert the excel page to metastock format in my metastock downloader and shows the error message as "could not open the file" i.e the one created by your convertor. I know i am doing some thing wrong some where but not able to track my error....can you help me?

also I will be glad if you narrate step by step point wise......I have really liked your bhav copy convertor and thank you for creating it.

hasobha · #7 18th July 2006, 11:01 PM

Hello Joy_Mitali

Excellent convertor. Great Work.

But How to update NSE indices ? As they are not included in bhavcopy.

Please also try to develop same type of utility for FO & BSE.

Good luck and congrats.

Hasobha

purvija99 · #8 22nd July 2006, 11:31 AM

Quote:

Originally Posted by joy_mitali

Respected Tradeji and all other seniors,knowledgables and other juniors of this forum,
This is a small utility ---which I made ---in request from Karthick---a very senior and honourable member of this forum---from whom I m obliged in learning many a new things---
This utility basically converts the EOD NSE bhavcopy ---(in .csv formal) to Metstk compatable excel format in a new folder withen the directory ---where the EOD files r generally stored by the respective users--
After the required conversion---The MetaStock downloader can take care of the remaining part---
I will be previledged if knowledgable forum members give necessary Comments regarding the improvement of the utility ---
Regards,
joy_mitali

Joy ,
This is great work . How can I download converted csv files for commodities ?
If I create a new folder in METASTOCK & create the commodity scrips there , is it possible by the downloader to extract the commodity data only in the respective folder ? What is the best method ?

NSE-CASINO · #9 5th August 2006, 10:38 PM

Quote:

Originally Posted by purvija99

Joy ,
This is great work . How can I download converted csv files for commodities ?
If I create a new folder in METASTOCK & create the commodity scrips there , is it possible by the downloader to extract the commodity data only in the respective folder ? What is the best method ?

hello purvija,
it seems you have sucessfully converted NSE bhav copy to metastock developed by joy mitali. can you please guide me too.I have got stuck halfway, i cannot convert from bhavcopyin excel format to metastock , my downloader show error as "unable to open file". so please tell me what things have to be done in metastock step by step,will you.i update some selected scrips manually in metastock every day.and i donot see any thread clearly explaining the issue. i mailed to joy mitali too but no responce from that member too.

rajneesh_mailbox · #10 6th August 2006, 07:01 PM

dear joy
its good to see good utilities again & again from u.one more favour asked can u think of developing a utility to convert NSE F&O data file to be usable in amibroker. hlp idea may be taken from future data file of BSE-NSE group.this format can hlp us to analyze option in better way
i hope u can use ur excellent brain to fill this vaccum
regards
rajneesh

Similar Threads for: My MetaStock COmpatable Excel EOD Convertor
Thread	Thread Starter	Forum	Replies	Last Post
excel help	vvn	Introductions	6	9th December 2009 11:11 PM
NSE Bhavcopy Downloader and Convertor	saji oommen	Software	1	22nd March 2009 01:07 AM
excel to metastock	veneet	Software	3	21st February 2008 02:29 PM
exporting to excel	cmlee	MetaStock	5	3rd October 2005 04:34 PM

The Following User Says Thank You to joy_mitali For This Useful Post:
sanamtrade (22nd September 2009)