Good Day

On Excel 2016, I keep track of my shares. I have been wanting to start including the current trading prices for the shares (and I want to use Google Finance as they are pull the information I need from the JSE in South Africa as well as other exchanges.

Is there a way to connect to Google Finance to pull the information directly into Excel? Going 1 step further, is it possible to pull the price per share as at a specific date instead of using the current one only?

Thanks.