Which ticker symbol can I use for the crude oil price for the
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
=GOOGLEFINANCE("NYMEX:CL") =GOOGLEFINANCE("NYMEX:CL=F") =GOOGLEFINANCE("NYMEX:BZ=F") =GOOGLEFINANCE("NYMEX:CL.1")
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