Which ticker symbol can I use for the crude oil price for the GOOGLEFINANCE function?

Nasdaq Brent oil is "BZ:NMX"


Nasdaq Crude oil is "CL:NMX"


I've tried these but #N/A is displayed


I also tried CL and BZ but they aren't crude oil, they are companies


NASDAQ:BZ = Kanzhun Ltd

NASDAQ:CL = Colgate Palmolive

I also tried NASDAQ:CRUD


Which looks correct "WisdomTree WTI Crude Oil ETC"

But the result is 11.90 when the BZ:NMX is 119.51 (as at 8-June-2022)

Just for the record - I'm not a trader, I wanted to get historical prices of crude oil and compare the rise/fall to petrol prices at the pump


There's a list of exchanges here


I think its the NYMEX that I need to use but still getting #N/A


There's an answer here which uses YAHOOFINANCE - its an add on (via extensions) but wants to access a lot of information so I haven't installed it



1 Answer 1


The correct formula for Crude Oil is =googlefinance ("WTI") as shown in the below example

enter image description here

This was borne out by the result below achieved at the same time from https://www.google.com/finance/quote/WTI:NYSE`

The web page constantly updates so be aware that results change dynamically and it may be necessary to refresh the sheet accordingly.

enter image description here

  • Hey 24601, thank you for the reply. I think I tried that too but WTI is the price for the company though not for crude oil Jun 8, 2022 at 15:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.