Hi,
I have an excel tool that will go to a website and fetch a table of data and import it into excel. My problem is that sometimes a website does not have data in a table format. For example, here is a website: https://www.wsj.com/market-data/bonds I want to be able to fetch some data from this site using a macro in excel. Specifically, I want the Consumer Rate data. Is a way to find this page in an XML format that would have this data? I was able to do this for another page (below) that I pull rates form, but I was looking for a way to do it with the WSJ. I can get my excel tool to work with the XML format.
Here is an example of what I was able to do before:
Website Page: https://www.newyorkfed.org/markets/reference-rates/sofr
XML format of the same page: https://markets.newyorkfed.org/read...=25&startPosition=0&sort=postDt:-1&format=xml
Thanks, let me know if my question is not making any sense.
I have an excel tool that will go to a website and fetch a table of data and import it into excel. My problem is that sometimes a website does not have data in a table format. For example, here is a website: https://www.wsj.com/market-data/bonds I want to be able to fetch some data from this site using a macro in excel. Specifically, I want the Consumer Rate data. Is a way to find this page in an XML format that would have this data? I was able to do this for another page (below) that I pull rates form, but I was looking for a way to do it with the WSJ. I can get my excel tool to work with the XML format.
Here is an example of what I was able to do before:
Website Page: https://www.newyorkfed.org/markets/reference-rates/sofr
XML format of the same page: https://markets.newyorkfed.org/read...=25&startPosition=0&sort=postDt:-1&format=xml
Thanks, let me know if my question is not making any sense.