Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Need help selecting prices on an arbitrary day

Greetings Quantopians,

I'm new to this, still learning the API+python, and need help selecting the properties of a security (price for example) on an arbitrary day, hour or minute.

There are several posts about using external data sources to feed into our algorithms which have motivated me to start thinking about how to relate news and events to specific securities on specific days. Since these dates and times will vary from security to security there will probably need to be some code/function/subroutine that retrieves the properties of those securities on any given date from the Back-testing data. For example, During live trading, some news is reported relevant to a security in my portfolio. It would be useful to be able to compare how prices moved on days in the past when similar news were reported about the security.

The first solution I have come with up so far:
- Set the starting date of the algorithm to the chosen date.
- Retrieve the value
- Store the value externally, import the external value on a separate algorithm

This doesn't work too well, because it would be ideal to reference the properties of the security from within handle_data() and would probably not work during live trading. The second solution I've come up with is:
- Set @batch_transform(window_length=n), where n falls on the arbitrary date.
- Drop the values that the @batch_transform() function returns, except for the day or days chosen.

This seems computationally inefficient, but it does allow for sampling the days around the arbitrary date which could turn out to be important. However, both of these solutions seem like the wrong way to go about doing this.

2 responses

Hi Aponte,

Maybe this is oversimplifying, but could you feed the news events through the algorithm via fetcher, and when your algorithm receives a news event for a security, you could store the open/close price in context for use later in the same simulation?

thanks,
fawce

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.

Thanks Fawce,

I do not think you are oversimplifying it, perhaps my post was premature. Once the code is ready to handle external event sources (Delayed mostly by my learning curve) I will definitely look at fetcher more closely.