Extracting EOD Data from BSE

Earlier, I had worked around to download Bhavcopy from NSE. Now, I would make a similar attempt to download the BSE Bhavcopy

Objective: Download Bhavcopy (Equity) from http://www.bseindia.com and save only relevant columns Date, Symbol, Name, Open, High, Low, Close, Last and Volume.

[Fixed] Extracting EOD Data from NSE

My prime interest being the Indian financial markets, the first step would be to get the data to play around. NSE India provides EOD of data as bhavcopies. The same are stored as zipped files at their servers. Downloading them one by one for a larger time frame will be very tedious, hence I will attempt to automate the process.

There is a great tool for statistical computing called R. It is open-source with a lot of development being done across various packages. This interests me a lot because of it simplicity and power. I would make my attempt of automating bhavcopy downloads using this software. If you want to try the same, you can visit the downloads section of R-Project and get the latest version

Objective: Download Bhavcopy (Equity) from http://www.nseindia.com and save only relevant columns Date, Symbol, Open, High, Low, Close, Last and Volume.

To download the Bhavcopy (Equity) from http://www.bseindia.com refer to this post.

The Beginning of Learning Technical Analysis

Googling for financial lessons throws up thousands of website, few excellent, while the others doing self promotion or trying to sell their system or tips.

As I learn the trading techniques, I would like to share in this blog, along with my observations, keep re-visiting them over time and try to improve upon the techniques and strategies.

Of course, for analysis, and playing around with data, I would be requiring a tool. I have been fascinated by R-Project, being open source, and a lot of development and resources available on the net. I might support it with Excel/Google Spreadsheet. Let see, how my learning goes. My current skill set in R-Project is beginner, and with practical implementations, I would like to enhance it.

If there are any visitors, other than me, would request them to provide suggestions and criticize my approaches.


Thanks
Gaurav

FIIs in India Geographic Distribution

The Geographic spread of FIIs in India is depicted in the map below

Exploration and drilling the map to the lowest level (office address location) is possible.

Go ahead and explore!!





 
Details are available in spreadsheet below:

30-July-2013: The google spreadsheet linked to the data has got removed due to google upgrades. Will get this resolved soon.

Data Source: SEBI, 31-March-2011

Map Created using BatchGeo and Google Maps