Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
using history() - cant pass barcount a variable?

I am using a batch transform to use a rolling memory of price histories, but I want to access all the price data since the first daily tick at a specific point for comparison. I have been trying to use a context based variable to count the ticks, with the intention of passing this number as the bar count each run, but it wont let me, as it says the value must be an int (i've tried int(context.daycounter) too).

context.daycounter += 1  
  all_prices = get_past_prices(data)  
  historical_prices = history(bar_count=context.daycounter, frequency='1d', field='price')  

is there any way to achieve this?

3 responses

You're right that bar_count has to be a static number and cannot be passed in a variable. One possible workaround is to know the number of bars in your backtest, set the bar_count equal to this number, and then index into the dataframe to select the appropriate data.

Also, I'm not sure of the details of your code, but I'd suggest to use rolling transformations with history(). It increases the backtest performance rate. Hope that helps!

Disclaimer

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 Quantopian. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian 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.

Hi Chris,

From what you describe I think you are just looking to accumulate prices inside your algorithm from the start of the backtest forward. If that's the case you could so something like the example below.

I've kept this simplest case, but you can extend this logic to work with a universe of many stocks (just need to loop over each stock and add a second index to the defaultdic), you can also set the maximum number of data points you want to accumulate by passing a maxlen parameter to the deque. You can read more about the collections module to see other examples.

from collections import defaultdict, deque  
import numpy as np

def initialize(context):  
    context.stock = sid(24)  
    context.prices  = defaultdict(deque)

# Will be called on every trade event for the securities you specify.  
def handle_data(context, data):  

    price = data[context.stock].price  
    context.prices[context.stock].append(price)  
    stock_series = np.array(context.prices[context.stock])  
    record(number_of_points_stored = len(stock_series))  

Note: to pass the maxlen parameter you need to use a partially applied function which requires importing from functools as follows:

from functools import partial  

and then replacing the initialization of the prices deque as follows to limit to 20 data points for example:
context.prices = defaultdict(partial(deque, maxlen=20))

Disclaimer

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 Quantopian. In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian 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.

Excellent, Thanks Jessica!