I am trying to create a quote price for a strip that trades in the crude oil & natural Gas markets - which is essentially the average price of the April through October contract prices.
Simply put it is the sum of the prices (last done, not bid/ask) for the APril through october contract divided by 7 (the number of contracts) and as the April contract settles, it becomes the sum of the May through Oct contracts divided by 6 and so on. The same can be done for a calendar strip - which is Jan through Dec. I want to be able to chart it and apply studies against it.
Can some kind soul point me to an existing EFS or show me how to get started doing this? FOr starters, I would be interested in creating the composite price and do not mind adjusting the formula as a contract settles, instead of doing that portion automatically, if that helps.
Thanks very much.
Alex.
Simply put it is the sum of the prices (last done, not bid/ask) for the APril through october contract divided by 7 (the number of contracts) and as the April contract settles, it becomes the sum of the May through Oct contracts divided by 6 and so on. The same can be done for a calendar strip - which is Jan through Dec. I want to be able to chart it and apply studies against it.
Can some kind soul point me to an existing EFS or show me how to get started doing this? FOr starters, I would be interested in creating the composite price and do not mind adjusting the formula as a contract settles, instead of doing that portion automatically, if that helps.
Thanks very much.
Alex.
Comment