Page 1 of 1

Data from Excel to TB

Posted: Thu Jun 16, 2011 5:36 pm
by mannick
I have price data from a non exchange traded market which I would like to back test in TB.

Does anyone know if there is a way to convert data from an excel sheet into the format needed to create instruments in TB?

Any guide would be much appreciated.

M

Posted: Thu Jun 16, 2011 5:52 pm
by cryder
Have a look for LoadExternalData, LoadSymbol, LoadIPVFromFile functions in the Builder Users guide.

Posted: Thu Jun 16, 2011 7:01 pm
by rgd
if it has dates, and a price series, be sure to copy the price series into 4 columns representing open,high,low,close and save it as a .csv file in the appropriate folder.

Posted: Fri Jun 17, 2011 6:44 am
by mannick
Thanks very much for the inputs, will have a look in to that!

intra day data - minute data

Posted: Wed Jun 22, 2011 7:41 am
by ES
Can TB handle data for minute time frames such as 4 minute or 15 minute time lines? Next, can TB also handle simultaneous long short positions?

Posted: Wed Jun 22, 2011 9:49 am
by sluggo
Answers to questions about what Trading Blox can and cannot do, may be found here: http://www.tradingblox.com/Manuals/Trad ... 0Guide.pdf

You might also enjoy reading the posts on this forum written by member "babyturtle" .

Posted: Wed Jun 22, 2011 2:01 pm
by Tim Arnold
Yes TB can handle multiple intraday timeframes. Each system can only be long or short a market, but multiple systems can be tested at the same time so a market can be long and short at the same time.

feedback

Posted: Wed Jun 22, 2011 11:17 pm
by ES
Thanks Tim and yes Sluggo we're finally taking the plunge.