Data conversion from CMS Visual Trader to Metastock

awoodj

Active member
142 0
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.
 

Attachments

  • test data.xls
    42.5 KB · Views: 607

ilia king

Well-known member
327 0
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
 

Attachments

  • awoodj.bmp
    683.1 KB · Views: 492

awoodj

Active member
142 0
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

Well-known member
327 0
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

Junior member
27 1
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)
 
Last edited:

ilia king

Well-known member
327 0
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

Junior member
27 1
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

Junior member
27 1
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
 

1kyle

Junior member
27 1
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.
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock