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 just wanted to let you know how fast and easy I found it to integrate IQFeed into our existing Java code using your JNI client. In my experience, such things almost never go so smoothly - great job!" - Comment from Nate
"You are either overstaffed or people just don't have problems with your feed because customer support always answers the phone quickly." - Comment from Jay via Email
"As a past ******* customer(and not a happy one), IQ Feed by DTN is a much better and cheaper product with great customer support. I have had no problems at all since switching over." - Comment from Public Forum
"After all the anxiety I had with my previous data provider it is a relief not to have to worry about data speed and integrity." - Comment from Eamonn
"I just wanted to say how happy I am with your service. I was able to download the API docs last week and I was able to replicate Interactive Brokers historical bar queries and realtime bar queries over the weekend. That was about one of the fastest integrations that I've ever done and it works perfectly!!!!" - Comment from Jason via Email
"I am enjoying the feed very much - so superior to the broker provided feed I was previously using." - Comment from George
"Awesome response, as usual. It is a sincere and refreshing pleasure to do business with DTN, compared to your competition." - Comment from Ryan
"You are much better than lawyers or the phone company because you answer the phone when I call! I just love your customer service." - Comment from Isreal
"I like you guys better than *******...much more stable and a whole lot fewer issues." - Comment from Philip
"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.
Home  Search  Register  Login  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 July 16, 2019 11:06 AM CFBB v1.2.0 31 ms.
© AderSoftware 2002-2003