• 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.

Stock quotes

K

Karanbir Soin

Member
Hello.
I need to get the latest value of stock quotes traded in indian markets in my table.
I have a trading account on icicidirect.com that can be accessed with password and there is a page that has these values. How to get these into excel. I am using Excel 2016.

Best Regards.

Karanbir
 
Try leveraging PowerQuery (Get & Transform), From Web query.

If the site offers API access, you can leverage that, using advanced option in Web Query, you can set API query string along with any headers needed.

If not, it will be quite a bit more involved. As Excel's connector to web, does not offer OAuth2 & other login method to web site out of the box.

If you are not married to Excel, you can still use PowerBI Desktop to do the same, with added authentication built in.
 
You must log in or register to reply here.
Back
Top