Macro to Pull Data from Website Periodically

[REDPOOL]

Hello,
Every time I try to 'Get External Data' then, 'From Web' and punch in the following website: https://exchange.coinbase.com/trade/BTC-USD - Excel crashes.

This is what I'm trying to do:
- Set up a macro that pulls the 'Last trade price' from the website header every 5 minutes and log it into excel.
Can someone help me set this up?
Please and thank you!

[Kaper]

Excel probably crashes, because there are no simple tables on the page (this is the source type expected by get external data from web).
Data from this site can be probably properly accesed via (payed) API (Application Programming Interface) - see https://docs.exchange.coinbase.com/

[EduardoHiguchi]

Hi REDPOOL, maybe using a browser different from IE (for example, Chrome) might allow you to scrap the data of that web page. I think you can do this with Selenium with VBA. Please check this page
http://florentbr.github.io/SeleniumBasic/