Combining two data sources on same chart?
- furytrader
- Posts: 354
- Joined: Jul 30 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
I have some 1 minute bar data for a commodity that goes back several years. The data is so large, in fact, that it had to be broken up into 2 data files to send it via email. Is there an easy way in MultiCharts to "paste" those two files together so that they are 1 continuous chart on the screen?
- TJ
- Posts: 7774
- Joined: Aug 29 2006
- Location: Global Citizen
- Has thanked: 1036 times
- Been thanked: 2233 times
are they ascii files?I have some 1 minute bar data for a commodity that goes back several years. The data is so large, in fact, that it had to be broken up into 2 data files to send it via email. Is there an easy way in MultiCharts to "paste" those two files together so that they are 1 continuous chart on the screen?
if you import them through QM, they are automatically appended in the database.
- furytrader
- Posts: 354
- Joined: Jul 30 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Yes, they are ASCII files. How will the QM "know" that they should be appended? Do I have to designate something when I "map to ascii" or do I do an "import" instead?
As you can tell, I am new to this.
thanks!
As you can tell, I am new to this.
thanks!
- TJ
- Posts: 7774
- Joined: Aug 29 2006
- Location: Global Citizen
- Has thanked: 1036 times
- Been thanked: 2233 times
QM arranges the data by time stamp.Yes, they are ASCII files. How will the QM "know" that they should be appended? Do I have to designate something when I "map to ascii" or do I do an "import" instead?
As you can tell, I am new to this.
thanks!
or,
you can merge the files before import.
- furytrader
- Posts: 354
- Joined: Jul 30 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
I guess my question is how does QM know that the two files are related?
thanks for your help.
thanks for your help.
- TJ
- Posts: 7774
- Joined: Aug 29 2006
- Location: Global Citizen
- Has thanked: 1036 times
- Been thanked: 2233 times
If you are importing the data into the same symbol, all the data will be associated with that symbol, and all the data will be arranged by the time stamp.I guess my question is how does QM know that the two files are related?
thanks for your help.
any duplicate time stamps will be overwritten by the latest import.
ps.
if you are concerned with data contamination,
you can set up a dummy symbol and test out the import process with that symbol first.
- furytrader
- Posts: 354
- Joined: Jul 30 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Thanks for your help - I ended up creating a unique symbol just for this ASCII data and it looks like the Quote Manager assembled everything cleanly as you described.
One more reason why MultiCharts is very cool - thanks!
One more reason why MultiCharts is very cool - thanks!
- TJ
- Posts: 7774
- Joined: Aug 29 2006
- Location: Global Citizen
- Has thanked: 1036 times
- Been thanked: 2233 times
you are welcomeThanks for your help - I ended up creating a unique symbol just for this ASCII data and it looks like the Quote Manager assembled everything cleanly as you described.
One more reason why MultiCharts is very cool - thanks!