My MetaStock COmpatable Excel EOD Convertor

#1
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

Well-Known Member
#2
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
 
#3
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

Well-Known Member
#4
joy_mitali said:
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
 
#6
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.
 
Last edited:
#7
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
 
#8
joy_mitali said:
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 ?
 
#9
purvija99 said:
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.
 
#10
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