QuantConnect Community

At the moment, we do not have the underlying of the futures in our database. For that reason, we get the null value.

I guess i have the definition of underlying wrong.

I request the expiries of the future with symbol (a String) Futures.Indices.SP500EMini within a time range (7 days to 1/2 year). I get expiries via OnSecuritiesChanged and i want to link them back to that symbol. The symbol must be in the database somewhere, as i am getting the expiries for that symbol.
I can use string operations to obtain the link, as the base Future is "/ES" and the expiries are ESU17, ESM17, ESH17, ESZ17, etc. This is similor for CL and GC

Bart van den Broek, could you please rephrase your question?
I don't know whether you want the underlying or the expire date.

You can buy and sell the contract with the symbol provided in the Securities changed event. In LEAN there is one "canonical" security which acts as a holder/helper for the "ES" ticker but has fake expiry dates etc; but then all the futures contracts are separate individual securities which live in the securities dictionary.

Jared, thank you for that clarification.
Alexande, want to retrieve the holder/helper for the "ES" ticker of the individual securities / futures contracts so i can perform a selection on the expiry. The intent is to select the most current (highest trading volume) expiry. Since I see a consistent pattern here, for example, 7 days before the expiry of the nearest ES (S&P500 mini future), the next expiry has the highest volume.
And of course, I need this because of multiple futures: "ES", "CL", "GC" etc.

Turns out easy to solve:

    public static String GetFutureBaseName(Future fut)
        {
            return fut.Symbol.ID.Symbol;
        }