Hello,
I have searched the community but couldn't find an example for a multiple time frame algos, I am also struggling with the resample method,
I want to have 15 minutes data and 1 hour data besides my 1 minute data. if any one got an example I'd be very thankful.
Hi Adham,
If I'm understanding you correctly, I think this algorithm that calls a function my_func every 30 minutes using schedule_function in a for loop should help you!
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 Jamie,
What I mean is an algo that uses different time frames simultaneously, using the so called resample method, I have faced only inconsistency with this method so far, for example I cloned your example and added the resample method but the output is inconsistent (length of Series) which cause me IndexError: index out of bounds when I use it with my trading logic :-
Output:-
2015-09-04PRINT17
2015-09-04PRINT17
2015-09-04PRINT17
2015-09-04PRINT17
2015-09-04PRINT17
2015-09-04PRINT17
2015-09-04PRINT16
2015-09-08PRINT17
2015-09-08PRINT17
2015-09-08PRINT17
2015-09-08PRINT17
2015-09-08PRINT17
2015-09-08PRINT17
2015-09-08PRINT16
2015-09-09PRINT18
2015-09-09PRINT18
2015-09-09PRINT18
2015-09-09PRINT18
2015-09-09PRINT18
2015-09-09PRINT18
2015-09-09PRINT16
2015-09-10PRINT17
2015-09-10PRINT17
2015-09-10PRINT17
2015-09-10PRINT17
2015-09-10PRINT17
2015-09-10PRINT17
2015-09-10PRINT16
2015-09-11PRINT17
2015-09-11PRINT17
2015-09-11PRINT17
2015-09-11PRINT17
2015-09-11PRINT17
2015-09-11PRINT17
2015-09-11PRINT16
2015-09-14PRINT17
2015-09-14PRINT17
2015-09-14PRINT17
2015-09-14PRINT17
2015-09-14PRINT17
2015-09-14PRINT17
2015-09-14PRINT16
2015-09-15PRINT18
2015-09-15PRINT18
2015-09-15PRINT18
2015-09-15PRINT18
2015-09-15PRINT18
2015-09-15PRINT18
2015-09-15PRINT16
2015-09-16PRINT17
2015-09-16PRINT17
2015-09-16PRINT17
2015-09-16PRINT17
2015-09-16PRINT17
2015-09-16PRINT17
2015-09-16PRINT16
2015-09-17PRINT17
2015-09-17PRINT17
2015-09-17PRINT17
2015-09-17PRINT17
2015-09-17PRINT17
2015-09-17PRINT17
2015-09-17PRINT16
2015-09-18PRINT17
2015-09-18PRINT17
2015-09-18PRINT17
2015-09-18PRINT17
2015-09-18PRINT17
2015-09-18PRINT17
2015-09-18PRINT16
2015-09-21PRINT17
2015-09-21PRINT17
2015-09-21PRINT17
2015-09-21PRINT17
2015-09-21PRINT17
2015-09-21PRINT17
2015-09-21PRINT16
2015-09-22PRINT18
2015-09-22PRINT18
2015-09-22PRINT18
2015-09-22PRINT18
2015-09-22PRINT18
2015-09-22PRINT18
2015-09-22PRINT16
2015-09-23PRINT17
2015-09-23PRINT17
2015-09-23PRINT17
2015-09-23PRINT17
2015-09-23PRINT17
2015-09-23PRINT17
2015-09-23PRINT16
2015-09-24PRINT17
2015-09-24PRINT17
2015-09-24PRINT17
2015-09-24PRINT17
2015-09-24PRINT17
2015-09-24PRINT17
2015-09-24PRINT16
End of logs.
I'm not sure I follow. Do you think you could elaborate on what you mean by using different time frames simultaneously? Also, could you explain to me what you are trying to do with the .resample() method? This might help me understand!
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.
If you mean you would like to execute a function once every 15 minutes, another function once every 30 minutes, and another once every hour, you can make 3 schedule function calls, each in its own for loop like my first example!
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.
I mean I want to have access to different frequency time frames besides 1 minute, like the 30 minutes timeframe period and the 1 hour timeframe..
as if you are passing 30min /1 hour into history function :-
history(15,'30m','close_price')
history(15,'1h','close_price')
I want to have access to different time frames
You might be able to find your answer here: https://www.quantopian.com/posts/testing-accuracy-of-resample-1w-for-weekly-history-dataframe
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.
I knew this link and several other, but unfortunately I haven't find my answer there, I hope someone from Quantopian can elaborate on this matter
Hi Adham,
The reason you are getting inconsistent length Series lengths is simply a result of the time frame you chose and the way the .resample() method works. Since 50 minutes does not easily divide the 390 minute trading day, and since you are looking back in history longer than the current day, where each .resample() 'window' starts will change based on which minute bar calls the history function. For example, you might have a window start at 4:00pm (market close) and then another start at 9:30am (market open) because the .resample method does not recognize the gap when the markets are closed.
If you either restrict your history lookback to just the current day, or you choose a number that is divisible by the 390 minute trading day, you shouldn't run into the inconsistent size problem you are having.
Here is a functional 30-minute resolution example of the algorithm you posted.
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 Jamie for pointing this out, I recognize this while playing yesterday with different numbers, although I am still having some weird behavior which I couldn't replicate
KeyError: Timestamp ......
which I went over it with a try except block, it may be due to the other point you mentioned that resample doesn't recognize the ** gap when the markets are closed** or maybe it is something else.
Thank you again for your dedication to solve the problem, I do appreciate it
Same issue: I would like to get a custom timeframe of data. Just taking the last 180 bars from 1m charts and calling it 12 bars of 15m charts does not represent how we chart the data in contemporary charting systems. Typical systems align the bars to the start of the day or start of the month or week or... actually I don't even really know. But telling me to take the previous bars and simply transposing the last 15 and calling it a 15 minute bar does not sit well.
Maybe I am confused but it seems like I should be able to enter '15m', '30m', '1h', '2h', '1w', '1M', '1y', etc. into the history function to get the data I am trying to curate.
Because of this thread and my anticipation of the need for the 15m and 1h charts, I made this algo. Of course, if this is already made or integrated, please let me know so I can use the proper implementation.
Known buggies/issues:
- Assumes start of day is at 13:30 and therefore may not account for daylight savings time. This needs further development.
- Need to evaluate each timeframe to ensure that is defined as expected: for example, the minute and hourly is based on the start of day which is 31 minutes into the hour. A 15m chart would have its first period from 9:31 to 9:45, second period from 9:46 to 10:00, etc.
- Also, I don't think 7, 31, and 365 are the proper constants for week month and year, but I will leave these as is for now.
- Only tested using a single symbol. I would not suggest trying on a series of symbols. Probably the simple solution is to just iterate over the multiple symbols. That is how I would implement the functionality.
- Probably not optimized, especially if you are trying to take multiple timeframes on the same symbol. There is likely much optimization that could be accomplished in the future and more so out of our control here.
- I am kinda burned on this project, so I am probably missing stuff, take it as it is, let me/us know how to make it better.
Check the source of Historic Custom Timeframe and take all the code from def historic_custom_timeframe and below. You will also need the first line of code to import pandas as pd
You will be able to get your data as exemplified in the top portion of the code like this:
hourly_chart_100_bars = historic_custom_timeframe(data,sid(24),'1h',100)
fifteenMinute_chart_30_bars = historic_custom_timeframe(data,sid(24),'15m',30)
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.
