Combining two data sources on same chart?
- furytrader
- Posts: 354
- Joined: 30 Jul 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Combining two data sources on same chart?
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: 7740
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2221 times
Re: Combining two data sources on same chart?
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: 30 Jul 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Re: Combining two data sources on same chart?
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: 7740
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2221 times
Re: Combining two data sources on same chart?
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: 30 Jul 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Re: Combining two data sources on same chart?
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: 7740
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2221 times
Re: Combining two data sources on same chart?
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: 30 Jul 2010
- Location: Chicago, IL
- Has thanked: 155 times
- Been thanked: 217 times
Re: Combining two data sources on same chart?
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: 7740
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2221 times
Re: Combining two data sources on same chart?
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!