Using Google Finance to pull stock info

You can use my method here to copy the formula down.