EOD Download/ Convert from NSE and BSE

[pkjha30]

Sorry for hard words from my side.I appreciate your intention to help others.I gave comment by keeping some other persons (those who made their software commercial) in this site.I know it is painful process to develp a software,keep it error free and answering others query with patience.I donot have that much of spirit in me.I will try to learn from people like you.

Hard words were irrelevant actually. No software, free or commercial can become good software unless tested by intended users.

I don't find fault with those who choose to make their software commercial.. In comparison to many data providers and TA softwares, these alternatives are pretty low cost, mostly due to individual efforts.In any case data is being used to get informations which is later used to generate profit for individuals, so there is nothing free or unethical about it.

There is nothing to learn from me , in fact , I should learn from you and many others.

Pankaj

 

[RANJITSINGH66]

hello PANKAJ,
I WANT TO USE NSE DELIVERY PERCENTAGE AND VOLUME IN AMIBROKER SO PLEASE HELP . ONE MORE THING , I COULD NOT UNDERSTAND
If you want that to be included in converted files then yoy have to use database option and select these two figures for adding to output.If you open ODBC dialogue of AMIBROKER and Select EODDlc as System DSN and EOD_NSE as database , then you will see all fields.
Conversion part is being debugged based on feedback.
I AM NEW TO AMIBROKER AND PRESENTLY USING FIBOTRADER .I WILL START USING AMIBROKER ONLY IF YOUN HELP ME WITH DELIVERY DATA IN AMIBROKER WITH EITHER ***** OR NSE SYMBOL

 

[pkjha30]

hello PANKAJ,
I WANT TO USE NSE DELIVERY PERCENTAGE AND VOLUME IN AMIBROKER SO PLEASE HELP . ONE MORE THING , I COULD NOT UNDERSTAND
If you want that to be included in converted files then yoy have to use database option and select these two figures for adding to output.If you open ODBC dialogue of AMIBROKER and Select EODDlc as System DSN and EOD_NSE as database , then you will see all fields.
Conversion part is being debugged based on feedback.
I AM NEW TO AMIBROKER AND PRESENTLY USING FIBOTRADER .I WILL START USING AMIBROKER ONLY IF YOUN HELP ME WITH DELIVERY DATA IN AMIBROKER WITH EITHER ***** OR NSE SYMBOL

Hi Ranjit

I don't know if Fibotrader has ODBC dialogues. I will check and revert.
I will see if I can include both delivery volume and percentage in EOD files itself. Bit of work but not difficult. I have to download delivery files simultaneously while downloading bhavcopy and include records.

let us see how it goes.

Pankaj

p.s.lease avoid CAPS as it is equivalent to shouting and reading is also difficult.

 

[pkjha30]

Hi Ranjit

Fibotrader does not have ODBC data sources import option. Guess I have to do it in text files.

Will comeback later if it is done.

pankaj

 

[RANJITSINGH66]

hi Pankaj,
thanks for your prompt reply . Actually people like you are asset of this forum. the format of nse headings should be like this,
ticker, date, open ,high,low, close ,volume ,ticker, openinterest
Actually openinterest= % of delivery (for cash segment)
One more thing ,please tell something about ODBC in amibroker

 

[pkjha30]

hi Pankaj,
thanks for your prompt reply . Actually people like you are asset of this forum. the format of nse headings should be like this,
ticker, date, open ,high,low, close ,volume ,ticker, openinterest
Actually openinterest= % of delivery (for cash segment)
One more thing ,please tell something about ODBC in amibroker

Hi

I think If I include only delivery Quantity in converted file that should be enough as percentage can be worked out by TA softwares.


As regards ODBC, you can start AMI and go to File>>Database Settings

Select Data Source as ODBC/SQL Universal Plugin
Base Time Interval as End of Day

Then click configure >>Pick ODBC Source >>Machine Data Source >>EODDlc
then click OK You will come to previous page. Here Select Name of The table EOD_NSE

Server Type as "MicroSoft Access -Uses[] as identifier"

Retrieve All Symbols

Then Select Desired fields.
Then click OK

You will comeback to previous page Here also click OK
You are done with. All symbols would have been uploaded.

If it is registered version then data will be saved else everytime this procedure needs to be followed. or may be only to select Machine Data Source. page which comes up everytime you open AMI .

But see that before all this you have enough data in tables.

Also better to wait for stable version.

Pankaj

 

[RSI]

Open formula builder in Amibroker and type

Graph0 = (OI/Volume)*100;

Give it a name, for example Delivery% and save it under custom folder.
Thereafter insert or overlay this indicator in the chart, preferably over the volume or as a seperate subwindow.

I think you must see the graph of delivery percentage here. I think there is no need to give this data seperately in EOD file.

If there is any mistake in afl code, any experienced member please correct it.
Hope this helps
Thanks and regards
R. S. Iyer

 

[RSI]

The format of nse headings should be like this,
ticker, date, open ,high,low, close ,volume ,ticker, openinterest
Actually openinterest= % of delivery (for cash segment)
One more thing ,please tell something about ODBC in amibroker

Format should be
ticker, name, date, open, high, low, close, volume, openinterest

Openinterest is the number of shares delivered. To get delivery percentage of the actual shares traded, I think, you will have to divide it by volume and then multiply it by 100

Delivery Precentage = (Open Interest/Volume) * 100

 

[abcdgetright]

Hi mr. pkjha

As per your suggestions i have created (manually) database directories and download the files and converted. Converting of the nse eod, fno is working. But bse, mcx, ncdex is not converting, instead it is giving a message process over but the converted file size is 1 kb. herewith i'm enclosing the error log file for your reference.

 

[pkjha30]

Hi mr. pkjha

As per your suggestions i have created (manually) database directories and download the files and converted. Converting of the nse eod, fno is working. But bse, mcx, ncdex is not converting, instead it is giving a message process over but the converted file size is 1 kb. herewith i'm enclosing the error log file for your reference.

Hi

can I assume that MCX and NCDEX download for more than one day is working now?

If it is so then I can be sure of modalities adopted for downloading multiday MCX/NCDEX data, since it was not tested on another computer.

Regarding conversion, errors listed in error.txt will be rectified. Thanks for the file as it is really helpful.

Pankaj