How to get Weekly EMA by Mike Reichard

Mike Reichard INVESTOR

| Reward Discussion

Hi all,

I have been trying to get a weekly EMA going however I have realized Resolution only goes to Daily. With that being said, I have also tried to use a consolidator to create a Weekly bar to use:

Consolidate(symbol, Calendar.Weekly, WeeklyEMA);

However I keep receiving the error:

'Calendar' is an ambiguous reference between 'QuantConnect.Data.Consolidators.Calendar' and 'System.Globalization.Calendar'

I have looked through several posts as well as the docs and have not found what I was looking for. A desired example would be something similar to:

ExponentialMovingAverage weekly1 = EMA(symbol, 1, Resolution.Weekly);

(I know this doesn't compile just as an example).

Thank you for your assistance!

Update Backtest

Mike Reichard

Accepted Answer

Update Backtest

Notebook

The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by QuantConnect. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. QuantConnect makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances. All investments involve risk, including loss of principal. You should consult with an investment professional before making any investment decisions.

Alexandre Catarino

Hi Mike Reichard ,

Please check out the docs, under Indicators - Custom Period Indicators.

We need to create a Weekly Consolidator and register the EMA:

var symbol = AddEquity("SPY", Resolution.Daily).Symbol;

var consolidator = new TradeBarConsolidator(CalendarType.Weekly);

ema = new ExponentialMovingAverage(3);

RegisterIndicator(symbol, ema, consolidator);

Mike Reichard

3.1k ,

Thanks Alex. Was just reading on QC and found information on “Sequential Consolidators”. My goal is to have 5 trading day bars consolidated into 1 bar, then use the bars to calculate the 3 and 5 EMA. Here’s the process mentioned:

oneDayConsolidator = TradeBarConsolidator(TimeSpan.FromDays(1)

fiveCountConsolidator = TradeBarConsolidator(5)

five_oneDayBar = SequentialConsolidator(oneDayConsolidator, fiveCountConsolidator)

five_oneDayBar.DataConsolidated += self.FiveDayBarConsolidatedHandler

self.SubscriptionManager.AddConsolidator(self.spy, five_oneDayBar)

Let me know if this is how I get 5 trading days into 1 bar that I can then use for the EMA3 and EMA5 crossover. If this is the right approach would the ema_3 and ema_5 calculate the EMA of 3 and 5 bars as calculated above?

Appreciate your insights.

Mike

Shile Wen

63.5k ,

Hi Mike,

To use a consolidator, we use a TradeBarConsolidator object, where the parameter is the number of bars we would like to use. To register a function to a TradeBarConsolidator, so we can use our consolidated data, we do TradeBarConsolidator += MyConsolidatorFunction, where MyConsolidatorFunction is where we would like to handle the data (similar to OnData). Finally, to subscribe to our consolidator, we use a SubscriptionManager, to which we add our consolidator object. If different Resolutions are desired, the Resolution should be changed in the add security function (in this case AddEquitiy). To see this in action, check out the attached backtest.

For future reference, see our documentation on Data Consolidation.

Best,
Shile Wen

Mike Reichard INVESTOR

Update Backtest

Notebook

To unlock posting to the community forums please complete at least 30% of Boot Camp.
You can continue your Boot Camp training progress from the terminal. We hope to see you in the community soon!

Platform

QuantConnect Community

Alpha League Competition: $1,000 Weekly Prize Pool

Filter Discussion by Tags

Community Ambassadors

Earn free QuantConnect cloud credits by helping others, each week we airdrop credits to the most active community members.

233,188 Quants.

Online Now

Stay Connected