NSEL E-series EOD

amsin21

Well-Known Member
#1
Hi,

Is there any way to download the EOD data for the e-series from NSEL? Please advise.
 

sr114

Well-Known Member
#2
Amsin21

in the bhav copy of NSEL, there is an option of View in Excel. after opening the bhav copy in excel save it in ur pc. but the main problem arises in sorting the data . write a macro to get the proper data . some one can write the macro to get the data

regards
sr
 

amsin21

Well-Known Member
#3
Hi,

Found myself a solution for the same.

Go to hxxp://www.nationalspotexchange.com/Sitepages/MarketMaster.htm?pg=13

  • Select "DateWise"
  • Select Asset Name : All
  • Select Commodity Symbol : All e-series (see attached image)
  • Click "GO"
  • From the report screen, "Export To Excel option" to download the bhavcopy in csv format.

Now preparing the downloaded csv for Amibroker import using getbhavcopy downloader data format(hxxp://www.getbhavcopy.com/importingtoamibroker.htm)

Format
Ticker,Date_YMD,Open,High,Low,Close,Volume,OpenInt

1. Open the csv in excel
2. Delete column "Asset Name"
3. Cut and paste "Product Name" column as the first column.
4. Highlight the date column, right click and select "Format cells", select "Custom" as category, under "Type" write "yyyymmdd" and click OK.
5. Replace all "GRAMS" and "KGS" in Trade Volume column with blank (highlight column, use find and replace, replace column keep blank)
6. Cut and paste "Turnover (Rs. In Cr)" as the last column.
7. Replace all values in the above column with 0.
8. Delete all headings
9. File > Save as > File name:desired filename.txt > Save as type : CSV (Comma delimited).
10. Import using Amibroker "import ASCII" option.

Also find the link for NSEL e-series bhavcopy formatted for Amibroker import (from 17-03-2010 to 18-05-2012)
hxxp://www.4shared.com/office/rq-5nQ8n/BhavCopyHistoricalData_17-03-2.html
 
Last edited:

amsin21

Well-Known Member
#4
Thanks buddy,.... detailed process posted below your message.
 
#5
want NSEL profit loss calculation sheet

Please proide NSEL profit -loss sheet if anybody have.

Aur Please Share a profit loss calculation in CASTKADI3
 

amsin21

Well-Known Member
#6
Try attached excel sheet. Created for my use. Feedback appreciated. Copy & paste below the previous block for new contracts.

Deep blue colored cells - daily you need to change as per the contract

Light orange cells - Change as per your state rules and broker. (one time change)

http://www.4shared.com/file/rCO-urs7/Profit__Loss_-_Commodities_-Tr.html

Enjoy :thumb:
 
#7

amsin21

Well-Known Member
#8
nice share . can useful for mcx-ncedx but i want for National Spot Exchange if any body have?
Instead of future price and lot size...you need to have spot price and lot size....that is the difference from my point of view....or you can derive one from this concept and share....
 

Similar threads