Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Importing own time series into Blocks Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
blocksworks
Posted : Thursday, August 30, 2007 2:05:54 PM
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.
Bruce_L
Posted : Friday, August 31, 2007 8:12:02 AM


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
blocksworks
Posted : Friday, August 31, 2007 4:00:06 PM
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.
blocksworks
Posted : Thursday, September 6, 2007 8:35:38 PM
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.
Bruce_L
Posted : Friday, September 7, 2007 8:18:07 AM


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
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.