Discussions
»
Product and Service Development
»
MetaStock
»
how to create continuous futures contract from local data files
Rank: Member
Groups: Registered, Registered Users, Subscribers Joined: 12/3/2007(UTC) Posts: 18 Location: Singapore
|
Dear All,
Is it possible to create continuous futures contract from local data files. In summary this is what I would like to accomplish
a) have individual futures contract files say
AI - expiry May 28 2012
AII - expiry Jun 28 2012
AIII - expiry Jul 28 2012,
b) I would to create a new chart 'Ac1' and data gets populated from individual contract files in the manner
till May 28, OHLC from AI
from May 29 to Jun 28, OHLC from AII
from Jun 29 to Jul 28, OHLC from AIII.
Any ideas / leads on how to do this are most welcome.
Many thanks for the help and support
Regards,
SNVK
|
|
|
|
Rank: Advanced Member
Groups: Moderators, Registered, Registered Users, Subscribers Joined: 10/8/2010(UTC) Posts: 1,960
Thanks: 92 times Was thanked: 155 time(s) in 150 post(s)
|
I'm sorry but the downloader does not have any features to automatically create the file you are asking for. You can manually copy and paste the data. otherwise you would likely have to take all the data to Excel and then import it back after the file is created.
|
|
|
|
Rank: Advanced Member
Groups: Registered, Registered Users, Subscribers Joined: 4/5/2006(UTC) Posts: 129 Location: Norgate Data
|
As a commercial solution, our futures data continuous contract generation tool allows you to specify this type of behaviour... For example, if we wanted to roll Crude Oil on the 14th of each month:
If we wanted more granular control of each individual roll, then we can do it contract-by-contract too:
Further product details of the data service are here: Norgate Futures Data Service. The continuous contract tool is provided with the data. A free trial is available.
|
|
|
|
|
Users browsing this topic |
Guest (Hidden)
|
Discussions
»
Product and Service Development
»
MetaStock
»
how to create continuous futures contract from local data files
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.