Help with accessing history close price

Hi Matthieu,

It seems like you're trying to access the close prices of all symbols in the NASDAQ 100. From the error message, it appears that there might be an issue with how you're trying to access the close prices from the DataFrame.

Here's how you can access the close prices for all symbols:

df_close = df['close'].unstack(level=0)

This will transform the DataFrame so that the column indices are the Symbol of each ticker and each row contains the close value. You can then access the close price for a specific symbol like this:

past_close_price = df_close[symbol]

Regarding the display of the whole DataFrame in the console, pandas has a setting that limits the maximum number of rows and columns displayed. You can change this setting as follows:

import pandas as pd

pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)

This will remove the limit on the number of rows and columns displayed. However, please be aware that displaying a large DataFrame in the console might be slow.

Here's how you can modify your code:

import pandas as pd

def Initialize(self):
    self.nasdaq100 = ['AAPL', 'GOOG', 'MSFT', 'AMZN', 'FB', 'NVDA', 'TSLA'…]
    pd.set_option('display.max_rows', None)
    pd.set_option('display.max_columns', None)

def OnData(self, data: Slice):
    if not self.Portfolio.Invested:
        df = self.History(self.nasdaq100, start_time, end_time, Resolution.Daily)
        df_close = df['close'].unstack(level=0)
        self.Debug(df)
        self.Debug(df_close)
        for symbol in self.nasdaq100:
            past_close_price = df_close[symbol]
            self.Debug("past_close_price is worth ", past_close_price)

I hope this helps! Let me know if you have any other questions.

Sources:

• QuantConnect Documentation: US Equity
• QuantConnect Documentation: Matplotlib
• QuantConnect Documentation: Airline Buybacks