Excel itself is built on VBA.
Excel has feature to extract data from any website and present it on the sheet. Here you can set the time interval for updation.
If you are not a programmer or have little knowledge then it will be difficult for you to automate this accurately.
Google doc also has excellent scripting options but again one must know programming