Message Boards Message Boards

GROUPS:

Get financial tickers for commodities using FinancialData?

Posted 9 months ago
1342 Views
|
2 Replies
|
0 Total Likes
|

Hi there,

I am using FinancialData with great success for stocks, currencies and ETFs. However I am struggling to get prices for commodities (Metals, grains...). Not sure whether this is available as usually traded at Chicago Board of Trade (CBOT-CME) or London Metal Exchange and cannot find their tickers.

Thanks for your support, Miguel

2 Replies
Posted 8 months ago

Hi Miguel,

This is possible for listed futures.

FinancialData will call the same database as Wolfram Alpha does, so the easy "cheat" is to use Wolfram Alpha to discover the exchange and ticker for the commodity you want.

For example, to find WTI Crude this query will help:

https://www.wolframalpha.com/input/?i=wti+oil+futures

You'll note this in the output

wolfram alpha query cap

This gives you the product code ("CL") and the exchange code ("NYMEX") that will be the ticker to use in FinancialData.

You can then write the Financial Data query as normal:

FinancialData["NYMEX:CL","Close",{2010,1,1}]

That query will return the TimeSeries of the closing prices since 2010

I will say that this can be quite unstable for less "popular" commodities such as ags...but, after two or three tries, the data populates.

In short, if the commodity / fx / rate / equity future is on ICE, CME, NYMEX, CBOT then you can probably pull the timeseries via FinancialData.

Hope that helps!

As stated in the previous post, you can pull out data from the NYMEX, CME, etc databases.

I have never been able to get data from the LME. It'd be nice to have since for at least a couple commodities London is the default exchange.

Guess Wolfram doesn't have a service agreement with them. Wolfram relies on third parties (Yahoo?) to provide Financial Data.

This reliance on third parties is patchy sometimes (right now my code isn't running).

Hope this helps

Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract