Getbhavcopy: Free NSE and BSE data downloader

Hi Hemen, great to see the new version which can get data of Futures too..

I request you too add Options also.

Though i do not have the technical expertise of coding.. but i wud try my best to explain what many traders would or could be wanting...and how to go about it:

- Options on NSE site are classified as 1. OPTIDX 2. OPTSTKS

- I do not think that many of the traders who use options data for their daily analysis might be putting it into charting softwares like Amibroker. (Amibroker doesnt have any dedicated options analysis platform yet). Metastock does have but i doubt if anyone does use it. The prefered platform, i belive is MS Excel.

- You can keep an option, where it just downloads and stores the bhvcopy data.. as it is.

- If you want it to be fed as data for Meta or Ami, you will have to fuse the symbol, option, strike price and series arrays. For eg: NIFTY-PE-5100-28JAN10  this entire thing as the symbol.

- If it is to be put in ami/ meta then only O,H, L,C,Vol and OI can be used.

- Pls remember tht in the bhavcopy data, vol is given in number of contracts while OI is given in number of shares. So (number of contacts x lot size) will give you the volume in number of shares.(tht is if u want to compare todays volume and OI ) Alternately, you can even convert OI into number of contracts (which can be infact more convenient for analysis)

- I hope i have been able to help you to some threshold extent which might help you to start with including Options Data in the next verson of GetBhavcopy. Would be glad to help you further..

Rgds,

NiranjaN

Can other also voice their opinion on how the volume thing be implemented in the NSE Futures data that is available in the alpha version? However if you observe the Derivatives bhavcopy files we do not have the lot size mentioned there.

Also i did not understand much about the Options stuff as most of the data is blank, so i am not sure how they can be used to plot charts in TA softwares...

Suggestions ???

Can somebody please explain how to change the optionstk which we download in *.cvs format to metastock compatiable format??

Dear Hemen,

I fully agree with Niranjan that volume and OI  are to be in the same units (Lots or shares). I prefer that both be expressed as volume (=Lots * Lot size). In the Cash Bhav copy, the volume is given in number of shares. When both Cash Bhav copy and Futures Bhav copy express volume in number of shares, it would be possible to compare the cash and fulures volumes just by the very look. It will also be possible to write code in AB using the 'FOREIGN' function. This function refers to a field (Like OHLC or in this case volume) of 'another' stock. (ex. BHEL stock volume can be compared with BHEL futures volume)

I am not aware if any other downloader provides this facility. But if you want to ensure compatibility with other downloaders to facilitate easy migration (and backup), you may consider providing an option to user to select either lots or shares into the volume column.

Thanks for the software and the support.

murthymsr

If i want to provide this option then where do i get the two entities to calculate the volume as (Lots * Lot size). Lots as we know are currently being downloaded in the Futures file generate by Getbhavcopy, but I did not see any place where I get the lotsize. How to obtain that for each stock and index entitiy for futures?

Dear Hemen,

Try this link, hope it may be what you have asked for.

http://www.nseindia.com/content/fo/fo_mktlots.csv

Lots - this is what is now provided under volume in the Futures bhav copy.

LotSize - from the above link.

thanks for your +ve response.

murthymsr