Getting current price for a stock in google spreadsheets

How to

It is both easy and possible to get the current price of a stock in google spreadsheets. You simpy use the GOOGLEFINANCE() command with a ticker. You just type =GOOGLEFINANCE("<Your stock>") in order to get the current rate. For example to get the rate for the Danish company Novo nordisk you type =GOOGLEFINANCE("NOVO-B"). This can be seen in the below image:

Google finance look up novo nordisk

That is all there is to it.

You can find the ticker for the company by searching for it on google finance. If it is not there it will not show up on your google spreadsheets. The ticker you need to use you can find below the name of the company:

Novo nordisk ticker in google finance

In the above example you would have to remove the space between CPH: and NOVO-B.

Are you not finding the correct rate?

Perhaps you are selecting the wrong stock! There are many exchanges and big companies are often found on more than one. If you are looking for the Danish company Genmab, you will not find it by typing "=GOOGLEFINANCE("GEN")". This will give you a rate of 2,07 but Genmab's rate is 1030! (as of now). This is due to the imprecision of typing "GEN". It should have been CPH:GEN. Which lets Google finance know that I wish to look for the ticker on the Copenhagen Nasdaq Exchange. Typing just "GEN" gives me Genmab on the New york stock exchange (NSE:GEN). Which gives me Genesis Healthcare Inc - a totally different company.

If you wish to see a list of all of the command you can use with GoogleFinance you can find the list here. Another way is to hover over the "googlefinance" command in your google spreadsheet and directly access it like below:

Google finance get price/rate command