Anyone has any idea how can I use vba to scrape the previous closing rate of a list of currencies to excel?
<tbody>
</tbody>
For example, if I want to check the previous closing of AUDUSD, I would need to go to the following website, and copy the previous close figure to excel.
But I would need to do the above step for every single currencies. Any way to use vba to scrape such figure?
https://www.marketwatch.com/investing/currency/audusd/historical
https://www.marketwatch.com/investing/currency/usdcad/historical
etc..
Thank you.
<tbody>
</tbody>
AUDUSD |
USDCAD |
USDCHF |
EURUSD |
GBPUSD |
USDJPY |
NZDUSD |
USDCNH |
<tbody>
</tbody>
For example, if I want to check the previous closing of AUDUSD, I would need to go to the following website, and copy the previous close figure to excel.
But I would need to do the above step for every single currencies. Any way to use vba to scrape such figure?
https://www.marketwatch.com/investing/currency/audusd/historical
https://www.marketwatch.com/investing/currency/usdcad/historical
etc..
Thank you.
<tbody>
</tbody>