Hello,
I am trying to pull current market data (bond rates) into excel from the below link:
https://rates.chathamfinancial.com/us-market/rates
In short, I am trying to pull the rates for each respective term in the 'Current' column as per the highlighted below. I have been able to do this using excel's data scraper tool and using vlookups but I am pretty sure there is a better way (more accurate/consistent) to do this via VBA.
<header _ngcontent-c7="" class="rates-table__header" style="font-family: "PT Sans", Helvetica, Arial, sans-serif; box-sizing: border-box; display: flex; place-content: center; flex-direction: column; height: 30px; width: 606px; padding-left: 10px; margin: 0px; background-color: rgb(126, 126, 126); color: rgb(65, 65, 65); font-size: 16px;">[h=1]US TREASURIES[/h]</header>[FONT="]
<thead _ngcontent-c7="" style="box-sizing: border-box;">
</thead><tbody _ngcontent-c7="" class="ng-star-inserted" style="box-sizing: border-box; padding: 10px;">
</tbody>[/FONT]
Any help would be appreciated!
I am trying to pull current market data (bond rates) into excel from the below link:
https://rates.chathamfinancial.com/us-market/rates
In short, I am trying to pull the rates for each respective term in the 'Current' column as per the highlighted below. I have been able to do this using excel's data scraper tool and using vlookups but I am pretty sure there is a better way (more accurate/consistent) to do this via VBA.
<header _ngcontent-c7="" class="rates-table__header" style="font-family: "PT Sans", Helvetica, Arial, sans-serif; box-sizing: border-box; display: flex; place-content: center; flex-direction: column; height: 30px; width: 606px; padding-left: 10px; margin: 0px; background-color: rgb(126, 126, 126); color: rgb(65, 65, 65); font-size: 16px;">[h=1]US TREASURIES[/h]</header>[FONT="]
Current | 1 Day Ago | 1 Mo. Ago | 1 Year Ago | |
---|---|---|---|---|
1 Year | 2.620% | 2.645% | 2.572% | 1.417% |
2 Year | 2.837% | 2.877% | 2.815% | 1.583% |
3 Year | 2.890% | 2.954% | 2.898% | 1.727% |
5 Year | 2.944% | 3.011% | 2.963% | 2.042% |
7 Year | 3.031% | 3.099% | 3.041% | 2.256% |
10 Year | 3.108% | 3.169% | 3.082% | 2.415% |
15 Year | – | – | – | – |
30 Year | 3.334% | 3.367% | 3.218% | 2.923% |
<thead _ngcontent-c7="" style="box-sizing: border-box;">
</thead><tbody _ngcontent-c7="" class="ng-star-inserted" style="box-sizing: border-box; padding: 10px;">
</tbody>