Getting current price for a stock in google spreadsheets

It is both easy and possible to get the current price of a stock in Google spreadsheets. You simply 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

You can find the ticker for the company by searching for it on google finance (for example novo nordisk stock). 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. It is good practice to prefix the ticker with the stock exchange! read on.

Are you not finding the correct rate?

Perhaps you are selecting the wrong stock! There are many stock exchanges and big companies are often found on more than one. If you are looking for the Danish company Simcorp, you will not find it by typing "=GOOGLEFINANCE("SIM")". This will give you a rate of 9,37 but Simcorp's rate is 811,5! (as of now). This is due to the imprecision of typing "SIM", instead of "CPH:SIM". Which lets Google finance know that you wish to look for the ticker on the Copenhagen Stock Exchange. Typing just "SIM" gives you "Grupo Simec SAB de CV" on the New york stock exchange (NYSE:SIM), which is a totally different company.

If you wish to see a list of all of the commands 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

That is it!

I hope you found this helpful, let me know below if you did - or if you did not! :)