Free googlefinance data is not downloadable into a standard excel spreadsheet, other than converting into another format that I'm aware of, and it is not the method I use. This is a simple effective method.... Either buy a chromebook and use the spreadsheets provided or... Simply open Chrome web browser on your PC and at the menu bar it says 'APPS'. Click on this and then click on 'Sheets' You will need a google account, but it's easy enough to subscribe. A subscription will give you access to their cloud service. I have a chromebook, when you buy one of these it provides one with 100GB of free cloud service for 2 years. Anyhow, on the spreadsheet from Chrome, enter your formulae and you will have free stock and indexes data which updates automatically, these from various exchanges around the world. Next post I will illustrate the formulas.
ignore the little dot prior to the equals sign in the example above, I needed to do that in order to get it to display as a text file, the format function in this instance wasn't behaving so had to use this method. Yesterday date and day before date look identical, only because my computer is working off a different date than currently in USA.
These are functions which will supply data results... price priceopen high low volume marketcap tradetime datadelay volumeavg pe eps high52 low52 change beta changepct closeyest shares currency name