Data conversion from CMS Visual Trader to Metastock

[awoodj]

Hi all

I am trying to convert the output of CMS's visual trader software. (Spot currency dealing software) into Metastock format for backtesting etc.

They allow export to the clipboard by selecting an area of chart so data can be in daily, weekly or intraday format. I have attached an examlpe of what you get if you paste a selection of 15 minute data into Excel and am looking to see if anyone can tell me how to get a security setup in the downloader that i can paste the data directly into or how to do it via Excel as an intermediate step.

Thanks for any help you can give.

 

[ilia king]

Hi awoodj sorry if this is too late but, but when you open metastock and then open The Downloader, open the tools menu and then click on convert, select xls (as this is the excel format), you can also download data in ascii format, then choose your destination and choose convert. Then open the converted data in Metstock

HTH, you might've allready worked it out by now

Cheers Ilia

 

[awoodj]

Did that work?

Hi there

Thanks for the reply, i think i tried something along those lines at the time but as all the fields did not match (or exist in some cases) the results in Metastock were pretty useless.

Not had another chance to play with i so no further forward yet.

Did yours come in in a usable way?

Thanks

Al

 

[ilia king]

Awoodj I have not tested it yet but think that the field names are not suitable for metastock, so it will not work. Is there another export function, I think that if you export it in ascii then open it in excel there is a small wizard that will change the fields to those required by metastock.

Will try something tommorrow or today

Cheers

Ilia

 

[1kyle]

Easy way to do it

1) Save your EXCEL file as a CSV file
2) split date and time into separate cells / resave
3) Download trial C2MS (Convert to Metastock) program from http://www.trading-tools.com
4) Convert your file -- the program allows zillions of date formats and up to 15 user fields.

While the program gives you a free trial period I was so impressed I actually registered it -- it's very cheap and a useful tool to have anyway.

Otherwise try downloading metastock downloader from equis and import your excel file as an intraday format file. The downloader used to be free -- bot sure if it is anymore as I have metastock 8 and not the new version.


Good Luck

(edited --typo in the URL)

 

[ilia king]

Kyle did it work? Strange, does it convert the data fields to metastock format because I thought metastock doesn't accept those type of column names

 

[1kyle]

I'll try and update the converted file on my web server -- I've amended my previous post -- it works with the Equis metsatock downloader provided you split date and time up.

 

[1kyle]

Add a couple of fields

e.g here's one I did for RBS from NYSE on 13 Apr until today 19 apr

Add to your data the ticker / symbol
change time format as I've got it
you can ignore last two fields Vol and Opneint

Now it converts simply to metastock.


<TICKER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>
RBS-I,040413,093000,25.7,25.7,25.7,25.7,1300,0
RBS-I,040413,110000,25.6,25.6,25.6,25.6,400,0
RBS-I,040413,115000,25.7,25.7,25.7,25.7,1300,0
RBS-I,040413,120000,25.7,25.7,25.6,25.6,400,0
RBS-I,040413,122000,25.56,25.56,25.56,25.56,1000,0
RBS-I,040413,124000,25.55,25.55,25.52,25.52,1000,0
RBS-I,040413,143000,25.6,25.6,25.6,25.6,1000,0
RBS-I,040413,151000,25.53,25.53,25.53,25.53,500,0
RBS-I,040413,153000,25.6,25.6,25.6,25.6,100,0
RBS-I,040413,154000,25.54,25.54,25.54,25.54,800,0
RBS-I,040414,093000,25.55,25.55,25.55,25.55,900,0
RBS-I,040414,105000,25.54,25.54,25.54,25.54,2000,0
RBS-I,040414,110000,25.53,25.55,25.53,25.55,1900,0
RBS-I,040414,114000,25.52,25.52,25.52,25.52,300,0
RBS-I,040414,120000,25.52,25.52,25.52,25.52,900,0
RBS-I,040414,121000,25.55,25.55,25.55,25.55,800,0
RBS-I,040414,122000,25.55,25.55,25.55,25.55,1800,0
RBS-I,040414,135000,25.51,25.51,25.5,25.5,1200,0
RBS-I,040414,141000,25.54,25.54,25.54,25.54,400,0
RBS-I,040414,145000,25.5,25.5,25.5,25.5,700,0
RBS-I,040414,150000,25.54,25.55,25.54,25.55,1400,0
RBS-I,040414,151000,25.5,25.5,25.5,25.5,2000,0
RBS-I,040415,093000,25.15,25.15,25.15,25.15,6700,0
RBS-I,040415,094000,25.25,25.35,25.25,25.35,1200,0
RBS-I,040415,103000,25.26,25.26,25.25,25.25,1200,0
RBS-I,040415,112000,25.3,25.3,25.3,25.3,1100,0
RBS-I,040415,113000,25.25,25.25,25.25,25.25,2500,0
RBS-I,040415,120000,25.3,25.3,25.3,25.3,400,0
RBS-I,040415,125000,25.3,25.3,25.3,25.3,1000,0
RBS-I,040415,131000,25.26,25.26,25.26,25.26,1700,0
RBS-I,040415,132000,25.35,25.35,25.35,25.35,1100,0
RBS-I,040415,133000,25.45,25.45,25.45,25.45,1100,0
RBS-I,040415,134000,25.35,25.35,25.35,25.35,200,0
RBS-I,040415,141000,25.36,25.36,25.36,25.36,100,0
RBS-I,040415,143000,25.36,25.36,25.35,25.35,500,0
RBS-I,040415,153000,25.4,25.4,25.4,25.4,8000,0
RBS-I,040415,155000,25.4,25.48,25.4,25.48,600,0
RBS-I,040416,093000,25.29,25.29,25.29,25.29,2000,0
RBS-I,040416,103000,25.31,25.31,25.3,25.3,1700,0
RBS-I,040416,110000,25.33,25.33,25.33,25.33,100,0
RBS-I,040416,111000,25.33,25.35,25.32,25.35,1100,0
RBS-I,040416,115000,25.38,25.39,25.38,25.39,600,0
RBS-I,040416,121000,25.4,25.4,25.4,25.4,1000,0
RBS-I,040416,125000,25.4,25.4,25.4,25.4,400,0
RBS-I,040416,133000,25.4,25.4,25.4,25.4,100,0
RBS-I,040416,145000,25.5,25.5,25.5,25.5,300,0
RBS-I,040416,150000,25.5,25.59,25.5,25.59,300,0
RBS-I,040419,100000,25.55,25.55,25.55,25.55,400,0


Good luck

 

[ilia king]

Wow, thanks Kyle - learn everything new every day or for me every hour

 

[1kyle]

Here's a picture of the smart chart (metastock) of the data posted above.

File converted using Metastock's downloader program (ASCII to Metastock)

http://www.1kyle.com/metastock.jpg


Works for any intrday stuff (currencies etc) so long as the format is OK --- just "poodlefake" a valid symbol with the -I suffix to denote intraday.

Took a little while to get it right but it works fine.