Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
In Excel 2002, On the ToolBar i click on:
Data Import External Data New Web Query In the Address field I enter the following https://secure.icicidirect.com/tradi...p?Symbol=NIFTY The web page opens properly. Then i click on Import, Put data on existing worksheet. The following error comes Unable to open https://secure.icicidirect.com/tradi...p?Symbol=NIFTY. Cannot download the information you requested. This error has started to come recently. Till few weeks back data was getting downloaded on the excel sheet from this particular website. Now also data is getting downloaded from other sites, but not from this site. I urgently need data download to excel from this site. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
Can you provide your codes by blocking your login id and password.
"Pradip Jain" wrote: In Excel 2002, On the ToolBar i click on: Data Import External Data New Web Query In the Address field I enter the following: https://secure.icicidirect.com/tradi...p?Symbol=NIFTY The web page opens properly. Then i click on Import, Put data on existing worksheet. The following error comes Unable to open https://secure.icicidirect.com/tradi...p?Symbol=NIFTY. Cannot download the information you requested. This error has started to come recently. Till few weeks back data was getting downloaded on the excel sheet from this particular website. Now also data is getting downloaded from other sites, but not from this site. I urgently need data download to excel from this site. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query
I can give you an alternative. I have a free open-source EXCEL add-in
that can extract data from most web pages. I originally wrote the add- in because of various problems and issues I was having with EXCEL Web Queries. The add-in, documentation on its functions, and templates and examples of their usage, can be found in the files are of this Yahoo Group: http://finance.groups.yahoo.com/group/smf_addin/ For example, the following three formula could be used to grab the last price, the opening price, and the high price from the web page you mention: =RCHGetTableCell("https://secure.icicidirect.com/trading/equity/ trading_stock_quote.asp?Symbol=NIFTY",1,"Last Trade Price") =RCHGetTableCell("https://secure.icicidirect.com/trading/equity/ trading_stock_quote.asp?Symbol=NIFTY",1,"Day Open") =RCHGetTableCell("https://secure.icicidirect.com/trading/equity/ trading_stock_quote.asp?Symbol=NIFTY",1,"Day High") ...which returns: 4497.7 4509.65 4538.6 On Sep 11, 12:46 am, Pradip Jain wrote: In the Address field I enter the following:https://secure.icicidirect.com/tradi...tock_quote.asp... This error has started to come recently. Till few weeks back data was getting downloaded on the excel sheet from this particular website. Now also data is getting downloaded from other sites, but not from this site. I urgently need data download to excel from this site. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
Stop to modify the SQL query manually entered into query ! | Excel Programming |