Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 8/14/2007 Posts: 34
|
I know one can create our own watchlist in two ways: copy/paste from Excel, for instance, or via csv file format (which I have not yet figured out how).
Is it possible to import my own time series? For instance, I want to backtest the S&P 500 against the VIX index or the put/call ratio whose data are not available in Blocks. But I can get the latter historical data (e.g. date & number) from an outside source. Is there a way to bring that into blocks?
Thanks in advance.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
There are three Blocks designed for this purpose. These Blocks are CSV To Bar, CSV To Line and CSV To Line With Key. The Import Custom Data with .CSV Reader Blocks Video provides some information on their use. That said, these Blocks no longer seem to work exactly as described in the video and I do not have any additional information on their use or when they (or the video or documentation) might be updated.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 8/14/2007 Posts: 34
|
I watched the video you specified and tried to recreate what Ken showed in the video. My plot did not show anything. I tried the CSV to Bar and CSV to Line without luck. I wonder it was because I did not follow instructions correctly or that this block no longer works like you said. If the latter is the case, could you please find out if someone will update this. Last weekend I attended the NYC La Guardia session and was told that this feature works. Thanks.
|
|
Registered User Joined: 8/14/2007 Posts: 34
|
I just want to re-post my question again in case the trainers or any software engineer forgot to reply to my question.
When I followed the video's instructions and applied the CSV To Bar, I could not get imported data to display on the charts. Bruce_L mentioned that these BLocks might be outdated. Any chance we'll get to use the updated version or a working version (to import outside data)?
Thanks again.
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
As stated in my original response, these Blocks no longer seem to work exactly as described in the video and I do not have any additional information on their use or when they (or the video or documentation) might be updated.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |