Getting Current Share values from Google/Google FInance

[#1]

Hi,

I want to create a dashboard that will extract the Current Share Price from Google and use that data for Analysis in a Qlikview Dashboard.

For Example : For XYZ company, I want to extract the current i.e Today's value and also its value 1 year back and the value on the day it was bought.

For ABC company , the same data to be extracted.

Using the data for these two companies I want to display the trend since they were bought.

How do I go about extracting the data from Google/Google Finance?

Also, This is just for personal use. I want to use the dashboard to be up-to-date with the stocks and shares in my name.