NSE DataExtractor for FCharts

[pkjha30]

hi pkjha,

Since the last 4 hours I am not getting NSE site. This happened while I was testing Satya's DataExtractor. Of course the two are not linked, surely. Rest of the world I could access. On reading your test report, I thought, I should share this with you. Is NSE site alone is down for some reason?
thanks for your time.

murthymsr

Hi Murthy

Thanks for reading my views. Mostly, I test it from user point of view. In my opinion user experience is most important and technical competence should be geared towards this or else program will fall by wayside like thousand others. I feel this program has great utility and whatever little I can contibute I must do it for the sake of forum members.

Now coming to your post I think nse site is very much up and running fine . Just to check it I visited nse site and went to the folder containing bhav copy archives. It is also online and I could see the file for which I tried dataextractor and download it from opera.

May be there are some other issues with nse site.

One needs to examine connection parameters and permissions.

Regards
Pankaj

 

[pkjha30]

hi pankaj,

Plus is Amibroker available in India and if yes is it reasonably priced?
your views please.
regards
ragh_ash

Hi ragh

What you are doing the same I am also doing. It soe not save data. Real time quote sources for Indian stocks are not available. AmiBroker standard or Professional is not available in India. If you have International credit card you can get the paid version. I would not recemmend it as credit card transaction is still venerable. There will be issues with quote sources and support from this US based company. MetaStock is best option in India if you can afford it.

There is another software called Ganalyst lite which provides various technical indicators and once you have imported data It is saved. So far I have not seen any limitations on its use except limit in features provided.

May be it will serve your perpose.

regards
Pankaj

 

[srisara]

Dear Murthy & Panjak,

noted down your comments. just would like to list them.

1. file format to be specified as Year_Month_Day.txt (easy to do)
2. Provide terminate feature ( i need to check)
3. Check for if directory exists (easy to do)
4. Save Settings (easy to accomplish)
5. Change button from "Process" to "Download" (easy to do)
6. regarding filtering of NSE Bhav Copy (its major work, need time to do it).


also little about technology used. As said,

1. this software has very small foot print (around 60 KB file).
2. Doesnt require any Registry entries by itself.
3. No need of uninstall program, as u can simply delete the exe file.
4. I avoided using fancy VB controls like "INET", Inet has some problem doesnt download more than 60 KB, I had framgement files after download.
5. Doesnt require other software, like Excel, unlike the 1st version.

Also, little considerations, while testing i found,
1. if your I.E is set to work offline, this fails i dont know why.

Also, this uses an API urlDownloadToFile, it downloads file synchronously so till completes whole application is freezed.

I understand its limitations, but being a freeware, you could pardon me for this.

Also, pankaj, I am attaching a screen shot after running it from my computer. I dont know why it failed on your computer.

Satya

 

[ragh_ash]

thx pankaj
your reply is to the point and precise.
actually i was about to bite the bullet and buy Amibroker thru Credit card, but i also had same nagging doubts about online shopping.
so u have freed my mind and will try Ganalyst lite like u have suggested.
actually ihave used other free software Fcharts, apistock etc, but i found Amibroker fulfiilling my needs the most.
anyway i will wait till Amibroker is avialble in India.
regards
and thx once again

 

[pkjha30]

Hi Rag


You are welcome.
glad that it helped.

Regards
Pankaj

 

[pkjha30]

Hi Satya

Finally, it was able to download the files. It seems problem was at the end of server run by nseindia as predicted by murthy.

Hope we see improvements in the programme soon.

What about creating seperate eod file for each script???

Regards
Pankaj

 

[murthymsr]

Dear Satya,
This is in continuation of my earlier post of my observations on the DataExtractor.

9) On completion of the download of the selected range of dates, a pop-up window appears to indicate the completion of operation. Instead it may display an additional line to show the total downloaded files. The focus may also be shifted to read the last line at the end of the downloading operation. Many people, including me, do not like pop-ups and will be blocking them.

Similarly, when the conversion is completed, the status bar info may be replaced with the total no of files converted. Noticing the two figures match, the user will realize that DE has completely done the job.

10) I have started the program and done a download and a convert. Without closing and restarting the program, I have selected another range of dates and started the download. I wished the window to be cleared before the next report, but it did not happen.

11) You may allow a date span of 1 or 2 months only for downloads, otherwise there could be some problems on the server side, when many people download simultaneously.

12) Both the downloaded files and the converted files reside in the same folder. The user may be allowed the option to select the destination folder. Best-Charts has a default folder location for the EOD files.

13) I have tested the converted file as input into FCharts. Fcharts will process the manually selected file into a data-file of its own and is NOT particular of the filename as long as the data format is OK. So the data is displayed in Fcharts well.

But I was not successful in using the same data as input to Best-Charts. Best-Charts uses the same EOD data as it is. So it not only wants the data in the specified format, but also the filename. Best-Charts Wants the files named in YYYYMMDD format strictly. The users can easily adopt themselves to this date convention. Otherwise, one is forced to manually rename the files and copy into the default folder. I only hope that other popular software do not impose such restrictions on file-naming standards.

Thanks for the good software and your receptive mind for suggestions.
murthymsr

 

[pkjha30]

Hi satya

.....I will later suggest you a good versioning software.

regards
Pankaj

Hi satya

you can put the following code in the form load event.

Dim str1 As String
'use str1 to instert newline character
str1 = Chr$(13)

'you use the Version Numbering feature from the project 'properties 'Dialog box and click tab make. here you select ' "Auto Increment" 'checkbox. Other infomations can also 'be provided here.
'Versioning supports a three-part version number which 'allows for major, 'minor and Revision level. The Auto 'Increment feature, when selected, 'automatically increases 'the Revision number by one each time you 'executethe 'Make Project command for your project.

'From general Properties tab you can provide product 'name.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

'create a label of appropriate size and name it lblVersion
lblVersion.Caption = App.ProductName & str1 & "Version: " & App.Major & "." & App.Minor & "." & App.Revision & str1 & str1 & str1 & "Designed by:- " & str1 & App.Comments & ";" & str1 & str1 & "Company Name :- " & str1 & App.companyname
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
This way one can keep track of the latest version .

Regards
pankaj

 

[anbuji]

Satya,
Thanks for the wonderful tool. This is what I was looking for years.
Its very useful for NSE. IS there a similar workarounds for BSE stocks and commodities and Futures ! Hope this will satisfy everyones need!

--
anbu

Friends,

The file which i am attaching (Data Extractor ver 2.0) now should work on both Win 98 / 2K / XP machines.

Also, it needs a dll "msstdfmt.dll", it should be present in your windows\system32 directory. In case it is missing, please install it. I am attaching it with the zip file here.

coming to the features: This new version is slightly different from other versions by

1. there is no selection of Fcharts, MetaStock etc etc.
2. It creates a standard output file. the contents are
Symbol, YMD(YearMonthDay), Open, High, Low, Close , Volume.
3. This outputed file can be used as input to most of the softwares like FCharts, MetaStock, AmiBroker ( I tested it with all these softwares).

4. It displays, whether a file is downloaded or not.

5. It has 2 buttons, one is Process to download file from NSE and convert to convert the NSE file to text file.


Let me know your comments and any problems you facing while trying this.

Note: Murthy, please try this on your machine and let me know please.

Satya

 

[vikrammahad]

How do I download your software. I do not see a link for "save attachment" or "download attachment" anywhere.