get intraday data for free

#1
i have developed a web robot and a excel web query file using which you can download intraday data in CSV format for free just download this query file which is nothing more than a simple text file, after downloading the file rename the file to query.iqy. start excel go to data menu---import external data---import data and then browse to the location where you have downloaded the query file and click open, follow the easy procedure after that. you need to specify the stock code in icicidirect.com format. you can get that by visiting the link https://secure.icicidirect.com/trading/equity/trading_stock_code.asp?Symbol=RE&ExchangeCode=NSE just replace the red letters by company name and you will get company code. after that you need to type yes if you want header info or no if you dont want header.
the procedure is simple if you do it right just once.

if any difficulty let me know.
 
#3
Dear xman thanks. but when i tried only the link with replacing RE with REL, it gave error message...
i guess you are looking for reliance energy, the code for REL with ICICIDirect.com is BSES. so replace RE with BSES. i am working on it so that you can use NSE code, however there are some problems which would be resolved soon, till that time you have to use ICICIDirect.com code.
 

Laksh

Active Member
#6
i have developed a web robot and a excel web query file using which you can download intraday data in CSV format for free just download this query file which is nothing more than a simple text file, after downloading the file rename the file to query.iqy. start excel go to data menu---import external data---import data and then browse to the location where you have downloaded the query file and click open, follow the easy procedure after that. you need to specify the stock code in icicidirect.com format. you can get that by visiting the link https://secure.icicidirect.com/trading/equity/trading_stock_code.asp?Symbol=RE&ExchangeCode=NSE just replace the red letters by company name and you will get company code. after that you need to type yes if you want header info or no if you dont want header.
the procedure is simple if you do it right just once.

if any difficulty let me know.
Hi xman,
Can your s/w backfill data if the computer is started late or put off for some time during trading hours?

Laksh
 

biggles

Active Member
#7
Hi XMAN,

i tried ur robot, all well :confused: except i keep getting the error message
"The robot behind this page have encountered a problem that may be solved by the author of the robot, using the information below:

Error from the Click action. The following alert message was generated by JavaScript:

"
TheSymbol field accepts letters,numbers only.

Please re-enter your Symbol".


here is how i fed in the symbol"http://service.openkapow.com/xmanin/getquoteicicidirect.csv?Symbol=["STABAN"]&header=["NO]

can u clarify?

thanks:cool:


i have developed a web robot and a excel web query file using which you can download intraday data in CSV format for free just download this query file which is nothing more than a simple text file, after downloading the file rename the file to query.iqy. start excel go to data menu---import external data---import data and then browse to the location where you have downloaded the query file and click open, follow the easy procedure after that. you need to specify the stock code in icicidirect.com format. you can get that by visiting the link https://secure.icicidirect.com/trading/equity/trading_stock_code.asp?Symbol=RE&ExchangeCode=NSE just replace the red letters by company name and you will get company code. after that you need to type yes if you want header info or no if you dont want header.
the procedure is simple if you do it right just once.

if any difficulty let me know.
 

Laksh

Active Member
#8
i have developed a web robot and a excel web query file using which you can download intraday data in CSV format for free just download this query file which is nothing more than a simple text file, after downloading the file rename the file to query.iqy. start excel go to data menu---import external data---import data and then browse to the location where you have downloaded the query file and click open, follow the easy procedure after that. you need to specify the stock code in icicidirect.com format. you can get that by visiting the link https://secure.icicidirect.com/trading/equity/trading_stock_code.asp?Symbol=RE&ExchangeCode=NSE just replace the red letters by company name and you will get company code. after that you need to type yes if you want header info or no if you dont want header.
the procedure is simple if you do it right just once.

if any difficulty let me know.
I tried your robot. I followed all the instructions as per your post. But at the final step after browsing to query.iqy and clicking open it asks for type of data - whether delimited or fixed with. Which ever I select the ultimate result id the parsing of the text in query file in columns. Nothine further happens. Any help?

Laksh
 

Similar threads