NS getting error data unavailable i tried with -eq. Dear Amol, Many Thanks for this Useful Program. Is it possible to create such program for multiple stocks per day basis?

Dear Amol, You are an amazing programmer. But there is an issue here Could you pls help resolve this.

Dear Amol, When I put in a script "ACC", data of script "ACCELYA" is collected. Also how do we get data for indexes? Thanks Warm Regards Dinesh. There is an error for the BSE data as the data source is changed, so please change the code and provide is the modified file. Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing?

I have a presentation next week, and I am on the look for such information. For this, I had been using this and it's great. It has instructions which can help tradez options binaires en ligne. Historical Stock Data in Excel Just visit the site for more info. The macro code was working fine till yesterday. However, I am not sure what has happened. The code is not working.

I believe some thing wrong with the URL. Exploring creative n smarter programming solutions Recently while browsing the Indian stock market web sites NSE and BSEa thought came by to indian stock market data in excel a automated data downloader for the historical equity prices to be analyzed in excel.

NSE - National Stock Exchange of India Ltd.

Henceforth the following tool was built to do the same. The data downloaded via tool is placed on separate sheets for both NSE and BSE, upon which any post download analysis can be conducted.

Hope this tool helps you regrets signal for binary options reviews outperform the markets better. WinHttpRequest Dim htmlDocument As MSHTML.

Open "GET", prepUrl request. SetTimeouts timeOut, timeOut, timeOut, timeOut request. Length 0 Then For Each rowSubData In rowSubContent anchorRange. Description, vbExclamation, "Download Error" On Error GoTo 0 Err.

Clear End Sub modBse.

WinHttpRequest Dim lineSplit As Variant Dim rowCount As Long Dim line As Variant Dim anchorRange As Range Dim url As String DataDumpBse. Open "GET", url request.

Range "A1"xlDelimited, Comma: Posted by Amol Pandey at Newer Post Older Post Home. Subscribe by Email Subscribe Post [at] email. About Me Amol Pandey Hi, I am a programmer at a Business Intelligence firm.

Error (Forbidden)

My day to day work involves data analytics, application development for data processing and reporting. I am a big fan of microsoft products and always keep exploring the new technologies.

Excel Stock Screener for Indian Stocks

My key areas of focus upon development are "Simplified Programming" with efficient code and performance improvemnts. I am also working through my knowledge in quant finance and look forward towards some quant development and exploring the world of high performance computing View my complete profile. Template Designed by Amol Pandey.