Office for Mere Mortals has been running for over 20 years, weve never, ever revealed or sold subscriber details.

Its part of a series: introduction and using MSN Money in Excel.

Googles GoogleFinance() function returns a lot of information about many global stocks and indexes.

Weve added another column with the vital currency detail as well eg GoogleFinance(A3,currency).

The usual 21 st century disclaimers, use at your own risk etc.

The link will download a.csv file with the data from the worksheet cells.

It should do an accurate job dealing with the incoming data.

See the Sheets column on left and the Excel version on the right.

A detailed and independent look at Windows 10, especially for Microsoft Office.

But you might like to add it anyway, to distinguish the same company being listed on multiple exchanges.

Use these in the second parameter of the function eg GoogleFinance(MSFT,priceopen).

Thats especially true for codes such as the Hong Kong bourse which are numbers, not letters.

Office Watch has been running for over 20 years, weve never, ever revealed or sold subscriber details.

Invalid email address Weve been running secure and private newsletters for over 20 years.

Thanks for subscribing Well send you future issues right away.

Webservice In Excel For Mac