NO 1 KNOWS???? Web Query ques unanswered....!!!!!!

[Dhruv]

Dear Sir,

i dont know excel programing but only uses its functions.i ve made a "open interest tracker" for my peronal data interpretation but few data is not coming thru webquery selection. Eg :

http://www.nseindia.com/marketinfo/companyinfo/companysearch.jsp?cons=idfc&section=7#

here im trying to download "PRICE INFORMATION table" but only left column is visible n values are not.... my whole sheet has gone useless coz of this....

plz suggest

Waiting eagerly for ur reply.....

Thanks in adv.

Dhruv

 

[Hui]

Dhruv

Excel Web Query can only retrieve data from HTML or XML based web sites

It is possible that this site is using something else to populate the tables and hence they are not accessible.


I would try a number of other data sources and see if you can get better results.


I believe a lot of people have success with Yahoo Finance and Google, But I can't comment of either


ps: No Need for the Capitals and !!!! here please.

All responses here are voluntary and unpaid.

ie: We don't have to help at all.


http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

 

[Dhruv]

Thanks for the reply...

yahoo n google dont provide FUTURES data, so its a complusion using this site... Isnt there any other way to fetch that data thru excel...?

plz helpme out, n reply even if its not poss.

many data on same site is fetchable thru excel by web query...

its a intraday data filled in light yellow tables which are not fetchable...

plz try.

Graphs on yahoo finance are also not coming to excel. plz comment on that too...

thanks again...