• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel web Query : DataSource.Error: .. (404): Not Found

B

BK LAAL

Member
Dear Ninja's
Need help in resolving the below issue


1) I want to get the data into the web query from url https://www.screener.in/screens/7780/all-stock/
2) This screen can be accessed with user is logged in
76765



3) but when user is not logged in this screen cannot be accessed

screenerPrivate_imag2.png
4) I want to retrieve this data into the excel.
5) Added the authentication type as basic
76768
5) Added the following code in Advance Editor
76770
7) Following error is thrown
8) Any help in this regards is highly appreciated.
76771

9) Attaching the worksheet as well. Kindly help
 
I don't believe this is an Excel/PQ issue. When I tried to open the site directly using Chrome, I got a 404 Message. I suspect the web site is down or no longer active.
 
AlanSidman said:
I don't believe this is an Excel/PQ issue. When I tried to open the site directly using Chrome, I got a 404 Message. I suspect the web site is down or no longer active.
Click to expand...
Thanks for response

Yes only when logged in, this link will be available, for others page non found is shown
 
AlanSidman said:
You are aware that we cannot assist in this request and test the issue without the password.
Click to expand...

Ok,

All_stock - Screener

www.screener.in www.screener.in
This list is the public list when this url is used it is working fine.

But when list is private and when login is required then its not working.

Also login to screener.in is free, can u please give a try by creating ur userid and private list please
 
Apologies but I have no interest in an account of this type especially for one in a country for which I don't live. Good Luck finding a solution.
 
BK LAAL
As well as You should reread Forum Rules
There are sentences about Cross-posting and those are for You too.

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
Ps. Same kind of rules are in every Forum.
 
You must log in or register to reply here.
Back
Top