I have data from other providers, but I'd like to import data from my broker, MB Trading. They supply the last few years back on their site.
Attached is a sample of what they give us. It will not work for me with MC. Any explanations?
They provide it in a .csv file and I'm unable to upload that onto here so I changed it to a .txt file which shouldn't change anything about the importing process.
Importing MB tick data
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: Importing MB tick data
Hello MAtricks,
Date and time should be comma separated. Milliseconds timestamp is not currently supported, time values should be without it.
The data should be like that:
Date and time should be comma separated. Milliseconds timestamp is not currently supported, time values should be without it.
The data should be like that:
More info on invalid ASCII files here: Importing ASCII dataAUD/CAD,2012-10-18, 17:02:16,1.0207,1.02133
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: Importing MB tick data
MS Excel can do this job for you automatically with just a couple of clicks.
Re: Importing MB tick data
Hello MatricksI was unaware of this feature. While I know this isn't your obligation to help me with Excel, could you give me a quick description of how to do this?
Much appreciated!
Best site for Excel question is MrExcel forum ( google it)
Can't beat the price it cost for the information.... free
Subscribe as a member in the forum, formulate your question as clear as you can. You will be answer shortly
Good luck
Martin