Share via

Excel stock data - Trying to pull in light sweet crude oil price - not working

Anonymous
2022-11-12T22:23:01+00:00

Hi, I'm trying to use the built in excel stock price function to pull in the price for light sweet crude. I've tried searching it in the data selector with no luck. I've tried following the steps inthis tutorialand it can't locate the price using '@CL01.

All the other commodities outlined in this postwork. Did Microsoft remove the ability to pull in crude oil prices on this add-in earlier this year?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-01-17T18:08:00+00:00

    figured out Brent and WTI. Use UKOIL and USOIL for those. Still need help on Copper futures, Nickel futures. Also would like to add US Treasury futures. Does anyone know had to get those prices loaded up? Thanks

    Was this answer helpful?

    20+ people found this answer helpful.
    0 comments
  2. Anonymous
    2023-03-27T21:55:00+00:00

    I wrote an article in the Mr. Excel forum. It contains links to a file and instructions and how to create the Stock Data Types for many tough-to-find symbols, like indexes and commodities.

    The article is called 'Stock Data Types searches are Unwieldy'. In case links are allowed in this forum, here it is.

    I have to say, this process is so frustrating. Why can't there be a master list we can all search through to find what we need?

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-11-12T22:48:40+00:00

    Yes, the youtube video is instructing me to enter the symbol '@CL01 using that function but it doesn't recognize it.

    I'm able to successfully get it to work for other commodities like natural gas, copper but no luck with oil.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2023-01-17T15:48:15+00:00

    I can't get '@CL0Y or '@HG0Y to work. I can't get Brent to work either. The only commodities that have worked for me are Gold, Silver, Platinum, Natural Gas and Soybeans.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2022-11-12T22:35:34+00:00

    re:built in excel stock price function

    can you share this function with screenshot because i can not open youtube?

    Was this answer helpful?

    0 comments