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

Need help to link a particular information in a webpage in Excel

Not sure if this is what you are looking for. But if you look in the source code of the page you will see following lines.
Code: 
var pageURLs = [
    '/products/content/equities/equities/mrkt_timing_holidays.htm',
    '/products/content/equities/mutual_funds/mrkt_timing_holidays.htm',
    '/products/content/equities/slbs/mrkt_timing_holidays.htm',
    '/products/content/derivatives/equities/mrkt_timing_holidays.htm',
    '/products/content/derivatives/currency/mrkt_timing_holidays.htm',
    '/products/content/derivatives/irf/mrkt_timing_holidays.htm',
    '/products/content/debt/rdm/mrkt_timing_holidays.htm',
    '/products/content/debt/wdm/mrkt_timing_holidays.htm',
    '/products/content/debt/corp_bonds/mrkt_timing_holidays.htm',   
      '/products/content/debt/ndm/mrkt_timing_holidays.htm'

So the info Equities holidays are stored in...
https://www1.nseindia.com/products/content/equities/equities/mrkt_timing_holidays.htm

Now go to ribbon tool Data tab and select "From Web". Paste in above URL and hit "Go".

After page loads, click on import. Below shows part of import result.

upload_2016-5-11_9-7-45.png
 
Chihiro said:
Not sure if this is what you are looking for. But if you look in the source code of the page you will see following lines.
Code: 
var pageURLs = [
    '/products/content/equities/equities/mrkt_timing_holidays.htm',
    '/products/content/equities/mutual_funds/mrkt_timing_holidays.htm',
    '/products/content/equities/slbs/mrkt_timing_holidays.htm',
    '/products/content/derivatives/equities/mrkt_timing_holidays.htm',
    '/products/content/derivatives/currency/mrkt_timing_holidays.htm',
    '/products/content/derivatives/irf/mrkt_timing_holidays.htm',
    '/products/content/debt/rdm/mrkt_timing_holidays.htm',
    '/products/content/debt/wdm/mrkt_timing_holidays.htm',
    '/products/content/debt/corp_bonds/mrkt_timing_holidays.htm', 
      '/products/content/debt/ndm/mrkt_timing_holidays.htm'

So the info Equities holidays are stored in...
https://www1.nseindia.com/products/content/equities/equities/mrkt_timing_holidays.htm

Now go to ribbon tool Data tab and select "From Web". Paste in above URL and hit "Go".

After page loads, click on import. Below shows part of import result.

View attachment 30859
Click to expand...

Hello Chihiro,

Well i tried but was not successful. A screen shot is attached in a file. Well i need only the Trading Holidays of Equities only not any other stuff.

Regards,

Sonjoe Joseph
 

Attachments

  • err.png
    err.png
    324.2 KB · Views: 19
From the looks of it. You are pulling from wrong URL. Use the link I supplied in my post. This is the simplest way to pull the info you want.

You can then clean it or manipulate it as needed for your purpose.

If you want to learn more about pulling info from Web. Read through the link and navigate through the site for other articles.

http://analystcave.com/web-scraping-tutorial/
 
Chihiro said:
From the looks of it. You are pulling from wrong URL. Use the link I supplied in my post. This is the simplest way to pull the info you want.

You can then clean it or manipulate it as needed for your purpose.

If you want to learn more about pulling info from Web. Read through the link and navigate through the site for other articles.

http://analystcave.com/web-scraping-tutorial/
Click to expand...

Hello Chihiro,

I will go through the link as per your advice. But normally there is a method to link a particular information we want from web to excel. I have tried this method but getting a security warning. Just need to fix this issue. The method is as follows.

Data ->From Web -> In the Address paste the link -> Press Go -> from here on i'm getting a warning ie Securing warning "Do you want to view only the webpage content that was delivered securely? An error has occurred in the script on this page. Normally if everything goes fine in the webpage there will be yellow arrow signs were we just need to click it and just click the import button. That particular thing will be copied. In my case its not working. In the youtube you can do a search on this will get some videos. I did looking to the youtube video but in my case its not working. I'm using excel 2007. Can you solve the issue. Anyone can respond.
 
This QueryTable method (Data menu, From Web) works
for some webpages, not for all !

So this method does not work with your link …
However as yet written by Chihiro,
this method works with his post #2 link !
As it works under my 2003 tests version, it works under your 2007 version !
With no choice except download all the webpage …
After you can clear all undesired data, what else ?!
​
 
Marc L said:
This QueryTable method (Data menu, From Web) works
for some webpages, not for all !

So this method does not work with your link …
However as yet written by Chihiro,
this method works with his post #2 link !
As it works under my 2003 tests version, it works under your 2007 version !
With no choice except download all the webpage …
After you can clear all undesired data, what else ?!
​
Click to expand...

So Marc how to solve the issue any idea????
 
You must log in or register to reply here.
Back
Top