Why is there value on 9 March 2019 when I am using rollingwindows to capture the historical price?
Don't have an account? Join QuantConnect Today
QuantConnect Community Discussions
QUANTCONNECT COMMUNITY
LEAN is the open-source algorithmic trading engine powering QuantConnect. Founded in 2012 LEAN has been built by a global community of 180+ engineers and powers more than 300+ hedge funds today.
Join QuantConnect's Discord server for real-time support, where a vibrant community of traders and developers awaits to help you with any of your QuantConnect needs.
The Open-Quant League is a quarterly competition between universities and investment clubs for the best-performing strategy. The previous quarter's code is open-sourced, and competitors must adapt to survive.
Inquiring about value on 9 Mar 2019 when using rolling windows to track historical price in QuantConnect.
Continue ReadingRefer to our Research Guidelines for high quality research posts.
Create an account on QuantConnect for the latest community delivered to your inbox.
Sign Up Today
|
|
|||||||
|
|
||||||||
|
Rolling windows historical price
Zc Yong | April 2019
Why is there value on 9 March 2019 when I am using rollingwindows to capture the historical price?
QuantConnectâ„¢ 2025. All Rights Reserved
Zc Yong
Hi, anyone can help?
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.
Zc Yong
9 March 2019 is Saturday
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.
Jack Simonson
Hi,
Since the Rolling Window and Indicators are being updated each day with new data, then there will be data for each day the market is open. With daily resolution data, the timestamp is at 00:00 UTC the next day, so this is why there is data for March 9, 2018, even though it was a Saturday -- it's just the timestamp for the data slice containing the Close price of the 8th.
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.
Zc Yong
Thanks Jack. However, the Saturday issue is only applicable to the Saturday on March 9, 2018 but not the other Saturday. Why is there such inconsistency? Not sure if I understand your explaination correctly, maybe you can elaborate more. Thanks.
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.
Link Liang
Hi Zc,
Our timestamp is 00:00 for all daily resolution data. A data entry with timestamp 2019-03-09 00:00:00 in daily resolution indicates that the timeframe for this data entry is from 2019-03-08 00:00:00 to 2019-03-09 00:00:00, which is Friday.
From the log in your backtest, I see there is data on all Saturday Timestamps, for example, at 2019-03-16 00:00:00 and 2019-03-02 00:00:00. Could you please elaborate more on how to reproduce your inconsistency Saturday issue?
You could find more information regarding time here.
Reminder: logging price is against our terms of service. Please avoid that in the future. Thanks for your support!
Hope it helps!
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.
Zc Yong
Thanks Link Liang for your reply. Do you mind to elaborate more about logging price that you mentioned above? Not sure if you are referring to the plotting of the price, sincerely apologise if I have violated any TOS but my main purpose of price plotting is to investigate the data calculation inconsistency against my raw spreadsheet calculation. Will definitely avoid that in the future.
Back to the issue above, I am actually referring to the 'trade plot' graph in the backtesting results as that is the result of the 'rolling windows' calculation from the raw data. There is no value on the graph on other Saturday like 2019-03-30, 2019-03-23, 2019-03-16 but 2019-03-09. Hope that clarifies.
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.
Link Liang
Hi Zc,
After running a backtest, there should be a message in console “Your log was successfully created and can be retrieved from: {url}“. Click on that url and logs from your algorithm should be there. If the timestamps in the log are consistant, then there is no problem with data.
Hope it helps!
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.
Zc Yong
Noted that I should refer to the logs rather than the chart created. Thanks Link Liang
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.
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!