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)




"There is no doubt that IQFeed is the best data provider. I am very satisfied with your services. And IQFeed is the only one that I would recommend to my friends. Now, most of them are using your product in China." - Comment from Zhezhe
"I am keeping IQFeed, much better reliabilty than *******. I may refer a few other people in the office to switch as well." - Comment from Don
"You have an excellent product !!!!!!" - Comment from Arely
"I started a trial a few weeks back before the market went wild. DTN.IQ didn’t miss anything and beat my other provider. I decided to stay with you because of the great service through all the volatility." - Comment from Mike
"I've never had DTN go out on me since switching. ******* would go down a couple times every month when I was using them." - Comment from Bryce in AL.
"And by the way, have to say this. I love the IQFeed software. It's rock solid and it has a really nice API." - Comment from Thomas via RT Chat
"My broker in Davenport suggested I give you a try as he uses your service and says its the best." - Comment from Bill via RT Chat
"If someone needs the best quality data and backfill beyond what their broker provides at a rate that is the best in the industry, I highly recommend IQFeed." - Comment from Josh via Public Forum
"I'm very glad I switched to IQFeed. It's working perfectly with no lag, even during fast market conditions." - Comment from Andy via Email
"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
Home  Search  Register  Login  Blogs Recent Posts

Information on DTN's Industries:
DTN Oil & Gas | DTN Trading | DTN Agriculture | DTN Weather
Follow DTNMarkets 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: Tue April 23, 2019 6:51 PM CFBB v1.2.0 16 ms.
© AderSoftware 2002-2003