• 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

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
 

AlanSidman

Well-Known Member
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.
 

BK LAAL

Member
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.
Thanks for response

Yes only when logged in, this link will be available, for others page non found is shown
 

BK LAAL

Member
You are aware that we cannot assist in this request and test the issue without the password.
Ok,
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
 

AlanSidman

Well-Known Member
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.
 

vletm

Excel Ninja
BK LAAL
As well as You should reread Forum Rules
There are sentences about Cross-posting and those are for You too.
Ps. Same kind of rules are in every Forum.
 
Top