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)




"This beats the pants off CQG, I am definitely switching to the ProphetX 3.0!" - Comment from Stephen
"Thanks for following up with me. You guys do a great job in tech support." - Comment from Phelps
"Its working FABULOUSLY for me!! Holy cow...there has been so much I've been missing lately, and with this feed and Linnsoft software...I'm in the game now." - Comment from Chris R.
"IQFeed version 4 is a real screamer compared to anything else I have seen." - Comment from Tom
"I ran your IQFeed DDE vs. my broker vs. a level II window for some slow-moving options. I would see the level II quote change, then your feed update instantaneously. My broker's DDE, however, would take as much as 30 seconds to update. I am not chasing milliseconds, but half a minute is unacceptable." - Comment from Rob
"Version 4.0.0.2 has been working well for me and I appreciate that it is now a much tighter client to work with. I feel I can go to press with my own application and rely on a stable platform" - Comment from David in IA.
"Can I get another account from you? I am tired of ******* going down so often" - Comment from George
"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
"If you are serious about your trading I would not rely on IB data for serious daytrading. Took me a while to justify the cost of IQ Feed and in the end, it's just a 2 point stop on ES. Better safe than sorry" - Comment from Public Forum
"Everything is working great with the API. I love it." - Comment from Calvin
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: Mon October 22, 2018 12:11 AM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003