Join the 80,000 other DTN customers who enjoy the fastest, most reliable data available. There is no better value than DTN!

(Move your cursor to this area to pause scrolling)




"I used to have *******, but they are way more money for the same thing. I have had no probs with data from DTN since switching over." - Comment from Public Forum Post
"DTN has never given me problems. It is incredibly stable. In fact I've occasionally lost the data feed from Interactive Brokers, but still been able to trade because I'm getting good data from DTN." - Comment from Leighton
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"If you want customer service that answers the phone, your best bet is IQFeed. I cannot stop praising them or their technical support. They are always there for you, and they are quick. I have used ****** too but the best value is IQFeed." - Comment from Public Forum
"DTN feed was the only feed that consistently matched Bloomberg feed for BID/ASK data verification work these past years......DTN feed is a must for my supply & demand based trading using Cumulative Delta" - Comment from Public Forum Post
"I have to tell you though that using the IQFeed API is about the easiest and cleanest I have seen for some time." - Comment from Jim
"I am a hedge fund manager here. It’s funny, I have a Bloomberg terminal and a Bridge feed, but I still like having my DTN feed!" - Comment from Feras
"I've been using Neoticker RT with IQFeed for two months, and I'm very happy with both of the products (I've had IQFeed for two years with very few complaints). The service from both companies is exceptional." - Comment from Public Forum
"Everything is working great ! Very impressive client. The news refreshes better and is more pertinent than the ******* feed I paid $ 100/month for. I Also like the charts a lot." - Comment from Leon
Home  Search  Register  Login  Blogs Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTN_IQFeed on Twitter
DTN.IQ/IQFeed on Twitter
DTN News and Analysis on Twitter
»Forums Index »Product Support »ProphetX Support »NatGas Options and Excel
Author Topic: NatGas Options and Excel (2 messages, Page 1 of 1)

nikolasp
-Interested User-
Posts: 4
Joined: Mar 31, 2006


Posted: Sep 15, 2006 08:46 AM          Msg. 1 of 2
Has anyone had any success with creating a volatility surface for NYMEX natural gas options in Excel by linking the options quotes from ProphetX?

I have set up a spreadsheet with links to the ATM gas options contracts. The spreadsheet has the current premium, previous premium and the ATM volatility for a number of contracts. The problem is that the ATM options change every day which makes it difficult to manually update them all at the end of the day. With Bloomberg and Excel one is able to create a "dynamic" ATM contract using concatenation, etc. Is there a way to do that with ProphetX?

Thanks!

margep
-DTN Evangelist-
Posts: 119
Joined: Sep 13, 2005


Posted: Sep 15, 2006 09:50 AM          Msg. 2 of 2
Hello,
Other users may have been able to manipulate their spreadsheets with this information but we do not have currently have a spreadsheet available to do this. But you may still hear from other users who are willing to share their techniques with you....

We are, however, in the process of upgrading our options module to include various charting capabilities based on the volatility and directly from the options module, as well as linking directly from options. This should, in some cases, eliminate the need to do a lot of the current linking you're doing from the quote sheets. The plan is for implementation in version 3.4, scheduled for year end - hopefully sooner.
Regards,
Marge
 

 

Time: Wed December 12, 2018 3:16 AM CFBB v1.2.0 15 ms.
© AderSoftware 2002-2003