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.