Merge historical data plus new real-time data [SOLVED]
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Merge historical data plus new real-time data
I have some data to be imported into Multicharts. When I import data into Multicharts (MC), I have to give it an instrument name. But then I want to merge new real-time data with this old data to form the overall continuous contract. For example, I want to use 6 years of TF continuous contract data up to Sep. 2013. Then I want to use the current Dec. TF contract from there. How can I do that?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: Merge historical data plus new real-time data
Hello tradetree,
You can add the current instrument for your data provider, import historical data into it. When the contract rolls over to the next month - just rename your instrument to match the front month contract.
If you want to have a customizable custom futures instrument in MultiCharts - you need to add individual futures contracts, then import data into each contract.
You can add the current instrument for your data provider, import historical data into it. When the contract rolls over to the next month - just rename your instrument to match the front month contract.
If you want to have a customizable custom futures instrument in MultiCharts - you need to add individual futures contracts, then import data into each contract.
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Merge historical data plus new real-time data
I am confused about the custom futures contract. I have created one, but my thinking was that I was creating a pail and then I'd tell it the list of source to fill the pail with. But there is no mechanism to do this. So I understand the non-custom contract path (where there is an existing brokers contract that I backfill), but not the custom contract path. Lets be specific. My broker has a TF FMH0014 I also have a csv file of data for years prior. I know how to use ASCII mapping to bring this data into a symbol. Now I want to use that data plus the broker TF FMH0014 as a custom futures contract. How do you do that?
Note that I know how to "create" a new custom futures, but I don't know how to add data or tell it what data to use. It appears to generate some symbol code like "!TF_108C0^HMUZ" and I can guess that it expects to see previous contracts like TF FMZ0013, but those are what I don't have. Or rather, I don't have anything prior to TF FMZ0013. So should I load my ASCII data into the TF FMZ0013 and it will be seen in the custom futures?
Note that I know how to "create" a new custom futures, but I don't know how to add data or tell it what data to use. It appears to generate some symbol code like "!TF_108C0^HMUZ" and I can guess that it expects to see previous contracts like TF FMZ0013, but those are what I don't have. Or rather, I don't have anything prior to TF FMZ0013. So should I load my ASCII data into the TF FMZ0013 and it will be seen in the custom futures?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: Merge historical data plus new real-time data [SOLVED]
Custom Futures is a symbol combined from the individual futures contracts. The data series of Custom Futures is created by rolling over the data of the individual contracts added to the QuoteManager. Individual futures contracts should be added to the database prior to creating a Custom Futures symbol. Creating a Custom Futures will not add the necessary individual futures contracts.
There is no automated way to create a custom futures series from two files only: N years of historical data + front month contract. You need to have the data in each expired historical contract.
Instead of splitting the data and importing it separately into each individual expired historical contract - you can import the complete data you have into each historical contract. Custom Futures will just load the piece of data it needs based on your settings when the chart is plotted.
There is no automated way to create a custom futures series from two files only: N years of historical data + front month contract. You need to have the data in each expired historical contract.
Instead of splitting the data and importing it separately into each individual expired historical contract - you can import the complete data you have into each historical contract. Custom Futures will just load the piece of data it needs based on your settings when the chart is plotted.
-
- Posts: 81
- Joined: 29 Apr 2013
- Location: www.threefoldmarkets.com
- Has thanked: 12 times
- Been thanked: 16 times
- Contact:
Re: Merge historical data plus new real-time data
Just for final clarity, what I did was to load my file data into the previous (expired) contract. So the custom futures worked by showing data from the current, front month, then the previous contract which also had all my data. It worked going back many years. Thanks.
Re: Merge historical data plus new real-time data
hello tradetree,
Can you please describe me how you load the historical data into the current contract?
Thanks
Can you please describe me how you load the historical data into the current contract?
Thanks
- JoshM
- Posts: 2195
- Joined: 20 May 2011
- Location: The Netherlands
- Has thanked: 1544 times
- Been thanked: 1565 times
- Contact:
Re: Merge historical data plus new real-time data
See Merging Data Sources into a Single Chart for a small guide, with in this case the historical data loaded in the History part and the current/recent data in the RealTime part of the merging data sources screen.Can you please describe me how you load the historical data into the current contract?
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2958 times
Re: Merge historical data plus new real-time data
Please see Importing Datahello tradetree,
Can you please describe me how you load the historical data into the current contract?
Thanks