I was wondering how to find the historical symbol for equities that are delisted now but were active for a historical testing period.
For example, testing DELL in the year 2000 I receive an error message that says that the first trading date for DELL is 2018, the year it was re-listed more recently. How can I find or enter the symbol for when it was trading under that name in 2000? Thank you.
Louis Szeto
Hi Prescott
To use the older Symbol, we can call the following Symbol object:
In this case, it is considered as 2 different equities for re-listing, by 2 different IPOs. Thus, they are not the same and cannot be fetched using the same Symbol object.
Best
Louis Szeto
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.
Prescott Henning
Thank you, that solution works if the symbol I enter still trades now, for example Dell is currently trading under DELL but went private and relisted as a new company, as you mentioned. So DELL.1 is an easy fix. But that does not address the more common problem of mergers and bankruptcies.
For example AOL traded under that symbol in 2000 but what works now on Quantconnect is not AOL or AOL.1 but TWX.1. The reason is because Time Warner acquired AOL. If I search for AOL on the Data explorer on Quantconnect it has the data but does not tell me which symbol to use to actually implement the data on an algo.
Is there somewhere I can map old symbols to what they are able to be accessed under in Quantconnect? For instance how would I find what AOL is testable under without having known about the Time Warner acquisition? Thanks
Alexandre Catarino
Hi Prescott Henning ,
QuantConnect has the mapping information. However, it's not accessible via Data Explorer. It's an interesting feature that we will implement as soon as possible. We have recently added support for getting a Lean symbol based on FIGI, CUSIP, ISIN, SEDOL #5922 that might also help in this case, but it still requires some research from the quant.
Regardless, if we want to get the Symbol for a given ticker and date/time, we can use the following approach:
Prescott Henning
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!