nifty daily data to excel

B

begoodbetter

New Member
#1
#1
hai, i want information on how to bring data into excel , nifty50+junior stock comes 100 stocks. i want to take only that stocks into 100 sheets in one excel file to work on it. any guidence pleace help , hank u
 
S

sumeetsj

Well-Known Member
#2
#2


(This is taken from a friends website)

1. To start, roto Data - Import External Data - New Web Query

2. A mini-browser opens inside of Excel. It will display your default Internet Explorer home page.

3. Use the mini-browser to navigate to the web page containing data that you would like to download. Type www.nseindia.com into the address bar in the Excel browser. Click Go and the page loads. You will notice that there are many yellow arrows on the page. These arrows point to each table on the page. The nseindia.com page has a lot of tables. Some web pages might just have one arrow, to grab the whole page.

4. Click on a yellow arrow to select that table. Once you select the table(s), the yellow arrow(s) turn to green checkmarks. When you click the Import button, the Import Data dialog is displayed. By default, the data will be imported at the current cell pointer location.

5. Go to Data->Import External Data->Data Range Properties. Here you have to put the following
1)Refresh every 1 minute, or according to your convenience
2)Refresh data on file open
3)Insert entire rows for new data and clear unused cells

Enjoy !!!
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
C Nifty and Banknifty futures data EOD (1min) for backtesting, updated daily Intraday 9
K NIFTY & BNF daily historical data in csv format Data Feeds 1
N Daily and Historical Data for Nifty Options for Intraday Options 5
tomjerry NSE Daily Data: FII, Nifty Future, FII Stock Future, Market Put Call Ratio. Derivatives 132
VJAY Daily nifty ieod data for ami Intraday 1

Similar threads